Question: please do this in excel! and show work Today is your 25th birthday, you are starting a new job, and you plan to begin saving

please do this in excel! and show work
 please do this in excel! and show work Today is your

Today is your 25th birthday, you are starting a new job, and you plan to begin saving for retirement. Your goal is to have $4 million on your 60th birthday (and retire!). Starting one year from today (t-1), you will deposit $X into an investment account. Each year thereafter, you will deposit 2% more than you did the year before. You will make your final deposit on your 60th birthday (t=35), and this will take your account right to $4 million. You expect to earn 6% each year on invested money (r = 6%). What is X? Upload Choose a File

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!