Question

In: Finance

Based on the below information: Liquidity Ratio 2013-12 2014-12 2015-12 2016-12 2017-12 1 Current Ratio =...

Based on the below information:

Liquidity Ratio 2013-12 2014-12 2015-12 2016-12 2017-12
1 Current Ratio = CurrentAssets / Current Liabilities 0.826892 0.818622 0.789666 0.86939 0.815876
2 Quick Ratio = ( Cash and equivalents + receivables)/ current liabilities 0.526964 0.504773 0.436861 0.525862 0.49807
3 net working capital-to-sales ratio = (Current Assets - Current Liabilities)/ Sales -0.0295 -0.02975 -0.04375 -0.02846 -0.04485
Operating performance ratio
1 Days of Sales in Inventory = 365/ Inventoryturnover 17.71466 19.41963 28.73953 30.66475 34.03286
2 Days of Sales in Receivables = 365/ receivable turnover 28.75343 25.94051 27.9565 35.7206 39.39461
`
Profitability ratios
1 Gross Profit Margin = Gross profit / sales 0.21002 0.204603 0.204911 0.178914 0.231589
2 Operating profit margin = operating profit / sales 0.137156 0.131731 0.08585 0.038526 0.081274
3 Net profit margin = Net profit / sales 0.077417 0.082516 0.062238 0.035863 0.083108
Return on Investment ratios
1 Basic Earning Power ratio = EBIT / Total assets 0.166432 0.148547 0.066151 0.025497 0.055278
2 ROA = Net Income / Total assets 0.093942 0.093049 0.047957 0.023735 0.056526
3 ROE = Netincome/ Shareholder equity 0.187238 0.186469 0.094549 0.046855

0.105015

How liquid is the company?

Is management generating substantial profit on the company's assets?

If management of the company would like to improve the company's financial performance, what should the management do?

Solutions

Expert Solution

Ans 1) Company is not liquid enough because most of the liquidity ratio is less than one which tells that current liabilties are mroe than current asset which make this firm less liquid.It need to be more than 1 to be liquid enough to take care of its short term liabilties.

Ans 2) Though management is generating postive return on asset but we can't say it is substantial due to decrease in this ratios towards the year 2015 to 2017 in comparision oto 2013 and 2014.

Ans 3) Advice to management:

1. Increase the liqiudity ratio and maintain positive net working capital. It can be done by either reducing the liabiltiy or increading the asset but reducing the liability is advicable due to less return on asset, increasing the asset will put more pressure on the return on asset.

2. Operaitng performance ratio is deteriorating from 2012 to 2017, management should make sure that these days should be minimize because it is keeping moeny and end product idle and company is losing opportunity cost on it and also increaing the inventory cost.

3. Company should try to reduce the operating expenses because it is impacting the net income.

4. Company should try to reduce its debt by its retained earning.


Related Solutions

Historical Ratios Projected Ratios 12/31/2014 12/31/2015 12/31/2016 12/31/2017 4/1/2018 Current Ratio 1.161 0.833 Current Ratio 0.951...
Historical Ratios Projected Ratios 12/31/2014 12/31/2015 12/31/2016 12/31/2017 4/1/2018 Current Ratio 1.161 0.833 Current Ratio 0.951 0.964 0.613 Quick Ratio 0.522 0.426 Quick Ratio 0.46 0.466 0.294 Total Debt-to-Total-Assets Ratio 0.73 0.804 Debt-to-Total-Assets Ratio 0.85 0.832 0.865 Total Debt-to-Equity Ratio 2.82 4.306 Debt-to-Equity Ratio 5.976 4.962 6.525 Times-Interest-Earned Ratio 16.618 13.359 Times-Interest-Earned Ratio 14.376 15.802 16.776 Question: What do the ratios calculated communicate about the financial strengths and weaknesses of Hershey? Question: Based on your calculations, would you invest in...
Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015...
Pepsi 2013 2014 2015 2016 2017 Sales/Revenue 66.42B 66.68B 63.05B 62.8B 63.53B Coca-Cola 2013 2014 2015 2016 2017 Sales/Revenue 46.76B 46B 43.7B 41.38B 35.02B Using the year 2013-2017 financial data of Coca-Cola and PepsiCo companies, determine their 5-year average growth rates related to net sales and income from continuing operations. Coca Cola: Net Sales: 7.86% Increase. PepsiCo: Net Sales: 3.11% Increase. And what data to use to calculate.
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013...
Innovative Components, Inc. reported the following income statement data for 2013-2017.    2017 2016 2015 2014 2013 Net Sales $3,144.6 $2,993.1 $2,790.5 $2,654.0 $2,478.9 What would be an appropriate sales growth rate based on the historical data?
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800...
2017 2016 2015 2014 2013 Sales $ 699,332 $ 466,221 $ 368,554 $ 252,434 $ 189,800 Cost of goods sold 352,166 234,761 187,327 128,167 94,900 Accounts receivable 33,918 27,227 25,283 14,767 13,001 Compute trend percents for the above accounts, using 2013 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Sales 2017: / = % 2016: / = % 2015: / = % 2014: / = % Trend Percent for Cost of Goods...
3/11/2014 12/18/2014 1,166.67 12/19/2013 12/18/2014 5,800.00 5/29/2014 5/28/2015 7,600.00 12/26/2013 7/25/2014 500.00 7/26/2014 7/25/2015 750.00 1/1/2014...
3/11/2014 12/18/2014 1,166.67 12/19/2013 12/18/2014 5,800.00 5/29/2014 5/28/2015 7,600.00 12/26/2013 7/25/2014 500.00 7/26/2014 7/25/2015 750.00 1/1/2014 12/31/2014 4,200.00 3/6/2014 3/6/2015 4,670.00 3/6/2013 3/6/2014 4,670.00 The above information contains the terms and invoice amounts for several prepaid expenses. Calculate the monthly amortization for each (include equations) and determine the balances for each as of 12/31/2014. Use quarter of a month depreciation.
A manufacturing company's financials reveal the following ratios: Ratio/Calculation 2016 2015 2014 2013 2012 Industry Ave....
A manufacturing company's financials reveal the following ratios: Ratio/Calculation 2016 2015 2014 2013 2012 Industry Ave. Debt Ratio 40.0% 42.0% 46.0% 45.0% 45.0% 52.0% Times Interest Earned 7.1 7.1 7.1 6.9 6.9 7.1 Fixed Charge Coverage 5.4 5.4 5.9 6.9 6.9 6.5 Financial Leverage Ratio 1.7 1.7 1.9 1.8 1.8 2.1 Based on your review of this company's debt paying ability ratios and their comparison to the industry, averages comment on this company's debt-paying ability and financial leverage position.
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what information this ratio provides (define), and what the results mean specifically to your company. Use complete sentences in your own words. Has the current ratio improved?_________________________ 2) Company's Debt ratio 2017 Debt Ratio =0.417987 = 41.799% 2016 Debit Ratio = 0.415240 = 41.524% Explain what information this ratio provides (define), and what the results mean specifically to your company Use complete sentences Has the...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what information this ratio provides (define), and what the results mean specifically to your company. Use complete sentences in your own words. Has the current ratio improved?_________________________ 2) Company's Debt ratio 2017 Debt Ratio =0.417987 = 41.799% 2016 Debit Ratio = 0.415240 = 41.524% Explain what information this ratio provides (define), and what the results mean specifically to your company Use complete sentences Has the...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what information this ratio provides (define), and what the results mean specifically to your company. Use complete sentences in your own words. Has the current ratio improved?_________________________ 2) Company's Debt ratio 2017 Debt Ratio =0.417987 = 41.799% 2016 Debit Ratio = 0.415240 = 41.524% Explain what information this ratio provides (define), and what the results mean specifically to your company Use complete sentences Has the...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61...
Time series is given: Year 2012 2013 2014 2015 2016 2017 2018 2019 Amount 65 61 73 68 67 72 75 70 Calculate and interpret the characteristics of it; Make the time series next value forecast by using any method.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT