FIN 28 Bond Calculations

Coin Crunch
8 followers
AI Generated·May contain errors
Video Summary
AI GeneratedThis video provides a step-by-step tutorial on calculating the price of a bond using both a financial calculator and manual mathematical formulas. Using a specific example of a 10-year bond, the instructor demonstrates how to determine the present value of cash flows and explains how bond prices evolve as they approach maturity.
In this video, we're going to work on a problem you can download from TonyBell.com.
Go to the website, click the PDF link, and you'll notice there's no sign in, no sign
up.
The PDF just pops right up.
You'll scroll down and find whatever problem it is that we're working on.
As you scroll through the problems, you'll notice many are free and open, like the one
you're watching now, but some are members only.
I think the free and open ones are enough for most people, but if you can't get enough
of me and you'd like to join and get access to those members only videos, click the join
button underneath the YouTube play box.
All right.
Thanks so much for watching.
Let's get started.
Let's run through problem 41A.
I'll read through the question and we'll kind of discuss it as we go.
You're considering buying a 10 year thousand dollar bond with a coupon rate of 9% in semi-annual
coupons.
So 10 years, semi-annual coupons means there's 20 payments, right?
20 interest payments.
Its yield to maturity is 8%.
So big picture, when you're contemplating a bond, you have two cash flows to track.
One, these 20 semi-annual payments, which is an annuity.
So with a bond, we take the present value of an annuity and it's just those 20, every
six months there's interest to be paid back.
And then at the end of it, the borrower, the person you buy the bond from has to pay you
back the thousand dollars.
It's a loan, you're loaning them a thousand dollars and they're making interest payments
along the way.
And so that's the second piece of this.
There's the present value of that thousand dollars, however much you'll loan them upfront.
So we'll solve at least a part of this problem by hand just to show you the math and it can
be done by hand very easily.
But we'll focus in on our financial calculator as we solve the problem.
So I'll solve it first with a financial calculator.
Then I'll solve maybe part A with just by hand to show you it can be done, but let's
solve it with our financial calculator.
Okay.
You're considering buying a 10 year, a thousand dollar bond, coupon rate, 9%, semi-annual
payment, semi-annual coupons.
Its yield to maturity is 8%.
Calculate the price of the bond today.
Here's what we're going to input into our calculator.
The N is a 20, right?
There's 20 semi-annual payments, 20 periods.
Our IY is this yield to maturity and the yield to maturity is 8%.
But remember when you're quoted interest rates, you're quoted for the year.
We need to break that into six months.
So for a six month period, that's half, it's 4% per semi-annual payment, right?
Per six month period.
Our PV is unknown.
That's what we're solving for.
Our payment amount is what we promise.
And what we promise is the coupon rate.
So it's a thousand dollar bond, 9% coupon means it's a $90 payment, but the
fact that it's semi-annual, this is $90 per year, divide by two to get your
payment, which is $40, $5 per six month period, our F fee is a thousand bucks.
That's what we get paid back at the end of this.
So we're saying, what's the present value of those cash flows?
20 payments of $45.
That's what this is summarizing.
And a thousand dollar lump sum coming to us at the end of the bond.
I smacked my microphones and coming to us and smacked my mic.
Okay.
Let's, uh, let's solve it.
Hopefully I'm still speaking into the mic.
Yeah.
My meters are still working.
Uh, okay.
So let me just clear any, uh, information.
I have my calculator.
I hit 20 as my N, uh, four as my IY, PV is unknown.
PMT is 45 positive.
This is cash flowing to us.
A thousand FV positive is cash flowing to us.
And I compute the PV.
And the answer is I got to pay 1067 to get those cash flows.
That's a value of those cash flows today.
One come Oh six, 7.95.
And this is not a surprise that it's more than a thousand dollars.
The reason is the coupon rate.
9% is higher than the yield to maturity 8%.
It means our coupon is going to be attractive and people will pay a premium.
This is a higher coupon rate than the risk level of the bond might dictate.
People will pay a higher amount for it.
There's a premium of $67 on this bond.
And had the coupon rate been lower, there would be a discount.
And I think that's the B version of this problem shows a discount.
Uh, assuming no changes in interest rate, calculate the
price of the bond in five years.
So this is asking us, okay.
Everything else in the bond is equal, but just change the N.
What is our new N?
Well, five years, when it's a 10 year bond, five years from now, there's
five years left, which means there's 10 payments left, right?
There's two payments a year.
There's five years left.
So our N is 10.
Everything else is equal.
So again, nice feature of the financial calculator.
All I do is put in 10 as N everything.
I could re input everything, right?
Put the IY, but it's already in there.
So now I compute PV and I get 1040.55.
All right.
The third scenario.
Uh, so that's the answer, right?
Assuming no changes, calculate the price of the bond in five years.
It's 1040.55.
Uh, what about the price of the bond in nine years?
Okay.
The price of the bond in nine years.
So in nine years, how many periods are left on the bond?
How many interest payments are left?
And the answer is, well, I got one year left.
So there's two payments a year, two payments.
So N is two in that circumstance.
So I put two in as my N and I compute PV and I get a thousand and nine, 1009.43.
Okay.
There we have it.
Uh, so we've solved A, B and C.
Part B says, explain the movement in the bond price.
We expect bonds over time as they get closer and closer to the maturity date.
In other words, as they're, you know, getting closer and closer
to they have to pay back.
The value gets closer and closer to the face value, any discount or premium
as we have a premium here shrinks, right?
The premium was 67 bucks today, 40 bucks, five years from now and
nine bucks, nine years from now.
The premium is going to go down to zero.
Cause they're just going to pay me back a thousand dollars with, without
a premium or without a discount.
So we expect the movement of any bond to be closer and closer to the maturity
value as the maturity date approaches.
So, uh, again, closer and closer to a thousand dollar face value
as the maturity date approaches.
Okay.
There we have it.
We've solved 418.
I will do a little chunk of this by hand, but that's enough for you.
That's enough for you.
And it'd be enough for me to hit one of those buttons.
Hey, if you're going to stick around, why not hit one of those
buttons anyway, because it feels good to do it.
It feels good to make you feel good.
Make me feel good.
Um, okay.
Let's do this by hand though, and see how you're coping with doing it by hand.
Uh, the present value of the annuity is the payment amount.
We said the payment was 45 bucks.
So C is cashflow, the regular cashflow, 45 times one minus one over
one plus the interest rate.
And this is the, uh, IY.
This is the, the, uh, yield to maturity divided by two.
So 4%, 1.04 to the power of T it's 20.
Sorry, I'm redoing part A just to be clear.
I'm calculating the bond price.
Oh my goodness.
Well, forgive the coughing attack.
I will mute that in post.
Okay.
So, uh, we were just kind of coming up with our time period.
And what we'd said was, well, we're doing part A.
And so for part A, this is a 10 year bond, 20 payments.
So our T is 20 and like a real tickle in my throat there.
Uh, we divide that by R which is 0.04.
And so there we have it.
We have our payment 45 times.
And then what's in brackets, that's going to give the present value
of those, uh, regular interest periods.
What about the present value of the lump sum?
Well, again, we're getting paid a thousand dollars back at the
end of the bond divide by 1.04.
One plus R to the T 1.04 to the power of 20.
Okay.
Let's crunch our numbers and then I'll, uh, stop the video and cough away.
Uh, 1.04 to the power of 20 is 2.19.
One minus 2.19.
No one, so pardon me, one over 2.19.
So I go one over X, then I go one minus that answer.
So minus one plus minus 0.54 divide by 0.04.
I get 13.59 times 45, 611.56 is the present value of the interest.
Well, what about the thousand dollars I get at the end of the bond?
You go 1.04 to the power of 20.
You divide a thousand by that.
So one over X times a thousand, and that's worth 456.39.
Add these two together.
You can hear a frog in my throat.
Uh, 611.56 plus 456.
Let's do it.
611.56 plus 456.39.
And we find the present value of our bond is 1067.95.
And that's what we had done in our calculator.
Now we could very easily do this for five years and 10 years.
All you would do if you want to do it for five years, you would change this
exponent to 10, because that's the amount of time remaining on the bond.
You would change this to 10.
And if you wanted to do it for nine years out, you would
change the exponent to two.
And this exponent would become two.
And you could solve them all that way.
And if, if you had to, you could, and it's not even that much slower.
You could do this by hand reasonably quickly, but we did it, uh, with our
calculator first and we have solved the problem.
All right.
I got to remember to edit the coffee out of the video.
Uh, thanks so much for watching as always.
And I'll see you in the next video.
Bye-bye.
