How to calculate PV and FV in the last picture with the given information? Also, what would be the First year $ be under "amount needed in retirement" in the last picture? Lastly, how to calculate the ROR for each percentage in the last picture?

You have recently graduated and just started your first job . Your financial advisor has recommended saving for retirement to ensure you have enough to live large and to leverage the time value of money . Data for your situation follows : Starting salary = $60, 000 ( at end of first year ) Annual raises = 5%/0 1.2 Current age = 25 Career = 40 years ROR in career = 10% P. a. Savings rate = 15%/ P.a . In the Retirement I tab , calculate the values going out to 40 years and graph the ending balances . In the Retirement 2 tab , determine the amount you need to have in your account the day you retire ( PV ) and conduct a sensitivity analysis to determine if you will have* enough for retirement based on the various savings rates and RORS . An excellent tutorial is available at https : / / www . youtube . com / watch ? V = XO BFIbKISS . Data for your situation follows :" Retirement = 30 years Amount needed in first year of retirement = 80%/ of last year's salary Inflation in retirement = 3%/ P.a . ROR in retirement = 5%/ }. a .AMOUNT NEEDED IN RETIREMENT First year , $ Inflation , % 3%0 ROR , % 5% n 30 PV, S This is the amount you will need the day you retire . SENSITIVITY ANALYSIS Salary , S 60, 000 Saving , % 15% ROR , % 5% Raises , % 5% n 30 FV , S # DIV / O !' Savings Rate 10% 1 1% 12% 13% 14% 15% 909 ROR 7%0 8% 9 90 10%