In: Finance
You want to retire 35 years from today with $2.5 million in your Individual Retirement Account (IRA). You currently have 100,000.00 saved in your IRA which is earning 9.00% annually. What amount would you need to save and deposit at the beginning of each quarter to achieve your retirement goal? Note that you are making the deposits quarterly, not annually.
Assuming rate of 9% is annual rate compounded quarterly
Quarterly deposits=PMT(9%/4,4*35,100000,-2.5*10^6,1)=251.84