CF 6-4A – Internal Rate of Return (IRR) and Net Present Value (NPV) – Corporate Finance

Coin Crunch
8 followers
AI Generated·May contain errors
Video Summary
AI GeneratedThis video provides a step-by-step walkthrough of a corporate finance problem focused on calculating Net Present Value (NPV) and the Internal Rate of Return (IRR) for a project costing $50,000 with annual returns of $10,000 for eight years. The instructor demonstrates how to solve these problems using both a financial calculator and manual formulas.
Let's take a run through problem six, four, a, we're asked to
commute internal rate of return.
That's the point at which net present value is zero.
That's the discount rate at which net present value is zero, as well
as just net present value calculations.
This is a great practice.
Again, net present value being a fundamental concept in
a corporate finance class.
Pinnacle company is considering a project that will cost 50 grand today
and expects we'll provide cash flows of $10,000 per year for the next eight years.
So we're going to be, um, uh, to have a payback period of five years, right?
It costs us 50 grand to per year.
And it's 10 grand per year for the next eight years.
It pays back in five years, but what's the net present value because payback
doesn't consider the time value of money.
Uh, and so it's going to depend on our discount rate, our required
rate of return to figure out whether this is a good idea or a bad idea.
Um, so you could do this in so many ways, we're going to do it
in the financial calculator.
So I'll show you how to do that.
Uh, but you could also do this by hand just by like listing out your cash flows.
So negative 50, 10, 10, 10, 10, 10, 10, 10, you know, down to, you know, do that
eight times and then you just go present value calculations, you divide by one
plus the discount rate, 1.06 to the zero.
That happens at time zero.
This one happens at time.
One time to down to time 10, but of course we have an annuity, so I'll show you how
to do it in the financial calculator.
And there's different ways you could do it in the financial calculator.
And then I'll show you just calculate the PV of the nudity by hand and
show you how it's solved this by hand.
But let's start with our financial calculator.
Um, we're going to be entering cash flows.
Now I think I have stuff.
Yeah.
In my calculator from before.
So I have to go a second function, clear work.
Uh, let's see.
NPV.
Okay.
That's all clear.
Good.
Okay.
So you just want to make sure that memory is cleared out.
So you don't have some previous payment hiding in there somewhere.
Uh, but let's think about the payments.
We're putting out $50,000 today.
We're getting 10 grand a year for the next eight years.
So cash flows.
I want to enter cash flows, $50,000 negative today.
Cashflow at time zero.
I hit enter down arrow cashflow at time one, 10,000 enter down arrow.
Now here, this F1 is, is the frequency of that $10,000 cashflow.
And because it's a new, it just pays the same every year for eight years.
I can say frequency is eight.
And at that point I've done, I've entered every cashflow.
I've said I get 50,000 out today.
And starting next year, I get eight payments yearly of $10,000.
That's what this means.
And I'm done.
So now I can compute the net present value at 6%.
Let me erase this so I can have room to enter my answer.
Uh, so I hit NPV.
It says what's the I or the required rate of return for part A at six.
So six enter.
I hit the down arrow.
It says NPV zero.
No, no, no.
I hit compute and it'll tell me the NPV and the NPV is $12,098.
$12,098.
So we would say based on NPV rules to do it, right?
This is a project worth doing because it has positive net present value.
Okay.
Part B calculate the net present value, assuming a rate
required rate of return of 30.
Well, you just go back and you got all the cash flows already entered.
So you just go back into NPV.
You change I from six to 30.
How do I do that?
I just put 30 enter.
So now my I or my required rate of return is 30.
I hit the down arrow.
Now it's got the old NPV.
I just have to recompute it.
So I hit compute.
Now it's negative 20, seven, five, three.
So in this case, we would say, don't do the project.
Negative NPV, don't do the project.
Positive NPV, do the project in the absence of other information.
Okay.
So we've solved there.
Now it asks for the internal rate of return.
That's the rate of return at which NPV is zero.
So it's going to be somewhere between six and 30.
I'm going to guess.
I don't know.
I'm spitballing here.
Maybe 14, 15%.
I don't know.
Some point in between six and 30, we go negative.
So what's the point at which we're zero?
I'm spitballing 13.
I'd start with maybe let's see.
So easy enough in a financial calculator, you just hit IRR and compute.
Ah, 11.8.
So as a little bit off with my guess, 11.81%.
That's the point at which our net present value is zero and
we're indifferent to the project.
Uh, so if our required rate of return is higher than 11.8, we don't do it.
If our required rate of return is lower than 11.8, it's worth doing.
Okay.
We've solved and that's it.
Uh, so if you're using financial calculator, you probably
don't need to go any further.
We can say goodbye, but if you're using a, if you want to do this by hand, you
won't do IRR by hand because changing these rates in our calculations is like.
Tedious.
And it's just trial and error.
You just, uh, yeah, just trying various versions.
You can do it in Excel quickly, but you can do it much more quickly just
with a financial calculator or in Excel using an IRR solve feature.
Okay.
Let's solve this by hand though.
So I'm going to redo part a by hand.
You could apply this to part B just as easily.
So, uh, PV of an annuity we're we're.
We'll deal with this $50,000 today money after we want to know what $10,000 per
year for the next eight years at a discount rate of 6%, what's the value of that?
So 10,000 is our recurring payment times one minus one over 1.06, right?
One plus 6% to the power of T.
This is eight years all divided by R, which is 0.06.
Okay.
Let's get some brackets around stuff.
And there we are.
That's good enough.
Okay.
So 1.06 to the power of eight, 1.59.
I go one over that.
So one over that is 0.62.
One minus that.
I was going minus one, then hit the plus minus 0.37 divide by 0.06.
And I end at 6.2 times 10,000.
And the value of those cash flows is 62, oops, 62098.
So you got to ask yourself, would I pay $50,000 today to get value of 62,000?
And the answer is yes, you would.
And what's the overall value here?
Well, I'd pay 50 to get 62.
I'm making 12098 on that deal.
That's my net present value.
So we could do this, you know, by hand that took two minutes.
Maybe like it doesn't take long.
It is quicker in the financial calculator, but you can do it by hand.
We've solved the problem though.
Thanks for watching.
See you in the next video.
Bye-bye.
