Question

In: Finance

R efer to the following data: Selected Ratios: SKI and Industry Average SKI Industry Current 1.75...

R

efer to the following data:

Selected Ratios: SKI and Industry Average

SKI

Industry

Current

1.75

2.25

Debt/Assets

58.76%

50.00%

Turnover of cash and securities

16.67

22.22

Days sales outstanding (365-day basis)

45.63

32

Inventory turnover

4.82

7

Fixed assets turnover

11.35

12

Total assets turnover

2.08

3

Profit margin

2.07%

3.50%

Return on equity (ROE)

10.45%

21.00%

Answer the following:

1. A. Find EVA using available data (make reasonable assumptions)

B. Analyze and Interpret

C. Examine factors in DuPont equation which could be modified to generate higher EVA for SKI

Solutions

Expert Solution

Ans 1 A. EVA (Economic Value Added) = Net Operating Profit after Tax (NOPAT) - Invested Capital *Weighted Average Cost of Capital (WACC). Essentially it is how much more the firm is earning than what is expected of it by the fund providers.

Our Assumptions here Sales of $100 mn ; Thus with the help of Profit Margin SKI NOPAT = $100 mn * 2.07% = $2.07 mn; Invested Capital is assumed as Total Assets in our Case thus with the help of Total Assets Turnover Ratio = 2.08 we have assumed Sales as $ 100 mn and Total Assets Turnover = Sales / Total Assets = 100 / Total Assets = 2.08 or Total Assets = 100 /2.08 = $ 48.07692 mn. Thus our Invested Capital is assumed as $ 48.07692. Moving on to WACC we are assuming it to be @ 10%.

With the variables: NOPAT= $2.07 mn ; Invested Capital = $48.07692 mn and WACC = 10% our EVA for SKI should be = 2.07 - (48.07692*0.10) = - $ 2.73769 mn.

Ans 1 B. We can now know from the above assumptions that the Return that SKI is generating on its Sales are way below the minimum expectation i.e. WACC (10%) by its Shareholders and Bondholders. This puts SKI in a difficult position to convince the capital providers to hold on with SKI for a possible turnaround in near future. The capital providers specially equity holders can be patient for the future but Debt Holders will need safety in terms of Capital & Interest Protection with high level of Debt in SKI portfolio the additional cost is not helping SKI much. SKI needs to rationalize its Debt and with it its financial costs to turn things around and add Economic Value to its firm.

Ans 1 C. DuPont Analysis factors are : Profit Margin; Asset Turnover and Financial Leverage. We will compare each of these factors of SKI with Industry Averages and find the action required from SKI. The analysis is as under:-

(i) Profit Margin: SKI= 2.07% vis a vis Industry Average = 3.50%. Action required from SKI is to improve its Profit Margin as it is close to half of what Industry players are making on their Sales. Needs massive Improvement.

(ii) Asset Turnover: SKI = 2.08 vis a vis Industry Average = 3.0. Action required from SKI is to improve its Total Asset Turnover too. It can be improved by the simple way of increasing sales or let go off the unnecessary Assets it has on its balance sheet. Needs Improvement.

(iii) Financial Leverage: This could be understood from Debt to Assets percentage i.e. SKI has =58.76% vis a vis Industry average of 50.00%. This shows that SKI is highly leveraged but it is not working in favor i.e. neither it is saving cost nor it is generating sufficient turnover when compared to Industry peers reflected by the above two factors. Course of action for SKI is to reduce the amount of Debt to improve its EVA.


Related Solutions

