You must use Excel function in solving the problem Part A You are planning to retire in 25 years in Hwa You are quoted by a bank for an annuity at a rate of 5% per year If you deposit $1,000 per month at the end of the month, would you have a retirement next of S1,000,000 at the end of 25th year? Show your calculation (pt) You must state financial function in Cell B7) After reaching your goal of exact 51,000,000 at the end of the 25th year, how much your could you withdrew from the bank account for unother 30 years (anume # 5% interest rate on your money) (8 pes) You must use ancel financial function in Cell 1123 Part Moerdyk Corporation's bonds have a 25-year maturity, 754 cupon rate with semiannual payments), and a par value of 1,000 The hond price is $985 calculate YTM (using Excel functions) - 2 pts/cach) VIM effective yield You must use a Excel francia function in Cells $19 and (19) Tart C Lite bonding companies to Part Assume that your friend wants to buy a car with a price tag of 35.000. He find bank offering a year car loan with a 3 APR monthly payment) How much is the monthly payment of the loan?141) MT