You started planning for your retirement. Assume a fixed horizon (given below) and a given annual inflation rate. For the first years you will be making contributions at the beginning of the year (adjusted for the inflation beginning in year 2) in order to meet the following retirement goal:
Starting in year K, withdraw a desired amount (IN TODAY'S DOLLARS) at the beginning of each year until the end of the horizon.
For the first few years, you will be using more aggressive investments (higher expected return). For the next few years assume a different return another for the remainder of the years.
Build a model to answer the question: 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 K, calculate the future value using K-1 years and type=end of the period. Do not change any Solver options.
*the three extra rows mentioned to add i added already: return, withdrawal, and ending balance*
- Solver DO Amination In Cotton started planning for your med one for you will be making covebutions at the beginning of the adjusted for beggender meer hengerresto Starting in year withdraw desired amount TOORTS DOLLARS beach you the end of the horizon For the few young reaction For the next few years-ansure adoreret another for the mander of the years da model to anwerthestion What is the hart HNT Den your window there are and to end of the period Denon 20.000.00 Desired and withdrawal Tewww Year from Yeart 1.00 1.00 Co Your Degal 5 Batam Withdrawal Ending Balance S 12 33 22 14 23 34 23 13 14 11 contributions at the beginning of the year (adjusted for the in Annual Inflation: 2.00% Starting in year K, withdraw a desired amount (IN TODAY'S Initial Contribution: For the first few years, you will be using more aggressive inve remainder of the years. Desired annual withdrawal: $200,000.00 Build a model to answer the question: What is the minimum Year withdrawals begin: 43 HINT: Determine your inflation-adjusted contributions and wi type=end of the period. Do not change any Solver options. Year from: Year to: Exp. Return 1 15 12.50% The interest between Year 1 and Year 15 (inclusive) is 12.50% 16 35 8.00% The interest between Year 16 and Year 35 (inclusive) is 8.00% 36 70 5.00% The interest between Year 36 and Year 70 (inclusive) is 5.00% Add more columns below (I suggest three more in addition to the Contr.), all added cel Return Withdrawal Ending Balance Contr. Year Beg. Bal. 1 0 $ - Solver DO Amination In Cotton started planning for your med one for you will be making covebutions at the beginning of the adjusted for beggender meer hengerresto Starting in year withdraw desired amount TOORTS DOLLARS beach you the end of the horizon For the few young reaction For the next few years-ansure adoreret another for the mander of the years da model to anwerthestion What is the hart HNT Den your window there are and to end of the period Denon 20.000.00 Desired and withdrawal Tewww Year from Yeart 1.00 1.00 Co Your Degal 5 Batam Withdrawal Ending Balance S 12 33 22 14 23 34 23 13 14 11 contributions at the beginning of the year (adjusted for the in Annual Inflation: 2.00% Starting in year K, withdraw a desired amount (IN TODAY'S Initial Contribution: For the first few years, you will be using more aggressive inve remainder of the years. Desired annual withdrawal: $200,000.00 Build a model to answer the question: What is the minimum Year withdrawals begin: 43 HINT: Determine your inflation-adjusted contributions and wi type=end of the period. Do not change any Solver options. Year from: Year to: Exp. Return 1 15 12.50% The interest between Year 1 and Year 15 (inclusive) is 12.50% 16 35 8.00% The interest between Year 16 and Year 35 (inclusive) is 8.00% 36 70 5.00% The interest between Year 36 and Year 70 (inclusive) is 5.00% Add more columns below (I suggest three more in addition to the Contr.), all added cel Return Withdrawal Ending Balance Contr. Year Beg. Bal. 1 0 $