Best Practice Modelling

Consolidation Example
Go to Table of Contents

Primary Developer: Best Practice Modelling

Cover Notes:
1 The modules within this workbook have been sourced from the following module suite:
Business Planning (Small Business)
2 Download this module suite to access additional modules for insertion into this workbook.
3 This workbook has the following key properties:
- Genre/industry: General Business Planning
- Region: United States
- Category: Small Business
- Time series: Annual
4 Use the Project Manager (Modules tab, Project Manager button) to explore this workbook.
Table of Contents
Consolidation Example
Go to Cover Sheet

Section & Sheet Titles Page

1 Assumptions 5
a. Time Series - Assumptions 6
b. Consol Opening Balance Sheet 7
c. Operational 10
- Co. A - Revenue - Assumptions -
- Co. A - COGS - Assumptions -
- Co. A - Salaries - Assumptions -
- Co. A - Opex - Assumptions -
- Co. B - Revenue - Assumptions -
- Co. B - COGS - Assumptions -
- Co. B - Salaries - Assumptions -
- Co. B - Opex - Assumptions -
- Consol Capex - Assumptions -
- Consol Intangibles Capex - Assumptions -
d. Working Capital 19
- Consol Debtors - Assumptions -
- Consol Inventory - Assumptions -
- Consol Creditors - Assumptions -
e. Assets 25
- Consol Book Assets - Assumptions -
- Consol Book Intangibles - Assumptions -
f. Assets 27
- Consol Book Assets - Capital Expenditure Assumptions -
- Consol Book Intangibles - Capital Expenditure Assumptions -
g. Capital 29
- Consol Debt - Assumptions -
- Consol Ordinary Equity - Assumptions -
h. Consol Taxation - Assumptions 32
i. Other Financial Statement Items 35
- Co. A - Other Income Statement Items - Assumptions -
- Co. B - Other Income Statement Items - Assumptions -
- Consol Interest on Cash - Assumptions -
- Consol Other Balance Sheet - Assumptions -
2 Outputs 42
a. Consol Income Statement 43
b. Financial Statements 44
Table of Contents
Consolidation Example
Go to Cover Sheet

Section & Sheet Titles Page

- Co. A - EBITDA Statement -

- Co. B - EBITDA Statement -
c. Consol Balance Sheet 45
d. Consol Cash Flow Statement 47
e. Operational 49
- Co. A - Revenue - Outputs -
- Co. A - COGS - Outputs -
- Co. A - Salaries - Outputs -
- Co. A - Opex - Outputs -
- Co. B - Revenue - Outputs -
- Co. B - COGS - Outputs -
- Co. B - Salaries - Outputs -
- Co. B - Opex - Outputs -
- Consol Capex - Outputs -
- Consol Intangibles Capex - Outputs -
f. Working Capital 66
- Consol Debtors - Summary -
- Consol Inventory - Summary -
- Consol Creditors - Summary -
- Consol Debtors - Schedules -
- Consol Inventory - Schedules -
- Consol Creditors - Schedules -
g. Assets 75
- Consol Book Assets - Summary -
- Consol Book Intangibles - Summary -
- Consol Book Assets - Schedules -
- Consol Book Intangibles - Schedules -
h. Capital 81
- Consol Debt - Summary -
- Consol Ordinary Equity - Outputs -
- Consol Debt - Schedules -
i. Consol Taxation - Outputs 86
j. Other Financial Statement Items 89
- Co. A - Other Income Statement Items - Summary -
- Co. A - Other Income Statement Items - Schedules -
- Co. B - Other Income Statement Items - Summary -
- Co. B - Other Income Statement Items - Schedules -
- Consol Interest on Cash - Outputs -
Table of Contents
Consolidation Example
Go to Cover Sheet

Section & Sheet Titles Page

- Consol Other Balance Sheet - Summary -

- Consol Other Balance Sheet - Schedules -
3 Presentation Outputs 100
a. Financial Statements Summary 101
4 Appendices 102
4.1. Lookup Tables 103
a. Time Series - Lookups 104
b. Working Capital 107
- Consol Debtors - Lookups -
- Consol Inventory - Lookups -
- Consol Creditors - Lookups -
c. Assets 110
- Consol Book Assets - Lookups -
- Consol Book Intangibles - Lookups -
d. Consol Ordinary Equity - Lookups 112
e. Other Financial Statement Items 113
- Co. A - Other Income Statement Items - Lookups -
- Co. B - Other Income Statement Items - Lookups -
- Consol Other Balance Sheet - Lookups -
f. Consol Financial Summary - Lookups 115
4.2. Checks 116
a. Checks 117
- Error Checks -
- Sensitivity Checks -
- Alert Checks -

Total Pages: 120

 Assumptions
Section 1.
Consolidation Example
Go to Table of Contents
çè

Section Cover Notes:

Contains the model assumptions.

403447950.xlsx
Ass_SC Page 5 of 117
Printed: 07:25:12 on 12/01/2018
Time Series - Assumptions
Consolidation Example
Go to Table of Contents
çè xhO

Time Series - Assumptions

Primary Periodicity Annual

Financial Year End 12

First Financial Year 2014

Term (Years) 5

Denomination $ 2

403447950.xlsx
TS_BA Page 6 of 117
Printed: 07:25:12 on 12/01/2018
Consol Opening Balance Sheet
Consolidation Example
Go to Table of Contents
çè xhO

Consol Opening Balance Sheet 1-Jan-14

✘1 Automatically balance opening balance sheet using retained profits?

Retained Profits / (Losses) - Not Currently Applied -

Current Assets

Cash 6,329.0
Trade Debtors Category 1 94.4
Trade Debtors Category 2 62.1
Trade Debtors Category 3 66.4
Trade Debtors 223.0
Inventory Category 1 62.4
Inventory Category 2 2.7
Inventory Category 3 93.3
Inventory 158.3
Other Current Asset 1 61.5
Other Current Asset 2 45.5
Other Current Asset 3 56.1
Other Current Assets 163.2

Total Current Assets 6,873.4

Non-Current Assets

Book Assets Category 1 76.4

Book Assets Category 2 76.8
Book Assets Category 3 2.6
Book Assets 155.8
Book Intangibles Category 1 2.6
Book Intangibles Category 2 31.6
Book Intangibles Category 3 49.0
Book Intangibles 83.3
Other Non-Current Asset 1 47.5
Other Non-Current Asset 2 48.0

403447950.xlsx
OBS_BA Page 7 of 117
Printed: 07:25:12 on 12/01/2018
Consol Opening Balance Sheet
Consolidation Example
Go to Table of Contents
çè xhO
Other Non-Current Asset 3 19.6
Other Non-Current Assets 115.1

Total Non-Current Assets 354.2

Total Assets 7,227.6

Current Liabilities

Trade Creditors Category 1 6.2

Trade Creditors Category 2 80.8
Trade Creditors Category 3 19.6
Trade Creditors 106.5

Corporate Tax Payable 39.3

Debt Category 1 1.2

Debt Category 2 71.2
Debt Category 3 3.7
Debt Interest Payable 76.1

Ordinary Equity Dividends Payable 60.3

Other Current Liability 1 56.4
Other Current Liability 2 9.8
Other Current Liability 3 41.4
Other Current Liabilities 107.5

Total Current Liabilities 389.7

Non-Current Liabilities

Debt Category 1 26.7

Debt Category 2 37.1
Debt Category 3 98.8
Debt 162.6
Other Non-Current Liability 1 87.6
Other Non-Current Liability 2 28.9
Other Non-Current Liability 3 0.8
Other Non-Current Liabilities 117.4

Total Non-Current Liabilities 280.0

403447950.xlsx
OBS_BA Page 8 of 117
Printed: 07:25:12 on 12/01/2018
Consol Opening Balance Sheet
Consolidation Example
Go to Table of Contents
çè xhO
Total Liabilities 669.7

Net Assets 6,557.9

Ordinary Equity 23.7

Other Equity Category 1 66.6
Other Equity Category 2 27.3
Other Equity Category 3 98.2
Other Equity 192.1

Retained Profits 6,342.0

Total Equity 6,557.9

Error Check -
Alert Check (Negative Cash) -

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Assets, liabilities and equity assumptions are entered as positive numbers.

403447950.xlsx
OBS_BA Page 9 of 117
Printed: 07:25:12 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Revenue - Assumptions

Categories
Co. A - Revenue Category 1 182.2 396.1 401.2 913.4 135.9
Co. A - Revenue Category 2 945.3 254.9 147.6 503.8 88.5
Co. A - Revenue Category 3 382.1 359.9 261.8 903.3 921.6
Total Revenue 1,509.7 1,010.9 810.5 2,320.5 1,146.0

Go to Co. A - Revenue - Outputs

Notes
. Revenue assumptions are entered in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TA Page 10 of 117
Printed: 07:25:12 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - COGS - Assumptions

Categories
Co. A - COGS Category 1 57.3 18.9 56.8 22.0 61.4
Co. A - COGS Category 2 57.2 68.6 67.8 42.0 60.4
Co. A - COGS Category 3 79.9 97.5 17.1 26.3 13.4
Total Cost of Goods Sold 194.3 185.0 141.7 90.3 135.2

Go to Co. A - COGS - Outputs

Notes
. Cost of goods sold assumptions are entered in $'000 unless specified otherwise.
. Cost of goods sold assumptions are entered as positive numbers.

403447950.xlsx
Op_Ann_TA Page 11 of 117
Printed: 07:25:12 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Salaries - Assumptions

Average Staff Numbers

Categories Staff Numbers

Co. A - Salaries & Wages Category 1 1.0 1.0 1.0 1.0 1.0
Co. A - Salaries & Wages Category 2 1.0 1.0 1.0 1.0 1.0
Co. A - Salaries & Wages Category 3 1.0 1.0 1.0 1.0 1.0
Average Total Staff 3.0 3.0 3.0 3.0 3.0

Average Annual Base Salaries

Categories $ (Excluding Retirement Contributions)

Co. A - Salaries & Wages Category 1 43,893 52,727 36,020 22,848 60,910
Co. A - Salaries & Wages Category 2 21,073 77,354 99,564 16,245 22,908
Co. A - Salaries & Wages Category 3 33,783 41,155 39,860 64,673 95,087

Average Bonuses

Categories $ (Excluding Retirement Contributions)

Co. A - Salaries & Wages Category 1 6 10 42 40 1
Co. A - Salaries & Wages Category 2 92 88 63 8 55
Co. A - Salaries & Wages Category 3 55 18 21 7 97

Taxes Withheld

Categories Average Personal Tax Rate (%)

Co. A - Salaries & Wages Category 1 2.4% 2.7% 3.7% 2.3% 4.9%
Co. A - Salaries & Wages Category 2 4.5% 7.4% 0.7% 2.1% 7.4%
Co. A - Salaries & Wages Category 3 7.1% 5.1% 0.6% 7.0% 1.2%

Retirement Contributions

Categories Average Contribution (%)

Co. A - Salaries & Wages Category 1 6.38% 0.41% 1.56% 4.26% 4.07%

403447950.xlsx
Op_Ann_TA Page 12 of 117
Printed: 07:25:12 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Salaries & Wages Category 2 7.86% 5.21% 0.81% 2.83% 2.31%
Co. A - Salaries & Wages Category 3 3.06% 4.10% 7.35% 2.66% 8.99%

Go to Co. A - Salaries - Outputs

Notes
. Average annual base salaries and bonuses assumptions are entered in annual $ excluding retirement contributions.
. All other assumptions are entered in $'000 unless specified otherwise.
. Taxes withheld assumptions should take into account marginal tax rates and any applicable additional levies.
. Retirement contributions are added to salaries and bonuses when calculating total salaries and wages.

403447950.xlsx
Op_Ann_TA Page 13 of 117
Printed: 07:25:12 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Opex - Assumptions

Categories
Co. A - Opex Category 1 90.7 93.9 3.9 4.4 28.7
Co. A - Opex Category 2 52.6 56.5 44.5 7.9 62.2
Co. A - Opex Category 3 32.1 91.2 11.2 36.8 62.4
Total Operating Expenditure 175.4 241.6 59.5 49.1 153.3

Go to Co. A - Opex - Outputs

Notes
. Operating expenditure assumptions are entered in $'000 unless specified otherwise.
. Operating expenditure assumptions are entered as positive numbers.

Co. B - Revenue - Assumptions

Categories
Co. B - Revenue Category 1 623.7 60.1 710.0 968.6 491.2
Co. B - Revenue Category 2 112.6 729.7 807.0 621.4 568.7
Co. B - Revenue Category 3 247.6 470.2 747.8 951.5 373.8
Total Revenue 983.9 1,259.9 2,264.8 2,541.5 1,433.6

Go to Co. B - Revenue - Outputs

Notes
. Revenue assumptions are entered in $'000 unless specified otherwise.

Co. B - COGS - Assumptions

Categories
Co. B - COGS Category 1 90.8 65.0 77.8 18.5 90.2
Co. B - COGS Category 2 7.9 84.8 97.0 72.8 69.7
Co. B - COGS Category 3 13.4 47.6 53.8 16.5 65.4

403447950.xlsx
Op_Ann_TA Page 14 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Total Cost of Goods Sold 112.1 197.5 228.6 107.8 225.3

Go to Co. B - COGS - Outputs

Notes
. Cost of goods sold assumptions are entered in $'000 unless specified otherwise.
. Cost of goods sold assumptions are entered as positive numbers.

Co. B - Salaries - Assumptions

Average Staff Numbers

Categories Staff Numbers

Co. B - Salaries & Wages Category 1 1.0 1.0 1.0 1.0 1.0
Co. B - Salaries & Wages Category 2 1.0 1.0 1.0 1.0 1.0
Co. B - Salaries & Wages Category 3 1.0 1.0 1.0 1.0 1.0
Average Total Staff 3.0 3.0 3.0 3.0 3.0

Average Annual Base Salaries

Categories $ (Excluding Retirement Contributions)

Co. B - Salaries & Wages Category 1 94,810 41,307 64,902 9,309 33,342
Co. B - Salaries & Wages Category 2 6,213 81,168 38,411 98,654 36,415
Co. B - Salaries & Wages Category 3 82,906 98,788 50,373 8,352 82,624

Average Bonuses

Categories $ (Excluding Retirement Contributions)

Co. B - Salaries & Wages Category 1 96 52 90 24 98
Co. B - Salaries & Wages Category 2 59 55 48 14 62
Co. B - Salaries & Wages Category 3 82 56 92 15 93

Taxes Withheld

