Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analy ACCT 2023 PROJECT I Amazing Company began operations on January 1, 2015, and is now in its fourth ycar of operations. It is a retail sales company with a large amount of online sales. he 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 Tral Blue Account Tule 2019 Adjusted Trial Balance Debit Credit 120,000 35,000 5,000 36,000 53,000 59,000 24.000 12.200 2.600 2.000 21000 240.000 2018 Pest Cheslag Trial Balance Dethit Credit 125.000 125.000 6.000 15.00 47.000 21.000 Cash Accounts Receivable Prepaid Insurance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaris Payable Sales Tax Payable Note Payable Long Term Con Stock 510 par Retained Earnings Dividends Sales Reven Cost of Good Sold Rent Safari ponse Insurance pense Legal Fees Desition Exp Interest Income Tax Expense 16,000 2,700 4,00 12,100 160,00 1.1 18.00 10,000 240.000 142.500 20,000 4.000 11,800 9.200 R000 1.800 1.000 582,400 52.400 250,200 250,200 Transaction Data for 2018 (Note these transactions were included in the trial balance number above.) Caspaid for purchase of office equipment Cash paid for purchase of tools Acquisition of Machinery with Notes Payable long-term Cash payment of dividends Cash receipt from issuance of 8,000 shares of common stock 6,000 15,000 27,000 10,000 NO,000 Requirements: See sheet tabs at bottom. Use each sheet for the following requirements.) se 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 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.) 5. 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 EBUY (ratis given). Abo use the chart from the attached article, and any other source to analyze the impact of usit GAAP. IFRS> Write short response (15.10 sentences on your analysis Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analy Ising the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (5 Requirements: Current Ratio Working Capital Cash Ratio Debt Ratio Debt-to- Equity Ratio Requirement I. Compute hese ratiost rution reimal acor army wat Inventory Days Sales in Gross Profit Turnover Inventory Percentage Accounts Receivable Turnover Days Sales Receivables 2018 Total Assets Rate of Rate of Return Assel Turnoved Earnings Ped Return on Ratio Stockholders Share Total Asset Equity 2018 SHE Current Stock Price is 10.00 per share Price Earnings Dividend Yield Ratio Dividend Payout Dividend per share Requirement 2. Based on he rates computed above nalyze the company's bility to pay its debts both erat and long term Refer to at least specie tiesia your analysis requirement: Based on he rates computed above. nalyze the company's management of inventory fer to at least perille atlos in your analysis. tequirement 4. Based on he rates computed above nalyze the company's management of receivables. Refer to at least specific ties in your analysis Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Ana You have just received a large annual bonus at work, and have decided to invest it in stocks for your retirement. You have been analyzing different stocks and have narrowed your choice to two possibilities. You can either invest in Amazing Company, or in EBUY. EBUY's ratios are given below. Select 3 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 pages 117-120, there is a chart that summarizes some of the differences between GAAP and IFRS. Explain the general similarities and differences, and discuss how interest expense would be presented on the Statement of Cash Flows. Include in your discussion any differences between GAAP and IFRS. Would that impact your investment decision above? Your answer will be graded on analysis, logic, and writing skills, 1. Which three ratios would you choose to analyze which company would be a better INVESTMENT for you? 2. Based on your selection, which company has better ruticos? Which company would you invest in? Why? 3. Read the article attached on the assignment in CANVAS, Focus on page 117-120, and explain the general similarities AND differences between GAAP and IFRS. Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analy ACCT 2023 PROJECT I Amazing Company began operations on January 1, 2015, and is now in its fourth ycar of operations. It is a retail sales company with a large amount of online sales. he 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 Tral Blue Account Tule 2019 Adjusted Trial Balance Debit Credit 120,000 35,000 5,000 36,000 53,000 59,000 24.000 12.200 2.600 2.000 21000 240.000 2018 Pest Cheslag Trial Balance Dethit Credit 125.000 125.000 6.000 15.00 47.000 21.000 Cash Accounts Receivable Prepaid Insurance Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaris Payable Sales Tax Payable Note Payable Long Term Con Stock 510 par Retained Earnings Dividends Sales Reven Cost of Good Sold Rent Safari ponse Insurance pense Legal Fees Desition Exp Interest Income Tax Expense 16,000 2,700 4,00 12,100 160,00 1.1 18.00 10,000 240.000 142.500 20,000 4.000 11,800 9.200 R000 1.800 1.000 582,400 52.400 250,200 250,200 Transaction Data for 2018 (Note these transactions were included in the trial balance number above.) Caspaid for purchase of office equipment Cash paid for purchase of tools Acquisition of Machinery with Notes Payable long-term Cash payment of dividends Cash receipt from issuance of 8,000 shares of common stock 6,000 15,000 27,000 10,000 NO,000 Requirements: See sheet tabs at bottom. Use each sheet for the following requirements.) se 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 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.) 5. 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 EBUY (ratis given). Abo use the chart from the attached article, and any other source to analyze the impact of usit GAAP. IFRS> Write short response (15.10 sentences on your analysis Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Analy Ising the information provided in the instructions and the financial statements you have created in the previous requirements, perform the following analysis (5 Requirements: Current Ratio Working Capital Cash Ratio Debt Ratio Debt-to- Equity Ratio Requirement I. Compute hese ratiost rution reimal acor army wat Inventory Days Sales in Gross Profit Turnover Inventory Percentage Accounts Receivable Turnover Days Sales Receivables 2018 Total Assets Rate of Rate of Return Assel Turnoved Earnings Ped Return on Ratio Stockholders Share Total Asset Equity 2018 SHE Current Stock Price is 10.00 per share Price Earnings Dividend Yield Ratio Dividend Payout Dividend per share Requirement 2. Based on he rates computed above nalyze the company's bility to pay its debts both erat and long term Refer to at least specie tiesia your analysis requirement: Based on he rates computed above. nalyze the company's management of inventory fer to at least perille atlos in your analysis. tequirement 4. Based on he rates computed above nalyze the company's management of receivables. Refer to at least specific ties in your analysis Instructions Income Statement Balance Sheet Stmt of Cash Flows Analysis Stock Investment Ana You have just received a large annual bonus at work, and have decided to invest it in stocks for your retirement. You have been analyzing different stocks and have narrowed your choice to two possibilities. You can either invest in Amazing Company, or in EBUY. EBUY's ratios are given below. Select 3 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 pages 117-120, there is a chart that summarizes some of the differences between GAAP and IFRS. Explain the general similarities and differences, and discuss how interest expense would be presented on the Statement of Cash Flows. Include in your discussion any differences between GAAP and IFRS. Would that impact your investment decision above? Your answer will be graded on analysis, logic, and writing skills, 1. Which three ratios would you choose to analyze which company would be a better INVESTMENT for you? 2. Based on your selection, which company has better ruticos? Which company would you invest in? Why? 3. Read the article attached on the assignment in CANVAS, Focus on page 117-120, and explain the general similarities AND differences between GAAP and IFRS