Working from the top down, enter data needed from the text question. Calculate a solution for each cell back-lighted in yellow. Build your formulas in calculation cells by referencing cells above that in turn reference numbers directly from the text problem.

fx A B G H 1 a Solving for the Annuity that will last N years, Given a Current Portfolio Value and the Expected Future Rate of Return 2 3 4 If you now have $1,600,000.00 in an investment portfolio, you expect to earn a nominal rate of 6.10% per year, and you expect to live 20 more years, how much can you withdraw each year, beginning today, such that at the end of 20 years, the value of your portfolio will be zero? What if you expect the rate of inflation to b 2.20% 5 6 7 Annual Withdrawal Beginning Today= 8 9 Annual Withdrawal Beginning 1 year from Today= 10 11 Annual Withrawal Beginning Today with Inflation= 12 fx A B G H 1 a Solving for the Annuity that will last N years, Given a Current Portfolio Value and the Expected Future Rate of Return 2 3 4 If you now have $1,600,000.00 in an investment portfolio, you expect to earn a nominal rate of 6.10% per year, and you expect to live 20 more years, how much can you withdraw each year, beginning today, such that at the end of 20 years, the value of your portfolio will be zero? What if you expect the rate of inflation to b 2.20% 5 6 7 Annual Withdrawal Beginning Today= 8 9 Annual Withdrawal Beginning 1 year from Today= 10 11 Annual Withrawal Beginning Today with Inflation= 12