Refer to the following data: Selected Ratios: SKI and Industry Average SKI Industry Current 1.75 2.25...
Refer to the following data: Selected Ratios: SKI and Industry Average SKI Industry Current 1.75 2.25 Debt/Assets 58.76% 50.00% Turnover of cash and securities 16.67 22.22 Days sales outstanding (365-day basis) 45.63 32 Inventory turnover 4.82 7 Fixed assets turnover 11.35 12 Total assets turnover 2.08 3 Profit margin 2.07% 3.50% Return on equity (ROE) 10.45% 21.00% Answer the following questions: 1. a. Determine the DuPont Equation using available data    b. Analyze and interpret in comparison with industry as...
Based on the data below, compute: Current Ratio (Industry Average is 2) Quick Ratio (Industry Average...
Based on the data below, compute: Current Ratio (Industry Average is 2) Quick Ratio (Industry Average is 1) Inventory Turnover (Industry Average is 90 days) Accounts Receivable Turnover (Industry Average is 60days) Earnings Per Share (Industry Average is $2.60) Price-Earnings Ratio (Industry Average is 4) Be sure to comment on the meaning of your computations and compare to the industry average Cash = $120,000 Supplies = $32,000 Accounts Receivable = $90,000 Accounts Payable = $145,000 Equipment = $565,000 Wages Payable...
Select all the correct statements based on the following company and industry ratios Company Industry average...
Select all the correct statements based on the following company and industry ratios Company Industry average ROE 15% 18% ROA 13% 10% PM 11% 11.5% FATO 38 97 EM 14% 12% . The company should reevaluate its pricing strategy and seek higher quality suppliers . The company should rely more on debt financing . The company should issue more stock and use the proceeds to pay down debt . The company should invest more in property plant and equipment. ....
Facebook industry average financial ratios FACEBOOK, INC. RATIO ANALYSIS Industry Average Profitability Ratios Operating Margin Net...
Facebook industry average financial ratios FACEBOOK, INC. RATIO ANALYSIS Industry Average Profitability Ratios Operating Margin Net Profit Margin Return on Equity Financial Strength Ratios Current Ratio Debt-Equity Ratio
Based on the following data, compute: a) Current Ratio (Industry Average is 2.4) b) Quick Ratio...
Based on the following data, compute: a) Current Ratio (Industry Average is 2.4) b) Quick Ratio (Industry Average is 1.5) c) Inventory Turnover (Industry Average is 100 days) d) Accounts Receivable Turnover (Industry Average is 59 days) e) Earnings Per Share (Industry Average is $2) f) Price-Earnings Ratio (Industry Average is 5) Data: Cash = $91,000 A/R = $45,000 A/P = $99,000 Supplies = $1000 Equipment = $400,000 Wages Payable = $6000 Inventory = $110,000 Net Credit Sales = $600,000\...
Using Walt Disney Company, find the industry ratios for the following: Current Ratio Debt to Equity...
Using Walt Disney Company, find the industry ratios for the following: Current Ratio Debt to Equity Ratio Return on Assets Return on Equity Inventory Turnover Asset Turnover
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $649,000 Cost of goods sold 363,000 Gross profit $286,000 Selling and administrative expense 100,000 Operating income $186,000 Interest expense 50,000 Income before tax $136,000 Income tax expense (40%) 54,400 Net income $81,600 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood...
Return Ratios and Leverage The following selected data are taken from the financial statements of Redwood Enterprises: Sales revenue $659,000 Cost of goods sold 397,000 Gross profit $262,000 Selling and administrative expense 100,000 Operating income $162,000 Interest expense 50,000 Income before tax $112,000 Income tax expense (40%) 44,800 Net income $67,200 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen...
Return Ratios and Leverage The following selected data are taken from the financial statements of Evergreen Company: Sales revenue $657,000 Cost of goods sold 387,000 Gross profit $270,000 Selling and administrative expense 100,000 Operating income $170,000 Interest expense 50,000 Income before tax $120,000 Income tax expense (40%) 48,000 Net income $72,000 Accounts payable $45,000 Accrued liabilities 70,000 Income taxes payable 10,000 Interest payable 25,000 Short-term loans payable 150,000 Total current liabilities $300,000 Long-term bonds payable $500,000 Preferred stock, 10%, $100...
Compare and contrast Walmart ratios with the industry ratios. following the table below. Ratios Walmart (2019)...
Compare and contrast Walmart ratios with the industry ratios. following the table below. Ratios Walmart (2019) Industry (2019) Current Ratio 0.8 1.10 Debt to Equity Ratio 0.97 1.54 Return on Assets 2.33 5.41 Return on Equity 7.04 15.70 Inventory Turnover 8.7 18 Asset Turnover 2.33 65
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT