Scenario Summary
Current Values: 1 2 3 4
Changing Cells:
Stated_Rate
4.00% 3.00% 3.50% 4.50% 6.00%
Result Cells:
1
2
3
11
12
13
14
15
16
17
18
19
20
21
22
23
3 $100,000.00 $116,920.98 ($16,920.98) ($144,659.33) $2,355,340.67
4 $100,000.00 $117,767.03 ($17,767.03) ($126,892.30) $2,373,107.70
5 $100,000.00 $118,655.38 ($18,655.38) ($108,236.92) $2,391,763.08
6 $100,000.00 $119,588.15 ($19,588.15) ($88,648.76) $2,411,351.24
7 $100,000.00 $120,567.56 ($20,567.56) ($68,081.20) $2,431,918.80
8 $100,000.00 $121,595.94 ($21,595.94) ($46,485.26) $2,453,514.74
9 $100,000.00 $122,675.74 ($22,675.74) ($23,809.52) $2,476,190.48
A B C D E F
What SUP, Inc.
Bond Amortization Schedule
Payment #
Interest Payment Interest Expense Amortization (Discount) Premium Carrying Value
($193,043.37) $2,306,956.63
1 $100,000.00 $115,347.83 ($15,347.83) ($177,695.54) $2,322,304.46
2 $100,000.00 $116,115.22 ($16,115.22) ($161,580.32) $2,338,419.68
Student Name 3/6/2023 ch5-04_student_name.xlsx
4
5
6
7
8
9
10