Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

can you help me?
please write with an excel program and take a screenshot, it is very helpful for me.
there are 5 questions. image text in transcribed
image text in transcribed
image text in transcribed
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

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

The Consolations Of Economics How We Will All Benefit From The New World Order

Authors: Gerard Lyons

1st Edition

0571307795, 9780571307791

More Books

Students also viewed these Accounting questions

Question

F. How will you order your message? What will be the subject line?

Answered: 1 week ago

Question

=+What's the purpose of the piece?

Answered: 1 week ago

Question

=+What benefits are there in direct mail?

Answered: 1 week ago

Question

=+How will this product help them?

Answered: 1 week ago