In: Accounting
Prepare an amortization schedule for the 1st and 2nd years (effective interest method) using the following data:
1. On January 1, 2010 XYZ Co. issued $3,000,000, 6%, 10 year bonds, interest payable on June 30th and December 31st to yield 5%. Use the following format and round to the nearest dollar (may have small rounding error). The bonds were issued for $3,233,834.
Date Cash paid Interest expense Amortization Bond Carry Value
2. Show how this bond would be reported on the balance sheet on 12/31/11.
| 1) | |||||||
| Amortization Schedule: | |||||||
| Date | Cash Paid | Interest Expense | Amortization | Bonds Carrying Value | |||
| January 1, 2010 | $ 32,33,834 | ||||||
| June 30, 2010 | $ 90,000 | $ 80,846 | $ 9,154 | $ 32,24,680 | |||
| December 31, 2010 | $ 90,000 | $ 80,617 | $ 9,383 | $ 32,15,297 | |||
| June 30, 2011 | $ 90,000 | $ 80,382 | $ 9,618 | $ 32,05,679 | |||
| December 31, 2011 | $ 90,000 | $ 80,142 | $ 9,858 | $ 31,95,821 | |||
| Working: | |||||||
| Semi annual cash paid | = | Par Value x Semi Annual Coupon Interest | |||||
| = | $ 30,00,000 | x | 3% | ||||
| = | $ 90,000 | ||||||
| Semi annual Interest expense | = | Beginning Book Value x Semi annual yield | |||||
| = | $ 32,33,834 | x | 2.50% | ||||
| = | $ 80,846 | ||||||
| 2) | |||||||
| Balance Sheet | |||||||
| on 12/31/11 | |||||||
| (Partial) | |||||||
| Non-Current Liabilities: | |||||||
| Bonds Payable | $ 30,00,000 | ||||||
| Add:Premium on bonds payable | $ 1,95,821 | ||||||
| Bonds Carrying Value | $ 31,95,821 | ||||||