Estimating Share Value Using the ROPI Model Following are forecasts of sales, net operating profit after...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Estimating Share Value Using the ROPI Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported Terminal Horizon period NOA millions 2018 2019 2020 2021 2022 Period Sales $56,816 $57,670 $58,536 $59,416 $60,308 $60,912 NOPAT 2,492 2,542 2,580 2,619 2,658 2,684 3,936 4,001 4,062 4,125 4,188 4,231 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) Common shares outstanding 196 7.8% 135.6 million Net nonoperating obligations (NNO) $(6,225) million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31, 2018. ($ millions) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period ROPI (NOPAT -[NOABeg x rw]) $ $ $ $ $ Present value of horizon ROPI Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value Less NNO Firm equity value $ Shares outstanding (millions) $ Stock price per share (b) Humana (HUM) stock closed at $307.56 on February 21, 2019, the date the 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Estimating Share Value Using the ROPI Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Note: Complete the entire question in Excel and format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places. Reported Terminal Horizon period NOA millions 2018 2019 2020 2021 2022 Period Sales $56,816 $57,670 $58,536 $59,416 $60,308 $60,912 NOPAT 2,492 2,542 2,580 2,619 2,658 2,684 3,936 4,001 4,062 4,125 4,188 4,231 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) Common shares outstanding 196 7.8% 135.6 million Net nonoperating obligations (NNO) $(6,225) million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31, 2018. ($ millions) Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period ROPI (NOPAT -[NOABeg x rw]) $ $ $ $ $ Present value of horizon ROPI Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value Less NNO Firm equity value $ Shares outstanding (millions) $ Stock price per share (b) Humana (HUM) stock closed at $307.56 on February 21, 2019, the date the 10-K was filed with the SEC. How does your valuation estimate compare with this closing price?
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Exam scores of 40 students in a statistics class are shown. (a) Estimate the mean and standard deviation from the sample. (b) Assuming that the data are from a normal distribution, de ne bins by...
-
Ava Borzi is the new controller for Halo Software, Inc., which develops and sells education software. Shortly before the December 31 fiscal year-end, Jeremy Busch, the company president, asks Borzi...
-
For each claim, state H 0 and H a in words and in symbols. Then determine whether the hypothesis test is a left-tailed test, right-tailed test, or two-tailed test. Sketch a normal sampling...
-
Daily foreign exchange rates can be obtained from the Federal Reserve Bank of Chicago. The data are the noon buying rates in New York City certified by the Federal Reserve Bank of New York. Consider...
-
Deacon Publishing House is a publishing company that produces consumer magazines. The house and home division, which sells home-improvement and home-decorating magazines, has seen a 20% reduction in...
-
Pettijohn Inc. The balance sheet and income statement shown below are for Pettijohn Inc. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired...
-
What is the term for a community food collection program that provides groceries to be prepared and eaten at home? a. supermarket b. food pantry c. emergency kitchen d. farmer's market
-
Annual versus Monthly Payments: Assume you are borrowing $30,000 and plan to pay it back over a 3 year period. The annual interest rate you are being charged is 4.5%.
-
As the Senior Human Resources Officer, you are approached in your office one day by a male employee. The employee is undergoing a gender transition processes, has been working for the organization...
-
SadBoi, Inc. produces high quality water-proof tissue papers. Mr. Ramos, Sadboi's Managerial Accountant, has developed an annual formula using observations from the production of 10,000 to 25,000...
-
A certain portion of all disciplinary actions fails because supervisors do not know how to conduct personnel investigations. Explain the answer to this problem ?
-
If action on an issue is needed quickly and money is short, which of these is the least effective way to lobby? Question 9 options: a) direct lobbying b) grassroots lobbying c) outside lobbying d)...
-
The table below shows closing share prices for a small sample of companies. What is the mean? Price 42 98 53 17 72 41 74
-
Velshi Printers has contracts to complete weekly supplements required by fortysix customers. For the year 2018, manufacturing overhead cost estimates total $600,000 for an annual production capacity...
-
Revise cash collections budget (Learning Objective 4) Turn to the original Whitewater Sporting Goods Data Set item 4. Suppose \(70 \%\) of sales are cash and \(30 \%\) are credit. Revise Whitewater's...
-
Revise inventory, purchases, and cost of goods sold budget (Learning Objective 4) Refer to the original Whitewater Sporting Goods Data Set item 5. Suppose cost of goods sold averages \(75 \%\) of...
-
Revise cash payments for purchases (Learning Objective 4) Refer to the original Whitewater Sporting Goods Data Set item 5. Suppose Whitewater Sporting Goods pays for \(60 \%\) of inventory purchases...
Study smarter with the SolutionInn App