Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help me... need to answer 5 questions. can you write an excel and take a screenshot. it is gonna be helpful for me. 1.
please help me...
A B D E F F G 1 Balance Sheets 2 3 4 5 6 7 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,200 $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 2021Expected $14,000 71,632 878,000 1.716,480 $2,680,112 1,220,000 383.16 $836.840 $3.516,952 D 00 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 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 $663.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 fx 4 A B E E F F G 1 2 3 4 5 6 Income Statements 2019 Sales $3,432,000 COGS except depr. 2,864,000 Depreciation 18,900 Other Expenses 340.000 Total Operating Costs $3.222.900 EBIT $209,100 Interest Expense 62.500 EBT $146,600 Taxes (40%) 58,640 Net Income $87.960 7 2020 $5,834,400 4,980,000 116,960 720.000 $5.816.960 $17,440 176,000 ($158,560) -63.424 ($95.136) 2021Expected $7,035,600 5,800,000 120,000 612.960 $6.532.960 $502,640 80.000 $422,640 169,056 $253.584 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Other Data Stock Price Shares Outstanding EPS DPS Tax Rate Book Value Per Share Lease Payments 2015 $8.50 100,000 $0.88 $0.22 40% $6.64 $40,000 2016 $6.00 100,000 ($0.95) $0.11 40% $5.58 $40,000 2017E $12.17 250,000 $1.01 $0.22 40% $7.91 $40,000 fx 4 B C D H M N o P 0 R 1 2019 2020 2021 Industry ADRE 2.7 1 1. Calculate current ratio and cuck Patios for 2019 2020 and 2021 Espected years. Make comments on company liquidity position in the years and compare with the industry averaget 2 3 4 5 6 7 1 Ratio Anal Current Oukk Inventory Turnov Dave Sales Outdin Fixed Assets Tumover Total Assets. Turnover Debt Ratio Labtes/Assets Ratio Times Interested Margin ROA NOE Pricing Mail BoA 10 11 12 13 14 15 16 -17 32 7 25 12001 50.00% 6.2 EN 9.OON 12.90 162 2.9 2. Calculate investory turnover, day sales outstanding tod asset butover and total asset turnover for 2019,2020 and 2021Expected years and mate comments online les considering to industry wers 3. Calculate debt ratio,labilities 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 mars, retum onts and retur on equity for 2019, 2020, and 2022Expected years, and make comment considering the industry averages Caleate perearsing and marvet books for 2019 2020 2021xpected pars. Haned the natin, what do you think that investorite outfit? 19 Note: All calculation will be an Excel cells above. Please fill in the blanks under the years with corresponding rates, and write your comment part of the questions 20Your comments should include but not limited to the interpretation of ratio calculations, annual trand (2019.2020 20216), whether it is good or bad for the fire, comparhan with Industry average data etc. 21 22 23 HE Balance Sheet Income Statement Ratio Analysis + A C D m E 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 need to answer 5 questions. can you write an excel and take a screenshot. it is gonna be helpful for me.
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?
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