Posts in the QuickBooks category:

QuickBooks

Bond Retirement

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

 

In this presentation, we will discuss the journal entries related to the retirement of bonds. the retirement of bonds just means that we’re going to pay off the bonds in some form or another at some time or another, meaning the bonds are going to go away. Typically, that’ll happen at the maturity date at the end of the bond. So for example, if we have a bond on these terms, with the face amount of 240, the issue price of 198 for 80, for 15 year bonds, they’re going to be semi annual. What would happen is when we put this on the books, we would put it on the books as cash we got for the 198, the bond payable on the books for 240, and then a discount. And then of course, over the life of the bond, we would be paying interest for that 15 year time period two times that’s 30 payments. And then at the end of this we would also be be amortizing out the discount to get rid of it, to make it go away to the interest and then By the end of this time period, the discount would be zero. And we would only be left with a bond on the books. In other words, at the maturity date, we would have something like this on our trial balance, the discount is now zero. And the bond is on the books at 240, which is the face amount of the bond, if it were a premium, it would be it would be the same in that we would be left with just the bond amount and the premium would be gone to zero. And now it’s just like anything else that we don’t have to deal with interest at this point or anything else, we just need to close out the bond. And so it’s just like any other liability, we’re just going to pay at the maturity date. That’s how we’re going to retire it. So this is a 240 credit, we’re going to make it go down by doing the opposite thing to it a debit, and we’re going to pay cash, cash is a debit balance, we need to make it go down. So we’re going to credit cash. So this is going to be our journal entry. We’ll debit the bond make go away, and then we’ll pay off the cash. When we post this then the bond payable will be here. Here, it’s going to go it’s a credit, we’re going to debit it, making it go away to zero, and then the cash has a debit balance, we’re going to credit it making the cash go down. So it’s a pretty straightforward journal entry.

 

02:12

The only confusing thing about this journal entry is that it happens at the end of the bond term. So when we’re talking about book questions, we often don’t get asked it because usually we’re concentrating on how to calculate the interest how to calculate the face amount of the bond, how to record the bond, how to amortize the the bond, discount or premium. And we don’t really typically get all the way to the end of the bond, the retirement the maturity date, to record the end transaction oftentimes, and it’s a pretty easy transaction if we were to do so. And it’s a lot easier to if we can actually see the trial balance. When you see the trial balance, you say, oh, there’s a liability there. We’re going to pay it just like we would if it were note payable at this time. It needs to go down and then we’re going to pay it off with cash. Now it is possible for us To have a callable bond that we’re going to retire before the end of the bond date before the maturity date. So in other words, in this case, we have the bond on the books of 240,000. And we have the discount of 338 748. And therefore, if we were to calculate the carrying amount, we’d have 240,000 minus 238 748, or two a one 252. This 201 252 is the carrying amount of this bond payable. This is something that we owe in the future. If we can pay it off at this point in time for some cash that’s going to be less than this amount, then we’re going to have a gain resulting in a gain. And if we are paying it off early for something more than this, we’re going to have a loss. So let’s see what that’s going to look like.

 

03:52

The gain or loss can be confusing here. When we’re talking about a bond. It’s easier to get to that point by just doing the journaling So if we have all this information, especially if we have the trial balance, because then we can see what accounts are debited and credited on the trial balance or which accounts have a debit or credit balance, then it’s a lot easier for us to construct the journal entry. So the first is going to be given to us, we’re going to say that the cash that we’re paying is 230,000. That’s gonna have to just be given in the problem because that’s the callable price that’s how much we’re able to purchase these bonds for. So cash is going to go down because remember, we are buying them back basically, or we’re we’re paying them off early before the maturity date. So it’s going to be 230. Then we’re going to say that the bond payable has to go off the books. Now the bond payables on the books at 240,000, we can see it’s a liability, it has a credit balance. So to take it off the books, we do the opposite thing to it, a debit for whatever it needs to be to make it go to zero, the discount. Same thing we need to do whatever we need to do to make it go to zero because it’s Gotta go away. So when we construct the journal entry, we just know that we just got to do whatever we need to do to make it go to zero. If you have a trial balance in front of you, that’s easy to do, because we can see the discounts on the books at a debit. And we need to do the opposite to make it go down, which is a credit. If you’re looking at a book problem that doesn’t give you a trial balance, and just tells you that the bond is on the books at a discount, then you got to think through it. And one way to think through it might be to say, well, the bonds is a liability, it must be a credit, that discount means that we’re making the bond go down, because it must be decreasing, we’re having it less than the state, the face amount, the sticker price.

 

05:40

