Question

20- please provide formula and answer Experts say that the baby boom generation (born 1946-1960) cannot count on a company pension or Social Security benefits to provide a comfortable retirement. It is recommended that they start to save regularly and early. Michael, a baby boomer, has decided to deposit $200 each quarter in an account that pays 8% compounded quarterly for 20 years. a) How much money will be in the account at the end of the 20 years? b) Suppose Michael has determined he needs to accumulate $130,000 from this annuity. What rate would achieve this goal? c) If he cannot get the higher rate, what amount would his payments need to be in order to achieve the goal? d) Suppose Michael cannot get the higher interest rate, nor increase his payments. How many months would he need to invest in order to achieve his goal?    not excel

Answer 1