The green box are the directions. please help with #1 and #2 . thanks!
7 Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) 6 Use Excel Skills in completing these requirements. You must use formules and functions, cell references, and professional formatting 1. Prepare the Amazing Company multi-step income statement for the year ended December 31, 2019. Include the EPS at the bottom. 8 Also include a vertical analysis column at the right and perform a vertical analysis of the income statement. (Use percentage format with 2 decimal places.) 9 2. Prepare the Amazing Company balance sheet for December 31, 2019. Include a vertical analysis column at the right -0 and perform a vertical analysis of the balance sheet. (Use the percentage format with 2 decimal places.) 3. Prenare the Amazina Comnany statement of cash flows for the year ended December 11 2019 Ilse the indirect method and the format in our textbook Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analysis 9020 Clipboard Font Formatting Table Styles Styles Alignment Number 143 X fo D F 4 B E 22 Common Stock, $10 par 240,000 160,000 23 Retained Earnings 38,600 38,600 24 Dividends 10,000 25 Sales Revenue 240,000 26 Cost of Goods Sold 142.600 27 Rent Expense 20,000 28 Salaries Expense 48,000 29 Insurance Expense 11,800 30 Legal Fees 9,200 31 Depreciation Expense 8,000 32 Interest Expense 1,800 33 Income Tax Expense 3,000 34 $ 582,400 $ 582,400 $ 250,200 250,200 35 36 37 Transaction Data for 2018 (Note, these transactions were included in the trial balance numbers above.) 38 Cash paid for purchase of office equipment $ 6,000 39 Cash paid for purchase of tools 15,000 40 Acquisition of Machinery with Notes Payable ---Long-term 23,000 41 Cash payment of dividends 10,000 42 Cash receipt from issuance of 8,000 shares of common stock 80.000 43 44 45 Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) 46 Use Excel Skills in completing these requirements. You must use formulas and functions. cell references, and professional formatting 1. Prepare the Amazing Company multi-step income statement for the year ended December 31, 2019. Include the EPS at the bottom. 48 Also include a vertical analysis column at the right and perform a vertical analysis of the income statement. (Use percentage format with 2 decimal pla 49 2. Prepare the Amazing Company balance sheet for December 31, 2019. Include a vertical analysis column at the right 50 and perform a vertical analysis of the balance sheet. (Use the percentage format with 2 decimal places.) 51 Prenare the Amazine Comnan statement of cash flows for the year ended December 11 2019 Ilse the indirect method and the format in our text Instructions Income Statement Balance Sheet Strnt of Cash Flows Analysis Stock Investment Analysis X B D E AMAZING COMPANY Adjusted Trial Balance 12/31/2019 Account Title Cash Accounts Receivable Prepaid Insurance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable--Long Term Common Stock, $10 par Retained Earnings Dividends Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense Insurance Expense Legal Fees Depreciation Expense Interest Expense Income Tax Expense 2019 2018 Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit $ 120,000 $ 125,600 55,000 35,000 5,000 6,000 36,000 15,600 53,000 47,000 59,000 21,000 $ 24,000 16,000 12,200 16,800 2,600 2,700 2.000 4,000 23,000 12,100 240,000 160,000 38,600 38,600 10,000 240,000 142,600 20,000 48,000 11,800 9,200 8,000 1,800 3,000 $ 582,400 $ 582,400 S 250,200 250,200 Analysis Stock Investment Analysis Instructions Income Statement Balance Sheet Stmt of Cash Flows B D AMAZING COMPANY Income Statement Year Ended December 31, 2019 Vert. Analysis 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Instructions Income Statement Balance Sheet Stmt of Cash Flows Ready Analysis S Clipboard Font Alignment Number Styles A25 X fo A B D 1 2 3 AMAZING COMPANY Balance Sheet December 31, 2019 Vert Analysis 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analysis
