instructions

43 Requirements In cell D17, by using cell references, calculate the future value of the yearly savings on the day you retire. Note: The output of the expression or function you typed in this cell is expected as a positive number. (1 pt.). In cell D21, by using cell references, calculate the lump-sum that you need to invest today in order to save the same amount as with the yearly savings (1 pt.). NOTE: Input the lump-sum as a positive number In cell D27, by using cell references, calculate the amount that you can withdraw from your retirement account every year (1 pt.) In cell D33, by using cell references, calculate the number of years that it will take to deplete your retirement savings if you withdraw a certain amount per year (1 pt.) In cell D40, by using cell references, calculate the return that you need to eam on your yearly savings for a certain payment to reach your goal at retirement. Note: For this particular case, only use the first four parameters of the RATE function. Assume Annual savings as a cash outflow and the Future value as an cash inflow. (1 pt) 2 3 4 48 49 51 52 54 59 4-25