FINANCIAL ACCOUNTING – Eleventh Edition Solutions Manual
Using the PV function in EXCEL, the issue price of the bonds is $1,145,203.
Req. 2 (amortization table)
Dec. 31, 2016 454,797 1,145,203
June 30, 2017 24,000 40,082 16,082 438,715 1,161,285
Dec. 31, 2017 24,000 40,645 16,645 422,070 1,177,930
1. Use the PV function in Excel to calculate the issue price of the bonds.
2. Using Exhibit 9-4 as a model, prepare a bond amortization table for the term of the
bonds.
3. Record issuance of the bonds payable on December 31, 2016; the first semiannual
interest payment on June 30, 2017; and the second payment on December 31, 2017.
Interest
Payment
(1.5% of
Maturity
Value)
Interest
Expense (3.5%
of Preceding
Bond Carrying
Amount)
Discount
Amortization
(B – A)
Discount
Account
Balance
(Preceding D
– C)
Bond
Carrying
Amount
($4,000,000 –
D)
Chapter 9: Liabilities Page 32 of 115
June 30, 2018 24,000 41,228 17,228 404,842 1,195,158
Dec. 31, 2018 24,000 41,831 17,831 387,012 1,212,988
Dec. 31, 2019 24,000 43,100 19,100 349,457 1,250,543
June 30, 2020 24,000 43,769 19,769 329,688 1,270,312
Dec. 31, 2020 24,000 44,461 20,461 309,227 1,290,773
June 30, 2021 24,000 45,177 21,177 288,050 1,311,950
Dec. 31, 2021 24,000 45,918 21,918 266,131 1,333,869
June 30, 2022 24,000 46,685 22,685 243,446 1,356,554
Dec. 31, 2022 24,000 47,479 23,479 219,967 1,380,033
June 30, 2023 24,000 48,301 24,301 195,665 1,404,335
Dec. 31, 2023 24,000 49,152 25,152 170,514 1,429,486
June 30, 2024 24,000 50,032 26,032 144,482 1,455,518
Dec. 31, 2024 24,000 50,943 26,943 117,539 1,482,461
June 30, 2025 24,000 51,886 27,886 89,652 1,510,348
Dec. 31, 2025 24,000 52,862 28,862 60,790 1,539,210
June 30, 2026 24,000 53,872 29,872 30,918 1,569,082