In this question, you are hired by Palumbo & Entrup Partners (PE) to decide whether it...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In this question, you are hired by Palumbo & Entrup Partners (PE) to decide whether it is worthwhile to purchase a private firm, Young LLC. Young LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Young LLC. 2021 Income Statement and Balance Sheet Data for Young LLC. Year 2021 Year 2021 Income Statement ($ 000) Balance Sheet ($ 000) 1 Sales 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 2 Cost of Goods Sold (3,000) (2,400) 14,600 11,000 4,000 5,000 3 Raw Materials 4 Direct Labor Costs 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 4 Total Current Assets 20,000 10,000 5 Property, Plant, and Equipment 6 Goodwill 1 Total Assets| Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity (2,600) (3,800) --- 8,200 30,000 (1,000) 7,200 11 Interest Expense (net) (300) 9 Depreciation 10 EBIT 1,255 6,000 7,255 12 Pre-tax Income 6,900 13 Income Tax 14 Net Income (1,380) 5,520 22,745 30,000 Young LLC has excess cash of $10 million. Based on its business, the comparable companies are Microsoft Corporation (MSFT), Alphabet Inc. (GOOGL), and Apple Inc. (AAPL). The owner of Young is willing to accept a price based on the average of equity prices estimated using P/E, and Enterprise Value/EBITDA ratios for each of the comparable firm. Based on your analysis, what acquisition price will you propose to pay for the owner (the equity holder)? (Please use the ratios in the following table.) Valuation ratios of comparable firms Multiple AAPL MSFT GOOGL P/E 31.3 38.0 28.1 EV/EBITDA 24.4 27.8 18.9 Your manager wants to know how much money can PE make after buying the firm. You are given the following assumptions (if you need any other assumptions, please list them explicitly in your answer): 1. Market size for this type of watch is 1 million units in current year and is expected to grow at the rate of 10% per year in the coming five years; 2. Market share of Young is 20%. With some sales and marketing strategies, the market share can be increased by 300 basis points per year for the coming 5 years. That is, the market share next year will be 23%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 5% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 7% in the coming 5 years. 5. The direct labor costs are $12/unit in current year and is expected to grow by 5% per year in the coming 5 years. 6. The sales and marketing costs account for 13% of the sales in current year. To increase the sales, PE plans to increase these costs to 16% in the next year and 18% in the year after next. After that, the costs will be 20% of the sales every year. 7. The administrative costs are 19% of sales in current year. PE plans to decrease them to 16% of sales in the next year, and 15% of sales from the year after next on. 8. The tax rate is 20% for all years. 9. The depreciation expense equals 10% of Property, Plant and Equipment of that year. 10. The Capital expenditure equals the depreciation cost. 11. Your manager wants you to use the discounted cash flow approach to estimate the continuation/terminal value. 12. To get the unlevered cost of equity, you are expected to estimate the levered beta of comparable firms using the stock return data of most recent 60 calendar months, calculate the unlevered beta assuming their debts are risk free, and take an average of the unlevered beta. (If you are not able to get the unlevered cost of equity, you can use 8% to continue the rest of the question.) To improve the operational efficiency, PE hopes to reach the following goals from the next year on: the accounts receivable will be 45 days of sales revenue, the raw materials will have 60 days of inventory, the finished goods will have 30 days of inventory; the minimum cash balance will be 20 days of sales. The wage payable will be 15 days of labor costs (including both the direct labor cost and administrative costs) and other account payable will be 60 days of raw materials and sales & marketing costs. To increase the firm value, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 3% per year. After five years, the acquired firm is expected to be sold at a price valued based on the perpetual free cash flows of the firm growing at 2% per year rate forever. (If you can't get the terminal value of the firm in five years, you can use $280 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) PE will also return all the debt when selling the firm. Based on these assumptions, what is the NPV of acquiring Young LLC.? In this question, you are hired by Palumbo & Entrup Partners (PE) to decide whether it is worthwhile to purchase a private firm, Young LLC. Young LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Young LLC. 2021 Income Statement and Balance Sheet Data for Young LLC. Year 2021 Year 2021 Income Statement ($ 000) Balance Sheet ($ 000) 1 Sales 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 2 Cost of Goods Sold (3,000) (2,400) 14,600 11,000 4,000 5,000 3 Raw Materials 4 Direct Labor Costs 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 4 Total Current Assets 20,000 10,000 5 Property, Plant, and Equipment 6 Goodwill 1 Total Assets| Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity (2,600) (3,800) --- 8,200 30,000 (1,000) 7,200 11 Interest Expense (net) (300) 9 Depreciation 10 EBIT 1,255 6,000 7,255 12 Pre-tax Income 6,900 13 Income Tax 14 Net Income (1,380) 5,520 22,745 30,000 Young LLC has excess cash of $10 million. Based on its business, the comparable companies are Microsoft Corporation (MSFT), Alphabet Inc. (GOOGL), and Apple Inc. (AAPL). The owner of Young is willing to accept a price based on the average of equity prices estimated using P/E, and Enterprise Value/EBITDA ratios for each of the comparable firm. Based on your analysis, what acquisition price will you propose to pay for the owner (the equity holder)? (Please use the ratios in the following table.) Valuation ratios of comparable firms Multiple AAPL MSFT GOOGL P/E 31.3 38.0 28.1 EV/EBITDA 24.4 27.8 18.9 Your manager wants to know how much money can PE make after buying the firm. You are given the following assumptions (if you need any other assumptions, please list them explicitly in your answer): 1. Market size for this type of watch is 1 million units in current year and is expected to grow at the rate of 10% per year in the coming five years; 2. Market share of Young is 20%. With some sales and marketing strategies, the market share can be increased by 300 basis points per year for the coming 5 years. That is, the market share next year will be 23%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 5% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 7% in the coming 5 years. 5. The direct labor costs are $12/unit in current year and is expected to grow by 5% per year in the coming 5 years. 6. The sales and marketing costs account for 13% of the sales in current year. To increase the sales, PE plans to increase these costs to 16% in the next year and 18% in the year after next. After that, the costs will be 20% of the sales every year. 7. The administrative costs are 19% of sales in current year. PE plans to decrease them to 16% of sales in the next year, and 15% of sales from the year after next on. 8. The tax rate is 20% for all years. 9. The depreciation expense equals 10% of Property, Plant and Equipment of that year. 10. The Capital expenditure equals the depreciation cost. 11. Your manager wants you to use the discounted cash flow approach to estimate the continuation/terminal value. 12. To get the unlevered cost of equity, you are expected to estimate the levered beta of comparable firms using the stock return data of most recent 60 calendar months, calculate the unlevered beta assuming their debts are risk free, and take an average of the unlevered beta. (If you are not able to get the unlevered cost of equity, you can use 8% to continue the rest of the question.) To improve the operational efficiency, PE hopes to reach the following goals from the next year on: the accounts receivable will be 45 days of sales revenue, the raw materials will have 60 days of inventory, the finished goods will have 30 days of inventory; the minimum cash balance will be 20 days of sales. The wage payable will be 15 days of labor costs (including both the direct labor cost and administrative costs) and other account payable will be 60 days of raw materials and sales & marketing costs. To increase the firm value, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 3% per year. After five years, the acquired firm is expected to be sold at a price valued based on the perpetual free cash flows of the firm growing at 2% per year rate forever. (If you can't get the terminal value of the firm in five years, you can use $280 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) PE will also return all the debt when selling the firm. Based on these assumptions, what is the NPV of acquiring Young LLC.?
Expert Answer:
Answer rating: 100% (QA)
To find out the acquisition price first we need to do the equity valuation in the preacquisition and ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Income statement and balance sheet data for Great Adventures, Inc., are provided below. As you can tell from the financial statements, 2014 was an especially busy year. Tony and Suzie were able to...
-
Income statement and balance sheet data for Virtual Gaming Systems are provided below. Required: 1. Calculate the following risk ratios for 2015 and 2016: a. Receivables turnover ratio. b. Inventory...
-
Income statement and balance sheet data for The Athletic Attic are provided below. Required: 1. Calculate the following risk ratios for 2015 and 2016: a. Receivables turnover ratio. b. Inventory...
-
You need to write a paper about the leadership and your responsibility in an organization. Which types of problems can be occurred and how can you face them
-
Quetario Company is considering purchasing a machine that would save the company $ 13,500 in cash per year for six years, at the end of which the machine would be retired with no residual value. The...
-
The trial balance of Gaolee Fashion Center contained the following accounts at November 30, the end of the company's fiscal year. Adjustment data: 1. Supplies on hand totaled $2,600. 2. Depreciation...
-
Describe the wide variety of legal issues that occur in the emergency department setting.
-
Harvey Inc. uses a standard cost system for labor. Standard costs for material cannot be used because customers require unique materials and all jobs are different sizes. One of the companys jobs...
-
How do cognitive biases, such as confirmation bias and anchoring, impact decision-making during conflict resolution, and what strategies can be employed to mitigate their effects and promote more...
-
Devon Bishop, age 45, is single. He lives at 1507 Rose Lane, Albuquerque, NM 87131. His Social Security number is 111-11-1117. Devon does not want $3 to go to the Presidential Election Campaign Fund....
-
Calculate the concentration of a solution made by diluting 67.0 mL of 4.2 M HBr to a final volume of 500.0 mL. Significant figures are graded for this problem. Be sure you do not round your answers...
-
Intermediate substations are often economical from the viewpoint of the number of lines required for power transfer if their costs do not outweigh the reduction in line costs. (a) True (b) False
-
Consider an ideal single-phase 2-winding transformer of turns ratio \(N_{1} / N_{2}=a\). If it is converted to an autotransformer arrangement with a transformation ratio of \(V_{H} / V_{X}=1+a\),...
-
A single-phase step-down transformer is rated \(13 \mathrm{MVA}, 66 \mathrm{kV} / 11.5 \mathrm{kV}\). With the \(11.5 \mathrm{kV}\) winding short-circuited, rated current flows when the voltage...
-
If Doria Oliva dies this year (2019), what estate tax is payable if the facts are: Adjusted gross estate Adjusted taxable gifts after 1976 Cift tax paid $11,710,000 100,000 6,000
-
For a conceptual single-phase phase-shifting transformer, the primary voltage leads the secondary voltage by \(30^{\circ}\). A load connected to the secondary winding absorbs \(110 \mathrm{kVA}\) at...
-
A DVD sales rack has 21 comedies, 14 dramas, 11 science fiction movies, and 31 action movies. How many DVDs are on the sales rack? 76 77 78 79 2 answers
-
What is a manufacturing system?
-
In testing a claim about a population mean, a larger z test statistic always results in a larger P-value. Decide whether the statement makes sense (or is clearly true) or does not make sense (or is...
-
In testing the claim that the mean IQ score of statistics students is greater than 100, the alternative hypothesis is expressed as > 100. Decide whether the statement makes sense (or is clearly...
-
A handy mnemonic for interpreting the P-value in a hypothesis test is this: If the P (value) is low, then the null must go.
Study smarter with the SolutionInn App