Please solve this equation mathematically and not through excel. Please show all your work. Please take all PVIF(A) calculations and intermediate calculations 7 places passed the decimal point. Compounding is monthly. Thank you!

1. (Refinance Decision) Amount Terms Cost of Refinancing Original Loan $350,000 6.6%, 30 New Loan 5.64%, $7,000 The original loan has been outstanding for 6 years. The owner plans to retain ownership of the property for another 7 years. The opportunity cost is 9%. Show MPVIFA numbers. Should the loan be refinanced? Remember to answer this question using Present Value (PV) Analysis. Show the tables with labels when answering this question. A. Table showing the calculations for change in Monthly Payments and Loan Balances Show Table) B. Present Value Analysis (show equation and work for solution method) C. Decision using Marginal Cost and Marginal Benefit Analysis 1. (Refinance Decision) Amount Terms Cost of Refinancing Original Loan $350,000 6.6%, 30 New Loan 5.64%, $7,000 The original loan has been outstanding for 6 years. The owner plans to retain ownership of the property for another 7 years. The opportunity cost is 9%. Show MPVIFA numbers. Should the loan be refinanced? Remember to answer this question using Present Value (PV) Analysis. Show the tables with labels when answering this question. A. Table showing the calculations for change in Monthly Payments and Loan Balances Show Table) B. Present Value Analysis (show equation and work for solution method) C. Decision using Marginal Cost and Marginal Benefit Analysis