Categories Average Personal Tax Rate (%)

Co. B - Salaries & Wages Category 1 9.9% 3.2% 0.2% 3.1% 5.9%

403447950.xlsx
Op_Ann_TA Page 15 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. B - Salaries & Wages Category 2 9.0% 0.3% 0.2% 7.5% 4.4%
Co. B - Salaries & Wages Category 3 7.8% 4.1% 3.8% 6.1% 7.0%

Retirement Contributions

Categories Average Contribution (%)

Co. B - Salaries & Wages Category 1 1.27% 7.71% 0.34% 3.39% 3.48%
Co. B - Salaries & Wages Category 2 7.61% 6.52% 2.09% 9.28% 7.46%
Co. B - Salaries & Wages Category 3 8.33% 7.71% 7.35% 6.89% 5.19%

Go to Co. B - Salaries - Outputs

Notes
. Average annual base salaries and bonuses assumptions are entered in annual $ excluding retirement contributions.
. All other assumptions are entered in $'000 unless specified otherwise.
. Taxes withheld assumptions should take into account marginal tax rates and any applicable additional levies.
. Retirement contributions are added to salaries and bonuses when calculating total salaries and wages.

Co. B - Opex - Assumptions

Categories
Co. B - Opex Category 1 26.6 22.8 24.7 71.6 93.6
Co. B - Opex Category 2 92.1 12.9 83.1 21.3 17.8
Co. B - Opex Category 3 17.7 21.7 50.2 68.1 23.1
Total Operating Expenditure 136.4 57.5 158.0 161.1 134.5

Go to Co. B - Opex - Outputs

Notes
. Operating expenditure assumptions are entered in $'000 unless specified otherwise.
. Operating expenditure assumptions are entered as positive numbers.

403447950.xlsx
Op_Ann_TA Page 16 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Capex - Assumptions

Categories Amounts
Consol Capex Category 1 85.2 14.4 83.6 87.2 37.1
Consol Capex Category 2 1.3 78.5 25.1 32.0 17.8
Consol Capex Category 3 54.9 53.3 27.5 67.7 39.5
Total Capital Expenditure 141.4 146.2 136.2 186.9 94.4

Go to Consol Capex - Outputs

Notes
. Capital expenditure assumptions are entered in $'000 unless specified otherwise.
. Capital expenditure assumptions are entered as positive numbers.

403447950.xlsx
Op_Ann_TA Page 17 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Intangibles Capex - Assumptions

Categories
Consol Intangibles Capex Category 1 90.9 69.3 36.0 58.1 64.5
Consol Intangibles Capex Category 2 60.4 6.5 3.8 92.5 33.1
Consol Intangibles Capex Category 3 56.4 58.5 75.1 45.5 77.9
Total Intangibles Capital Expe 207.7 134.3 114.9 196.1 175.6

Go to Consol Intangibles Capex - Outputs

Notes
. Intangibles capital expenditure assumptions are entered in $'000 unless specified otherwise.
. Intangibles capital expenditure assumptions are entered as positive numbers.

403447950.xlsx
Op_Ann_TA Page 18 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Debtors - Assumptions

Allocated Revenue

Revenue Categories Allocation

Co. A - Revenue Category 1 1

Co. A - Revenue Category 2 2

Co. A - Revenue Category 3 3

Co. B - Revenue Category 1 1

Co. B - Revenue Category 2 2

Co. B - Revenue Category 3 3

Co. A Other Revenue Category 1

Co. A Other Revenue Category 2

Co. A Other Revenue Category 3

Co. B Other Revenue Category 1

Co. B Other Revenue Category 2

Co. B Other Revenue Category 3

Debtor Days

Categories
Trade Debtors Category 1 7 7 7 7 7
Trade Debtors Category 2 14 14 14 14 14
Trade Debtors Category 3 21 21 21 21 21

Trade Debtors Closing Balances

Categories Opening Closing

Trade Debtors Category 1 94.4 16.0 11.7 24.1 37.8 13.2

403447950.xlsx
WC_Ann_TA Page 19 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Trade Debtors Category 2 62.1 43.9 42.7 41.1 50.4 30.1
Trade Debtors Category 3 66.4 41.9 51.0 62.7 114.9 79.0
Total Trade Debtors 223.0 101.7 105.4 127.9 203.1 122.3

Go to Consol Debtors - Summary

Go to Consol Debtors - Schedules

Notes
. Trade debtors assumptions are entered in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TA Page 20 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Inventory - Assumptions

Allocated Cost of Goods Sold

Cost of Goods Sold CategorAllocation

Co. A - COGS Category 1 1

Co. A - COGS Category 2 2

Co. A - COGS Category 3 3

Co. B - COGS Category 1 1

Co. B - COGS Category 2 2

Co. B - COGS Category 3 3

Inventory Days

Categories
Inventory Category 1 7 7 7 7 7
Inventory Category 2 14 14 14 14 14
Inventory Category 3 21 21 21 21 21

Inventory Closing Balances

Categories Opening Closing

Inventory Category 1 62.4 2.8 1.6 2.6 0.8 2.9
Inventory Category 2 2.7 2.5 5.9 6.3 4.4 5.0
Inventory Category 3 93.3 5.4 8.3 4.1 2.5 4.5
Total Inventory 158.3 10.7 15.8 12.9 7.6 12.4

Go to Consol Inventory - Summary

Go to Consol Inventory - Schedules

Notes
. Inventory assumptions are entered in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TA Page 21 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Creditors - Assumptions

Allocated Expenses

Expense Categories Allocation

Co. A - COGS Category 1 1

Co. A - COGS Category 2 2

Co. A - COGS Category 3 3

Co. B - COGS Category 1 1

Co. B - COGS Category 2 2

Co. B - COGS Category 3 3

Co. A - Opex Category 1 1

Co. A - Opex Category 2 2

Co. A - Opex Category 3 3

Co. B - Opex Category 1 1

Co. B - Opex Category 2 2

Co. B - Opex Category 3 3

Co. A Other Expenses Categor 1

Co. A Other Expenses Categor 2

Co. A Other Expenses Categor 3

Co. B Other Expenses Categor 1

Co. B Other Expenses Categor 2

Co. B Other Expenses Categor 3

Creditor Days

403447950.xlsx
WC_Ann_TA Page 22 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Categories
Trade Creditors Category 1 7 7 7 7 7
Trade Creditors Category 2 14 14 14 14 14
Trade Creditors Category 3 21 21 21 21 21

Trade Creditors Closing Balances

Categories Opening Closing

Trade Creditors Category 1 6.2 5.9 4.6 4.2 4.6 6.4
Trade Creditors Category 2 80.8 12.6 13.2 15.1 9.8 13.2
Trade Creditors Category 3 19.6 9.7 22.1 11.2 14.0 16.8
Total Trade Creditors 106.5 28.2 39.9 30.4 28.4 36.4

Go to Consol Creditors - Summary

Go to Consol Creditors - Schedules

Notes
. Trade creditors assumptions are entered in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TA Page 23 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Consol Book Assets - Assumptions

Depreciation Assumptions Opening Assets Capital Expenditure

Opening
Depreciati
Net Capital Expenditure Depreciati
on
Categories Book Timing on (Years)
(Years)
Value
76.4 3.9 2 7.0
Book Assets Category 1
Book Assets Category 2 76.8 4.7 2 10.0

Book Assets Category 3 2.6 7.7 2 10.0

Go to Consol Book Assets - Capital Expenditure Assumptions

Go to Consol Book Assets - Summary
Go to Consol Book Assets - Schedules

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Depreciation is calculated on a straight-line basis.

403447950.xlsx
Assets_BA Page 24 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Consol Book Intangibles - Assumptions

Amortization Assumptions Opening Intangibles Capital Expenditure

Opening
Net Amortizati Capital Expenditure Amortizati
Categories Book on (Years) Timing on (Years)
Value
2.6 6.6 2 10.0
Book Intangibles Category 1
Book Intangibles Category 2 31.6 2.2 2 4.0

Book Intangibles Category 3 49.0 1.9 2 2.0

Go to Consol Book Intangibles - Capital Expenditure Assumptions

Go to Consol Book Intangibles - Summary
Go to Consol Book Intangibles - Schedules

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Amortization is calculated on a straight-line basis.

403447950.xlsx
Assets_BA Page 25 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Book Assets - Capital Expenditure Assumptions

Capital Expenditure

Categories Amounts
Consol Capex Category 1 85.2 14.4 83.6 87.2 37.1
Consol Capex Category 2 1.3 78.5 25.1 32.0 17.8
Consol Capex Category 3 54.9 53.3 27.5 67.7 39.5
Total Capital Expenditure 141.4 146.2 136.2 186.9 94.4

Capital Expenditure Allocation

Categories Allocation
Consol Capex Category 1 1

Consol Capex Category 2 2

Consol Capex Category 3 3

Go to Consol Book Assets - Assumptions

Go to Consol Book Assets - Summary
Go to Consol Book Assets - Schedules

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Capital expenditure amounts assumptions are entered as positive numbers.

403447950.xlsx
Assets_Ann_TA Page 26 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Book Intangibles - Capital Expenditure Assumptions

Capital Expenditure

Categories Amounts
Consol Intangibles Capex Cat 90.9 69.3 36.0 58.1 64.5
Consol Intangibles Capex Cat 60.4 6.5 3.8 92.5 33.1
Consol Intangibles Capex Cat 56.4 58.5 75.1 45.5 77.9
Total Capital Expenditure 207.7 134.3 114.9 196.1 175.6

Capital Expenditure Allocation

Categories Allocation
Consol Intangibles Capex Cat 1

Consol Intangibles Capex Cat 2

Consol Intangibles Capex Cat 3

Go to Consol Book Intangibles - Assumptions

Go to Consol Book Intangibles - Summary
Go to Consol Book Intangibles - Schedules

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Capital expenditure amounts assumptions are entered as positive numbers.

403447950.xlsx
Assets_Ann_TA Page 27 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Debt - Assumptions

Debt Category 1 Assumptions

Category Name Debt Category 1

Funds Drawn

Opening Balance 26.7 21.3 59.7 80.5 74.7

Drawdowns 14.5 72.2 45.5 32.7 33.1
Repayments 19.9 33.8 24.7 38.5 34.5
Closing Balance 26.7 21.3 59.7 80.5 74.7 73.3

Interest Expense

Opening Interest Payable 1.2

All-In Interest Rate (% p.a.) 5.07% 8.19% 7.74% 9.94% 7.59%

Debt Category 2 Assumptions

Category Name Debt Category 2

Funds Drawn

Opening Balance 37.1 59.0 23.7 19.9 43.1

Drawdowns 56.4 13.4 15.9 29.0 40.8
Repayments 34.5 48.8 19.6 5.8 12.7
Closing Balance 37.1 59.0 23.7 19.9 43.1 71.1

Interest Expense

Opening Interest Payable 71.2

All-In Interest Rate (% p.a.) 1.98% 4.02% 3.95% 9.33% 6.05%

Debt Category 3 Assumptions

403447950.xlsx
CS_Ann_TA Page 28 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Category Name Debt Category 3

Funds Drawn

Opening Balance 98.8 109.8 68.4 73.5 77.0

Drawdowns 29.8 7.2 44.7 34.9 57.6
Repayments 18.8 48.6 39.6 31.4 24.6
Closing Balance 98.8 109.8 68.4 73.5 77.0 110.0

Interest Expense

Opening Interest Payable 3.7

All-In Interest Rate (% p.a.) 7.48% 0.02% 2.92% 0.98% 5.00%

Go to Consol Debt - Summary

Go to Consol Debt - Schedules

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Drawdowns and repayments assumptions are entered as positive amounts.
. Interest expense is assumed to be paid in the same period in which it is incurred.

403447950.xlsx
CS_Ann_TA Page 29 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Ordinary Equity - Assumptions

Ordinary Equity Balances

Opening Balance 23.7 23.2 26.8 22.9 26.1

Equity Raisings 2.9 4.8 0.4 7.8 4.6
Equity Buybacks 3.4 1.2 4.2 4.6 2.2
Closing Balance 23.7 23.2 26.8 22.9 26.1 28.4

Dividends

Opening Dividends Payable 60.3

Dividend Determination Meth 1

Dividend Declaration Period? Yes Yes Yes Yes Yes

Dividend Payout Ratio - % of Net Profit After Tax 7.3% 0.3% 6.2% 1.3% 7.0%
Amounts - Not Applied - - - - -

✘1 Limit dividends to prevent negative cash at bank?

Financial Statements Data

Opening Retained Profits 6,342.0 7,394.7 8,148.7 9,806.9 12,753.1

Net Profit After Tax (NPAT) 1,135.2 756.3 1,768.4 2,983.8 1,324.4
Opening Cash at Bank 6,329.0 7,954.9 8,141.0 10,214.5 13,649.2
Cash Flow Available For Dividends 1,686.2 268.6 2,075.8 3,544.9 683.0

Go to Consol Ordinary Equity - Outputs

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Assumptions are entered as positive amounts.
. Dividends are assumed to be paid in the period after they are declared.

403447950.xlsx
CS_Ann_TA Page 30 of 117
Printed: 07:25:13 on 12/01/2018
Consol Taxation - Assumptions
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

403447950.xlsx
Corp_Tax_Ann_TA Page 31 of 117
Printed: 07:25:13 on 12/01/2018
Consol Taxation - Assumptions
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Taxation - Assumptions

Taxation Rate

Corporate Taxation Rate 40.0%

Opening Tax Position

1-Jan-14
Opening Tax Losses - (Not Tax Effected)
Opening Tax Payable 39.3

Periodic Tax Payable

Net Profit Before Tax

Net Profit Before Tax 1,895.7 1,264.4 2,950.1 4,975.1 2,215.1

Adjustments

Provisions
(Add Back) Provision for Annual Leave - - - - -
(Add Back) Provision for Long Service Leave - - - - -
(Add Back) Retirement Contributions Withheld 5.5 5.9 4.3 3.2 11.6
(Less) Retirement Contributions Paid - - - - -

Other Adjustments
Other Adjustments Category 1 - - - - -
Other Adjustments Category 2 - - - - -
Other Adjustments Category 3 - - - - -
Total Other Adjustments - - - - -

Tax Payment Timing

% Paid in Period Incurred 39.7% 87.8% 76.0% 52.6% 95.9%

% Paid in Subsequent Period 60.3% 12.2% 24.0% 47.5% 4.1%

