include excel formula and step by step on how you get solutions to both (2parts of the same question) I'm lost I have a timeline set up with the ROR at 9% while working but don't know what to do from here? 

 

Transcribed Image Text:

tab I caps lock shift Question Completion Status: Your friend is celebrating her birthday and wants to start saving for retirement. She has provided you with the following information Years until retirement: 25 Amount to withdraw each year in retirement: $160,000 Years to withdraw in retirement 20 ROR while working: 9% ROR in retirement: 5% Nest egg $100,000 The first deposit will be made one year from today, and the last deposit will be made on the day she retires. Her first withdrawal will not take place unta one year after she retires Calculate the amount she will need to have saved on the day she retires. (Enter a positive value and round to 2 decimals) ctrl Pavilio QUESTION 17 Your friend is celebrating her birthday and wants to start saving for retirement. She has provided you with the following information. Years until retirement: 25 Amount to withdraw each year in retirement: $160,000 Years to withdraw in retirement 20 ROR while working: 9% ROR in retirement 5% Nest egg: $100,000 The first deposit will be made one year from today, and the last deposit will be made on the day she retires Her first withdrawal will not take place until one year after she retires. Calculate the amount she will need to deposit each year in order to reach her retirement goal. (Enter a positive value and round to 2 decimals) Click Save and Submi to save and submit. Click Save All Answers to save all answers. P Pavilion tab I caps lock shift Question Completion Status: Your friend is celebrating her birthday and wants to start saving for retirement. She has provided you with the following information Years until retirement: 25 Amount to withdraw each year in retirement: $160,000 Years to withdraw in retirement 20 ROR while working: 9% ROR in retirement: 5% Nest egg $100,000 The first deposit will be made one year from today, and the last deposit will be made on the day she retires. Her first withdrawal will not take place unta one year after she retires Calculate the amount she will need to have saved on the day she retires. (Enter a positive value and round to 2 decimals) ctrl Pavilio QUESTION 17 Your friend is celebrating her birthday and wants to start saving for retirement. She has provided you with the following information. Years until retirement: 25 Amount to withdraw each year in retirement: $160,000 Years to withdraw in retirement 20 ROR while working: 9% ROR in retirement 5% Nest egg: $100,000 The first deposit will be made one year from today, and the last deposit will be made on the day she retires Her first withdrawal will not take place until one year after she retires. Calculate the amount she will need to deposit each year in order to reach her retirement goal. (Enter a positive value and round to 2 decimals) Click Save and Submi to save and submit. Click Save All Answers to save all answers. P Pavilion