Part D.

Answer using Excel preferred.

Suppose you are 30. You expect to retire as soon as you reach age 65, and live to age 100. Your real annual labor income is $150,000 a year until age 65 Suppose the real discount rate is 2%. Suppose from age 40 you start paying social security tax of $12,000 and continue to do so each year until retirement Assume that all cash flows occur in annual frequencies and at year end, and the last social security tax is made when you just turn 65 4. What is your permanent income? How much do you need to save (including both personal and social security savings) each year during your working years in order to maintain a constant level of annual consumption that equals the permanent income? Verify that the PV of savings equal to the PV of consumption in retirement years. How much is your personal savings each year after you start paying social security tax? What is the annual benefit you get from social security after retirement? Does joining social security change your permanent income? Suppose you just won a lottery of $300,000 on your 30th birthday. By how much percent will your permanent income increase? a. b. c. d