1. Money
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Loan Calculator

How to Use the Excel Loan Calculator


Family lifestyle
Nick David/ Taxi/ Getty images

Running numbers is easy with an Excel loan calculator. Microsoft Excel includes built-in tools and formulas so you can get information quickly. The Excel loan calculator shows all the details about your loan, and helps you figure out how to repay it early.

Creating an Excel Loan Calculator

The steps to create a calculator depend on your version of Excel, but the steps below will more or less get you there.

  1. In Excel, right-click on the tab of sheets at the bottom ('Sheet1, Sheet2, etc').
  2. Select 'Insert'
  3. In the popup box, choose the 'Spreadsheet Solutions' tab
  4. Double-click the 'Loan Amortization' option
You can also use the File menu and click 'New...' Then, look for Templates 'On my computer...' (it might also be in 'Sample Templates').

Using the Excel Loan Calculator

Plug your loan’s information into the box that says 'Enter Values'. You’ll see basic details in the box titled 'Loan Summary'. More information on each payment appears in an amortization table below.

What-if Scenarios

An Excel loan calculator makes it easy to see how things (such as your payment) would change if you change the interest rate. Just change one of the values and the rest of the spreadsheet will update instantly.

You can also see what happens if you pay more than your minimum payment. By paying a little extra, you’ll save on interest costs and pay the loan off early.

Using Excel Loan Calculator Data

Suppose you want to copy, paste, slice, and dice the date from Excel’s loan calculator. Is it possible? Only if you tell Excel to unprotect the spreadsheet. Go to the 'Tools' menu and select 'Protection', then 'Unprotect Sheet'.

After you do this, you can move the data elsewhere or add your own calculations alongside Excel’s calculations.

  1. About.com
  2. Money
  3. Banking / Loans
  4. Calculators
  5. Excel Loan Calculator

©2014 About.com. All rights reserved.