Question

In: Finance

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

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....
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)....
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)....
Use MuPAD to compute the following limits.
Use MuPAD to compute the following limits.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT