Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Terrorist Finance

Authors: T. Wittig

2011th Edition

0230291848, 978-0230291843

More Books

Students also viewed these Finance questions