Preview

Tata Power

Satisfactory Essays
Open Document
Open Document
624 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Tata Power
OBJECTIVE: To find β, Value of Share and Weighted Average Cost of Capital (WACC) for TATA POWER CO. LTD.
REFERENCE INDEX:
Reference index used for β and other calculations is NSE INDEX. I have collected weekly data from 31/08/2005 to 30/08/2010.
COST OF CAPITAL
Cost of capital of the company has been calculated by using Weighted Average Cost of Capital (WACC) by assigning weights to cost of equity and cost of debt.
COST OF EQUITY-
CAPM model has been used to calculate the cost of equity (Ke). β (systematic risk) has been calculated using the formula
Beta (β) = covariance (market, security)
Variance (market)
Ke=Rf+ β (Rm-Rf)
Where,
Ke=Cost of equity Rf=risk free rate (8.1%) Rm=Market return

| SECURITY | MARKET | AVG. RETURN | 0.55 | 0.404 | VARIANCE | 34.5346 | 16.936 | COVARIANCE | 17.49273916 | BETA | 1.032885407 | | | | Annual Return(Rm) | 23.32% | Risk Free Rate(Rf) | 8.10% | | | | CAPM(Ke) | 23.82% |

Analysis: β is >1, the investment in the firm is more risky.
COST OF DEBT-
It has been calculated using the formula-
Kd = Interest(1-Tax Rate) Total Debt

Tax Rate= Tax PBT

Calculation of WACC has been shown below-
WACC=We*Ke+Wd*Kd

CALCULATION OF WACC | YEAR | 2006 | 2007 | 2008 | 2009 | 2010 | | BOOK VALUE | Equity | 10,623.77 | 10,623.77 | 10,623.77 | 10,623.77 | 10,623.77 | Debt | 2,796.81 | 3,675.52 | 3,083.35 | 5,247.06 | 5,872.01 | Total | 13,420.58 | 14,299.29 | 13,707.12 | 15,870.83 | 16,495.78 | We | 0.7916 | 0.743 | 0.7751 | 0.6694 | 0.644 | Wd | 0.2084 | 0.257 | 0.2249 | 0.3306 | 0.356 | Ke | 0.2382 | 0.2382 | 0.2382 | 0.2382 | 0.2382 | WACC | 0.19794 | 0.1885 | 0.1955 | 0.1761 | 0.1725 | | MARKET VALUE | FACE VALUE | | | | | 10 | NO. OF SHARES | | | | | 23.73065 | MARKET VALUE | | | | | 237.31 | TOTAL | | | | | 6,109.32 | We | | | | | 0.0388 | WACC | | | | | 0.0284 |

