Spreadsheet: 173834d1344800364-tricky-formatting-in-an-export-file-amadeus-amec-plc
Sheet: Sheet2

Balance sheet
Consolidated |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31/12/2010 |  |  |  |  | 31/12/2009 |  |  |  |  |  |  | 31/12/2008 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 31/12/2006 |  |  |  | 31/12/2005 |  |  | 31/12/2004 |  |  | 31/12/2003 |  |  | 31/12/2002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | mil EUR |  |  |  |  | mil EUR |  |  |  |  |  |  | mil EUR |  |  |  |  |  |  |  |  |  |  |  |  | mil EUR |  |  |  |  |  |  | mil EUR |  |  |  | mil EUR |  |  | mil EUR |  |  | mil EUR |  |  | mil EUR
Exchange rate: EUR/GBP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 months |  |  |  |  | 12 months |  |  |  |  |  |  | 12 months |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 months |  |  |  |  | 12 months |  |  |  | 12 months |  |  | 12 months |  |  | 12 months |  |  | 12 months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IFRS |  |  |  |  | IFRS |  |  |  |  |  |  | IFRS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IFRS |  |  |  |  | IFRS |  |  |  | IFRS |  |  | Local GAAP |  |  | Local GAAP |  |  | Local GAAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.17058 |  |  |  |  | 1.12418 |  |  |  |  |  |  | 1.04750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.36091 |  |  |  |  | 1.49175 |  |  |  | 1.45961 |  |  | 1.41795 |  |  | 1.41312 |  |  | 1.53695
Assets
Fixed assets |  |  |  |  |  |  |  |  |  |  |  | 1225.98238274851 |  |  | 891.1617783667682 |  |  |  |  |  | 719.2523969285963 |  |  |  |  |  |  | 658.2468496079435 |  |  |  |  |  |  |  |  |  |  |  | 714.6163708013968 |  |  |  |  |  |  |  | 714.5475345448317 |  |  |  | 1306.79118975126 |  |  | 909.4758552479403 |  |  | 921.6355237129585 |  |  | 608.1706373702029
- Intangible fixed assets |  |  |  |  |  |  |  |  |  |  |  | 1013.287583402278 |  |  | 727.2807210025918 |  |  |  |  |  | 510.8288358305005 |  |  |  |  |  |  | 406.5334219173184 |  |  |  |  |  |  |  |  |  |  |  | 304.5727362128216 |  |  |  |  |  |  |  | 294.7695048560726 |  |  |  | 697.548877004498 |  |  | 483.8059897265314 |  |  | 483.4276489760857 |  |  | 204.8752741001973
- Tangible fixed assets |  |  |  |  |  |  |  |  |  |  |  | 41.82201110740532 |  |  | 37.34146949940879 |  |  |  |  |  | 49.57647812527524 |  |  |  |  |  |  | 53.00332684621569 |  |  |  |  |  |  |  |  |  |  |  | 78.38869350249563 |  |  |  |  |  |  |  | 109.3451655159419 |  |  |  | 231.0566797024734 |  |  | 265.2992399702052 |  |  | 292.5154146099086 |  |  | 231.3107933389324
- Other fixed assets |  |  |  |  |  |  |  |  |  |  |  | 170.8727882388275 |  |  | 126.5395878647677 |  |  |  |  |  | 158.8470829728207 |  |  |  |  |  |  | 198.7101008444094 |  |  |  |  |  |  |  |  |  |  |  | 331.6549410860796 |  |  |  |  |  |  |  | 310.4328641728173 |  |  |  | 378.1856330442884 |  |  | 160.3706255512037 |  |  | 145.6924601269641 |  |  | 171.9845699310733
Current assets |  |  |  |  |  |  |  |  |  |  |  | 1669.295700487007 |  |  | 1684.4631539075 |  |  |  |  |  | 1426.363615540799 |  |  |  |  |  |  | 1531.335247361319 |  |  |  |  |  |  |  |  |  |  |  | 1757.89367008982 |  |  |  |  |  |  |  | 2007.147615302862 |  |  |  | 3372.726909592579 |  |  | 3259.451431958903 |  |  | 3262.889334948208 |  |  | 1895.672641224181
- Stock |  |  |  |  |  |  |  |  |  |  |  | 4.779658412274894 |  |  | 1.638810573641765 |  |  |  |  |  | 6.070589158196968 |  |  |  |  |  |  | 12.25570996246489 |  |  |  |  |  |  |  |  |  |  |  | 8.301580388285128 |  |  |  |  |  |  |  | 71.15640375321183 |  |  |  | 107.7194122681146 |  |  | 129.601018349956 |  |  | 144.1380303874912 |  |  | 132.9460705901505
- Debtors |  |  |  |  |  |  |  |  |  |  |  | 915.3045859506423 |  |  | 754.0869796714464 |  |  |  |  |  | 514.763476951554 |  |  |  |  |  |  | 653.7426143225931 |  |  |  |  |  |  |  |  |  |  |  | 637.8607750802031 |  |  |  |  |  |  |  | 647.2696769081472 |  |  |  | 1893.263545433217 |  |  | 1754.151201320903 |  |  | 1685.425772972164 |  |  | 771.8556838193479
- Other current assets |  |  |  |  |  |  |  |  |  |  |  | 749.2114561240896 |  |  | 928.7373636624116 |  |  |  |  |  | 905.5295494310477 |  |  |  |  |  |  | 865.3369230762605 |  |  |  |  |  |  |  |  |  |  |  | 1111.731314621331 |  |  |  |  |  |  |  | 1288.721534641503 |  |  |  | 1371.743951891247 |  |  | 1375.699212288044 |  |  | 1433.325531588552 |  |  | 990.8708868146824
* Cash & cash equivalent |  |  |  |  |  |  |  |  |  |  |  | 622.5505081988049 |  |  | 866.3455039659073 |  |  |  |  |  | 688.0001045956564 |  |  |  |  |  |  | 800.9158835299708 |  |  |  |  |  |  |  |  |  |  |  | 999.0475677114938 |  |  |  |  |  |  |  | 560.0023892862836 |  |  |  | 513.6376853272292 |  |  | 424.6772975471752 |  |  | 515.5054263270274 |  |  | 373.0174720488963
TOTAL ASSETS |  |  |  |  |  |  |  |  |  |  |  | 2895.278083235517 |  |  | 2575.624932274268 |  |  |  |  |  | 2145.616012469395 |  |  |  |  |  |  | 2189.582096969262 |  |  |  |  |  |  |  |  |  |  |  | 2472.510040891216 |  |  |  |  |  |  |  | 2721.695149847694 |  |  |  | 4679.518099343839 |  |  | 4168.927287206843 |  |  | 4184.524858661166 |  |  | 2503.843278594384
Liabilities & Equity
Shareholders funds |  |  |  |  |  |  |  |  |  |  |  | 1641.812664616426 |  |  | 1492.488200995179 |  |  |  |  |  | 1153.749195010657 |  |  |  |  |  |  | 1035.555116999384 |  |  |  |  |  |  |  |  |  |  |  | 1215.841298179333 |  |  |  |  |  |  |  | 738.1171609452667 |  |  |  | 471.3089189888101 |  |  | 380.1535341315447 |  |  | 387.9008758957484 |  |  | 389.7702138920482
- Capital |  |  |  |  |  |  |  |  |  |  |  | 201.9405679186143 |  |  | 197.8278478181845 |  |  |  |  |  | 189.9869569880162 |  |  |  |  |  |  | 177.0269216800484 |  |  |  |  |  |  |  |  |  |  |  | 229.5863297547051 |  |  |  |  |  |  |  | 248.823650860288 |  |  |  | 242.8795420245835 |  |  | 214.1110915847194 |  |  | 211.4024445683204 |  |  | 229.7738445459827
- Other shareholders funds |  |  |  |  |  |  |  |  |  |  |  | 1439.872096697812 |  |  | 1294.660353176994 |  |  |  |  |  | 963.7622380226409 |  |  |  |  |  |  | 858.5281953193355 |  |  |  |  |  |  |  |  |  |  |  | 986.2549684246283 |  |  |  |  |  |  |  | 489.2935100849787 |  |  |  | 228.4293769642267 |  |  | 166.0424425468254 |  |  | 176.498431327428 |  |  | 159.9963693460655
Non-current liabilities |  |  |  |  |  |  |  |  |  |  |  | 264.0761272781879 |  |  | 209.6506955280286 |  |  |  |  |  | 250.8052668877303 |  |  |  |  |  |  | 289.2138051826117 |  |  |  |  |  |  |  |  |  |  |  | 294.7741495250096 |  |  |  |  |  |  |  | 316.8473827501509 |  |  |  | 1133.973054079921 |  |  | 998.0979958045295 |  |  | 910.8958273311455 |  |  | 539.3153314460557
- Long term debt |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0.1047496577988452 |  |  |  |  |  |  |  |  |  |  |  | 0.136091481775166 |  |  |  |  |  |  |  | 10.29306469386083 |  |  |  | 814.9017326461837 |  |  | 761.7250225119949 |  |  | 668.5460997678636 |  |  | 379.3189620999901
- Other non-current liabilities |  |  |  |  |  |  |  |  |  |  |  | 264.0761272781879 |  |  | 209.6506955280286 |  |  |  |  |  | 250.8052668877303 |  |  |  |  |  |  | 289.1090555248128 |  |  |  |  |  |  |  |  |  |  |  | 294.6380580432345 |  |  |  |  |  |  |  | 306.55431805629 |  |  |  | 319.0713214337378 |  |  | 236.3729732925345 |  |  | 242.3497275632818 |  |  | 159.9963693460655
* Provisions |  |  |  |  |  |  |  |  |  |  |  | 201.9405679186143 |  |  | 219.0153273774101 |  |  |  |  |  | 202.8026452108765 |  |  |  |  |  |  | 214.0035508830408 |  |  |  |  |  |  |  |  |  |  |  | 271.3664146596811 |  |  |  |  |  |  |  | 274.6309000202579 |  |  |  | 110.4926762695972 |  |  | 84.79366408454447 |  |  | 80.97165824709064 |  |  | 72.39028814793166
Current liabilities |  |  |  |  |  |  |  |  |  |  |  | 989.3892913409031 |  |  | 873.4860357510607 |  |  |  |  |  | 741.0615505710077 |  |  |  |  |  |  | 864.8131747872663 |  |  |  |  |  |  |  |  |  |  |  | 961.8945931868735 |  |  |  |  |  |  |  | 1666.730606152277 |  |  |  | 3074.236126275107 |  |  | 2790.675757270769 |  |  | 2885.728155434273 |  |  | 1574.75773325628
- Loans |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  | 0.9427469201896072 |  |  |  |  |  |  |  |  |  |  |  | 1.497006299526827 |  |  |  |  |  |  |  | 22.5254024459853 |  |  |  | 63.4931495076285 |  |  | 68.77078107191316 |  |  | 155.1603503582994 |  |  | 60.24839268362891
- Creditors |  |  |  |  |  |  |  |  |  |  |  | 497.084474876589 |  |  | 472.6797925975319 |  |  |  |  |  | 347.4850201479043 |  |  |  |  |  |  | 425.3883603211106 |  |  |  |  |  |  |  |  |  |  |  | 512.2483374017249 |  |  |  |  |  |  |  | 986.9408118055546 |  |  |  | 1916.909270077437 |  |  | 1810.727575852229 |  |  | 1644.727976156873 |  |  | 982.8787530913439
- Other current liabilities |  |  |  |  |  |  |  |  |  |  |  | 492.3048164643141 |  |  | 400.8062431535288 |  |  |  |  |  | 393.5765304231034 |  |  |  |  |  |  | 438.4820675459662 |  |  |  |  |  |  |  |  |  |  |  | 448.1492494856217 |  |  |  |  |  |  |  | 657.2643919007367 |  |  |  | 1093.833706690041 |  |  | 911.1774003466269 |  |  | 1085.8398289191 |  |  | 531.6305874813071
TOTAL SHAREH. FUNDS & LIAB. |  |  |  |  |  |  |  |  |  |  |  | 2895.278083235517 |  |  | 2575.624932274268 |  |  |  |  |  | 2145.616012469395 |  |  |  |  |  |  | 2189.582096969262 |  |  |  |  |  |  |  |  |  |  |  | 2472.510040891216 |  |  |  |  |  |  |  | 2721.695149847694 |  |  |  | 4679.518099343839 |  |  | 4168.927287206843 |  |  | 4184.524858661166 |  |  | 2503.843278594384
My Gearing |  |  |  |  |  |  |  |  |  |  |  | 43.29343788691704 |  |  | 42.0533563604963 |  |  |  |  |  | 46.22760138321283 |  |  |  |  |  |  | 52.70535329856958 |  |  |  |  |  |  |  |  |  |  |  | 50.82562747688244 |  |  |  |  |  |  |  | 72.88024116196218 |  |  |  | 89.92825951341234 |  |  | 90.8812625420904 |  |  | 90.730109415102 |  |  | 69.03717768736219
Gearing (%) |  |  |  |  |  |  |  |  |  |  |  | 16.084 |  |  | 14.047 |  |  |  |  |  | 21.738 |  |  |  |  |  |  | 28.019 |  |  |  |  |  |  |  |  |  |  |  | 24.368 |  |  |  |  |  |  |  | 45.978 |  |  |  | 254.072 |  |  | 280.6420000000001 |  |  | 274.827 |  |  | 153.825
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.691708398838414 |  |  |  |  |  | 2.993760686302862 |  |  |  |  |  |  | 2.126580245800572 |  |  |  |  |  |  |  |  |  |  |  | 1.881057614424839 |  |  |  |  |  |  |  | 2.085752933227283 |  |  |  | 1.585111165382622 |  |  | 0.35394793410298 |  |  | 0.3238334338484274 |  |  | 0.3301353557514436 |  |  |  | 0.4488033654306009