Carlson Airlines
Case 32
Merger Analysis and Cash Flow
Purpose: The case demonstrates the use of capital budgeting techniques in a merger analysis. There are
a number of tax implications the student must consider. The student will also evaluate the impact of
terminal value on the analysis. This factor is frequently omitted in cases of this nature. The importance
of the growth rate is demonstrated as are the overall dimensions of the merger analysis.
Relation to Text: The case should follow Chapter 20.
Complexity: The case is of moderate difficulty and should require 45 minutes.
Solutions
1.
Depreciation Expense
Earnings before Taxes
5,560,000
Taxes (30%)
1,668,000
Earnings after Taxes
Plus Depreciation
4,400,000
Cash Flow
$8,292,000
2.
5
13,047,621
6
14,613,335
7
16,366,935
8
18,330,967
9
20,530,683
10
22,994,364
3.
Year
Projected
Cash Flow
10%
Discount
Rate
Present Value
1
8,292,000
.909
$7,537,428
2
9,287,040
.826
7,671,095
3
10,401,484
.751
7,811,514
4
11,649,662
.683
7,956,719
5
13,047,621
.621
8,102,573
6
14,613,335
.564
8,241,921
7
16,366,935
.513
8,396,238
8
18,330,967
.467
8,560,562
9
20,530,683
.424
8,705,001
10
22,994,364
.386
8,875,825
Sales
$33,000,000
Cost of Goods Sold
19,440,000
Gross Profit
13,560,000
Selling and Administrative Expense
3,600,000
Year
Projected Cash Floor (12% Growth)
2
9,287,040
3
10,401,484
4
11,649,662
4. Sales Price $140,000,000
5. Total Proceeds
Sum of Present Value $81,858,876
PV of A/T Sales Proceeds 45,934,000
Total Proceeds $127,792,876