Forum Discussion

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

SergeiBaklan

Diamond Contributor

Sep 28, 2019

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.