These calculations will be undertaken on an EXCEL spreadsheet. The exercise will be based on: o Calculating the net present value (at the beginning of their retirement period) of net after-tax revenue and income during their retirement - The second calculation will be to compare this to the future value of all their accumulated savings available at the beginning of their retirement period. 0 in the event that the future value of the savings is not sufficient to support the present value of their net retirement expenditures, you will calculate what additional annual savings needed over the next 10 years to balance these two calculations 0 In the event that the future value of the savings exceeds the present value of their net expenditures, you will calculate the reduction in annual savings that they would be able to afford over the next 10 years to balance these Mo calculations