Spreadsheet: 857842d1706716565-how-to-get-a-result-using-vlookup-formula-with-special-formatting-ccfr_2312_fi-100-capitaux-propres
Sheet: Adaptiv

Comptes | [NAME] | févr.-2023 | mars-2023 | avr.-2023 | mai-2023 | juin-2023 | juil.-2023 | août-2023 | sept.-2023 | oct.-2023 | nov.-2023 | déc.-2023 | EX2023
Gross Revenue
Gross Technology Sourcing Revenue | 66896811.81 | 58825542.97 | 65492412.5 | 59504951.22 | 55312319.21 | 83864260.52 | 59480430.1 | 59081805.8 | 60527125.39 | 69778179.01 | 79917283.25 | 127836275.19 | 846517396.97
Gross Professional Services Revenue | 5073277.03 | 5095329.39 | 6186346.38 | 3262379.09 | 4456528.34 | 5051565.57 | 3998489.63 | 4160916.67 | 5076358.53 | 5274216.48 | 5505316.34 | 5200770.33 | 58341493.78
Gross Managed Services Revenue | 13096917.45 | 13134458.47 | 13431966.39 | 12435323.81 | 12878224.97 | 12910832.99 | 12927584.64 | 12537751.44 | 13500824.91 | 12479092.85 | 11700050.58 | 12440124.74 | 153473153.24 |  |  |  | 0.03
Total | 85067006.29 | 77055330.83 | 85110725.27 | 75202654.12 | 72647072.52 | 101826659.08 | 76406504.37 | 75780473.91 | 79104308.83 | 87531488.34 | 97122650.17 | 145477170.26 | 1058332043.99 |  |  |  | 0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
Intercompany Revenue
Intercompany Technology Sourcing Revenue | 528683 | 342173 | 693392 | 300373 | 1406899 | 983603 | 552600.98 | 907114 | 316951 | 878285 | 754968 | 717732 | 8382773.98 |  |  | M
Intercompany Professional Services |  |  |  |  |  | 38841 |  |  | -38841 | 0 | 0 | 0 | 0 |  |  | PM
Intercompany Managed Services Revenue | 73097 | 87286 | 78424 | 77918 | 78125 | 77446 | 75441 | 58678 | 70482 | 56385 | 65994 | 69970 | 869246 |  |  | SRA
Total | 601780 | 429459 | 771816 | 378291 | 1485024 | 1099890 | 628041.98 | 965792 | 348592 | 934670 | 820962 | 787702 | 9252019.98
External Gross Revenue
External Gross - Technology Sourcing | 66368128.81 | 58483369.97 | 64799020.5 | 59204578.22 | 53905420.21 | 82880657.52 | 58927829.12 | 58174691.8 | 60210174.39 | 68899894.01 | 79162315.25 | 127118543.19 | 838134622.99
External Gross - Professional Services | 5073277.03 | 5095329.39 | 6186346.38 | 3262379.09 | 4456528.34 | 5012724.57 | 3998489.63 | 4160916.67 | 5115199.53 | 5274216.48 | 5505316.34 | 5200770.33 | 58341493.78
External Gross - Managed Services | 13023820.45 | 13047172.47 | 13353542.39 | 12357405.81 | 12800099.97 | 12833386.99 | 12852143.64 | 12479073.44 | 13430342.91 | 12422707.85 | 11634056.58 | 12370154.74 | 152603907.24
Total | 84465226.29 | 76625871.83 | 84338909.27 | 74824363.12 | 71162048.52 | 100726769.08 | 75778462.39000002 | 74814681.91 | 78755716.83 | 86596818.34 | 96301688.17 | 144689468.26 | 1049080024.01
Technology Sourcing Revenue : Agency / Principal Element
Software | 19571038.17 | 17293640.05 | 12838802.65 | 12150346.51 | 13546221.58 | 22086425.19 | 22928103.66 | 12599114.55 | 11509142.2 | 15161627.36 | 17839620.74 | 44297486 | 221821568.66
Resold - Professional Services | 1501271.51 | 1760926.68 | 3391471.58 | 2427572.43 | 2378089.07 | 5619552.91 | 2438455.46 | 2102112.88 | 2311949.13 | 2588908.48 | 4046265.16 | 8049803.97 | 38616379.26
Resold - Managed Services | 1484280.91 | 1777848.15 | 1734729.4 | 1816593.84 | 1408806.45 | 2681275.64 | 1104993.23 | 2463165.4 | 1059918.7 | 3038420.55 | 1704076.32 | 5560840.87 | 25834949.46
Total | 22556590.59 | 20832414.88 | 17965003.63 | 16394512.78 | 17333117.1 | 30387253.74 | 26471552.35 | 17164392.83 | 14881010.03 | 20788956.39 | 23589962.22 | 57908130.84 | 286272897.38
IFRS Income
IFRS Technology Sourcing | 43811538.22 | 37650955.09 | 46834016.87 | 42810065.44 | 36572303.11 | 52493403.77999999 | 32456276.77 | 41010298.97 | 45329164.36 | 48110937.62 | 55572353.03 | 69210412.35 | 551861725.61
IFRS Professional Services | 5073277.03 | 5095329.39 | 6186346.38 | 3262379.09 | 4456528.34 | 5012724.57 | 3998489.63 | 4160916.67 | 5115199.53 | 5274216.48 | 5505316.34 | 5200770.33 | 58341493.78
IFRS Managed Services | 13023820.45 | 13047172.47 | 13353542.39 | 12357405.81 | 12800099.97 | 12833386.99 | 12852143.64 | 12479073.44 | 13430342.91 | 12422707.85 | 11634056.58 | 12370154.74 | 152603907.24
Total | 61908635.7 | 55793456.95 | 66373905.64000001 | 58429850.34 | 53828931.42 | 70339515.33999999 | 49306910.04000001 | 57650289.08 | 63874706.8 | 65807861.95000001 | 72711725.95 | 86781337.41999999 | 762807126.63
IFRS COS
Technology Sourcing COS | 36585806.23 | 31692265.77 | 38824663.33000001 | 36758202.23999999 | 31276675.11 | 43661243.16999999 | 27675337.22 | 35566458.48999999 | 39442463.33 | 41436944.82000001 | 47757756.76000001 | 54236717.8 | 464914534.27
Professional Services COS | 4201027.140000001 | 4210894.739999999 | 5355498.3 | 2447142.29 | 3775715.04 | 4106816.29 | 3300781.31 | 3605905.16 | 4214514.09 | 4238938.4 | 4522291.14 | 4027896.36 | 48007420.26
Managed Services COS | 13372337.47 | 13446503.63 | 13600287.29 | 12194301.2 | 13114714.02 | 11828240.36 | 12022344.44 | 12129918.93 | 12345164.09 | 12355463.12 | 11290586.87 | 11815076.3 | 149514937.72
Total | 54159170.84 | 49349664.14000001 | 57780448.92 | 51399645.73 | 48167104.17 | 59596299.81999999 | 42998462.97 | 51302282.57999999 | 56002141.51000001 | 58031346.34 | 63570634.77 | 70079690.46 | 662436892.25
[NAME]
Technology Sourcing Contribution | 7225731.99 | 5958689.32 | 8009353.54 | 6051863.2 | 5295628 | 8832160.61 | 4780939.55 | 5443840.48 | 5886701.03 | 6673992.8 | 7814596.27 | 14973694.55 | 86947191.33999999
Professional Services Contribution | 872249.89 | 884434.65 | 830848.08 | 815236.8 | 680813.3 | 905908.28 | 697708.32 | 555011.51 | 900685.44 | 1035278.08 | 983025.2 | 1172873.97 | 10334073.52
Managed Services Contribution | -348517.02 | -399331.16 | -246744.9 | 163104.61 | -314614.05 | 1005146.63 | 829799.2 | 349154.51 | 1085178.82 | 67244.73 | 343469.71 | 555078.44 | 3088969.52
Total | 7749464.859999999 | 6443792.810000001 | 8593456.719999999 | 7030204.61 | 5661827.25 | 10743215.52 | 6308447.07 | 6348006.5 | 7872565.290000001 | 7776515.61 | 9141091.18 | 16701646.96 | 100370234.38
People Expenses
People External | 41857.24 | 86393.02 | 69538.42 | 39239.46 | 68623.93 | 87605.74 | 62530.06 | 81052 | 88037.21 | 101550.91 | 110089.92 | 82686.93 | 919204.84
People Internal | 1507832.66 | 1698413.79 | 329601.85 | 2111049.39 | 1619451.14 | 3513409.51 | 1196847.04 | 1332624.27 | 1644645.6 | 32261626.13 | 4722312.17 | 7324681.24 | 59262494.79
People Related | 268853.13 | 270562.92 | 364940.15 | 278487.75 | 266338.32 | 268831.74 | 374586.29 | 202947.45 | -323728.37 | 1691095.43 | 442599.9 | 365791.27 | 4471305.98
Total | 1818543.03 | 2055369.73 | 764080.42 | 2428776.6 | 1954413.39 | 3869846.99 | 1633963.39 | 1616623.72 | 1408954.44 | 34054272.47 | 5275001.99 | 7773159.439999999 | 64653005.61
Infrastructure Expenses
Property Expenses | 31183.34 | 93644.38 | -124551.98 | -35134.95 | 52450.77 | 91897.05 | 97050.08 | -35269.74 | 9572.39 | 578071.27 | 88497.12 | 196788.57 | 1044198.3
Communication Expenses | 41713.18 | 49996.1 | 60662.04 | 44008.93 | 45250.85 | 45401.96 | 63410.18 | 46022.91 | 58553.25 | 97381.52 | 35168.97 | 67214.84 | 654784.73
Equipment Expenses | -84805.61 | 135489.31 | 65313.31 | 98560.21 | 122446.65 | 116403.35 | 137885.27 | 122479.21 | 111957.4 | 142189.01 | 107407.35 | 149154.06 | 1224479.52
Depreciation and Amortisation Charges | 85920.54 | 76859.32 | 85832 | 92656.63 | 90931.93 | 88439.26 | 96963.63 | 90274.5 | 54724.96 | 288570.83 | 116270.23 | 129051.2 | 1296495.03
Total | 74011.45 | 355989.11 | 87255.37 | 200090.82 | 311080.2 | 342141.62 | 395309.16 | 223506.88 | 234808 | 1106212.63 | 347343.67 | 542208.67 | 4219957.58
Admin Expenses
Carrier Costs | 7.62 | 40017.66 | 2226.04 | 3520 | 1737.24 | 171.65 | 4556.36 | 0 | 0 | 3759.25 | 2009.46 | 484.43 | 58489.71
Admin Costs | 875095.65 | 1001911.78 | 7293010.89 | 2770101.9 | 2862765.95 | 1892770.66 | 2890490.62 | 4505975.3 | 5854150.8 | -22362427 | 978341.91 | 8179887.21 | 16742075.67000001
Marketing Expenses | 143793.21 | 120513.77 | 222229.5 | 164812.52 | 377262.06 | 287704.37 | 135791.39 | 198491.86 | 138088.12 | 214719.48 | 428787.76 | 322392.55 | 2754586.59
Total | 1018896.48 | 1162443.21 | 7517466.43 | 2938434.42 | 3241765.25 | 2180646.68 | 3030838.37 | 4704467.16 | 5992238.92 | -22143948.27 | 1409139.13 | 8502764.19 | 19555151.97
Finance Expenses | -73992.77 | -104782.34 | -166648.62 | -133257.58 | -97310.67 | -386422.58 | 75181.34 | -149807.55 | -137012.73 | 246388.31 | -377727.45 | -466369.31 | -1771761.95
ISP Charges | -79456.58 | -143244.36 | -68132.48 | 52676.27 | 141478.7 | 99291.77 | 8487.19 | -76724.89 | 419.77 | 2831.18 | 83734.1 | -156247.29 | -134886.62
Statutory Indirect Expenses | 2758001.61 | 3325775.350000001 | 8134021.119999999 | 5486720.529999999 | 5551426.870000001 | 6105504.48 | 5143779.45 | 6318065.32 | 7499408.399999999 | 13265756.32 | 6737491.439999999 | 16195515.7 | 86521466.58999999
Other Income | -872527.58 | -915778.09 | -719738.95 | -807048.41 | -460892.25 | -686919.36 | -809192.68 | -854471.98 | -892219.58 | -721701.95 | -626407.61 | -899795.57 | -9266694.010000002
Statutory SG&A | 3630529.19 | 4241553.44 | 8853760.069999998 | 6293768.939999999 | 6012319.120000001 | 6792423.840000001 | 5952972.13 | 7172537.300000001 | 8391627.979999999 | 13987458.27 | 7363899.05 | 17095311.27 | 95788160.6
Statutory EBIT | 4118935.669999999 | 2202239.37 | -260303.35 | 736435.670000001 | -350491.870000001 | 3950791.679999999 | 355474.94 | -824530.800000001 | -519062.689999998 | -6210942.660000001 | 1777192.13 | -393664.309999999 | 4582073.779999986
Interest income | 16084.98 | 47557.42 | 13671.19 | -814.11 | 5590.41 | 10693.01 | 35991.21 | 8572.02 | 8860.81 | 178036.15 | 63106.74 | 155322.59 | 542672.42
Interest Cost
Interest cost | 48660.09 | 97188.42 | 104542.98 | 108083.15 | 67592.72 | 62774.79 | 43012.94 | 35681.74 | 59362.25 | 39183.15 | 14753.62 | 273059.43 | 953895.28
Total | 48660.09 | 97188.42 | 104542.98 | 108083.15 | 67592.72 | 62774.79 | 43012.94 | 35681.74 | 59362.25 | 39183.15 | 14753.62 | 273059.43 | 953895.28
Adjusted Profit Before Tax | 4086360.56 | 2152608.37 | -351175.14 | 627538.410000001 | -412494.180000001 | 3898709.899999999 | 348453.21 | -851640.520000001 | -569564.129999998 | -6072089.660000001 | 1825545.25 | -511401.149999999 | 4170850.919999986
Statutory Profit Before Tax | 4086360.56 | 2152608.37 | -351175.14 | 627538.410000001 | -412494.180000001 | 3898709.899999999 | 348453.21 | -851640.520000001 | -569564.129999998 | -6072089.660000001 | 1825545.25 | -511401.149999999 | 4170850.919999986
Tax
Tax Charge |  |  |  |  |  |  | 105000 |  |  | 131000 |  | 209000 | 445000
Total |  |  |  |  |  |  | 105000 |  |  | 131000 |  | 209000 | 445000
Statutory Profit After Tax | 4086360.56 | 2152608.37 | -351175.14 | 627538.410000001 | -412494.180000001 | 3898709.899999999 | 243453.21 | -851640.520000001 | -569564.129999998 | -6203089.660000001 | 1825545.25 | -720401.149999999 | 3725850.919999986
Statutory Retained Profit or Loss | 4086360.56 | 2152608.37 | -351175.14 | 627538.410000001 | -412494.180000001 | 3898709.899999999 | 243453.21 | -851640.520000001 | -569564.129999998 | -6203089.660000001 | 1825545.25 | -720401.149999999 | 3725850.919999986
Statutory Retained Earnings Test | 4086360.56 | 2152608.37 | -351175.14 | 627538.410000001 | -412494.180000001 | 3898709.899999999 | 243453.21 | -851640.520000001 | -569564.129999998 | -6203089.660000001 | 1825545.25 | -720401.149999999 | 3725850.919999986
Notes :
23 janv. 2024 12:20:01 CET
Informations confidentielles. Ne pas diffuser sans autorisation.