Investments HW 5
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
Investments HW 5
This homework should reflect your own work. Please use Excel to perform the tasks. It is recommended you create an Excel worksheet for each of the problem questions. Please mark your answers clearly. For questions that doesn’t involve calculations, please type in your answers in the same Excel file as texts and clearly label your answers so it is easy for the TAs to locate them.
1. (20 points) Radius Manufacturing started operations on December 31, 2019, acquiring a new facility for a total of $500 million. Below are financial statements for 2019 and 2020 in millions of dollars. What is Radius’ Free Cash Flow in 2020?
|
|
|
|
2019 |
2020 |
Income Statement |
|
|
|
|
|
Revenue |
|
|
|
|
500 |
Operating Costs |
|
|
|
300 |
|
Depreciation |
|
|
|
|
40 |
Earnings Before Interest and Taxes |
|
|
160 |
||
Taxes |
|
|
|
|
64 |
EBIAT |
|
|
|
|
96 |
|
|
|
|
|
|
Balance Sheet |
|
|
|
|
|
Accounts Receivable |
|
|
0 |
85 |
|
Inventory |
|
|
|
0 |
90 |
Current Assets |
|
|
0 |
175 |
|
|
|
|
|
|
|
Gross Property, Plant, and Equipment |
|
360 |
480 |
||
Less: Accumulated Depreciation |
|
0 |
40 |
||
Net Property, Plant, and Equipment |
|
360 |
440 |
||
Total Assets |
|
|
|
360 |
615 |
|
|
|
|
|
|
Accounts Payable |
|
|
0 |
40 |
|
Equity |
|
|
|
360 |
456 |
Total Liabilities and Equity |
|
360 |
496 |
NOTE: Assume that Net Working Capital = Accounts Receivable + Inventory – Accounts Payable.
Questions 2:
XYZ Corporation does not currently pay cash dividends and is not expected to for the next five years. Its latest EPS was $10, all of which was reinvested in the company. The firm’s expected ROE for the next five years is 20% per year, and during this time it is expected to continue to reinvest all of its earnings. Starting in year 6, the firm’s ROE on new investments is expected to fall to 15%, and the company is expected to start paying out 40% of its earnings in cash dividends, which it will continue to do forever after. XYZ’s market capitalization rate is 15% per year. Please answer the following questions:
1) (15 points) Project the earnings and dividends for each ear from year 0 to year 6 (assuming the dividend will grow at the same rate as ROE)
2) (15 points) Estimate XYZ’s intrinsic value per share, using a two-stage DDM model
Questions 3:
You are trying to value a private firm, Acme Inc., to figure out how much money it can expect to raise in an IPO. Acme Inc. manufactures pool equipment. In the current year, Acme has sales of $1M and the free cash flow of $0.5M.
You identified two publicly traded firms, Firm A and Firm B, with very similar business models, on which you will base your valuation.
You looked up the following information, for the current year, for these comparable firms:
Comparable Firm values (in $M) |
Firm A |
Firm B |
ACME |
Value of equity: |
100 |
500 |
|
Value of debt |
30 |
10 |
|
Equity beta |
1.7 |
1.2 |
|
Debt beta |
0.25 |
0.25 |
|
Sales |
10 |
55 |
1.0 |
Free Cash Flow |
6 |
30 |
0.5 |
Sales and Cash flow growth rate (g) |
|
|
3% |
|
|
|
|
r_f |
2% |
|
|
r_M- r_f |
5% |
|
|
1) (10 points) What is Acme’s valuation as measured by the sales multiple of comparable firms?
2) (10 points) What is Acme’s valuation as measured by the cash flow multiple of comparable firms?
3) (30 points) You expect that Acme’s sales and cash flows will grow in perpetuity at the annual growth rate of 3%. Furthermore, you observe that the risk-free rate is 2%. You estimate that the expected market risk premium is 5%. Assume that the beta of debt is 0.25 for all firms. What is the Discounted Cash Flow valuation of Acme? (HINT: Use the Gordon Growth Formula. For discount rates for ACME, use the CAMP model with ACME beta being the average asset beta of firm A and B, which can be calculated as
i. Beta(asset) = E/(D+E) *beta_equity + D/(D+E) *beta_debt,
where D and E are debt and equity value)
2023-11-07