Bond Price Excel Formula

In this presentation, we will calculate the bond price explaining how this can be done using present value formulas within Excel. Remember that the bonds is going to be a great tool for both accounting and finance to describe the present value calculation. So that’s why it’s going to be used. Oftentimes It has two cash flows related to it, one’s going to be the face amount of the bond that’s going to be due at the end of the term of the bond. In our case, it’s going to be two years semiannual or four time periods. And the other is the flow of interest. So bonds are a great example because they have the two types of present value problems that we need in one area. So even if you’re not in an area where you’re dealing with bonds all the time, they’re still going to be used and useful to understand present value types of calculations. So here we’ve got the bond is going to have one cash flow of 100,000 at the end of four periods or two years, and we need to figure out what the present value is in order to price it back here at your at time period zero. And then we have these four payments in terms of the annuity 4000. And we need to take those and present value them, we could take each period and present value each payment and present value it. But the easier thing to do is to present value, an annuity when it’s applicable and present value, the one amount when it’s applicable. And therefore think of that about these as two basically separate cash flows that we’re going to have to present value separately. So we can do this multiple different ways. And it just depends on what you’re what tools you have. And where you are, in order to know how to do it. What you want to know is just that there’s different tools to do it. Anytime someone uses a different tool. What are they doing the same thing? And and when can you apply these tools and what’s actually happening here. So that’s what’s actually happening. We’re present valuing this information.

(more…)

Bond Price Present Value Tables

In this presentation, we will calculate the bond price using present value tables. Remember that the bonds is going to be a great tool for understanding the time value of money. Because of those two cash flow streams we have when with relation to bonds, meaning we’re going to pay the bond back the face amount of the bond, and we’re going to have the income stream. And those are going to be perfect for us to think about time value of money, how to calculate time value of money, our goal being to get a present value of those two streams. So we’re going to think of those two streams separately generally, and present value each of them to find out what the present value of the bond will be. We can do that at least three or four different ways. We can do that with a formula actually doing the math on it. We can do it now, which is probably more popular. Now. Do it with a calculator or with tables in Excel, I would prefer Excel or we can use just tables pre formatted tables. The goal here the point is to really understand what we’re doing in terms of what what is happening, what can it tell it? What can it tell us, and then understand that these different methods are all doing the same thing.

(more…)

Bonds Present Value Formulas

In this presentation, we will take a look at present value formulas related to bonds. One of the reasons bonds is so important to accounting and finance is because they’re a good example of the term of present value of money. We’re trying to look for an equal measure of money, when we think of bonds and bonds is going to have this relationship between market rates and the stated rate, which helps us to kind of look through and figure out these types of concepts. So even if we don’t work with bonds, in other words, if we’re not planning on issuing bonds, or buying bonds, or knowing anything about bonds not being important to us, the time value of money is a very important concept and bonds is going to be a major tool to help us with that. Why is bonds so useful for learning time value of money, because there’s two types of cash flows with bonds meaning at the end of the time period, we typically are going to get the face amount of the bond that 100,000 similar to a note and then we’ve got the interest payments that are going to happen on a periodic To basis, and therefore we have these two different types of cash flows, that we can use two different formulas for, to think about how to equalize.

(more…)

Premium Amortization & Interest

 

In this presentation, we will discuss the amortization of a bond premium and the recording of interest expense on bonds. This is going to be our starting point. This is the initial transaction in order to get the bonds on the books. Here’s our data down here we’ve got the number of years we’ve got the face amount of the bonds, we’ve got the issue price 270, we see that the interest on the market rate is different than the contract rate. The result then is that cash is going to be increased by the 217. The bonds payable went on the books for the face amount of the bond, the amount that’s on the bonds of the 240, which is a liability. And then we have the premium being the difference increasing the premium here by the 30. The 240 plus 230 is going to be equal to the 270,000 carrying amount book value of the bonds. Now we’re going to go through the process of recording the interest we can see that this is going to have 15 years bonds, we’re going to pay the bonds semi annually. So we’re going to have to record the interest on them. And we’re gonna have to reduce this premium in some way as well. Remember, at the end of the bonds, we’re not going to pay back the 270. We’re only going to pay back 240. So how are we going to get rid of that the premium on the bond and why are we going to do it in the way we will. We’ll start off by amortize in the premium using a straight line the method. Note that the effective method is the preferred method for amortize in a premium for generally accepted accounting principles, but the straight line method will be appropriate in some cases, if the difference is going to be a non material. And the straight line method is a simplified method and it’s easy for us to see what is going on. So we’ll start off with the straight line method.

(more…)

Bond Issued at Premium

In this presentation, we will take a look at the journal entries related to issuing a bond at a premium. When considering the journal entry for a bond, remember what can change and what is the same for a bond. When we think about a bond, it’s already been printed, we know the amount of the bond, the interest on the bond, the maturity date of the bond, these are already set. So if we’re making a negotiation with the bond after it had already been printed, then we can’t change the face amount. We can’t change the interest due dates. What can we change in order to negotiate and make a sales price on the bond, we can change the amount that we issue it for. So keep that in mind. Whenever you think about these bond problems. That’s the thing that’s going to differ from a bond to a note. The thing that changes when we want to loan is the interest rate. The thing that changes when we want to issue a bond that’s already been made is going to be the amount we receive For the bond being different than the face amount of the bond if there’s a difference in the market rate and the contract rate. So in this example, we’re saying that we issued a bond. Now note that when we think about the issuance of the bond, just like a note, we often have more information than we really need. And that can be a little bit confusing for us.

(more…)