D E F G 3% 70 LIFE-CYCLE FINANCIAL 1 PLANNING 2 3 Inputs 4 Real Riskfree Rate 5 Retirement Age 6 7 Outputs 8PV of Work Yrs $1 Annuity 9PV of $1 Infinite Annuity 10 Working Years PV / Infinite PV 11 12 Date 13 Age 14 Real Salary 15 Real Savings 16 Real Consumption $2.83 $33.33 8.49% o 2 31 4 67 681 69 701 711 $200,000 $200,000 $200,000 $200,000 SO $183,028 $183,028$183,028 -$16,972 $16,972 $16,972 $16,972 $16,972 a) Write the If Statement for the Real Salary at age 68 (D14), which will be copied across to G14. (5 points) b) Write the formula for the Real Consumption at age 68 (D16), which will be copied across to G16. (2.5 points)