VALUATION
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Chipotle Cash Flow Analysis Paper
    • 1590 Words
    • 7 Pages

    Chipotle Cash Flow Analysis Paper

    The weighted average cost of capital (WACC) is the discount rate used in the discounted cash flow analysis. Usually, the WACC is the weighted average of the cost of debt (Kd) and the cost of equity (Ke), since debt and equity are the most common sources of funds for the companies. In general, the formula for WACC is the following:…

    • 1590 Words
    • 7 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Case 54 Questions
    • 1477 Words
    • 8 Pages

    Case 54 Questions

    The comptroller currently finds the weights for the weighted average cost of capital (WACC) from information from the balance sheet shown in Table 2. Compute the book value weights that the comp­trol­ler currently uses for the company’s capital structure.…

    • 1477 Words
    • 8 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    ahahahahaa
    • 759 Words
    • 4 Pages

    ahahahahaa

    We then determined a WACC of 5.37% based on a cost of equity of 8.85% (calculated with beta of 1.76, risk fee rate of 0.05%, and market risk premium of 5%) and estimated the cost of debt at 6%.…

    • 759 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Telus: the Cost of Capital
    • 1178 Words
    • 5 Pages

    Telus: the Cost of Capital

    In calculating the cost of equity, we will use the average between the dividend growth model and the CAPM. Since R-squared = 0.13 we know that the correlation is not strong enough and the sole use of the beta given to us will prove unreliable. For this reason, we choose to take the average between the dividend growth model and the CAPM model if possible. Also, as described above, we decide not to count the underwriter fees in our calculation.…

    • 1178 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Nike Case
    • 836 Words
    • 4 Pages

    Nike Case

    In my analysis, I will argue about choosing different numbers than Cohen to get a more accurate WACC. For the calculation of debt cost of capital, I used the current yield on publicly traded Nike debt to get a market value for the debt and not the book. Having the 6.75% coupon rate paid semiannually, 20 years to maturity, and the current price of $95.60, the debt cost of capital would be estimated at 7.17%. for the calculation of the equity cost of capital, I used CAPM. The three components are the risk free premium, the Beta value, and the market risk premium. I chose a 3-month yield on Treasury bills as the risk free premium since it is the safest and…

    • 836 Words
    • 4 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Kraft Foods, Inc. Case Analysis Essay Example
    • 538 Words
    • 3 Pages

    Kraft Foods, Inc. Case Analysis Essay Example

    Plugging these figures into the WACC formula, we were able to determine a weighted average cost of capital of 4.711%.…

    • 538 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Midland Case
    • 742 Words
    • 3 Pages

    Midland Case

    In order to calculate Midland’s overall corporate WACC we must first determine the cost of equity and the cost of debt. The cost of equity can be defined as the risk-weighted projected return required by investors, where the return is largely unknown. Therefore the cost of equity for the upcoming year can be inferred by using the Beta of equity in the CAPM formula. In the case we are given the Beta of equity for the corporation. Therefore to calculate the cost of equity we plug the Beta of equity into the CAPM formula. Through this calculation we conclude that the cost of equity is 11.23%. These are the results we obtain:…

    • 742 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Midland Energy Resources, Inc. Case Study
    • 747 Words
    • 3 Pages

    Midland Energy Resources, Inc. Case Study

    First of all, cost of capital is an essential component in WACC. WACC is composed of cost of equity and cost of debt.The Mortensen’s estimates are used in various ways including asset appraisals for both capital budgeting and financial accounting, performance assessments, M&A proposals and stock repurchases at division ,business unit level and corporate level.…

    • 747 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Hybrid- Birdie Mergers Case Study
    • 557 Words
    • 3 Pages

    Hybrid- Birdie Mergers Case Study

    For the calculation of the firm value the WACC is used by considering current debt equity ration ( .50). WACC is calculated as follow –…

    • 557 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    My Stuff
    • 476 Words
    • 2 Pages

    My Stuff

    -Beta equals the expected rate of return minus the risk free rate divided by the expected market return minus the risk free rate. The beta for Dell is 1.36.…

    • 476 Words
    • 2 Pages
    Better Essays
    Read More
  • Good Essays

    Yeats Valves Business Evaluation
    • 4542 Words
    • 19 Pages

    Yeats Valves Business Evaluation

    First we calculated the weighted average cost of capital (WACC). It is based on the assumption of a stable debt/equity ratio. YVC’s has no outstanding debt. We first had to compute return on equity and return on debt. To calculate return on debt for TSE we have taken the rating of a Baa Corporate Bond.…

    • 4542 Words
    • 19 Pages
    Good Essays
    Read More
  • Good Essays

    Star Appliances B
    • 1175 Words
    • 5 Pages

    Star Appliances B

    In addition to the estimation of the cost of equity, Star Appliance Company is also considering increasing their current debt ratio of 9.5% to the industry average of 19%. With a higher current debt ratio the WACC will be lower, at a rate of 8.24%. The cost of equity of each product was valued using the beta from the industry averages. The beta of the home appliance industry is 0.95, while the beta of the agricultural machinery industry is 0.88. Through the use of the CAPM model, these betas yield a cost of equity for the home appliances of 11.29% and for the agricultural machinery of 10.7%. The WACC of each individual project is then compared to the project’s IRR. The WACC of the home appliance project was found to be 10.4% and the WACC of the agricultural machinery project was calculated as 9.92%, while the IRR’s of the appliance and agricultural machinery projects were 11.29% and 10.7%, respectively. Therefore, both projects should be accepted based on the notion that the internal rate of return of each project is greater than the weighted average cost of capital.…

    • 1175 Words
    • 5 Pages
    Good Essays
    Read More
  • Powerful Essays

    Wacc Project Smrt Sbs
    • 2065 Words
    • 9 Pages

    Wacc Project Smrt Sbs

    Cost of Equity (Ke,SMRT) = Rf + βSMRT * (E(Rm) – Rf) = 3.36% + 0.31 * 6.3% = 5.31%…

    • 2065 Words
    • 9 Pages
    Powerful Essays
    Read More
  • Good Essays

    Tata Powers
    • 6285 Words
    • 26 Pages

    Tata Powers

    MARCH 2009 FINANCIAL HIGHLIGHTS During the year, the Company reported its highest ever Profit after Tax (PAT) of Rs. 922.20 crores, as against Rs. 869.90 crores for the previous year, a growth of 6%.The Operating Revenue is also higher at Rs. 7,236.23 crores, as against Rs. 5,915.91 crores, a growth of 22.3%. Operating Revenue is higher mainly owing to new tariff approved by the Regulator in Mumbai Licensed Area,additional power generated from new plants commissioned during the year,such as Haldia Power Plant and new wind farms and higher volume sold in Jojobera and Belgaum in the current year.…

    • 6285 Words
    • 26 Pages
    Good Essays
    Read More
  • Good Essays

    Maruti Suzuki Stock Valuation.
    • 793 Words
    • 4 Pages

    Maruti Suzuki Stock Valuation.

    * The capital structure of maruti Suzuki is drawn and subsequently the WACC is calculated taking cost of capital which has been calculated using CAPM model.…

    • 793 Words
    • 4 Pages
    Good Essays
    Read More