Using IRR Excel Command:

Answer: N>100 yrs, N>22.5 yrs

Number of Years A systems engineer who invested wisely can retire now because she has $2,000,000 in her self- directed retirement account. Determine how many years she can withdraw (a) $100,000 per year, or (b) $150,000 per year (beginning 1 year from now) provided her account earns at a rate of 5% per year. (c) Explain why the increased annual withdrawal from $100,000 to $150,000 per year is important