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...
-
Daisey Company is a very profitable small business. It has not, however, given much consideration to internal control. For example, in an attempt to keep clerical and office expenses to a minimum,...
-
Use the power method with the x 0 given. List {x k } and { k } for k = 1,...,5. S [i] = [2 8] => 0x V L 9
-
The Longo Corporation issued \(\$ 50\) million maturity value of six percent coupon rate bonds, with interest paid semiannually. At the time of the bond issuance, equivalent risk-rated debt...
-
Building Maintenance Fund. The balance sheet and statement of revenues, expenditures. and changes in fund balance for the Building Maintenance Fund, an internal service fund of Coastal City, are...
-
A local Chevrolet dealership carries the following types of vehicles: Inventory Items Quantity Unit Cost Unit NRV Vans 4 $27,000 $25,000 Trucks 7 18,000 17,000 2-door sedans 3 13,000 15,000 4-door...
-
For Simonsen Village, prepare a government-wide statement of net position and statement of activities, and a governmental funds balance sheet and statement of revenues, expenditures, and changes in...
-
Solve the equation below: c) logx-log(x - 1) = 1 CS
-
Calculate the accumulated value of $10879.35 at 7.9% compounded quarterly for 6 years. How much of the amount is interest? Calculate to two decimals. Do not use commas or $ signs. Answer:
-
The heat equation, as given in the introduction, can also be rearranged to calculate the mass or temperature change for a substance. Follow the same steps used to calculate the quantity of heat...
-
The following program does not compile correctly or type check correctly using the comp compiler and type inference system. However, it is a valid Standard ML program. Modify both the comp compiler...
-
discuss why a company might want to repurchase some of its outstanding shares? What benefit could this provide for the company and for shareholders? What is the likely change that would occur to the...
-
Q3:Using the lists of common spatial and temporal scales, decide which spatial and temporal scale you would use if you wished to study each of the following physical events. Additionally, you must...
-
Think of a product to buy. Identify the product and discuss which of the 4 "Ps" (product, price, place, promotion) of the marketing mix most impacts the choice. Do you think one of the "Ps" within...
-
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...
-
Which product costing system would most likely be used to account for a home builder building custom homes for its customers? a. Job order costing b. Process costing c. Normal costing d. Standard...
-
Which of the following is usually not found on a job order cost sheet? a. Manufacturing overhead b. Finished units currently on hand c. Direct materials d. Unit cost Never
-
Which of the following is not one of the categories of cost involved in the allocation of service department costs? a. Service department costs allocated to production departments b. Costs directly...
Study smarter with the SolutionInn App