1 2 3 Future Income Projection CPI Values 2a Below, you will generate the projected income...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 2 3 Future Income Projection CPI Values 2a Below, you will generate the projected income 5 years in the future You will base your 6 projection on CPI values that you look up. Use this procedure to look up the CPI value: 7 20 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to a CPI table for about the last 10 years. (You may need to change the values shown by using the "Change Output 2 Options" at the top of the page). 29 =0 20 3 4 First, fill in the CPI value for the given month (1 = Jan, 2 = Feb, etc.) and year. Then, fill in the CPI #1 25 values for the next 7 years, advancing exactly one year for each value. For example, if you start in 6 February 2011, your next CPI value will come from February 2012. Format your CPI values as 7 Numbers with 3 decimals of precision. 28 Month Number 2 #2 13 13 14 14 55 19 6 +7 Current Income 38 =9 10 1 12 12 13 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu 2. Check the box to the left of text "U.S. city average, All items - CUUR0000SAO" 14 15 16 $105,536.00 9 9 9 9 9 9 9 9 9 Year 2014 2015 2015 2016 2016 2017 2018 2019 2020 2021 2022 CPI Value 238.031 237.945 241.428 246.819 252.439 256.759 260.28 274.31 296.808 Green Gold Any other color Enter a number Enter an Excel formula Make no changes 2b 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. Slope (m) Y-Intercept (b) 6.445920103 1984.067595 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; 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-year Inflation Rate to your Current Income to find a 5-year Income Projection; and calculate the Projected Monthly Income. Use Excel formulas with cell references when appropriate for all gold cells. Format the Projected CPI Value as a Number with 3 decimal places and the 5-year Inflation Rate as a Percentage with 2 decimal places. Format Your Current Income, Your 5-year Income Projection, and Projected Monthly Income as Currency with 2 decimal places. Year you are Projecting your Income to (5 years after the last CPI value from 2a) Projected CPI Value for the Year you are Projecting to The 5-year Inflation Rate based on the last CPI value from 2a and the Projected CPI value Your Current Income (cell referenced from above)| Your 5-year Income Projection Projected Monthly Income 2027 Income and Projection - part 2c 1. 2. 3. 4. 5. 6. The Year you are projecting to represents 5 years after the last year in the CPI values table. Projected CPI Value for the Year you are Projecting to = slope*Year+y-intercept The five-year inflation rate is =(The projected CPI-last CPI value from 2a)/ last CPI value from 2a Cell reference the Current Income Your 5-year Income Proection inflation rate) current Projected Monthly Budget = Your 5-year Income Projection/12 ToJelleu LI I value as a univer with cumiar piaces and the Jaycan natin hale as a i cicilage will & uccinia nt Income, Your 5-year Income Projection, and Projected Monthly Income as Currency with 2 decimal places. Year you are Projecting your Income to (5 years after the last CPI value from 2a) Projected CPI Value for the Year you are Projecting to The 5-year Inflation Rate based on the last CPI value from 2a and the Projected CPI value Your Current Income (cell referenced from above) Your 5-year Income Projection Projected Monthly Income 2027 319.448 7.63% $60,736.00 $65,371.32 $5,447.61 1 2 3 Future Income Projection CPI Values 2a Below, you will generate the projected income 5 years in the future You will base your 6 projection on CPI values that you look up. Use this procedure to look up the CPI value: 7 20 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to a CPI table for about the last 10 years. (You may need to change the values shown by using the "Change Output 2 Options" at the top of the page). 29 =0 20 3 4 First, fill in the CPI value for the given month (1 = Jan, 2 = Feb, etc.) and year. Then, fill in the CPI #1 25 values for the next 7 years, advancing exactly one year for each value. For example, if you start in 6 February 2011, your next CPI value will come from February 2012. Format your CPI values as 7 Numbers with 3 decimals of precision. 28 Month Number 2 #2 13 13 14 14 55 19 6 +7 Current Income 38 =9 10 1 12 12 13 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu 2. Check the box to the left of text "U.S. city average, All items - CUUR0000SAO" 14 15 16 $105,536.00 9 9 9 9 9 9 9 9 9 Year 2014 2015 2015 2016 2016 2017 2018 2019 2020 2021 2022 CPI Value 238.031 237.945 241.428 246.819 252.439 256.759 260.28 274.31 296.808 Green Gold Any other color Enter a number Enter an Excel formula Make no changes 2b 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. Slope (m) Y-Intercept (b) 6.445920103 1984.067595 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; 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-year Inflation Rate to your Current Income to find a 5-year Income Projection; and calculate the Projected Monthly Income. Use Excel formulas with cell references when appropriate for all gold cells. Format the Projected CPI Value as a Number with 3 decimal places and the 5-year Inflation Rate as a Percentage with 2 decimal places. Format Your Current Income, Your 5-year Income Projection, and Projected Monthly Income as Currency with 2 decimal places. Year you are Projecting your Income to (5 years after the last CPI value from 2a) Projected CPI Value for the Year you are Projecting to The 5-year Inflation Rate based on the last CPI value from 2a and the Projected CPI value Your Current Income (cell referenced from above)| Your 5-year Income Projection Projected Monthly Income 2027 Income and Projection - part 2c 1. 2. 3. 4. 5. 6. The Year you are projecting to represents 5 years after the last year in the CPI values table. Projected CPI Value for the Year you are Projecting to = slope*Year+y-intercept The five-year inflation rate is =(The projected CPI-last CPI value from 2a)/ last CPI value from 2a Cell reference the Current Income Your 5-year Income Proection inflation rate) current Projected Monthly Budget = Your 5-year Income Projection/12 ToJelleu LI I value as a univer with cumiar piaces and the Jaycan natin hale as a i cicilage will & uccinia nt Income, Your 5-year Income Projection, and Projected Monthly Income as Currency with 2 decimal places. Year you are Projecting your Income to (5 years after the last CPI value from 2a) Projected CPI Value for the Year you are Projecting to The 5-year Inflation Rate based on the last CPI value from 2a and the Projected CPI value Your Current Income (cell referenced from above) Your 5-year Income Projection Projected Monthly Income 2027 319.448 7.63% $60,736.00 $65,371.32 $5,447.61
Expert Answer:
Answer rating: 100% (QA)
Here are the steps to project income 5 years into the future based on CPI values 1 The last year in ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
Prepare a brief (i.e. less than three-quarters of a page) memo addressed to Melissa suggesting the type of audit opinion that should be given and explain why you have chosen that opinion. Ensure that...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
In the figure below, which compares different DNA extraction kits (e.g, MO BIO and PSP), which one of the two trees shows the co-occurrence of microbial taxa? Proportion of max 0 0.2 0.4 0.6 0.8...
-
Discuss the following project situations, using just the following schedule and cost information:
-
a. "The flight of funds from bank deposits to U.S. stocks will pressure interest rates." b. "Since Japanese interest rates have recently declined to very low levels, expect a reduction in U.S....
-
H. J. Heinz Company is a global company engaged in several lines of business, including food service, infant foods, condiments, pet foods, and weightcontrol food products. Below is a five-year...
-
For 20Y3, Greyhound Technology Company reported its most significant decline in net income in years. At the end of the year, Duane Vogel, the president, is presented with the following condensed...
-
calculate the production cost variances and indicate whether they are favorable or unfavorable. Please show work
-
Recently, Google announced that it was offering Google Consumer Surveys ( www.google.com/insights/consumersurvey ) to anyone wanting to do marketing research. Google says that the service is for...
-
If a company receives $11,300 from a stockholder, the effect on the accounting equation would be: Multiple Choice Assets decrease $11,300 and equity decreases $11,300. Assets increase $11,300 and...
-
1. Research how profitable John Lewis and Waitrose have been in comparison with their major competitors in the last ten years. What conclusions can you draw? 2. Find out where your nearest John Lewis...
-
The Regal Cycle Company manufactures three types of bicycles-a dirt bike, a mountain bike, and a racing bike. Data on sales and expenses for the past quarter follow: Sales Variable manufacturing and...
-
The table shows data on four freshly prepared radioactive samples A, B, C and D. Number of active nuclei in the sample Sample A B D Which sample has the smallest activity? N N 5N 8N Half-life of the...
-
You are a member of multitalented team consisting of majors in psychology, finance, computer science and engineering. Senior management team of one of the local FinTech start up approaches you for...
-
Problem 1. The velocity field of a flow is given as V(x, y, z, t) = (3tx, -ty, -5xy) a) Is the flow steady or unsteady? b) Is it possible to approximate the flow as a two-dimensional flow? c)...
-
e EX 1-10 Total Financial statements of a manufacturing firm Obj. 4 The following events took place for Digital Vibe Manufacturing Company during March, the 0 first month of its operations as a...
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
Selected data for General Mills for 2007, 2008, and 2009 appear below (amounts in millions). 2009 2008 2007 Net income......................$1,304.4...............$1,294.7.................$1,144.0...
-
Assume that Motorola, Inc., issues bonds with a face value of $10,000,000 for $9,200,000. The bonds have detachable warrants that may be traded in for shares of common stock. Assume that immediately...
-
Using the following key, identify the effects of the following transactions or conditions on the various financial statement elements: I ¼ increases; D ¼ decreases; NE ¼ no...
-
In the 2010 Wells Report, what was the third most common way of detecting fraud? a. Tips b. Internal audits c. External audits d. By accident e. Reports from the police
-
According to the 2010 Wells Report, the most costly form of fraud was: a. Asset misappropriations b. Fraudulent disbursements c. Check tampering d. Fraudulent financial statements e. Bribery and...
-
Charles Moon, the managing director of your client Neptune plc, is negotiating with a view to Neptune plc acquiring the entire share capital of Sirius Group Ltd ('Sirius'). He has informed you that...
Study smarter with the SolutionInn App