The case study of an economic analysis is done for Schlumberger, oilfield Service Company. They are No. 1 in terms of market caps, revenue and employees globally. When any references are used/outside sources (except for Schlumberger's annual reports and financial statements), they should be evidently stated. Now answer the following Question?
1. Calculate Super Normal profit: calculate exactly the % of super normal profit Schlumberger is making. Use 5 year average, as well as 2009 data separately, and Q 3 2010 (it was announced on Fri). Plot 3 simple graphs to show, or this three in one graph is also okay.
2. Effects of inflation on revenue: Do that either using GDP calculator or industry indices (e.g. Dow Jones.) To calculate real versus nominal value. The industry they should look for is oilfield equipment and services. If they can't fine then oil and gas. Also, if they could draw a generic conclusion on exchange rates. (There are no specific breakdowns detailed enough. they operate globally, generate revenue in dollars, and oil is traded in dollars. I just need a generic conclusion on how exchange rates affect their revenue and not specific data for them to look at. Note: it should not be a conclusion on how oil trade is affected by exchange rates fluctuations.
3. Price Elasticity of Demand (PED) for Schlumberger (i.e. oilfield service): I am not sure how they can do it. One way is to compare average change in rig rates (info available on site www.rigzone.com) to average change in SLB stock price? They must note that the stock price was split in 2006 when it crossed a 100$. I think that the site that have historic stock price have already considered that in calculation. Or they can use any other way.
4. Wealth generating potential: A few generic strategic sentences/one short paragraph, based on their balance sheet and net dept vs. equity or cash flow. Treat it as part of investment appraisal exercise.
Below is Schlumberger's revenue from 2009 - 2004 (backwards), in $ US Billions:
2009 2008 2007 2006 2005 2004
22.7 27.16 23.28 19.23 14.31 11.5
Below is RONA from one of the websites for 5 year average (need to check that figure):
Please note: this was as of Q 2 2010. For a 12 month period ending Q 2 2010 they had the following figure for RONA (all is $ US billion)
Below is also an explanation on GDP deflator and how to convert nominal to real values:
Nominal Sales/Output of UK based company 'X' (£m) = TR
2000 2001 2002 2003 2004 2005 2006 2007
1000 1027 1015 1034 1086 1210 1450 1520
GDP deflator = P 92.071 94.099 97.03 100 102.564
Real Sales/Output 1086 1091 1046 1034 1058 1153 1346 1369
(Q = TR / P)'
At the business level the simplest solution to this problem is to deflate current total revenue (i.e. the money value of output = P x Q) by an appropriate index of prices .The GDP deflator can be viewed as a measure of aggregate prices in the domestic economy. The deflator is usually expressed in terms of an index, i.e. a time series of index numbers The GDP deflator reflects movements of hundreds of separate deflators for the individual expenditure/output components of GDP.
GDP deflator for specific economy should be used The IMF is the first port of call for this data but local sources can also be used. In the example 2003 is the base year so when TR (the money value of output) is deflated before 2003 the real value is higher i.e. at 2003 prices TR is higher in 2000 when it is valued at 2000 prices. After 2003 the opposite happens so the real value (‘volume’) is less than the current value. Government statisticians use this method to value company level real output which they can they aggregate to obtain a macro level measure i.e. GDP
GDP deflator is an average measure of prices In general, it is better when calculating real output at the company level to use either a company or sector specific price index. When this is not available the GDP deflator is a good alternative