Please, Show steps

Q4 Suppose you purchased a house 7 years ago and took out a mortgage for $400,000 with a 5.6% interest rate. The mortgage is a 30 year mortgage with monthly payments. Today you can refinance the loan at a 5% interest rate for a fee of $10,000. Assume that you would borrow just enough to repay the old loan and the refinancing fee. Monthly Annual Rate Life (In Years) Loan Amount Periods Paid Fee Payments 5.6% 30 $400,000.00 84 $ 5.0% 30 o $10,000.00 Initial Loan Refinancing If you refinance at the new rate, how much will you save per month? Monthly Savings If you expect to move in 6 years, would you want to refinance? Years Months 72 Time Till Move 6 Old Loan New Loan Loan Balance at Move NPV of Refinancing Refinance