Sampa Video
Sampa Video
Sampa Video
t=0
t=1
t=2
t=3
t=4
6,000,000
6,000,000
6,000,000
6,000,000
(2,000,000)
(2,000,000)
(2,000,000)
(2,000,000)
Deprec.
2,000,000
2,000,000
2,000,000
2,000,000
OP CF
3,500,000
3,500,000
3,500,000
3,500,000
Initial invest.
(total cost)
(8,000,000)
Inc. rev.
Inc. cost
NOP CF
3,000,000
Project CF
(8,000,000)
Financing
8,000,000
Interest (AT)
3,500,000
3,500,000
3,500,000
6,500,000
(360,000)
(360,000)
(360,000)
(360,000)
Repay.
Fin. Rel. CF
Total CF
(8,000,000)
8,000,000
(360,000)
(360,000)
(360,000)
(8,360,000)
3,140,000
3,140,000
3,140,000
(1,860,000)
Assuming that financing totally comes from debt, and the before-tax
cost of capital is 6%, tax rate 25%, so the after-tax cost of capital 4.5%.
Project CF
NPV (at 4.5%)
t=0
t=1
t=2
t=3
t=4
(8,000,000)
3,500,000
3,500,000
3,500,000
6,500,000
7,072,024
t=0
Total CF
t=2
t=3
t=4
3,140,000
3,140,000
3,140,000
(1,860,000)
7,072,024
t=0
t=1
t=2
(t=3
8,000,000
(360,000)
(360,000)
(360,000)
Fin. Rel. CF
NPV (at 4.5%)
t=1
t=4
(8,360,000)
Valuation Methods
Adjusted Present Value (APV) Approach
EBIT (1 t ) tk D D
VL
Vu tD
k su
kD
WACC approach
VL = CFL / WACC
EBIT (1 t ) tk D D
VL
Vu tD
k su
kD
Asset Beta
Risk free rate
Market risk premium
Asset Return
1.50
5.0%
7.2%
15.8%
2003E
Free CF
-112.0
Discount Rate 15.8%
Discount Factor 0.864
Present Value
-96.7
TV=495(1+5%)/(15.8%-5%) = 4812.5
Total PV of FCF
Less: Initial Investment
Net Present Value
6.0
15.8%
0.746
4.5
2004E
2005E
151.0
15.8%
0.644
97.2
314.0
15.8%
0.556
174.6
2728.5
1500.0
1228.5
2006E
495.0
15.8%
0.480
237.7
TV
4812.5
0.480
2311.1
levered firm
SD
SD
a
Debt beta
[E] from Exhibit 2
0.25
Debt percentage
[F] from questions
25%
Debt Return
[G] = [B] + [F] * [C]
6.8%
Debt beta contribution [H] = [E] * [F]
0.06
Equity beta
[I] = ([A] - [H]) / [J]
1.92
Equity percentage
[J] = 1 - [F]
75%
Equity Return
[K] = [B] + [I] * [C]
18.8%
Equity beta contribution [L] = [I] * [J]
1.44
Asset beta
[M] = [H] + [L] = [A]
1.50
Tax Rate
[N] from Exhibit 2
40%
WACC
[O] = (1-[N]) * [F] * [G] + [J] * [K]
15.1%
2003E
Free CF
-112.0
Discount Rate 15.1%
Discount Factor 0.869
Present Value
-96.7
TV=495(1+5%)/(15.1%-5%) =5135.9
Total PV of FCF
Less: Initial Investment
Net Present Value
6.0
15.1%
0.755
4.5
2004E
2005E
151.0
15.1%
0.655
97.2
314.0
15.1%
0.569
174.6
2970.0
1500.0
1470.0
2006E
495.0
15.1%
0.495
237.7
TV
5135.9
0.495
2311.1
2002E
2003E
2004E
PV of Future FCF
2970.0
Debt at 25% of Value
742.5
Debt Rate
6.80%
6.80%
Tax Rate
40%
40%
Interest tax shield
20.2
2005E
2006E
TV
3531.0
4058.9
4521.6
882.8
1014.7
1130.4
6.80%
6.80%
6.80%
40%
40%
40%
24.0
27.6
30.7
Free CF
-112.0
Interest tax shield
Capital Cash Flow
6.0
20.2
-91.8
151.0
24.0
30.0
314.0
27.6
178.6
495.0
30.7
344.7
5135.9
33.3
528.3
Discount Rate
Discount Factor
Present Value
15.8%
0.864
-79.3
15.8%
0.746
22.4
15.8%
0.644
115.0
15.8%
0.556
191.7
15.8%
0.480
253.7
TV=495(1+5%)/(15.1%-5%) =5135.9
Total PV of FCF
2970.0
Less: Initial Investment 1500.0
Net Present Value
1470.0
4891.3
1222.8
33.3
5135.9
0.480
2466.4