You plan on buying yourself a retirement cabin in the Rocky Mountains 40 years from now. At an interest rate of 5 percent per year, how much must you invest each year (equal annual amounts beginning next year) to have $150,000 in your cabin fund in 40 years?
please solve using excel
Future Value to accumulate in 40 years = $150,000
Calculating the Equal Annual Payments at the end of each year using Excel "PMT" function:-
So, equal annual payments is $1241.72
If you need any clarification, you can ask in comments.
If you like my answer, then please up-vote as it will be motivating
Get Answers For Free
Most questions answered within 1 hours.