View the step-by-step solution to:

Question

# (Please use an Excel Spreadsheet to solve this problem.)You are the CFO of GreatFood, a large chain of

grocery stores. It is the first week in December, and you are planning to expand your business by acquiring the GoodWine winery that has recently been put up for sale by the owners. You think that this acquisition may turn out to be a good investment so you want to have solid financial background for the deal to present at the upcoming Shareholders Meeting in late December 2019. You have the following information about the GoodWine winery (the "Target") and your firm (the "Acquirer").

GoodWine winery ("Target")

Some important accounting numbers projected for the next 5 years are as follows (all numbers are before-tax, as of the end of the fiscal year and in \$ thousands):

Problem 2 - Firm Valuation and M&A (50 Marks)

2020

Sales 2327.0

EBITDA 581.8

Capital expenditures 500.0 350.0 Increase in NWC 50.0 60.0

2021

2022

2984.0 746.0 200.0

65.0 185.7

2023

3447.0 861.8 180.0

70.0 191.2

2024

3743.0 935.8 150.0

75.0 197.0

Depreciation 175.0

180.3

2863.0 715.8

After year 5, the winery's free cash flow (FCF) will grow at an annual rate of 3% into perpetuity. There are 200 thousand shares outstanding. The market value of equity is currently \$3,500 thousand and the market value of outstanding debt is \$450 thousand (assume that the share price, the value of equity, and the value of debt are given at the valuation date, i.e. end of December, 2019). The firm faces the (marginal) tax rate of 40%. The asset beta of the target (the beta of the same but all-equity firm) is 1.15.

GreatFood (Acquirer)

The acquirer expects to have the following estimated synergies from the M&A and all figures are before-tax, as of the end of the fiscal year and in \$ thousands:

Synergies 2020 2021 2022 2023 2024

EBITDA 134.0 150.0 171.0 216.0 223.0

After year 5, the free cash flow (FCF) from synergies will grow at an annual rate of 2% into perpetuity. The firm faces the (marginal) tax rate of 40%. The asset beta of the acquirer (the beta of the same but all-equity firm) is 0.8.

Note: The fiscal years of both your firm and the target end on December 31 (i.e. all projected numbers are given at the end of the fiscal year starting from exactly one year from the date of valuation).

Information about the deal/market conditions

The target leverage (D/V) after the deal is completed is expected to be 25% (applies to both the target and the synergies). The borrowing rate (cost of capital) is 8% and the Treasury bond rate (risk-free rate) is 3%. The market risk premium is 5%.

1.1. What is the maximum price per share that your firm can pay for the target based on DCF and APV methods? You can build your analysis on the following steps in your valuation:

a) Estimate the value of the levered target firm:

a. Calculate the cost of assets (unlevered equity return, i.e. cost of equity of the same but all-equity

firm) for the target using CAPM

b. Calculate the cost of equity (levered equity return) for the target

c. Calculate the weighted average cost of capital (WACC) for the target

d. Estimate free cash flow (FCF) for years 2020-2024

e. Calculate the terminal value in 2024 using the APV method and the WACC method separately

f. Calculate the value of the levered target firm using the APV method (Hint: since leverage is

expected to change, D*t is not an appropriate way of estimating tax shields - derive tax shields

from the relation between the levered and unlevered values of the firm)

g. Calculate the value of the levered target firm using the WACC method

b) Calculate the value of synergies:

a. Calculate the cost of assets for the acquirer using CAPM

b. Calculate the cost of equity (levered equity return) for the acquirer

c. Calculate the weighted average cost of capital (WACC) for the acquirer

d. Estimate free cash flow (FCF) from synergies for years 2020-2024 using beta and growth rate of

the acquirer

e. Calculate the terminal value of synergies in 2024 using the APV method and the WACC method

separately

f. Calculate the value of the levered synergies using the APV method (do not forget about the tax

shields)

g. Calculate the value of the levered synergies using the WACC method

c) Find the value of the target's equity to the acquirer:

a. Calculate the value of the levered target to the acquirer by adding the value of synergies to the

value of the levered target firm

b. Subtract the amount of outstanding debt to get the value of equity

d) Calculate the maximum price per share that the acquirer can pay for the target

1.2. If your firm announces the deal in December 2019, what is the expected return on the target's equity at the announcement (based on both DCF and APV methods)?     L5F11146 8H1E| @133 ‘3: EE—T, 1511mm: X D https://inst-fs-yu|-prod.insc X D https://parking.utm.utoront X HomeworkHelp-Q&amp;Afrom X
&lt; C i inst—fs—yu|—prod.inscloudgate.net .9 ﬁ  no
t. Calculate the value of the levered target firm using the APV method (Flint: since leverage IS
4/5 expected to change, D*t is not an appropriate way of estimating tax shields — derive tax shields from the relation between the levered and unlevered values of the ﬁrm)
g. Calculate the value of the levered target firm using the WACC method
b) Calculate the value of synergies:
a. Calculate the cost of assets for the acquirer using CAPM
b. Calculate the cost of equity (levered equity return) for the acquirer
c. Calculate the weighted average cost of capital (WACC) for the acquirer
d. Estimate free cash flow (FCF) from synergies for years 2020-2024 using beta and growth rate of
the acquirer
e. Calculate the terminal value of synergies in 2024 using the APV method and the WACC method
separately
f. Calculate the value of the levered synergies using the APV method (do not forget about the tax
shields)
g. Calculate the value of the levered synergies using the WACC method
c) Find the value of the target’s equity to the acquirer:
a. Calculate the value of the levered target to the acquirer by adding the value of synergies to the
value of the levered target firm
b. Subtract the amount of outstanding debt to get the value of equity
d) Calculate the maximum price per share that the acquirer can pay for the target 1.2. If your firm announces the deal in December 2019, what is the expected return on the target’s equity at the
announcement (based on both DCF and APV methods)? 1411:46 8A18 8
65%
a inst-fs-yul-prod.inscloudgate.net
5/5
Hint: The following relationship will be useful for you in Problem 2.
PV (TS) = V Ic and V1 = Vu + PV(TS) =&gt; PV(TS) = (Vu + PV(IS)) _ Tc
&gt; PV(TS) = V. P. Tc + PV(IS) PT. =&gt; 1-[PIC PV(TS) = V. PTC
Vu
=&gt; PV (TS) =
1 -
D
VI
To L5F11146 8H1E| @133 ‘3: EE—T, 1511mm: X D https://inst-fs-yul-prod.insc X D https://parking.utm.utoront X HomeworkHelp-Q&amp;Afrom X &lt; G i inst—fs—yu|—prod.inscloudgate.net \$1 5%  4/5 Information about the deallmarket conditions The target leverage (D/V) after the deal is completed is expected to be 25% (applies to both the target and the
synergies). The borrowing rate (cost of capital) is 8% and the Treasury bond rate (risk-free rate) is 3%. The market
risk premium is 5%. 1.1. What is the maximum price per share that your firm can pay for the target based on DCF and APV methods?
You can build your analysis on the following steps in your valuation: a) Estimate the value of the levered target firm:
a. Calculate the cost of assets (unlevered equity return, i.e. cost of equity of the same but all-equity
firm) for the target using CAPM
Calculate the cost of equity (levered equity return) for the target
Calculate the weighted average cost of capital (WACC) for the target
Estimate free cash flow (FCF) for years 2020-2024
Calculate the terminal value in 2024 using the APV method and the WACC method separately
Calculate the value of the levered target firm using the APV method (Hint: since leverage is
expected to change, D*t is not an appropriate way of estimating tax shields — derive tax shields
from the relation between the levered and unlevered values of the ﬁrm)
g. Calculate the value of the levered target firm using the WACC method
b) Calculate the value of synergies:
a. Calculate the cost of assets for the acquirer using CAPM
b. Calculate the cost of equity (levered equity return) for the acquirer
c. Calculate the weighted average cost of capital (WACC) for the acquirer
d. Estimate free cash flow (FCF) from synergies for years 2020-2024 using beta and growth rate of
the acquirer
e. Calculate the terminal value of synergies in 2024 using the APV method and the WACC method separately
f mmmdmmwmmeMMmemmmmmmm The??? Problem 2 - Firm Valuation and M&amp;A (50 Marks) {Please use an Excel Spreadsheet to solve this problem. ) You are the CFO of GreatFood, a large chain of grocery stores. It is the first week in December, and you are
planning to expand your business by acquiring the GoodWine winery that has recently been put up for sale by the
owners. You think that this acquisition may turn out to be a good investment so you want to have solid financial
background for the deal to present at the upcoming Shareholders Meeting in late December 2019. You have the
following information about the GoodWine winery (the &quot;Target&quot;) and your ﬁrm (the &quot;Acquirer&quot;). GoodWine wineg (&quot;Target&quot;) Some important accounting numbers projected for the next 5 years are as follows (all numbers are before-tax, as
of the end of the fiscal year and in S thousands): 2020 2021 2022 2023 2024
Sales 2327.0 2863.0 2984.0 3447.0 3743.0
EBITDA 581.8 715.8 746.0 861.8 935.8
Capital expenditures 500.0 350.0 200.0 180.0 150.0
Increase in NWC 50.0 60.0 65.0 70.0 75.0
Depreciation 175.0 180.3 185.7 191.2 197.0 After year 5, the winery's free cash flow (FCF) will grow at an annual rate of 3% into perpetuity. There are 200
thousand shares outstanding. The market value of equity is currently \$3,500 thousand and the market value of
outstanding debt is \$450 thousand (assume that the share price, the value of equity, and the value of debt are
given at the valuation date, i.e. end of December, 2019). The firm faces the (marginal) tax rate of 40%. The asset
beta of the target (the beta of the same but all-equity firm) is 1.15. GreatFood (Acguirer) The acquirer expects to have the following estimated synergies from the M&amp;A and all figures are before-tax, as of
the end of the fiscal year and in \$ thousands: Synergies 2020 2021 2022 2023 2024 EBITDA 134.0 150.0 171.0 216.0 223.0 After year 5, the free cash flow (FCF) from synergies will grow at an annual rate of 2% into perpetuity. The firm
faces the (marginal) tax rate of 40%. The asset beta of the acquirer (the beta of the same but all-equity firm) is
0.8. Note: The ﬁscal years of both your ﬁrm and the target end on December 31 (l. e. all projected numbers are given at
the end of the ﬁscal year starting from exactly one year from the date of valuation}. Page 3 of 5

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents
• ### -

Question & Answers

Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

Ask a Question