View Help Wrap Text General Insert v 2 Merge & Center ~ $ ~ % 9 08 -20 Conditional Format as Cell Delete ~ Formatting ~ Table ~ Styles Format ~ Number Styles Cells E G H First, fill in the CPI value for the given month and year. Then, fill in the CPI values for the next 6 years, advancing each value. For example, if you start in February 2011, your next CPI value will come from February 2012. Form Year Number CPI Value Month Year 1 234.149 9 2013 2 238.031 19 2014 3 237.945 9 2015 4 241.428 9 2016 5 246.819 19 2017 6 252.439 9 2018 3b Now, from the year number and CPI values, find the slope and y-intercept of the best-fit line for your CPI values. Slope (m) Y-Intercept (0, b) 3C Finally, project the CPI forward an additional 5 years using your slope and intercept; calculate the 5-year inflation your year 6 CPI value and the calculated value; and apply the inflation rate to your budget total to find a 5-year budg The Year Number to use for your further 5-year projection The projected CPI value for that year The 5-year inflation rate based on the last CPI value in the table and the projected CPI value Your Budget Total (brought forward from above) Your 5-year Budget Total Projection Funding X w 1 10OF hp 112 ins f10 prt sc delete PPI 144 & backspa 8 O