Forum Discussion

xl-user's avatar
xl-user
Copper Contributor
Sep 27, 2019

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 !  
Need Help
tauqeeracma's avatar
tauqeeracma
Steel Contributor
Sep 28, 2019

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