CPI Value Month Year Reference CPI 244.786 7 2017 Legend CPI one year later 252.006 7 2018 If a cell is shaded You should Yearly inflation rate (r) Blue Enter a text response Green Enter a number 9 Next, enter your budget total from cell G21 of the Monthly Budget sheet from your Major Assignment 1. Then, use the following Gold Enter an Excel formula formula to project your monthly budget forward 1, 5, and 10 years into the future: Any other color Make no changes A= B*(1+r)^t where A is the budget after t years; B is the initial budget; and r is the yearly inflation rate. Here, also calculate how much larger each budget is in percent than your initial budget. Format your Projected Budget entries as Currency with the $ symbol and 2 decimals of precision; format your Percent Increase cells as Percentages with 2 decimals of precision. Value oft Projected Budget Percent Increase over Current Budget Current Monthly Budget (B) Monthly Budget next year Monthly Budget in 5 years Monthly Budget in 10 years