Q.5 You expect to contribute to an investment fund for your retirement over the next 30 years with an annual deposit of a yet-to-be-determined amount. Assume your goal is to have $2 million available when you stop the annual deposits and that the fund can return 10% per year every year. a. Calculate if you will reach your goal for either of the following two deposit scenarios: (1) $12,000 every year; (2) $8000 at the end of next year for 15 years, followed by $15,000 deposits in each of years 16 through 30. b. Calculate the exact number of years necessary to accumulate the $2 million if $12,000 is deposited each year until the goal is achieved. c. For a little more of a challenge, use only the FV function to calculate the number of years necessary to attain the $2 million goal for the second deposit scenario, assuming the $15,000 is deposited annually until the goal is achieved.

Answer :

Other Questions