lease payment calculator

[xl-user]

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 !

[#2]

Hi!

You Can Solve this using SUM IF formula.

=SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ...)

[#3]

@xl-user 

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.

[#4]

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