Skip to main content

AI assistant

Sign in to chat with this filing

The assistant answers questions, extracts KPIs, and summarises risk factors directly from the filing text.

Columbus Interim / Quarterly Report 2017

Aug 24, 2017

3396_ir_2017-08-24_8d219f6c-5d40-46e3-80ea-3baec0467449.pdf

Interim / Quarterly Report

Open in viewer

Opens in your device viewer

Interim Report H1/2017

Columbus A/S CVR.: 13 22 83 45

Columbus, Lautrupvang 6, DK-2750 Ballerup Phone: +45 70 20 50 00, Fax: +45 70 25 07 01 www.columbusglobal.com, CVR.: 13 22 83 45

Highlights first half 2017

Revenue

DKK 642m

An increase of 8% compared to H1/2016.

EBITDA (before share-based payment)

DKK 71.2m

An increase of 7% compared to H1/2016.

Service revenue

DKK 431m

An increase of 10% compared to H1/2016.

Columbus Software sales

DKK 40.7m

A decrease of 11% compared to H1/2016.

Profit after tax

DKK 40.1m

An increase of 1% compared to H1/2016.

Recurring revenue

DKK 173m

An increase of 16%. In H1/2016 recurring revenue constituted 25% of the total revenue. In H1/2017 recurring revenue constituted 27% of the total revenue.

Contents

Columbus

Key figures and ratios 4
Management's review 5
The Columbus2020 strategy 8
Statement by management 10

Financial Statements

Statement of comprehensive income 12
Balance sheet 13
Statement of changes in equity 15
Cash flow 16
Notes 17

Key figures and ratios

DKK ´000 H1 2017 H1 2016 2016
Income related figures
Columbus licenses 13,571 22,554 44,187
Columbus subscriptions 27,164 23,271 46,876
Columbus Software 40,735 45,825 91,063
External licenses 53,473 47,662 86,495
External subscriptions 106,090 99,776 195,164
Service 431,323 390,778 796,401
Other 10,694 10,496 23,584
Net revenue 642,315 594,537 1,192,707
Recurring revenue % of total revenue 27.0% 25.1% 25.3%
Service EBITDA 47,865 41,812 91,341
EBITDA before share-based payment 71,177 66,754 144,070
EBITDA 70,019 65,663 138,546
EBIT 50,298 50,506 105,271
Profit before tax 46,413 49,867 107,303
Profit after tax 40,084 39,564 81,479
Balance sheet
Non-current assets 588,668 467,478 547,771
Current assets 257,435 270,946 289,735
Total assets 846,103 738,424 837,506
Group shareholder equity 499,848 416,116 469,813
Minority interests 3,379 2,937 1,774
Total liabilities 342,876 319,371 365,919
Total equity and liabilities 846,103 738,424 837,506
Cash flow
Cash flow from operating activities 60,971 52,950 124,708
Cash flow from investing activities -71,593 -43,451 -130,546
Cash flow from financing activities -10,436 -7,509 19,981
Total cash flow -21,058 1,990 14,143
Key ratios
EBITDA-margin 10.9% 11.0% 11.6%
Operating profit margin (EBIT-margin) 7.8% 8.5% 8.8%
Equity ratio 59.1% 56.4% 56.1%
Return on equity 7.7% 9.4% 17.2%
Return on invested capital including goodwill (ROIC) 10.9% 14.8% 25.1%
Number of shares, in thousands 119,866 116,198 116,198
Average number of shares, in thousands 118,319 115,048 115,628
Book value of equity per share (BVPS) 4.17 3.58 4.04
Earnings per share (EPS) 0.33 0.34 0.70
Cash flow per share 0.51 0.45 1.04
Share price, end of period 13.90 8.40 10.70
Average full time employee for the period 1,200 1,088 1,105

The key figures and financial ratios above have been calculated in accordance with the Danish Society of Financial Analysts' "Recommendations and Key Figures 2015",

Management's review

In first half of 2017 revenue increased by 8% to DKK 642m, and EBITDA1 increased by 7% compared to H1 2016. Growth in the services business and cloud are driving the results. Columbus2020 execution is on track.

Growth driven by the services business

In the first half of 2017, revenue amounted to DKK 642m (H1 2016: DKK 595m), an increase of 8%. EBITDA1 amounted to DKK 71.2m (H1 2016: DKK 66.8m), corresponding to an increase of 7%.

The revenue growth was primarily driven by growth in the services business, where revenue increased by 10%. The increase in EBITDA1 was driven by a 14% increase in earnings in the services business.

