- Excel Book Excerpt
Excel Calculate Many Scenarios for Loan Payments
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Calculate Many Scenarios
for Loan Payments
Problem: I am considering buying a car. I used “Calculate a Loan Payment” to calculate a loan payment. Now I want to do some what-if scenarios in order to see various options of increasing or decreasing the term or price. How can Excel help me with this?
Strategy: You follow the same setup described in “Calculate a Loan Payment.” Then you copy cells B1:B5 and plug in different numbers for the price and/or term.
Figure 331 Copy so that you can play what-if analyses.
This is an area where Excel shines. After you have entered the formulas for one loan model, you can easily copy and create many more loan models.
For more resources for Microsoft Excel: