Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Rate
6.00% 5.00% 7.00%
Loan_Amount 65,000.00$ 75,000.00$ 60,000.00$
1
2
3
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
7 2,880.84$ 247.36$ 2,633.48$ 46,838.51$
8 2,880.84$ 234.19$ 2,646.65$ 44,191.86$
9 2,880.84$ 220.96$ 2,659.88$ 41,531.98$
10 2,880.84$ 207.66$ 2,673.18$ 38,858.80$
11 2,880.84$ 194.29$ 2,686.55$ 36,172.26$
12 2,880.84$ 180.86$ 2,699.98$ 33,472.28$
13 2,880.84$ 167.36$ 2,713.48$ 30,758.80$
14 2,880.84$ 153.79$ 2,727.05$ 28,031.76$
26
27
28
29
30
31
32
33
34
35
19 2,880.84$ 84.93$ 2,795.91$ 14,190.63$
20 2,880.84$ 70.95$ 2,809.89$ 11,380.74$
21 2,880.84$ 56.90$ 2,823.94$ 8,556.81$
22 2,880.84$ 42.78$ 2,838.06$ 5,718.75$
23 2,880.84$ 28.59$ 2,852.25$ 2,866.51$
24 2,880.84$ 14.33$ 2,866.51$ 0.00$
A B C D E
Snick’s Board Shop
Loan Amortization Schedule
Payment # Payment Interest Principal Balance
65,000.00$
1 2,880.84$ 325.00$ 2,555.84$ 62,444.16$
2 2,880.84$ 312.22$ 2,568.62$ 59,875.54$
3 2,880.84$ 299.38$ 2,581.46$ 57,294.08$
4 2,880.84$ 286.47$ 2,594.37$ 54,699.71$
5 2,880.84$ 273.50$ 2,607.34$ 52,092.37$
6 2,880.84$ 260.46$ 2,620.38$ 49,471.99$
15 2,880.84$ 140.16$ 2,740.68$ 25,291.08$
16 2,880.84$ 126.46$ 2,754.38$ 22,536.69$
17 2,880.84$ 112.68$ 2,768.16$ 19,768.54$
18 2,880.84$ 98.84$ 2,782.00$ 16,986.54$
4
5
6
7
Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Stated_Rate
6.00% 5.00% 7.00%
Market_Rate 5.50% 4.00% 7.50%
1
2
3
4
5
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
5 325.00$ 300.28$ 24.72$ 491.74$ 65,491.74$
6 325.00$ 300.17$ 24.83$ 466.91$ 65,466.91$
7 325.00$ 300.06$ 24.94$ 441.96$ 65,441.96$
8 325.00$ 299.94$ 25.06$ 416.91$ 65,416.91$
9 325.00$ 299.83$ 25.17$ 391.73$ 65,391.73$
10 325.00$ 299.71$ 25.29$ 366.45$ 65,366.45$
11 325.00$ 299.60$ 25.40$ 341.04$ 65,341.04$
12 325.00$ 299.48$ 25.52$ 315.52$ 65,315.52$
13 325.00$ 299.36$ 25.64$ 289.88$ 65,289.88$
14 325.00$ 299.25$ 25.75$ 264.13$ 65,264.13$
15 325.00$ 299.13$ 25.87$ 238.26$ 65,238.26$
16 325.00$ 299.01$ 25.99$ 212.27$ 65,212.27$
30
31
32
33
34
35
36
37
22 325.00$ 298.29$ 26.71$ 53.80$ 65,053.80$
23 325.00$ 298.16$ 26.84$ 26.96$ 65,026.96$
24 325.00$ 298.04$ 26.96$ 0.00$ 65,000.00$
A B C D E F
Snick’s Board Shop
Bond Amortization Schedule
Face Value
65,000.00$
Stated Rate
6.00%
Payment #
Interest
Payment
Interest
Expense
Amortization
(Discount)
Premium
Carrying
Value
614.20$ 65,614.20$
1 325.00$ 300.73$ 24.27$ 589.93$ 65,589.93$
2 325.00$ 300.62$ 24.38$ 565.55$ 65,565.55$
3 325.00$ 300.51$ 24.49$ 541.06$ 65,541.06$
4 325.00$ 300.40$ 24.60$ 516.45$ 65,516.45$
17 325.00$ 298.89$ 26.11$ 186.15$ 65,186.15$
18 325.00$ 298.77$ 26.23$ 159.92$ 65,159.92$
19 325.00$ 298.65$ 26.35$ 133.57$ 65,133.57$
20 325.00$ 298.53$ 26.47$ 107.10$ 65,107.10$
21 325.00$ 298.41$ 26.59$ 80.51$ 65,080.51$
6
7
8
9
10
11
5.50%