Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Advanced Accounting In Canada

Authors: Hilton Murray, Herauf Darrell

7th Edition

1259066487, 978-1259066481

More Books

Students also viewed these Accounting questions

Question

help me please!

Answered: 1 week ago