help

Part 3: 401k Plan Upland Nursery has started a 401k plan for their assistant manager, Danielle Stormy. The historical returns from investing in this very specific 401lk plan have been provided. Calculate the average return, return standard deviation, coefficient of variation, and the typical year upper return, and typical year lower return. The average historical return will serve as the baseline estimate of the expected return on the 401k plan. Her starting salary is $50,500 and she will likely receive a 2.5% raise each year. Upland will make a 6% contribution and Ms. Stormy will make a 4.5% contribution. Write a VB function* to calculate the value of her 401k plan. Upland may want to use this worksheet to setup a more generic 401k calculator for other employees. For Expected Return on 401k and Years Until Retirement use drop down menus, the potential lists are provided in the worksheet. The rate of return on the investments will be varied using scenario manager. Ms. Stormy will retire in 30 years. If Ms. Stormy has discount rate of 3% per year what is the present value of this future value? Use scenario manager to determine the future value of the 401k, and the present value of the future value for the three cases indicated below: Case 1: Rate of return equals expected return, retire in 30 years Case 2: Rate of return equals expected return, retire in 20 years Case 3: Rate of return equals 4%, retire in 30 years Case 4: Rate of return equals 4%, retire in 20 years Can Ms. Stormy count on retiring with at $100,000 in present value terms? Part 3: 401k Plan Upland Nursery has started a 401k plan for their assistant manager, Danielle Stormy. The historical returns from investing in this very specific 401lk plan have been provided. Calculate the average return, return standard deviation, coefficient of variation, and the typical year upper return, and typical year lower return. The average historical return will serve as the baseline estimate of the expected return on the 401k plan. Her starting salary is $50,500 and she will likely receive a 2.5% raise each year. Upland will make a 6% contribution and Ms. Stormy will make a 4.5% contribution. Write a VB function* to calculate the value of her 401k plan. Upland may want to use this worksheet to setup a more generic 401k calculator for other employees. For Expected Return on 401k and Years Until Retirement use drop down menus, the potential lists are provided in the worksheet. The rate of return on the investments will be varied using scenario manager. Ms. Stormy will retire in 30 years. If Ms. Stormy has discount rate of 3% per year what is the present value of this future value? Use scenario manager to determine the future value of the 401k, and the present value of the future value for the three cases indicated below: Case 1: Rate of return equals expected return, retire in 30 years Case 2: Rate of return equals expected return, retire in 20 years Case 3: Rate of return equals 4%, retire in 30 years Case 4: Rate of return equals 4%, retire in 20 years Can Ms. Stormy count on retiring with at $100,000 in present value terms