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 E H K L 1 co i The Nominal Rate of Return Required to Yield $1,000,000 in Purchasing Power N Years Later, Assuming a Given Rate of Inflation and a Given Nominal Investment Each Year 2 2 3 4 5 What nominal annual rate of interest must you earn if you deposit $870.00 at the end of each year for the next 50 years if you want to have real purchasing power o $1,000,000.00 50 years from now and you expect the rate of inflation to be 2.30% 6 7 8 Nominal Dollar Amount Required= $3,117,322.15 Nominal Annual Rate of Interest Required=| 9