In this project we were asked to analyze three companies In the oil and gas industry. Firstly, we studied the dividend history of each of the firms. Unlike many other industries, all of our firms paid dividends during the period 1989 to 1998. We came up with two methods of calculating the dividend growth rate. Firstly, using 1989 as the base year and relating all dividends back to this year and secondly, comparing the growth of dividends on a year-to-year basis (I. E. Taking the dividend Inn 997, subtracting from it the dividend in 1996, and then dividing the difference by the evident in 1996).

We think that both of these methods are equally valid because they show different trends and patterns. Looking first at the year-by-year dividend calculations, some general trends can be observed, such as that all three companies had a positive average growth in dividends for the period. Simply, dividends actually went up rather than down. Growth rates for all three companies indicated an increasing trend till the year 1 997 when they experienced a decline. In order to study the required rate of return for each companies stock. We used a geometric average of lading period returns for the past ten years.

CHEVRON CORP.. Regarding Investors Required Rate of Return ( IR) we estimated that due to the upcoming merger of Exxon and Mobil, Chevron’s IR will Increase to 22% compared to 20% which Is the average for the past ten years. We also created a second rate of return, which will come into affect seven years from now in 2006, when we expect the market to stabilize after the effects of the merger. This rate will be lower than that of the first because the risk caused by the merger should have subsided by this time, hush we estimated it at about 17% which is close to but less than that of Mobiles at present.

Another aspect that contributed to this decision was that if the rate were any lower investors would rather invest in Mobil or other oil companies of similar caliber. As a percentage of Net Income Chevron is paying the highest dividends, and due to Its weak position with respect to competition it Is essential for Chevron to pay high dividends to attract Investors. Regarding a reasonable range of required rates of return Chevron cannot fall far below Mobil and must stay close to 17% and within n upper Limit that Is logical compared to competitors.

We studied the value of Chevron’s stock based on different rates of return and dividend growth rate assumptions (refer to appendix). We selected the dividend growth rates of 6. 4% and 3. 2 We started off with 6. 4% because this was the average growth rate of the dividends over the last 10 years. This rate applied for the first 6 years of our model (1999-2005) since we felt that we would have to keep the dividends at a high level due to the merger between Mobil and Exxon, because otherwise investors would not hold Chevron stocks. We chose 3. As the rate after 6 years because we thought that after the immediate period following the merger, things in the market would have stabilized and the rate of dividend growth could decrease yet investors would continue to hold the stock. Based on these assumptions, the value of the stock Is $19. 711, considerably lower than the current market price of $85. 50. So the stock appears to be over-valued and hence we recommend that Investors sell the stock. The stock will remain over-valued despite varying dividend growth rates and rates of Rate Reason GIG = 8. 23% Average of the last three years growth rates GO = 4. 15% 1/2 of the average growth rate for the last three years GIG,GO = 10% The highest ever paid out dividend RI = 14% Last year’s holding period return RE = 13% RE would decrease slightly after merger. Stabilization RI, RE = 24. 43 Average of the last three year’s rate of return RE= 11% 1/2 of 22% (our first assumption) The current stock price for Chevron is $85. 50 on closing of November 5th. The return the market requires is 5. 75% (based on the original dividend assumptions mentioned above), however the RL has to remain constant, as fluctuations in this figure will result n the sale of ownership in Chevron.

By changing dividend assumptions to 8. 23% and 4. 115% we find that the required market rate of return increases to 6. 40%. In order to analyze the affect of dividend growth rate on market price we set the market price at $85. 50 and calculated growth rate in dividends. By changing go the growth rate would be 15. 01% if all other assumptions were held constant. By changing gal. to 8. 23% the growth rate would be lower (14. 775%) because higher dividends are paid earlier and therefore in the future dividend growth rate would be lower in order to compensate. EXXON and MOBIL

Exxon showed the most dramatic decrease in dividend growth of all the three companies, displaying a 3. 25% decrease in 1998. The overall decrease throughout the companies may be a reflection of the economic crisis Asia has faced in recent times, which has also caused significant repercussions throughout the worldwide marketplace. Despite Pope’s efforts to curb the worldwide extraction of oil, a number of companies defaulted on the agreement and thereby created excess supply and this resulted in low oil prices in the past year. Low profits pushed dividends to lower levels, contributing in turn to low dividend growth.

Exxon displayed an extremely low average in this respect compared to very similar rates of return for Chevron and Mobil at 20% and 18% respectively. This was perhaps the result of stock splits causing closing prices to fluctuate greatly. In turn, sparse negative holding period returns occurred. This could be why the overall average resulted in such a low figure. Analyzing Exxon we estimated that before the upcoming merger the IR would be 4. 05%. The dividend growth rate for the past year declined sharply due to the circumstances discussed above, hence we considered this an irregular event.

