Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Loan_Amount
100,000.00$ 125,000.00$ 90,000.00$
Rate 10.00% 9.00% 11.00%
Result Cells:
Rosey’s Roses
Loan Amortization Schedule
Loan Amount
100,000.00$ Pmt. # Payment Interest Principal Balance
Rate
10.00% 100,000.00$
Loan Term
10 1 16,274.54$ 10,000.00$ 6,274.54$ 93,725.46$
Payment
$16,274.54 2 16,274.54$ 9,372.55$ 6,901.99$ 86,823.47$
3 16,274.54$ 8,682.35$ 7,592.19$ 79,231.27$
Student Name 3/6/2023 ch5-08_student_name.xlsx
4 16,274.54$ 7,923.13$ 8,351.41$ 70,879.86$
5 16,274.54$ 7,087.99$ 9,186.55$ 61,693.31$
6 16,274.54$ 6,169.33$ 10,105.21$ 51,588.10$
7 16,274.54$ 5,158.81$ 11,115.73$ 40,472.37$
8 16,274.54$ 4,047.24$ 12,227.30$ 28,245.07$
9 16,274.54$ 2,824.51$ 13,450.03$ 14,795.04$
Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Market_Rate
9.00% 8.00% 10.00%
Rosey’s Roses
Bond Amortization Schedule
Market Rate
9.00%
Stated Rate
10.00%
Payment #
Interest
Payment
Interest
Expense
Amortization
(Discount)
Premium
Carrying
Value
6,417.66$ 106,417.66$
1 10,000.00$ 9,577.59$ 422.41$ 5,995.25$ 105,995.25$
2 10,000.00$ 9,539.57$ 460.43$ 5,534.82$ 105,534.82$
3 10,000.00$ 9,498.13$ 501.87$ 5,032.95$ 105,032.95$
4 10,000.00$ 9,452.97$ 547.03$ 4,485.92$ 104,485.92$
5 10,000.00$ 9,403.73$ 596.27$ 3,889.65$ 103,889.65$
6 10,000.00$ 9,350.07$ 649.93$ 3,239.72$ 103,239.72$
7 10,000.00$ 9,291.57$ 708.43$ 2,531.29$ 102,531.29$
8 10,000.00$ 9,227.82$ 772.18$ 1,759.11$ 101,759.11$
9 10,000.00$ 9,158.32$ 841.68$ 917.43$ 100,917.43$