Question

Question text Estimating Share Value Using the DCF Model Following are the income statement and balance...

Question text Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar.

Reported Forecast Horizon Terminal
$ thousands 2015 2016 2017 2018 2019 Period
Sales $1,807,368 $2,060,400 $2,348,855 $2,513,275 $2,689,205 Answer
NOPAT 102,495 168,953 192,606 206,089 220,515 Answer
NOA 662,502 755,279 861,017 921,288 985,779 Answer

b. Estimate the value of a share of TXRH common stock using the discounted cash flow (DCF) model as of December 29, 2015; assume a discount rate (WACC) of 7%, common shares outstanding of 70,091 thousand, net nonoperating obligations (NNO) of $(14,680) thousand, and noncontrolling interest (NCI) from the balance sheet of $7,520 thousand. Note that NNO is negative because the company’s cash exceeds its nonoperating liabilities.

Rounding instructions:

  • Use rounded answers for subsequent computations.

  • Round answers to the nearest whole number unless otherwise noted.
  • Round discount factor to 5 decimal places and stock price per share to two decimal places.
  • Do not use negative signs with any of your answers below.

    TXRH Reported Forecast Horizon Terminal
    $ thousands 2015 2016 2017 2018 2019 Period
    Increase in NOA Answer Answer Answer Answer Answer
    FCFF (NOPAT - Increase in NOA) Answer Answer Answer Answer Answer
    Discount factor [1 / (1 + rw)t ] Answer Answer Answer Answer
    Present value of horizon FCFF Answer Answer Answer Answer
    C u m PV of horizon FCFF Answer
    Present value of terminal FCFF Answer
    Total firm value Answer
    NNO Answer
    NCI Answer
    Firm equity value Answer
    Shares outstanding (thousands) Answer
    Stock price per share Answer

Homework Answers

