Question: Estimating Share Value Using the DCF ModelFollowing are forecasts of sales, net operating profit after tax ( NOPAT ) , and net operating assets (
Estimating Share Value Using the DCF ModelFollowing are forecasts of sales, net operating profit after tax NOPAT and net operating assets NOA as of December 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.ReportedForecast Horizon PeriodTerminalmillionsSalesNOPATNOA$$$$$Period$Answer the following requirements with the following assumptions:Answer the following requirements with the following assumptions:AssumptionsTerminal period growth rateDiscount rate WACCCommon shares outstanding millionNet nonoperating obligations NNO$ millionNoncontrolling interest$ millionNNO 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 Forecast HorizonTerminalE$ millionsReportedIncrease in NOAFCFF NOPAT Increase in NOAPresent value of horizon FCFFCum. present value of horizon FCFF $Present value of terminal FCFFTotal firm valueNNOFirm equity valueShares outstanding millionsStock price per share
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
