《M16-01-LBOModel（英文）企业并购财务模型工作底稿》由会员分享，可在线阅读，更多相关《M16-01-LBOModel（英文）企业并购财务模型工作底稿（5页珍藏版）》请在金锄头文库上搜索。
1、6 5 1,800,000%462,766 62,000 134,931 105,426 73,265 38,21000,766 327,835 357,341 389,501 424,556,499,234 1,171,398 814,058 424,556 006%0 0 0 0 0 0 0 0 0 0 0 0 0 62,000 134,931 105,426 73,265 38,21000,766 327,835 357,341 389,501 424,556,499,234 1,171,398 814,058 424,556 0,800,000 1,499,234 1,171,398
2、814,058 424,556% 6 650,000%0% ,400,000% of 20% 50,000 650,000 650,000 650,000 650,000 - 162,000 134,931 105,426 73,265 38,210 88,000 515,069 544,574 576,735 611,790 - 95,200 206,028 217,830 230,694 244,716 92,800 309,041 326,744 346,041 367,074 + 80,000 480,000 480,000 480,000 480,000 772,800 789,04
3、1 806,744 826,041 847,074 - 300,766 327,835 357,341 389,501 424,556 to 72,034 461,206 449,404 436,540 422,518 * 6 6 of 00,000of to % 6 - 472,034 933,240 1,382,643 1,819,183 2,241,701 ,000 1,000 1,000 1,000 1,000 1,000 ,000 473,034 934,240 1,383,643 1,820,183 2,242,701 9,000 99,000 99,000 99,000 99,0
4、00 99,000 ,400,000 2,400,000 2,400,000 2,400,000 2,400,000 2,400,000 00,000 980,000 1,460,000 1,940,000 2,420,000 2,900,000 ,900,000 1,420,000 940,000 460,000 (20,000) (500,000) ,000,000 1,992,034 1,973,240 1,942,643 1,899,183 1,841,701 ,800,000 1,499,234 1,171,398 814,058 424,556 - 00,000 492,800 8
5、01,841 1,128,586 1,474,627 1,841,701 ,000,000 1,992,034 1,973,239 1,942,644 1,899,183 1,841,701 % 0% 75% 59% 42% 22% 0%00,000 492,800 801,841 1,128,586 1,474,627 92,800 309,041 326,744 346,041 367,074 92,800 801,841 1,128,586 1,474,627 1,841,701 92,800 309,041 326,744 346,041 367,074 80,000 480,000
6、480,000 480,000 480,000 772,800 789,041 806,744 826,041 847,074 00,766 327,835 357,341 389,501 424,556 472,034 461,206 449,404 436,540 422,518 472,034 933,240 1,382,643 1,819,183 72,034 933,240 1,382,643 1,819,183 2,241,701 of on to 0,841,701* be (x (1 + 36 1. 1,000 473,034 934,240 1,383,643 1,820,1
7、83 2,242,701 2. 300,766 327,835 357,341 389,501 424,556 - 3. (1) - (2) (299,766) 145,198 576,899 994,142 1,395,627 2,242,701 4. D(3) 444,965 431,701 417,243 401,485 847,074 * in 661 2 3 4 550,000 650,000 650,000 650,000 650,000 i) 162,000 134,931 105,426 73,265 38,210 1 2 3 4 51. 390,000 390,000 390,000 390,000 390,000 2. + 80,000 480,000 480,000 480,000 480,000 3. 0 0 0 0 4. orkin
