In: Accounting
On January 1, 2019, ABC Company borrowed $120,000 from the bank. The loan is a 7-year note payable that requires annual payments of $24,500 every December 31, beginning December 31, 2019. Assume the loan has an interest rate of 10% compounded annually. Calculate the amount of the note payable at December 31, 2020 that wouldbe classified as a current liability.
ANSWER
| Amount of principal Payable during next one year is classified as current liability | |||||||
| Amount of PRINCIPAL due within one year=Current Liability | |||||||
| REPAYMENT SCHEDULE | |||||||
| A | B | C=A*10% | D=B-C | E=A-D | |||
| Year | Beginning Balance | Annual Total Payment | Interest | Principal | Ending Balance | ||
| 2019 | $120,000 | $24,500 | $12,000 | $12,500 | $107,500 | ||
| 2020 | $107,500 | $24,500 | $10,750 | $13,750 | $93,750 | ||
| 2021 | $93,750 | $24,500 | $9,375 | $15,125 | $78,625 | ||
| 2022 | $78,625 | $24,500 | $7,863 | $16,638 | $61,988 | ||
| 2023 | $61,988 | $24,500 | $6,199 | $18,301 | $43,686 | ||
| 2024 | $43,686 | $24,500 | $4,369 | $20,131 | $23,555 | ||
| 2025 | $23,555 | $24,500 | $2,355 | $22,145 | $1,410 | ||
| Loan Balance as on December 31, 2020 | $93,750 | ||||||
| Principal Payable within next one year(by December 31,2021) | $15,125 | ||||||
| Classified as current liability on December 31, 2020 | $15,125 | ||||||