Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Rate
3.00% 2.50% 3.50%
Loan_Amount 500,000.00$ 550,000.00$ 450,000.00$
Result Cells:
1
2
3
4
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
4 43,725.74$ 2,843.78$ 40,881.96$ 338,289.13$
5 43,725.74$ 2,537.17$ 41,188.57$ 297,100.56$
6 43,725.74$ 2,228.25$ 41,497.48$ 255,603.07$
7 43,725.74$ 1,917.02$ 41,808.72$ 213,794.36$
8 43,725.74$ 1,603.46$ 42,122.28$ 171,672.08$
9 43,725.74$ 1,287.54$ 42,438.20$ 129,233.88$
A B C D E
Wine Depot
Loan Amortization Schedule
Rate
3.00%
Payment # Payment Interest Principal Balance
500,000.00$
1 43,725.74$ 3,750.00$ 39,975.74$ 460,024.26$
2 43,725.74$ 3,450.18$ 40,275.56$ 419,748.71$
3 43,725.74$ 3,148.12$ 40,577.62$ 379,171.08$
Student Name 3/6/2023 ch5-06_student_name.xlsx
5
6
7
Scenario Summary
Current Values: Best Case Worst Case
Changing Cells:
Stated_Rate
3.00% 2.00% 3.90%
Market_Rate 3.50% 2.90% 4.00%
1
2
3
4
5
12
13
14
15
16
17
18
19
20
21
22
23
24
25
4 3,750.00$ 4,327.87$ (577.87)$ (4,808.73)$ 495,191.27$
5 3,750.00$ 4,332.92$ (582.92)$ (4,225.81)$ 495,774.19$
6 3,750.00$ 4,338.02$ (588.02)$ (3,637.78)$ 496,362.22$
7 3,750.00$ 4,343.17$ (593.17)$ (3,044.61)$ 496,955.39$
8 3,750.00$ 4,348.36$ (598.36)$ (2,446.26)$ 497,553.74$
9 3,750.00$ 4,353.60$ (603.60)$ (1,842.66)$ 498,157.34$
A B C D E F
Wine Depot
Bond Amortization Schedule
Stated Rate
3.00%
Market Rate
3.50%
Payment #
Interest Payment
Interest
Expense
Amortization
(Discount)
Premium
Carrying
Value
(7,090.30)$ 492,909.70$
1 3,750.00$ 4,312.96$ (562.96)$ (6,527.34)$ 493,472.66$
2 3,750.00$ 4,317.89$ (567.89)$ (5,959.45)$ 494,040.55$
3 3,750.00$ 4,322.85$ (572.85)$ (5,386.60)$ 494,613.40$
6
7
8
9
10
11