1 -Overview part 1
2 -Overview part 2
3 -Transaction assumptions
4 -Debt assumptions part 1
5 -Debt assumptions part 2
6 -Sources & uses
7 -Populating the Historical Values
8 -Revenue Build up part 1
9 -Revenue build up part 2
10 -Revenue build up part 3 final
11 -Cost sheet calculations
12 -Working Capital Management
13 -Ratios and Assumptions part 1
14 -Ratios and Assumptions part 2
15 -Capex-Base Equation
16 -Calculating depreciation part 1
17 -Calculating depreciation part 2
18 -Amortization schedule
19 -Linking the income statement
20 -Linking the balance sheet
21 -Linking the cash flow statement
22 -Shareholders equity schedule
23 -Debt schedule part 1
24 -Debt schedule part 2
25 -Debt schedule part 3
26 -Debt schedule part 4
27 -Completing the missing links
28 -calculating IRR part 1
29 -calculating IRR part 2
30 -Sensitivity analysis part 1
31 -Reference File.zip
31 -Sensitivity analysis part 2