Question: Please show solution using Excel David Jones estimated net wealth is $15,000, and he intends to retire in ten years. His annual salary after tax

Please show solution using Excel

David Jones estimated net wealth is $15,000, and he intends to retire in ten years. His annual salary after tax is $40,000 and current expenditure is $28,000, allowing him to save $12,000 per annum (Assume that this money is saved at the end of the year). His pension fund advisor tells him that the actuarial evidence suggests he should plan on an expected life of 16 years following retirement. If the rate of interest he can earn on invested funds is 8%, and David wants to maintain a minimum wealth position of $50,000 after the expected 16 years of retirement, how much does he have at the beginning of retirement?

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!