And since it’s a credit, the thing that makes a credit go down would be a debit. So that discount must be a debit because these two are really combined together. And a discount means that we we really the net of the two are below the face amount price, so this must be a debit. So if it were a premium, then this amount be increasing or greater than the face amount, and it would be a credit normal balance. Once we know that this is a, this is a debit normal balance for a discount, then we can do the opposite thing to it to credit it to make it go down. And then of course, we just need to figure out what the difference is we’ve got credits of 230,038 748 minus the 240. Debit means we need a 28 748 debit. And that of course, in this case, I’m going to say it’s a gain loss account here because it could have gone either way. But if it’s a debit here, then it’s on the income statement. That’s going to be a loss. And you just got to basically start to be able to recognize that why would that be a loss? Well, you can think through that. We paid 230 versus the carrying value, or you can also just think well, if it’s a debit on the income statement, It’s acting more like an expense, meaning expenses have debit balances, they go up in the debit direction, and they bring net income down.

 

07:08

Revenue has a credit balance, it brings net income up. This is acting like a, an expense because it’s a debit balance. If we debit the income statement, it’s going to make net income go down, that means it must be a loss rather than a gain, which we would think would make net income go up. So the other way we can think about this is to is remember, the carrying value is going to be the 240,000 minus the 38 748. So this is kind of a value that we owe on the bond. And it’s a liability, that’s kind of the value we owe and we paid more than the value that we owe. So that’s going to be a loss in this case. And that’s another way you can think through it being a loss. So if we post this out, then we’re going to say that the gain or loss 28 748 Here, making the income statement accounts go up, kind of like an expense bringing net income down. The bond payable will be posted here, it’s going to make the bond payable go to zero. That’s why we are retiring. It’s making it go away. And then we’ve got the discount, it’s going to make the discount go to zero because we’re retiring it as well. And then the cash is going to be here, cash is going to go down. So there’s going to be our transaction. We have the bond payable and discount going away which has to be the case if we’re retiring the bonds. The cash is going down for the early retirement. And we resulted in a loss in order for us to be able to retire the bonds early.

QuickBooks

Bond Price Excel Formula

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

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…)

QuickBooks

Bond Price Present Value Tables

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

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…)

QuickBooks

Bonds Present Value Formulas

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

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…)

QuickBooks

Premium Amortization & Interest

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

 

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…)

QuickBooks

Bond Issued at Premium

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

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…)

QuickBooks

Note Receivable Example

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

 

In this presentation we will discuss notes receivable, giving some examples of journal entries related to notes receivable and a trial balance so we can see the effect and impact on the accounts as well as the effect on net income of these transactions. first transaction, we’re gonna have 120 day 7% note giving the company EMI and extension on past due AR or accounts receivable of 6200. When considering book problems and real life problems, one of our challenges is to interpret what is actually happening what is going on, which party are we in this transaction in? Therefore, how are we going to record this transaction when we’re looking at notes receivable? A common problem with notes receivable is the conversion of an accounts receivable to a notes receivable. So in this case, that’s what we have. We have an accounts receivable here that includes an amount of Due to us by this particular company in AI so these are our books, we have a receivable people owing us money for prior transactions goods or services provided in the past and they owe us in total, all customers owe us 41,521 this customer in particular owes us 6200 of this amount in the receivable that could be found not in the general ledger which would give backup of transactions by date.

(more…)

QuickBooks

Interest Calculations

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

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.

(more…)

QuickBooks

Notes Receivable

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

In this presentation, we will take a look at notes receivable. We’re first going to consider the components of the notes receivable. And then we’ll take a look at the calculation of maturity and some interest calculations. When we look at the notes receivable, it’s important to remember that there are two components two people, two parties, at least to the note, that seems obvious. And in practice, it’s pretty clear who the two people are and what the note is and what the two people involved in the note our doing. However, when we’re writing the notes, or just looking at the notes as a third party that’s considering the note that has been documented. Or if we’re taking a look at a book problem, it’s a little bit more confusing to know which of the two parties are we talking about who’s making the note who is going to be paid at the end of the note time period? We’re considering a note receivable here, meaning we’re considering ourselves to be the business who is going to be receiving money. into the time period, meaning the customer is making a promise, the customer is in essence, we’re thinking of making a note in order to generate that promise, that will then be a promise to pay us in the future.

(more…)

QuickBooks

Allowance Method % Accounts Receivable vs % Sales Method

Written by Bob Steele CPA - Accounting Instruction, Help & How To on . Leave a comment

In this presentation, we will be taking a look at the allowance method for accounts receivable focusing in on the calculation of the allowance for doubtful accounts. There are two methods that can be used in order to calculate the allowance for doubtful accounts accounts. One being the percentage of accounts receivable, the other is the percentage of sales, we will take a look at them both and look at the pros and cons of them. First, we’re going to look at the accounts receivable method. We’re going to start off with the percentage of accounts receivable method for a few different reasons. One, it’s the one that’s most often tested. And two is the one that may be most often used in practice often making the most sense to people that are looking at the two methods. It’s also a bit more complicated. So when we’re looking at test questions, they typically would focus on this method in order to have a bit more complicated process to do the calculation.

(more…)