Estimating Share Value Using the ROPI Model Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Forecast Horizon Period Reported Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $101,711 $108,830 $116,449 $124,600 $133,322 $135,989 NOPAT 11,349 12,189 13,043 13,955 14,932 15,231 NOA 24,013 25,692 27,490 29,414 31,474 32,103 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $25,779 million. a. Estimate the value of a share of Home Depot common stock using the residual operating income (ROPI) model as of February 3, 2019. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $ 0

Estimating Share Value Using the ROPI Model Following are forecasts of Home Depot's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 3, 2019, which the company labels fiscal 2018. Forecast Horizon Period Reported Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $101,711 $108,830 $116,449 $124,600 $133,322 $135,989 NOPAT 11,349 12,189 13,043 13,955 14,932 15,231 NOA 24,013 25,692 27,490 29,414 31,474 32,103 Answer the following requirements assuming a discount rate (WACC) of 7.85%, a terminal period growth rate of 2%, common shares outstanding of 1,105 million, net nonoperating obligations (NNO) of $25,779 million. a. Estimate the value of a share of Home Depot common stock using the residual operating income (ROPI) model as of February 3, 2019. Note: Do not round until your final answer; round your final answer to two decimal places. Stock price per share: $ 0

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Assume this is a partial list of financial highlights from a Best Buy annual report: 2019 2020 (dollars in millions). $ 37,580 $ 33,075 1,283 891 2,231 1,318. Net sales Earnings before taxes Net earnings Complete a horizontal and vertical analysis from the above information. (Enter your answers in millions. Round the "percent" answers to the nearest hundredth percent.) Net sales Earnings before taxes Net earnings 2020 Horizontal analysis 2019 Increase Percent Vertical analysis 2020 % % % 2019 + % % %
Please detailed
Abbott Laboratories’ Consolidated Statements of Earnings for the 3 fiscal year’s ending December 31, 2019. Required: Using the attached earnings statement, for each period presented, Compute the gross margin % Note: Gross margin % = [(Net sales – Cost of products sold)/Net sales] x 100 Compute the net profit margin on sales % Note: Net profit margin % = (Net earnings/Net sales) x 100 Considering the 3-year trend for a. and b. above, provide a brief comment about the company’s performance for: Gross margin % and Net profit margin %.
Obtain Target Corporation's annual report for its 2018 fiscal year (year ended February 2, 2019) at http://investors.target.com a. What was Target's gross margin percentage for the fiscal year ended February 2, 2019 (2018) and 2017? Use "Sales" for these computations b. What was Target's Return on Sales percentage for 2018 and 2017? Use "Total Revenue" for these computations. c. Target's return on ales percentage for 2017 was higher than it was in 2018. Ignoring taxes, how much higher would Target's 2018 net income have been if it's return on sales percentage in 2018 had been the same as for 2017?
Estimating Share Value Using the DCF Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. 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. a. Forecast the terminal period values assuming the following terminal period growth rate. Assumption Terminal period growth rate 1% Reported Forecast Horizon Period Terminal $ millions 2018 2019 2020 2021 2022 Period Sales $15,544 $16,010 $16,491 $16,985 $17,495 Answer NOPAT 2,737 2,818 2,902 2,989 3,079 Answer NOA 5,837 6,012 6,193 6,378 6,570 Answer b. Estimate the value of a share of Colgate-Palmolive common stock using the discounted cash flow (DCF) model using the following assumptions and the information above. Assumptions Discount rate (WACC) 5.70% Common shares outstanding 863.0 million Net…
Estimating Share Value Using the DCF ModelAssume following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,750 $ 4,500 $ 5,400 $ 6,480 $ 7,776 $ 7,853 NOPAT 464 539 654 794 982 960 NOA 1,320 1,602 1,933 2,332 2,791 2,802 Answer the following requirements assuming a discount rate (WACC) of 13.3%, a terminal period growth rate of 1%, common shares outstanding of 86.2 million, and net nonoperating obligations (NNO) of $(261) million (negative NNO reflects net nonoperating assets such as investments rather than net obligations).(a) Estimate the value of a share of Abercrombie & Fitch common stock using the discounted cash flow (DCF) model as of January 29, 2011. Rounding instructions: Round answers to the nearest whole number unless noted otherwise. Use your rounded answers for…
(Profitability Ratio)What is the Return on Common Stock in 2020?
Estimating Share Value Using the ROPI Model Following are forecasted sales, NOPAT, and NOA for Colgate-Palmolive Company for 2019 through 2022. Forecast Horizon Period Colgate Palmolive (CL) Reported $ millions 2018 2019 2020 2021 2022 Sales $13,990 $14,409 $14,842 $15,287 $15,746 NOPAT 2,463 2,536 2,612 2,690 2,771 NOA 5,253 5,411 5,574 5,740 5,913 a. Forecast the terminal period values for Sales, NOPAT, and NOA, assuming a 1% terminal period growth rate. Note: Round answers to the nearest dollar. Terminal period sales 2$ 15,903 Terminal period NOPAT $ 2,799 Terminal period NOA 2$ 5,972 b. Estimate the value of a share of Colgate-Palmolive common stock using the residual operating income (ROPI) model. Assume a discount rate (WACC) of 5.70%, common shares outstanding of 862.9 million, net nonoperating obligations (NNO) of $5,076 million, and noncontrolling interest (NCI) from the balance sheet of $269 million. Note: Round answers to two decimal places. $ 0 c. Colgate-Palmolive stock…
2. Calculate the financial leverage - equity multiplier and cash cover ratio
Refine Assumptions for PPE ForecastFollowing are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income (loss) before income taxes 5,197 Income tax provision 547 Net income (loss) 4,650 Net (income) loss attributable to noncontrolling interests (19) Net income (loss) attributable to Medtronic $ 4,631 Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, less…
Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are income statements and balance sheets for Cisco Systems. 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. Cisco Systems Consolidated Statements of Income Years Ended December ($ millions) July 27, 2019 July 28, 2018 Revenue Product $33,544 $31,570 Service 11,093 10,854 Total revenue 44,637 42,424 Cost of sales Product 12,782 12,407 Service 3,763 3,695 Total cost of sales 16,545 16,102 Gross margin 28,092 26,322 Operating expenses Research and development 5,656 5,446 Sales and marketing 8,231 7,948 General and administrative 1,571 1,844 Amortization of purchased intangible assets 129 190 Restructuring and other charges 277 308 Total operating expenses 15,864 15,736 Operating income 12,228 10,586 Interest income 1,125 1,297 Interest expense (739) (811) Other…
What is the Retained earnings - 2020 (restated)?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS