Unless otherwise noted you must have Excel 2000 or later installed on
your computer.
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.
