In: Accounting
A | B | C | D | E | F | G | H |
2 | |||||||
3 | a) | ||||||
4 | Face Value of the Bond | $1,000,000 | |||||
5 | Bonds issued at | $1,030,000 | |||||
6 | Coupon (Semi-Annual) | 5% | |||||
7 | Semi-Annual coupon payment | $25,000 | |||||
8 | Period (years) | 5 | |||||
9 | Number of semiannual Period | 10 | |||||
10 | Semi-annual effective interest rate | 2.16% | =RATE(D9,D7,-D5,D4) | ||||
11 | |||||||
12 | Amortization Table | ||||||
13 | Year | Cash Paid (@2.5% of face value) | Interest Expense (@2.16% of BV) | Decrease in carrying value | Carrying Value | ||
14 | 1/1/2019 | $ 1,030,000.00 | |||||
15 | 6/30/2019 | $25,000 | $ 22,280.58 | $ 2,719.42 | $ 1,027,280.58 | =G14-F15 | |
16 | 1/1/2020 | $25,000 | $ 22,221.75 | $ 2,778.25 | $ 1,024,502.33 | ||
17 | 6/30/2020 | $25,000 | $ 22,161.65 | $ 2,838.35 | $ 1,021,663.99 | ||
18 | 1/1/2021 | $25,000 | $ 22,100.26 | $ 2,899.74 | $ 1,018,764.24 | ||
19 | 6/30/2021 | $25,000 | $ 22,037.53 | $ 2,962.47 | $ 1,015,801.77 | ||
20 | 1/1/2022 | $25,000 | $ 21,973.45 | $ 3,026.55 | $ 1,012,775.22 | ||
21 | 6/30/2022 | $25,000 | $ 21,907.98 | $ 3,092.02 | $ 1,009,683.20 | ||
22 | 1/1/2023 | $25,000 | $ 21,841.09 | $ 3,158.91 | $ 1,006,524.29 | ||
23 | 6/30/2023 | $25,000 | $ 21,772.76 | $ 3,227.24 | $ 1,003,297.05 | ||
24 | 1/1/2024 | $25,000 | $ 21,702.95 | $ 3,297.05 | $ 1,000,000.00 | ||
25 | |||||||
26 | b) | ||||||
27 | Journal Entry at the time of sale: | ||||||
28 | Date | Journal Entry | Debit | Credit | |||
29 | 1/1/2019 | Cash | $1,030,000 | ||||
30 | Premium on Bonds Payable | $30,000 | |||||
31 | Bonds Payable | $1,000,000 | |||||
32 | |||||||
33 | c) | ||||||
34 | Journal entry for first interest payment: | ||||||
35 | 6/30/2019 | Interest Expense | $ 22,280.58 | ||||
36 | Premium on Bonds Payable | $ 2,719.42 | |||||
37 | Cash | $25,000 | |||||
38 |
Formula sheet