mortgage refinancing analysis

2. Refinancing a mortgage. Use Worksheet 5.4. Lily Nguyen purchased a condominium four years ago for $200,000, paying $1,250 per month on her $162,000, 8 percent, 25-year mortgage. The current loan balance is $152,401. Recently, interest rates dropped sharply, causing Lily to consider refinancing her condo at the prevailing rate of 6 percent. She expects to remain in the condo for at least four more years and has found a lender that will make Worksheet 5 4 MORTGAGE REFINANCING ANALYSIS Date May 31, 2016 Item Description Current monthly payment (Terms Amount % years) 2 New monthly payment (Terms years) 0 3 4 Monthly savings, pretux (Item 1 - Item 2) Tax on monthly savings [Item 3 tax rate ( Monthly savings, after-tax (Item 3 . Item 4) %) 5 Costs to refinance: a. Prepayment penalty b. Total closing costs (after-tax) c. Total refinancing costs (Item 6a+Item 6b) Months to break even (Item 6e . Item 5) 7 LO6 12. Refinancing a mortgage. Use Worksheet 5.4. Lily Nguyen purchased a condominium four years ago for $200,000, paying $1,250 per month on her $162,000, 8 percent, 25-year mortgage. The current loan balance is $152,401. Recently, interest rates dropped sharply, causing Lily to consider refinancing her condo at the prevailing rate of 6 percent. She expects to remain in the condo for at least four more years and has found a lender that will make a 6 percent, 21-year, $152,401 loan, requiring monthly payments of $1,065. Although there is no prepayment penalty on her current mortgage, Lily will have to pay $1,500 in closing costs on the new mortgage. She is in the 15 percent tax bracket. Based on this information, use the mortgage refinancing analysis form in Worksheet 5.4 to determine whether Lily should refinance her mortgage under the specified terms. LO6 12. Refinancing a mortgage. Use Worksheet 5.4. Lily Nguyen purchased a condominium four years ago for $200,000, paying $1,250 per month on her $162,000, 8 percent, 25-year mortgage. The current loan balance is $152,401. Recently, interest rates dropped sharply, causing Lily to consider refinancing her condo at the prevailing rate of 6 percent. She expects to remain in the condo for at least four more years and has found a lender that will make a 6 percent, 21-year, $152,401 loan, requiring monthly payments of $1,065. Although there is no prepayment penalty on her current mortgage, Lily will have to pay $1,500 in closing costs on the new mortgage. She is in the 15 percent tax bracket. Based on this information, use the mortgage refinancing analysis form in Worksheet 5.4 to determine whether Lily should refinance her mortgage under the specified terms