3. The End of the Accounting Cycle – prepare the financial statements (7pts): The adjusted trial balance for Scoops Ahoy, Inc. as of July, 2020 is given below:
Scoops Ahoy |
||
Adjusted Trial Balance |
||
As of 7/31/2020 |
||
Account: |
DEBIT: |
CREDIT: |
Cash |
$ 61,080 |
|
Accounts Receivable |
$ 59,111 |
|
Inventory |
$ 50,354 |
|
Equipment |
$ 90,240 |
|
Accumulated Depreciation - Equipment |
$ 9,024 |
|
Land |
$ 11,440 |
|
Goodwill |
$ 68,707 |
|
Accounts Payable |
$ 44,819 |
|
Wages Payable |
$ 8,420 |
|
Utilities Payable |
$ 930 |
|
Interest Payable |
$ 820 |
|
Notes Payable |
$ 95,000 |
|
Common Stock |
$ 6,530 |
|
Additional Paid-In Capital |
$ 38,648 |
|
Retained Earnings |
$ 119,399 |
|
Sales Revenue |
$ 179,817 |
|
Cost of Goods Sold (COGS) |
$ 84,524 |
|
Wages Expense |
$ 65,107 |
|
Utilities Expense |
$ 1,980 |
|
Interest Expense |
$ 820 |
|
Depreciation Expense |
$ 4,512 |
|
Rent Expense |
$ 5,044 |
|
Dividends |
$ 488 |
|
$ 503,407 |
$ 503,407 |
Using the adjusted trial balance provided above for Scoops Ahoy, prepare the following financial statements for July:
PART A (3pts): Income statement for the period ended July 31st, 2020.
PART B (4pts): Classified balance sheet as of July 31st, 2020. Assume during 2020 no additional stock was issued and $488 in dividends were declared and paid in cash.
Income Statement | ||
Sales Revenue | $ 179,817 | |
Cost of Goods Sold | $ 84,524 | |
Gross Profit | $ 95,293 | |
Operating Expenses | ||
Wages Expense | $ 65,107 | |
Utilities Expense | $ 1,980 | |
Depreciation Expense | $ 4,512 | |
Rent Expense | $ 5,044 | |
Total Operating Expenses | $ 76,643 | |
Net Operating Income | $ 18,650 | |
Interest Expense | $ 820 | |
Net Income | $ 17,830 |
Statement of Retained Earnings | |
Beginning Balance | $ 119,399 |
Add : Net Income | $ 17,830 |
$ 137,229 | |
Less : Dividend | $ 488 |
Ending Balance | $ 136,741 |
Balance Sheet | ||
Assets | ||
Current Assets | ||
Cash | $ 61,080 | |
Accounts Receivable | $ 59,111 | |
Inventory | $ 50,354 | |
Total Current Assets | $ 170,545 | |
Property, Plant and Equipment | ||
Land | $ 11,440 | |
Equipment | $ 90,240 | |
Less : Accumulated Depreciation | $ (9,024) | |
Total Property, Plant and Equipment | $ 92,656 | |
Intangible Assets | ||
Goodwill | $ 68,707 | |
Total Assets | $ 331,908 | |
Liabilities & Stockholder's Equity | ||
Current Liabilities | ||
Accounts Payable | $ 44,819 | |
Wages Payable | $ 8,420 | |
Utilities Payable | $ 930 | |
Interest Payable | $ 820 | |
Total Current Liabilities | $ 54,989 | |
Long term Liabilities | ||
Notes Payable | $ 95,000 | |
Total Liabilities | $ 149,989 | |
Stockholder's Equity | ||
Common Stock | $ 6,530 | |
Additional Paid-in Capital | $ 38,648 | |
Retained Earnings | $ 136,741 | |
Total Stockholder's Equity | $ 181,919 | |
Total Liabilities & Stockholder's Equity | $ 331,908 |
If you have any query, kindly comment with your query and please mark thumbs up.
3. The End of the Accounting Cycle – prepare the financial statements (7pts): The adjusted trial...
The End of the Accounting Cycle – prepare the financial statements: The adjusted trial balance for Scoops Ahoy, Inc. as of July, 2020 is given below: Scoops Ahoy Adjusted Trial Balance As of 7/31/2020 Account: DEBIT: CREDIT: Cash $ 61,080 Accounts Receivable $ 59,111 Inventory $ 50,354 Equipment $ 90,240 Accumulated Depreciation - Equipment $ 9,024 Land $ 11,440 Goodwill $ 68,707 Accounts Payable $ 44,819 Wages Payable $ 8,420 Utilities Payable $ 930 Interest Payable $ 820 Notes Payable...
PROBLEM NO. 4 – FINANCIAL STATEMENTS The adjusted trial balance of Perez Company appears below. Using the information from the adjusted trial balance, you are to prepare for the quarter ending March 31, 2020: 1. an income statement. 2. an owner’s equity statement. 3. a balance sheet. Perez Company Adjusted Trial Balance March 31, 2020 Debit Credit Cash......................................................................................................... $ 17,000 Accounts Receivable.................................................................................. 4,500 Supplies.................................................................................................... 1,000 Equipment................................................................................................. 18,000 Accumulated Depreciation—Equipment........................................................ $ 6,000 Accounts Payable....................................................................................... 8,000 Unearned Service Revenue......................................................................... 7,000 Salaries and Wages Payable....................................................................... 1,000 Perez, Capital............................................................................................ 18,250 Perez, Drawings......................................................................................... 3,500 Service Revenue........................................................................................ 16,400 Salaries...
Preparation of financial statements Using the Adjusted Trial Balance shown below, prepare the company’s: (a) Income Statement (b) Statement of Retained Earnings (c) Balance Sheet by completing the tables provided on the following pages. Repair Shop Adjusted Trial Balance Dec. 31, 2016 Debit Credit Cash $ 30,000 Supplies 2,000 Accounts Receivable 70,000 Equipment 30,000 Accumulated Depreciation on Equipment $ 10,000 Accounts Payable 20,000 Notes Payable 5,000 Income Taxes Payable 20,000 Capital Stock 30,000 Retained Earnings (as of Jan 1, 2016)...
Brief Exercise 3-20 Prepare a post-closing trial balance (LO3-7) The year-end adjusted trial balance of Hilltoppers Corporation included the following account balances: Cash, $3,800; Equipment, $15,800; Accounts Payable, $1,800; Common Stock, $10,000; Retained Earnings, $6,600; Dividends, $1,000; Service Revenue, $14,800; Salaries Expense, $9,800; and Utilities Expense, $2,800. Prepare the post-closing trial balance. HILLTOPPERS CORPORATION Post-Closing Trial Balance Accounts Debit Credit Cash Equipment Accounts Payable Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Utilities Expense Totals $ 0 $ 0
Catena's Marketing Company has the following adjusted trial balance at the end of the current year. Cash dividends of $600 were declared at the end of the year, and 660 additional shares of common stock ($0.10 par value per share) were issued at the end of the year for $2,640 in cash (for a total at the end of the year of 820 shares). These effects are included below: Catena's Marketing Company has the following adjusted trial balance at the...
Accounting Cycle Tutorial . Step 7: Prepare the Adjusted Trial Balance 0.00 2 Prepare the Adjusted Trial Balance Activity 2.a - Prepare the Adjusted Trial Balance Post the transactions to the ledger in chronological order and complete the Adjusted Trial Balance. Transactions Dec. issued common stock for $22,100 cash Explanation Debit Credit Balance 21.000 43100 Received cash in advance for service to Paid rent in advance Billed clients for $13.900 of work performed Received payment of 1500 in advance for...
GLS Complete worksheet, prepare financial statements, closing entries, and post-closing trial balance (L01 2.4 The adjusted trial balance columns of the worksheet for Alshwer Company are as follows. Dr. Account No. 101 112 126 130 157 ALSHWER COMPANY Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account Titles Cr. Cash 5.300 Accounts Receivable 10.800 Supplies 1,500 Prepaid Insurance 2.000 Equipment 27,000 Accumulated Depreciation Equipment 5,600 Notes Payable 15,000 Accounts Payable 6.100 Salaries and Wages Payable 2,400 Interest...
Catena's Marketing Company has the following adjusted trial balance at the end of the current year. Cash dividends of $600 were declared at the end of the year, and 570 additional shares of common stock ($0.10 par value per share) were issued at the end of the year for $2,970 in cash (for a total at the end of the year of 820 shares). These effects are included below: Catena’s Marketing Company Adjusted Trial Balance End of the Current Year...
Catena's Marketing Company has the following adjusted trial balance at the end of the current year. Cash dividends of $590 were declared at the end of the year, and 650 additional shares of common stock ($0.10 par value per share) were issued at the end of the year for $2,800 in cash (for a total at the end of the year of 820 shares). These effects are included below: Credit Catena's Marketing Company Adjusted Trial Balance End of the Current...
A partial adjusted trial balance of Swifty Company at January 31, 2020, shows the following. SWIFTY COMPANY ADJUSTED TRIAL BALANCE JANUARY 31, 2020 Debit Credit Supplies $820 Prepaid Insurance 3,120 Salaries and Wages Payable $920 Unearned Service Revenue 870 Supplies Expense 950 Insurance Expense 520 Salaries and Wages Expense 1,920 Service Revenue 2,120 Answer the following questions, assuming the year begins January 1. If the amount in Supplies Expense is the January 31 adjusting entry, and $850 of supplies was...