please answer #3,#4 & #5 . please show at least once how to use the formula.

same one but the other was blurry. thanks!!!

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 40 Also include a vertical analysis column at the right and performa vertical analysis of the income statement. (Use percentage format with 2 decimal places) 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 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 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 FBUY ratios given). Also use the chart from the attached article, and any other source to analyze the impact of using GAAP VS. IFRS Write short response (15-30 sentences) on your analysis. 53 X Cut Oh copy - Calibri General -AAE - Wrap Text O A E. Merge & Center BIU- PH Inser Format Painter $ % 8-9 Conditional Format as Cell Formatting Table Styles Styles Clipboard F Font Alignment Number 33 X f B D E F G ACCT 2023 PROJECT 1 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 Title 5 5 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 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 Instructions income Statement 2019 Adjusted Trial Balance Debit Credit $ 120,000 S 55,000 5.000 36,000 53,000 59.000 $ 24,000 12,200 2,600 2.000 21000 240,000 38.600 10,000 240,000 142.600 20000 48,000 11,800 9.200 Analysis Stock investment Analysis 2018 Post-Closing Trial Balance Debit Credit 125,600 35.000 6,000 15,600 47,000 21,000 16,000 16.800 2,700 4.000 12.100 160,000 38,600 30 Balance Sheet Stmt of Cash Flows Ready Calibri Wrap Text General x cut [ Copy - Format Painter 11 A A BIU Merge & Center $ % 8 - Conditional Format as Cell Formatting Table Styles Styles Clipboard 5 Font Alignment Number B D F 59,000 E 21,000 S 24,000 12,200 2,600 2,000 23,000 240,000 38,600 16,000 16,800 2,700 4,000 12.100 160,000 38,600 10,000 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 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 $ 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 B C D F G 1 2 3 4 5 AMAZING COMPANY Statement of Cash Flows Year Ended December 31, 2019 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 Analysis Stock Investment Analysis Ready File Home Insert Draw Page Layout Formulas Data Review View Help Search Calon - AA == 19 Viva Text General Xun Paste 0 Copy Format Printer 27 BTU 13- Merge Center $ % Conditional Format Formatting Styles In Dwete format Son & Fiber Editing Clipboard Alignment Numbe 19 R49 f D H 1 K M N P 1 Using the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (S Requirements) 2 Requirement 1. Current Working Debt-to- 3 Compute these ratios: Ratio Capital Cash Ratio Debt Ratio Equity Ratio 4 Round rarios to two 5 decimal places ar formatos percentages or Accounts Days Sales currency os apropriate Inventory Days Sales In Gross Profit Receivable In 6 Turnover Inventory Percentage Turnover Receivables 7 2018 Total Assets Rate of Rate of Return on Asset Return on Total Turnover Stockholders' Earnings Assets Ratio Equity Per Share 10 2018 SHE 11 Price/ "Current Stock Prices Earnings Dividend Dividend 12 $10.00 per share Ratio Yield Payout Dividend the 13 14 15 Requirement. Based on 16 the ratios computed above 17 analyze the company's 18 ability to pay its debts both 19 current and long term Instructions Income Statement Balance Sheet Set of Cash Flows Analysis Stockinestment Analysis A1 You have received a lor for your retirement. You have been analysing different shocks and have owed your choice to two pies you You have past received a large annual bonus at work, and have decided to investit in stocks for your retirement. You have been analyringer stocks and have narrowed your choice to two possibilities. You can either invest in Amazing Company, or in THUY, TUY vatios are given below. Select ratios you might use to determine which stock to invest in and make a choice. Defend your selection with quality reasoning. The second part of your analysis is to read the article attached to this assignment. On papes 117-120, there is a chart that summarives some of the differences between GAAP and RS. Explain the generalities and differences, and show interest expense would be presented on the Statement of Cash Flows. Include in your discussion any differences between GAAP and F. Would that impact your investment decision above? Your answer will be saded on analysis. Lors and writing skills Current Working Capital 000 Debte Equity Cash Rate Debt Ratio Days Account Sales in Inventory Dept Sales Gross Pro Receivable Recea Turnover inventory Percentage Turnover 7.25 50.34 50 ERH 2. Based on your selection, which company has better with company you? Ww? Rated Return on Total Assets Rute Return on Stockhollder Caring Per Ratio 1.50 Price Dividend Dividend Yield 2.00 Instructions Income Statement Balance Sheet Stof cash flows Analysis Stock Investment Analysis A B D E G H 1 Price/ Earnings Ratio Dividend Yield Dividend Payout Dividend per share Current Stock Price is 12 $10.00 per share 13 14 15 Requirement 2. Based on 16 the ratios computed above, 17 analyze the company's 18 ability to pay its debts (both 19. current and long term). 20 Refer to at least 3 specific 21 ratios in your analysis. 22 23 Requirement 3: Based on 24 the ratios computed above, 25 analyze the company's 26 management of inventory. 27 Refer to at least 2 specific 28 ratios in your analysis. 29 30 31 Requirement 4: Based on 32 the ratios computed above, 33 analyze the company's 34 management of receivables. 35 Refer to at least 2 specific 36 ratios in your analysis. RZ Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analysis + Ready 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 40 Also include a vertical analysis column at the right and performa vertical analysis of the income statement. (Use percentage format with 2 decimal places) 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 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 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 FBUY ratios given). Also use the chart from the attached article, and any other source to analyze the impact of using GAAP VS. IFRS Write short response (15-30 sentences) on your analysis. 53 X Cut Oh copy - Calibri General -AAE - Wrap Text O A E. Merge & Center BIU- PH Inser Format Painter $ % 8-9 Conditional Format as Cell Formatting Table Styles Styles Clipboard F Font Alignment Number 33 X f B D E F G ACCT 2023 PROJECT 1 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 Title 5 5 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 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 Instructions income Statement 2019 Adjusted Trial Balance Debit Credit $ 120,000 S 55,000 5.000 36,000 53,000 59.000 $ 24,000 12,200 2,600 2.000 21000 240,000 38.600 10,000 240,000 142.600 20000 48,000 11,800 9.200 Analysis Stock investment Analysis 2018 Post-Closing Trial Balance Debit Credit 125,600 35.000 6,000 15,600 47,000 21,000 16,000 16.800 2,700 4.000 12.100 160,000 38,600 30 Balance Sheet Stmt of Cash Flows Ready Calibri Wrap Text General x cut [ Copy - Format Painter 11 A A BIU Merge & Center $ % 8 - Conditional Format as Cell Formatting Table Styles Styles Clipboard 5 Font Alignment Number B D F 59,000 E 21,000 S 24,000 12,200 2,600 2,000 23,000 240,000 38,600 16,000 16,800 2,700 4,000 12.100 160,000 38,600 10,000 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 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 $ 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 B C D F G 1 2 3 4 5 AMAZING COMPANY Statement of Cash Flows Year Ended December 31, 2019 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 Analysis Stock Investment Analysis Ready File Home Insert Draw Page Layout Formulas Data Review View Help Search Calon - AA == 19 Viva Text General Xun Paste 0 Copy Format Printer 27 BTU 13- Merge Center $ % Conditional Format Formatting Styles In Dwete format Son & Fiber Editing Clipboard Alignment Numbe 19 R49 f D H 1 K M N P 1 Using the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (S Requirements) 2 Requirement 1. Current Working Debt-to- 3 Compute these ratios: Ratio Capital Cash Ratio Debt Ratio Equity Ratio 4 Round rarios to two 5 decimal places ar formatos percentages or Accounts Days Sales currency os apropriate Inventory Days Sales In Gross Profit Receivable In 6 Turnover Inventory Percentage Turnover Receivables 7 2018 Total Assets Rate of Rate of Return on Asset Return on Total Turnover Stockholders' Earnings Assets Ratio Equity Per Share 10 2018 SHE 11 Price/ "Current Stock Prices Earnings Dividend Dividend 12 $10.00 per share Ratio Yield Payout Dividend the 13 14 15 Requirement. Based on 16 the ratios computed above 17 analyze the company's 18 ability to pay its debts both 19 current and long term Instructions Income Statement Balance Sheet Set of Cash Flows Analysis Stockinestment Analysis A1 You have received a lor for your retirement. You have been analysing different shocks and have owed your choice to two pies you You have past received a large annual bonus at work, and have decided to investit in stocks for your retirement. You have been analyringer stocks and have narrowed your choice to two possibilities. You can either invest in Amazing Company, or in THUY, TUY vatios are given below. Select ratios you might use to determine which stock to invest in and make a choice. Defend your selection with quality reasoning. The second part of your analysis is to read the article attached to this assignment. On papes 117-120, there is a chart that summarives some of the differences between GAAP and RS. Explain the generalities and differences, and show interest expense would be presented on the Statement of Cash Flows. Include in your discussion any differences between GAAP and F. Would that impact your investment decision above? Your answer will be saded on analysis. Lors and writing skills Current Working Capital 000 Debte Equity Cash Rate Debt Ratio Days Account Sales in Inventory Dept Sales Gross Pro Receivable Recea Turnover inventory Percentage Turnover 7.25 50.34 50 ERH 2. Based on your selection, which company has better with company you? Ww? Rated Return on Total Assets Rute Return on Stockhollder Caring Per Ratio 1.50 Price Dividend Dividend Yield 2.00 Instructions Income Statement Balance Sheet Stof cash flows Analysis Stock Investment Analysis A B D E G H 1 Price/ Earnings Ratio Dividend Yield Dividend Payout Dividend per share Current Stock Price is 12 $10.00 per share 13 14 15 Requirement 2. Based on 16 the ratios computed above, 17 analyze the company's 18 ability to pay its debts (both 19. current and long term). 20 Refer to at least 3 specific 21 ratios in your analysis. 22 23 Requirement 3: Based on 24 the ratios computed above, 25 analyze the company's 26 management of inventory. 27 Refer to at least 2 specific 28 ratios in your analysis. 29 30 31 Requirement 4: Based on 32 the ratios computed above, 33 analyze the company's 34 management of receivables. 35 Refer to at least 2 specific 36 ratios in your analysis. RZ Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analysis + Ready