2) You just turned 40 years old. You plan to retire early at 55. You currently have $200,000 in savings. You would like to be able to withdraw $100,000 a year until you are 65 (at which point you expect to live off social security). All deposits/withdrawals will occur at the beginning of the year. The discount rate is 7%. (7 points). a Using trial and error, are deposits of $10,000 per year enough to reach your savings goal? [2 points] b. Using goal seek, find the annual deposit necessary to meet your financial goals. Write the inputs used in the goal seek equation below the answer. [1 point] C. Using PMT, solve for the annual deposit necessary to meet their financial goals. [2 points] d. Using a data table, report the required deposit for interest rates ranging from 2% to 12% in increments of 1%. [1 point] e. Briefly interpret the results from the data table. [1 point]. 2) You just turned 40 years old. You plan to retire early at 55. You currently have $200,000 in savings. You would like to be able to withdraw $100,000 a year until you are 65 (at which point you expect to live off social security). All deposits/withdrawals will occur at the beginning of the year. The discount rate is 7%. (7 points). a Using trial and error, are deposits of $10,000 per year enough to reach your savings goal? [2 points] b. Using goal seek, find the annual deposit necessary to meet your financial goals. Write the inputs used in the goal seek equation below the answer. [1 point] C. Using PMT, solve for the annual deposit necessary to meet their financial goals. [2 points] d. Using a data table, report the required deposit for interest rates ranging from 2% to 12% in increments of 1%. [1 point] e. Briefly interpret the results from the data table. [1 point]