Estimating Share Value Using the DCF ModelFollowing are the income statement and balance sheet...

50.1K

Verified Solution

Question

Accounting

Estimating Share Value Using the DCF Model

Following are the income statement and balance sheet for TexasRoadhouse for the year ended December 29, 2015.

a. Assume the following forecasts for TXRH’s sales, NOPAT, andNOA for 2016 through 2019. Forecast the terminal period valuesassuming a 1% terminal period growth rate for all three modelinputs: Sales, NOPAT, and NOA.

Round your answers to the nearest dollar.

ReportedForecast HorizonTerminal
$ thousands20152016201720182019Period
Sales$1,807,368$2,069,436$2,369,504$2,547,217$2,738,258$Answer
NOPAT102,495169,694194,299208,872224,537$Answer
NOA662,502758,591868,587933,7311,003,760$Answer

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

Rounding instructions:

Use rounded answers for subsequent computations.

Round answers to the nearest whole number unless otherwisenoted.

Round discount factor to 5 decimal places and stock price pershare to two decimal places.

Do not use negative signs with any of your answers below.

TXRHReportedForecast HorizonTerminal
$ thousands20152016201720182019Period
Increase in NOA$Answer$Answer$Answer$Answer$Answer
FCFF (NOPAT - Increase in NOA)AnswerAnswerAnswerAnswerAnswer
Discount factor [1 / (1 + rw)t ]AnswerAnswerAnswerAnswer
Present value of horizon FCFFAnswerAnswerAnswerAnswer
Cumulative PV of horizon FCFF$Answer
Present value of terminal FCFFAnswer
Total firm valueAnswer
NNOAnswer
NCIAnswer
Firm equity value$Answer
Shares outstanding (thousands)Answer
Stock price per share$Answer

c. TXRH closed at $42.13 on February 26, 2016, the date the Form10-K was filed with the SEC. How does your valuation estimatecompare with this closing price?

Stock prices are a function of many factors. It is impossible tospeculate on the reasons for the difference.

Our stock price estimate is higher than the TXRH market price,indicating that we believe that the stock is slightly undervalued.Stock prices are a function of expected NOPAT and NOA, as well asthe WACC discount rate. Our higher stock price estimate might bedue to more optimistic forecasts or a lower discount rate comparedto other investors' and analysts' model assumptions.

Our stock price estimate is higher than the TXRH market price,indicating that we believe that the stock is slightly undervalued.Stock prices are a function of expected NOPAT and NOA, as well asthe WACC discount rate. Our higher stock price estimate might bedue to more pessimistic forecasts or a higher discount ratecompared to other investors' and analysts' model assumptions.

Our stock price estimate is slightly higher than the WMT marketprice, indicating that we believe that WMT stock is slightlyovervalued. Stock prices are a function of expected NOPAT and NOA,as well as the WACC discount rate. Our higher stock price estimatemight be due to more pessimistic forecasts or a higher discountrate compared to other investors' and analysts' modelassumptions.

d. If WACC had been 7.5%, what would the valuation estimate havebeen? What about if WACC has been 6.5%?

The valuation estimate at 7.5% would be lower than the estimatecalculated in part a because the discount rate increased. Incontrast, the valuation estimate at 6.5% would be higher than ourestimate.

The valuation estimate at 7.5% would be higher than the estimatecalculated in part a because the discount rate increased. Incontrast, the valuation estimate at 6.5% would be lower than ourestimate.

The valuation estimate would be the same regardless of the rateused to compute the estimate.

Answer & Explanation Solved by verified expert
4.3 Ratings (898 Votes)
a Reported Forecast Horizon 000s 2015 2016 2017 2018 2019 Terminal Period Sales 1807368 2069436 2369504 2547217 2738258 2738258101007001 46094010 NOPAT 102495 169694 194299 208872 224537 224537101007001 3779706 NOA 662502 758591 868587 933731 1003760 1003760101007001 16896627 TXRH WACC7 Reported Forecast Horizon thousands 2015 2016 2017 2018 2019 Increase in NOA 96089 109996 65144 70029 FCFF NOPAT Increase in NOA 73605 84303 143728 154508 Discount factor 1 1 007t    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

