How to create a schedule of capital lease payments

Written by doyl smith
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to create a schedule of capital lease payments
Using Microsoft Excel is one of the best ways to calculate lease payments. (keyboard image by red 2000 from

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.

Skill level:

Things you need

  • Microsoft Excel 2007

Show MoreHide


  1. 1

    Open Microsoft Excel 2007.

  2. 2

    Go to 'File' and click new.

  3. 3

    Click on 'Installed Templates'.

  4. 4

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

  5. 5

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

    How to create a schedule of capital lease payments
    A capital lease is an excellent way for a business to acquire equipment without paying the entire upfront cost. (chenille image by Emmanuel Bergère from
  6. 6

    Enter the annual interest rate in the respective cell.

  7. 7

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

  8. 8

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

  9. 9

    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.

Tips and warnings

  • 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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.