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.


For more resources for Microsoft Excel