Calculate Many Scenarios for Loan Payments
February 07, 2022 - by Bill Jelen
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.
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.
This article is an excerpt from Power Excel With MrExcel
