The spreadsheets below can be saved to the hard drive of your
computer by clicking on File and then Save As.
You must have Excel 2000 or later installed on your computer.
When you enter a number in the spreadsheet, other numbers change only
when you move the cursor.
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 a daily accrual
basis, 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.