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 |
$ 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: Income statement for the period ended July 31st, 2020.
PART B : 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.
Part A:
| Scoops Ahoy | ||
| Income Statement | ||
| As of 7/31/2020 | ||
| Revenues | ||
| Sales revenue | $ 179,817 | |
| Expenses: | ||
| Cost of goods sold | $ 84,524 | |
| Wages Expense | $ 65,107 | |
| Utilities Expense | $ 1,980 | |
| Interest Expense | $ 820 | |
| Depreciation Expense | $ 4,512 | |
| Rent Expense | $ 5,044 | |
| Total Expenses | $ 161,987 | |
| Net income | $ 17,830 | |
| Statement of Retained earnings | |
| Retained earnings, beginning | $ 119,399 |
| Add: Net income | $ 17,830 |
| Less: Dividends | ($ 488) |
| Retained earnings, Ending | $ 136,741 |
Part B:
| Scoops Ahoy | |||||
| Classified Balance Sheet | |||||
| at December 31, 2020 | |||||
| Assets | Liabilities and Stockholders' equity | ||||
| Current Assets: | Current liabilities: | ||||
| Cash | $ 61,080 | Accounts payable | $ 44,819 | ||
| Accounts receivable | $ 59,111 | Wages payable | $ 8,420 | ||
| Inventory | $ 50,354 | Utilities payable | $ 930 | ||
| Total current assets | $ 170,545 | Interest payable | $ 820 | ||
| Property, plant and equipment: | Total current liabilities | $ 54,989 | |||
| Equipment | $ 90,240 | Long-term liabilities: | |||
| Less: Accumulated depreciation-equipment | ($ 9,024) | Notes payable | $ 95,000 | ||
| Land | $ 11,440 | Total long-term liabilities | $ 95,000 | ||
| Total property, plant and equipment | $ 92,656 | Total liabilities | $ 149,989 | ||
| Intangible assets: | Stockholders' equity: | ||||
| Goodwill | $ 68,707 | Common stock | $ 6,530 | ||
| Additional paid-in Capital | $ 38,648 | ||||
| Retained earnings | $ 136,741 | ||||
| Total stockholders' equity | $ 181,919 | ||||
| Total Assets | $ 331,908 | Total liabilities and stockholders' equity | $ 331,908 | ||
The End of the Accounting Cycle – prepare the financial statements: The adjusted trial balance for...
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...
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)...
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 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...
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
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...
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...
The following is the adjusted trial balance for Stockton Company. Stockton Company Adjusted Trial Balance December 31 Cash 6,095 Accounts Receivable 2,947 Prepaid Expenses 734 Equipment 14,809 Accumulated Depreciation 8,323 Accounts Payable 1,403 Notes Payable 4,681 Common Stock 1,000 Retained Earnings 7,339 Dividends 679 Fees Earned 7,413 Wages Expense 3,322 Rent Expense 845 Utilities Expense 412 Depreciation Expense 207 Miscellaneous Expense 109 Totals 30,159 30,159 Determine the total assets. a.$30,159 b.$16,262 c.$24,585 d.$8,339