Monthly Lease Payment Calculator Instructions. The Excel monthly lease payment calculator, available for download below, computes the monthly lease payment by entering details relating to the cost and residual value of the asset, the lease interest rate, and the number of payments and advance payments required by the lease agreement.

How to Calculate a Lease Payment A lease is a method of financing the use of an asset and is an agreement between a lessee (who rents the asset), and a lessor (who owns the asset). The lessor is usually a lease company or finance company.

Car Lease Calculator Explanation. A lease calculator is important when leasing a car for a number of reasons. First, it allows consumers to verify the correctness of a car dealer’s math in a lease offer or lease contract. We are often asked what’s wrong with our calculator when the results don’t match a dealer’s.

Using the Operating Lease Calculator. The Excel operating lease calculator, available for download below, calculates the operating lease payments for up to twenty four different assets by entering details relating to the asset and the operating lease, and is used as follows: Enter the asset description, quantity and unit cost. For each asset.

Lease Calculator. The Lease Calculator can be used to calculate the monthly payment or the effective interest rate on a lease. If the interest rate is known, use the "Fixed Rate" tab to calculate the monthly payment. If the monthly payment is known, use the "Fixed Pay" tab to calculate the effective interest rate.

Here are the steps to follow to calculate the present value of lease payments using Excel when the payment amounts are different. Let’s use an example: Calculate the present value of lease payments for a 10-year lease with annual payments of \$1,000 with 5% escalations annually, paid in advance. Assume the rate inherent in the lease is 6%.