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 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
Get step-by-step solutions from verified subject matter experts
