B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1				This table displays data for a maximum of 40 interest payment periods. (All amounts rounded).
2				Beginning Balances		Data for journal entries				Data for journal entries		Ending Balances
3					Net bond liability (book or carrying value, or amortized cost), beginning of the period.	Debit Interest Expense A/C	Credit Cash A/C	Credit Bond Discount A/C	Net bond liability (amortized cost) either (a) at the end of each period or (b) on 31/7/2028, the retirement date.	Debit Bond Liability A/C	Credit Bond Discount A/C		Net bond liability (amortized cost), after retirement (if any) during the period, and prior to maturity.
4				Bond Discount A/C		3.0000% (=yield) interest expense per interest payment period.	2.0000% [4.0000%/2] interest payment per period.	Bond discount amortization.		Face value of the retired bonds.	Proportion of unamortized discount on the retired bonds.	Bond Discount A/C			This model does not generate an amortization table for situations where (i) the bonds are issued between interest payment dates AND (ii) the effective interest rate (yield) is not provided in the INPUT worksheet, AND (iii) the INPUT worksheet specifies the effective-interest-rate method.
5
6						A4 = A3 x 3.0000% (See Notes below this table for period 1's $31,921 calculation)	$25,000 in period 1 does not include repayment by the company of the $5,000 interest accrued on April 01, 2025, the date of issuance ($25,000 + $5,000 = $30,000)		A7 = A3 + A6 (See Notes below this table for period 1's $1,285,143 calculation)		See Notes below this table for the calculation of $64,471 on July 31, 2028	A10 = A2 - A6 - A9	A11= A7 - A8 + A9
7	Date at beginning of period	Date at end of period	Period					A6 = A4 - A5		$600,000 = $1,500,000 x 40.0000% retired.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48			Totals
49
50
51	NOTES:
52
53
54
55
56
57				RETIREMENT PERIOD: please refer to the Retirement worksheet for the following calculation: $64,471= $169,441 x 40.00% (unamortized at beginning of March 02, 2028) - $3,306 [$3,306 = ($1,330,559 x 3.000000% yield x 5/6 x 40.00%) - ($1,500,000 x 2.0000% interest paid x 5/6 x 40.00%) amortization, March 01, 2028 to July 31, 2028 on the 40.00% retired)]. March 01, 2028 is the closest preceding interest payment date to the date of retirement. [This is 5 months before 31/7/2028, the date of retirement].
58
59				Please refer to the Retirement worksheet for details of the bond discount amortization in the semi-annual interest payment period in which the retirement takes place.
60
61				PERIOD 1: $1,285,143 = $429,714 + $855,429 = The present value of the bond's future interest payments and maturity value, respectively, at September 01, 2025 (the end of the first semi-annual interest payment period) using 3.00% yield per period.
62
63				$31,921 = ($1,285,143 - $1,278,222) + $25,000 = $6,921 + $25,000. Here we use the amount of the amortization between the bond's carrying amount (a) at the end of period 1 and (b) at the issuance date, and the interest paid at the end of period 1 to help us calculate period 1's interest expense.
64
65
66	BondBeagle Copyright (c) Brian Conheady. All Rights Reserved.
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95