It's your first day as an analyst and you have been asked to prepare a valuation...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It's your first day as an analyst and you have been asked to prepare a valuation for an energy drink company that is set to go public on January 1. You are asked to prepare a financial model, which will provide both an expected enterprise and equity value of the business. The company would like to raise $100MM in equity. The company has also provided the following information: Company Forecast Units (MM) $/Unit Variable Costs/Unit Fixed Costs ($MM) Valuation 26000 Year 1 0 15 0 100 Year 1 25% Year 2 20% Year 2 20 15 3 200 Year 3 15% The company has $50MM of long-term debt on its balance sheet (6% interest rate). Funds will be used to construct a $150MM factory (Year 1). Assume ongoing CAPEX to be 5% of sales (Year 2-Year 5). Page 1 Year 3 25 15 3 200 Year 4 12% Assume the factory has a useful life of 25 years with no residual value. Depreciation can be accelerated using the following simplified MACRS schedule: Year 4 Year 5 10% 35 15 3 300 Assume the CAPEX depreciates using the same rate methodology as the factory. The company has an effective tax rate of 35%. Year 5 45 15 3 300 7/31/13 You have already done some research and found the risk-free rate of return is 3% and the market has returned 10% over the past 10 years. Comps suggest energy drink businesses are trading at approximately 5,5x EBITDA, Assume a 3% perpetuity growth rate. It's your first day as an analyst and you have been asked to prepare a valuation for an energy drink company that is set to go public on January 1. You are asked to prepare a financial model, which will provide both an expected enterprise and equity value of the business. The company would like to raise $100MM in equity. The company has also provided the following information: Company Forecast Units (MM) $/Unit Variable Costs/Unit Fixed Costs ($MM) Valuation 26000 Year 1 0 15 0 100 Year 1 25% Year 2 20% Year 2 20 15 3 200 Year 3 15% The company has $50MM of long-term debt on its balance sheet (6% interest rate). Funds will be used to construct a $150MM factory (Year 1). Assume ongoing CAPEX to be 5% of sales (Year 2-Year 5). Page 1 Year 3 25 15 3 200 Year 4 12% Assume the factory has a useful life of 25 years with no residual value. Depreciation can be accelerated using the following simplified MACRS schedule: Year 4 Year 5 10% 35 15 3 300 Assume the CAPEX depreciates using the same rate methodology as the factory. The company has an effective tax rate of 35%. Year 5 45 15 3 300 7/31/13 You have already done some research and found the risk-free rate of return is 3% and the market has returned 10% over the past 10 years. Comps suggest energy drink businesses are trading at approximately 5,5x EBITDA, Assume a 3% perpetuity growth rate.
Expert Answer:
Related Book For
Accounting Texts and Cases
ISBN: 978-1259097126
13th edition
Authors: Robert Anthony, David Hawkins, Kenneth Merchant
Posted Date:
Students also viewed these general management questions
-
Assume that you have been asked to prepare a computer hardware budget. Your company has identified three classes of computer user. Class A employees use the computer for email, Web browsing, Internet...
-
You have been asked to prepare a report showing monthly sales by geographic region. Most of the managers using the report are not accountants, so your supervisor thought they would be more likely to...
-
You have been asked to prepare a brief statement about labor force participation rate for males and females (percentage of population age 15-64). Using statistics from the following table obtained...
-
Inverse permutation. Write a program that reads in a permutation of the integers 0 to n-1 from n command-line arguments and prints the inverse permutation. (If the permutation is in an array a[], its...
-
Explain purchasing power parity, both the absolute and relative versions. What causes deviations from purchasing power parity?
-
Write a Lewis formula for each of the following, assuming that the octet rule holds for the atoms. Then obtain the formal charges of the atoms. a. ClNO b. POCl3 c. N2O (NNO)
-
What huge bankruptcy in 2001-2002 caused forensic accountants to become rising stars within the accounting profession?
-
Xinhong Company is considering replacing one of its manufacturing machines. The machine has a book value of $ 45,000 and a remaining useful life of 5 years, at which time its salvage value will be...
-
Can you answer with details explanations?. CLASS EXERCISE The management of The Grissom Company has decided to acquire the use of production equipment that is manufactured only by Carter-Smith,...
-
Clampett Oil purchases crude oil products from suppliers in Texas (TX), Oklahoma (OK), Pennsylvania (PA), and Alabama (AL), from which it refines four end-products: gasoline, kerosene, heating oil,...
-
Motivation is the force that initiates, guides and maintains goal-oriented behaviors. It is what causes us to take action, whether to grab a snack to reduce hunger or enroll in college to earn a...
-
Day, a small manufacturing company, has appointed you to make an audit and issue an opinion for the 19X9 calendar year. In January 19X9, the nine shareholders (all individuals) elected to be taxed as...
-
What is the primary advantage of a Schottky TTL NAND gate compared to a regular TTL NAND gate.
-
Explain the operation of a Schottky clamped transistor. What are its advantages?
-
Explain how maximum fanout can be based on a maximum rated collector current in the output transistor when the output is low.
-
Explain how maximum fanout can be based on maintaining the output transistor in saturation when the output is low.
-
O Question 2 1 pts The differences in language input and SES have been studied a lot concerning parenting practice as well as societal policy. What do these findings (i.e., that reduced language...
-
Dan and Diana file a joint return. Dan earned $31,000 during the year before losing his job. Diana received Social Security benefits of $5,000. a. Determine the taxable portion of the Social Security...
-
Watson Company pays a bonus to any of its five division managers who increase their percentage of income to sales over that of the year before. The manager of Division A is displeased because of the...
-
Delta Division of Gotham Industries, Inc., makes two products, A and B. Both products use the same raw material and are produced in the same factory by the same workforce. In preparing its annual...
-
Dover Rubber Company had been offered a contract to supply 500,000 premium automobile tires to a large automobile manufacturer at a price of $41.65 per tire. Dover's full cost of producing the tire...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Perform a horizontal analysis of the balance sheets and income statements...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Perform a vertical analysis of the balance sheets and income statements for...
-
The following information for Great Oaks Furniture, a retail furniture and design firm, relates to Exercises 6 through 11. Calculate earnings per share, the price-eam- m'ssm jngS ratio, the gross...
Study smarter with the SolutionInn App