Question

Your uncle has $340,000 invested at 7.5%, and he now wants to retire. He wants to withdraw $35,000 at the end of each year, starting at the end of this year. He also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. For how many years can he make the $35,000 withdrawals and still have $25,000 left in the end

Answer 1

Answer:

17.27 years

Explanation:

For this question we use the NPER formula that is shown on the attachment below:

Provided that  

Present value = $340,000

Future value = $25,000

PMT = $35,000

Rate of interest = 7.5%

The formula is shown below:

= NPER(Rate;PMT;-PV;FV;type)

The present value come in negative

So, after solving this, the number of year is 17.27 years