Due to this assumption we selected 4. 05% as a good estimate for 1999 based on the figures of 1997 and 1996, especially since Exxon being the largest of the three companies by far, can afford to have a low IR in comparison. Here, the geometric average method of calculating the rate does not seem to be an accurate assessment since negative holding period returns caused the result to be extremely small and unrealistic. Regarding Mobil, the geometric average of the holding period returns for the past ten years was used as the Required Rate of Return for Investors and resulted in 18. 02%.

For the next two years we assumed that it would be fairly accurate to use this of Chevron (22%), Mobiles sheer size will attract investors despite this difference. We have assumed that the Exxon Mobil merger will go through by the year 2000 therefore new Investors Rates of Return must be estimated for the new Joint company. Based on the stock price for both Exxon and Mobil, we took 40% of Exxon IR and 60% of Mobil IR and combined it to get 11. 91% as a new IR for the new company we termed “Moneybox”. This rate will be the second IR for both companies, which will take affect in the year 2001.

Studying the value of Oxen’s stock based on different rates of return and dividend growth rate assumptions (refer to appendix), we chose the dividend growth rates of 4. 05% and 5. 56%. We started off with 4. 05% because this was the average growth rate of the dividends over the 10-year period. This rate applied for the first 2 years of our model (1999-2000). The second dividend growth rate of 5. 56% was derived from the same method as the second IR using a breakup of to 60% for Exxon and Mobil respectively. For Mobil we chose the dividend growth rate of 6. 72% based on Mobiles 10-year average of dividend growth.

The resulting rate was 9. 231%. This number shows what the market expects the dividend growth rate of Moneybox to be. In the third scenario we assumed RL, re, and go constant at their original assumptions. This resulted in gal. being 55. 9230%. In this scenario we decided to alter gal. in order to see what the assumptions that the first IR is 18. 02% (1999-2000), the second IR is 1 1. 91% (from 2000 onward), the first dividend growth rate is 6. 72% (1999-2000), the second dividend growth rate is 5. 56% (from 2000 onward), and a 1. 5 Merger Stock Ratio (for every share of Mobil, you receive 1. Hares of Moneybox), the value of Mobiles stock is $42. 3446 which is considerably lower than the current market price of $91. 375. So, similar to Exxon and Chevron, the stock appears to be over-valued and hence we recommend that investors sell the stock. At varying dividend growth rates and rates of return, the conclusion is the same as for Exxon and Chevron. We varied these figures using the same rates as Exxon due to the fact that they will merge and become the same company. Hence, their figures (re and go) need to coincide (refer to table for Exxon and appendix).

In addition, we performed two sets of computation: nee with the Merger Stock Ratio of 1. 5 and another with the ratio of 2. This was done in order to gain a broader perspective on the future value of Moneybox since we do not know for sure what the terms of their merger is. However, the two values of 1. 5 and 2 seem to the most reasonable. The ratio of 1. 5 was derived by looking at the current stock prices of Exxon and Mobil, which proportionally showed that for every share of Exxon you would receive one share of Moneybox while one share of Mobil will be equal to 1. 5 shares of Moneybox.

The second ratio of 2 was also considered a possibility engendering that the Mobiles stock performance as well as dividend growth figures are superior to that of Oxen’s. The current stock price for Mobil is $91. 375 on closing of November 5th. The return the market requires is 8. 44% (based on the original dividend assumptions mentioned above and a merger stock ratio of 1. 5). RL and gal. remained constant in all of our scenarios because we truly feel that they are relatively close to the true figures. Under the same assumptions however altering the Merger Stock Ratio to 2, we found that the return the market requires changed to 9. 8%. This means that the market expects more return than the original assumption of the ratio being 1. 5. We created two additional scenarios where go was the changing figure. All assumptions (r 1, re, and gal.) remained at the original assumption values. The first scenario used a ratio of 1. 5, which resulted in a gaff 8. 989%. The second, using a ratio of 2, resulted in a go figure of 8. 043%. These figures represent what the market expects the dividend growth rate of Moneybox to be in the future. CONCLUSION Surprisingly, we found the stock prices of all three companies to be over-valued.

This means that investors are paying too much for these stocks. Obviously, our opinions do not represent those of investors. The oil industry is one that holds many opportunities for growth and golden financial prospects. When investors look at an oil company they do not focus on its value based on rates of return, dividends, and growth. What they see is an industry producing an inelastic good that has endless demand and is one of the most basic necessities. In conclusion, any analysis done on the oil industry will fall short in determining the true value of these companies.