In line with expectations, Columbus Software licenses revenue declined by 40% due to the cloud conversion, and subscriptions increased by 17%. External licenses revenue grew by 12%, which is mainly due to extraordinary product licenses sales. External subscriptions increased by 6%, mainly due to the acquisition of Tridea Partners LLC.

Profit after tax amounted to DKK 40.1m. The result is negatively affected by currency adjustment on intercompany balances and increased depreciations. Depreciations are increased due to acquisitions and increased software development.

The results are in line with management's expectations.

Cash flow

Cash flow from primary activities amounted to DKK 66.8m, corresponding to an increase of 10% compared to H1 2016.

Columbus2020 execution on track

Columbus' five-year strategy Columbus2020 is based on four interconnected elements that lead customers in the digital transformation of their business.

We are progressing with the execution of our strategic priorities, which include ensuring satisfied customers, increasing our digital leadership position, delivering high quality to our customers, and developing our employees.

During the first half of the year, Columbus has come further in optimizing and improving the customer value chain throughout the company. This includes refined and standardized marketing and sales processes, higher quality in project delivery, improved service delivery management and an enhanced ColumbusCare support portfolio.

Our global loyalty program, Columbus Pulse, has been implemented as an integrated part of operations across the Group. The increased customer loyalty transparency in our key markets, is driving our improved customer focus.

We have applied new ways of working with better customer segmentation and resource optimization. As an example we have increased our focus on key account management. As a result of these efforts, we are starting to see significant improvements in our customer loyalty.

DKK ´000 H1 2017 H1 2016 Development
Columbus Software licenses 13,571 22,554 -40%
Columbus Software subscriptions 27,164 23,271 17%
External licenses 53,473 47,662 12%
External subscriptions 106,090 99,776 6%
Services 431,323 390,778 10%
Other 10,694 10,496 2%
Total net revenue 642,315 594,537 8%

Service EBITDA and development in the services business

Development in sale of Columbus Software

Good progress within Columbus' Value Drivers

In connection with Columbus2020, Columbus has identified three financial value drivers, which measure the development in relation to significant success criteria for future growth and value creation:

  • Improve profits from the services business
  • Scaling of own software sales
  • Growth in recurring revenue

Below, the development in these three financial value drivers are reviewed.

Growth and increased EBITDA in the services business

In the first half of 2017, the services business grew revenue by 10% to DKK 431m (H1 2016: DKK 391m). The growth primarily came from an increase in realized hourly rates and the effect from acquisitions made in 2016 and 2017.

Service EBITDA increased by 14%, from DKK 41.8m to DKK 47.9m. The increase is due to higher realized hourly rates, acquisitions, and increased utilization of Columbus' Global Delivery Center in India.

In the first half of the year, chargeable hours declined from 58% to 54%. The decline is primarily due to a decrease in chargeable hours in the US SMB business. The US SMB market has been affected by a change in technology, leading to a slightly hesitant market causing this decrease. Further, the US SMB business was impacted by a loss of DKK 4m on customer engagements, which had a negative impact on service EBITDA in first half. Due to the challenges in the SMB business, the planned integration of the SMB business and the Enterprise business in the US has been accelerated.

The development is in the lower range of our expectations, but we expect to see an improvement during the next quarters.

Columbus Software sales as expected

Columbus Software sales declined by 11% in the first half of the year. The decline is a consequence of the cloud conversion, where new license terms result in a lower

Development in recurring revenue

up-front revenue from sale of software licenses.

License sales decreased by 40% due to the cloud conversion as mentioned above. Revenue from subscriptions increased by 17% due to a satisfactory renewal rate of previous years' sale of licenses.

Columbus Cloud revenue grew DKK 1.6m. which is in line with expectations.

The total sale of Columbus Software is in line with expectations, where the cloud effect causes the temporary decrease in software revenue.

Growth in recurring revenue

The recurring revenue includes Columbus and third party Cloud revenue, Columbus and third party software subscriptions, hosting revenue and ColumbusCare contracts revenue.

In the first half of 2017, the recurring revenue increased by 16%, constituting 27% of total revenue (H1 2016: 25%).

The progress is driven by a significant growth in the sale of ColumbusCare contracts, which increased by 67%, as well as the emergence of cloud revenue amounting to DKK 5.5m.

The development is satisfactory and according to plan.

Acquisitions in 2017

In January 2017 Columbus acquired the US IT services company, Tridea Partners LLC, which holds a leading positon within ERP and CRM in the growing food and beverage industry in the US.

The integration of Tridea Partners LLC into our US subsidiary is progressing as planned.

