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.