Loan Calculator & Amortization Schedule

Free download

See the true cost of any loan — payment, payoff date and total interest — before you sign.

Preview of the FundMil Loan Calculator and Amortization Schedule spreadsheet

Features

  • Monthly payment, total interest and total cost of the loan, updated as you type
  • A full month-by-month amortization schedule for loans up to 30 years (360 payments)
  • Add an extra monthly payment and see the new payoff date and the interest you save
  • Works for car loans, personal loans, business loans and fixed-rate mortgages

How to use it

  1. Enter the amount, APR, term in months and first payment date
  2. Read your payment, total interest and payoff date in the results box
  3. Open the Amortization Schedule tab to see every payment split into interest and principal

Format: Excel (.xlsx — also opens in Google Sheets) + printable PDF

Prefer a web tool? Browse FundMil's free calculators

Email only — no account, no card. Subscribing adds you to The Mil Daily, our free newsletter, and unlocks the download buttons right here. See our Privacy Policy.

More free tools

  • DSCR Calculator

    Find out whether a property or business earns enough to cover its loan payments — the way a lender looks at it.

  • SBA Loan Application Checklist

    Every document lenders commonly ask for on an SBA 7(a) application — in one checklist you can tick off.

  • Business Debt Schedule

    Every business loan, card and credit line on one page — the exact schedule lenders ask for.

← All free tools & templates

Sponsored

Sponsored

Sponsorship space available

Your sponsorship here — clearly labelled, always. FundMil never sells editorial conclusions.

Explore FundMil