Question

In: Finance

We have gathered the following information on Cheesecake Factory Current Dividend (Source – Yahoo!Finance) = $1.28...

We have gathered the following information on Cheesecake Factory

  • Current Dividend (Source – Yahoo!Finance) = $1.28
  • Required Return (Estimated) = 8.9%
  • Current EPS (Source – Yahoo!Finance) = $2.14
  • Current Book Value Per Share (Source – Yahoo!Finance) = $13.24
  • Current EBITDA per share (Source – Yahoo!Finance) = $5.25
  • Current Debt per share = $2.80                Current Cash and Equivalents per share = $0.61
  • Initial Growth Rate for H-Model (Estimated) = 9%
  • Terminal Growth Rate for H-Model (Estimated) = 3%
  • Time to Reach Terminal Growth Rate for H-Model (Estimated) = 10 years
  • Forecasted Growth Rates (Estimated)
    • Year 1 = 6%
    • Year 2 = 9%
    • Year 3 = 12%
    • Year 4 = 6%
    • Year 5 = 4%
    • Years 6 through infinity = 3%
  • Historical PE, PB and EV/EBITDA (Source – Morningstar and Gurufocus.com)
    • 5-Year Average = 19.8        4.1          9.3         
  • Comparative PE, PB, and EV/EBITDA for S&P 500 (Source – Morningstar and estimate)
    • 19.2 (5-year avg = 19.6)                 3.7 (5-year avg = 2.9)      13.0 (5-year average 12.3)
  1. Calculate the price for Cheesecake Factory using the
    1. H-Model
    2. Non-Constant Dividend Valuation Approach
    3. Relative valuation     
      1. Historical PE, PB, and EV/EBITDA
      2. Comparative PE, PB, and EV/EBITDA (Adjust S&P 500 to reflect Cheesecake Factory’s average discount or premium to the market over the past 5 years. Example, if the S&P 500 had an average PE over the past 5 years of 17.0 and your company had an average PE of 14, then your company has historically traded at 82.35% of the market average PE. Therefore, if the current S&P 500 PE is 17.7, your company should have a PE of 14.58 based on the comparative relative valuation to PE. Take the 14.58 times your firm’s EPS to get fair value using this method.)

Solutions

Expert Solution

1. H Model Price

2. Non-Constant Dividend Valuation Approach

First we will calculate the dividend for that year until 6th year and then terminal value. Once we find these value, we will discount then to present value and add them to get the final ans.

3. Relative valuation

3.1 Historical PE, PB, and EV/EBITDA

3.2

Comparative PE, PB, and EV/EBITDA


Related Solutions

Select one of the following companies, and use yahoo finance (or an alternate similar source) to...
Select one of the following companies, and use yahoo finance (or an alternate similar source) to locate and review the balance sheet, income statement and statement of cash flows from the past fiscal reporting year. This assignment should be prepared professionally and formatted well, and include proper citations for sources used. FOUR CHOICES ONLY I tried to select some good ones: • Adidas (manufacturing – sports mgmt) • Urban Outfitters (merchandising) • Sony Music Entertainment (for our music industry group)...
1. Go to Yahoo! Finance or another source and pick a stock to track for the...
1. Go to Yahoo! Finance or another source and pick a stock to track for the last year. Discuss the performance of the stock over the last year and offer your thoughts being specific about why the stock has done well or not. 2. What are some reasons that a company might choose common stock as means of financing their business rather than using debt? Also comment on why a company might choose debt over common stock.
1. Go to Yahoo! Finance or another source and pick a stock to track for the...
1. Go to Yahoo! Finance or another source and pick a stock to track for the last year. Discuss the performance of the stock over the last year(2018) and offer your thoughts being specific about why the stock has done well or not. 2. What are some reasons that a company might choose common stock as means of financing their business rather than using debt? Also comment on why a company might choose debt over common stock.
Here is the following information on the Cheesecake Factory, I am trying to answer question 1...
Here is the following information on the Cheesecake Factory, I am trying to answer question 1 below. Can you please help me out? Excel assignment. Current Dividend (Source – Yahoo!Finance) $1.28 Required Return (Estimated) 8.9% Current EPS (Source – Yahoo!Finance) $2.14 Current Book Value Per Share (Source – Yahoo!Finance) $13.24 Current EBITDA per share (Source – Yahoo!Finance) $5.25 Current Debt per share è $2.80 Current Cash and Equivalents per share $0.61 Initial Growth Rate for H-Model (Estimated) 9% Terminal Growth...
"Researching Financial Information" Please respond to the following: Go to the Finance website of Yahoo. Next,...
"Researching Financial Information" Please respond to the following: Go to the Finance website of Yahoo. Next, select one (1) company and find the Recommendation Rating by Analysts for this company. You will then examine the most recent annual report for the same company located at the Securities and Exchange Commission website, for information disclosed that supports the analysts' recommendations. Within your response be sure to discuss the possible roles for at least two (2) of these disclosures.
Moresan Co. gathered the following information on power costs and factory machine usage for the last...
Moresan Co. gathered the following information on power costs and factory machine usage for the last six months: Month Power Cost Factory Machine Hours January $24,400 13,900 February 30,400 17,600 March 29,000 16,800 April 22,340 13,200 May 19,900 11,600 June 16,900 8,600 Using the high-low method of analyzing costs, answer the following questions. What is the estimated variable portion of power costs per factory machine hour? (Round answer to 2 decimal places, e.g. 15.25.) Variable power costs $ per factory...
Fernicus Company gathered the following information on power costs and factory machine usage for the last...
Fernicus Company gathered the following information on power costs and factory machine usage for the last five months. Month Power Cost Factory Machine Hours January P48,000 19,000 February 35,000 15,500 March 50,000 18,500 April 41,000 17,000 May 40,000 15,000 Instructions: Use the high-low method of analyzing costs to answer the following questions. 1. How much is the estimated variable portion of power costs per factory machine hour? 2. How much is the estimated fixed power cost each month? 3. If...
a. Search Yahoo Finance or any other credible source to retrieve the most recent income statement...
a. Search Yahoo Finance or any other credible source to retrieve the most recent income statement and balance sheet for a major leveraged corporation. Provide these statements in proper format. Also, retrieve the data on the company's stock annual rate of return for the past 20 years. In addition, retrieve annual rate of return of a major financial index. Present this data as well. Using the data on company's stock rate of return and the index's rate of return estimate...
• Given the information below, answer questions from #9 to #10. The owner of Cheesecake Factory...
• Given the information below, answer questions from #9 to #10. The owner of Cheesecake Factory at the Forum Shop is renegotiating the operation’s lease and has the option of either (1) an annual fixed lease of $55,000 or (2) an annual fixed lease of $10,000 plus a variable lease set at 5% of annual revenue. What is the indifference point? A. $900,000 B. $1,100,000 C. $1,000,000 D. $1,300,000 Which option will cost less for the owner if annual revenue...
We have the following information for the Valverde company. The stock pays a $10  dividend, and it...
We have the following information for the Valverde company. The stock pays a $10  dividend, and it will grow by 100% the first year, 30% the second year and 3% forever   after that. You know the ROR in the S&P 500 is 11%, the Bheta is 1.2 and the Treasury bond rate is 4%. Derive the value of Valverde.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT