We would like to have $1,000,000 in 10 years. We have $700,000 now in an account. We are withdrawing $100,000 a year from the account at the beginning of each year. What annual interest rate would we need to achieve our goal?

Please show excel work