Estimating Share Value Using the DCF 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. Module Reported Forecast Horizon Period Terminal $ millions 2018 2019 2020 2021 2022 Period $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 Sales NOPAT NOA 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 $27,424 million. Required a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) 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: $ 519 x b. Home Depot stock closed at $190.06 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Stock price is appropriately valued +

Estimating Share Value Using the DCF 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. Module Reported Forecast Horizon Period Terminal $ millions 2018 2019 2020 2021 2022 Period $108,203 $115,777 $123,882 $132,553 $141,832 $144,669 12,073 12,967 13,875 14,846 15,885 16,203 25,546 27,332 29,245 31,292 33,483 34,152 Sales NOPAT NOA 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 $27,424 million. Required a. Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) 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: $ 519 x b. Home Depot stock closed at $190.06 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your valuation estimate compare with this closing price? Stock price is appropriately valued +

Name: Estimating Share Value Using the DCF ModelFollowing are forecasts of
Uploaded: 2024-03-20T06:33:21.000Z
Channel: Bartleby
Description: Estimating Share Value Using the DCF ModelFollowing 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.ModuleForecast Horizon Perio

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

Using the fiscal year end 2019 annual report for General Mills, Inc. and the figures from the 2017 annual report as noted below, calculate the financial ratios for 2019 and 2018 indicated using the EXCEL template provided: Gross profit percentage Return on sales Asset turnover Return on assets Return on common stockholders’ equity Current ratio Quick ratio Operating-cash-flow-to-current-liabilities ratio Accounts receivable turnover Average collection period Inventory turnover Days’ sales in inventory Debt-to-equity ratio Times-interest-earned ratio Operating-cash-flow-to-capital-expenditures ratio Earnings per share Price-earnings ratio Dividend yield Dividend payout ratio Total assets 2017 = $21,812.6 Total stockholders’ equity 2017 = $4,327.9 Total current liabilities 2017 = $5,330.8 Accounts receivable 2017 = $1,430.1 Inventory 2017 = $1,483.6 Year-end closing stock price May 2019 = $50.93 Year-end closing stock price May 2018 = $39.37 Perform a comparative analysis of the…
23. Condensed financial data of Novak Company for 2020 and 2019 are presented below. NOVAK COMPANYCOMPARATIVE BALANCE SHEETAS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $1,830 $1,180 Receivables 1,710 1,320 Inventory 1,590 1,920 Plant assets 1,890 1,710 Accumulated depreciation (1,220 ) (1,190 ) Long-term investments (held-to-maturity) 1,320 1,440 $7,120 $6,380 Accounts payable $1,190 $890 Accrued liabilities 210 260 Bonds payable 1,400 1,580 Common stock 1,940 1,660 Retained earnings 2,380 1,990 $7,120 $6,380 NOVAK COMPANYINCOME STATEMENTFOR THE YEAR ENDED DECEMBER 31, 2020 Sales revenue $6,720 Cost of goods sold 4,680 Gross margin 2,040 Selling and administrative expenses 920 Income from operations…
Abbreviated financial statements for Archimedes Levers are shown in the table below. Assume sales and expenses increase by 14% in 2022 and all assets and liabilities increase correspondingly. Income Statement Sales Costs, including interest Net income Net assets Total $ 4,800 3,900 $ 900 Balance Sheet, Year-End 2021 2020 $ 3,936 $3,500 $ 3,936 $3,500 Debt Equity Total 2021 $ 1,536 2,400 $ 3,936 2020 $1,433 2,067 $3,500 a. If the payout ratio is set at 50% and no external debt or equity is to be issued, what is the maximum possible growth rate for Archimedes? b. If the payout ratio is set at 50% and the firm aintains a fixed debt ratio but issues no equity, what is the maximum possible growth rate for Archimedes? Note: For all requirements, do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.
Estimating Share Value Using the ROPI Model Following are forecasts of sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of December 31, 2018, for Humana. Terminal 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 place Reported Horizon period $ millions 2018 2019 2020 2021 2022 Period Sales $56,880 $57,734 $58,600 $59,480 $60,372 2,492 2,542 2,580 2.619 2,658 4,000 4,065 4,126 4,189 4,252 NOPAT NOA $60,976 2,684 4,295 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) 19 7.8% Common shares outstanding 135.6 million Net nonoperating obligations (NNO) S(6,161) million NNO is negative because Humana's nonoperating assets exceed its nonoperating liabilities. (a) Estimate the value of a share of common stock using the residual operating income (ROPI) model as of December 31,…
Calculate the projected price/earnings ratio and market/book ratio. Explain whether these ratios indicate that investors will be expected to have a high or low opinion of the company. Computron's Balance Sheets (Millions of Dollars) 2019 2020 Assets Cash and equivalents $ 60 $ 50 Short-term investments 100 10 Accounts receivable 400 520 Inventories 620 820 Total current assets $ 1,180 $ 1,400 Gross fixed assets $ 3,900 $ 4,820 Less: Accumulated depreciation 1,000 1,320 Net fixed assets $ 2,900 $ 3,500 Total assets $ 4,080 $ 4,900 Liabilities and equity Accounts payable $ 300 $ 400 Notes payable 50 250 Accruals 200 240 Total current liabilities $ 550 $ 890 Long-term bonds 800 1,100 Total liabilities $ 1,350 $ 1,990 Common stock 1,000 1,000 Retained earnings 1,730 1,910 Total equity $ 2,730 $ 2,910 Total liabilities and equity $ 4,080 $ 4,900…
Here are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2022 Sales $ 5,000 Cost 3,900 Net income $ 1,100 BALANCE SHEET, YEAR-END 2021 2022 2021 2022 Assets $ 7,500 $ 12,100 Debt $ 833 $ 1,000 Equity 6,667 11,100 Total $ 7,500 $ 12,100 Total $ 7,500 $ 12,100 If sales increase by 10% in 2023 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 10%), what must be the balancing item? What will be the value of this balancing item?
The 2019 financial statements for Growth Industries are presented below. INCOME STATEMENT, 2019 Sales Costs EBIT Interest expense Taxable income Taxes (at 216) Net income Dividends Addition to retained earnings Current assets Cash Assets Accounts receivable Inventories Total current assets Net plant and equipment Total assets $22,120 $22,120 $ 240,000 170,000 $70,000 14,000 $ 56,000 11,760 G44,240 BALANCE SHEET, YEAR-END, 2019 7,000 12,000 21,000 $ 40,000 180,000 220,000 Liabilities Current liabilities Accounts payable Total current liabilities Long-term debt Stockholders' equity Common stock plus additional paid-in capital Retained earnings Total liabilities plus stockholders' equity 14,000 14,000 140,000 15,000 $1,000 $220,000
Requirement 1. Compute these ratios: Working Capital Current Debt-to- Ratio Cash Ratio Debt Ratio Equity Ratio Round ratios to two 14.44 212400 7.73 decimal places or format as percentages or Accounts Days Sales currency as appropriate. Inventory Days Sales in Gross ProfitReceivable in Turnover Inventory Percentage Turnover Receivables 2019 Total Assets = Rate of Rate of Asset Return on Return on Turnover Stockholders' Earnings Total Assets Ratio Equity Per Share 2019 SHE = Price/ Earnings *Current Stock Price is Dividend $10.00 per share Ratio* Dividend Yield Payout Dividend per share= Requirement 2. Based on the ratios computed above, analyze the company's ability to pay its debts (both current and long term). Refer to at least 3 specific ratios in your analysis. Requirement 3: Based on the ratios computed above, analyze the company's management of inventory. Refer to at least 2 specific ratios in your analysis. Requirement 4: Based on the ratios computed above, analyze the company's…
Estimating Share Value Using the DCF Model Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of February 2, 2019, which we label fiscal year 2018. 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. Reported Forecast Horizon Period Terminal $ millions 2018 Sales $75,956 NOPAT NOA 3,269 23,620 2019 2020 2021 2022 $79,124 $83,680 $87,234 $92,196 4,002 3,572 4,351 3,939 24,197 26,007 26,677 28,611 Period $93,428 4,617 28,571 Answer the following requirements with the following assumptions: Assumptions Terminal period growth rate Discount rate (WACC) Common shares outstanding 2% 7.63% 517.80 million Net nonoperating obligations (NNO) $12,323 million Estimate the value of a share of Target common stock using the discounted cash flow (DCF) model as of February 2, 2019. Increase in NOA ($ millions)…
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 S millions Sales NOPAT NOA Forecast Horizon Period Terminal Period 2021 Reported 2018 2019 2020 2022 $125,515 $134,301 $143,703 $153,761 $164,525 $167,816 14,005 15,042 16,095 17,221 18,427 29,633 31,705 33,924 36,299 38,840 18,795 39,616 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 $31,812 million. Required a Estimate the value of a share of Home Depot's common stock using the discounted cash flow (DCF) 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: s b. Home Depot stock closed at $220.47 on March 28, 2019, the date the Form 10-K was filed with the SEC. How does your…
Operating data for Cheyenne Corp. are presented below. 2022 2021 Sales revenue $831,900 $629,500 Cost of goods sold 529,700 410,900 Selling expenses 125,400 74,300 Administrative expenses 79,400 52,000 Income tax expense 37,000 24,500 Net income 60,400 67,800 Prepare a schedule showing a vertical analysis for 2022 and 2021. (Round percentages to 1 decimal place, e.g. 12.1%.)
Here is financi:l information for Glitter Inc. December 31, 2020 December 31, 2019 Current assets $123,000 $100,000 Plant assets (nat) 394,471 329,000 Current liabilities 87,472 71,000 Long-term liabilities 137,192 88,000 Common stock, $1 par 166,833 111,000 Retained earning 125,974 159,000 Prepare a schedule shoving a horizontal analysis for 2020, using 2019 as the base year. (Enter negative amounts and percentages using either a negative sign preceding the number eg. -45, -45% or parentheses eg. (45). (45%). Round percentages to 1 decimal place, eg 12.3%)

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