In: Accounting
Caprio Inc. sells $500,000 of 10% bonds on June 1, 2015. The bonds pay interest on December 1 and June 1. The due date of the bonds is June 1, 2020. The bonds yield 8%. On October 1, 2016, Caprio buys back $200,000 (face value) of bonds for $210,000 in cash (not including accrued interest which was paid separately – also in cash). Provide the following: Show EXCEL FORMULAS
a. The present value of the bond payable is $ ______________________ on June 1, 2015. Round to the nearest dollar.
b. Prepare a well-labeled schedule (with debits/credits shown) for the journal entries through the life of the Bond.
c. Give all journal entries for:
•6/1/15
•12/1/15
•12/31/15
•6/1/16
•10/1/16 Update
•10/1/16 accrued interest payment
•10/1/16 redemption
| 
 Basic details  | 
|
| 
 Coupon rate per Period (10%/2)  | 
 5.00%  | 
| 
 Face value of bond  | 
 500,000  | 
| 
 Market or Discounting rate per Period (8%/2)  | 
 4.00%  | 
| 
 Interest paid (500000*5%)  | 
 25000  | 
| 
 Payment at end of period with Face value(500000+25000)  | 
 525000  | 
| 
 Interest paid on  | 
 Semi annually  | 
| 
 Present Value of bond  | 
|||
| 
 Period  | 
 Payment  | 
 Discounting Factor @ 4%  | 
 Present Value  | 
| 
 Dec 1, 2015  | 
 25000  | 
 0.961538  | 
 24038.46  | 
| 
 Jun 1, 2016  | 
 25000  | 
 0.924556  | 
 23113.91  | 
| 
 Dec 1, 2016  | 
 25000  | 
 0.888996  | 
 22224.91  | 
| 
 Jun 1, 2017  | 
 25000  | 
 0.854804  | 
 21370.10  | 
| 
 Dec 1, 2017  | 
 25000  | 
 0.821927  | 
 20548.18  | 
| 
 Jun 1, 2018  | 
 25000  | 
 0.790315  | 
 19757.86  | 
| 
 Dec 1, 2018  | 
 25000  | 
 0.759918  | 
 18997.95  | 
| 
 Jun 1, 2019  | 
 25000  | 
 0.730690  | 
 18267.26  | 
| 
 Dec 1, 2019  | 
 25000  | 
 0.702587  | 
 17564.67  | 
| 
 Jun 1, 2020  | 
 525000  | 
 0.675564  | 
 354671.19  | 
| 
 Present value of Bond  | 
 540554  | 
||
| 
 Less: face value of Bond  | 
 500000  | 
||
| 
 Premium on Bond payable  | 
 40554  | 
||
| 
 Fair value  | 
||||||||
| 
 Interest payment (Credit Cash) = Face value of bond * Coupon rate  | 
||||||||
| 
 Interest Expense (Debit Interest Expense) = book value of Bond for previous period * Market or Discounting rate  | 
||||||||
| 
 Amortization of bond premium (Debit Bond Premium) = Interest payment - Interest Expense  | 
||||||||
| 
 Credit Balance in Bond premium = Credit Balance in Bond premium for previous period - Amortization of bond premium  | 
||||||||
| 
 Credit Balance in Bond Payable = Face value of bond  | 
||||||||
| 
 Book value of Bond = Credit Balance in Bond premium + Credit Balance in Bond Payable  | 
||||||||
| 
 Bond Premium Amortization Table  | 
||||||||
| 
 Credit Balance in Bond premium at end of retirement of bond payable must be Zero.  | 
||||||||
| 
 Period  | 
 Date  | 
 Interest payment  | 
 Interest Expense  | 
 Amortization of bond premium  | 
 Credit Balance in Bond premium  | 
 Credit Balance in Bond Payable  | 
 Book value of Bond  | 
|
| 
 0  | 
 Jun 1, 2015  | 
 40554  | 
 500000  | 
 540554  | 
||||
| 
 1  | 
 Dec 1, 2015  | 
 25000  | 
 21622  | 
 3378  | 
 37177  | 
 500000  | 
 537177  | 
|
| 
 2  | 
 Jun 1, 2016  | 
 25000  | 
 21487  | 
 3513  | 
 33664  | 
 500000  | 
 533664  | 
|
| 
 3  | 
 Dec 1, 2016  | 
 25000  | 
 21347  | 
 3653  | 
 30010  | 
 500000  | 
 530010  | 
|
| 
 4  | 
 Jun 1, 2017  | 
 25000  | 
 21200  | 
 3800  | 
 26211  | 
 500000  | 
 526211  | 