Columbus maintains expectations to 2017

Columbus maintains the announced expectations to 2017:

  • Revenue in the level of DKK 1.35bn.
  • EBITDA2 in the level of DKK 150m.
  • Columbus Software revenue of DKK 80m.
  • Service EBITDA of DKK 140m.
  • 10% dividend on nominal share capital

Columbus' new strategy is built around three value drivers:

The Columbus2020 strategy

Improve profitability in the services business

As, the services business is our largest in the services business is very effectful. We will deliver higher productivity and delivery, minimize risk and control cost.

Scaling of own software sales

Columbus Software generates high earnings while creating high value for customers. We will grow our software sales within Columbus Software licenses, subscriptions and cloud solutions.

Recurring service revenue and cloud revenue

We will increase the recurring service revenue in order to improve predictability and profitability. The recurring revenue consists of Columbus Software and third party software subscriptions, cloud revenue and ColumbusCare revenue. All revenue categories are based on a long cooperation with customers where Columbus becomes the strategic business partner.

Columbus2020 – embracing the digital economy

Columbus' strategy is based on four interconnected elements that lead our customers in the digital transformation of their business. In the following, we explain the different strategic elements.

Customer Success – Taking care of our customers for life

Columbus aims to be widely recognized as a business the value realization of their ERP investments.

Therefore, we focus on creating a unique customer and project delivery throughout our business.

Taking care of our customers is a fundamental goal for Columbus. An important foundation for reaching that goal is our lifetime support offering, ColumbusCare, which ensures our customers high quality support around the clock. During our strategic journey, we extend the ColumbusCare offering

Digital Leadership – Accelerate business innovation

Columbus helps our customers accelerate business innovation by maximizing the value realization of ERP and by leading them in the digital business transformation. Digital Leadership comprises two different, yet closely connected types of innovation:

Columbus will continue to strengthen our leadership position within ERP. This means that we invest in new business applications, new methodologies and new business processes to make the experience of buying and implementing ERP and other business applications from Columbus faster, better, less risky and with high returns.

Columbus extend our business and builds a new leadership position in digital business transformation. Our customers are seeking a business partner that is able to lead them in the digital transformation of their business. Columbus wants to be that partner. We will build a leadership position using cloud, social, analytics and IoT (Internet of Things) technologies and business models, to enable our customers to take advantage of the digital opportunities.

Process Excellence – Quality in everything we do

In Columbus, we constantly strive to optimize and streamline the business operations in order to achieve global sales excellence and deliver high quality services to our customers. Our goal is to create the best customer experience, when engaging with Columbus.

The focal point is quality in everything we do – from the initial contact with customers, over sales and design of

the business solution to the implementation process and lifetime support engagement. We want to be best in class in ensuring the value realization of the project and manage the inherent risks in the implementation. In order to reach that goal, we continuously optimize our sales, services and support delivery capabilities – always striving to improve the quality.

Our People – Attract, develop and retain the best people

Columbus is a people business. Our greatest asset is our people and therefore it is crucial for our success that we attract and retain the best people in the industry. We want Columbus to be a company attracting highly skilled people to join, because it is the best place for competence development. We will achieve this goal by providing challenging career opportunities, attractive working conditions and professional and personal growth.

Furthermore, we want to create a customer success culture, where meeting the customers' expectation for high quality sets the direction in everything we do. This means that we always strive to deliver projects on time, within budget and at the highest quality.

Statement by management

We have today considered and approved the interim financial report for the period 1 January 2017 – 30 June 2017 for Columbus A/S.

The interim financial report has been prepared in accordance with IAS 34 and additional Danish interim reporting requirements for listed companies. The interim financial report is unaudited and has not been reviewed by the Company's auditor.

We consider the accounting policies applied to be appropriate to the effect that the interim financial report gives a true and fair view of the Group's assets, liabilities and financial position at 30 June 2017, and of the results of the Group's operations and cash flows during the first half of 2017.

We consider the management report to give a true and fair view of the development in the Group's business activities and financial situation, the financial result for the period and the Group's financial position as a whole together with a true and fair description of the significant risks and uncertainty factors which the Group faces.

Ballerup, 24 August 2017

Executive Board

Thomas Honoré CEO & President

Hans Henrik Thrane

Board of Directors

Ib Kunøe

Chairman

Jørgen Cadovius Deputy Chairman

Corporate CFO

Peter Skov Hansen Sven Madsen

Financial Statements H1/2017

Statement of comprehensive income

