In: Accounting
Tony’s favorite memories of his childhood were the times he spent with his dad at camp. Tony was daydreaming of those days a bit as he and Suzie jogged along a nature trail and came across a wonderful piece of property for sale. He turned to Suzie and said, “I’ve always wanted to start a camp where families could get away and spend some quality time together. If we just had the money, I know this would be the perfect place.” On November 1, 2022, Great Adventures purchased the land by issuing a $590,000, 6%, 10-year installment note to the seller. Payments of $6,550 are required at the end of each month over the life of the 10-year loan. Each monthly payment of $6,550 includes both interest expense and principal payments (i.e., reduction of the loan amount).
Late that night Tony exclaimed, “We now have land for our new camp;
this has to be the best news ever!” Suzie said, “There’s something
else I need to tell you. I’m expecting!” They decided right then,
if it was a boy, they would name him Venture.
Required:
1. Complete the first three rows of an amortization schedule.
2. & 3. Record the purchase of land with the issuance of a long-term note payable on November 1, 2022, and the first two payments on November 30, 2022, and December 31, 2022, and calculate the remaining balance of the note payable as of December 31, 2022. (If no entry is required for a particular transaction, select "No Journal Entry Required" in the first account field.)
4. The 12 monthly payments in 2023 (following year) will reduce the note’s balance by an additional $44,856. How would the remaining balance of the note payable be reported in the balance sheet as of December 31, 2022?
Date | Cash Paid$(a) | Interest Expenses $(b) | Decrease in Carrying Value$(a-b)=C | Carrying Value $(After adjusted value derived under C) | Principal ($)(a) | Interest part(6%)(b=6%*a) | Monthly Interest Cost($)(b/12 | ||
Nov12022 | Purchased The land | 5,90,000 | 5,90,000 | 35,400 | 2,950 | ||||
End of Nov 2022 | 6,550 | 2,950 | 3,600 | 5,86,400 | 5,86,400 | 35,184 | 2,932 | ||
End of Dec 2022 | 6,550 | 2,932 | 3,618 | 5,82,782 |
Journal Entries | Particular | Debit($) | Credit($) | ||
Nov12022 | Cash | 5,90,000 | |||
Note Payable | 5,90,000 | ||||
End of Nov 2022 | Interest Expenses | 2,950 | |||
Note Payable | 3,600 | ||||
Cash | 6,550 | ||||
End of Dec 2022 | Interest Expenses | 2,932 | |||
Note Payable | 3,618 | ||||
Cash | 6,550 |