Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you guys help me plz? Need to answer 5 questions. All questions on the bottom. could you write with excel please? (take a screenshot)
can you guys help me plz? Need to answer 5 questions. All questions on the bottom.
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 A C D E F 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 - 5 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 (2 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 A C D E F 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 - 5 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 (2 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 could you write with excel please? (take a screenshot) it is gonna be helpful for me.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started