DKK ´000 Note H1 2017 H1 2016 2016
Net revenue 3 642,315 594,537 1,192,707
External project costs -142,856 -134,735 -264,601
Gross profit 499,459 459,802 928,106
Staff expenses and remuneration 4 -353,416 -319,932 -631,675
Other external costs -74,916 -73,340 -158,982
Other operating income 50 546 6,685
Other operating costs 0 -322 -64
EBITDA before share-based payment 71,177 66,754 144,070
Share-based payment 4 -1,158 -1,091 -5,524
EBITDA 70,019 65,663 138,546
Depreciation -19,721 -15,157 -33,275
Operating profit (EBIT) 50,298 50,506 105,271
Financial income 18 99 2,674
Financial expense -3,903 -738 -642
Profit before tax 46,413 49,867 107,303
Corporate tax -6,329 -10,303 -25,824
Profit after tax 40,084 39,564 81,479
Items that may
be reclassified subsequently to profit and loss:
Foreign exchange adjustments of subsidiaries -14,027 -3,031 4,521
Other comprehensive income -14,027 -3,031 4,521
Total income for the period 26,057 36,533 86,000
Allocated to:
Shareholders in Columbus A/S
38,731 39,192 80,902
Minority interests 1,353 372 577
40,084 39,564 81,479
Total comprehensive income allocated to:
Shareholders Columbus A/S 24,703 36,169 85,433
Minority interests 1,354 364 567
26,057 36,533 86,000
Earnings per share of DKK 1.25 (EPS) 0.33 0.34 0.70
Earnings per share of DKK 1.25, diluted (EPS-D) 0.32 0.33 0.68

Balance sheet

DKK ´000 Note H1 2017 H1 2016 2016
ASSETS
Goodwill 449,358 341,954 415,152
Customer base 31,496 29,303 30,562
License rights 15 0 17
Development projects finalized 62,721 53,656 59,354
Development projects in progress 8,716 9,442 8,491
Property, plant and equipment 14,575 15,649 17,142
Deferred tax assets 21,786 17,474 17,053
Total non-current assets 588,668 467,478 547,771
Inventories 233 522 205
Trade receivables 5 142,289 145,029 151,475
Contract work in progress 6 8,709 12,652 8,994
Corporate tax receivables 4,133 307 11,531
Deferred tax assets 3,400 7,500 7,500
Other receivables 10,178 12,331 8,155
Prepayments 14,776 9,241 7,206
Receivables 183,485 187,060 194,861
Cash 73,717 83,365 94,669
Total current assets 257,435 270,946 289,735
TOTAL ASSETS 846,103 738,424 837,506

Balance sheet

DKK ´000
Note
H1 2017 H1 2016 2016
EQUITY AND LIABILITIES
Share capital 149,832 145,247 145,247
Reserves on foreign currency translation -20,503 -14,029 -6,475
Retained profit 370,519 284,898 331,041
Group shareholders' equity 499,848 416,116 469,813
Minority interests 3,379 2,937 1,774
Equity 503,227 419,053 471,587
Deferred tax 11,198 6,425 10,614
Provisions 16,887 10,967 11,532
Non-current liabilities 28,085 17,392 22,146
Debt to credit institutions 14,345 235 29,091
Client prepayments 19,618 34,638 33,645
Trade payables 72,363 57,734 66,211
Corporate tax payables 17,967 12,465 24,177
Other liabilities 143,614 162,879 157,228
Accruals 46,884 34,028 33,421
Current liabilities 314,791 301,979 343,773
Total liabilities 342,876 319,371 365,919
TOTAL EQUITY AND LIABILITIES 846,103 738,424 837,506

Statement of changes in equity

Shareholders in Columbus A/S
Reserves on
foreign
currency Retained Minority
DKK ´000 Share capital translation profits interests Equity
H1 2017
Balance at 1 January 2017 145,247 -6,475 331,041 1,774 471,587
Profit after tax 0 0 38,731 1,353 40,084
Currency adjustments of investments in subsidiaries 0 -14,028 0 1 -14,027
Total comprehensive income 0 -14,028 38,731 1,354 26,057
Capital increase 4,585 0 14,572 251 19,408
Share-based payment cf. note 4 0 0 1,158 0 1,158
Payment of dividend 0 0 -14,983 0 -14,983
Balance at 30 June 2017 149,832 -20,503 370,519 3,379 503,227
H1 2016
Balance at 1 January 2016 142,123 -11,006 255,062 2,573 388,752
Profit after tax 0 0 39,192 372 39,564
Currency adjustments of investments in subsidiaries 0 -3,023 0 -8 -3,031
Total comprehensive income 0 -3,023 39,192 364 36,533
Capital increase 3,124 0 4,079 0 7,203
Share-based payment, cf. note 4 0 0 1,091 0 1,091
Payment of dividend 0 0 -14,526 0 -14,526
Balance at 30 June 2016 145,247 -14,029 284,898 2,937 419,053
2016
Balance at 1 January 2016 142,123 -11,006 255,062 2,573 388,752
Profit after tax 0 0 80,902 577 81,479
Currency adjustments of investments in subsidiaries 0 4,531 0 -10 4,521
Total comprehensive income 0 4,531 80,902 567 86,000
Capital increase 3,124 0 4,079 0 7,203
Share-based payment, cf. note 4 0 0 5,524 0 5,524
Payment of dividend 0 0 -14,526 -1,366 -15,892
Balance at 31 December 2016 145,247 -6,475 331,041 1,774 471,587

