Financial Analysis Excel Templates 企业估值模板-lboval(2)

49

MERGER LBO VALUATION WORKSHEET

49

RESULTS OF THE MERGER/LBO ANALYSIS

P

V of CF Equity Investors All Investors $1,974 $9,148

Investment $1,000 $6,200

Decision ACCEPT THE DEAL ACCEPT THE DEAL

Cashflow to Equity Investors Average FCFE = Maximum FCFE = Minimum FCFE= Std. Deviation of FCFE= $164 $529 ($147) $214

Leverage D/E Ratio before LBO = D/E Ratio after LBO = D/E Ratio in year 5= D/E Ratio in year 10 = 40.89% 520.00% 190.29% 24.09%

Beta Beta before LBO = Beta after LBO = Beta in year 10 = 1.05 3.47 0.96

RESULTS OF THE MERGER/LBO ANALYSIS

50

MERGER LBO VALUATION WORKSHEET

50

10

0.00% 20.00%

After yr 10 8.00% 8.00% 8.00% 16.00%

51

MERGER LBO VALUATION WORKSHEET

51

85.68%

Term Year$30,554$26,179$1,650$2,725$204$0$0$0$2,521$1,009$1,513$1,650$3,163$1,338$362$0$0$0$0$0$0$1,462

$0$122$0$1,585

54

MERGER LBO VALUATION WORKSHEET

54

Term Year $1,700 $0 $0 $0 $0 $7,057 24.09% 19.41% 0.00%

0.96 16.20% 12.00% 14.45%