FINANCIAL ACCOUNTING – Eleventh Edition Solutions Manual
Using the PV function in EXCEL, the issue price of the bonds is $3,840,363.
Req. 2 (amortization table)
Dec. 31, 2016 159,637 3,840,363
June 30, 2017 80,000 86,408 6,408 153,229 3,846,771
Dec. 31, 2017 80,000 86,552 6,552 146,676 3,853,324
June 30, 2018 80,000 86,700 6,700 139,977 3,860,023
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
(2% of
Maturity
Value)
Interest
Expense
(2.25% 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 52 of 115
Dec. 31, 2018 80,000 86,851 6,851 133,126 3,866,874
June 30, 2019 80,000 87,005 7,005 126,122 3,873,878
Dec. 31, 2019 80,000 87,162 7,162 118,959 3,881,041
June 30, 2020 80,000 87,323 7,323 111,636 3,888,364
Dec. 31, 2020 80,000 87,488 7,488 104,148 3,895,852
June 30, 2021 80,000 87,657 7,657 96,491 3,903,509
Dec. 31, 2021 80,000 87,829 7,829 88,662 3,911,338
June 30, 2022 80,000 88,005 8,005 80,657 3,919,343
Dec. 31, 2022 80,000 88,185 8,185 72,472 3,927,528
June 30, 2023 80,000 88,369 8,369 64,102 3,935,898
Dec. 31, 2023 80,000 88,558 8,558 55,545 3,944,455
June 30, 2024 80,000 88,750 8,750 46,794 3,953,206
Dec. 31, 2024 80,000 88,947 8,947 37,847 3,962,153
June 30, 2025 80,000 89,148 9,148 28,699 3,971,301
Dec. 31, 2025 80,000 89,354 9,354 19,345 3,980,655
June 30, 2026 80,000 89,565 9,565 9,780 3,990,220
Dec. 31, 2026 80,000 89,780 9,780 0 4,000,000