(13 of 17) Ch.14 - Calculate WACC & then NPV: example - YouTube

Channel: unknown

[0]
Let's look at the following example.
[4]
A company wants to invest $300,000 into a new factory in Texas.
[10]
The factory is expected to generate profits equal to $150,000 per year for three years.
[17]
What do we know about the company?
[22]
It issues debt and equity in equal proportions.
[26]
The beta of its equity equals 1.2.
[30]
The yield to maturity on its bonds is 10%.
[35]
Its corporate income tax rate is 34%.
[38]
We also know that the risk-free rate in the economy is 3% and the expected return on the
[46]
market portfolio is 20%.
[49]
The question in this problem is should the company make the investment?
[56]
Let's see how we should approach this problem.
[60]
To answer the big question, should the company make the investment, essentially, we would
[67]
need to calculate the project's net present value.
[71]
So, we need to discount the future cashflows estimated for this project in order to calculate
[79]
the project's net present value.
[83]
The project's cashflows are given.
[86]
We need to invest 300,000 and this three-year project will generate $150,000 per year.
[94]
So, the cashflows are not a problem but what we need for the net present value, apart from
[103]
the cashflows is the discount rate, project's discount rate.
[107]
For that, we can use the weighted average cost of capital.
[111]
So, our very first step will be calculating the cost of equity, the cost of debt, and
[119]
their weights in order to find the weighted average cost of capital which will then be
[124]
used as the discount rate to find the project's net present value.
[131]
So, this is our plan.
[134]
Let's start with the weighted average cost of capital formula.
[138]
Once again, we only have two parts in it rather than three
[177]
because we don't have any preferred stock, just debt and equity.
[181]
So, we have the equity component in the WACC formula and the debt component in the WACC
[188]
formula.
[190]
Let's start with the cost of equity, RE.
[193]
What are we given about the common stock shares?
[201]
The beta, the risk-free rate, and the expected return on the market.
[205]
These three are part of the capital asset price and model formula which is the approach
[211]
we can use to find the cost of equity.
[214]
So, from the CAPAM approach we have the risk-free rate, 3% or 0.03 in decimals, plus the beta
[223]
of the stock, 1.2, multiplied by the expected return on the market which is 20% or 0.2 minus
[233]
the risk-free rate, 0.03.
[236]
This gives us 0.234 or 23.4%.
[242]
So, on the money provided by investors who buy the firm's common stock shares, it will
[249]
have to pay back every year 23.4% of that money.
[256]
That's for the common stock part.
[258]
Now what about the bonds?
[260]
So, let's calculate the cost of debt which is denoted by RD which is also the same thing
[267]
as the pre-tax cost of debt.
[272]
The yield to maturity is 10%.
[275]
It's already given so there is nothing we really need to calculate.
[279]
We don't need to solve any bond problem for IY.
[283]
We already know the pre-tax cost of debt.
[287]
OK.
[288]
Then the tax rate, the corporate income tax rate, TC.
[294]
That's also given, 34% or 0.34 in decimals.
[301]
Then what you're left in the WACC formula is the capital structure weights.
[308]
The weight of equity -- you divide it by V. And the weight of debt -- D divided by V.
[315]
Let's see what we are given.
[316]
The company issues debt and equity in equal proportions which means both weights are 50%
[325]
each or 0.5 in decimals.
[329]
OK?
[331]
Let's put all the numbers together.
[333]
The weighted average cost of capital in this problem equals 0.5, the weight of equity,
[339]
multiplied by 0.234, the cost of equity, plus the weight of debt, 0.5, times the pre-tax
[348]
cost of debt, 0.10, times one minus the corporate income tax rate, 0.34.
[356]
This gives us 0.15 in decimals or 15%.
[362]
Fifteen percent is how much it costs the firm every year on the money that stock and bond
[371]
buyers provided to the firm.
[373]
And so, this is the minimum the firm should want to earn on any new investment project.
[381]
So, we are now using 15% as the discount rate for the project in our problem.
[390]
The net present value equals minus the initial investment minus $300,000 plus the first year's
[399]
cashflow, 150,000, discounted back by one year, so divided by one plus 0.15 -- the WACC.
[408]
Then we add the discounted second year's estimated cashflow -- $150,000 divided by squared sum
[417]
of one and 0.15.
[420]
And then similarly we add the last discounted cashflow.
[425]
The third year's $150,000 cashflow divided by cubed one plus 0.15.
[434]
This gives us the net present value of $42,484.
[439]
Of course, this whole thing, the net present value step, could be calculated in one step
[447]
in the financial calculator using the cashflow keys.
[451]
Let's review that.
[454]
OK.
[455]
Let's clear everything.
[456]
I am pressing second plus/minus enter.
[461]
I press the cashflow button.
[463]
For year zero we have the initial investment of $300,000.
[468]
So, I press that, 300,000.
[472]
I change the sign to negative by pressing the plus/minus key on the bottom.
[477]
And then I save it by pressing enter.
[480]
Then I press the down arrow key.
[483]
It takes me to cashflow number one in the future which is the first year's estimated
[489]
cashflow, $150,000 -- 150,000.
[498]
I save it by pressing enter.
[500]
I press the down arrow key.
[503]
The calculator is asking me about the frequency of the cashflow I have just entered.
[511]
And this is where we can speed things up a little and change the frequency to three because
[517]
we have $150,000 repeating consecutively three times.
[522]
I press three, enter, down arrow key.
[527]
Cashflow number two -- after my first cashflows have been saved.
[534]
There is no cashflow number two.
[537]
That's it.
[538]
We are done.
[539]
Now I press NPV.
[541]
The display asks me about the I which is the interest rate or the discount rate.
[548]
That's 15% weighted average cost of capital.
[552]
I press 15, enter, down arrow key, and the last thing I press is the compute button,
[563]
CPT. 42,483.77 or approximately $42,484 like I calculated on the slide earlier.
[575]
And now let's interpret this result.
[578]
Because the net present value is above zero dollars, the project is worth it.