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...
-
Total Glass Company repairs chips in car windshields in the companys home county. Gary White, the owner, incurred the following operating costs for the month of July 2012: Salaries and wages . . . ....
-
Explain why the cost per thousand method is so flawed.
-
Think of the last position you had or the current job you are in. What type of organizational structure was in place? Was it working for the organization? Did you feel comfortable within the...
-
Greene Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2013. 1. Sales: Quarter 1,...
-
un estudio que seale cul porcentaje de la poblacin de recin titulados (no ms de cinco aos desde que obtuvo el diploma) de las universidades de Nicaragua encuentran un empleo relacionado con la...
-
Men food shop differently than women, preferring to buy just enough for the next couple of meals and sticking to brands they know, regardless of price. Could this be a lack of confidence in the...
-
If interest rates rise 5% and if you own a bond with a maturity of 10years and a duration of 5with a 5% yield your bond price will change by approximately what percentage amount? A- up 5% b- down 5%...
-
Hi, could you help to identify and fix my mistakes? I try to perform cross-validation but have no idea how answer to questions correctly. 1. Consider the following model: diabetic status (*Diabetes*;...
-
A 0.5530 kg ice cube at -12.40 C is placed inside a rigid, thermally isolated chamber containing 6.910 moles of steam at 365.0C. Later, you notice that the ice cube has completely melted into a...
-
need to be C++ for an academic integrity violation. Prerequisite Knowledge Although many teachers use total points to calculate student grades for a course, some use weighted categories. It is...
-
A group of big furniture and electronics stores asked you to estimate a model that determines the probability of households to own durable goods from a sample of 200 households. As an econometrician...
-
Mikolas Proude is seeking to establish an investment portfolio with 2 investments. These are a zero coupon bond with the government authority, Sandgrid, requiring an initial investment of $5 000 and...
-
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...
-
After factory overhead has been applied to work in process, what does a credit balance in Factory Overhead indicate?
-
Explain the difference between actual factory overhead and applied factory overhead.
-
To which work sheet column is the debit balance of Cost of Goods Sold extended?
Study smarter with the SolutionInn App