Just realised this was posted in the wrong place.
Hi I have a Uni exam tomorrow in my Personal finance module, I am going through the revision questions only I have been stuck on the same question for a while now . Any help would be appreciated.
You have an annual income of £18,000 of which £2,000 each year is invested in a pension fund. The contributions to the fund are made over 40 years, and the average rate of return on the fund is 3.5% p.a. in real terms. The expected life expectancy at retirement is 4.5% p.a. What annual pension should you receive?
I also need to be able to work it out using Excel, using functions such as FV, PMT, PV.
I have the answers to the question, I just need to know how to get to the answer;
Pension fund value: £169,100.56
Annual Pension: £17,982.11