Question

In: Finance

You need to build a DCF model for an unlisted company. Since there are no market...

You need to build a DCF model for an unlisted company. Since there are no market prices available for the company stock, you need to use comparable companies to estimate the beta of your target. After some research, you reduce the comparable universe to the following three companies: Comparable A • Levered Beta = 0.81 • Debt = 67 m$ • Equity = 181 m$ • Marginal Tax Rate = 28 % Comparable B • Levered Beta = 0.96 • Debt = 1819 m$ • Equity = 1836 m$ • Marginal Tax Rate = 22 % Comparable C • Levered Beta = 1.23 • Debt = 435 m$ • Equity = 333 m$ • Marginal Tax Rate = 23 % Calculate the levered beta of the target knowing that the target company has: • • • Debt = 138 m$ Equity = 232 m$ Marginal Tax Rate = 29 % Enter your answer with four decimal points.

Solutions

Expert Solution

Comparable Company

Levered Beta

Debt (m$)

Equity (m$)

Debt/Equity

Comparable A

0.81

67

181

0.3702

Comparable B

0.96

1819

1836

0.9907

Comparable C

1.23

435

333

1.3063

Average of Comparable A, B and C

1

0.8891

Now, we have to use the Average Levered Beta and the Average Debt/Equity of the Comparable companies to calculate the Unlevered Beta of the target company in the formula:

Unlevered Beta = Levered Beta / [1 + {(1 – Marginal Tax Rate)(Debt/Equity)}]

Given, Marginal tax rate of target company = 29%

So, Unlevered Beta of the target company = 1 / [1 + {(1 – 0.29)(0.8891)}]       = 0.6130

Also, Given, Debt of the target company = 138m$

And Equity of the target company = 232 m$

This implies Debt /Equity of the target company = 0.5948

Now, we have to use the Unlevered Beta of the target company and the Debt/Equity of the target company of the Comparable companies to calculate the Levered Beta of the target company in the formula:

Levered Beta = Unlevered Beta x [1 + {(1 – Marginal Tax Rate)(Debt/Equity)}]

So, Levered Beta of the target company = 0.6130 x [1 + {(1 – 0.29)(0.5948)}]       = 0.8719


Related Solutions

build a model for used mobile market and elaborating to your model
build a model for used mobile market and elaborating to your model
EXERCISE 2.2 USING CETERIS PARIBUS Suppose you build a model of the market for umbrellas, in...
EXERCISE 2.2 USING CETERIS PARIBUS Suppose you build a model of the market for umbrellas, in which the predicted number of umbrellas sold by a shop depends on their colour and price, ceteris paribus. 1.   The colour and the price are variables used to predict sales. Which other variables are being held constant? Which of the following questions do you think this model might be able to answer? In each case, suggest improvements to the model that might help you...
Part A: You have been hired by a company to build a predictive analytics model to...
Part A: You have been hired by a company to build a predictive analytics model to increase their sales. Before building the model, your manager asked you to start with exploratory data analysis and report the findings. Which visualization tools would you use to display important properties of data such as outliers, range of data, mean, IQR, and distribution of data, etc.? Be specific about the tools and methods that display the skewness, similarity of distributions, and whether data comes...
Use the “home” data to build a regression model that predicts market as a function of...
Use the “home” data to build a regression model that predicts market as a function of square feet. Give a 99% confidence interval for the value of one square foot. (select the closest answer) Home Market Value House Age Square Feet Market Value 33 1,812 $90,000.00 32 1,914 $104,400.00 32 1,842 $93,300.00 33 1,812 $91,000.00 32 1,836 $101,900.00 33 2,028 $108,500.00 32 1,732 $87,600.00 33 1,850 $96,000.00 32 1,791 $89,200.00 33 1,666 $88,400.00 32 1,852 $100,800.00 32 1,620 $96,700.00 32...
Use the “home” data to build a regression model that predicts market as a function of...
Use the “home” data to build a regression model that predicts market as a function of square feet. Is the coefficient for square feet significant at a .05 level? Home Market Value House Age Square Feet Market Value 33 1,812 $90,000.00 32 1,914 $104,400.00 32 1,842 $93,300.00 33 1,812 $91,000.00 32 1,836 $101,900.00 33 2,028 $108,500.00 32 1,732 $87,600.00 33 1,850 $96,000.00 32 1,791 $89,200.00 33 1,666 $88,400.00 32 1,852 $100,800.00 32 1,620 $96,700.00 32 1,692 $87,500.00 32 2,372 $114,000.00...
I need to build a simple model of a coffee shop using Arena simulation
I need to build a simple model of a coffee shop using Arena simulation
In addition to the dividend discount model (DDM) and discounted cash flow (DCF) model there are...
In addition to the dividend discount model (DDM) and discounted cash flow (DCF) model there are different other valuation models/metrics. Can you identify some of them? Different models may be appropriate for different firms in different industries. Can you identify which models/metrics may be more appropriate for specific industries/firms?
SAFE PLC is an unlisted company that provides a range of services to the medical and...
SAFE PLC is an unlisted company that provides a range of services to the medical and healthcare industry. Last year, it made a profit of £500,000 and had a dividend payout ratio of 80%. The average P/E ratio for this sector is 9. The company’s balance sheet shows Shareholder funds of £2.25m for 1m shares, but the buildings are worth £1m more than their balance sheet value and stocks would be worth £250,000 less in a break-up of the company....
This is the shareholders’ equity of the Sun, a joint stock unlisted company, on Dec 31,...
This is the shareholders’ equity of the Sun, a joint stock unlisted company, on Dec 31, 2019.  Common share (1,000,000 issued and outstanding) $6,000,000  3%, preferred shares (100,000 authorized, 80,000 issued) 2,000,000  Retained earnings 4,000,000  Total $12,000,000 Notes: 1. Preferred shares were issued on Jan 1, 2010. 2. No dividends were declared or paid since Dec 31, 2014 until the Sun declared and paid $2,500,000 dividends on Dec 31, 2019. Requirements: a. Assuming preferred shares are...
MULTIPLE CHOICE: 1) Since it is based on cash flows, the discounted cash flow (DCF) method...
MULTIPLE CHOICE: 1) Since it is based on cash flows, the discounted cash flow (DCF) method of valuation has the added advantage that it is not subject to the bias of different: A. Discount rates B. Internal rates of return C. Monetary systems D. Accounting policies for determining total assets and net income 2) Which of the following budgets must be completed before preparing a cash budget? A. Cash receipts budget. B. Rolling budget. C. Cash financing budget. D. Pro...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT