Question: i need help understanding how to calculate 4,5,and6 using excell please please see photo for question 3 4. Using vour answer to part 3, find

i need help understanding how to calculate 4,5,and6 using excell please
i need help understanding how to calculate 4,5,and6 using excell please please
see photo for question 3 4. Using vour answer to part 3,
please see photo for question 3

4. Using vour answer to part 3, find the equal annual amount you would need to save every year from the age you input as now until the date you retire to reach 5. Now let's assume you are 10 yearsinto saving for your retirement, 5010 years older than what you chose as your age now and aspume you earned 2% less than 2. 6. Assume that the amount you calculate in part 3 is too much for you to posibly save, suggests so ethical options. 1. Calculyte the amount of monsvvou will need the firt vear of retirement: 2. Calculation the amount you wili need the day veu reire if you want the amount yuu calculated in part 1 peid out anhualfy hoen the dry rou retire until the last date yeu want to recelve retiremeet income and you want to lexe nothin to your heir. Acuime the rate of return vou wil 4. Using vour answer to part 3, find the equal annual amount you would need to save every year from the age you input as now until the date you retire to reach 5. Now let's assume you are 10 yearsinto saving for your retirement, 5010 years older than what you chose as your age now and aspume you earned 2% less than 2. 6. Assume that the amount you calculate in part 3 is too much for you to posibly save, suggests so ethical options. 1. Calculyte the amount of monsvvou will need the firt vear of retirement: 2. Calculation the amount you wili need the day veu reire if you want the amount yuu calculated in part 1 peid out anhualfy hoen the dry rou retire until the last date yeu want to recelve retiremeet income and you want to lexe nothin to your heir. Acuime the rate of return vou wil

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!