A B C D E F G H K M N O P Q R S T U V 20 pts. Solver settings] must be saved. 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: Annual Inflation: 2.00% Starting in year K, withdraw a desired amount (IN TODAY'S DOLLARS) at the beginning of each year until the end of the horizon. Initial Contribution: 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. Desired annual withdrawal: $ 100,000.00 Build a model to answer the question: What is the minimum first contribution to accomplish such a retirement goal? Year withdrawals begin: 43 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. Year from: Year to: Exp. Return 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% NOTE: In this problem you can hard-code the value of zero (0) in the right-hand side of the Solver's constraints 36 70 5.00% The interest between Year 36 and Year 70 (inclusive) is 5.00% This model will be tested on different sets of input data. Add more columns below (I suggest three more in addition to the Contr.), all added cells must be calculated cells Year Beg. Bal. Contr. o $ - WN