Most of the loan calculators you find on this website are developed using a MS Excel spreadsheet. The same has been converted into a webpage and then embedded here using special tools. These online calculators only provide you a basic understanding about your mortgages.
In case you are interested in more detailed analysis and graphs, we encourage you to download the specialized spreadsheets given on this page. You will need to open these files using MS Excel to get the detailed insight into your loan conditions. Click on the links given below to download the MS Excel Loan Calculators now. You might be taken to a new page, where you can download the excel spreadsheet.
Some of these spreadsheets may be original work of their respective creators. The copyright may belong to the original creator.
Home Loan and Mortgage Calculators
Versatile Home Loan Calculator
This versatile spreadsheet analyzes a fixed or variable rate home loan. You can also enter periodic extra payments, or add additional payments manually. It can compare different term lengths, rates, loan amounts, and the savings from making extra payments. It also calculates the outstanding balance at the end of a specified number of years and the tax returned if the interest paid is tax deductible.Download
Loan Affordability Calculator
This Loan Affordaibility Calculator will calculate the amount for which you are qualified for the loan. It will depend upon your current incomes, expenses and two ratios named as Housing cost ratio and Debt service ratio.Download
Home Equity Calculator
Home Equity is the difference between the home’s fair market value and the outstanding balance of allliens on the property. It is used by lenders to understand your qualification for borrowing. This versatile home loan equity calculator will give all details of your home equity.Download
ARM – Adjustable Rate Loan Calculator
ARM Loans are great when interest rates are falling. Take their advantage to reduce your monthly payments and get qualified for higher loan amounts. This MS Excel worksheet will calculate details of your Loan in adjustable rate scenario.Download
Loan Early Payoff Calculator
Got some surplus money? May be a good idea to increase monthly payments to reduce the loan term and make serious savings. This calculator will allow you to enter additional amounts as and when available with you and will calculate the savings in interest, total payments and loan terms.Download
Balloon Payment Loan Calculator
Balloon Payments are useful when you commit to repay a significant portion of principal back at a future date. Go for them when you expect to receive large money somehow; may be a tax refund, an inherited property or something like that.Download
Extra Payment Loan Calculator
Got some surplus money? This calculator will calculate how early you can payoff your moan, you commit to pay some additional monthly payment for serving your loan. The information is presented in a comprehensive yet easy to understand manner and in full details.Download
Interest Only Home Loan Calculator
This spreadsheet creates an amortization schedule for a fixed-rate loan, with optional extra payments and an optional interest-only period. The payment frequency can be annual, semi-annual, quarterly, bi-monthly, monthly, semi-monthly, bi-weekly, or weekly.Download
Auto Loan Calculators
Auto Loan Calculator
This spreadsheet analyzes your auto loan in great details. Featuring graphs and diagrams, this will give the comprehensive insight in full details. Unless otherwise indicated, the comparison tables are based on the Loan Amount, Interest Rate, Term, and Frequency listed to the right. These values can be changed in the PaymentCalculator worksheet.
Auto Lease Calculator
‘Leasing doesn’t always make sense and you need to know the full details of your lease conditions before making a leasing decision. This MS Excel Auto Lease calculator will give you great insights into your auto lease offer and let you make the perfect decision.
Buy vs. Lease Calculator
As with most financial decisions, there are certain advantages and disadvantages of both leasing and buying decisions. You have to make a choice among them before taking the final call. This detailed lease vs. buy calculator will let you analyze the two choices in great details.
Buy vs. Rent Calculator
Did you know that yet another useful option is renting a car instead of leasing or buying it. But make your calculations before arriving at the decision of buying vs. owning vs. renting. This MS Excel Buy vs. Rent calculator will analyze your offers and help you make a decision.