Course Content / Graded Assignments / Module 13 and 14 Graded Assignment Estimating Share Value Using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Course Content / Graded Assignments / Module 13 and 14 Graded Assignment Estimating Share Value Using the ROPI Model Module 13 and 14 Graded Assignment 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 Horizon period Terminal $ millions Sales NOPAT NOA 2018 2019 2020 2021 2022 Period $56,912 $57,766 $58,632 $59,512 $60,404 $61,008 2,492 2,542 2,580 2,619 2,658 4,032 4,097 4,158 4,221 4,284 2,684 4,327 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 1% 7.8% 135.6 million Discount rate (WACC) Common shares outstanding Net nonoperating obligations (NNO) $(6,129) 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 2019 2020 2021 2022 Terminal Period ROPI (NOPAT - [NOABeg x rw]) Present value of horizon ROPI $ 0 $ 0 $ 0 0 0 $ 0 0 $ 0 0 0 0 0 0 0 $ 0 Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value Less NNO Firm equity value Shares outstanding (millions) tA 0 Course Content / Graded Assignments / Module 13 and 14 Graded Assignment Estimating Share Value Using the ROPI Model Module 13 and 14 Graded Assignment 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 Horizon period Terminal $ millions Sales NOPAT NOA 2018 2019 2020 2021 2022 Period $56,912 $57,766 $58,632 $59,512 $60,404 $61,008 2,492 2,542 2,580 2,619 2,658 4,032 4,097 4,158 4,221 4,284 2,684 4,327 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 1% 7.8% 135.6 million Discount rate (WACC) Common shares outstanding Net nonoperating obligations (NNO) $(6,129) 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 2019 2020 2021 2022 Terminal Period ROPI (NOPAT - [NOABeg x rw]) Present value of horizon ROPI $ 0 $ 0 $ 0 0 0 $ 0 0 $ 0 0 0 0 0 0 0 $ 0 Cum present value of horizon ROPI $ Present value of terminal ROPI NOA Total firm value Less NNO Firm equity value Shares outstanding (millions) tA 0
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Most businesses will incur debt at some point during their existence. Question 26 options: True False
-
Why have labor and management tended to treat each other as adversaries in the U.S. labor relations system?
-
How many degrees of freedom are there? Exercises 49 refer to the following data: Electric motors are assembled on four different production lines. Random samples of motors are taken from each line...
-
Using the following partial listing of T accounts, prepare closing entries in general journal form dated May 31, 20--. Then post the closing entries to the Taccounts. Income Supplies Expense 900 Cash...
-
Analyze the complexities of urban infrastructure planning and design, considering factors such as population growth, land use dynamics, and climate change resilience, and discuss innovative...
-
An electron travels to the right at \(3.0 \times 10^{6} \mathrm{~m} / \mathrm{s}\) between two large, flat sheets that are parallel to each other and to the electron's line of motion. If currents per...
-
The plates of a capacitor are charged using a battery, and they produce an electric field across the separation distance \(d\) between them. The two plates are now to be pushed together to a...
-
Two parallel-plate capacitors have the same plate area. Capacitor 1 has a plate separation twice that of capacitor 2 , and the quantity of charge you place on capacitor 1 is twice the quantity you...
-
A region of space contains a changing magnetic field given by \(\vec{B}(t)=B_{0} e^{-t / \tau} \hat{k}\), and a circular conducting loop of radius \(R\) lies in this region in the \(x y\) plane. (a)...
-
A fellow scientist heard that a Van de Graaff generator built 70 years ago could collect \(5.0 \mathrm{C}\) of charge on its dome, which had a radius of \(1.1 \mathrm{~m}\), and has challenged you to...
Study smarter with the SolutionInn App