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
Create a professional loan amortization schedule for fixed-rate loans.
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).
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.
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.
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?