ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Quality Textile Mills
2
Acquisition Analysis Workings
3
Table of Contents
4
Excel Worksheet Board Report ReferenceDescription
5
1a(i) QTM AssumptionsAppendix AAssumptions used for the QTM business valuation
6
1a(ii) QTM PL ForecastAppendix BQTM profit and loss forecast incorporated into business valuation
7
1a(iii) QTM FCFAppendix CQTM free cash flow workings and reconciliation to NPAT
8
1a(iv) QTM Terminal ValueAppendix DQTM terminal value calculation
9
1a(v) QTM Equity Value DetailedAppendix EDetailed equity value workings
10
1a(vi) QTM Enterprise ValueAppendix FEnterprise value and implied goodwill calculations
11
1a(vii) QTM Value ConclusionValue conclusion of QTM
12
1a(viii) QTM Implied EBITDAAppendix GValidation of concluded value with similiar market comparators
13
2a(i) RH Debt CapacityRH cash and debt capacity workings
14
2a(ii) RH CAPEX Option 1 Replacement of QTM key plant and equipment at Y4 - NPV calculations
15
2a(iii) RH CAPEX Option 2Replacement of QTM key plant and equipment at Y1 - NPV calculations
16
3a) Sensitivity AnalysisQTM equity value with different sensitivities for revenue, gross margin, working capital and salary costs
17
3b) 10% Loss in Sales Workings to determine the decrease in G&A expenses required if 10% loss of sales occur in Y1
18
3c) WACC SensitivityData table calculating the QTM equity value at different WACC rates
19
4) Risk MatrixQTM residual risk matrix
20
QTM Profit and LossStatement of Profit and Loss provided by QTM
21
QTM Financial PositionStatement of Financial Position provided by QTM
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100