Download Your Own Excel Reverse Mortgage Calculator (for Free!)
Quickly and easily estimate reverse mortgage proceeds with this free Excel reverse mortgage calculator.
Enter your Name and email address below and click 'Download'.
We hate spam as much as you do! We won't give your email address to anybody else. We'll send you updates from time to time, but you can unsubscribe at any time. The downloadable reverse mortgage calculator requires Microsoft Excel 97 or later.
"I started MyHECM.com to help seniors, their families, and their advisors get the information and resources they need to make an informed decision about a reverse mortgage." - Mike Roberts, Founder of MyHECM.com
How To Use The Calculator
IMPORTANT: To get accurate calculations, you’ll need to update the interest rates on the Excel reverse mortgage calculator once you’ve downloaded it (see Step 1 below). Once you’ve downloaded and opened the Excel reverse mortgage calculator, you’ll see a section to enter the current swap and index rates, which can be found on our interest rates page (the link to the rates page is in the calculator). Click the plus icons to expand each section below.
Click the hyperlink in the calculator to go to our rates page and obtain the latest swap and index rates. The current swap and index rates are important for accurate calculations, so you’ll want to update them after you’ve downloaded the Excel reverse mortgage calculator and anytime you want to use it in the future. Simply type the rates from the interest rates page into the corresponding fields in the calculator (see below).
A reverse mortgage offers multiple payout options, including lump sum, line of credit, and term/tenure monthly income plans. A reverse mortgage comes with either a variable or fixed interest rate and can even be used to purchase a home. In other words, there are a variety of payout and program options available to you. Select which program you would like to calculate using the drop down box just below where you entered the swap and index rates.
In the area below where you selected the HECM program, enter your age (or that of the youngest borrower), home value, mortgage balance, principal and interest payment, and the years left on your mortgage. If your home is free and clear, enter a zero for everything except your age and home value. Once you’ve entered the appropriate parameters into the Excel reverse mortgage calculator, the results will appear on the right side of the screen.
To see how the loan could amortize in the future, simply click the “Amortization” tab at the bottom left of the Excel reverse mortgage calculator. The calculator will display how your loan balance, available line of credit (if applicable) and home equity could change over time.
You can change the assumed home appreciation by clicking the yellow dropdown on the upper right of the amortization page. This will enable you to see how various home appreciation rates could impact your home equity in the future.
We hope you find our Excel reverse mortgage calculator helpful!
Get your free calculator now! Enter your email address below and click the 'Download' button.
We hate spam as much as you do! We won't give your email address to anybody else. We'll send you updates from time to time, but you can unsubscribe at any time. The downloadable reverse mortgage calculator requires Microsoft Excel 97 or later.