Question: Please include the steps to your solution using excel formulas. I think i need to use the PV function but im not sure. Thank you

Please include the steps to your solution using excel formulas. I think i need to use the PV function but im not sure. Thank you very much!
You just graduated from college and your new employer offers a 401(k) where they match your contribution, dollar for dollar. You want to know the accumulated balance in your 401(k), including your employer's contribution, assuming you contribute either $900 per month or $1,100 per month, and the fund earns 9.3% annually.
\table[[Annual rate of return,9.3%],[Monthly contribution #1,$900],[Monthly contribution #2,$1,100],[Years to retirement,25],[Payments per year,12],[1. Assuming you and your employer each invest $900 per month, what will be the value of your 401(k) at the end of 25 years?]]
Assuming you and your employer each invest $1,100 per month, what will be the value of your 401(k) at the end of 25 years?
Please include the steps to your solution using

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!