Computing ROPI for Multiple Years Use the following data to compute ROPI for Intel Corporation for...

Computing ROPI for Multiple Years
Use the following data to compute ROPI for Intel Corporation for 2016 through the terminal period. Assume that the company's weighted average cost of capital is 9%.

	Actual	Horizon Period				Terminal
$ millions	2015	2016	2017	2018	2019	Period
Sales	$55,466	$61,555	$67,699	$73,771	$78,962	$80,511
NOPAT	11,343	13,573	14,248	15,524	15,825	15,331
NOA	51,488	57,157	62,873	68,521	72,674	74,101

Round answers to the nearest whole number.

	Forecast Horizon				Terminal
($ millions)	2016	2017	2018	2019	Period

ROPI	Answer	Answer	Answer	Answer	Answer

Solutions

Expert Solution

We know that

ROPI = Residual operating income = NOPAT - (Beginning NOA x WACC)

Beginning NOA of a year = Ending NOA of previous year

For year 2016, NOPAT = 13573 and Beginning NOA = Ending NOA of 2015 = 51488

ROPI = 13573 - 51488 x 9% = 13573 - 4633.92 = 8939.08 = 8939 (rounded to nearest dollar)

For year 2017, NOPAT = 14248 and Beginning NOA = Ending NOA of 2016 = 57157

ROPI = 14248 - 57157 x 9% = 14248 - 5144.13 = 9103.87 = 9104 (rounded to nearest dollar)

For year 2018, NOPAT = 15524 and Beginning NOA = Ending NOA of 2017 = 62873

ROPI = 15524 - 62873 x 9% = 15524 - 5658.57 = 9865.43 = 9865 (rounded to nearest dollar)

For year 2019, NOPAT = 15825 and Beginning NOA = Ending NOA of 2018 = 68521

ROPI = 15825 - 68521 x 9% = 15825 - 6166.89 = 9658.11 = 9658 (rounded to nearest dollar)

For terminal period NOPAT = 15331 Beginning NOA = 72674

ROPI = 15331 - 72674 x 9% = 15331 - 6540.66 = 8790.34 = 8790 (rounded to nearest dollar)

Answer:

	Forecast Horizon				Terminal
($ millions)	2016	2017	2018	2019	Period

ROPI	8939	9104	9865	9658	8790

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Computing Present Value of Terminal Residual Operating Income Use the following data to compute the present...

Computing Present Value of Terminal Residual Operating Income Use the following data to compute the present value of the terminal period ROPI for each of the four firms A through D. Assume a forecast horizon of four years. A B C D Terminal period ROPI $208,011 $46,767 $93,674 $124,622 Weighted average cost of capital (WACC) 8.1% 11.9% 9.7% 13.9% Terminal growth period rate 2.0% 1.0% 2.5% 2.0% Do not round until your final answers. Round your answers to the nearest...

Computing Present Value of Terminal Period FCFF Use the following data to compute the present value...

Computing Present Value of Terminal Period FCFF Use the following data to compute the present value of the terminal period free cash flows to the firm for each of the four firms A, B, C, and D. The forecast horizon included four years. A B C D Terminal period free cash flow to the firm (FCFF) $72,670 $16,813 $101,517 $44,672 WACC 5.0% 6.2% 4.3% 11.0% Terminal period growth rate 1.0% 1.0% 2.0% 1.5% Round answers to the nearest whole number....

Computing Present Value of Terminal Period FCFF Use the following data to compute the present value...

Computing Present Value of Terminal Period FCFF Use the following data to compute the present value of the terminal period free cash flows to the firm for each of the four firms A, B, C, and D. The forecast horizon included four years. A B C D Terminal period free cash flow to the firm (FCFF) $62,670 $6,813 $91,517 $34,672 WACC 5.0% 6.2% 4.3% 11.0% Terminal period growth rate 1.0% 1.0% 2.0% 1.5% Round answers to the nearest whole number....

Compute the following ratios for two years. You may use Excel to compute your ratios. (all...

Compute the following ratios for two years. You may use Excel to compute your ratios. (all these formulas should be bases on the company you picked, in this case (Johnson & Johnson) use numbers from balance sheet and income statements found online. Debt ratio Gross profit margin Free cash flow Times interest earned Accounts receivable turnover Inventory turnover Prepare a DuPont Analysis of ROE for two years, including computations of Return on Sales Asset Turnover Return on Assets Financial Leverage...

Use the following data to develop a multiple regression model to predict from and . Discuss...

Use the following data to develop a multiple regression model to predict from and . Discuss the output, including comments about the overall strength of the model, the significance of the regression coefficients, and other indicators of model fit. y x1 x2 198 29 1.64 214 71 2.81 211 54 2.22 219 73 2.70 184 67 1.57 167 32 1.63 201 47 1.99 204 43 2.14 190 60 2.04 222 32 2.93 197 34 2.15 Appendix A Statistical Tables *(Round...

Directions: Use SPSS to compute the Regression Line. Problem: Using the following set of data and...

Directions: Use SPSS to compute the Regression Line. Problem: Using the following set of data and Excel, compute the regression line. The data set represents the number of hours of training to predict how severe injuries will be if someone is injured playing football. Briefly summarize your findings. Training Injuries Training Injuries 12 8 11 5 3 7 16 7 22 2 14 8 12 5 15 3 11 4 16 7 31 1 22 3 27 5 24 8...

Tax Drill - Computing the Standard Deduction Compute the 2017 standard deduction for the following taxpayers....

Tax Drill - Computing the Standard Deduction Compute the 2017 standard deduction for the following taxpayers. If an amount is zero, enter "0". Click here to access the standard deduction table to use. a. Margie is 15 and claimed as a dependent by her parents. She has $800 in dividends income and $1,400 in wages from a part-time job. $ b. Ruby and Woody are married and file a joint tax return. Ruby is age 66 and Woody is 69....

Do PESTEL Model Analysis for intel corporation in 2017

The following is information for Intel. Intel wants to pursue a new type of artificial intelligence...

The following is information for Intel. Intel wants to pursue a new type of artificial intelligence (AI) chip that would be used in autonomous vehicles. They want to know what they should use for their WACC (weighted average cost of capital). Preferred stock sells for $145 and pays an annual dividend of $13.25. There are currently 20 year 5.1% coupon bonds that pay semi-annual payments and are non-callable available at a price of $1,016.79. The bond-yield risk premium is 4%....

Selected data for the Derby Corporation are shown below. Use the data to answer the following...

Selected data for the Derby Corporation are shown below. Use the data to answer the following questions. INPUTS (In millions) Year Current Projected 0 1 2 3 4 Free cash flow -$20.0 $20.0 $80.0 $84.0 Marketable Securities $40 Notes payable $100 Long-term bonds $300 Preferred stock $50 WACC 9.00% Number of shares of stock 40 a. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow)....

Subjects