Loan Calculators
Free amortization-based loan spreadsheets for Excel® - Updated 3/10/2025
Vertex42 provides high quality free Excel-based loan calculators to both individuals and industry professionals. These can be used for auto loans, home equity loans, installment loans, credit lines, mortgages and general amortization-based loans. We believe that a strong basic financial education is the key to living within your means, avoiding bad debt, and becoming financially secure. We hope that our loan calculators can help you make better decisions and save money.
Advertisement
Featured Loan Calculators
Create and print a professionally formatted loan amortization schedule.
Understand what you are getting into before you buy! Figure out how much you'll need to finance and what type of loan will work best for you.
This is a general revolving line of credit calculator, useful for estimating and tracking payments on a Home Equity Line of Credit (HELOC).
For small businesses, lenders, or borrowers wanting to track draws, payments, and interest for a general line of credit.
Advertisement
Calculate the payment required to pay off an auto or mortgage loan in one big chunk after a number of regular payments have been made.
Use this for fixed-rate interest-only loans, with optional extra payments. The IO period is specified as a number of years, after which the loan amortizes over the remaining years.
A "Simple Interest Loan" or "Simple Interest Mortgage" is a special type of loan in which the interest accrues daily in a separate interest accrual account.
This calculator was designed based on the simple interest loan calculator above, but it involves daily compounding interest, and therefore negative amortization.
Need a second mortgage? This calculator can help answer the questions (a) How much can I borrow? (b) What will my monthly payment be? (c) How much equity will I have in N years?