Question: I plan to deposit $2,000 per month at the end of each month over the next 10 years. My investments earn 0.8 percent per month.

I plan to deposit $2,000 per month at the end of each month over the next 10 years. My investments earn 0.8 percent per month. I would like to have $1 million in 10 years. To achieve this, I will also need to deposit a lump sum now. How much should that lump sum be?

Step by Step Solution

3.58 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate the required lump sum that you need to invest now we can use ... View full answer

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 Microsoft Excel Data Analysis 7th Questions!