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...
-
In a particular month Northwest Medical Clinic reported the following: 1. It provided direct care services to patients, billing them $400,000. Of this amount it received $120,000 in cash, but as a...
-
A 44-kg chandelier is suspended 1.5 m below a ceiling by three wires, each of which has the same tension and the same length of 2.0 m (see the drawing). Find the tension in eachwire. 1.5 m 2.0 m
-
If a well-behaved investment alternative's internal rate of return (IRR) is equal to MARR, which of the following statements about the other measures of worth for this alternative must be true? 1....
-
Kohler Corporation reports the following components of stockholders equity on December 31, 2013: Common stock $ 10 par value, 100,000 shares authorized, 40,000 shares issued and outstanding . . . . ....
-
8. The electronic health record shows an order for 120 mL of 25 % formula to be administered in the nasogastric feeding tube every 2 hours between 0700 and 1900 each day. The 30 mL can of...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
A check written by the company for $ 272 is incorrectly recorded by a company as $ 227 . On the bank reconciliation, the $ 45 error should be deducted from the balance per books. added to the balance...
-
For this you will be writing a program that provides information about tennis players. I have provided a file called womenSinglesDraw.txt that contains a list of players who qualified for the women's...
-
Create a very simple temperature converter form having two text fields. The first one is where the user will enter the temperature. The second field is where the computed temperature value is...
-
Identify the correct sentence. A. Gary's share of the rent is 1 hundred fifty dollars. B. Gary's share of the rent is one hundred fifty dollars. C. Gary's share of the rent is $150. D. Gary's share...
-
FCFE0 = $940, FCFF0 = $890, tax rate = 35%, book value of debt = $5000, cost of equity = 10%, cost of assets = 8.6%, cost of capital = 8%. Debt will remain constant forever. Cash flows are expected...
-
Find the value of n 6) n + 7n+15=5 -5-5
-
Chronic Chiropractic offers 1 service: spinal manipulations to ease back and body discomfort, reduce stress and improve overall well-being. Chronic Chiropractic has 2 groups of patients: standard...
-
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...
-
Last year, Miley decided to terminate the S corporation election of her solely owned corporation on October 17, 2018 (effective immediately), in preparation for taking it public. At the time of the...
-
You have been assigned to compute the income tax provision for Motown Memories Inc. (MM) as of December 31, 2019. The companys income statement for 2019 is provided below: MM prepared the following...
-
Jane has been operating Mansfield Park as a C corporation and decides she would like to make an S election. What is the earliest the election will become effective under each of these alternative...
Study smarter with the SolutionInn App