Please explain how you got each of your numbers/ answers. I would really like to learn not just get answers. Thank you! also could you please show how to use excel as well as formulas by hand. If correct answers will thumbs up if wrong will leave blank. I appreciate you & your help! Thanks again!

The mortgage on your house is five years old. It required monthly payments of $1,422, had an original term of 30 years, and had an interest rate of 8\% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance-that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125% (APR). a. What monthly repayments will be required with the new loan? b. If you still want to pay off the mortgage in 25 years, what monthly payment should you make after you refinance? c. Suppose you are willing to continue making monthly payments of $1,422. How long will it take you to pay off the mortgage after refinancing? a. What monthly repayments will be required with the new loan? The monthly repayments with the new loan will be $. (Round to the nearest cent.) b. If you still want to pay off the mortgage in 25 years, what monthly payment should you make after you refinance? The monthly repayments will be $. (Round to the nearest cent.) c. Suppose you are willing to continue making monthly payments of $1,422. How long will it take you to pay off the mortgage after refinancing? It will take approximately months. (Round to the nearest integer.)