Question

In: Finance

Calculate the Hurdle rate /WACC for HCL Technologies Calculate the cost of equity capital: 1. Take...

Calculate the Hurdle rate /WACC for HCL Technologies

Calculate the cost of equity capital:
1. Take historical monthly adjusted closing prices for the company from yahoo finance for 3-5 years
2. Calculate the monthly returns Ln(Pt/Pt-1)
3. Take historical monthly adjusted closing prices for market index and calculate monthly returns
4. Run a regression with dependent variable as target company monthly returns and independent variable as market returns
5. The beta (coefficient of market return) is the beta levered for the firm
6. Calculate the cost of equity capital using CAPM model
7. Risk free rate can be taken as ytm of government bond.

8. Calculate cost of debt (wither ytm of corporate bond) or synthetic rating
Calculate EBIT/Interest expense.Add credit default spread to risk free rate for cost of debt.

9. Calculate market value of debt from book value of debt for target company
10. Calculate market value of equity for target company
Calculate the cost of capital for the firm:
11. Calculate WACC using the WACC formula

Solutions

Expert Solution

Please refer to the below output of regression:

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.42313567
R Square 0.179043795
Adjusted R Square 0.178372531
Standard Error 0.01015903
Observations 1225
ANOVA
df SS MS F Significance F
Regression 1 0.027528 0.027528 266.7262 2.17E-54
Residual 1223 0.126221 0.000103
Total 1224 0.153749
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 4.87666E-05 0.00029 0.167991 0.866618 -0.00052 0.000618 -0.00052 0.000618
X Variable 1 0.276086673 0.016905 16.33176 2.17E-54 0.242921 0.309252 0.242921 0.309252
Beta 0.28

Here Beta= X Variable 1 coefficient in the above table

Steps 1-5 given in the question are followed in the excel. Please note:

1) There are certain data points which need to be deleted from the excel for which the value is NULL (indicated as Excluded data in excel sheet) as excel cannot run regression on non integer values

2) The regression has to be run by going to the data analysis function in the data category of excel and selecting regression from the list of options. Here Y variable has to be the stock price as this is the dependent variable

The Beta as per regression is= 0.28

CAPM cost of equity= Rf + Beta*(Rm-Rf)

Where Rf=risk free rate, Rm= Market return

Cost of equity = 6.44%+ 0.28*(15%-6.44%)

=8.84%

The market risk premium is long term average return on the equity markerts which can be googled for SENSEX

The risk free rate can also be found as Indian govt bond yeild on 10 yr bond through google search


Related Solutions

Do we need to know the cost of equity to calculate the WACC?
Do we need to know the cost of equity to calculate the WACC?
What is cost of capital? How do you calculate WACC?
What is cost of capital? How do you calculate WACC?
1. The Weighted Average Cost of Capital (WACC) is a.  the rate at which a company’s future...
1. The Weighted Average Cost of Capital (WACC) is a.  the rate at which a company’s future cash flows need to be discounted b. to arrive at a present value for the business. c. all of the above reflect the WACC d. the value of a company equals the present value of its future cash flows 2.  Flotation Cost is a. the cost for servicing equity capital b. the cost for using debt capital c. the cost for using retained earnings d....
Calculate component cost of capital and WACC for major expansion program assuming that entire capital is...
Calculate component cost of capital and WACC for major expansion program assuming that entire capital is raised from new bonds, preferred stock and retained earnings. – Tax rate = 40%. – 15-year, 12% coupon, semiannual payment noncallable bonds sell for $1,153. New bonds will be privately placed with no flotation cost. – 10%, $100 par value, perpetual preferred stock sells for $111.10. New preferred stocks are issued at 5% flotation cost – Common stock sells for $50. D0 = $4.19...
Calculate the company cost of capital (or WACC) of Kangas Ltd, a company that commenced operations...
Calculate the company cost of capital (or WACC) of Kangas Ltd, a company that commenced operations many years ago. Relevant details relating to the company include the following. Extract from statement of financial performance Liabilities Debentures ($100 par, 12.5% coupon—annual) $4,000,000 Preference shares ($3 par, 7% cumulative) 1,500,000 Owners’ equityOrdinary shares ($0.50 par) $7,500,000 Retained earnings 2,500,000 Additional information •An interest payment in relation to the debentures has just been made, and they mature three years from today. The market...
1. ( A ) What is the WACC (weighted cost of capital) for a company if...
1. ( A ) What is the WACC (weighted cost of capital) for a company if it borrows from two sources: bank loan of 25 million at 6% per compounded monthly, and retained earning of 10 million with earnings per share of 35 cents and price per share 14.00 dollars. Income tax rate is 35%. ( B )When using the “longest life” planning horizon what issue (or issues) might you have to consider for alternatives whose cash flow profiles are...
How to find CVS Health WACC, Cost of Debt, Cost of Equity using CAPM model (Capital...
How to find CVS Health WACC, Cost of Debt, Cost of Equity using CAPM model (Capital Asset Pricing Model) for year 2017?
A firm’s weighted average cost of capital (WACC) is used as the discount rate to evaluate...
A firm’s weighted average cost of capital (WACC) is used as the discount rate to evaluate various capital budgeting projects. However, remember the WACC is an appropriate discount rate only for a project of average risk. Analyze the cost of capital situations of the following company cases, and answer the specific questions that finance professionals need to address. Consider the case of Fuzzy Button Clothing Company Fuzzy Button Clothing Company has a target capital structure of 58% debt, 6% preferred...
The weighted average cost of capital (WACC) is used as the discount rate to evaluate various...
The weighted average cost of capital (WACC) is used as the discount rate to evaluate various capital budgeting projects. However, it is important to realize that the WACC is an appropriate discount rate only for a project of average risk. Consider the case of Turnbull Company. Turnbull Company has a target capital structure of 58% debt, 6% preferred stock, and 36% common equity. It has a before-tax cost of debt of 8.20%, and its cost of preferred stock is 9.30%....
In order to calculate an entity weighted average cost of capital (WACC) financial weight have to...
In order to calculate an entity weighted average cost of capital (WACC) financial weight have to be set each component in the firms capital structure. the weight may be calculated as book or market value and as historic or target figures. Explain what is meant by these four types of weights.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT