James's friend, Brandon, has hired a financial planner for advice on retirement

Finance Sep 11, 2020

James's friend, Brandon, has hired a financial planner for advice on retirement. Considering Brandon's current expenses and expected future lifestyle changes, the financial planner has stated that once Brandon crosses a threshold of $19,388,019 in savings, he will have enough money for retirement. Brandon has nothing saved for his retirement yet, so he plans to start depositing $55,000 in a retirement fund at a fixed rate of 12.00% at the end of each year. It will take years for Brandon to reach his retirement goal.

Expert Solution

We can calculate the number of years by using the following formula in excel:-

=nper(rate,-pmt,pv,fv)

Here,

Nper = Number of years

Rate = 12.00%

Pmt = $55,000

PV = $0

FV = $19,388,019

Substituting the values in formula:

=nper(12%,-55000,0,19388019)

= 33.25 years

Archived Solution

Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In

Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution

Get Custom Quote