## 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.

## Interest Calculations

In this presentation, we will take a look at how to calculate simple interest a few different ways. As we look at this, you may ask yourself, why are we going over this a few different ways, why not just go over it one way, the best way. And let us learn that well and be able to apply it in each situation. While one way does work in most situations. In other words, we will probably learn one way have a favorite way to calculate the simple interest and apply that in every circumstance. It’s also the case that when we look at other people’s calculations or technical calculation, they may have some different form of the calculation. For example, I prefer away when I think about the calculation of simple interest to have some subtotals in the calculation and have more of a vertical type of calculation the way we would see if done in something like a calculator. If we see a type of equation in a book, then the idea there is that Have the most simple type of equation expressed in as short a way as possible. And that typically is going to be some type of formula. And that formula will often not be showing the subtotal.