Question
Social Security will give me the following amounts per year, depending on when I retire: Age 62 $28,680/yr till death Age 65 $35,304/yr till death,
Social Security will give me the following amounts per year, depending on when I retire:
Age 62 $28,680/yr till death
Age 65 $35,304/yr till death, and no Social Security benefit before then.
Age 67 $40,740/yr till death, and no Social Security benefit before then.
Assume a conservative discount factor of 5%.
I expect to live to age 80.
I'm currently 60.
I make $75k a year and will continue to work until I begin to claim my social security benefit, at which point I will resign from MSU.
BTW - Social Security will allow me to earn $20k a year in employment income without penalizing my retirement benefit. This will be done by the beginning of the year I start social security and continue to do so until age 70.
Calculate the NPV for each of the three scenarios using an Excel worksheet. Pleaseprovide me with the formulas used at every step. When should I retire?
Also - what's the total amount I'd receive for each scenario without discounting? What lesson have you learned?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Scenario 1 Retiring at Age 62 Given information Annual Social Security benefit at age 62 28680 Expec...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started