Useof Excel's TVM functions among =PV, =FV, =PMT, =RATE, =NPER, =IPMT, =PPMT, =CUMIPMT, =CUMPRINC to best suit all answer each question and show the formula excel

1New Scenario (Independent): Mia deposits $454885 into her savings account today. The bank pays interest at 9% p.a. compounded quarterly for the first 9 years and 9.5 % p.a. compounded quarterly thereafter. Calculate the balance in Mias savings account in 17 years' time.

2New Scenario (Independent): Nancy makes a deposit into her savings account today. She earns interest at 10% p.a. compounded monthly. How many months does it take for Nancy to double her money?

3New Scenario (Independent): Frank takes out a $181800 mortgage loan today. To fully repay the loan, he needs to make 40 equal quarterly repayments of $9090 starting in 3 months. Calculate the interest rate p.a. compounded quarterly for this loan

4 New Scenario (Independent): Ken deposits $4545 into his savings account every month starting from today. He will make 80 deposits in total. The interest rate is 9.3% p.a. compounded monthly. Calculate the balance in his bank account in 120 months' time.