Loan Calculators

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 for Excel

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

Home Equity Loan Calculator The ultimate "second-mortgage" calculator. Hopefully, you'll never need to use it! (a) How much can I borrow? (b) What will my monthly payment be? (c) How much equity will I have in N years?

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

Balloon Loan Calculator Calculates 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 Calculator For fixed-rate interest-only loans, with optional extra payments. IO period is specified as a number of years after which the loan amortizes over the remaining years.

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