Answered step by step
Verified Expert Solution
Question
1 Approved Answer
With the numbers above Assignment Requirements: Prepare the 2020 financial statements using Excel, which includes: First, make an Income Statement (multi-step) Secondly, an Statement of
With the numbers above Assignment Requirements:
- Prepare the 2020 financial statements using Excel, which includes:
- First, make an Income Statement (multi-step)
- Secondly, an Statement of Stockholders Equity (NOT just Retained Earnings)
- Then, Make a Balance Sheet (classified; also show both the 2020 and 2019 numbers)
- Finally, the Statement of Cash Flow
These statements should be in proper form, including formatting.
Accounts Payable Accounts Receivable Accrued Liabilities Accumulated Depreciation - Buildings Accumulated Depreciation - Equipment Additional Paid in Capital Allowance for Doubtful Accounts Buildings Cash Common Stock, $1 Par Cost of Goods Sold Depreciation Expense Dividend Income Dividends Equipment Gain from Discontinued Operation, net of tax Gain on Sale of Equipment Goodwill Closing Trial Balance 70,500 90,000 154,500 45,000 16,500 243,000 3,000 180,000 123,000 27,000 135,000 Adjusted Trial Balance 68,500 104,000 196,000 51,000 18,000 256,500 4,500 220,500 148,500 28,500 585,000 19,500 1,500 45,000 148,000 87,500 3,000 60,000 25,000 12,000 12,500 4,000 133,000 24,000 45,000 15,000 135,000 10,000 93,500 66,000 1,184,000 31,500 372,000 60,000 Income Taxes 135,000 45,000 Insurance Expense Interest Expense Interest Income Inventory Investment in ABC Stock Land Loss from Discontinued Operation, net of tax Notes Payable (due in 4 years) Prepaid Rent Rent Expense Retained Earnings Sales Revenue Treasury Stock Wages Expense 150,000 7,500 66,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started