Cash flow

DKK ´000 Note H1 2017 H1 2016 2016
Operating profit (EBIT) 50,298 50,506 105,271
Non-recurring income and expenses from acquisitions 0 0 -5,594
Depreciations and amortizations 19,721 15,157 33,275
Cost of incentive scheme 4 1,158 1,091 5,524
Changes in net working capital -4,410 -6,098 3,415
Cash flow from primary activities 66,767 60,656 141,891
Interest received, etc. 18 406 1,904
Interest paid, etc. -625 -612 -642
Corporate tax paid -5,189 -7,500 -18,445
Cash flow from operating activities 60,971 52,950 124,708
Net increase in development projects -15,714 -12,855 -28,260
Acquisition of tangible assets -2,360 -4,415 -8,799
Acquisition of intangible assets -7 -43 -166
Disposal of tangible assets 212 16 335
Disposal of intangible assets 0 0 388
Acquisition of subsidiaries and activities -53,724 -26,154 -94,044
Cash flow from investing activities -71,593 -43,451 -130,546
Proceeds from capital increase/warrants exercised 19,292 7,203 7,203
Overdraft facilities -14,745 -186 28,670
Dividends paid -14,983 -14,526 -15,892
Cash flow from financing activities -10,436 -7,509 19,981
Total cash flow -21,058 1,990 14,143
Cash funds at the beginning of the year 94,669 82,294 82,294
Exchange rate adjustments 106 -919 -1,768
Cash funds at the end of the period 73,717 83,365 94,669

Note Side Note 1 – Accounting Policies 18 Note 2 - Segment data 19 Note 3 - Net revenue 22 Note 4 - Staff expenses and remuneration 23 Note 5 - Trade receivables 23 Note 6 – Contract work in progress 23 Note 7 – Business combinations 24

18

Note 1 – Accounting Policies

The consolidated interim financial report is prepared in accordance with IAS 34, Presentation of Interim Financial Reporting, as approved by the EU. The interim financial report is presented in Danish kroner (DKK), which is the Parent Company's functional currency.

The accounting policies applied in the interim financial report are prepared in accordance with International Financial Reporting Standards, as approved by the EU, and additional Danish disclosure requirements for interim financial reports of listed companies and is unchanged compared to 2016. For more information on the accounting policies, we refer to our Annual Report for 2016.

19

Notes

Note 2 - Segment data

In order to support decisions about allocation of resources and assessment of performance of the segments, the Group's internal reporting to the Board of Directors of the Parent Company is based on the following grouping of operating segments:

Strategic business areas Description Geographical segment
ISV (Independent Software Vendor) Development and sale of industry-specific
software within Columbus' three focus
industries: Retail, food and manufacturing
No specific area
Consultancy Sale, implementation and service of standard
business systems.
Western Europe
Eastern Europe
North America

Information about the Group's segments is stated below.

Consultancy
Western Eastern North HQ, GDC and
DKK ´000 ISV Europe Europe America Eliminations Total
H1 2017
Columbus Software licenses 11,749 7,095 1,625 512 -7,410 13,571
Columbus Software subscriptions 21,261 8,672 858 2,451 -6,078 27,164
External licenses 0 23,822 9,330 20,469 -148 53,473
External subscriptions 0 34,145 14,286 57,720 -61 106,090
Services 8,878 231,790 50,306 149,026 -8,677 431,323
Other 352 4,797 982 5,080 -517 10,694
Total net revenue 42,240 310,321 77,387 235,258 -22,891 642,315
Gross profit 36,055 234,636 56,615 159,449 12,704 499,459
EBITDA 21,287 44,594 8,472 5,750 -10,084 70,019
Operating profit (EBIT) 7,492 28,817 6,494 -5,645 13,140 50,298
Profit before tax 6,849 28,842 6,836 -9,105 12,991 46,413
Profit after tax 5,548 26,116 5,910 -7,779 10,289 40,084
Segment assets 135,806 387,439 87,205 343,879 -108,226 846,103
Segment liabilities 55,212 99,241 32,080 84,768 71,575 342,876
Non-current assets 109,722 223,961 41,080 303,064 -89,159 588,668
Asset investments 14,489 2,181 484 462 463 18,079
Depreciation -11,877 -4,496 -201 -2,851 -296 -19,721
Average number of employees 87 524 282 277 30 1,200

