Finance Excel Help

Cathys gets her paycheck twice-a-month (on the 1st and 16th). So, she pays her mortgage twice-a-month (on the 1st and 16th). On 01/01/2012, Cathy bought her home using a 30-year mortgage with an APR of 4.50% on a $1,000,000 loan. She has been making her payments twice-a-month. On 01/01/2020, her bank offered a special mortgage refinance offer at an APR of 3.00% on 20-year mortgages.

Q9) How much mortgage Cathy was paying from each paycheck between 2012 and 2020? (use two decimals, ex: $1,234.56).

Q10) What is the change in Cathys mortgage payment (each pay period), if she refinanced? (use two decimals, ex: + or - $123.45).

Q11) At the time of refinancing, Cathy took an additional $40,000 loan from the bank to buy a BMW and increased the remaining mortgage balance. What will be her new payment (each pay period)? (use two decimals, ex: $1,234.56).

Please provide excel function or formula to get the answer?