C1.. Assume that over the 30-years of retirement you are able to earn a weighted average of 7% compounded annually through investing in bonds, stock, and CD's. Using this rate, discount the total expenses for each of the 30-years you found in part B3 back to the date of your retirement. For example if your expenses for the last 3-years of retirement (years 28, 29, and 30) totaled $200,000, $206,000, and $212,180, respectively, due to inflation's effects, discount these amounts back to the date of your retirement using the present value formula. For the 28th year: $200,000/(1.07)^28 $30,080.44. For the 29th year: $206,000/(1.07)^29 = $28,955.94. For the 30th year: $212,180/(1.07)^30 $27,873.47. If you add these three discounted values they total $86,909.85. That means a deposit of $86,909.85 Invested at retirement earning 7% compounded annually will grow sufficiently to withdraw $200,000 in 28-years, then $206,000 the next or 29th year of your retirement, then $212,180 the final or 30th year of your retirement. You need to do this for each of the 30-years then add the total of the discounted values for each of the 30-years. This will become your required "nest-egg" at retirement! C2. Take the total of the discounted expenses you found in C1 as your future value or nest egg at retirement and create a sinking fund for yourself with monthly payments or a monthly investment at the end of each month in order for your to meet the sinking fund goal at retirement. Assume a weighted average nominal rate of 12% compounded monthly from now until retirement (Assumes you are 100% in Stock). Find the monthly investment at the end of each month required for the following years you may be employed before retiring using the formula for sinking fund for the following periods (illustrate your formula or calculator use) a. 50-years until retirement or 600 months. b. 40-years until retirement or 480 months. c. 30-years until retirement or 360 months. d. 20-years until retirement or 240 months. C2. Comment and reflect on the rising opportunity costs of investing for retirement if you begin investing with 50-years to retirement? If you begin investing with 40-years to retirement? If you begin investing with 30-years to retirement? If you begin investing with 20-years to retirement? (3-paragraph minimum) C3. Reflect on the benefits of starting early vs starting later in planning on retirement. (2-paragraph minimum) C4. Is planning for retirement and its opportunity costs and sacrifices worth the effort? Reflect and evaluate the Why's and the Why not's. (2-paragraph minimum) C5. Post your Signature Assignment to your e-Portfolio. Submit your Signature assignment via the URL for you e-Portfolio.