In order to be able to estimate the results of the segments and allocate resources between these, the Board of Directors also monitors the tangible, intangible and financial assets related to each segment.

Note 2 - Segment data continued

Consultancy
Western Eastern North HQ, GDC and
DKK ´000 ISV Europe Europe America Eliminations Total
H1 2016
Columbus Software licenses 18,412 7,959 1,544 1,980 -7,341 22,554
Columbus Software subscriptions 18,261 7,605 823 2,744 -6,162 23,271
External licenses 0 15,943 5,688 26,233 -202 47,662
External subscriptions 0 35,082 12,427 52,644 -377 99,776
Services 7,016 229,909 43,768 121,815 -11,730 390,778
Other 278 5,109 969 4,019 121 10,496
Total net revenue 43,967 301,607 65,219 209,435 -25,691 594,537
Gross profit 39,068 228,046 48,369 135,449 8,870 459,802
EBITDA 23,085 40,397 6,016 12,455 -16,290 65,663
Operating profit (EBIT) 9,253 25,714 2,423 4,573 8,543 50,506
Profit before tax 8,968 25,971 2,291 2,164 10,473 49,867
Profit after tax 7,481 22,041 -207 2,150 8,099 39,564
Segment assets 121,419 327,423 79,720 282,221 -72,359 738,424
Segment liabilities 37,836 103,984 29,365 67,942 80,244 319,371
Non-current assets 102,458 163,097 37,013 218,875 -53,965 467,478
Asset investments 12,982 3,663 172 574 74 17,465
Depreciation -9,271 -3,187 -237 -2,262 -200 -15,157
Average number of employees 77 471 273 240 27 1,088

In order to be able to estimate the results of the segments and allocate resources between these, the Board of Directors also monitors the tangible, intangible and financial assets related to each segment.

Note 2 - Segment data continued

Consultancy
Western Eastern North HQ, GDC and
DKK ´000 ISV Europe Europe America Eliminations Total
2016
Columbus licenses 37,141 14,847 2,541 3,319 -13,661 44,187
Columbus subscriptions 40,961 14,407 1,350 6,182 -16,024 46,876
External licenses 0 24,875 11,825 50,269 -474 86,495
External subscriptions 0 70,018 23,179 103,288 -1,321 195,164
Services 14,215 452,383 92,833 261,584 -24,614 796,401
Other 1,156 10,504 1,697 9,967 260 23,584
Total net revenue 93,473 587,034 133,425 434,609 -55,834 1,192,707
Gross profit 82,560 438,489 100,383 286,782 19,892 928,106
EBITDA 49,604 89,395 11,560 25,263 -37,276 138,546
Operating result (EBIT) 25,851 59,351 6,074 15,929 -1,934 105,271
Profit before tax 26,529 59,983 5,325 10,521 4,945 107,303
Profit after tax 20,809 42,621 3,178 8,744 6,127 81,479
Segment assets 132,040 373,474 81,357 334,100 -83,465 837,506
Segment liabilities 44,492 155,787 32,101 77,655 55,884 365,919
Non-current assets 107,089 228,740 37,067 269,431 -94,556 547,771
Capital investments 27,959 6,081 402 1,755 1,028 37,225
Depreciation -19,586 -8,112 -481 -4,757 -339 -33,275
Average number of employees 80 468 277 251 29 1,105

In order to be able to estimate the results of the segments and allocate resources between these, the Board of Directors also monitors the tangible, intangible and financial assets related to each segment.

Revenue and long-term assets distributed in geographic areas

The Group's revenue from external customers and non-current assets distribution in geographical areas are specified below. Revenue is distributed according to the registered address of the customers, and the non-current assets are distributed according to location and legal relation.

