Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Note:
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. Forecast Horizon Period $ millions Sales NOPAT NOA Reported Terminal 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 2,684 4,032 4,097 4,158 4,221 4,284 4,327 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate 196 Discount rate (WACC) 7.8% Common shares outstanding 135.60 million Net nonoperating obligations (NNO) $(6,129) million Noncontrolling interest $0 million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of Humana's common stock using the discounted cash flow (DCF) model as of December 31, 2018. ($ millions) Increase in NOA FCFF (NOPAT - Increase in NOA) Present value of horizon FCFF Cum. present value of horizon FCFF $ Present value of terminal FCFF Total firm value NNO Firm equity value Shares outstanding (millions) Stock price per share $ $ Reported 2018 Forecast Horizon Terminal 2019 2020 2021 2022 Period $ $ $ $ $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started