Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Rate
3.00% 2.80% 3.20%
1
2
3
4
A B C D E
Kelly’s Boutique
Loan Amortization Schedule
Loan Amount
425,000.00$
Student Name 3/6/2023 ch5-05_student_name.xlsx
5
6
7
8
9
Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Market_Rate
3.50% 2.90% 3.80%
Stated_Rate 3.00% 2.00% 4.00%
1
2
3
4
5
11
12
13
14
15
16
17
18
2 12,750.00$ 14,601.81$ (1,851.81)$ (5,953.48)$ 419,046.52$
3 12,750.00$ 14,666.63$ (1,916.63)$ (4,036.85)$ 420,963.15$
4 12,750.00$ 14,733.71$ (1,983.71)$ (2,053.14)$ 422,946.86$
5 12,750.00$ 14,803.14$ (2,053.14)$ (0.00)$ 425,000.00$
A B C D E F
Kelly’s Boutique
Bond Amortization Schedule
Market Rate
3.50%
Stated Rate
3.00%
Payment #
Interest
Payment
Interest
Expense
Amortization
(Discount)
Premium
Carrying
Value
(9,594.49)$ 415,405.51$
1 12,750.00$ 14,539.19$ (1,789.19)$ (7,805.29)$ 417,194.71$
6
7
8
9
10