Net revenue from external customers Non-current assets
DKK ´000 H1 2017 H1 2016 2016 H1 2017 H1 2016 2016
Denmark 168,317 174,247 333,592 110,928 143,996 103,218
Norway 32,746 29,869 58,363 7,852 7,837 8,398
United Kingdom 102,765 88,747 176,136 85,116 22,444 87,380
USA 234,507 208,071 431,939 295,532 211,343 261,899
Russia 37,111 29,399 61,739 203 21 366
The rest of the world 66,869 64,204 130,938 89,037 81,837 86,509
Total 642,315 594,537 1,192,707 588,668 467,478 547,771

Note 3 - Net revenue

DKK ´000 H1 2017 H1 2016 2016
Sale of products
Columbus Software licenses 13,571 22,554 44,187
Columbus Software subscriptions 27,164 23,271 46,876
External licenses 53,473 47,662 86,495
External subscriptions 106,090 99,776 195,164
Total sale of products 200,298 193,263 372,722
Sale of services
Sales value of finished projects 466,632 374,455 789,496
Change in contract work in progress -35,309 16,323 6,905
Other services 10,694 10,496 23,584
Total sale of services 442,017 401,274 819,985
Total net revenue 642,315 594,537 1,192,707
Contract work in progress, beginning of period -59,380 -52,475 -52,475
Contract work in progress, end of period 24,071 68,798 59,380
Total change in contract work in progress -35,309 16,323 6,905

Note 4 - Staff expenses and remuneration

DKK ´000 H1 2017 H1 2016 2016
Staff expenses
Salary and wages 310,869 272,725 564,857
Other social security costs 23,712 28,677 44,084
Other staff expenses 18,835 18,530 22,734
Staff costs before share-based payment 353,416 319,932 631,675
Share-based payment 1,158 1,091 5,524
Staff expenses 354,574 321,023 637,199
Average number of employees 1,200 1,088 1,105

Note 5 - Trade receivables

DKK ´000 H1 2017 H1 2016 2016
Receivables (gross) at 30 June 152,966 150,559 167,941
Provisions for bad debt at 1 January 16,466 6,991 6,991
Change in provisions for bad debt during the period -2,290 563 15,151
Loss realized during the period -3,499 -2,024 -5,676
Provisions for bad debt 30 June 10,677 5,530 16,466
Carrying amount at 30 June 142,289 145,029 151,475

Provisions for bad debt are made if it is assessed that the individual debtor's ability to pay is reduced, e.g. in the event of administrative orders, insolvency, etc.

Note 6 – Contract work in progress

DKK ´000 H1 2017 H1 2016 2016
Contract work in progress 24,071 68,798 59,380
On account billing and prepayments -23,781 -69,060 -60,232
290 -262 -852
The net value is included in the balance as follows:
Contract work in progress (assets) 8,709 12,652 8,994
Client prepayments (liabilities) -8,419 -12,914 -9,846
290 -262 -852

Note 7 – Business combinations

Acquisition of companies in 2017

As of 9 January 2017 the Group acquired 100% of the shares in Tridea Partners LLC.

Name Primary activity Date of
control
gained
Acquired
ownership
Acquired
voting rights
Total
consideration
DKK '000
Tridea Partners LLC Distribution and implementation of
standardised business solutions.
9 January 100% 100% 60,381
Total 60,381

The acquisition of Tridea Partners LLC will strengthen Columbus' coast-to-coast reach in US market and underlines the goal of being recognized as a strategic business partner that leads customers in the digital business transformation.

Tridea
DKK ´000 Partners LLC Total
Other intangible assets 5,532 5,532
Total non-current assets 5,532 5,532
Trade receivables 3,727 3,727
Other receivables 655 655
Cash 4,543 4,543
Total current assets 8,925 8,925
Trade payables -1,425 -1,425
Other debt -3,824 -3,824
Total current debt -5,249 -5,249
Net assets acquired 9,209 9,209
Goodwill 51,172 51,172
Total consideration 60,381 60,381
Acquired cash funds -4,543 -4,543
Contingent consideration -13,837 -13,837
Cash consideration on acquisition date 42,001 42,001

After recognition of identifiable assets, liabilities and contingent liabilities at fair value, goodwill in relation to the acquisition was assessed to DKK 51.1m.

Estimated tax deductibility on goodwill for the Tridea Partners LLC acquisition is DKK 42.9m. Goodwill is for tax purposes amortized over 15 years.

Contingent consideration for Tridea Partners LLC is DKK 13.8m. The contingent consideration is determined by certain contribution thresholds in 2017 and 2018 for the combined business and by certain staff retention. The consideration is recognized as if these thresholds will be met.

Tridea
DKK ´000 Partners LLC Total
Fair value assessment of trade receivables
Trade receivables, gross amount 3,727 3,727
Trade receivables, not expected to be collected 0 0
Trade receivables, fair value 3,727 3,727

