CF 3-4A – Number of Periods – Corporate Finance

Coin Crunch
8 followers
AI Generated·May contain errors
Video Summary
AI GeneratedThis video demonstrates how to calculate the number of periods (time) required for an investment to grow to a specific future value. Using an example of $50,000 growing to $75,000 at an 8% interest rate, the instructor compares the \"trial and error\" manual calculation method with the precision of a financial calculator.
Let's have a look at problem three for a thus far, we've been asked to calculate the present
value, the future value, the rate of return or the interest rate.
And now we're being asked to do the hardest one, mathematically anyway, the hardest one,
the number of periods.
So we're given present value number, you invest $50,000 today at an interest rate of 8%.
So we're given the rate and it says, how long will it take for this investment to grow to
75,000?
So that's the future value.
So we've been given everything, but how long, right?
The number of periods, this is the hardest one to do.
So here's the formula we've been using quite often, this module, the present value, you
take the dollar value today, times by one plus the rate raised to the power of the number
of periods equals our future value.
So plugging things in here, it's $50,000 times one plus the rate of interest, 1.08, our rate
is 8% raised to the power of T, that's what we're solving for.
We don't know the number of periods equals our future value, 75,000.
So we got to solve for T and the fact that we're solving for an exponent brings the math
far beyond my puny brain, but my understanding reading the textbooks is it's just not an
easy solve.
The textbooks all say just trial and error to get your answer.
So I'll show you what trial and erroring to get our answer looks like here.
So I'm going to divide both sides by 50,000 to get the 50,000 off this side.
So I have 1.08 to the power of T equals 75 divided by 50, it equals 1.5.
Okay, so I need to know, I need to make 1.08 to the power of something equal 1.5 and good
news is most calculators will have this Y to the X or some X to the Y button, right,
that I'm hovering over right now.
And so I just trial and error, I go, okay, well, 1.08 to the power of three, is it three
years?
1.25, I'm not even close.
Okay, 1.08 to the power of six years, is it six years?
Okay, 1.58, I'm too high, right, because I want it to be 1.5, I'm shooting for 1.5.
So 1.2 is too low, 1.6 is too high.
Let's go a year less, 1.08 to the power of five, oh, I'm closer now, 1.47, I want to
be at 1.5, but I'm at 1.47, so it's a little bit higher than five years.
1.08 to the power of 5.2, so it's at 5.2 years, well, I'm 1.49, I'm still not there, it's
higher than 5.2, 1.08 to the power of 5.3, now I'm just a little too high, it's somewhere
between 5.2 and 5.3 years, 1.08 to the power of 5.25, 1.497, okay, I'm going to stop there.
I'm going to say 1.08, I'm going to say T here, just by trial and error, equals, I'll
make this wavy, because we're not quite right, what was it, 5.25 is where I saw, it's actually
a little higher than 5.25, because we want this answer to be a little higher, it's actually
5.26, 5.27, 5.28, something like that, right, and you just have to try them all in your
calculator until you land right on it.
Here I'm going to say it's about 5.25 periods, or 5.25 years, now that's kind of unsatisfying
to me, but you can get the answer that way, right, and it's just like, okay, brute force
your way to a solution, in Excel you can like goal seek, but if you have a financial calculator
you can just solve, so let's solve in our financial calculator, let me pull up my little
table here, and we'll fill in the information that we've got, the number of periods is our
thing that we're solving for, our IY is 8%, our PV value today, $50,000, we're going to
invest today, there's no payments, there's no BGN, and our future value is $75,000, we
put in 50 today to get 75 out in, who knows how many years, 5.25, somewhere around there,
a little higher we said, so let's punch in our numbers, I always clear memory to the
best of my ability, and I go 8 is my IY, $50,000 negative is my PV, $75,000 positive is my
FV, and that's everything, PMT is 0, oops, no, 0 is PMT, I think I put in 75 as PMT there by
mistake, anyway, I think we're good now, I've fixed my PMT, now we want to compute the number
of periods, so I say compute N, and I get 5.268, so we knew we were close, but 5.268 is a more
precise answer than 5.25, there we have it, we've solved 3-4-A, we did it the trial and error way,
we got close, and we could have got closer if we just stuck with it, now we've got a much more
precise answer using our financial calculator, I hope this video helped you, and if it did,
I hope you'll give me the old thumbs up, thanks for watching, bye-bye.
