Question: Please solve on excel and show formula for answer. thanks A B D E Retirement Age: 60 65 70 PV Rate NPER present value interest

Please solve on excel and show formula for answer. thanks A BPlease solve on excel and show formula for answer. thanks

A B D E Retirement Age: 60 65 70 PV Rate NPER present value interest rate number of periods payment per period future value beginning of period (1) or end (0) PMT FV Type You received $2,500 from a summer job as a technology camp counselor prior to going to college. Your mom is encouraging you to invest this in an IRA today, saying an S&P500 Index fund is a safe "Invest it and forget it" place to park your cash, and that it has historically returned about 10% a year. Investing for retirement sounds crazy to you - you're only 18 and you won't retire for years. Assuming you decide to spend the money today, how much would you be giving up at retirement? - Run three models, assuming a retirement age of 60, 65, and 70

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!