Bonds - Excel Project
Instructions: You must complete your work in Excel using formulas. Please submit your Excel file as an attachment to the link provided in the classroom.
Bond interest and discount amortization.
BU Curriculum Corporation issued $900,000 of 7% bonds on October 1, 2016, due on October 1, 2021. The interest is to be paid twice a year on April 1 and October 1. The bonds were sold to yield 9% effective annual interest. BU Curriculum Corporation closes its books annually on December 31.
Instructions
(a) Complete an amortization schedule for the above bond (for all periods) in a similar format as below. (Round all answers to the nearest dollar.) Use the effective-interest method.
|
Date
|
Credit
Cash
|
Debit
Interest Expense
|
Credit
Bond Discount
|
Carrying Amount of Bonds
|
|
Oct. 1, 2016
|
|
|
|
Use the PV formula in Excel; see posted bond excel sheet in the classroom
|
|
Apr. 1, 2017
....continue schedule (use Excel)
|
|
|
|
|
(b) Prepare the journal entries for the following:
1. October 1, 2016 bond issue
2. Adjusting entry for December 31, 2016 (adjusting entry should cover 2 months)
3. April 1, 2017 entry
4. October 1, 2017 entry
5. Adjusting entry from December 31, 2017
(c) Compute the interest expense to be reported in the income statement for the year ended December 31, 2016 and December 31, 2017.
(d) Complete an amortization schedule for the above bond (for all periods) using the straight-line amortization method (entries are not required).