can you help me?
please write with an excel program and take a screenshot, it is very helpful for me.
there are 5 questions.
1. Calculate current ratio and quick ratios for 2019, 2020, and 2021Expected years. Make comments on the company's liquidity position in these years and compare with the industry averages.
2. Calculate the inventory turnover, days sales outstanding, fixed asset turnover, and total asset turnover for 2019, 2020, and 2021Expected years, and make comments on the utilization of assets considering industry averages.
3. Calculate debt ratio, liabilities-to-asset ratio, and times-interest-earned ratios for 2019, 2020, and 2021Expected years and compare with the industry data concerning financial leverage.
4. Calculate profit margin, return on assets, and return on equity for 2019, 2020, and 2021Expected years, and make comments considering the industry averages.
5. Calculate price-earnings and market-book ratios for 2019, 2020, and 2021Expected years. Based on the ratios, what do you think that investors think about the firm's future?
Balance Sheet Income Statement Ratio Analysis Balance Sheets Assets Cash Short-Term Investments, Accounts Receivable Inventories Total Current Assets Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Total Assets 2019 $9,000 48,600 351,200 715,2001 $1,124,000 491,000 146,200 $344,800 $1,468,800 2020 $7,282 20,000 632,160 1,287,360 $1,946,802 1,202,950 263,160 $939,790 $2,886,592 2021 Expected $14,000 71,632 878,000 1,716,4801 $2,680,112 1,220,000 383,160 $836,840 $3,516,952 Liabilities And Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long-Term Debt Common Stock (100,000 Shares) Retained Earnings Total Equity Total Liabilities And Equity 2013 $145,600 200,000 136,000 $481,600 323,432 460,000 203,768 S663,768 $1,468,800 2014 $324,000 720,000 284,960 $1,328,960 1,000,000 460,000 97,632 $557.632 $2,886,592 2015e $359,800 300,000 380,000 $1,039,800 500,000 1,680,936 296,216 $1,977,152 $3,516,952 1 A B B C D E m F G 2019 2020 - . - Ratio Analysis Current Quick Inventory Turnover Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Debt Ratio Liabilities/Assets Ratio Times-Interest-Earned Profit Margin ROA ROE Price/Earnings (P/E) Market/Book 2021Expected Industry Average 2.7 1 6.1 32 7 2.5 32.00% 50.00% 6.2 3.60% 9.00% 17.90% 16.2 2.9 3 2 3 4 5 6 7 8 Note: All calculation will be on Excel cells above. Please fill in the blanks under the years with correspond Your comments should include but not limited to the interpretation of ratio calculations, annual trend (20 3 1. Calculate current ratio and quick ratios for 2019, 2020 and 2021Expected years. Make comments on company's liquidity position in these years and compare with the industry averages. 2. Calculate inventory turnover, days sales outstanding, fixed asset turnover and total asset turnover for 2019, 2020 and 2021Expected years, and make comments on utilization of assets considering to industry averages. 3. Calculate debt ratio, liabilities-to-asset ratio and times-interest-earned ratios for 2019, 2020 and 2021Expected years and compare with the industry data with respect to financial leverage. 4. Calculate profit margin, return on assets and retun on equity for 2019, 2020, and 2021Expected years, and make comments considering the industry averages. 5. Calculate price-earning and market-book ratios for 2019, 2020 and 2021Expected years. Based on the ratios, what do you think that investors think about firm's future? Balance Sheet Income Statement Ratio Analysis Balance Sheets Assets Cash Short-Term Investments, Accounts Receivable Inventories Total Current Assets Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Total Assets 2019 $9,000 48,600 351,200 715,2001 $1,124,000 491,000 146,200 $344,800 $1,468,800 2020 $7,282 20,000 632,160 1,287,360 $1,946,802 1,202,950 263,160 $939,790 $2,886,592 2021 Expected $14,000 71,632 878,000 1,716,4801 $2,680,112 1,220,000 383,160 $836,840 $3,516,952 Liabilities And Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long-Term Debt Common Stock (100,000 Shares) Retained Earnings Total Equity Total Liabilities And Equity 2013 $145,600 200,000 136,000 $481,600 323,432 460,000 203,768 S663,768 $1,468,800 2014 $324,000 720,000 284,960 $1,328,960 1,000,000 460,000 97,632 $557.632 $2,886,592 2015e $359,800 300,000 380,000 $1,039,800 500,000 1,680,936 296,216 $1,977,152 $3,516,952 1 A B B C D E m F G 2019 2020 - . - Ratio Analysis Current Quick Inventory Turnover Days Sales Outstanding Fixed Assets Turnover Total Assets Turnover Debt Ratio Liabilities/Assets Ratio Times-Interest-Earned Profit Margin ROA ROE Price/Earnings (P/E) Market/Book 2021Expected Industry Average 2.7 1 6.1 32 7 2.5 32.00% 50.00% 6.2 3.60% 9.00% 17.90% 16.2 2.9 3 2 3 4 5 6 7 8 Note: All calculation will be on Excel cells above. Please fill in the blanks under the years with correspond Your comments should include but not limited to the interpretation of ratio calculations, annual trend (20 3 1. Calculate current ratio and quick ratios for 2019, 2020 and 2021Expected years. Make comments on company's liquidity position in these years and compare with the industry averages. 2. Calculate inventory turnover, days sales outstanding, fixed asset turnover and total asset turnover for 2019, 2020 and 2021Expected years, and make comments on utilization of assets considering to industry averages. 3. Calculate debt ratio, liabilities-to-asset ratio and times-interest-earned ratios for 2019, 2020 and 2021Expected years and compare with the industry data with respect to financial leverage. 4. Calculate profit margin, return on assets and retun on equity for 2019, 2020, and 2021Expected years, and make comments considering the industry averages. 5. Calculate price-earning and market-book ratios for 2019, 2020 and 2021Expected years. Based on the ratios, what do you think that investors think about firm's future
