A B D E F G H J K M 2 Below, you will find an annual income that someone could expect to earn result in missing or corrupted template elements. Copying cells from or into this template may once they start their career. Because they expect to enter into this career in likewise result in corrupted data. the future rather than today, you will need to project what that income will be five years in the future so you can investigate savings, investments and Legend If a cell is shaded You should Blue Enter a text response Current Income $78,416.00 Green Enter a number 12 Gold Enter an Excel formula 13 Fature Income Projection Cel Values Any other color Make no changes 14 2a Below, you will generate the projected income 5 years in the future You will base your projection on CPI values that you look up. Use this procedur= _ 1 the CPI value: 2 b Now, from the year and CPI values, find the slope and y-intercept of the best-fit line for your CPI values. Format your values as Numbers with 3 decimals of precision. 19 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi- bin/surveymost?cu Slope (m) 20 2. Check the box to the left of text "U.S. city average, All items - CUUROOCOSAO" Y-Intercept (b) 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to 23 a CPI table for about the last 10 years. (You may need to change the values shown by using the "Change Output Options" at the top of the page). 2C Use your slope and y-intercept to project the CPI 5 years in the future based on the Year you are Projecting the Income to; 25 calculate the 5-year Inflation Rate based on the last CPI value from the table in 2a and the Projected CPI Value; apply the 5- First, fill in the CPI value for the given month (1 = Jan, 2 = Feb, etc.) and year. Then, 26 year Inflation Rate to your Current Income to find a 5-year Income Projection; and calculate the Projected Monthly Income. fill in the CPI values for the next 8 years, advancing exactly one year for each value. 27 Use Excel formulas with cell references when appropriate for all gold cells. yample if you st It in February 2011 28 Month Number Year CPI Value Format the Projected CPI Value as a Number with 3 decimal places and the 5-year Inflation Rate as a Percentage with 2 1 2014 decimal places, Format Your Current Income, Your 5-year Income Projection, and Projected Monthly Income as Currency with 2 29 decimal places. 30 31 Grading Sheet - Rubric Income and Projection Student Loans Mortgage Rates Credit man Ready x Accessibility: Investigate 5:52 PM 86.F Q Search 9/28/2024 Windy