Date and Time Functions
Date and Time Functions
1/8/2010
1/12/2010 4 DAYS BETWEEN FIRST AND
1/13/2010 1
1/15/2010 2
1/18/2010 3
1/18/2010 0
1/19/2010 1
1/22/2010 3
1/22/2010 0
1/22/2010 0
1/23/2010 1
1/24/2010 1
1/24/2010 1
1/25/2010 1
1/27/2010 2
1/27/2010 0
1/28/2010 1
1/28/2010 0
1/29/2010 1
1/29/2010 0
1/31/2010 2
1/31/2010 0
1/31/2010 0
2/1/2010 1
2/1/2010 0
2/2/2010 1
2/2/2010 0
2/2/2010 0
2/2/2010 0
2/3/2010 1
2/3/2010 0
2/3/2010 0
2/3/2010 0
2/4/2010 1
2/4/2010 0
2/4/2010 0
2/4/2010 0
2/4/2010 0
2/5/2010 0
2/5/2010 0
2/5/2010 0
2/5/2010 0
2/5/2010 0
2/5/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/6/2010 0
2/7/2010 1
2/7/2010 0
2/7/2010 0
2/7/2010 0
2/7/2010 0
2/7/2010 0
2/7/2010 0
2/7/2010 0
2/8/2010 1
2/9/2010 1
2/9/2010 0
2/9/2010 0
2/10/2010 1
2/10/2010 0
2/11/2010 1
2/11/2010 0
2/12/2010 1
2/12/2010 0
2/12/2010 0
2/12/2010 0
2/12/2010 0
2/12/2010 0
2/12/2010 0
2/13/2010 1
2/13/2010 0
2/13/2010 0
2/13/2010 0
2/14/2010 1
2/14/2010 0
2/14/2010 0
2/14/2010 0
2/14/2010 0
2/14/2010 0
2/14/2010 0
2/14/2010 0
2/14/2010 0
2/15/2010 0
2/15/2010 0
2/15/2010 0
2/16/2010 1
2/16/2010 0
2/16/2010 0
2/16/2010 0
2/16/2010 0
2/16/2010 0
2/16/2010 0
2/16/2010 0
2/16/2010 0
2/17/2010 1
2/17/2010 0
2/18/2010 0
2/18/2010 0
2/18/2010 0
2/18/2010 0
2/18/2010 0
2/18/2010 0
2/19/2010 1
2/19/2010 0
2/19/2010 0
2/19/2010 0
2/19/2010 0
2/19/2010 0
2/19/2010 0
2/20/2010 1
2/20/2010 0
2/20/2010 0
2/21/2010 0
2/21/2010 0
2/21/2010 0
2/21/2010 0
2/21/2010 0
2/22/2010 1
2/22/2010 0
2/22/2010 0
2/22/2010 0
2/23/2010 1
2/23/2010 0
2/23/2010 0
2/23/2010 0
2/25/2010 1
2/25/2010 0
2/25/2010 0
2/25/2010 0
2/25/2010 0
2/26/2010 1
2/26/2010 0
2/27/2010 0
2/27/2010 0
2/27/2010 0
2/27/2010 0
2/27/2010 0
2/27/2010 0
2/27/2010 0
2/28/2010 0
2/28/2010 0
2/28/2010 0
3/1/2010 1
3/1/2010 0
3/2/2010 1
3/3/2010 1
3/3/2010 0
3/5/2010 2
3/6/2010 1
3/6/2010 0
3/7/2010 1
S BETWEEN FIRST AND LAST VISIT: 58
NETWORK DAYS: 41
Depreciation Calculation
NBV 2008
yes CG Q30 3D 2001 - Ph1 527 1-Aug-03 Jul-03 06/09 72 65 7 16,172 225 14,600 15,407 807 4 765 Apr-09
yes CG Q30 3D 2003 - PhII 544 1-Mar-04 Feb-04 01/10 72 58 14 14,657 204 11,807 13,086 1,279 6 1,571 Jun-09
yes CG Q30 3D 2004 phIV 552 1-Jun-05 May-05 04/11 72 43 29 14,526 202 8,675 13,717 5,042 25 809 Jan-11
yes CG Q30 3D 2004 phV 554 1-Aug-06 Jul-06 06/12 72 29 43 35,684 496 14,373 34,256 19,883 40 1,428 Apr-12
yes UKCS Q15 phII (BP & Andre 555 1-May-05 Apr-05 03/11 72 44 28 6,466 90 3,951 4,457 506 6 2,009 Jun-09
no UK Q30 3D phIII ext 547 1-Oct-10 Sep-10 08/15 60 -21 81 30,092 502 (10,532) 4,998 15,530 31 15,078 Jul-11 6,016
yes UK Q21 3D ph I 556 1-Oct-06 Sep-06 08/12 72 27 45 9,242 128 3,466 3,014 (452) -4 6,228 Aug-08
yes UK Q21 3D ph II 557 1-Jan-08 Dec-07 11/13 72 12 60 17,893 249 2,982 11,131 8,149 33 6,762 Sep-11
yes UK Q22 3D phI 563 1-Dec-06 Nov-06 10/12 72 25 47 18,030 250 6,260 8,314 2,053 8 9,716 Aug-09
yes UK Q22 3D phII 565 1-Dec-06 Nov-06 10/12 72 25 47 3,029 42 1,052 1,800 748 18 1,229 Jun-10
yes UK Q30 3D phI repro05 566 1-Dec-06 Nov-06 10/12 72 25 47 9,981 139 3,466 8,954 5,488 40 1,027 Apr-12
yes NQ8 phI 567 1-Jan-07 Dec-06 11/12 72 24 48 13,209 183 4,403 10,922 6,519 36 2,287 Dec-11
yes NQ8 phII 569 1-Jan-07 Dec-06 11/12 72 24 48 6,294 87 2,098 1,292 (806) -9 5,002 Mar-08
no UK Q22 3D phIII 576 1-May-09 Apr-09 03/14 60 -4 64 35,395 590 (2,360) 16,627 18,987 32 15,935 Aug-11 2,833
no Q21 ph II ext 588 1-May-09 Apr-09 03/14 60 -4 64 5,578 93 (372) 3,364 3,736 40 1,553 Apr-12 661
no Q22 ph 3 PSDM 650A 1-Dec-08 Nov-08 10/13 60 1 59 677 11 11 546 535 47 131 Nov-12
no Q22 ph 1 PSDM 1F 650B 1-Jan-09 Dec-08 11/13 60 0 60 472 8 0 251 251 32 221 Aug-11
no Q30 ph 2 30 13c PSDM 650C 1-Nov-08 Oct-08 09/13 60 2 58 495 8 17 335 319 39 160 Mar-12
no Q30 ph 5 Gyda PSDM 650D 1-Dec-08 Nov-08 10/13 60 1 59 454 8 8 265 257 34 189 Oct-11
no Q15 PSDM 650E 1-Jan-09 Dec-08 11/13 60 0 60 314 5 0 268 268 51 46 Mar-13
no Q30 ph 6 585 1-May-09 Apr-09 03/14 60 -4 64 8,405 140 (560) 2,358 2,918 21 3,976 Sep-10 2,071
no Q15 ph 3 589 1-May-09 Apr-09 03/14 60 -4 64 6,635 111 (442) 851 1,293 12 3,533 Dec-09 2,251
no Q22 ph 4 incl MonArb 586 1-May-09 Apr-09 03/14 60 -4 64 25,407 423 (1,694) 13,410 15,104 36 1,854 Dec-11 10,143
yes Nigeria 2003 3D - PhIII 540 1-Jun-04 May-04 04/10 72 55 17 32,960 458 25,178 30,549 5,371 12 2,411 Dec-09
yes Fusion Dome Flores 542 1-Sep-04 Aug-04 07/10 72 52 20 2,843 39 2,053 2,452 399 10 391 Oct-09
yes Namibia 2D PhI 545 1-Feb-04 Jan-04 12/09 72 59 13 3,038 42 2,490 2,356 (134) -3 683 Sep-08
yes Equatorial Guinea 3D 12141 1-Nov-04 Oct-04 09/10 72 50 22 6,229 87 4,325 5,259 934 11 970 Nov-09
yes Nigeria 3D ph IV OPL251 562 1-Jan-06 Dec-05 11/11 72 36 36 9,088 126 4,544 5,949 1,405 11 3,139 Nov-09
yes Namibia Ludenitz Basin 571 1-Nov-06 Oct-06 09/12 72 26 46 4,905 68 1,771 2,265 494 7 2,640 Jul-09
12/04 60 60 0 0 0 0 0 0 0 0 Dec-08
12/04 60 60 0 0 0 0 0 0 0 0 Dec-08
MUST BE 1ST
OF MONTH
MC roll NBV 119,717
Variance 23,975 ok
Profit elimination
Account A/c # Proj# Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue 0
Revenue - Acquisition (CMOC) 30201 645 0
Revenue - Multi- Prefunding (2006 Project) 30501 590 0 0 0 0 0 0 660 660 660 660 660 660 3,960
Revenue - Multi- Prefunding (2007 Project) 30501 591 0 0 0 0 0 0 2,640 2,640 2,640 2,640 2,640 2,640 15,840
Revenue - Processing - 3D (MGK) 30402 MGK Sark 0
Revenue - Processing - 3D (MGK) 30402 MGK Boz 0
Revenue - Processing - 3D (CMOC) 30402 CMOC 0
Rental Income (Vessel Sub-Lease) 30704 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Revenue 0 0 0 0 0 0 3,300 3,300 3,300 3,300 3,300 3,300 19,800
COS 0
Acquisition (CMOC) 0
Senior Staff (Seconded) 58005 645 0
Land (CGG Services Equipment) 56371 645 0
Sea - Vessels 56310 645 0
Spare Parts & Consumables 52320 645 0
Repairs & Maintenance n/a 645 0
Real Estate Costs 56110 645 0
Transport & Customs 56250 645 0
Legal & Professional (Consulting) (Curr = 5920 58150 645 0
Telecommunications 58302 645 0
Other Costs 69030 645 0
Data Library 0
Amortization of Data Library (2006 Project) 84010 590 0 0 0 0 0 0 0 0 0 0 0 0 0
Amortization of Data Library (2007 Project) 84010 591 0 0 0 0 0 0 2,199 2,199 2,199 2,199 2,199 2,199 13,195
Data Processing 0
Cost of Sales (MGK) 40101 MGK Sark 0
Cost of Sales (MGK) 40101 MGK Boz 0
Cost of Sales (CMOC) 40101 CMOC 0
0
Air/Boat Fares & Charter (Vessel Sub-Lease) 57101 0 0 0 0 0 0 0 0 0 0 0 0 0
Total OPEX / COS 0 0 0 0 0 0 2,199 2,199 2,199 2,199 2,199 2,199 13,195
0 0 0 0 0 0 0 0 0 0 0 0 0
SG&A (allocation 45% 0 0 0 0 0 0 0 0 0 0 0 0 0
Corporate Overhead Allocation 59900 0 0 0 0 0 0 0 0 0 0 0 0 0
Compensation 40101 46 46 46 46 46 46 46 46 46 46 46 46 556
Office 56110 6 12 12 12 12 12 12 12 12 12 12 12 135
Transportation 56250 1 1 1 1 1 1 1 1 1 1 1 1 11
Travel & Entertainment 57301 2 2 2 2 2 2 2 2 2 2 2 2 27
Telecommunication 58302 2 2 2 2 2 2 2 2 2 2 2 2 27
Professional Fees 59201 5 5 5 5 5 5 5 5 5 5 5 5 56
Revenue - Acquisition (CMOC) 30201 645 0
Revenue - Multi- Prefunding (2006 Project) 30501 590 0 0 0 0 0 0 660 660 660 660 660 660 3,960
Marketing 59214 1 1 1 1 1 1 1 1 1 1 1 1 11
Depreciation 3 3 3 3 3 3 3 3 3 3 3 3 32
Insurance & Medical Check-ups 61001 1 1 1 1 1 1 1 1 1 1 1 1 16
Contract Outside Services 58150 0 0 0 0 0 0 0 0 0 0 0 0 5
Other Expenses 69030 5 5 5 5 5 5 5 5 5 5 5 5 54
0 0 0 0 0 0 0 0 0 0 0 0 0
Other Income and Expense 0 0 0 0 0 0 0 0 0 0 0 0 0
Ecoin House 5% Commission 59219 0 0 0 0 0 0 165 165 165 165 165 165 990
Other Income - Miscellaneous 69010 0
EBIT (72) (78) (78) (78) (78) (78) 858 858 858 858 858 858 4,685
I/C VDGC 15% Commission 69910 0 0 0 0 0 0 495 495 495 495 495 495 3,300
Interest Paid - I/C - Corporate 95001 This is a Group level expense and does not relate to individual business lines 0
Foreign Current Income Tax Exp 97301 This is a Group level expense and does not relate to individual business lines 0
Revenue - Acquisition (CMOC) 30201 645 0
Revenue - Multi- Prefunding (2006 Project) 30501 590 0 0 0 0 0 0 660 660 660 660 660 660 3,960
Net Income (72) (78) (78) (78) (78) (78) 308 308 308 308 308 308 1,385
Revenue - Acquisition (CMOC) 30201 645 0
Revenue - Multi- Prefunding (2006 Project) 30501 590 0 0 0 0 0 0 660 660 660 660 660 660 3,960
Revenue - Acquisition (CMOC) 30201 645 0
Revenue - Multi- Prefunding (2006 Project) 30501 590 0 0 0 0 0 0 660 660 660 660 660 660 3,960
2008 1.03 0.9709
Data Library Surveys - Sales & Margin
Completed Surveys
VTS NORTH SEA - NO NBV 0 0 703 175 0 0 0 0 878 703 175 0 0
1 CGG NORTH SEA - NO NBV 0 0 0 0 0
3 1996 2D 288 288 288 0 0 0
100 1996 3D 800 800 0 0 800 0
517 Fugro 7 7 7 0 0 0
508/110 Q28/29 1999 3D 99 100 493 692 99 593 0 0
107 Nigeria 1999 3D ph1 1698 -5 1693 1,693 0 0 0
521 FE Guinea Bissau 2D 0 38 1 39 0 39 0 0
Processing
20 Guinea Bissau Repro 40 75 2 117 40 0 77 0
111 Senegal Dome Flore 0 0 0 0 0
519 Fugro 2D TBS2000 484 275 759 0 759 0 0
0 0 0 0
FY01/02 Surveys 0 0 0 0
527 CG Q30 3D 2001 - Ph1 20 -626 180 0 0 0 -426 20 -626 180 0
537 Q15 2002 3D - PhI 150 272 99 23 217 20 20 0 0 0 801 521 260 20 0
VTS AFRICA NO NBV 0 0 0 0 0 0 0 0 0
534 CGG AFRICA NO NBV 0 0 0 0 0 0 0 0
533/536 Mauritania 2001 2D 169 0 0 0 169 0 169 0 0
0 0 0
FY03 Surveys 0 0 0
539 Norway 6607 3D 2002 0 0 0 0 0 0 0 0
540 Nigeria 2003 3D - PhIII 5225 0 0 2060 7285 0 5,225 0 2,060
544 CG Q30 3D 2003 - PhII 99 213 388 0 0 0 700 312 0 388 0
542 Fusion Dome Flores 0 0 0 0 0 0 0 0
545 Namibia 2D PhI 0 0 0 0 0 0 0 0
0 0 0
FY04 Surveys 0 0 0
12141 Equatorial Guinea 3D 0 0 0 0 0 0 0 0
552 CG Q30 3D 2004 phIV 81 1239 333 0 333 1986 81 1,239 0 666
554 CG Q30 3D 2004 phV 2310 112 35 0 0 0 2457 2,310 112 35 0
555 UKCS Q15 phII (BP & Andrew) 522 500 133 0 1155 522 0 0 633
547 Tullow Oil Q30 3D phIII 473 1682 1167 1167 4489 473 0 0 4,016
548 Walter 2D N Sea 0 0 0 0 0 0 0 0
0 0 0
FY05 Surveys 0 0 0
556 UK Q21 3D ph I 167 167 167 501 0 0 0 501
562 Nigeria 3D ph IV OPL251 0 0 0 0 0 0 0 0
557 / 588 UK Q21 3D ph II (INCLUDES EX 34 492 808 735 735 735 3539 34 492 808 2,205
Q3/9 0 0 0 0 0
563 UK Q22 3D phI 72 64 0 0 0 136 72 64 0 0
565 UK Q22 3D phII 0 0 0 0 0 0 0 0
566 UK Q30 3D phI repro05 706 1636 1987 853 460 0 0 0 5642 2,342 2,840 460 0
0 0 0 0
FY06 Surveys 0 0 0 0
567 NQ8 ph I 0 0 0 0 0 0 0 0
571 Namibia Offshore 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
FY07 Surveys 0 0 0 0 0 0 0 0
576 UK Q22 ph III 0 49 695 695 696 2135 0 49 0 2,086
569 NQ8 ph II 0 0 0 0 0 0 0 0
564/5 UK Q22 3D phII 0 0 0 0 0 0 0 0
UK Q30 3D ph VI 0 0 0 0 0 0 0 0
Kazakhstan - 590 - SW 06 0 0 1134 1134 0 0 0 1,134
Kazakhstan - 591 - SW07 0 0 1134 1134 0 0 0 1,134
Libya 2D 0 0 0 0 0
0 0 0 0 0
FY08 Surveys 0 0 0 0 0
650 Central Graben PSDM 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
TOTAL DATA LICENSING 3,438 2,807 3,272 2,937 2,763 5,690 275 1,233 1,260 4,112 2,897 7,426 38,109 9,517 11,390 2,768 14,435
Promote License
Block 16/21d 0 0 0 0 0
Interpretation Group
Other 0 0 0 0 0
0 0 0 0 0
TOTAL 3,438 2,807 3,272 2,937 2,763 5,690 275 1,233 1,260 4,112 2,897 7,426 38,109 9,517 11,390 2,768 14,435
Total
West Africa 40 1,698 -5 38 0 5,226 75 2 0 0 0 2,060 9,134 1,733 5,264 77 2,060
Kazakhstan 0 0 0 0 0 0 0 0 0 0 0 2,268 2,268 0 0 0 2,268
North Sea 3,398 1,109 3,277 2,899 2,763 464 200 1,231 1,260 4,112 2,897 3,098 26,708 7,784 6,126 2,691 10,107
TOTAL 3,438 2,807 3,272 2,937 2,763 5,690 275 1,233 1,260 4,112 2,897 7,426 38,109 9,517 11,390 2,768 14,435
check 0 0 0 0 0 0 0 0 0 0 0 0 ###
0 0 0 0 0
check 1,134
Y - 2010 Y - 2011
3 YR DL Business Plan WORKINGS
12/31/2010 12/31/2010
ASSUMPTIONS:
Pre-funding
External Revenues (EXR) #REF! #REF! North Sea / Kazakhstan - 80% of capex
ES Revenues 0.0 0.0 Africa - 70% of capex
NES Revenues #REF! #REF! Vessel allocation as per instruction by J Beard 3rd Feb 2009
Original Participants 33.7 32.4
After Sales #REF! #REF! AS - 3% increase yr on yr for N orth sea / Africa NOT Kazakhstan - see below for Kazakhstan
Reproduction Revenues
Internal Revenues (INR) 0.0 0.0 NES amortization
NES Production 0.0 0.0 75% N Sea acquisition
Other 0.0 0.0 83% Africa acquisition
INCOME Cost of Production #REF! #REF! 75% average for all AS - as majority of PPA impact removed
Cash costs #REF! #REF!
Industrial Amortization
NES Amortization #REF! #REF! Kazakhstan assumptions
Devpt Costs Amortization For AS - no licensing round in 3 year period
STATEMENT Gross Margin #REF! #REF! No Aktau office but only Almaty office
Margin (vs EXR) #REF! #REF!
R&D Expenses 0.0 0.0
SG&A Expenses #REF! #REF! Y - 2010 Y - 2011
Cash expenses #REF! #REF!
Amortization - Non cash elements 0.0 0.0
Other Revenues 0.0 0.0 North Sea / Africa
Disposal of Assets 0.0 0.0
Hedging Income 0.0 Capex
Equity in Investees 0.0 0.0
Other North sea 0.0 42.2 0.0 40.5
EBIT #REF! #REF!
Margin (vs EXR) #REF! #REF! Challenger 38.3 36.8
Cost of Debt Excaliber I, II, III (N Sea) 0.0 0.0
Other financial items Processing (10% of acquisition costs) 3.8 3.7
Tax 0.0 0.0
Withholding Tax 0.0 0.0 Africa/ Med 0.0 0.0 0.0 0.0
Corporate Tax 0.0 0.0
Net Income #REF! #REF! Amedeus 0.0 0.0 0.0 0.0
Processing (10% of acquisition costs) 0.0 0.0
Year-to-date average Exchange Rate 1 € = 1.350 $ 1 € = 1.350 $
Total capex 42.2 40.5
EBITDA #REF! #REF!
Margin (vs EXR) #REF! #REF!
NES Production 42.2 40.5 Vessel costs per month
Devpt Costs Capitalization Challenger 6.0 6.2
Withholding Tax 0.0 0.0 Excaliber I, II, III (N Sea) 6.1 6.1
CASH FLOW Change in Operating WC (0.8) (0.8) Amedeus 4.8 5.0
Change in Inventories & WIP 0.0 0.0
Change in Receivables in Progress (0.5) (0.5)
Change in Receivables (0.4) (0.4) Vessel costs per day
Change in Payables 0.0 0.0 Challenger 0.20 0.20
STATEMENT Cash provided by Operations #REF! #REF! Excaliber I, II, III (N Sea) 0.20 0.20
Industrial Capex 0.0 0.0 Amedeus 0.16 0.16
Change in Investing WC
Net Operating Cash Flow #REF! #REF!
Cash Financial Items 0.0 0.0
Interest expenses No of days
Other Challenger (N Sea) 195 181
Other Tax paid #REF! #REF! Excaliber I, II, III (N Sea) 0 0
Corporate Tax [35.0%] #REF! #REF! Amedeus (Africa) 0 0
Change in Tax liabilities
Change in Other WC Total no of days 195 181
Other elements
Free Cash Flow #REF! #REF!
Other Flows
Net Cash Flow #REF! #REF! Pre-funding revenue
Closing Exchange Rate 1 € = 1.350 $ 1 € = 1.350 $ North sea - 80% capex 33.7 32.4
Africa - 70% capex 0.0 0.0
Tangible Assets 0.0 0.0
Vessels & Logistics
Seismic Equipment Total 33.7 32.4
Other
MCS Library #REF! #REF!
FIXED ASSETS Intangible Assets 0.0 0.0
Devpt Costs
Other NES amortization
Goodwill
Invest.& Adv. in CuEq. North sea - 80% capex / 75% COS 25.3 24.3
Other LT Assets Africa - 70% capex / 83% COS 0.0 0.0
LT Liabilities Allocations per M perot 7th Oct 0.7 0.9
Total Net LT Assets #REF! #REF! AS COS #REF! #REF! No VC COS as no NBV remaining
60% COS N Sea / Africa / 83% Kaz spread thru years
Inventories & WIP 0.3 0.3 Total #REF! #REF!
Days of Cash COP #REF! #REF!
Receivables in Progress 10.2 10.2
Days of EXR #REF! #REF! AS
Receivables (Net) 7.6 7.6
Days of Invoicing #REF! #REF!
WORKING CAPITAL Payables (Net) (0.6) (0.6) Kazakstan 14.9 14.9
Days of Cash COP #REF! #REF! North Sea / Africa #REF! #REF!
Net Operating WC 17.6 17.6
Days of EXR #REF! #REF! #REF! #REF!
Liabilities on Assets 0.0 0.0
Tax Liabilities 0.0 0.0
Other Current Elements 0.0 0.0 2008 N Sea / Africa Budget is $40.7
Assets
Liabilities
Net Working Capital 17.6 17.6
Cash expenses
CAPITAL EMPLOYED #REF! #REF!