Microsoft Word - Mini Case #2 - Neuquen, Inc.
Mini Case #2: Capital Budgeting at Neuquén, Inc.
Assignment Overview
Neuquén, Inc., a publicly traded firm, is considering the acquisition of a private
company, Artforever.com, which specializes in restoring damaged artwork and vintage
photographs for high net worth individuals. Neuquén’s CEO and chairman of the board,
Willie Ray, described the motivation for the acquisition as follows: “We are running out
of profitable investment opportunities in our core vintage shoe restoration business, and
our shareholders expect us to continue to grow. Therefore, we must look to acquisitions
to expand into growing markets.”
Neuquén, Inc.’s common stock is cu
ently trading at $50 per share, and the firm has
100,000 shares outstanding. The book value of the common stock is $20 per share.
However, as mentioned by Mr. Ray, sales had been slowing recently and the board was
concerned that soon the share price would also begin to flag as investors figured out
that the firm was running out of positive NPV investments. The firm has $2,000,000
market value of bonds trading at a yield to maturity of 6.2%.
You have been hired as a consultant to Neuquén to evaluate the proposed acquisition
of Artforever.com. There is considerable dissension among senior management and the
oard about whether the acquisition should be undertaken. Your job is to perform a
thorough analysis of the merits of the proposed acquisition and make a
ecommendation to senior management.
After several meetings with Neuquén management and a review of Artforever’s financial
performance and industry structure, you gathered the data shown in Table 1 below.
Forecast Data for Artforever.com (in $’000)
XXXXXXXXXX XXXXXXXXXX
Sales Revenue 1,000.0 1,250.0 1,875.0 2,100.0 3,750.0
Investment in CapEx and NWC XXXXXXXXXX0 80.0
Depreciation XXXXXXXXXX 80.0
Interest payments XXXXXXXXXX XXXXXXXXXX
Artforever.com cu
ently has $1,475,000 (market value) in long-term debt, with a
coupon rate of 7%. Its cost of goods sold (COGS) is expected to be 42% of sales
evenues, and selling, general and administrative (SG&A) expenses are expected to be
15 percent of revenues. The depreciation numbers listed above are already included in
COGS percentage estimates. The firm’s corporate tax rate is 40% and its cu
ent cost of
o
owing is 6.2%.
Your research indicates that Artforever has a target debt to value ratio of 15%, based on
its assessment of the probability and costs of financial distress. You note that this is
different from the capital structure of Neuquén and wonder how this would factor into
your analysis.
Although Artforever.com is a rapidly growing company, your analysis of industry
structure suggests that competition in the art restoration market is likely to increase in
the next few years. Thus, you forecast that the perpetual growth rate for free cash flows
eyond 2022 will be a more modest 2.0% per year.
Your analysis of market data yielded the information in Table 2 below.
Market Data
Cu
ent yield to maturity on 30 year treasury bonds 2.50%
Cu
ent yield to maturity on 3 month treasury bills 2.0%
Most recent 1-year return on the S&P XXXXXXXXXX%
Estimate of expected average return on the S&P 500 over the next 30 years 8.0%
Your analysis of Artforever.com’s industry reveals that most of the firms in the industry,
like Artforever, are private firms. However, you find a close competitor, ArtToday.net,
that is in the same line of business and is publicly traded. ArtToday has a long-term
target debt to equity ratio of 0.75, and has been historically quite close to that target.
Your analysis of ArtToday’s historical returns against the market returns yields an equity
eta of 1.5. ArtToday cu
ently has 50,000 common shares outstanding trading at $12
per share. Assume that both companies face a similar tax rate.
Guidelines for Case Analysis
The following aids are permitted for this analysis: You may use internet sources,
ooks, all posted materials (including Discussion Board Q&A), and your notes. Any
other aids are unauthorized and their use constitutes a violation of academic
integrity. This includes face-to-face or electronic co
espondence concerning the
specific details of the case with any other person that is not a member of your assigned
group, whether or not they have cu
ent or past affiliation with Texas A&M University
Corpus Christi.
The case is due on the date indicated on the course schedule. Late papers may be
accepted with a reasonable excuse, but will be assessed a 20% grade reduction
penalty. Cases should be typed in 12-point font, double-spaced, with a minimum
of 1 inch margins.
The case report should be written according to the following format:
1. Introduction
2. Analysis
3. Conclusion
The introduction sets the stage for the work to follow and should consist of
a short paragraph of the key problem(s) or issue(s) that your analysis addresses. The
analysis will constitute the bulk of the written presentation and will be a direct response
to the questions below. Use clear, concise, and complete sentences. Do not use bullet
points or numbered paragraphs. The conclusion should be a short paragraph that
summarizes the key points of the analysis.
Your report should not exceed five pages of double-spaced text with 1 inch
margins at the sides, top, and bottom of the page. This does not include exhibits of
your computations. You may submit one Excel spreadsheet that contains all your
exhibits, clearly labeled, and appropriately referenced in the text of your report.
Your analysis of “Neuquén, Inc.” should include answers to the questions below. Do not
write the questions ve
atim in your report. Instead, write a
ief introductory
statement that summarizes the question before you proceed with your analysis.
1. What discount rate is appropriate for finding the value of Artforever.com?
Write a few paragraphs giving your answer and clearly explaining your reasoning and computations; show
detailed computations in your Excel spreadsheet labeled Exhibit 1.
2. What are the relevant cash flows for valuing Artforever.com? Assume that your
valuation is performed at the end of 2017, and that the values shown in Table 1 are
end-of-year forecasts.
Write a few paragraphs giving your answer and clearly explaining your reasoning and computations; show
detailed computations in your Excel spreadsheet labeled Exhibit 2.
3. Based on your answers to questions (1) and (2) above, what is the maximum price that
Neuquén should pay to equity shareholders for Artforever.com?
Write a few paragraphs giving your answer and clearly explaining your reasoning and computations; show
detailed computations in your Excel spreadsheet labeled Exhibit 3.
4. Under what conditions might you consider recommending that management make a
higher offer than your recommended price in (3) above?
No computations are necessary, just a short discussion.
Your report is intended for the senior management of Neuquén, Inc., so be sure that
you write in a professional style that is easy to follow.
Donny Hall
Donny Hall
Donny Hall
Donny Hall
Exhibit
Neuquen Inc Market Data
Cu
ent yield to maturity on 30 year treasury bonds 2.50%
Shares Outstanding 100,000 Cu
ent yield to maturity on 3 month treasury bills 2.0%
Market Value of one stock $ XXXXXXXXXX Most recent 1-year return on the S&P 500 5.3%
Book value of common stock $ XXXXXXXXXX Estimate of expected average return on the S&P 500 over the next 30 years 8.0%
Bonds $ 2,000,000.00
YTM bonds 6.20%
ArtToday.net
Forecast data for Artforever.com Tax rate 40%
2018 2019 2020 2021 2022 Long term debt to equity ratio 0.75
Sales revenue $ 1,000,000.0 $ 1,250,000.0 $ 1,875,000.0 $ 2,100,000.0 $ 3,750,000.0 Equity beta (levered) 1.5
Investment in CapEx and NWC $ 25,000.0 $ 55,000.0 $ 170,000.0 $ 80,000.0 $ 80,000.0 common stock outstanding 50,000
Depreciation $ 15,000.0 $ 30,000.0 $ 50,000.0 $ 72,000.0 $ 80,000.0 Value per share $ XXXXXXXXXX
Interest payments $ 944,000.0 $ 1,014,000.0 $ 1,086,000.0 $ 1,159,000.0 $ 1,224,000.0
Unlevered beta = levered beta/(1+debt to equity*(1-tax rate)
Market value of long term debt $ 1,475,000 Unlevered beta (for art today) XXXXXXXXXX
Coupon rate 7%
COGS(% of sales) 42%
SGA (% of sales) 15%
Tax rate 40%
Interest rate 6.20%
Target debt to value ratio (debt:total value) 15% Target D/E 17.65%
Growth rate (beyond 2022) 2%
Equity to value ratio 85%
Target Debt to equity ratio 0.18
Re-levered beta for Art forever 1.1440 Re-Levered beta = Unlevered beta*(1+target debt to equity ratio(1-taxrate))
Expected return on Equity for ArtForever 8.79209%
R (WACC) (discount rate) 8.0313%
2018 2019 2020 2021 2022
Revenues $ 1,000,000.00 $ 1,250,000.00 $ 1,875,000.00 $ 2,100,000.00 $ 3,750,000.00
COGS $ 420,000.00 $ 525,000.00 $ 787,500.00 $ 882,000.00 $ 1,575,000.00
SGA $ 150,000.00 $ 187,500.00 $ 281,250.00 $ 315,000.00 $ 562,500.00
EBIT $ 430,000.00 $ 537,500.00 $ 806,250.00 $ 903,000.00 $ 1,612,500.00
Taxes (40%) $ 172,000.00 $ 215,000.00 $ 322,500.00 $ 361,200.00 $ 645,000.00
Earnings before interest and after tax $ 258,000.00 $ 322,500.00 $ 483,750.00 $ 541,800.00 $ 967,500.00
Add depreciation $ 15,000.00 $ 30,000.00 $ 50,000.00 $ 72,000.00 $ 80,000.00
Investments in Capex and NWC $ 25,000.00 $ 55,000.00 $ 170,000.00 $ 80,000.00 $ 80,000.00
Free cash flow $ 248,000.00 $ 297,500.00 $ 363,750.00 $ 533,800.00 $ 967,500.00
Terminal value after 2022 $ 16,362,209.63
Total cash flow $ 248,000.00 $ 297,500.00 $ 363,750.00 $ 533,800.00 $ 17,329,709.63
Enterprise value today for ArtForever 12,942,130.68
Market value of equity = Enterprise value - Market value of debt 11,467,130.68
Sheet1
Neuquen Inc Market Data
Cu
ent yield to maturity on 30 year treasury bonds 2.50%
Shares Outstanding $ 100,000.00 Cu
ent yield to maturity on 3 month treasury bills 2.0%
Market Value of one stock $ XXXXXXXXXX Most recent 1-year return on the S&P 500 5.3%
Book value of common stock $ XXXXXXXXXX Estimate of expected average return on the S&P 500 over the next 30 years 8.0%
Bonds $ 2,000,000.00
YTM bonds 6.20%
ArtToday.net
Forecast data for Artforever.com (in $ '000) Tax rate 40%
2018 2019 2020 2021 2022 Long term debt to equity ratio 0.75
Sales revenue $ 1,000.0 $ 1,250.0 $ 1,875.0 $ 2,100.0 $ 3,750.0 Equity beta (levered) 1.5
Investment in CapEx and NWC $ 25.0 $ 55.0 $ XXXXXXXXXX $ 80.0 $ 80.0 common stock outstanding 50000
Depreciation $ 15.0 $ 30.0 $ 50.0 $ 72.0 $ 80.0 Value per share $ XXXXXXXXXX
Interest payments $ 94.4 $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX
Unlevered beta = levered beta/(1+debt to equity*(1-tax rate)
Market value of long term debt $ 1,475,000 Unlevered beta (for art today) XXXXXXXXXX
Coupon rate 7%
COGS(% of sales) 42%
SGA (% of sales) 15%
Tax rate 40%
Interest rate 6.20%
Target debt to value ratio (debt:total value) 15% Target D/E 17.65%
Growth rate (beyond 2022) 2%
Equity to value ratio 85%
Target Debt to equity ratio 0.18
Re-levered beta for Art forever 1.1440 Re-Levered beta = Unlevered beta*(1+target debt to equity ratio(1-taxrate))
Expected return on Equity for ArtForever 8.79209%
R (WACC) (discount rate) 8.0313%
2018 2019 2020 2021 2022
Revenues $ 1,000,000.00 $ 1,250,000.00 $ 1,875,000.00 $ 2,100,000.00 $ 3,750,000.00
COGS $ 420,000.00 $ 525,000.00 $ 787,500.00 $ 882,000.00 $ 1,575,000.00
SGA $ 150,000.00 $ 187,500.00 $ 281,250.00 $ 315,000.00 $ 562,500.00
EBIT $ 430,000.00 $ 537,500.00 $ 806,250.00 $ 903,000.00 $ 1,612,500.00
Taxes (40%) $ 172,000.00 $ 215,000.00 $ 322,500.00 $ 361,200.00 $ 645,000.00
Earnings before interest and