In: Accounting
Using the adjusted trial balance below, prepare an income statement, statement of retained earnings, and a balance sheet as of December 31. Download the Excel spreadsheet located in the instructions and use it as a template for your financial statements. Once you have completed the statements, save the file and upload the completed spreadsheet for grading.
Parties Plus, Inc.
Adjusted Trial Balance
December 31
Debit | Credit | |
Cash | $1,600 | |
Accounts receivable | 4,000 | |
Office equipment | 16,800 | |
Accumulated depreciation | $1,600 | |
Income tax payable | 2,800 | |
Capital stock | 5,000 | |
Retained earnings | 7,420 | |
Dividends | 500 | |
Service fees earned | 21,920 | |
Wages expense | 10,500 | |
Supplies expense | 1,120 | |
Depreciation expense | 960 | |
Income tax expense | 2,800 | |
$38,740 | $38,740 |
1.) | Income Statement | |||
For the year ended December 31 | Amount $ | |||
Revenue | ||||
Service fees earned | 21,920 | |||
Expenses | ||||
Wages expense | 10,500 | |||
Supplies Expense | 1,120 | |||
Depreciation Expense | 960 | |||
Income Tax Expense | 2,800 | |||
Total Expense | 15,380 | |||
Net Income | 6,540 | |||
2.) | Statement of retained earnings | |||
Amount $ | ||||
Beginning Balance | 7,420 | |||
Add: Net Income | 6,540 | |||
13,960 | ||||
Less: Dividend | 500 | |||
Ending Balance | 13,460 | |||
3.) | Balance Sheet | |||
As at December 31 | Amount $ | |||
Assets | ||||
Current Assets | ||||
Cash | 1,600 | |||
Accounts Receivable | 4,000 | |||
Property , Plant & Equipment | ||||
Office Equipment | 16,800 | |||
Less: Accumulated Depreciation | 1,600 | 15,200 | ||
Shortage of Debit balance in Trial Balance | 460 | |||
(38,740 - 38,280 )* | ||||
Total Assets | 21,260 | - | ||
Liabilities & Stockholder's Equity | ||||
Current Liabilities | ||||
Income tax payable | 2,800 | |||
Stockholder's Equity | ||||
Common Stock | 5,000 | |||
Retained earnings | 13,460 | |||
Total Liabilities & Stockholder's Equity | 21,260 | |||