Answered step by step
Verified Expert Solution
Link Copied!

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.
could you write with excel please? (take a screenshot) it is gonna be helpful for me.
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Consolidated Financial Reporting

Authors: Paul Taylor

1st Edition

1853962503, 9781853962509

More Books

Students also viewed these Accounting questions

Question

=+d) How many treatments are involved?

Answered: 1 week ago