Estimating Share Value Using the DCF Model 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 Reported Forecast Horizon Period Terminal millions 2018 2019 2020 2021 Sales NOPAT NOA 2022 $57,432 $58,286 $59,152 $60,032 $60,924 3,012 3,062 3,100 3,139 3,178 3,204 4,552 4,617 4,678 4,741 4,804 4,847 Period $61,528 Answer the following requirements with the following assumptions: Assumptions

Estimating Share Value Using the DCF Model 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 Reported Forecast Horizon Period Terminal millions 2018 2019 2020 2021 Sales NOPAT NOA 2022 $57,432 $58,286 $59,152 $60,032 $60,924 3,012 3,062 3,100 3,139 3,178 3,204 4,552 4,617 4,678 4,741 4,804 4,847 Period $61,528 Answer the following requirements with the following assumptions: Assumptions

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 74E

See similar textbooks

Similar questions

The Jimenez Corporation’s forecasted 2020 financial statements follow, along with some industry average ratios. Calculate Jimenez’s 2020 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez’s projected strengths and weaknesses. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2020 Jimenez Corporation: Forecasted Income Statement for 2020 Jimenez Corporation: Per Share Data for 2020 Notes: aIndustry average ratios have been stable for the past 4 years. bBased on year-end balance sheet figures. cCalculation is based on a 365-day year.
Profitability Ratios Katrina Corp. is a publicly traded company on a large stock exchange. Katrinas financial statement for 2019 and 2018 included the following data: Required: Calculate Katrinas earnings per share as it would be reported on the 2019 income statement.
Ratio Analysis Consider the following information. Required: Calculate the stockholder payout ratios. (Note: Round answers to two decimal places.) Calculate the stockholder profitability ratios. (Note: Round answers to two decimal places.)
Rate of Change Analyses and Ratios Analyses The following are Cohen Companys comparative financial statements for 2020, 2019, and 2018: Additional information: Credit sales were 65% of net sales in 2019 and 60% in 2020. At the beginning of 2020, 400 shares of common stock were issued, the first sale of stock in several years. Cohen is concerned. Although it increased the dividends paid per share by 5% in 2020 and its 2020 net income is higher than 2019 net income, the market price of its common stock dropped from 22 per share at the beginning of 2020 to 21 per share at year-end. Required: 1. For 2019 and 2020, prepare rate of change analyses for the income statements and balance sheets of Cohen using a year-to-year approach. 2. For 2019 and 2020, compute the following ratios; (a) current, (b) inventory turnover, (c) receivables turnover, (d) net profit margin, (e) earnings per share, (f) return on total assets, (g) return on shareholders equity, and (h) debt-to-assets. 3. Next Level Based on your results, discuss the possible reasons for the decrease in the market price per share in 2020.
Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.