This template provides the analysis to make an informed refinancing decision. Begin by entering your marginal tax rate (the rate at which additional income would be taxed) and enter the number of months you intend to keep the property. Then enter the terms of the original and proposed mortgage, including the principal amount, the term in years, the interest rate, the number of months payments have been made, and the number of points required to obtain the new mortgage. Finally, enter the various refinancing fees that may apply. Mortgage Refinancing To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.Mortgage Refinancing Personal Marginal Tax Rate Resale Plan (months) Mortgage Terms Original Mortgage Current Mortgage Rate Original Term (years) Months Paid New Mortgage Rate New Term (years) Points Refinancing Fees Application Title Legal Other Points Total Fees Analysis Current Proposed Mortgage Amount Mortgage Payment Months to Recover Refinancing Costs Mortgage Balance at Resale Principal Repaid to Resale Total Payments to Resale Total Interest to Resale Tax Deduction on Interest Net Interest Cost to Resale Interest Savings (Costs) Total Savings (Costs)