25

Notes

Note 7 – Business combinations continued

Acquisition of companies in 2016

The Group has per 1 February 2016 acquired 100% shares in SystemHosting A/S and per 15 July 2016 acquired 100% assets in Client Strategy Group LLC. Furthermore, the Group acquired 100% shares in Cambridge Online Systems Ltd. per 1 December 2016.

Name Primary activity Date of
control
gained
Acquired
ownership
Acquired
voting rights
Total
consideration
DKK '000
Distribution, implementation and hosting of
SystemHosting A/S standardised business solutions. 1 February 100% 100% 40,600
Client Strategy Distribution and implementation of
Group LLC standardised business solutions. 15 July 100% 100% 43,662
Cambridge Online Distribution and implementation of
Systems Ltd standardised business solutions. 1 December 100% 100% 37,425
Total 121,687

The acquisition of SystemHosting A/S will strengthen Columbus' global position as an innovative solution provider.

The acquisition of Client Strategy Group LLC strengthens Columbus' coast-to-coast reach in the US market and underlines the goal of being recognized as a strategic business partner that leads customers in the digital business transformation.

The acquisition of Cambridge Online Systems Ltd. strengthens Columbus' position and growth potential in the Microsoft Dynamics 365 market.

Cambridge Client
Online Strategy SystemHosting
DKK ´000 Systems Ltd. Group LLC A/S Total
Development projects, finalized 0 0 878 878
Other intangible assets 2,605 1,339 10,000 13,943
Operating equipment 1,467 0 2,573 4,040
Total non-current assets 4,072 1,339 13,451 18,862
Trade receivables 10,437 2,112 5,873 18,422
Other receivables 2,179 123 780 3,083
Cash 13,450 2,479 2,518 18,447
Total current assets 26,067 4,714 9,171 39,952
Trade payables -1,337 0 -870 -2,207
Corporation tax and deferred tax -521 0 -2,736 -3,257
Other debt -15,187 -1,207 -7,824 -24,217
Total current debt -17,045 -1,207 -11,430 -29,682
Net assets acquired 13,094 4,846 11,192 29,132
Goodwill 24,330 38,817 29,407 92,554
Total consideration 37,425 43,662 40,600 121,686
Acquired cash funds -13,450 -2,479 -2,518 -18,447
Contingent consideration -4,125 -8,700 -19,000 -31,825
Cash consideration on acquisition date 19,850 32,483 19,082 71,414

Note 7 – Business combinations continued

After recognition of identifiable assets, liabilities and contingent liabilities at fair value, goodwill in relation to the acquisitions were assessed to DKK 93m. The goodwill represents the value of assets where the fair value cannot be measured reliably, the value of the acquired staff and knowhow, expected synergies from the merger of acquired company and the existing activities in Columbus as well as the value of access to new markets.

Estimated tax deductibility on goodwill for the Client Strategy Group LLC acquisition is DKK 31.6m. Goodwill is for tax purposes amortized over 15 years.

Contingent consideration for SystemHosting A/S is DKK 19m. The contingent consideration is determined by certain revenue and EBITDA thresholds in 2016 and 2017 for the combined business. The consideration is recognized as if these thresholds will be met.

Contingent consideration for Client Strategy Group is DKK 8.7m. The contingent consideration is determined by ColumbusCare contribution thresholds in 2016, 2017 and 2018 for the combined business. The consideration is recognized as if these thresholds will be met.

Contingent consideration for Cambridge Online Systems Ltd. is 4.1m. The contingent consideration is determined by certain staff retention and certain revenue criteria for 2017 and 2018. The consideration is recognized as if these thresholds will be met.

Changes to contingent considerations as a result of post-acquisition events during 2016 is recognized according to IFRS 3 as other income.

DKK ´000 Cambridge
Online
Systems Ltd.
Client
Strategy
Group LLC
SystemHosting
A/S
Total
Fair value assessment of trade receivables
Trade receivables, gross amount 11,471 2,112 5,873 19,456
Trade receivables, not expected to be collected -1,033 0 0 -1,033
Trade receivables, fair value 10,437 2,112 5,873 18,422

SystemHosting A/S, Client Strategy Group LLC and Cambridge Online Systems Ltd have been implemented completely in business and in the books, and a separation of the business is impracticable. The amount of revenue and profit or loss, for the period from the acquisition date as well as proforma figures for the year 2016 has consequently not been stated.

For more information on Columbus, visit www.columbusglobal.com