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
-
Cash Flow to Stockholders The 2 0 1 3 balance sheet of Maria's Tennis Shop, Inc., showed $ 6 7 0 , 0 0 0 in the common stock account and $ 5 . 9 million in the additional paid - in surplus account....
-
Kenley Corporation Comparative Balance Sheets June 30, 2013 and June 30 2014 Assets 2013 2014 Cash 12,500 69,900 Accounts Receivable 36,000 31,000 Inventory 51,400 46,400 Prepaid Expenses 2,600 3,200...
-
Wong Tai Sin Corporation s stock currently sells for $ 9 0 per share. There are cur - rently 3 , 0 0 0 , 0 0 0 shares outstanding. Yesterday the firm has issued rights to raise new equity capital. To...
-
Most businesses will incur debt at some point during their existence. Question 26 options: True False
-
Four years ago, Mr. Bates purchased 1,000 shares of UPF Inc. for $10,000. These shares represent a 30 percent equity interest in UPF, which is an S corporation. This year, UPF defaulted on a $120,000...
-
The flat-bed trailer carries two 1500-kg beams with the upper beam secured by a cable. The coefficients of static friction between the two beams and between the lower beam and the bed of the trailer...
-
Some of Castel Co.s cash receipts from customers are sent to the company with the regular mail. Castels recordkeeper opens these letters and deposits the cash received each day. (a) Identify any...
-
Little Oil has outstanding 1 million shares with a total market value of $20 million. The firm is expected to pay $1 million of dividends next year, and thereafter the amount paid out is expected to...
-
Assume the U.S. has only four citizens, who earned the following income (all taxable) for 2020: Citizen A = $12,000 Citizen B = $25,000 Citizen C = $50,000 Citizen D = $100,000 The citizens have...
-
Most changes on a project are related to? AScope Changes B Improvement Changes C Implementing Contingency Plans D All of the above
-
Rodino Inc. manufactures small tents for hiking. For financial year starting on 2020 Rodino Inc. budgeted the production of 6,000 units. The costs of production are presented below. Manufacturing...
-
Devops and Microservices MyFlix Assignment I will need to build a system similar to the Netflix platform (although very much simpler). We have discussed this at length in the lectures and all the...
-
An example of an ethical or legal dilemma related to child and adolescent health psychology. Then explain two strategies you might use to address this dilemma as a future health psychology...
-
Some examples of social norms that students have violated aresitting with strangers at the same table at the food court in themall, men wearing lipstick and nail polish, going into therevolving door...
-
Hrubec Products, Inc., operates a Pulp Division that manufactures wood pulp for use in the production of various paper goods. Revenue and costs associated with a ton of pulp follow: Selling price $23...
-
Brooklyn Studio's sales are all made on account. The firm's collection experience has been that 25% of a month's sales are collected in the month the sale is made, 60% are collected in the month...
-
A researcher reports a significant two-way between-subjects ANOVA, F(3, 40) = 2.96. State the decision to retain or reject the null hypothesis for this test.
-
One year ago the exchange rate between Polish zloty and the U.S. dollar was \(\mathrm{Z} 3.8000 / \mathrm{S}\). Since then the zloty has fallen \(14 \%\) against the dollar. Price levels in the...
-
On January 12, 2010, a 7.0 earthquake struck Haiti, leveling thousands of homes, cutting off electricity and telephone service, killing thousands, and leaving thousands more homeless and destitute in...
-
Pinot Noir wine is produced in the states of California (U.S.A.) and New South Wales (Australia). Equivalent bottles of Pinot Noir sell in the United States for US\$22 and in Australia for A\$34. a....
Study smarter with the SolutionInn App