The Home Category The Home: family money matters

How to create a schedule of capital lease payments

People come across variations of a capital lease all the time, in their car loan or mortgage agreement, but often are unaware of how much money per month actually goes to principal payments as compared to interest payments. A capital lease payment schedule solves that.

To be more specific, according to BusinessDictionary a capital lease is a " that is similar to a loan agreement for purchase of a capital asset on installments...Capital leases are regarded as essentially equivalent to a sale by the lessor, and a purchase by the lessee." Microsoft Excel can create a beautiful capital lease schedule for you in minutes.

Open Microsoft Excel 2007.

Go to 'File' and click new.

Click on 'Installed Templates'.

Look for and select the 'Loan Amortization' template and click create.

Enter the value of the asset being leased in the 'Loan amount' cell.

Enter the annual interest rate in the respective cell.

Enter the number of years for the lease in the 'Loan period in years'.

Enter the number of payments per year in the respective cell followed by the start date of the loan.

Test for accuracy. For a piece of machinery that costs £325,000 that will be purchased with a 10-year lease agreement an interest rate of 10% per annum, and one payment per year, the total annual payment should be equal to £52,892.2.


While the amortisation template in Excel 2007 is spreadsheet beautiful there are several amortisation calculators online that can also be used.


One of the most common areas that is overlooked is the number of payments per year. If its monthly, put in 12 or semi-annual, put in 2. This difference can easily throw out the formula.

Things Needed

  • Microsoft Excel 2007