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 =13 B E H K 1 2 3 4 a Understanding TIPS and inflation If an investor purchases a 4.7% two-year TIPS and the CPI increases 2.0% over the first year and 3.1% over the second year, how much does the investor receive at maturity? Face value= $ 1,000.00 CPI Nominal Real Stated coupon rate= 4.7% Year Inflation Cash Flow Cash Flow 1 2.0% 2 3.10% 5 6 7 8 9 10