Question

In: Finance

6. The table below shows the projected free cash flows of an acquisition target. Estimate the...

6. The table below shows the projected free cash flows of an acquisition target. Estimate the following:

a) Terminal value at the end of 2025 based on the perpetual growth equation with a 4% perpetual growth rate

b) Maximum acquisition price (MAP) as of the end of 2020 at a 9% discount rate

YEAR                                                               2021    2022   2023   2024   2025
FREE CASH FLOW ($ thousands)                  -$500      $83    $87    $89     $92

The Present Value of $1 Table (Table 3) tells us:

Period (n)        Present Value Factor at 9% Discount Rate
1                                                          .917
2                                                          .842
3                                                          .772
4                                                         .708
5                                                          .650

Solutions

Expert Solution

(a)-The terminal value at the end of 2025

Terminal value at the end of 2025 = FCF2025(1 + g) / (Ke- g)

= $92,000(1 + 0.04) / (0.09 – 0.04)

= $95,680 / 0.05

= $1,913,600

(b)-The Maximum acquisition price (MAP) as of the end of 2020 at a 9% discount rate

The Maximum acquisition price (MAP) is the Present Value of the future cash flows plus the present value of the Terminal flow

Year

Annual cash flows ($)

Present Value Factor (PVF) at 9.00%

Present Value of annual cash flows ($)

[Annual cash flow x PVF]

1

(500,000)

0.917

(458,500)

2

83,000

0.842

69,886

3

87,000

0.772

67,164

4

89,000

0.708

63,012

5

92,000

0.650

59,800

5

1,913,600

0.650

1,243,840

TOTAL

1,045,202

Therefore, the Maximum acquisition price (MAP) will be $1,045,202

NOTE    

The Formula for calculating the Present Value Factor is [1/(1 + r)n], Where “r” is the Discount/Interest Rate and “n” is the number of years.


Related Solutions

Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations...
Horizon Value of Free Cash Flows Current and projected free cash flows for Radell Global Operations are shown below. Actual 2016 2017 Projected 2018 2019 Free cash flow $602.40 $663.08 $703.13 $759.38 (millions of dollars) Growth is expected to be constant after 2018, and the weighted average cost of capital is 11.55%. What is the horizon (continuing) value at 2019 if growth from 2018 remains constant? Round your answer to the nearest dollar. Round intermediate calculations to two decimal places.
The table below shows Cash flows to the Equity. WACC = 10%, and the cost of...
The table below shows Cash flows to the Equity. WACC = 10%, and the cost of equity = 12%. What is the NPV and IRR of this project? Year FCFE 0 -20000000 1 10000000 2 8000000 3 7000000
Rate of Return Analysis: The table below shows the cash flows associated with a certain investment....
Rate of Return Analysis: The table below shows the cash flows associated with a certain investment. (a) How many possible rates of return are there for this set of cash flows? (b) Find all the rate of return values for these cash flows between 0% and 100%. Please, explain and show solution procedures. Year                              0                    1                2               3                4                  5                   6 Cash Flow ($)         15,000          -30,000         1500          6000          6000          6000            6000
A company is projected to generate free cash flows of $100 million per year for the...
A company is projected to generate free cash flows of $100 million per year for the next 3 years (FCFF1, FCFF2 and FCFF3). Thereafter, the cash flows are expected to grow at a 3.0% rate in perpetuity. The company's cost of capital is 7.0%. What is your estimate for its enterprise value? Answer in millions, rounded to one decimal place (e.g., $213,456,789 = 213.5).
A company is projected to generate free cash flows of $164 million per year for the...
A company is projected to generate free cash flows of $164 million per year for the next 3 years (FCFF1, FCFF2 and FCFF3). Thereafter, the cash flows are expected to grow at a 2.0% rate in perpetuity. The company's cost of capital is 10.2%. What is your estimate for its enterprise value? Answer in millions, rounded to one decimal place (e.g., $213,456,789 = 213.5).
A company is projected to generate free cash flows of $47 million per year for the...
A company is projected to generate free cash flows of $47 million per year for the next two years, after which it is projected grow at a steady rate in perpetuity. The company's cost of capital is 11.2%. It has $24 million worth of debt and $6 million of cash. There are 14 million shares outstanding. If the exit multiple for this company's free cash flows (EV/FCFF) is 14, what's your estimate of the company's stock price? Round to one...
Company is projected to generate free cash flows of $179 million per year for the next...
Company is projected to generate free cash flows of $179 million per year for the next 3 years (FCFF1, FCFF2 and FCFF3). Thereafter, the cash flows are expected to grow at a 1.8% rate in perpetuity. The company's cost of capital is 10.9%. What is your estimate for its enterprise value? Answer in millions, rounded to one decimal place
A company is projected to generate free cash flows of $178 million next year and $191...
A company is projected to generate free cash flows of $178 million next year and $191 million at the end of year 2, after which it is projected grow at a steady rate in perpetuity. The company's cost of capital is 13.6%. It has $107 million worth of debt and $77 million of cash. There are 21 million shares outstanding. If the exit multiple for this company's free cash flows (EV/FCFF) is 7.7, what's your estimate of the company's stock...
A company is projected to generate free cash flows of $171 million next year and $196...
A company is projected to generate free cash flows of $171 million next year and $196 million at the end of year 2, after which it is projected grow at a steady rate in perpetuity. The company’s cost of capital is 12.3%. It has $129 million worth of debt and $69 million of cash. There are 23 million shares outstanding. If the exit multiple for this company’s free cash flows (EV/FCFF) is 6.9, what’s your estimate of the company’s stock...
1.A. A company is projected to generate free cash flows of $800 million per year for...
1.A. A company is projected to generate free cash flows of $800 million per year for the next 3 years (FCFF1, FCFF2 and FCFF3). Thereafter, the cash flows are expected to grow at a 1.5% rate in perpetuity. The company's cost of capital is 12.0%. The company owes $100 million to lenders and has $90 million in cash. If it has 150 million shares outstanding, what is your estimate for its stock price? Round to one decimal place 1.B. A...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT