Excel: Calculate Many Scenarios for Loan Payments

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


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.

  1. 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.