Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance Version 3.1

Authors: Rachel S. Siegel

3rd Edition

1453334807, 978-1453334805

More Books

Students also viewed these Finance questions