Question: When is the best time to retire, i . e . , when to start taking out social security? 1 . Let s make the
When is the best time to retire, ie when to start taking out social security?
Lets make the following assumptions:
The official retirement age is x and at that time, you receive $a per year and this number will increase by every year denote this rate as i the annual inflation rate You will continue to receive money every year until you pass, say age b
The government also says that if you start taking out your social security differently than age the amount that you can get is less than a for each year earlier than x and more than a for each year later than x
You use an annual discount rate of in calculating NPV
Build a excel sheet with formulas model to answer the following questions:
Should you retire at age or Why?
Will your answer to the above question change if the life expectancy b is instead of Why?
Your model should be just one sheet instead of multiple duplicate sheets Your model should work even when you change your decision x or any parameters of your model a i b
the question is related to data analytics and should be done on excel
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
