Forum Discussion
xl-user
Sep 27, 2019Copper Contributor
lease payment calculator
I want to set up an excel file that calculates the payment per month on a Fair Market Value lease. Can somebody please direct me to a function in excel. Thanks !
3 Replies
- tauqeeracmaSteel Contributor
Hi xl-user
In order to calculate monthly lease payments in excel, you can use PMT(rate, nper, pv, [fv], [type])
function.
For more specific solution you need to share sample data with complete parameters.
Thanks
Tauqeer
- SergeiBaklanDiamond Contributor
In Excel two built-in functions, Future Value FV() and Present Value PV() https://support.office.com/en-us/article/pv-function-23879d31-0e02-4321-be01-da16e8168cbd. Perhaps the latest one is more close to FMV lease.
- vigneshasokan7Copper Contributor
Hi!
You Can Solve this using SUM IF formula.
=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)