Vertex42 provides high quality free Excel-based loan calculators to both individuals and industry professionals. 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.


Featured Loan Calculators


Amortization ScheduleLoan Amortization

Create a professional loan amortization schedule for fixed-rate loans.


Auto Loan CalculatorAuto Loan Calculator

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.


Line of Credit CalculatorLine of Credit Calculator

This is a general revolving line of credit calculator, useful for estimating and tracking payments on a Home Equity Line of Credit (HELOC).


Line of Credit TrackerLine of Credit Tracker

Instead of making estimations (like the Line Of Credit calculator above), this spreadsheet is designed for lenders or borrows to track or service a line of credit account. You enter draws and payments or changes in interest rate on the actual dates they occur.


Balloon Loan CalculatorBalloon Loan Calculator

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.


Interest-Only Loan CalculatorInterest-Only Loan Calculator

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.


Simple Interest Loan CalculatorSimple Interest Loan Calculator

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.


Daily Compounding Loan CalculatorDaily Compounding Loan Calculator

This calculator was designed based on the simple interest loan calculator above, but it involves daily compounding interest, and therefore negative amortization.


Home Equity Loan CalculatorHome Equity Loan Calculator

This is the ultimate "second-mortgage" calculator. Hopefully, you'll never need to use it. It 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?

More Loan Calculators

Follow Us On ...

Browse Template Categories