Refinancing a Home: The following explanation is the basic idea of refinancing a mortgage/home. Refinancing a mortgage involves applying and receiving a new mortgage (at a new and lower interest rate) for the amount of the remaining principal (i.e. the current balance) of the current mortgage. The loan amount of the new mortgage is used to pay off (i.e. close) the current mortgage. In other words, when refinancing the mortgage, you stop the current mortgage, get a new mortgage, pay off the remaining balance of the current mortgage using the new loan amount, and then start paying off the new mortgage according to the terms of the new mortgage. Beware! When you refinance your home, even though your new monthly payment (with the new mortgage) may be reduced, it may be possible that the total interest for the new mortgage may be more than the remaining amount of interest for the current mortgage! If the total amount of interest that you would pay with the new (refinanced) mortgage is greater than the remaining amount of interest for your current mortgage, then it is usually unwise to refinance your home (unless there are other circumstances involved). Suppose that you are currently making monthly payments on a $248,800 30-year mortgage at 567% interest compounded monthly. For the last 8 years, you have been paying the regular monthly payments. You now have the option to refinance your current mortgage with a new 25- year mortgage that has an interest rate of 4.5% compounded monthly. No the new loan has a closing cost fee of $1,300(for title insurance, home appraisal costs, etc.) for the new (refinanced) mortgage. The lender stipulates that closing cost must be paid in cash and cannot be part of the new loan. You are to determine whether you would save or lose money in interest if you were to refinance your home. Take the closing costs into account when determining if you would save or lose money. Show all your work that you used to answer this problem. Label the steps (with short sentences) that you use and important values as you solve the problem. Note that when you use the TVM Solver, show the all variables and the values you entered into the variables) and solved for. Your final answer should be in the form of two or three sentences that summarizes your findings. (20 points)