|
| 
 5  | 
 Dec 1, 2017  | 
 25000  | 
 21048  | 
 3952  | 
 22259  | 
 500000  | 
 522259  | 
|
| 
 6  | 
 Jun 1, 2018  | 
 25000  | 
 20890  | 
 4110  | 
 18149  | 
 500000  | 
 518149  | 
|
| 
 7  | 
 Dec 1, 2018  | 
 25000  | 
 20726  | 
 4274  | 
 13875  | 
 500000  | 
 513875  | 
|
| 
 8  | 
 Jun 1, 2019  | 
 25000  | 
 20555  | 
 4445  | 
 9430  | 
 500000  | 
 509430  | 
|
| 
 9  | 
 Dec 1, 2019  | 
 25000  | 
 20377  | 
 4623  | 
 4808  | 
 500000  | 
 504808  | 
|
| 
 10  | 
 Jun 1, 2020  | 
 25000  | 
 20192  | 
 4808  | 
 0  | 
 500000  | 
 500000  | 
|
| 
 Company Name  | 
|||
| 
 Journal entries  | 
|||
| 
 Date  | 
 General journal  | 
 Debit  | 
 Credit  | 
| 
 Jun 1, 2015  | 
 Cash  | 
 540554  | 
|
| 
 Bond payable  | 
 500000  | 
||
| 
 Premium on bond payable  | 
 40554  | 
||
| 
 (To record issued of bond payable at Premium.)  | 
|||
| 
 Dec 1, 2015  | 
 Interest expense  | 
 21622  | 
|
| 
 Premium on bond payable  | 
 3378  | 
||
| 
 Cash  | 
 25000  | 
||
| 
 (To record interest expense and amortization of bond premium.)  | 
|||
| 
 Dec 31, 2015  | 
 Interest expense (21487 / 6 )  | 
 3581  | 
|
| 
 Premium on bond payable (3513 / 6)  | 
 586  | 
||
| 
 Interest payable (500000*10%*1/12)  | 
 4167  | 
||
| 
 (To record accrued interest for one month) (Divided by 6 because of interest paid on 6 month.)  | 
|||
| 
 Jun 1, 2016  | 
 Interest expense (21487*5 / 6 )  | 
 17906  | 
|
| 
 Premium on bond payable (3513*5 / 6)  | 
 2928  | 
||
| 
 Interest payable  | 
 4167  | 
||
| 
 Cash  | 
 25000  | 
||
| 
 (To record interest expense and amortization of bond premium.)  | 
|||
| 
 Oct 1, 2016  | 
 Interest expense (8539*4 / 6 )  | 
 5693  | 
|
| 
 Premium on bond payable (1461 *4 / 6)  | 
 974  | 
||
| 
 Interest payable (200000*10%*4/12)  | 
 6667  | 
||
| 
 (To record accrued interest for Four month) ( 1 June to 1 Oct) (Divided by 6 because of interest paid on 6 month.)  | 
|||
| 
 Oct 1, 2016  | 
 Interest payable (200000*10%*4/12)  | 
 6667  | 
|
| 
 Cash  | 
 6667  | 
||
| 
 (To record accrued interest payment.)  | 
|||
| 
 Oct 1, 2016  | 
 Bond payable  | 
 200000  | 
|
| 
 Premium on bond payable (212492-200000)  | 
 12492  | 
||
| 
 Gain on retirement (Buy back) of bond  | 
 2492  | 
||
| 
 Cash  | 
 210000  | 
||
| 
 (To record Retirement of bond payable.)  | 
|||
| 
 Interest expense  | 
 Amortization of premium  | 
|
| 
 Amount from above table for Dec 1, 2016  | 
 21347  | 
 3653  | 
| 
 Divided by 500000 face value of bond  | 
 500000  | 
 500000  | 
| 
 0.042694  | 
 0.007306  | 
|
| 
 Multiply by: 200000 Face value bond buy back before maturity  | 
 200000  | 
 200000  | 
| 
 Value for 200000 face value of bond  | 
 8539  | 
 1461  | 
| 
 Bond value on June 1, 2016 For face value of 500000  | 
 533664  | 
|
| 
 Bond value on June 1, 2016 For face value of 200000 (533664*200000/500000)  | 
 213466  | 
|
| 
 Less: amortization of bond for 4 month (1 Jun to 1 Oct)  | 
 974  | 
|
| 
 Book value of bond for face value of 200000  | 
 212492  | 
|
| 
 Less: cash paid for buy back of bond  | 
 210000  | 
|
| 
 Gain on retirement (Buy back) of bond  | 
 2492  | 
|