please show in excel

(a) Create an annual Loan Amortization Schedule for a 7-year Student Loan of $50,000 With an interest rate of 7%. (b) You decide to refinance your (Part (a)) student loan at the end of year 2, for an interest rate of 4%, but you have to pay a penalty of $3000. Recreate the annual Loan Amortization Schedule for the remaining 5-year student loan with the new interest rate. (c) Should you go ahead with Refinancing