Question
You started planning for your retirement now. Assume a 60-year horizon and 2% annual inflation rate. For the first 40 years you will be making
You started planning for your retirement now. Assume a 60-year horizon and 2% annual inflation rate. For the first 40 years you will be making a contribution at the beginning of the year (adjusted for the inflation beginning at year 2) in order to meet the following retirement goal: withdrawing $90,000 (IN TODAY'S DOLLARS) each year between year 41 and 60 at the beginning of each period. For the first 10 years (1-10), you will be using more aggressive investments (assume 12.5% interest). For the next ten years (11-20) assume 9% interest rate and 5% for the remainder of the years (21-60). What is the minimum first contribution to accomplish such a retirement goal? HINT: Determine your inflation-adjusted contributions and withdrawals first. For your first withdrawal in year 41, calculate the future value using 40 years and type=end of the period Hello Friends I need this done in excel : as the outputs added and maybe solver formulas, Thank you for helping me!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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