In: Accounting
Legacy issues $660,000 of 5.5%, four-year bonds dated January 1, 2017, that pay interest semiannually on June 30 and December 31. They are issued at $648,412 and their market rate is 6% at the issue date.
QUESTION: Prepare a straight-line amortization table for the bonds' first two years.
--Use required column and no. of periods asked
| 
 Period/Date  | 
 Cash Interest  | 
 Discount Amortised  | 
 Interest Expense  | 
 Unamortised Discount  | 
 Carrying Value  | 
 Face Value  | 
| 
 [A = 660000 x 5.5% x 6/12]  | 
 [B = 11588/8]  | 
 [C = A+B]  | 
 [D = D - B]  | 
 [E = E + B]  | 
 [F = D + E]  | 
|
| 
 01-Jan-17  | 
 $ 11,588.00  | 
 $ 648,412.00  | 
 $ 660,000.00  | 
|||
| 
 30-Jun-17  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 10,139.50  | 
 $ 649,860.50  | 
 $ 660,000.00  | 
| 
 31-Dec-17  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 8,691.00  | 
 $ 651,309.00  | 
 $ 660,000.00  | 
| 
 30-Jun-18  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 7,242.50  | 
 $ 652,757.50  | 
 $ 660,000.00  | 
| 
 31-Dec-18  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 5,794.00  | 
 $ 654,206.00  | 
 $ 660,000.00  | 
| 
 First Two years complete  | 
||||||
| 
 Amortisation for Remaining life of Bond  | 
||||||
| 
 30-Jun-19  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 4,345.50  | 
 $ 655,654.50  | 
 $ 660,000.00  | 
| 
 31-Dec-19  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 2,897.00  | 
 $ 657,103.00  | 
 $ 660,000.00  | 
| 
 30-Jun-20  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ 1,448.50  | 
 $ 658,551.50  | 
 $ 660,000.00  | 
| 
 31-Dec-20  | 
 $ 18,150.00  | 
 $ 1,448.50  | 
 $ 19,598.50  | 
 $ -  | 
 $ 660,000.00  | 
 $ 660,000.00  |