The mean real income is on the bottom right of the chart. How do you calculate projected real income ?
Price index =
Intercept + (Coefficient) x (Year)
Assume that Mrs. Cook's real income wil not change over the next ten years. Use the mean real income from previous steps to determine projected real income for the future ten years of Mrs. Cook's work expectancy. Use the regression equation from hint 2 to project adjusted price indices for the next ten years. Assume that Mrs. Cook pays 20% of her actual income in taxes and that Green will not provide significant state assistance Use the projected real income and adjusted price indices to estimate Mrs. Cook's net actual income for the next ten years. What would be the likely amount of an award to Mrs. Cook based on a present value rate of 8%? Discuss the factors that could cause Mrs. Cook's future income to differ from your estimale. Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Year 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Gross Income Price Index Adjusted Price Index Real Income Real Income 60 056 188.9 1.889 31,792.48 31792.48 61,257 195.3 1.953 31,365,59 31.365.59 62,482 201.6 2016 10.993.06 30.993.06 63,732 2073 2.073 30,743 85 30 743 85 65 007 215.3 2.153 30,193.68 30 193.68 66,307 214.5 2.145 30.912.35 30.912.35 67,633 218.1 2.181 31.010.09 31.010.09 68,986 2249 2.249 30,674,08 30,674.08 70,366 229.6 2.296 30,647 21 30,647 21 71.773 233 2.33 30.803,86 30.803.86 73,208 236.7 2.367 30.928.60 30,928.60 74,672 237 2.37 31,507.17 31,507.17 76,165 240 24 31.735.42 31,736 42 77 688 245.1 2.451 31,696.45 31 696 45 79.242 251.1 2 511 31,557 95 31,557.95 Group 7: Formulas and Findings Adjuted Price Index Price index/100 Real income Gross income Adj. Price Index Total: Mean: Median: Standard Deviation: Variance 466,561 84 31,104.12 30.993.06 477 44 22795101 466,561.84 31,104.12 30.993.06 477 44 227951.01 1. Use mean real income from question 1 to determine projected real income for 2019-2028. 2. Use regression equation from question 2 to determine projected adjusted price indices. 3. Use projected real income, adjusted price indices, and tax to estimate Mrs. Cook's net actual income for 2019 - 2028. 1 4. Determine the present value of the future net cash flow. Assume that Mrs. Cook's real income wil not change over the next ten years. Use the mean real income from previous steps to determine projected real income for the future ten years of Mrs. Cook's work expectancy. Use the regression equation from hint 2 to project adjusted price indices for the next ten years. Assume that Mrs. Cook pays 20% of her actual income in taxes and that Green will not provide significant state assistance Use the projected real income and adjusted price indices to estimate Mrs. Cook's net actual income for the next ten years. What would be the likely amount of an award to Mrs. Cook based on a present value rate of 8%? Discuss the factors that could cause Mrs. Cook's future income to differ from your estimale. Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Year 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Gross Income Price Index Adjusted Price Index Real Income Real Income 60 056 188.9 1.889 31,792.48 31792.48 61,257 195.3 1.953 31,365,59 31.365.59 62,482 201.6 2016 10.993.06 30.993.06 63,732 2073 2.073 30,743 85 30 743 85 65 007 215.3 2.153 30,193.68 30 193.68 66,307 214.5 2.145 30.912.35 30.912.35 67,633 218.1 2.181 31.010.09 31.010.09 68,986 2249 2.249 30,674,08 30,674.08 70,366 229.6 2.296 30,647 21 30,647 21 71.773 233 2.33 30.803,86 30.803.86 73,208 236.7 2.367 30.928.60 30,928.60 74,672 237 2.37 31,507.17 31,507.17 76,165 240 24 31.735.42 31,736 42 77 688 245.1 2.451 31,696.45 31 696 45 79.242 251.1 2 511 31,557 95 31,557.95 Group 7: Formulas and Findings Adjuted Price Index Price index/100 Real income Gross income Adj. Price Index Total: Mean: Median: Standard Deviation: Variance 466,561 84 31,104.12 30.993.06 477 44 22795101 466,561.84 31,104.12 30.993.06 477 44 227951.01 1. Use mean real income from question 1 to determine projected real income for 2019-2028. 2. Use regression equation from question 2 to determine projected adjusted price indices. 3. Use projected real income, adjusted price indices, and tax to estimate Mrs. Cook's net actual income for 2019 - 2028. 1 4. Determine the present value of the future net cash flow