jv9CX12W44HCc_YvRR-UN/edit stedit was seconds ago BI U A IEE - E - EE X Amazing Company began operations on January 1, 2015, and is now in its fourth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2019 appears below, along with prior year balance sheet data and some additional transaction data for 2018. AMAZING COMPANY Adjusted Trial Balance 12/31/2019 Account The 5 $ 2019 Most Tre Balance Debit Credit 120,000 55,000 5,000 35,000 50.000 59,000 $ 24.000 12,200 2018 Post-Closing Trial Balance Deble Credit 125,500 35,000 6,000 15.600 47,000 21,000 16.000 16,800 2,700 4.000 12.100 160,000 38,500 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, 510 par Retained Earnings Dividends Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense Insurance Expense Legal Fees Depreciation pense Interest Expense income Tax Expense 2.500 2,000 23.000 240,000 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 250.200 250.200 Transaction Data for 2018 Note these transactions were included in the trial balance numbers above.) Cash paid for purchase of office equipment S 6,000 Cash paid for purchase of tools 15.000 Acquisition of Machinery with Notes Payable-longtem 23.000 Cash payment of dividends 10.000 Cash receit from issuance of 8.000 shares of common stock 80,000 3 A F F H 1 Depreciation Expense Interest Expense Income Tax Expense 8,000 1,800 3,000 587.400 $ $ 582.400$ 250,200 250,200 1 5 5 7 Transaction Data for 2018 (Note, these transactions were included in the trial balance numbers above.) Cash paid for purchase of office equipment $ 6,000 Cash paid for purchase of tools 15,000 Acquisition of Machinery with Notes Payable -Long-term 23,000 Cash payment of dividends 10,000 Cash receipt from issuance of 8,000 shares of common stock 80,000 1 4 Requirements: (See sheet tabs at bottom. Use each sheet for the following requirements.) Use Excel Skills in completing these requirements. You must use formulas and functions. celleferences and professional format 7 1. Prepare the Amazing Company multi-step income statement for the year ended December 31, 2019. Laclude the Epsnt the actor 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.) 2. Prepare the Amazing Company balance sheet for December 31, 2019. Include a vertical analysis column at the right and perform a vertical analysis of the balance sheet. (Use the percentage format with 2 decimal places.) 1 3. Prepare the Amazing Company statement of cash flows for the year ended December 31, 2019. Use the indirect method and the format in your textbook. 2 4. Complete the analysis of the financial statements as directed on the Analysis sheet. 5. Complete the analyis of the investment options between this company and EBUY (ratios given). Also use the chart from the attached article, and any other source to 3 analyze the impact of using GAAP VS. IFRS) Write short response (15-30 sentences) on your analysis. 4 5 6 7 8 9 0 1 2 3 5 -5 S8 59 Le Search AutoSave OOR PI Unit 1 Project Fal 2020 (6) - Protected View File Home Insert Page Layout Formulas Data Renew View Help O PROTECTED VIEW Be careful files from the Internet can contain viruses. Une you need so due to stay in Protected View Enable Edtrg 323 x A D H M N Using the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (Requirer Current Ratio Working Capital Debt-to- Equity Ratio Cash Ratio Debt Ratio Requirement 1. Compute these ratios: Round ratios to two decimal places or format as percentages or currency as appropriate. Accounts Days Sales Inventory Days Sales in Gross Profit Receivable in Turnover Inventory Percentage Turnover Receivables 2018 Total Assets Rate of Return on Total Assets Asset Turnover Ratio Rate of Return on Stockholder Earnings s' Equity Per Share 2018 SHE Current Stock Price is $10.00 per share Price/ Earnings Ratio Dividend Yield Dividend Payout Dividend per shares 5 Requirement 2. Based on 5 the ratios computed above, analyze the company's B ability to pay its debts (both current and long term). Refer to at least 3 specific ratios lo your analysis