403447950.xlsx
Corp_Tax_Ann_TA Page 32 of 117
Printed: 07:25:13 on 12/01/2018
Consol Taxation - Assumptions
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Go to Consol Taxation - Outputs

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Opening tax payable is assumed to be paid during the 2014 financial year.
. Provisions adjustments assumptions are entered as positive numbers.
. Taxable profit is assumed to equal net profit before tax adjusted for provisions plus total adjustments in each period.
. Interim and annual tax assessments ignore opening tax payable, even if the first assessment period is not a full assessment period.

403447950.xlsx
Corp_Tax_Ann_TA Page 33 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

403447950.xlsx
OFSI_Ann_TA Page 34 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Other Income Statement Items - Assumptions

Other Revenue

Categories
Co. A Other Revenue Category 1 12.9 74.2 70.0 8.8 41.5
Co. A Other Revenue Category 2 61.0 63.2 29.8 92.2 58.1
Co. A Other Revenue Category 3 23.4 27.2 82.3 51.3 51.3
Total Other Income Items 97.3 164.6 182.1 152.3 150.9

Cash Flow Statement Impacts Impact Type

Co. A Other Revenue Category 1 1

Co. A Other Revenue Category 2 1

Co. A Other Revenue Category 3 1

Other Operating Expenditure

Categories
Co. A Other Expenses Category 1 0.4 33.6 52.9 62.2 39.0
Co. A Other Expenses Category 2 96.7 45.8 62.3 90.6 42.2
Co. A Other Expenses Category 3 7.3 72.9 51.0 31.7 54.9
Total Other Expense Items 104.4 152.3 166.3 184.4 136.1

Cash Flow Statement Impacts Impact Type

Co. A Other Expenses Category 1 2

Co. A Other Expenses Category 2 2

Co. A Other Expenses Category 3 2

Go to Co. A - Other Income Statement Items - Summary

Go to Co. A - Other Income Statement Items - Schedules

Notes

403447950.xlsx
OFSI_Ann_TA Page 35 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

. Assumptions are entered in $'000 unless specified otherwise.
. Revenue and expenses are entered as positive amounts.

Co. B - Other Income Statement Items - Assumptions

Other Revenue

Categories
Co. B Other Revenue Category 1 13.6 77.7 77.5 79.1 20.0
Co. B Other Revenue Category 2 25.5 66.8 90.6 97.1 70.2
Co. B Other Revenue Category 3 74.7 28.8 0.7 91.2 25.6
Total Other Income Items 113.8 173.2 168.8 267.3 115.8

Cash Flow Statement Impacts Impact Type

Co. B Other Revenue Category 1 1

Co. B Other Revenue Category 2 1

Co. B Other Revenue Category 3 1

Other Operating Expenditure

Categories
Co. B Other Expenses Category 1 40.5 6.5 2.5 62.4 22.5
Co. B Other Expenses Category 2 21.5 76.6 39.1 20.0 92.9
Co. B Other Expenses Category 3 18.7 52.7 11.7 64.5 72.2
Total Other Expense Items 80.7 135.8 53.3 146.8 187.5

Cash Flow Statement Impacts Impact Type

Co. B Other Expenses Category 1 2

Co. B Other Expenses Category 2 2

Co. B Other Expenses Category 3 2

Go to Co. B - Other Income Statement Items - Summary

Go to Co. B - Other Income Statement Items - Schedules

403447950.xlsx
OFSI_Ann_TA Page 36 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Revenue and expenses are entered as positive amounts.

Consol Interest on Cash - Assumptions

Cash at Bank

Opening Cash at Bank 6,329.0 7,954.9 8,141.0 10,214.5 13,649.2

