In: Accounting
Lemon Co. sells $1,000,000 of 10% bonds on August 1, 2017. The bonds pay interest on February 1 and August 1. The due date of the bonds is August 1, 2020. The bonds yield 12%. On October 1, 2018, Lemon Co. buys back $200,000 worth of bonds for $218,000 (includes accrued interest). Give entries through October 1, 2018.
When doing the amortization table, please show your work in excel! Thanks
| Present value of face amount = 1000000 * 0.70496 = 704961 | |
| Present value of interest = 50000 * 4.91732 = 245866 | |
| Total value of bond | 950827 | 


| Date | Account Head | Debit | Credit | |
| 01-08-2017 | Cash | 9,50,827 | ||
| Discount on Bond Liability | 49,173 | |||
| Bond Liability | 10,00,000 | |||
| 31-12-2017 | Interest Expense | 47542 | ||
| Discount on Bond Liability | 5875 | 7050*5/6 | ||
| Interest Liability | 41667 | 50000*5/6 | ||
| 01-02-2018 | Interest liability | 41667 | ||
| Interest expense | 9508 | |||
| Discount on bond liability | 1175 | |||
| Cash | 50000 | |||
| 01-08-2018 | Interest expense | 57743 | ||
| Discount on bond liability | 7743 | |||
| Cash | 50000 | |||
| 01-10-2018 | Interest expense | 3861 | 57921*0.20*2/6 | |
| Discount on bond liability | 528 | 7921*0.20*2/6 | ||
| Cash | 3333 | |||
| 01-10-2018 | Bond Liability | 200000 | ||
| Loss on redemption * | 21069 | |||
| Discount on bond liability | 6402 | |||
| Cash | 214667 | |||
| 31-12-2018 | Interest expense | 38614 | 57921*0.80*5/6 | |
| Discount on bond liability | 5281 | 7921*0.80*5/6 | ||
| Interest Liabilty | 33333 | |||
| 01-02-2019 | Interest liability | 33333 | 57921*0.80*1/6 | |
| Interest expense | 7723 | |||
| Discount on bond liability | 1056 | 7921*0.80*1/6 | ||
| Cash | 40000 | 50000*0.8 | ||
| * Loss on redeemption | ||||
| Reacquiring price | 214667 | 218000 - (200000 * 10% * 2/12) | ||
| Value at Par | 200000 | |||
| Unamortized discount | 6402 | 193598 | ||
| Loss on redeemption | 21069 |