In: Accounting
Year | Payment | Discount factor @ 12% | Present value |
1 | 160,000 | 0.892857 | 142,857 |
2 | 160,000 | 0.797194 | 127,551 |
3 | 160,000 | 0.711780 | 113,885 |
4 | 160,000 | 0.635518 | 101,683 |
5 | 160,000 | 0.567427 | 90,788 |
Present value of Note | $ 576,764 | ||
Discount on notes payable (800000-576764) | $ 223,236 |
Year | Opening value of Note | Installment paid | Interest expense | Principal Paid | Closing value of Note | Discount on notes payable |
Jan 2, 2017 | 576,764 | 223,236 | ||||
Dec 31, 2017 | 576,764 | 160,000 | 69,212 | 90,788 | 485,976 | 154,024 |
Dec 31, 2018 | 485,976 | 160,000 | 58,317 | 101,683 | 384,293 | 95,707 |
Dec 31, 2019 | 384,293 | 160,000 | 46,115 | 113,885 | 270,408 | 49,592 |
Dec 31, 2020 | 270,408 | 160,000 | 32,449 | 127,551 | 142,857 | 17,143 |
Dec 31, 2021 | 142,857 | 160,000 | 17,143 | 142,857 | - | 0 |
How to calculate the above number? | ||||||
Interest expense = Opening value of Note * 12% | ||||||
Principal Paid = Installment paid - Interest expense | ||||||
Closing value of Note = Opening value of Note - Installment paid | ||||||
Discount on notes payable = Discount on notes payable for the earlier period - Interest expense |
General entries | |||
Transaction | General Journal | Debit | Credit |
Jan 2, 2017 | Equipment | 576,764 | |
Discount on notes payable | 223,236 | ||
Notes payable | 800,000 | ||
(To record purchase of equipment on notes payable.) | |||
Dec 31, 2017 | Note payable | 160,000 | |
Interest expense | 69,212 | ||
Discount on notes payable | 69,212 | ||
Cash | 160,000 | ||
(To record interest expense on zero interest bearing note and installment paid.) | |||
Dec 31, 2018 | Note payable | 160,000 | |
Interest expense | 58,317 | ||
Discount on notes payable | 58,317 | ||
Cash | 160,000 | ||
(To record interest expense on zero interest bearing note and installment paid.) | |||
Dec 31, 2019 | Note payable | 160,000 | |
Interest expense | 46,115 | ||
Discount on notes payable | 46,115 | ||
Cash | 160,000 | ||
(To record interest expense on zero interest bearing note and installment paid.) | |||
Dec 31, 2020 | Note payable | 160,000 | |
Interest expense | 32,449 | ||
Discount on notes payable | 32,449 | ||
Cash | 160,000 | ||
(To record interest expense on zero interest bearing note and installment paid.) | |||
Dec 31, 2021 | Note payable | 160,000 | |
Interest expense | 17,143 | ||
Discount on notes payable | 17,143 | ||
Cash | 160,000 | ||
(To record interest expense on zero interest bearing note and installment paid.) |