Most valuable professional
  • 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.

LE10000310.jpg 

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.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: