How did you determine the current ebit value

Assignment Help Corporate Finance

Reference no: EM131160471

INSTRUCTIONS:

1. You may complete this assignment in a group of 2 or choose to complete it on your own. Grades are not impacted regardless of whether you complete the project alone or in pairs.

2. Complete the model.
a. All values highlighted in Yellow can/should be adjusted (do not assume any value currently in Yellow is correct. They Are Not!)

3. Answer the Project Questions

4. Submit both the Excel Model AND Questions on Blackboard

5. You may submit ONE copy of all materials for the team

6. Please complete the project as if you are examining the company on July 8, 2015, the time at which the IPO was filed.

PLEASE ANSWER THE FOLLOWING BASED ON YOUR DCF ANALYSIS

1. How did you determine the "Current EBIT" value used?

2. In setting the company's "Marginal Tax Rate", what factors did you consider?

3. How did you determine the "Current Cost of Borrowing"?

4. How did you determine the "Stable Growth Inputs"? If you used a comparable(s), explain why it is a good parallel for SULLY'S.

5. What did you use as the "Long-Term Government Bond Rate"? Why did you choose this rate?

6. Please provide a brief explanation supporting the rates you used for the "Expected Growth Rates" in years 1 through 10. Include why you chose to have the growth rate increase, decrease or remain stable over the 10 year period.

7. If SULLY'S announces they have set the IPO price at $20 per share, given your valuation model, do you believe this is a good trade? Why or Why not?

PLEASE ANSWER THE FOLLOWING BASED ON YOUR MULTIPLES ANALYSIS

8. Which multiple do you believe provides the best estimate of SULLY'S value? Why do you believe this multiple provides a more accurate assessment of SULLY'S value than the other multiples?

9. Assume the PEG ratio, out of the five multiples, provides the highest share price. Where can you derive much of SULLY'S value stems from compared to other companies? (Hint: compare the inputs for P/E, PEG and P/Sales, which of SULLY'S input is higher than average)

10. Which valuation method, Discount Cash Flows or Multiples, do you believe provides a more accurate value of SULLY'S? Why?

For questions 10 through 12, assume the model indicates SULLY'S stock is worth $28 (do not assume this is the price you should try to get in your model). Additionally, assume SULLY'S has smart finance students who have also determined the price of the stock should be $28.

11. Why might the company issue shares for $20 at the IPO? Consider quantitative and qualitative rationales.

12. What would you expect SULLY's stock price to do when it commences trading on the first day after its IPO?

13a.If after the first day of public trading SULLY'S stock is selling at $26 per share, what would you advise shareholders to do?

13b.Would your advice change if the stock was trading at $30 after the first day? If so, what would your advice be?

14. Why might someone use the valuation method you identified as less accurate in question 13?

Sully's includes the following statements on all their dog food packages:

All SULLY'S dog and cat foods start with real chicken, lamb or fish and contain plenty of whole grains, fresh-cut vegetables and fruit. SULLY'S will provide your companion with the wholesome nutrition veterinarians and breeders recommend.

Lastly, and of equal importance, SULLY'S dog and cat foods contain no chicken or poultry by-product meals, and no artificial preservatives, colors or flavors. And SULLY'S dog and cat foods contain no corn, wheat or soy, which have all been known to trigger allergies in some pets.

A news article, released two weeks before the scheduled IPO date, included the following statements

Nestle Purina has sued SULLY'S. The lawsuit contends that SULLY'S has engaged in false advertising. Nestle contends that testing has revealed the presence of poultry by-products in some of SULLY'S best-selling pet foods.

In SULLY'S answer, filed with the court, SULLY'S admits there is by-product meal in a "substantial" and "material" portion of their pet food. However, SULLY'S contends that prior the claims, and a resulting internal investigation, they were unaware the by-product was being used by an affiliate.

15. What impact do you believe these statements might have on the company?

16. Propose how you might be able to include the anticipated impacts in the DCF Valuation?

Attachment:- ipo-project-valuation-models.xls

Reference no: EM131160471

Questions Cloud

How to derive engel curve utilizing consumer choice theory : Suppose you only consume X(axis) and lemons (Y axis) If coconuts are normal good.Graphically illustrate how to derive an Engel curve utilizing consumer choice theory.

Why not just completely halt all research and development : Second, MM will providebenefitsthat are simply too good to pass up, including environmental repair; clean, cheap, and efficient manufacturing; medical breakthroughs; immensely powerful computers; and easier access to space.

What was initial intent of affirmative-action legislation : What was the initial intent of Affirmative-Action legislation? What did the landmark Bakke v. Regents case conclude? What was the basis for the conclusion?

Find the time required for an investment : Find the time required for an investment of 5000 dollars to grow to 8300 dollars at an interest rate of 7.5 percent per year, compounded quarterly.

How did you determine the current ebit value : How did you determine the "Current EBIT" value used - In setting the company's "Marginal Tax Rate", what factors did you consider?

Different wrappers for the cupcakes : Jack is making cupcakes for his party. He has 4 different types of frosting. He is baking 5 different kinds of cake for the cupcakes. He has 7 different wrappers for the cupcakes.

Why do some scientists dismiss mm as science fiction : It should be noted that none of those who dismiss MM are experts in the field. They may work in chemistry, biotechnology, or other nanoscale sciences or technologies, but are not sufficiently familiar with MM theory to critique it meaningfully.

What is the bank instability problem : What is the bank instability problem. Understand the Bryant and Diamond models of bank runs. I want you to understand the quantitative logic of the problem. Memorizing formulas is not the point here. Be able to understand how my decision about whethe..

Different ways can jack arrange people : For the party, the guests decide they want to see a movie at Jacks house. He has a couch that only seats 3 people at once. If there are 8 people watching the movie, how many different ways can Jack arrange people on the couch? Show work.

User Account

All Pages