#loan calculator excel
Explanations of the Different Spreadsheets
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 .
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 ?
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.