In this question, you are hired by Popper & Eciancio 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 Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew LLC.? In this question, you are hired by Popper & Eciancio Partners (PE) to decide whether it is worthwhile to purchase a private firm, Matthew LLC. Matthew LLC produces a type of communicating watch with its own apps. The following table shows the financial information for Matthew LLC. 2021 Income Statement and Balance Sheet Data for Matthew LLC. Year 2021 Year 2021 Balance Sheet (S 000) Income Statement (S 000) 1 Sales 2 Cost of Goods Sold Raw Materials 20,000 Assets 1 Cash and Equivalents 2 Accounts Receivable 3 Inventories 11.000 (3,000) (2.400) 4,000 Direct Labor Costs 5,000 4 5 Gross Profit 6 Sales and Marketing 7 Administrative 8 EBITDA 9 Depreciation 10 EBIT 11 Interest Expense (net) (300) 12 Pre-tax Income 13 Income Tax 14 Net Income 14,600 4 Total Current Assets 20,000 5 Property, Plant, and Equipment 6 Goodwill 7 Total Assets Liabilities and Stockholder's Equity 8 Accounts Payable 9 Debt 10 Total Liabilities 11 Stockholder's Equity 12 Total Liabilities and Equity 10,000 (2,600) (3,800) 8.200 30,000 (1.000) 7,200 1,255 6,000 6,900 7,255 (1,380) 5,520 22,745 30,000 Matthew 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 Matthew LLC is willing to accept a price based on the average of equity prices estimated using PE, 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 РЕ 27.9 33,3 30.2 EVEBITDA 21.6 22.7 21 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 15% per year in the coming five years; 2. Market share of Matthew LLC is 20%. With some sales and marketing strategies, the market share can be increased by 200 basis points per year for the coming 5 years. That is, the market share next year will be 22%. 3. The average sales price is $100/unit in current year and is expected to grow at the rate of 3% per year. 4. The raw materials cost $15/unit in current year and is expected to grow at the rate of 10% 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 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, if the interest expense in current year is less than 30% of EBIT in the previous year, PE believes that the debt level is safe. In other words, PE wants to have an interest payment of $2.16 million in the coming 5 years. The interest rate for the safe debt is 5% 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 $220 million as the terminal/end value to continue your work to get the credits for the rest of this problem.) Based on these assumptions, what is the NPV of acquiring Matthew 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
Related Book For
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...
-
For rigid-body motion, the strains will vanish. Under these conditions, integrate the straindisplacement relations (7.6.1) to show that the most general form of a rigid-body motion displacement field...
-
Sketch an AD-AS diagram depicting an economy in short run equilibrium. Discuss how the economy reaches long-run equilibrium. Discuss how the economy reaches long run equilibrium over a period of time...
-
The accounting information system of Textbook Co. reported the following cost and inventory data for the year. Required A. Calculate the cost of goods manufactured. B. Calculate the cost of goods...
-
In a 1975 contract, Eureka was given the exclusive right to sell spring water and other products under the Ozarka trade name in 60 Oklahoma counties in exchange for \($9,000\) paid to Arrowhead,...
-
The accounting records of Rhyme Redwood Corporation provide income statement data for 2012. Total revenue . . . . . . $ 940,000 Total expenses . . . . . . . 750,000 Income before tax . . . $ 190,000...
-
1. A car has tires that have an outer diameter of 31 inches. If the wheels are turning with an angular velocity of 12 rad/s, how far in miles will the car travel in 2 hours? Enter your result rounded...
-
The unadjusted trial balance of Mesa Inc., at the company's year end of December 31 follows: Additional information and adjustment data: 1. The 12-month insurance policy was purchased and was...
-
Read the article below and explain why Krugman believes a recession is imminent. Either agree or disagree with Krugman and explain why. Paul Krugman Warns an Imminent U.S Recession Nobel laureate...
-
Discuss an example of when the basic quality method of FMEA and/or Reliability Availability and Maintainability were followed in an organization, and another example when they were not followed in an...
-
M Connect | Learning X M Question 26 - Chapt Dashboard Product templates | R Create - PhotoRoom a Amazon A 57F | +...
-
Calculate the 2022 Vertical Analysis "Inventory" in % using total assets as your base. Fill in the numerator and denominator using the financial statements provided (no symbols or commas) and the...
-
As financial advisor (or even when investing your own funds), "Know Your Product" is an important part of determining the suitability of a particular fund for a given investor. You must ensure that...
-
This project will have two classes: A test class and a Bank Account class. Construct the Bank Account class by pasting the following code into BlueJ: public class BankAccount { public BankAccount...
-
What factors should leadership consider when selecting performance indicators? Group of answer choices Organizational goals and stakeholder requirements Professional groups represented in the...
-
Floyd Distributors, Inc., provides a variety of auto parts to small local garages. Floyd purchases parts from manufacturers according to the EOQ model and then ships the parts from a regional...
-
The Social Security Administration Web site has a link to a publication entitled Social Security Programs Throughout the World. The European version is online at...
-
Consider the example presented in the appendix to this chapter. Which coefficient estimates would be considered statistically significant or distinct from zero?
-
Many states have constitutional requirements that their budgets be in balance (or in surplus) in any given year, but this is not true for the U.S. federal government. Why might it make sense to allow...
-
The financial records of Dunbar Inc. were destroyed by fire at the end of 2015. Fortunately, the controller had kept the following statistical data related to the income statement. 1. The beginning...
-
Maher Inc. reported income before income tax during 2015 of 790,000. Additional transactions occurring in 2015 but not considered in the 790,000 are as follows. 1. The corporation experienced an...
-
Presented below is the trial balance of Thompson Corporation at December 31, 2015. Instructions Prepare an income statement and a retained earnings statement. Assume that the only changes in retained...
Study smarter with the SolutionInn App