Answer #1
Reported Forecast Horizon
$ thousands 2015 2016 2017 2018 2019 Terminal Period
Sales $1,807,368 $2,060,400 $2,348,855 $2,513,275 $2,689,205 $2,716,097.05
NOPAT 102,495 168,953 192,606 206,089 220,515 $222,720.15
NOA 662,502 755,279 861,017 921,288 985,779 $995,636.79
TXRH Reported Forecast Horizon Terminal
$ thousands 2015 2016 2017 2018 2019 Period
Increase in NOA $     92,777.00 $ 105,738.00 $   60,271.00 $      64,491.00 $       9,857.79
FCFF (NOPAT - Increase in NOA) $     76,176.00 $   86,868.00 $ 145,818.00 $    156,024.00 $   212,862.36
Discount factor [1 / (1 + 7%)^t ] 0.93458 0.87344 0.81630 0.76290
Present value of horizon FCFF $     71,192.52 $   75,873.88 $ 119,030.92 $    119,029.96
PV of horizon FCFF $                   385,127.29
Present value of terminal FCFF $                2,706,527.92
Total firm value $                3,091,655.21
NNO $                     14,680.00
NCI $                       7,520.00
Firm equity value $                3,098,815.21
Shares outstanding (thousands)                         70,091.00
Stock price per share $                            44.21


Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for...
Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Texas Roadhouse for the year ended December 29, 2015. a. Assume the following forecasts for TXRH’s sales, NOPAT, and NOA for 2016 through 2019. Forecast the terminal period values assuming a 1% terminal period growth rate for all three model inputs: Sales, NOPAT, and NOA. Round your answers to the nearest dollar. Reported Forecast Horizon Terminal $ thousands 2015 2016 2017 2018 2019 Period...
Estimating Share Value Using the DCF Model Following are forecasts of Abercrombie & Fitch's sales, net...
Estimating Share Value Using the DCF Model Following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. (Current-year NOPAT is lower due to transitory items; we use a longer term estimate for NOPM of 8%.) Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Intel Corporation. INTEL CORPORATION Consolidated Statements of Income Year Ended (In millions) Dec. 25, 2010 Dec. 26, 2009 Dec. 27, 2008 Net revenue $ 43,623 $ 35,127 $ 37,586 Cost of sales 15,132 15,566 16,742 Gross margin 28,491 19,561 20,844 Research and development 6,576 5,653 5,722 Marketing, general and administrative 6,309 7,931 5,452 Restructuring and asset impairment charges -- 231 710 Amortization...
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating...
Following are forecasts of Target Corporation's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 30, 2016 Reported Horizon Period Terminal $ millions 2016 2017 2018 2019 2020 Period Sales $74,340 $75,827 $77,344 $78,891 $80,469 $81,274 NOPAT 3,345 3,412 3,480 3,550 3,621 3,657 NOA 22,302 22,748 23,203 23,667 24,141 24,382 Answer the following requirements assuming a terminal period growth rate of 1%, a discount rate (WACC) of 6%, common shares outstanding of 602 million,...
Estimating Share Value Using the ROPI Model The following are forecasts of Abercrombie & Fitch's sales,...
Estimating Share Value Using the ROPI Model The following are forecasts of Abercrombie & Fitch's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) as of January 29, 2011. Refer to the information in the table to answer the following requirements. Reported Horizon Period (In millions) 2011 2012 2013 2014 2015 Terminal Period Sales $ 3,469 $ 3,989 $ 4,587 $ 5,275 $ 6,066 $ 6,187 NOPAT 152 319 367 422 485 495 NOA 1,032 1,173 1,349...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses Research and development 6,296 6,207 Sales and marketing 9,619 9,821 General and administrative...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July...
Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco Sytems Consolidated Statements of Income Years Ended December ($ millions) July 30, 2016 July 25, 2015 Revenue Product $37,254 $37,750 Service 11,993 11,411 Total revenue 49,247 49,161 Cost of sales Product 14,161 15,377 Service 4,126 4,103 Total cost of sales 18,287 19,480 Gross margin 30,960 29,681 Operating expenses Research and development 6,296 6,207 Sales and marketing 9,619 9,821 General and administrative...
Computing Free Cash Flows to the Firm (FCFF) Use the following data to compute free cash...
Computing Free Cash Flows to the Firm (FCFF) Use the following data to compute free cash flows to the firm for Intel Corporation for 2016 through the terminal period. Reported Horizon Period Terminal $ millions 2015 2016 2017 2018 2019 Period Sales $ 55,355 $ 61,444 $ 67,588 $ 73,660 $ 78,851 $ 80,400 NOPAT 11,621 13,851 14,526 15,802 16,103 15,609 NOA 51,488 57,157 62,873 68,521 72,674 74,101 2016 2017 2018 2019 Terminal Period Free cash flows to the firm...
Computing Free Cash Flows to the Firm (FCFF) Use the following data to compute free cash...
Computing Free Cash Flows to the Firm (FCFF) Use the following data to compute free cash flows to the firm for Intel Corporation for 2016 through the terminal period. Reported Horizon Period Terminal $ millions 2015 2016 2017 2018 2019 Period Sales $ 55,355 $ 61,444 $ 67,588 $ 73,660 $ 78,851 $ 80,400 NOPAT 11,510 13,740 14,415 15,691 15,992 15,498 NOA 51,488 57,157 62,873 68,521 72,674 74,101 2016 2017 2018 2019 Terminal Period Free cash flows to the firm
Assume the following expected free cash flows for Peterson Corporation for 2017: Current Forecast Horizon Terminal...
Assume the following expected free cash flows for Peterson Corporation for 2017: Current Forecast Horizon Terminal Year 2017 2018 2019 2020 2021 Free cash flows to the firm (FCFF) $4,651 $4,884 $5,128 $5,384 $5,653 $5,766 The company has net nonoperating obligations (NNO) of $12,000 and 3,000 shares outstanding. Calculate the per share stock price using the FCFF information above, a discount rate of 7%, and a terminal growth rate of 2%.