Change in Cash (Pre-Corporate Tax & Interest on Cas 1,553.3 875.2 2,177.5 3,874.8 1,521.5
Opening Corporate Tax Payable 39.3 458.6 62.1 283.6 944.9

Interest on Cash

All-In Interest Rate (% p.a.) 5.84% 2.64% 9.31% 7.41% 6.62%

Go to Consol Interest on Cash - Outputs

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Cash at bank, change in cash and corporate tax payable assumptions are entered as positive numbers.
. Interest is calculated based on an estimate of average cash at bank to avoid circularity.

403447950.xlsx
OFSI_Ann_TA Page 37 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Other Balance Sheet - Assumptions

Other Current Assets

Categories Opening Cash Flow Movement

Other Current Asset 1 61.5 82.7 94.0 89.7 53.7 1.7
Other Current Asset 2 45.5 68.9 22.3 59.1 87.4 96.9
Other Current Asset 3 56.1 57.0 94.6 7.4 64.9 94.2

Cash Flow Statement Impacts Impact Type

Other Current Asset 1 3

Other Current Asset 2 3

Other Current Asset 3 3

Other Non-Current Assets

Categories Opening Cash Flow Movement

Other Non-Current Asset 1 47.5 78.4 91.1 38.2 50.1 38.7
Other Non-Current Asset 2 48.0 59.1 22.8 54.7 81.7 3.8
Other Non-Current Asset 3 19.6 34.5 61.6 39.4 81.6 55.9

Cash Flow Statement Impacts Impact Type

Other Non-Current Asset 1 4

Other Non-Current Asset 2 4

Other Non-Current Asset 3 4

Other Current Liabilities

Categories Opening Cash Flow Movement

Other Current Liability 1 56.4 16.8 68.6 10.6 54.7 3.1
Other Current Liability 2 9.8 83.6 53.8 98.7 58.5 17.7
Other Current Liability 3 41.4 14.0 33.5 35.2 77.5 86.7

403447950.xlsx
OFSI_Ann_TA Page 38 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Cash Flow Statement Impacts Impact Type

Other Current Liability 1 2

Other Current Liability 2 2

Other Current Liability 3 2

Other Non-Current Liabilities

Categories Opening Cash Flow Movement

Other Non-Current Liability 1 87.6 79.1 78.9 18.7 75.8 22.3
Other Non-Current Liability 2 28.9 50.4 64.1 47.8 38.3 97.6
Other Non-Current Liability 3 0.8 59.6 19.6 31.4 57.7 36.9

Cash Flow Statement Impacts Impact Type

Other Non-Current Liability 1 5

Other Non-Current Liability 2 5

Other Non-Current Liability 3 5

Other Equity

Categories Opening Cash Flow Movement

Other Equity Category 1 66.6 95.3 45.3 90.1 78.7 88.5
Other Equity Category 2 27.3 43.3 45.8 40.4 37.8 79.3
Other Equity Category 3 98.2 89.4 27.5 85.1 59.1 33.0

Cash Flow Statement Impacts Impact Type

Other Equity Category 1 5

Other Equity Category 2 5

Other Equity Category 3 5

Go to Consol Other Balance Sheet - Summary

Go to Consol Other Balance Sheet - Schedules

403447950.xlsx
OFSI_Ann_TA Page 39 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Notes
. Assumptions are entered in $'000 unless specified otherwise.
. Positive numbers will increase the value of the asset or liability and be treated as cash outflows and inflows respectively

403447950.xlsx
OFSI_Ann_TA Page 40 of 117
Printed: 07:25:13 on 12/01/2018
 Outputs
Section 2.
Consolidation Example
Go to Table of Contents
çè

Section Cover Notes:

Contains the model outputs.

403447950.xlsx
Out_SC Page 41 of 117
Printed: 07:25:13 on 12/01/2018
Consol Income Statement
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Income Statement

Total Revenue 2,493.6 2,270.8 3,075.3 4,862.0 2,579.6

Total Cost of Goods Sold (306.4) (382.4) (370.3) (198.1) (360.5)

Gross Margin 2,187.2 1,888.4 2,705.1 4,663.9 2,219.1

Net Operating Expenses (582.9) (664.1) (424.7) (355.2) (696.2)

EBITDA 1,604.3 1,224.3 2,280.3 4,308.7 1,523.0

Total Depreciation & Amortization (112.4) (170.4) (178.2) (212.1) (216.8)

EBIT 1,491.8 1,053.9 2,102.1 4,096.5 1,306.2

Net Interest Expense 403.9 210.5 848.0 878.6 908.9

Net Profit Before Tax 1,895.7 1,264.4 2,950.1 4,975.1 2,215.1

Tax Expense (760.5) (508.1) (1,181.8) (1,991.3) (890.7)

Net Profit After Tax 1,135.2 756.3 1,768.4 2,983.8 1,324.4

Error Check - - - - - -

Notes
. Figures are stated in $'000 unless specified otherwise.
. Revenues and expenses enter the Income Statement as positive and negative numbers respectively.

403447950.xlsx
IS_Ann_TO Page 42 of 117
Printed: 07:25:13 on 12/01/2018
Financial Statements
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - EBITDA Statement

Total Revenue 1,509.7 1,010.9 810.5 2,320.5 1,146.0

Total Cost of Goods Sold (194.3) (185.0) (141.7) (90.3) (135.2)

Gross Margin 1,315.3 826.0 668.8 2,230.3 1,010.9

403447950.xlsx
FS_Ann_TO Page 43 of 117
Printed: 07:25:13 on 12/01/2018
Consol Balance Sheet
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Balance Sheet

Current Assets

Cash 7,954.9 8,141.0 10,214.5 13,649.2 14,294.7

Trade Debtors 101.7 105.4 127.9 203.1 122.3
Inventory 10.7 15.8 12.9 7.6 12.4
Other Current Assets 371.8 582.7 738.9 944.9 1,137.6
Total Current Assets 8,439.1 8,844.9 11,094.2 14,804.9 15,567.0

Non-Current Assets

Book Assets 252.1 336.7 395.1 485.6 490.6

Book Intangibles 223.6 249.2 263.6 344.0 392.1
Other Non-Current Assets 287.1 462.5 594.7 808.1 906.4
Total Non-Current Assets 762.8 1,048.3 1,253.4 1,637.6 1,789.1

Total Assets 9,201.9 9,893.2 12,347.7 16,442.5 17,356.1

Current Liabilities

Trade Creditors 28.2 39.9 30.4 28.4 36.4

Corporate Tax Payable 458.6 62.1 283.6 944.9 36.8
Debt Interest Payable 76.1 76.1 76.1 76.1 76.1
Ordinary Equity Dividends Payable 82.5 2.3 110.2 37.6 92.4
Other Current Liabilities 221.8 377.8 522.3 713.0 820.4
Total Current Liabilities 867.3 558.2 1,022.6 1,799.9 1,062.2

Non-Current Liabilities

Debt 190.1 151.7 173.9 194.8 254.4

Other Non-Current Liabilities 306.5 469.1 567.0 738.8 895.5
Total Non-Current Liabilities 496.6 620.8 740.9 933.6 1,149.9

Total Liabilities 1,363.8 1,179.0 1,763.5 2,733.5 2,212.1

403447950.xlsx
BS_Ann_TO Page 44 of 117
Printed: 07:25:13 on 12/01/2018
Consol Balance Sheet
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Net Assets 7,838.0 8,714.2 10,584.1 13,709.0 15,144.1

Ordinary Equity 23.2 26.8 22.9 26.1 28.4

Other Equity 420.1 538.7 754.3 929.8 1,130.6
Retained Profits 7,394.7 8,148.7 9,806.9 12,753.1 13,985.1

Total Equity 7,838.0 8,714.2 10,584.1 13,709.0 15,144.1

Total Error Checks Result - - - - - -

Alert Check (Negative Cash) - - - - - -

Notes
. Figures are stated in $'000 unless specified otherwise.
. Assets and liabilities both enter the Balance Sheet as positive numbers.

403447950.xlsx
BS_Ann_TO Page 45 of 117
Printed: 07:25:13 on 12/01/2018
Consol Cash Flow Statement
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Cash Flow Statement

Cash Flow from Operating Activities

Cash Receipts 2,825.9 2,605.0 3,403.7 5,206.4 2,927.1

Cash Payments (916.8) (1,221.8) (1,007.9) (779.0) (1,212.6)
Interest on Cash 413.8 215.5 856.4 890.0 922.7
Debt Interest Paid (10.0) (5.0) (8.4) (11.4) (13.7)
Corporate Tax Paid (341.2) (904.6) (960.3) (1,330.1) (1,798.8)
Other Operating Cash Flows (208.6) (210.9) (156.2) (206.0) (192.8)
Net Cash Flow from Operating Activities 1,763.2 478.1 2,127.3 3,769.8 631.9

Cash Flow from Investing Activities

Book Assets Capital Expenditure (141.4) (146.2) (136.2) (186.9) (94.4)

Book Intangibles Capital Expenditure (207.7) (134.3) (114.9) (196.1) (175.6)
Other Investing Cash Flows (172.0) (175.4) (132.3) (213.4) (98.3)
Net Cash Flow from Investing Activities (521.0) (455.9) (383.3) (596.4) (368.2)

Cash Flow from Financing Activities

Debt Drawdowns 100.7 92.9 106.1 96.5 131.5

Debt Repayments (73.3) (131.3) (83.9) (75.7) (71.8)
Ordinary Equity Raisings 2.9 4.8 0.4 7.8 4.6
Ordinary Equity Buybacks (3.4) (1.2) (4.2) (4.6) (2.2)
Ordinary Equity Dividends Paid (60.3) (82.5) (2.3) (110.2) (37.6)
Other Financing Cash Flows 417.1 281.1 313.5 347.4 357.4
Net Cash Flow from Financing Activities 383.8 163.8 329.6 261.2 381.8

Net Increase/(Decrease) in Cash Held 1,626.0 186.1 2,073.6 3,434.7 645.5

Interest on Cash Breakdown

Net Cash Flow from Investing Activities (521.0) (455.9) (383.3) (596.4) (368.2)
Net Cash Flow from Financing Activities 383.8 163.8 329.6 261.2 381.8

403447950.xlsx
CFS_Ann_TO Page 46 of 117
Printed: 07:25:13 on 12/01/2018
Consol Cash Flow Statement
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Cash Receipts 2,825.9 2,605.0 3,403.7 5,206.4 2,927.1
Cash Payments (916.8) (1,221.8) (1,007.9) (779.0) (1,212.6)
Debt Interest Paid (10.0) (5.0) (8.4) (11.4) (13.7)
Other Operating Cash Flows (208.6) (210.9) (156.2) (206.0) (192.8)
Change in Cash (Pre-Corporate Tax & Interest on Cas 1,553.3 875.2 2,177.5 3,874.8 1,521.5
Corporate Tax Paid (341.2) (904.6) (960.3) (1,330.1) (1,798.8)
Interest on Cash 413.8 215.5 856.4 890.0 922.7
Net Increase/(Decrease) in Cash Held 1,626.0 186.1 2,073.6 3,434.7 645.5

Cash Flow to Capital Providers

Net Cash Flow from Operating Activities 1,763.2 478.1 2,127.3 3,769.8 631.9
Net Cash Flow from Investing Activities (521.0) (455.9) (383.3) (596.4) (368.2)
(Add Back) Debt Interest Paid 10.0 5.0 8.4 11.4 13.7
Cash Flow Available To Capital Providers (CFAC 1,252.2 27.2 1,752.3 3,184.9 277.4
Debt Interest Paid (10.0) (5.0) (8.4) (11.4) (13.7)
Debt Drawdowns 100.7 92.9 106.1 96.5 131.5
Debt Repayments (73.3) (131.3) (83.9) (75.7) (71.8)
Other Financing Cash Flows 417.1 281.1 313.5 347.4 357.4
Cash Flow Available to Equity (CFAE) 1,686.7 265.0 2,079.7 3,541.7 680.7
Ordinary Equity Raisings 2.9 4.8 0.4 7.8 4.6
Ordinary Equity Buybacks (3.4) (1.2) (4.2) (4.6) (2.2)
Cash Flow Available for Dividends (CFAD) 1,686.2 268.6 2,075.8 3,544.9 683.0
Ordinary Equity Dividends Paid (60.3) (82.5) (2.3) (110.2) (37.6)
Net Increase/(Decrease) in Cash Held 1,626.0 186.1 2,073.6 3,434.7 645.5

Total Error Checks Result - - - - - -

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
CFS_Ann_TO Page 47 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Revenue - Outputs

Categories
Co. A - Revenue Category 1 182.2 396.1 401.2 913.4 135.9
Co. A - Revenue Category 2 945.3 254.9 147.6 503.8 88.5
Co. A - Revenue Category 3 382.1 359.9 261.8 903.3 921.6
Total Revenue 1,509.7 1,010.9 810.5 2,320.5 1,146.0

Growth Rates
Co. A - Revenue Category 1 117.4% 1.3% 127.7% (85.1%)
Co. A - Revenue Category 2 (73.0%) (42.1%) 241.4% (82.4%)
Co. A - Revenue Category 3 (5.8%) (27.3%) 245.1% 2.0%
Total Revenue (33.0%) (19.8%) 186.3% (50.6%)

Error Check - - - - - -
Alert Check (Negative Revenue) - - - - - -

Go to Co. A - Revenue - Assumptions

Notes
. Revenue is stated in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TO Page 48 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - COGS - Outputs

Categories
Co. A - COGS Category 1 57.3 18.9 56.8 22.0 61.4
Co. A - COGS Category 2 57.2 68.6 67.8 42.0 60.4
Co. A - COGS Category 3 79.9 97.5 17.1 26.3 13.4
Total Cost of Goods Sold 194.3 185.0 141.7 90.3 135.2

Growth Rates
Co. A - COGS Category 1 (67.0%) 201.1% (61.3%) 179.0%
Co. A - COGS Category 2 20.0% (1.2%) (38.0%) 43.7%
Co. A - COGS Category 3 22.0% (82.5%) 54.1% (49.1%)
Total Cost of Goods Sold (4.8%) (23.4%) (36.3%) 49.7%

Error Check - - - - - -
Alert Check (Negative Cost of Goods Sold) - - - - - -

Go to Co. A - COGS - Assumptions

Notes
. Cost of goods sold is stated in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TO Page 49 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Salaries - Outputs

Total Salaries & Wages

Salaries & Wages (Including Retirement Contributions)

Categories
Co. A - Salaries & Wages Category 1 46.7 53.0 36.6 23.9 63.4
Co. A - Salaries & Wages Category 2 22.8 81.5 100.4 16.7 23.5
Co. A - Salaries & Wages Category 3 34.9 42.9 42.8 66.4 103.7
Total Salaries & Wages 104.4 177.3 179.9 107.0 190.6

Salaries & Wages - Retirement Contributions Withheld

Categories
Co. A - Salaries & Wages Category 1 2.8 0.2 0.6 1.0 2.5
Co. A - Salaries & Wages Category 2 1.7 4.0 0.8 0.5 0.5
Co. A - Salaries & Wages Category 3 1.0 1.7 2.9 1.7 8.6
Total Retirement Contributions Withheld 5.5 5.9 4.3 3.2 11.6

Categories Average Contribution (%)

Co. A - Salaries & Wages Category 1 6.38% 0.41% 1.56% 4.26% 4.07%
Co. A - Salaries & Wages Category 2 7.86% 5.21% 0.81% 2.83% 2.31%
Co. A - Salaries & Wages Category 3 3.06% 4.10% 7.35% 2.66% 8.99%

Salaries & Wages (Excluding Retirement Contributions)

Categories
Co. A - Salaries & Wages Category 1 43.9 52.7 36.1 22.9 60.9
Co. A - Salaries & Wages Category 2 21.2 77.4 99.6 16.3 23.0
Co. A - Salaries & Wages Category 3 33.8 41.2 39.9 64.7 95.2
Total Salaries & Wages 98.9 171.4 175.6 103.8 179.1

Salaries & Wages - Taxes Withheld

Categories

403447950.xlsx
Op_Ann_TO Page 50 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Salaries & Wages Category 1 1.0 1.4 1.3 0.5 3.0
Co. A - Salaries & Wages Category 2 1.0 5.7 0.6 0.3 1.7
Co. A - Salaries & Wages Category 3 2.4 2.1 0.2 4.5 1.1
Total Taxes Withheld 4.4 9.2 2.2 5.4 5.8

Categories Average Personal Tax Rate (%)

Co. A - Salaries & Wages Category 1 2.4% 2.7% 3.7% 2.3% 4.9%
Co. A - Salaries & Wages Category 2 4.5% 7.4% 0.7% 2.1% 7.4%
Co. A - Salaries & Wages Category 3 7.1% 5.1% 0.6% 7.0% 1.2%

Net Salaries & Wages

Categories
Co. A - Salaries & Wages Category 1 42.9 51.3 34.7 22.4 57.9
Co. A - Salaries & Wages Category 2 20.2 71.7 99.0 15.9 21.3
Co. A - Salaries & Wages Category 3 31.4 39.1 39.6 60.2 94.1
Total Net Salaries & Wages 94.5 162.1 173.4 98.4 173.2

Average Staff Numbers

Categories Staff Numbers

Co. A - Salaries & Wages Category 1 1.0 1.0 1.0 1.0 1.0
Co. A - Salaries & Wages Category 2 1.0 1.0 1.0 1.0 1.0
Co. A - Salaries & Wages Category 3 1.0 1.0 1.0 1.0 1.0
Average Total Staff 3.0 3.0 3.0 3.0 3.0

Base Salaries & Wages

Base Salaries & Wages (Including Retirement Contributions)

Categories
Co. A - Salaries & Wages Category 1 46.7 52.9 36.6 23.8 63.4
Co. A - Salaries & Wages Category 2 22.7 81.4 100.4 16.7 23.4
Co. A - Salaries & Wages Category 3 34.8 42.8 42.8 66.4 103.6
Total Base Salaries & Wages 104.2 177.2 179.7 106.9 190.5

Base Salaries & Wages - Retirement Contributions Withheld

Categories

403447950.xlsx
Op_Ann_TO Page 51 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Salaries & Wages Category 1 2.8 0.2 0.6 1.0 2.5
Co. A - Salaries & Wages Category 2 1.7 4.0 0.8 0.5 0.5
Co. A - Salaries & Wages Category 3 1.0 1.7 2.9 1.7 8.5
Total Retirement Contributions Withheld 5.5 5.9 4.3 3.2 11.6

Base Salaries & Wages (Excluding Retirement Contributions)

Categories
Co. A - Salaries & Wages Category 1 43.9 52.7 36.0 22.8 60.9
Co. A - Salaries & Wages Category 2 21.1 77.4 99.6 16.2 22.9
Co. A - Salaries & Wages Category 3 33.8 41.2 39.9 64.7 95.1
Total Base Salaries & Wages 98.7 171.2 175.4 103.8 178.9

Base Salaries & Wages - Taxes Withheld

Categories
Co. A - Salaries & Wages Category 1 1.0 1.4 1.3 0.5 3.0
Co. A - Salaries & Wages Category 2 1.0 5.7 0.6 0.3 1.7
Co. A - Salaries & Wages Category 3 2.4 2.1 0.2 4.5 1.1
Total Taxes Withheld 4.4 9.2 2.2 5.4 5.8

Net Base Salaries & Wages

Categories
Co. A - Salaries & Wages Category 1 42.9 51.3 34.7 22.3 57.9
Co. A - Salaries & Wages Category 2 20.1 71.7 98.9 15.9 21.2
Co. A - Salaries & Wages Category 3 31.4 39.0 39.6 60.2 94.0
Total Base Salaries & Wages 94.4 162.0 173.2 98.4 173.1

Average Annual Base Salaries

Categories $ (Excluding Retirement Contributions)
Co. A - Salaries & Wages Category 1 43,893 52,727 36,020 22,848 60,910
Co. A - Salaries & Wages Category 2 21,073 77,354 99,564 16,245 22,908
Co. A - Salaries & Wages Category 3 33,783 41,155 39,860 64,673 95,087

Bonuses

Bonuses (Including Retirement Contributions)

Categories
Co. A - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0

403447950.xlsx
Op_Ann_TO Page 52 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Salaries & Wages Category 2 0.1 0.1 0.1 0.0 0.1
Co. A - Salaries & Wages Category 3 0.1 0.0 0.0 0.0 0.1
Total Bonuses 0.2 0.1 0.1 0.1 0.2

Bonuses - Retirement Contributions Withheld

Categories
Co. A - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0
Co. A - Salaries & Wages Category 2 0.0 0.0 0.0 0.0 0.0
Co. A - Salaries & Wages Category 3 0.0 0.0 0.0 0.0 0.0
Total Retirement Contributions Withheld 0.0 0.0 0.0 0.0 0.0

Bonuses (Excluding Retirement Contributions)

Categories
Co. A - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0
Co. A - Salaries & Wages Category 2 0.1 0.1 0.1 0.0 0.1
Co. A - Salaries & Wages Category 3 0.1 0.0 0.0 0.0 0.1
Total Bonuses 0.2 0.1 0.1 0.1 0.2

Bonuses - Taxes Withheld

Categories
Co. A - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0
Co. A - Salaries & Wages Category 2 0.0 0.0 0.0 0.0 0.0
Co. A - Salaries & Wages Category 3 0.0 0.0 0.0 0.0 0.0
Total Taxes Withheld 0.0 0.0 0.0 0.0 0.0

Net Bonuses
Categories
Co. A - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0
Co. A - Salaries & Wages Category 2 0.1 0.1 0.1 0.0 0.1
Co. A - Salaries & Wages Category 3 0.1 0.0 0.0 0.0 0.1
Total Bonuses 0.1 0.1 0.1 0.1 0.1

Average Bonuses
Categories $ (Excluding Retirement Contributions)
Co. A - Salaries & Wages Category 1 6 10 42 40 1
Co. A - Salaries & Wages Category 2 92 88 63 8 55
Co. A - Salaries & Wages Category 3 55 18 21 7 97

403447950.xlsx
Op_Ann_TO Page 53 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Salaries & Wages Reconciliation

Total Net Salaries & Wages 94.5 162.1 173.4 98.4 173.2
Total Taxes Withheld 4.4 9.2 2.2 5.4 5.8
Total Retirement Contributions Withheld 5.5 5.9 4.3 3.2 11.6
Total Salaries & Wages 104.4 177.3 179.9 107.0 190.6

Total Error Checks Result - - - - - -

Alert Check (Negative Salaries & Wages) - - - - - -

Go to Co. A - Salaries - Assumptions

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TO Page 54 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Opex - Outputs

Categories
Co. A - Opex Category 1 90.7 93.9 3.9 4.4 28.7
Co. A - Opex Category 2 52.6 56.5 44.5 7.9 62.2
Co. A - Opex Category 3 32.1 91.2 11.2 36.8 62.4
Total Operating Expenditure 175.4 241.6 59.5 49.1 153.3

Growth Rates
Co. A - Opex Category 1 3.6% (95.8%) 13.6% 547.2%
Co. A - Opex Category 2 7.5% (21.3%) (82.3%) 688.7%
Co. A - Opex Category 3 183.8% (87.8%) 229.5% 69.4%
Total Operating Expenditure 37.8% (75.4%) (17.5%) 211.9%

Error Check - - - - - -
Alert Check (Negative Operating Expenditure - - - - - -

Go to Co. A - Opex - Assumptions

Notes
. Operating expenditure is stated in $'000 unless specified otherwise.

Co. B - Revenue - Outputs

Categories
Co. B - Revenue Category 1 623.7 60.1 710.0 968.6 491.2
Co. B - Revenue Category 2 112.6 729.7 807.0 621.4 568.7
Co. B - Revenue Category 3 247.6 470.2 747.8 951.5 373.8
Total Revenue 983.9 1,259.9 2,264.8 2,541.5 1,433.6

Growth Rates
Co. B - Revenue Category 1 (90.4%) 1,082.1% 36.4% (49.3%)
Co. B - Revenue Category 2 548.1% 10.6% (23.0%) (8.5%)
Co. B - Revenue Category 3 89.9% 59.1% 27.2% (60.7%)

403447950.xlsx
Op_Ann_TO Page 55 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Total Revenue 28.1% 79.8% 12.2% (43.6%)

Error Check - - - - - -
Alert Check (Negative Revenue) - - - - - -

Go to Co. B - Revenue - Assumptions

Notes
. Revenue is stated in $'000 unless specified otherwise.

Co. B - COGS - Outputs

Categories
Co. B - COGS Category 1 90.8 65.0 77.8 18.5 90.2
Co. B - COGS Category 2 7.9 84.8 97.0 72.8 69.7
Co. B - COGS Category 3 13.4 47.6 53.8 16.5 65.4
Total Cost of Goods Sold 112.1 197.5 228.6 107.8 225.3

Growth Rates
Co. B - COGS Category 1 (28.4%) 19.6% (76.2%) 387.8%
Co. B - COGS Category 2 972.3% 14.3% (24.9%) (4.2%)
Co. B - COGS Category 3 255.6% 13.0% (69.3%) 296.2%
Total Cost of Goods Sold 76.2% 15.8% (52.8%) 109.0%

Error Check - - - - - -
Alert Check (Negative Cost of Goods Sold) - - - - - -

Go to Co. B - COGS - Assumptions

Notes
. Cost of goods sold is stated in $'000 unless specified otherwise.

Co. B - Salaries - Outputs

Total Salaries & Wages

403447950.xlsx
Op_Ann_TO Page 56 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Salaries & Wages (Including Retirement Contributions)

Categories
Co. B - Salaries & Wages Category 1 96.1 44.5 65.2 9.6 34.6
Co. B - Salaries & Wages Category 2 6.7 86.5 39.3 107.8 39.2
Co. B - Salaries & Wages Category 3 89.9 106.5 54.2 8.9 87.0
Total Salaries & Wages 192.8 237.5 158.6 126.4 160.8

Salaries & Wages - Retirement Contributions Withheld

Categories
Co. B - Salaries & Wages Category 1 1.2 3.2 0.2 0.3 1.2
Co. B - Salaries & Wages Category 2 0.5 5.3 0.8 9.2 2.7
Co. B - Salaries & Wages Category 3 6.9 7.6 3.7 0.6 4.3
Total Retirement Contributions Withheld 8.6 16.1 4.7 10.0 8.2

Categories Average Contribution (%)

Co. B - Salaries & Wages Category 1 1.27% 7.71% 0.34% 3.39% 3.48%
Co. B - Salaries & Wages Category 2 7.61% 6.52% 2.09% 9.28% 7.46%
Co. B - Salaries & Wages Category 3 8.33% 7.71% 7.35% 6.89% 5.19%

Salaries & Wages (Excluding Retirement Contributions)

Categories
Co. B - Salaries & Wages Category 1 94.9 41.4 65.0 9.3 33.4
Co. B - Salaries & Wages Category 2 6.3 81.2 38.5 98.7 36.5
Co. B - Salaries & Wages Category 3 83.0 98.8 50.5 8.4 82.7
Total Salaries & Wages 184.2 221.4 153.9 116.4 152.6

Salaries & Wages - Taxes Withheld

Categories
Co. B - Salaries & Wages Category 1 9.4 1.3 0.1 0.3 2.0
Co. B - Salaries & Wages Category 2 0.6 0.2 0.1 7.4 1.6
Co. B - Salaries & Wages Category 3 6.4 4.1 1.9 0.5 5.8
Total Taxes Withheld 16.4 5.7 2.1 8.2 9.3

403447950.xlsx
Op_Ann_TO Page 57 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Categories Average Personal Tax Rate (%)
Co. B - Salaries & Wages Category 1 9.9% 3.2% 0.2% 3.1% 5.9%
Co. B - Salaries & Wages Category 2 9.0% 0.3% 0.2% 7.5% 4.4%
Co. B - Salaries & Wages Category 3 7.8% 4.1% 3.8% 6.1% 7.0%

Net Salaries & Wages

Categories
Co. B - Salaries & Wages Category 1 85.5 40.0 64.9 9.0 31.5
Co. B - Salaries & Wages Category 2 5.7 81.0 38.4 91.2 34.9
Co. B - Salaries & Wages Category 3 76.5 94.8 48.5 7.9 77.0
Total Net Salaries & Wages 167.8 215.8 151.8 108.1 143.3

Average Staff Numbers

Categories Staff Numbers

Co. B - Salaries & Wages Category 1 1.0 1.0 1.0 1.0 1.0
Co. B - Salaries & Wages Category 2 1.0 1.0 1.0 1.0 1.0
Co. B - Salaries & Wages Category 3 1.0 1.0 1.0 1.0 1.0
Average Total Staff 3.0 3.0 3.0 3.0 3.0

Base Salaries & Wages

Base Salaries & Wages (Including Retirement Contributions)

Categories
Co. B - Salaries & Wages Category 1 96.0 44.5 65.1 9.6 34.5
Co. B - Salaries & Wages Category 2 6.7 86.5 39.2 107.8 39.1
Co. B - Salaries & Wages Category 3 89.8 106.4 54.1 8.9 86.9
Total Base Salaries & Wages 192.5 237.4 158.4 126.4 160.5

Base Salaries & Wages - Retirement Contributions Withheld

Categories
Co. B - Salaries & Wages Category 1 1.2 3.2 0.2 0.3 1.2
Co. B - Salaries & Wages Category 2 0.5 5.3 0.8 9.2 2.7
Co. B - Salaries & Wages Category 3 6.9 7.6 3.7 0.6 4.3
Total Retirement Contributions Withheld 8.6 16.1 4.7 10.0 8.2

Base Salaries & Wages (Excluding Retirement Contributions)

403447950.xlsx
Op_Ann_TO Page 58 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Categories
Co. B - Salaries & Wages Category 1 94.8 41.3 64.9 9.3 33.3
Co. B - Salaries & Wages Category 2 6.2 81.2 38.4 98.7 36.4
Co. B - Salaries & Wages Category 3 82.9 98.8 50.4 8.4 82.6
Total Base Salaries & Wages 183.9 221.3 153.7 116.3 152.4

Base Salaries & Wages - Taxes Withheld

Categories
Co. B - Salaries & Wages Category 1 9.4 1.3 0.1 0.3 2.0
Co. B - Salaries & Wages Category 2 0.6 0.2 0.1 7.4 1.6
Co. B - Salaries & Wages Category 3 6.4 4.1 1.9 0.5 5.8
Total Taxes Withheld 16.4 5.7 2.1 8.2 9.3

Net Base Salaries & Wages

Categories
Co. B - Salaries & Wages Category 1 85.4 40.0 64.8 9.0 31.4
Co. B - Salaries & Wages Category 2 5.7 80.9 38.3 91.2 34.8
Co. B - Salaries & Wages Category 3 76.5 94.7 48.5 7.8 76.9
Total Base Salaries & Wages 167.5 215.6 151.6 108.1 143.1

Average Annual Base Salaries

Categories $ (Excluding Retirement Contributions)
Co. B - Salaries & Wages Category 1 94,810 41,307 64,902 9,309 33,342
Co. B - Salaries & Wages Category 2 6,213 81,168 38,411 98,654 36,415
Co. B - Salaries & Wages Category 3 82,906 98,788 50,373 8,352 82,624

Bonuses

Bonuses (Including Retirement Contributions)

Categories
Co. B - Salaries & Wages Category 1 0.1 0.1 0.1 0.0 0.1
Co. B - Salaries & Wages Category 2 0.1 0.1 0.0 0.0 0.1
Co. B - Salaries & Wages Category 3 0.1 0.1 0.1 0.0 0.1
Total Bonuses 0.2 0.2 0.2 0.1 0.3

Bonuses - Retirement Contributions Withheld

Categories

403447950.xlsx
Op_Ann_TO Page 59 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. B - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0
Co. B - Salaries & Wages Category 2 0.0 0.0 0.0 0.0 0.0
Co. B - Salaries & Wages Category 3 0.0 0.0 0.0 0.0 0.0
Total Retirement Contributions Withheld 0.0 0.0 0.0 0.0 0.0

Bonuses (Excluding Retirement Contributions)

Categories
Co. B - Salaries & Wages Category 1 0.1 0.1 0.1 0.0 0.1
Co. B - Salaries & Wages Category 2 0.1 0.1 0.0 0.0 0.1
Co. B - Salaries & Wages Category 3 0.1 0.1 0.1 0.0 0.1
Total Bonuses 0.2 0.2 0.2 0.1 0.3

Bonuses - Taxes Withheld

Categories
Co. B - Salaries & Wages Category 1 0.0 0.0 0.0 0.0 0.0
Co. B - Salaries & Wages Category 2 0.0 0.0 0.0 0.0 0.0
Co. B - Salaries & Wages Category 3 0.0 0.0 0.0 0.0 0.0
Total Taxes Withheld 0.0 0.0 0.0 0.0 0.0

Net Bonuses
Categories
Co. B - Salaries & Wages Category 1 0.1 0.1 0.1 0.0 0.1
Co. B - Salaries & Wages Category 2 0.1 0.1 0.0 0.0 0.1
Co. B - Salaries & Wages Category 3 0.1 0.1 0.1 0.0 0.1
Total Bonuses 0.2 0.2 0.2 0.0 0.2

Average Bonuses
Categories $ (Excluding Retirement Contributions)
Co. B - Salaries & Wages Category 1 96 52 90 24 98
Co. B - Salaries & Wages Category 2 59 55 48 14 62
Co. B - Salaries & Wages Category 3 82 56 92 15 93

Salaries & Wages Reconciliation

Total Net Salaries & Wages 167.8 215.8 151.8 108.1 143.3
Total Taxes Withheld 16.4 5.7 2.1 8.2 9.3
Total Retirement Contributions Withheld 8.6 16.1 4.7 10.0 8.2
Total Salaries & Wages 192.8 237.5 158.6 126.4 160.8

403447950.xlsx
Op_Ann_TO Page 60 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Total Error Checks Result - - - - - -

Alert Check (Negative Salaries & Wages) - - - - - -

Go to Co. B - Salaries - Assumptions

Notes
. Figures are stated in $'000 unless specified otherwise.

Co. B - Opex - Outputs

Categories
Co. B - Opex Category 1 26.6 22.8 24.7 71.6 93.6
Co. B - Opex Category 2 92.1 12.9 83.1 21.3 17.8
Co. B - Opex Category 3 17.7 21.7 50.2 68.1 23.1
Total Operating Expenditure 136.4 57.5 158.0 161.1 134.5

Growth Rates
Co. B - Opex Category 1 (14.2%) 8.2% 190.3% 30.7%
Co. B - Opex Category 2 (86.0%) 542.5% (74.3%) (16.4%)
Co. B - Opex Category 3 22.9% 131.4% 35.7% (66.1%)
Total Operating Expenditure (57.9%) 175.0% 2.0% (16.5%)

Error Check - - - - - -
Alert Check (Negative Operating Expenditure - - - - - -

Go to Co. B - Opex - Assumptions

Notes
. Operating expenditure is stated in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TO Page 61 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Capex - Outputs

Categories
Consol Capex Category 1 85.2 14.4 83.6 87.2 37.1
Consol Capex Category 2 1.3 78.5 25.1 32.0 17.8
Consol Capex Category 3 54.9 53.3 27.5 67.7 39.5
Total Capital Expenditure 141.4 146.2 136.2 186.9 94.4

Growth Rates
Consol Capex Category 1 (83.2%) 482.6% 4.3% (57.5%)
Consol Capex Category 2 6,182.4% (68.1%) 27.6% (44.4%)
Consol Capex Category 3 (2.9%) (48.4%) 146.0% (41.7%)
Total Capital Expenditure 3.4% (6.8%) 37.2% (49.5%)

Error Check - - - - - -
Alert Check (Negative Capital Expenditure) - - - - - -

Go to Consol Capex - Assumptions

Notes
. Capital expenditure is stated in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TO Page 62 of 117
Printed: 07:25:13 on 12/01/2018
Operational
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Intangibles Capex - Outputs

Categories
Consol Intangibles Capex Category 1 90.9 69.3 36.0 58.1 64.5
Consol Intangibles Capex Category 2 60.4 6.5 3.8 92.5 33.1
Consol Intangibles Capex Category 3 56.4 58.5 75.1 45.5 77.9
Total Intangibles Capital Expenditure 207.7 134.3 114.9 196.1 175.6

Growth Rates
Consol Intangibles Capex Category 1 (23.7%) (48.1%) 61.6% 11.0%
Consol Intangibles Capex Category 2 (89.2%) (42.6%) 2,365.3% (64.2%)
Consol Intangibles Capex Category 3 3.6% 28.5% (39.5%) 71.3%
Total Intangibles Capital Expenditure (35.3%) (14.5%) 70.7% (10.5%)

Error Check - - - - - -
Alert Check (Negative Intangibles Capital Ex - - - - - -

Go to Consol Intangibles Capex - Assumptions

Notes
. Intangibles capital expenditure is stated in $'000 unless specified otherwise.

403447950.xlsx
Op_Ann_TO Page 63 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Debtors - Summary

Opening Balance 223.0 101.7 105.4 127.9 203.1

Revenue 2,704.6 2,608.6 3,426.2 5,281.6 2,846.3
Cash Receipts (2,825.9) (2,605.0) (3,403.7) (5,206.4) (2,927.1)
Increase/(Decrease) in Trade Debtors (121.2) 3.6 22.5 75.2 (80.8)
Closing Balance 101.7 105.4 127.9 203.1 122.3

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

Go to Consol Debtors - Assumptions

Go to Consol Debtors - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TO Page 64 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Inventory - Summary

Opening Balance 158.3 10.7 15.8 12.9 7.6

Inventory Purchases 158.8 387.6 367.4 192.8 365.2
Cost of Goods Sold (306.4) (382.4) (370.3) (198.1) (360.5)
Increase/(Decrease) in Inventory (147.6) 5.1 (2.9) (5.3) 4.8
Closing Balance 10.7 15.8 12.9 7.6 12.4

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

Go to Consol Inventory - Assumptions

Go to Consol Inventory - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TO Page 65 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Creditors - Summary

Opening Balance 106.5 28.2 39.9 30.4 28.4

Expenses 803.2 969.5 807.3 739.6 971.9
Cash Payments (881.6) (957.8) (816.8) (741.6) (963.8)
Increase/(Decrease) in Trade Creditors (78.3) 11.7 (9.5) (2.0) 8.0
Closing Balance 28.2 39.9 30.4 28.4 36.4

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

Go to Consol Creditors - Assumptions

Go to Consol Creditors - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TO Page 66 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Debtors - Schedules

Trade Debtors Category 1

Opening Balance 94.4 16.0 11.7 24.1 37.8

Revenue 832.4 608.1 1,258.7 1,969.9 688.6
Cash Receipts (910.8) (612.4) (1,246.3) (1,956.2) (713.2)
Increase/(Decrease) in Trade Debtors (78.5) (4.3) 12.4 13.7 (24.6)
Closing Balance 16.0 11.7 24.1 37.8 13.2

Debtor Days 7 7 7 7 7

Trade Debtors Category 2

Opening Balance 62.1 43.9 42.7 41.1 50.4

Revenue 1,144.4 1,114.5 1,075.0 1,314.4 785.4
Cash Receipts (1,162.7) (1,115.6) (1,076.6) (1,305.1) (805.7)
Increase/(Decrease) in Trade Debtors (18.2) (1.1) (1.6) 9.3 (20.3)
Closing Balance 43.9 42.7 41.1 50.4 30.1

Debtor Days 14 14 14 14 14

Trade Debtors Category 3

Opening Balance 66.4 41.9 51.0 62.7 114.9

Revenue 727.9 886.0 1,092.6 1,997.4 1,372.2
Cash Receipts (752.4) (876.9) (1,080.9) (1,945.1) (1,408.2)
Increase/(Decrease) in Trade Debtors (24.5) 9.1 11.7 52.2 (36.0)
Closing Balance 41.9 51.0 62.7 114.9 79.0

Debtor Days 21 21 21 21 21

Go to Consol Debtors - Assumptions

Go to Consol Debtors - Summary

403447950.xlsx
WC_Ann_TO Page 67 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TO Page 68 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Inventory - Schedules

Inventory Category 1

Opening Balance 62.4 2.8 1.6 2.6 0.8

Inventory Purchases 88.5 82.7 135.6 38.7 153.7
Cost of Goods Sold (148.0) (83.9) (134.6) (40.5) (151.6)
Increase/(Decrease) in Inventory (59.5) (1.2) 1.0 (1.8) 2.1
Closing Balance 2.8 1.6 2.6 0.8 2.9

Inventory Days 7 7 7 7 7

Inventory Category 2

Opening Balance 2.7 2.5 5.9 6.3 4.4

Inventory Purchases 64.9 156.8 165.2 113.0 130.7
Cost of Goods Sold (65.1) (153.4) (164.8) (114.9) (130.1)
Increase/(Decrease) in Inventory (0.2) 3.4 0.4 (1.9) 0.6
Closing Balance 2.5 5.9 6.3 4.4 5.0

Inventory Days 14 14 14 14 14

Inventory Category 3

Opening Balance 93.3 5.4 8.3 4.1 2.5

Inventory Purchases 5.4 148.1 66.6 41.2 80.8
Cost of Goods Sold (93.3) (145.1) (70.9) (42.8) (78.8)
Increase/(Decrease) in Inventory (87.9) 3.0 (4.3) (1.6) 2.1
Closing Balance 5.4 8.3 4.1 2.5 4.5

Inventory Days 21 21 21 21 21

Go to Consol Inventory - Assumptions

Go to Consol Inventory - Summary

403447950.xlsx
WC_Ann_TO Page 69 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TO Page 70 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Creditors - Schedules

Trade Creditors Category 1

Opening Balance 6.2 5.9 4.6 4.2 4.6

Expenses 306.2 240.8 218.6 241.1 335.3
Cash Payments (306.5) (242.0) (219.0) (240.6) (333.5)
Increase/(Decrease) in Trade Creditors (0.3) (1.3) (0.4) 0.4 1.8
Closing Balance 5.9 4.6 4.2 4.6 6.4

Creditor Days 7 7 7 7 7

Trade Creditors Category 2

Opening Balance 80.8 12.6 13.2 15.1 9.8

Expenses 328.0 345.2 393.8 254.6 345.3
Cash Payments (396.2) (344.5) (392.0) (259.9) (341.8)
Increase/(Decrease) in Trade Creditors (68.2) 0.7 1.8 (5.3) 3.5
Closing Balance 12.6 13.2 15.1 9.8 13.2

Creditor Days 14 14 14 14 14

Trade Creditors Category 3

Opening Balance 19.6 9.7 22.1 11.2 14.0

Expenses 169.0 383.6 195.0 243.9 291.3
Cash Payments (178.9) (371.2) (205.8) (241.0) (288.5)
Increase/(Decrease) in Trade Creditors (9.9) 12.3 (10.9) 2.8 2.7
Closing Balance 9.7 22.1 11.2 14.0 16.8

Creditor Days 21 21 21 21 21

Go to Consol Creditors - Assumptions

Go to Consol Creditors - Summary

403447950.xlsx
WC_Ann_TO Page 71 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
WC_Ann_TO Page 72 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Book Assets - Summary

Opening Net Book Value 155.8 252.1 336.7 395.1 485.6

Capital Expenditure 141.4 146.2 136.2 186.9 94.4
Book Depreciation (45.1) (61.6) (77.8) (96.4) (89.3)
Closing Net Book Value 252.1 336.7 395.1 485.6 490.6

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

Go to Consol Book Assets - Assumptions

Go to Consol Book Assets - Capital Expenditure Assumptions
Go to Consol Book Assets - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
Assets_Ann_TO Page 73 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Book Intangibles - Summary

Opening Net Book Value 83.3 223.6 249.2 263.6 344.0

Capital Expenditure 207.7 134.3 114.9 196.1 175.6
Book Amortization (67.3) (108.8) (100.4) (115.7) (127.4)
Closing Net Book Value 223.6 249.2 263.6 344.0 392.1

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

Go to Consol Book Intangibles - Assumptions

Go to Consol Book Intangibles - Capital Expenditure Assumptions
Go to Consol Book Intangibles - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
Assets_Ann_TO Page 74 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Book Assets - Schedules

Book Assets Category 1

Opening Assets
Opening Net 76.4
Book Value
Depreciation Method Straight-Line
Depreciation 3.9
(Years)
Capital Expenditure
Capital Expenditure
Middle of Period
Timing
Depreciation Method Straight-Line
Depreciation (Years) 7.0

Opening Net Book Value 76.4 136.1 117.9 161.9 198.6

Capital Expenditure 85.2 14.4 83.6 87.2 37.1
Book Depreciation (25.5) (32.6) (39.5) (50.6) (41.2)
Closing Net Book Value 136.1 117.9 161.9 198.6 194.5

Book Assets Category 2

Opening Assets
Opening Net 76.8
Book Value
Depreciation Method Straight-Line
Depreciation 4.7
(Years)
Capital Expenditure
Capital Expenditure
Middle of Period
Timing
Depreciation Method Straight-Line
Depreciation (Years) 10.0

403447950.xlsx
Assets_Ann_TO Page 75 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Opening Net Book Value 76.8 61.5 119.5 118.9 122.3
Capital Expenditure 1.3 78.5 25.1 32.0 17.8
Book Depreciation (16.6) (20.5) (25.7) (28.6) (25.5)
Closing Net Book Value 61.5 119.5 118.9 122.3 114.7

Book Assets Category 3

Opening Assets
Opening Net 2.6
Book Value
Depreciation Method Straight-Line
Depreciation 7.7
(Years)
Capital Expenditure
Capital Expenditure
Middle of Period
Timing
Depreciation Method Straight-Line
Depreciation (Years) 10.0

Opening Net Book Value 2.6 54.4 99.3 114.2 164.6

Capital Expenditure 54.9 53.3 27.5 67.7 39.5
Book Depreciation (3.1) (8.5) (12.5) (17.3) (22.7)
Closing Net Book Value 54.4 99.3 114.2 164.6 181.5

Go to Consol Book Assets - Assumptions

Go to Consol Book Assets - Capital Expenditure Assumptions
Go to Consol Book Assets - Summary

403447950.xlsx
Assets_Ann_TO Page 76 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Book Intangibles - Schedules

Book Intangibles Category 1

Opening Intangibles
Opening Net 2.6
Book Value
Amortization Method Straight-Line
Amortization (Years) 6.6

Capital Expenditure
Capital Expenditure
Middle of Period
Timing
Amortization Method Straight-Line
Amortization (Years) 10.0

Opening Net Book Value 2.6 88.5 144.9 162.6 197.8

Capital Expenditure 90.9 69.3 36.0 58.1 64.5
Book Amortization (4.9) (12.9) (18.2) (22.9) (29.0)
Closing Net Book Value 88.5 144.9 162.6 197.8 233.3

Book Intangibles Category 2

Opening Intangibles
Opening Net 31.6
Book Value
Amortization Method Straight-Line
Amortization (Years) 2.2

Capital Expenditure
Capital Expenditure
Middle of Period
Timing
Amortization Method Straight-Line
Amortization (Years) 4.0

403447950.xlsx
Assets_Ann_TO Page 77 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Opening Net Book Value 31.6 70.1 46.3 30.0 93.2
Capital Expenditure 60.4 6.5 3.8 92.5 33.1
Book Amortization (21.9) (30.3) (20.1) (29.2) (37.4)
Closing Net Book Value 70.1 46.3 30.0 93.2 89.0

Book Intangibles Category 3

Opening Intangibles
Opening Net 49.0
Book Value
Amortization Method Straight-Line
Amortization (Years) 1.9

Capital Expenditure
Capital Expenditure
Middle of Period
Timing
Amortization Method Straight-Line
Amortization (Years) 2.0

Opening Net Book Value 49.0 65.0 58.0 71.0 52.9

Capital Expenditure 56.4 58.5 75.1 45.5 77.9
Book Amortization (40.5) (65.5) (62.1) (63.6) (61.0)
Closing Net Book Value 65.0 58.0 71.0 52.9 69.8

Go to Consol Book Intangibles - Assumptions

Go to Consol Book Intangibles - Capital Expenditure Assumptions
Go to Consol Book Intangibles - Summary

403447950.xlsx
Assets_Ann_TO Page 78 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Debt - Summary

Funds Drawn

Opening Balance 162.6 190.1 151.7 173.9 194.8

Debt Drawdowns 100.7 92.9 106.1 96.5 131.5
Debt Repayments (73.3) (131.3) (83.9) (75.7) (71.8)
Closing Balance 190.1 151.7 173.9 194.8 254.4

Interest Payable

Opening Balance 76.1 76.1 76.1 76.1 76.1

Interest Expense 10.0 5.0 8.4 11.4 13.7
Interest Paid (10.0) (5.0) (8.4) (11.4) (13.7)
Closing Balance 76.1 76.1 76.1 76.1 76.1

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

Go to Consol Debt - Assumptions

Go to Consol Debt - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
CS_Ann_TO Page 79 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Ordinary Equity - Outputs

Ordinary Equity Balances

Opening Balance 23.7 23.2 26.8 22.9 26.1

Equity Raisings 2.9 4.8 0.4 7.8 4.6
Equity Buybacks (3.4) (1.2) (4.2) (4.6) (2.2)
Closing Balance 23.2 26.8 22.9 26.1 28.4

Dividends

Opening Dividends Payable 60.3 82.5 2.3 110.2 37.6

Dividends Declared 82.5 2.3 110.2 37.6 92.4
Dividends Paid (60.3) (82.5) (2.3) (110.2) (37.6)
Closing Dividends Payable 82.5 2.3 110.2 37.6 92.4

Dividend Payable

Dividend Determination Meth % of Net Profit After Tax

Dividend Declaration Period? Yes Yes Yes Yes Yes

Schedule
Opening Retained Profits 6,342.0 7,394.7 8,148.7 9,806.9 12,753.1
Net Profit After Tax (NPAT) 1,135.2 756.3 1,768.4 2,983.8 1,324.4
Maximum Dividends Allowed 7,477.2 8,151.0 9,917.1 12,790.7 14,077.6
Opening Cash at Bank 6,329.0 7,954.9 8,141.0 10,214.5 13,649.2
Cash Flow Available For Dividends 1,686.2 268.6 2,075.8 3,544.9 683.0
Total Available Cash For Dividends 8,015.2 8,223.5 10,216.8 13,759.4 14,332.3
Dividend Payout Ratio - % of Net Profit After Tax 7.3% 0.3% 6.2% 1.3% 7.0%
Amounts - Not Applied - - - - -
Target Dividends Declared 82.5 2.3 110.2 37.6 92.4
Actual Dividends Declared 82.5 2.3 110.2 37.6 92.4

Total Error Checks Result - - - - - -

Total Alert Checks Result - - - - - -

403447950.xlsx
CS_Ann_TO Page 80 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Go to Consol Ordinary Equity - Assumptions

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
CS_Ann_TO Page 81 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Debt - Schedules

Debt Category 1

Funds Drawn

Opening Balance 26.7 21.3 59.7 80.5 74.7

Drawdowns 14.5 72.2 45.5 32.7 33.1
Repayments (19.9) (33.8) (24.7) (38.5) (34.5)
Closing Balance 21.3 59.7 80.5 74.7 73.3

Interest Payable

All-In Interest Rate (% p.a.) 5.07% 8.19% 7.74% 9.94% 7.59%

Opening Balance 1.2 1.2 1.2 1.2 1.2

Interest Expense 1.2 3.3 5.4 7.7 5.6
Interest Paid (1.2) (3.3) (5.4) (7.7) (5.6)
Closing Balance 1.2 1.2 1.2 1.2 1.2

Debt Category 2

Funds Drawn

Opening Balance 37.1 59.0 23.7 19.9 43.1

Drawdowns 56.4 13.4 15.9 29.0 40.8
Repayments (34.5) (48.8) (19.6) (5.8) (12.7)
Closing Balance 59.0 23.7 19.9 43.1 71.1

Interest Payable

All-In Interest Rate (% p.a.) 1.98% 4.02% 3.95% 9.33% 6.05%

Opening Balance 71.2 71.2 71.2 71.2 71.2

Interest Expense 1.0 1.7 0.9 2.9 3.5

403447950.xlsx
CS_Ann_TO Page 82 of 117
Printed: 07:25:13 on 12/01/2018
Capital
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Interest Paid (1.0) (1.7) (0.9) (2.9) (3.5)
Closing Balance 71.2 71.2 71.2 71.2 71.2

Debt Category 3

Funds Drawn

Opening Balance 98.8 109.8 68.4 73.5 77.0

Drawdowns 29.8 7.2 44.7 34.9 57.6
Repayments (18.8) (48.6) (39.6) (31.4) (24.6)
Closing Balance 109.8 68.4 73.5 77.0 110.0

Interest Payable

All-In Interest Rate (% p.a.) 7.48% 0.02% 2.92% 0.98% 5.00%

Opening Balance 3.7 3.7 3.7 3.7 3.7

Interest Expense 7.8 0.0 2.1 0.7 4.7
Interest Paid (7.8) (0.0) (2.1) (0.7) (4.7)
Closing Balance 3.7 3.7 3.7 3.7 3.7

Go to Consol Debt - Assumptions

Go to Consol Debt - Summary

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
CS_Ann_TO Page 83 of 117
Printed: 07:25:13 on 12/01/2018
Consol Taxation - Outputs
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

403447950.xlsx
Corp_Tax_Ann_TO Page 84 of 117
Printed: 07:25:13 on 12/01/2018
Consol Taxation - Outputs
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Taxation - Outputs

Tax Expense

Tax Expense/(Benefit) 760.5 508.1 1,181.8 1,991.3 890.7

Tax Payable During Period

Net Profit Before Tax 1,895.7 1,264.4 2,950.1 4,975.1 2,215.1

Total Adjustments 5.5 5.9 4.3 3.2 11.6
Taxable Profit/(Loss) - Before Loss Utilization 1,901.2 1,270.4 2,954.4 4,978.2 2,226.7
Tax Losses - Used During Period - - - - -
Taxable Profit/(Loss) - After Loss Utilization 1,901.2 1,270.4 2,954.4 4,978.2 2,226.7
Corporate Taxation Rate 40.0% 40.0% 40.0% 40.0% 40.0%
Tax Payable 760.5 508.1 1,181.8 1,991.3 890.7

Tax Losses

Opening Balance - - - - -
Tax Losses - Created During Period - - - - -
Tax Losses - Used During Period - - - - -
Closing Tax Losses - - - - -

Tax Payable & Paid

Opening Tax Payable 39.3 458.6 62.1 283.6 944.9

Tax Payable - Created During Period 760.5 508.1 1,181.8 1,991.3 890.7
Tax Payable - Paid During Period (341.2) (904.6) (960.3) (1,330.1) (1,798.8)
Closing Tax Payable 458.6 62.1 283.6 944.9 36.8

Total Error Checks Result - - - - - -

Go to Consol Taxation - Assumptions

Notes

403447950.xlsx
Corp_Tax_Ann_TO Page 85 of 117
Printed: 07:25:13 on 12/01/2018
Consol Taxation - Outputs
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
Corp_Tax_Ann_TO Page 86 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

403447950.xlsx
OFSI_Ann_TO Page 87 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Other Income Statement Items - Summary

Net Income Statement Summary

Other Revenue
Co. A Other Revenue Category 1 12.9 74.2 70.0 8.8 41.5
Co. A Other Revenue Category 2 61.0 63.2 29.8 92.2 58.1
Co. A Other Revenue Category 3 23.4 27.2 82.3 51.3 51.3
Total Other Income Items 97.3 164.6 182.1 152.3 150.9

Other Operating Expenditure

Co. A Other Expenses Category 1 0.4 33.6 52.9 62.2 39.0
Co. A Other Expenses Category 2 96.7 45.8 62.3 90.6 42.2
Co. A Other Expenses Category 3 7.3 72.9 51.0 31.7 54.9
Total Other Expense Items 104.4 152.3 166.3 184.4 136.1

Cash Flow Statement Impacts

Other Income Statement Items - Cash Receipts 97.3 164.6 182.1 152.3 150.9
Other Income Statement Items - Cash Payments (104.4) (152.3) (166.3) (184.4) (136.1)
Other Income Statement Items - Operating Cash Flo - - - - -
Other Income Statement Items - Investing Cash Flow - - - - -
Other Income Statement Items - Financing Cash Flow - - - - -
Total Cash Flow Statement Impacts (7.1) 12.3 15.8 (32.1) 14.7

Error Values - - - - -
Balance Check - - - - -
Total Error Checks Result - - - - - -

Go to Co. A - Other Income Statement Items - Assumptions

Go to Co. A - Other Income Statement Items - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
OFSI_Ann_TO Page 88 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Co. A - Other Income Statement Items - Schedules

Other Revenue

Categories
Co. A Other Revenue Category 1 12.9 74.2 70.0 8.8 41.5
Co. A Other Revenue Category 2 61.0 63.2 29.8 92.2 58.1
Co. A Other Revenue Category 3 23.4 27.2 82.3 51.3 51.3
Total Other Income Items 97.3 164.6 182.1 152.3 150.9

Cash Flow Statement Impacts

Other Revenue Cash Receipts 97.3 164.6 182.1 152.3 150.9
Other Revenue Cash Payments - - - - -
Other Revenue Operating Cash Flows - - - - -
Other Revenue Investing Cash Flows - - - - -
Other Revenue Financing Cash Flows - - - - -
Total Cash Flow Statement Impacts 97.3 164.6 182.1 152.3 150.9

Other Operating Expenditure

Categories
Co. A Other Expenses Category 1 0.4 33.6 52.9 62.2 39.0
Co. A Other Expenses Category 2 96.7 45.8 62.3 90.6 42.2
Co. A Other Expenses Category 3 7.3 72.9 51.0 31.7 54.9
Total Other Expense Items 104.4 152.3 166.3 184.4 136.1

Cash Flow Statement Impacts

Other Operating Expenditure Cash Receipts - - - - -
Other Operating Expenditure Cash Payments (104.4) (152.3) (166.3) (184.4) (136.1)
Other Operating Expenditure Operating Cash Flows - - - - -
Other Operating Expenditure Investing Cash Flows - - - - -
Other Operating Expenditure Financing Cash Flows - - - - -
Total Cash Flow Statement Impacts (104.4) (152.3) (166.3) (184.4) (136.1)

Go to Co. A - Other Income Statement Items - Assumptions

403447950.xlsx
OFSI_Ann_TO Page 89 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Go to Co. A - Other Income Statement Items - Summary

Notes
. Figures are stated in $'000 unless specified otherwise.

Co. B - Other Income Statement Items - Summary

Net Income Statement Summary

Other Revenue
Co. B Other Revenue Category 1 13.6 77.7 77.5 79.1 20.0
Co. B Other Revenue Category 2 25.5 66.8 90.6 97.1 70.2
Co. B Other Revenue Category 3 74.7 28.8 0.7 91.2 25.6
Total Other Income Items 113.8 173.2 168.8 267.3 115.8

Other Operating Expenditure

Co. B Other Expenses Category 1 40.5 6.5 2.5 62.4 22.5
Co. B Other Expenses Category 2 21.5 76.6 39.1 20.0 92.9
Co. B Other Expenses Category 3 18.7 52.7 11.7 64.5 72.2
Total Other Expense Items 80.7 135.8 53.3 146.8 187.5

Cash Flow Statement Impacts

Other Income Statement Items - Cash Receipts 113.8 173.2 168.8 267.3 115.8
Other Income Statement Items - Cash Payments (80.7) (135.8) (53.3) (146.8) (187.5)
Other Income Statement Items - Operating Cash Flo - - - - -
Other Income Statement Items - Investing Cash Flow - - - - -
Other Income Statement Items - Financing Cash Flow - - - - -
Total Cash Flow Statement Impacts 33.1 37.5 115.5 120.5 (71.7)

Error Values - - - - -
Balance Check - - - - -
Total Error Checks Result - - - - - -

Go to Co. B - Other Income Statement Items - Assumptions

Go to Co. B - Other Income Statement Items - Schedules

403447950.xlsx
OFSI_Ann_TO Page 90 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Notes
. Figures are stated in $'000 unless specified otherwise.

Co. B - Other Income Statement Items - Schedules

Other Revenue

Categories
Co. B Other Revenue Category 1 13.6 77.7 77.5 79.1 20.0
Co. B Other Revenue Category 2 25.5 66.8 90.6 97.1 70.2
Co. B Other Revenue Category 3 74.7 28.8 0.7 91.2 25.6
Total Other Income Items 113.8 173.2 168.8 267.3 115.8

Cash Flow Statement Impacts

Other Revenue Cash Receipts 113.8 173.2 168.8 267.3 115.8
Other Revenue Cash Payments - - - - -
Other Revenue Operating Cash Flows - - - - -
Other Revenue Investing Cash Flows - - - - -
Other Revenue Financing Cash Flows - - - - -
Total Cash Flow Statement Impacts 113.8 173.2 168.8 267.3 115.8

Other Operating Expenditure

Categories
Co. B Other Expenses Category 1 40.5 6.5 2.5 62.4 22.5
Co. B Other Expenses Category 2 21.5 76.6 39.1 20.0 92.9
Co. B Other Expenses Category 3 18.7 52.7 11.7 64.5 72.2
Total Other Expense Items 80.7 135.8 53.3 146.8 187.5

Cash Flow Statement Impacts

Other Operating Expenditure Cash Receipts - - - - -
Other Operating Expenditure Cash Payments (80.7) (135.8) (53.3) (146.8) (187.5)
Other Operating Expenditure Operating Cash Flows - - - - -
Other Operating Expenditure Investing Cash Flows - - - - -
Other Operating Expenditure Financing Cash Flows - - - - -

403447950.xlsx
OFSI_Ann_TO Page 91 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Total Cash Flow Statement Impacts (80.7) (135.8) (53.3) (146.8) (187.5)

Go to Co. B - Other Income Statement Items - Assumptions

Go to Co. B - Other Income Statement Items - Summary

Notes
. Figures are stated in $'000 unless specified otherwise.

Consol Interest on Cash - Outputs

Cash at Bank

Opening Cash at Bank 6,329.0 7,954.9 8,141.0 10,214.5 13,649.2

(Add) Change in Cash (Pre-Corporate Tax & Interest 1,553.3 875.2 2,177.5 3,874.8 1,521.5
(Less) Opening Corporate Tax Payable (39.3) (458.6) (62.1) (283.6) (944.9)
Proxy Change in Cash at Bank 1,514.0 416.6 2,115.3 3,591.2 576.7
Proxy Closing Cash at Bank 7,842.9 8,371.5 10,256.3 13,805.7 14,225.9

Proxy Average Cash at Bank 7,085.9 8,163.2 9,198.6 12,010.1 13,937.6

Interest on Cash

All-In Interest Rate (% p.a.) 5.84% 2.64% 9.31% 7.41% 6.62%

Interest on Cash 413.8 215.5 856.4 890.0 922.7

Error Check - - - - - -

Go to Consol Interest on Cash - Assumptions

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
OFSI_Ann_TO Page 92 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Other Balance Sheet - Summary

Net Assets Summary

Opening Balance (138.7) (289.7) (340.4) (510.0) (628.6)

Change in Net Assets (150.9) (50.7) (169.6) (118.6) (173.9)
Closing Balance (289.7) (340.4) (510.0) (628.6) (802.4)

Cash Flow Statement Impacts

Other Balance Sheet Items - Cash Receipts - - - - -

Other Balance Sheet Items - Cash Payments 114.3 156.0 144.5 190.6 107.4
Other Balance Sheet Items - Operating Cash Flows (208.6) (210.9) (156.2) (206.0) (192.8)
Other Balance Sheet Items - Investing Cash Flows (172.0) (175.4) (132.3) (213.4) (98.3)
Other Balance Sheet Items - Financing Cash Flows 417.1 281.1 313.5 347.4 357.4
Total Cash Flow Statement Impacts 150.9 50.7 169.6 118.6 173.9

Total Error Checks Result - - - - - -

Go to Consol Other Balance Sheet - Assumptions

Go to Consol Other Balance Sheet - Schedules

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
OFSI_Ann_TO Page 93 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Consol Other Balance Sheet - Schedules

Other Current Assets

Balances

Opening Balance 163.2 371.8 582.7 738.9 944.9

Change in Other Current Assets 208.6 210.9 156.2 206.0 192.8
Closing Balance 371.8 582.7 738.9 944.9 1,137.6

Cash Flow Statement Impacts

Other Current Assets - Cash Receipts - - - - -

Other Current Assets - Cash Payments - - - - -
Other Current Assets - Operating Cash Flows (208.6) (210.9) (156.2) (206.0) (192.8)
Other Current Assets - Investing Cash Flows - - - - -
Other Current Assets - Financing Cash Flows - - - - -
Total Cash Flow Statement Impacts (208.6) (210.9) (156.2) (206.0) (192.8)

Other Non-Current Assets

Balances

Opening Balance 115.1 287.1 462.5 594.7 808.1

Change in Other Non-Current Assets 172.0 175.4 132.3 213.4 98.3
Closing Balance 287.1 462.5 594.7 808.1 906.4

Cash Flow Statement Impacts

Other Non-Current Assets - Cash Receipts - - - - -

Other Non-Current Assets - Cash Payments - - - - -
Other Non-Current Assets - Operating Cash Flows - - - - -
Other Non-Current Assets - Investing Cash Flows (172.0) (175.4) (132.3) (213.4) (98.3)
Other Non-Current Assets - Financing Cash Flows - - - - -
Total Cash Flow Statement Impacts (172.0) (175.4) (132.3) (213.4) (98.3)

403447950.xlsx
OFSI_Ann_TO Page 94 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Other Current Liabilities

Balances

Opening Balance 107.5 221.8 377.8 522.3 713.0

Change in Other Current Liabilities 114.3 156.0 144.5 190.6 107.4
Closing Balance 221.8 377.8 522.3 713.0 820.4

Cash Flow Statement Impacts

Other Current Liabilities - Cash Receipts - - - - -

Other Current Liabilities - Cash Payments 114.3 156.0 144.5 190.6 107.4
Other Current Liabilities - Operating Cash Flows - - - - -
Other Current Liabilities - Investing Cash Flows - - - - -
Other Current Liabilities - Financing Cash Flows - - - - -
Total Cash Flow Statement Impacts 114.3 156.0 144.5 190.6 107.4

Other Non-Current Liabilities

Balances

Opening Balance 117.4 306.5 469.1 567.0 738.8

Change in Other Non-Current Liabilities 189.1 162.5 97.9 171.8 156.7
Closing Balance 306.5 469.1 567.0 738.8 895.5

Cash Flow Statement Impacts

Other Non-Current Liabilities - Cash Receipts - - - - -

Other Non-Current Liabilities - Cash Payments - - - - -
Other Non-Current Liabilities - Operating Cash Fl - - - - -
Other Non-Current Liabilities - Investing Cash Flo - - - - -
Other Non-Current Liabilities - Financing Cash Fl 189.1 162.5 97.9 171.8 156.7
Total Cash Flow Statement Impacts 189.1 162.5 97.9 171.8 156.7

Other Equity

Balances

403447950.xlsx
OFSI_Ann_TO Page 95 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè xhO

Year Ending December 2014 2015 2016 2017 2018

Opening Balance 192.1 420.1 538.7 754.3 929.8

Change in Other Equity 228.0 118.6 215.6 175.6 200.7
Closing Balance 420.1 538.7 754.3 929.8 1,130.6

Cash Flow Statement Impacts

Other Equity - Cash Receipts - - - - -

Other Equity - Cash Payments - - - - -
Other Equity - Operating Cash Flows - - - - -
Other Equity - Investing Cash Flows - - - - -
Other Equity - Financing Cash Flows 228.0 118.6 215.6 175.6 200.7
Total Cash Flow Statement Impacts 228.0 118.6 215.6 175.6 200.7

Go to Consol Other Balance Sheet - Assumptions

Go to Consol Other Balance Sheet - Summary

Notes
. Figures are stated in $'000 unless specified otherwise.

403447950.xlsx
OFSI_Ann_TO Page 96 of 117
Printed: 07:25:13 on 12/01/2018
 Presentation Outputs
Section 3.
Consolidation Example
Go to Table of Contents
çè

Section Cover Notes:

Contains the model dashboards.

403447950.xlsx
Pres_Out_SC Page 97 of 117
Printed: 07:25:13 on 12/01/2018
 Financial Statements Summary
Consolidation Example
Go to Table of Contents
çè x h O

Income Statement Revenue Revenue - 2014

Co. B - Revenue Category 3 Co. B - Revenue Category 2
Year Ending December 2014 2015 2016 2017 2018
Co. B - Revenue Category 1 Co. A - Revenue Category 3
Co. A - Revenue Category 2 Co. A - Revenue Category 1 Co. A - Revenue
Revenue 2,494 2,271 3,075 4,862 2,580 Category 1
6,000
Cost of Goods Sold (306) (382) (370) (198) (360) Co. A - Revenue
Gross Margin 2,187 1,888 2,705 4,664 2,219 5,000 248 ; 9.93% 182 ; 7.31% Category 2
Net Operating Expenses (583) (664) (425) (355) (696) 113 ; 4.51% Co. A - Revenue
4,000
EBITDA 1,604 1,224 2,280 4,309 1,523 Category 3
(112) (170) (178) (212) (217) 3,000 624 ; 25.01% 945 ; 37.91%
Depreciation & Amortization Co. B - Revenue
EBIT 1,492 1,054 2,102 4,097 1,306 Category 1
2,000
Net Interest Expense 404 211 848 879 909 382 ; 15.32% Co. B - Revenue
Net Profit Before Tax 1,896 1,264 2,950 4,975 2,215 1,000 Category 2
Tax Expense (760) (508) (1,182) (1,991) (891) Co. B - Revenue
- Category 3
Net Profit After Tax 1,135 756 1,768 2,984 1,324
2014 2015 2016 2017 2018

Balance Sheet Salaries & Wages - 2014 Operating Expenditure - 2014

Year Ending December 2014 2015 2016 2017 2018

Current Assets 8,439 8,845 11,094 14,805 15,567

Non-Current Assets 763 1,048 1,253 1,638 1,789 Co. A - Salaries & Co. A - Opex Category
Total Assets 9,202 9,893 12,348 16,443 17,356 Wages Category 1 1
47 ; 15.72% Co. A - Salaries & 18 ; 5.66% Co. A - Opex Category
Wages Category 2 2
Current Liabilities 867 558 1,023 1,800 1,062
90 ; 30.25% 23 ; 7.68% Co. A - Salaries & 91 ; 29.09% Co. A - Opex Category
Non-Current Liabilities 497 621 741 934 1,150 92 ; 29.55%
Wages Category 3 3
Total Liabilities 1,364 1,179 1,764 2,733 2,212 35 ; 11.74%
7 ; 2.27% Co. B - Salaries & Co. B - Opex Category
Wages Category 1 27 ; 8.54% 53 ; 16.86% 1
Net Assets 7,838 8,714 10,584 13,709 15,144 32 ; 10.31%
Co. B - Salaries & Co. B - Opex Category
Wages Category 2 2
Ordinary Equity 23 27 23 26 28 96 ; 32.34%
Co. B - Salaries & Co. B - Opex Category
Other Equity 420 539 754 930 1,131 Wages Category 3 3
Retained Profits 7,395 8,149 9,807 12,753 13,985
Total Equity 7,838 8,714 10,584 13,709 15,144

Cash Flow Statement Revenue & Earnings Net Assets - 2014

Year Ending December 2014 2015 2016 2017 2018 Revenue EBITDA
EBIT 10,000
Cash Receipts 2,826 2,605 3,404 5,206 2,927 9,000
6,000 1,364
Cash Payments (917) (1,222) (1,008) (779) (1,213) 8,000
Other Operating Cash Flows (146) (905) (268) (658) (1,083)
5,000 7,000
Operating Cash Flows 1,763 478 2,127 3,770 632
6,000
4,000
Capital Expenditure (349) (280) (251) (383) (270)
5,000
Other Investing Cash Flows (172) (175) (132) (213) (98) 9,202
3,000 4,000
Investing Cash Flows (521) (456) (383) (596) (368) 7,838
2,000 3,000
Net Debt Drawdowns/(Repayments) 27 (38) 22 21 60
Net Ordinary Equity Raisings/(Buybacks) (1) 4 (4) 3 2 2,000
1,000
Other Financing Cash Flows 357 199 311 237 320 1,000
Financing Cash Flows 384 164 330 261 382
- -
2014 2015 2016 2017 2018 Assets Liabilities Net Assets
Change in Cash Held 1,626 186 2,074 3,435 645

403447950.xlsx
FS_Sum_P_MS Page 98 of 117
Printed: 07:25:13 on 12/01/2018
 Appendices
Section 4.
Consolidation Example
Go to Table of Contents
çè

Section Cover Notes:

Contains the model lookups and checks.

403447950.xlsx
App_SC Page 99 of 117
Printed: 07:25:13 on 12/01/2018
 Lookup Tables
Sub-Section 4.1.
Consolidation Example
Go to Table of Contents
çè

Sub-Section Cover Notes:

Contains the model lookups tables.

403447950.xlsx
LU_SSC Page 100 of 117
Printed: 07:25:13 on 12/01/2018
Time Series - Lookups
Consolidation Example
Go to Table of Contents
çè

Time Series - Lookups

Month Days Names

Month Day LU_TS_Mth_Days

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

Month Names Names

403447950.xlsx
TS_LU Page 101 of 117
Printed: 07:25:13 on 12/01/2018
Time Series - Lookups
Consolidation Example
Go to Table of Contents
çè

Month Name LU_TS_Mth_Names

January
February
March
April
May
June
July
August
September
October
November
December

Periods In Periods

Periods In Period
60 TS_Secs_In_Min
60 TS_Mins_In_Hr
24 TS_Hrs_In_Day
7 TS_Days_In_Wk
3 TS_Mths_In_Qtr
6 TS_Mths_In_Half
12 TS_Mths_In_Yr
2 TS_Qtrs_In_Half
4 TS_Qtrs_In_Yr
2 TS_Halves_In_Yr

Denominations Names

Denomination LU_TS_Denom
$
$'000
$Millions
$Billions

Denomination Conversions Names

Denomination Conversion LU_TS_Denom_Conv

1

403447950.xlsx
TS_LU Page 102 of 117
Printed: 07:25:13 on 12/01/2018
Time Series - Lookups
Consolidation Example
Go to Table of Contents
çè
1,000 TS_Thousand
1,000,000 TS_Million
1,000,000,000 TS_Billion

403447950.xlsx
TS_LU Page 103 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè

Consol Debtors - Lookups

Trade Debtors Allocation Lookup Names

Trade Debtors Allocations LU_Trd_Dr_Cat_Names

Trade Debtors Category 1
Trade Debtors Category 2
Trade Debtors Category 3

403447950.xlsx
WC_LU Page 104 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè

Consol Inventory - Lookups

Inventory Allocation Lookup Names

Inventory Allocations LU_Inv_Cat_Names

Inventory Category 1
Inventory Category 2
Inventory Category 3

403447950.xlsx
WC_LU Page 105 of 117
Printed: 07:25:13 on 12/01/2018
Working Capital
Consolidation Example
Go to Table of Contents
çè

Consol Creditors - Lookups

Trade Creditors Allocation Looku Names

Trade Creditors Allocations LU_Trd_Cr_Cat_Names

Trade Creditors Category 1
Trade Creditors Category 2
Trade Creditors Category 3

403447950.xlsx
WC_LU Page 106 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè

Consol Book Assets - Lookups

Capital Expenditure Timings Names

Capital Expenditure Timing LU_Assets_Bk_Capex_Timing

Start of Period
Middle of Period
End of Period

Category Names Names

Category Name LU_Assets_Bk_Cat_Names

Book Assets Category 1
Book Assets Category 2
Book Assets Category 3

403447950.xlsx
Assets_LU Page 107 of 117
Printed: 07:25:13 on 12/01/2018
Assets
Consolidation Example
Go to Table of Contents
çè

Consol Book Intangibles - Lookups

Capital Expenditure Timings Names

Capital Expenditure Timing LU_Intan_Bk_Capex_Timing

Start of Period
Middle of Period
End of Period

Category Names Names

Category Name LU_Intan_Bk_Cat_Names

Book Intangibles Category 1
Book Intangibles Category 2
Book Intangibles Category 3

403447950.xlsx
Assets_LU Page 108 of 117
Printed: 07:25:13 on 12/01/2018
Consol Ordinary Equity - Lookups
Consolidation Example
Go to Table of Contents
çè

Consol Ordinary Equity - Lookups

Dividend Determination MethodsNames

Dividend Determination Method LU_Eq_Ord_Div_Meth

% of Net Profit After Tax
Assume Dividend Amounts

Yes/No Lookup Names

Yes/No LU_Eq_Ord_Yes_No
Yes Eq_Ord_Yes
No Eq_Ord_No

403447950.xlsx
Eq_Ord_LU Page 109 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè

Co. A - Other Income Statement Items - Lookups

Cash Flow Statement Impact Loo Names

Cash Flow Statement Impact LU_OISI_CFS_Impact

Cash Receipts
Cash Payments
Operating Cash Flows
Investing Cash Flows
Financing Cash Flows

Co. B - Other Income Statement Items - Lookups

Cash Flow Statement Impact Loo Names

Cash Flow Statement Impact LU_OISI_2_CFS_Impact

Cash Receipts
Cash Payments
Operating Cash Flows
Investing Cash Flows
Financing Cash Flows

403447950.xlsx
OFSI_LU Page 110 of 117
Printed: 07:25:13 on 12/01/2018
Other Financial Statement Items
Consolidation Example
Go to Table of Contents
çè

Consol Other Balance Sheet - Lookups

Cash Flow Statement Impact Loo Names

Cash Flow Statement Types LU_OBSI_CFS_Impact

Cash Receipts
Cash Payments
Operating Cash Flows
Investing Cash Flows
Financing Cash Flows

403447950.xlsx
OFSI_LU Page 111 of 117
Printed: 07:25:13 on 12/01/2018
Consol Financial Summary - Lookups
Consolidation Example
Go to Table of Contents
çè

Consol Financial Summary - Lookups

First Displayed Periods Names

First Displayed Period LU_FS_Sum_First_Disp_Per

2014
2015
2016
2017
2018

Displayed Periods Names

Displayed Period LU_FS_Sum_Dis_Pers

2014
2015
2016
2017
2018

403447950.xlsx
FS_Sum_LU Page 112 of 117
Printed: 07:25:13 on 12/01/2018
Checks
Consolidation Example
Go to Table of Contents
ç xhO

Error Checks

✘1 Include summary in model name?

Errors Detected - Summary

Total Errors: -
Error Message (Empty if None):

Error Checks

Error Checks Check Include? Flag

Consol Opening Balance Sheet - Yes -

Consol Income Statement - Yes -
Co. A - EBITDA Statement - Yes -
Co. B - EBITDA Statement - Yes -
Consol Balance Sheet - Yes -
Consol Cash Flow Statement - Yes -
Co. A - Revenue - Outputs - Yes -
Co. A - COGS - Outputs - Yes -
Co. A - Salaries - Outputs - Yes -
Co. A - Opex - Outputs - Yes -
Co. B - Revenue - Outputs - Yes -
Co. B - COGS - Outputs - Yes -
Co. B - Salaries - Outputs - Yes -
Co. B - Opex - Outputs - Yes -
Consol Capex - Outputs - Yes -
Consol Intangibles Capex - Outputs - Yes -
Consol Debtors - Summary - Yes -
Consol Inventory - Summary - Yes -
Consol Creditors - Summary - Yes -
Consol Book Assets - Summary - Yes -
Consol Book Intangibles - Summary - Yes -
Consol Debt - Summary - Yes -
Consol Ordinary Equity - Outputs - Yes -
Consol Taxation - Outputs - Yes -
Co. A - Other Income Statement Items - Summary - Yes -

403447950.xlsx
Chks_BO Page 113 of 117
Printed: 07:25:13 on 12/01/2018
Checks
Consolidation Example
Go to Table of Contents
ç xhO

Co. B - Other Income Statement Items - Summary - Yes -

Consol Interest on Cash - Outputs - Yes -
Consol Other Balance Sheet - Summary - Yes -
Consol Financial Summary - Yes -

Total Errors: -

403447950.xlsx
Chks_BO Page 114 of 117
Printed: 07:25:13 on 12/01/2018
Checks
Consolidation Example
Go to Table of Contents
ç xhO

Sensitivity Checks

✘1 Include summary in model name?

Sensitivities Detected - Summary

Total Sensitivities: -
Sensitivity Message (Empty if None):

Sensitivity Checks

Sensitivity Checks Check Include? Flag

Total Sensitivities: -

403447950.xlsx
Chks_BO Page 115 of 117
Printed: 07:25:13 on 12/01/2018
Checks
Consolidation Example
Go to Table of Contents
ç xhO

Alert Checks

✘1 Include summary in model name?

Alerts Detected - Summary

Total Alerts: -
Alert Message (Empty if None):

Alert Checks

Alert Checks Check Include? Flag

Consol Opening Balance Sheet - Yes -

Consol Balance Sheet - Yes -
Co. A - Revenue - Outputs - Yes -
Co. A - COGS - Outputs - Yes -
Co. A - Salaries - Outputs - Yes -
Co. A - Opex - Outputs - Yes -
Co. B - Revenue - Outputs - Yes -
Co. B - COGS - Outputs - Yes -
Co. B - Salaries - Outputs - Yes -
Co. B - Opex - Outputs - Yes -
Consol Capex - Outputs - Yes -
Consol Intangibles Capex - Outputs - Yes -
Consol Debtors - Summary - Yes -
Consol Inventory - Summary - Yes -
Consol Creditors - Summary - Yes -
Consol Book Assets - Summary - Yes -
Consol Book Intangibles - Summary - Yes -
Consol Debt - Summary - Yes -
Consol Ordinary Equity - Outputs - Yes -

Total Alerts: -

403447950.xlsx
Chks_BO Page 116 of 117
Printed: 07:25:13 on 12/01/2018
 Checks
Sub-Section 4.2.
Consolidation Example
Go to Table of Contents
çè

Sub-Section Cover Notes:

Contains the model checks.

403447950.xlsx
Chks_SSC Page 117 of 117
Printed: 07:25:13 on 12/01/2018