11. Refinancing a mortgage.
Use Worksheet 5.4. Daisy Tran purchased a condominium ten
years ago for $300,000, paying $1,439 per month on her $240,000, 6 percent, 30-year
mortgage. The current loan balance is $200,857. Recently, Daisy has been considering
refinancing her condo. She expects to remain in the condo for at least four more years and
has found a lender that will make a 4 percent, 20-year, $200,857 loan, requiring monthly
payments of $1,217. Although there is no prepayment penalty on her current mortgage,
Daisy will have to pay $1,500 in closing costs on the new mortgage. She is in the 22 percent
tax bracket. Based on this information, use the mortgage refinancing analysis form in
Worksheet 5.4 to determine whether Daisy should refinance her mortgage under the
specified terms.
From the worksheet below, it will take 8.7 months to breakeven on the refinancing. Since she
plans to stay in the home for another 4 years, it will be to her advantage to refinance the
mortgage
Name Date September 6, 2018
Item Amount
1 240,000.00 , 6.00
30 years) 1,439.00$
2 200,857.00 , 4.00
20 years) 1,217.00$
3222.00$
422 %) 49.00$
5173.00$
6
$
1,500
1,500.00$
7 8.7
b. Total closing costs (after-tax)
Current monthly payment (Terms:
c. Total refinancing costs (Item 6a + Item 6b)
Months to break even (Item 6c ÷ Item 5)
New monthly payment (Terms:
Monthly savings, pretax (Item 1 – Item 2)
Tax on monthly savings [Item 3 × tax
Monthly savings, after-tax (Item 3 – Item 4)
MORTGAGE REFINANCING ANALYSIS