Question: Can you please describe how to input the highlighted data into excel to receive the answer? Thank you. You are saving for retirement. To live

 Can you please describe how to input the highlighted data into

Can you please describe how to input the highlighted data into excel to receive the answer? Thank you.

excel to receive the answer? Thank you. You are saving for retirement.

You are saving for retirement. To live comfortably, you decide you will need to save $1,000,000 by the time you are age 65 . Today is your 21st birthday, and you decide, starting today and continuing on every birthday up to and including your 65 th birthday, that you will put the same amount into a savings account. If the interest rate is 4%, you set aside $8,262.46 each year to make sure that you will have $1,000,000 in the account on your 65 th birthday. You realize that your plan has a flaw. Because your income will increase over your lifetime, it would be more realistic to save less now and more later. Instead of putting the same amount aside each year, you decide to let the amount that you set aside grow by 6% per year. Under this plan, how much will you put into the account today? (Recall that you are planning to make the first contribution to the account today.) The first payment is $. (Round to the nearest cent.) We can also compute this result using a spreadsheet: The present value is $522,330.39. Setting these equal gives: $522,330.39=0.060.08C1.08(1(1.061.08)30)+C Solving for C brings: C=0.060.081.08(1(1.061.08)30)+1$522,330.39=$12,553.43 The first payment is $12,553.43

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!