In: AccountingEstimating Share Value Using the DCF ModelFollowing are the income statement and balance sheet for...Estimating Share Value Using the DCF ModelFollowing are the income statement and balance sheet for TexasRoadhouse for the year ended December 29, 2015.a. Assume the following forecasts for TXRH’s sales, NOPAT, andNOA for 2016 through 2019. Forecast the terminal period valuesassuming a 1% terminal period growth rate for all three modelinputs: Sales, NOPAT, and NOA.Round your answers to the nearest dollar.ReportedForecast HorizonTerminal$ thousands20152016201720182019PeriodSales$1,807,368$2,069,436$2,369,504$2,547,217$2,738,258$AnswerNOPAT102,495169,694194,299208,872224,537$AnswerNOA662,502758,591868,587933,7311,003,760$Answerb. Estimate the value of a share of TXRH common stock using thediscounted cash flow (DCF) model as of December 29, 2015; assume adiscount rate (WACC) of 7%, common shares outstanding of 70,091thousand, net nonoperating obligations (NNO) of $(14,680) thousand,and noncontrolling interest (NCI) from the balance sheet of $7,520thousand. Note that NNO is negative because the company’s cashexceeds its nonoperating liabilities.Rounding instructions:Use rounded answers for subsequent computations.Round answers to the nearest whole number unless otherwisenoted.Round discount factor to 5 decimal places and stock price pershare to two decimal places.Do not use negative signs with any of your answers below.TXRHReportedForecast HorizonTerminal$ thousands20152016201720182019PeriodIncrease in NOA$Answer$Answer$Answer$Answer$AnswerFCFF (NOPAT - Increase in NOA)AnswerAnswerAnswerAnswerAnswerDiscount factor [1 / (1 + rw)t ]AnswerAnswerAnswerAnswerPresent value of horizon FCFFAnswerAnswerAnswerAnswerCumulative PV of horizon FCFF$AnswerPresent value of terminal FCFFAnswerTotal firm valueAnswerNNOAnswerNCIAnswerFirm equity value$AnswerShares outstanding (thousands)AnswerStock price per share$Answerc. TXRH closed at $42.13 on February 26, 2016, the date the Form10-K was filed with the SEC. How does your valuation estimatecompare with this closing price?Stock prices are a function of many factors. It is impossible tospeculate on the reasons for the difference.Our stock price estimate is higher than the TXRH market price,indicating that we believe that the stock is slightly undervalued.Stock prices are a function of expected NOPAT and NOA, as well asthe WACC discount rate. Our higher stock price estimate might bedue to more optimistic forecasts or a lower discount rate comparedto other investors' and analysts' model assumptions.Our stock price estimate is higher than the TXRH market price,indicating that we believe that the stock is slightly undervalued.Stock prices are a function of expected NOPAT and NOA, as well asthe WACC discount rate. Our higher stock price estimate might bedue to more pessimistic forecasts or a higher discount ratecompared to other investors' and analysts' model assumptions.Our stock price estimate is slightly higher than the WMT marketprice, indicating that we believe that WMT stock is slightlyovervalued. Stock prices are a function of expected NOPAT and NOA,as well as the WACC discount rate. Our higher stock price estimatemight be due to more pessimistic forecasts or a higher discountrate compared to other investors' and analysts' modelassumptions.d. If WACC had been 7.5%, what would the valuation estimate havebeen? What about if WACC has been 6.5%?The valuation estimate at 7.5% would be lower than the estimatecalculated in part a because the discount rate increased. Incontrast, the valuation estimate at 6.5% would be higher than ourestimate.The valuation estimate at 7.5% would be higher than the estimatecalculated in part a because the discount rate increased. Incontrast, the valuation estimate at 6.5% would be lower than ourestimate.The valuation estimate would be the same regardless of the rateused to compute the estimate.

Other questions asked by students