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...
-
You are the head of the project selection team at Broken Arrow records. Your team is considering three different recording projects. Based on past history, Broken Arrow expects at least a rate of...
-
You work for a nanotechnology company developing a new quantum device that operates essentially as a one-dimensional infinite square well of width 2.5 nm. Youre asked to specify the maximum number of...
-
Research a past California case in which you believe a removal would have changed the outcome of the case. Using your knowledge of the potential advantages of transferring a case already filed in the...
-
Ashley runs a small business in Boulder, Colorado, that makes snow skis. She expects the business to grow substantially over the next three years. Because she is concerned about product liability and...
-
Sebastian operates a small business with his wife Ariel. They have no other employees. They have $240,000 of assets in the plan. Must they file any forms with the IRS? If yes, which? What if they had...
-
1. Prepare a payroll register for Mary's Luxury Travel for the week ended March 22, 20--. (In the Taxable Earnings/Unemployment Compensation column, enter the same amounts as in the Social Security...
-
Find the area under the curve y = 0.5-1.5 from z=5 to = t and evaluate it for t= 10, t= 100. Then find the total area under this curve for I> 5. (a) t = 10 (b) t = 100 (c) Total area
-
A used conveyor dealer presents an investment package that requires you to pay $\$ 189.99$ a month with $\$ 1,499.00$ down and a nominal annual interest rate of $17 \%$. What is the actual cost of...
-
Home Realty, Incorporated, has been operating for three years and is owned by three investors. J. Doe owns 60 percent of the total outstanding stock of 9,000 shares and is the managing executive in...
-
A new graduate hired by the marketing research department of AT\&T is asked to prepare a questionnaire to determine household preferences for cell phone plans. The questionnaire is to be administered...
-
Compute the value of an option with strike \(\$ 100\) expiring in four months on underlying asset with present value by \(\$ 97\), using the binomial model. The risk-free interest rate is \(7 \%\)...
-
An observatory has a telescope that requires an initial investment of $\$ 25,000$. A benefactor will provide a $\$ 7,500$ gift every 5 years as long as the university makes the telescope available to...
-
What are three best practices that companies should adopt to stay current with operating system updates? Use examples of at least two different types of businesses to illustrate the impact of these...
-
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 armature of a variable-speed electric motor, of mass \(200 \mathrm{~kg}\), has an unbalance due to manufacturing errors. The motor is mounted on an isolator having a stiffness of \(10 \mathrm{kN}...
-
It is found that an exhaust fan, of mass \(80 \mathrm{~kg}\) and operating speed \(1000 \mathrm{rpm}\), produces a repeating force of \(10,000 \mathrm{~N}\) on its rigid base. If the maximum force...
-
A dishwashing machine weighing \(75 \mathrm{~kg}\) operates at \(300 \mathrm{rpm}\). Find the minimum static deflection of an isolator that provides 60 percent isolation. Assume that the damping in...
Study smarter with the SolutionInn App