Scribd
Upload
46 views3 pages

Scenario Summary: Changing Cells

The document outlines different scenarios for a home loan by varying the loan term (240 or 360 months) and interest rate (13%, 13.5%, or 14%). It provides the current values, changing cells, and resulting loan amount, monthly payment, total payments, and total interest for each scenario. Notes indicate the current values column represents the baseline and changing cells are highlighted in gray.

Uploaded by

Mohammed Zubair
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
46 views3 pages

Scenario Summary: Changing Cells

The document outlines different scenarios for a home loan by varying the loan term (240 or 360 months) and interest rate (13%, 13.5%, or 14%). It provides the current values, changing cells, and resulting loan amount, monthly payment, total payments, and total interest for each scenario. Notes indicate the current values column represents the baseline and changing cells are highlighted in gray.

Uploaded by

Mohammed Zubair
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 3

Scenario Summary

Current Values:

case1

case2

Changing Cells:
$B$4
240
360
240
$B$5
13%
13%
14%
Result Cells:
$B$8
604,800
604,800
604,800
$B$9
7,086
6,690
7,302
$B$10
1,700,566
2,408,506
1,752,528
$B$11
1,095,766
1,803,706
1,147,728
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.

case3

case4

360
14%

240
14%

604,800
6,927
2,493,883
1,889,083

604,800
7,521
1,804,995
1,200,195

case5

360
14%
604,800
7,166
2,579,798
1,974,998

Input Cells
Purchase Price
Down Payment
Loan Term(Months)
Interest Rate

create a scenario for the following data


756000
20%
240
13%

Result Cells
Loan Amount
Monthly Payment
Total Payments
Total Interest

604,800
7,086
1,700,566
1,095,766

Loan Term Interest Rate


360
13%
240
13.50%
360
13.50%
240
14%
360

14%

240
360

14.50%
14.50%

You might also like