Explanations of the Different Spreadsheets

Unless otherwise noted you must have Excel 2016 or later installed on your computer.

Should You Pay Off Your Mortgage at Retirement?

This spreadsheet allows you to compare not paying off your mortgage, paying off with financial assets, and paying off with a HECM reverse mortgage.

Retirement Saver

This spreadsheet will show you how a savings plan adopted now will increase your spendable funds at retirement, with or without a HECM reverse mortgage.

Forbearance Calculator

This spreadsheet allows mortgage borrowers who are having pandemic-related trouble making their payment to view the future consequences of various forbearance options.

Retiree Discretion Rule For Determining the Amount That Can Be Withdrawn Monthly From a Portfolio of Common Stock

This spreadsheet allows a retiree to adjust the amount withdrawn monthly to the investment risk of the portfolio and the retiree’s expectations of longevity.

Retirement Planning Calculator with Integrated Reverse Mortgage Options

This spreadsheet allows users to plan their retirement, including possible use of a reverse mortgage, and manage the process thereafter. (This spreadsheet requires Excel 2016 running on a Windows PC.)

Paying Down the Mortgage Balance In Order to Eliminate Private Mortgage Insurance

This spreadsheet shows the investment required to terminate PMI in the most cost-effective way possible, and the rate of return on the investment.

Assessing the Status of a HECM Reverse Mortgage, and Opportunities to Modify it or Refinance it

This spreadsheet allows HECM borrowers to a) project their future equity using different assumptions regarding the interest rate and property appreciation, b) determine whether a modification of the transaction would better meet their current needs, and c) if a modification is desired, determine whether it would be more advantageous to refinance into a new HECM rather than to modify the existing one.

Monitoring Ownership Shares of Occupant and Investor

This spreadsheet allows you to simulate and monitor the ownership shares of an occupant, and an investor who helps make occupancy possible.

Monitoring Amortization of a Simple Interest Loan

This spreadsheet allows you to keep track of the balance on a simple interest mortgage that accrues interest daily. Just make sure that the payments are recorded on the exact day they are credited to your account by the lender.

Keeping Track of Payments on Interest-Only (IO) Mortgages

This spreadsheet allows you to track the effects of principal payments on your loan balance and your interest payment on an IO. It also shows the fully-amortizing payment you will have to start paying at the end of the interest-only period, and if the IO is an ARM, you can change the interest rate.

Extra Payments on Monthly Payment Fixed-Rate Mortgages.

This spreadsheet allows you to track the impact of extra payments on your loan balance and date of payoff. It is discussed in Have I Been Credited For My Prepayment?

Extra Payments on Bimonthly Payment Fixed-Rate Mortgages.

The same program for borrowers on a bimonthly payment basis.

Extra Payments on Adjustable Rate Mortgages.

The same program for borrowers with ARMs. The borrower must enter new interest rates after the initial rate period, as well as any extra payments. This spreadsheet only works for ARMs on which the payment is recalculated to be fully amortizing whenever the rate changes. It will not work for negative amortization ARMs. Borrowers who make extra payments to shorten the term should read Can I Pay Off an ARM Early, and Using a Calculator to Prepay an ARM.

Biweekly Mortgages.

This spreadsheets allows you to compare total interest payments and payoff dates for conventional biweeklies, biweeklies on which payments are credited biweekly rather than monthly, and standard monthly payment loans on which the payment has been increased by 1/12. It is discussed in Refinance at a Higher Rate?

Future Net Worth.

This spreadsheet allows you to calculate future net worth under different assumptions regarding how large a down payment you make, the terms of any mortgage, how much you earn on investments, and other factors. Read Will I Be Richer at 65 if I Pay All Cash Now?

Blended Annual Percentage Rate (APR).

This spreadsheet allows you to calculate an APR for a combination of first and second mortgage. Read Is There a Blended Interest Rate?

Invest in Less Mortgage.

This spreadsheet allows you to calculate the yield on an investment in a larger down payment. Read Invest in Securities or Down Payment?

Yield to Lender on Wrap-Around Mortgages.

This spreadsheet allows you to calculate the yield to the lender over any period on a wrap-around mortgage. See What Is a Wrap-Around Mortgage? Note that the yield to the lender on a wrap-around is also the interest cost to the borrower on a cash-out refinance.

Loan Repayment Versus Investment.

This spreadsheet allows you to compare your net worth in two situations: one where you liquidate assets to repay your mortgage, the other where you retain the assets and the mortgage. The spreadsheet lets you change the interest rate over time.

Value of Assumptions.

This spreadsheet allows you to calculate the value of being able to assume an old mortgage that carries a rate lower than that available in the current market.

Want to shop for a mortgage on a level playing field?

Why Shop for a Mortgage with the Professor?

  1. Receive His Help in Finding the Type of Mortgage That Best Meets Your Needs
  2. Shop Prices Posted Directly by His Certified Lenders
  3. Shop Prices Fully Adjusted to Your Deal
  4. Shop Prices That Are Always Current
  5. Get Him as Your Ombudsman Just in Case

Read More About the Support and Protections Listed Above

Sign up with your email address to receive new article notifications