Phillips Petroleum is an integrated oil and gas company with headquarters in Bartlesville, Oklahoma, where it was founded in 1917. The company engages in petroleum exploration and production worldwide. In addition, it engages in natural gas gathering and processing, as well as petroleum refining and marketing primarily in the United States. The company has three operating groups: Exploration and Production, Gas and Gas Liquids, and Downstream Operations, which encompasses Petroleum Products and Chemicals. In the mid- 1980s, Phillips engaged in a major restructuring following two failed takeover at-tempts, one led by T. Boone Pickins and the other by Carl Ichan. 3 The restructuring resulted in a $ 4.5 billion plan to exchange a package of cash and debt securities for roughly half the company€™s shares and to sell $ 2 billion worth of assets. Phillips€™s long- term debt increased from $ 3.4 billion in late 1984 to a peak of $ 8.6 billion in April 1985.
During 1992, Phillips was able to strengthen its financial structure dramatically. Its subsidiary Phil-lips Gas Company completed an offering of $ 345 million of Series A 9.32% cumulative preferred stock. As a result of this action and prior years€™ debt reductions, the company lowered its long- term debt- to- capital ratio over the past 5 years from 75 percent to 55 percent. In addition, the firm re-financed over a billion dollars of its debt at reduced rates. A company spokesman said, €œOur debt-to- capital ratio is still on the high side, and we€™ll keep working to bring it down. But the cost of debt is manageable, and we€™re beyond the point where debt overshadows everything else we do.€ 4 Highlights of Phillips€™s financial condition from 1986 to 1992 are found in the accompanying table. These data reflect the company€™s financial restructuring following the downsizing and reorganization of Phillips€™s operations begun in the mid- 1980s.

Phillips€™s managers are currently developing its financial plans for the next 5 years and want to develop a forecast of its financing requirements. As a first approximation, they have asked you to develop a model that can be used to make €œballpark€ estimates of the firm€™s financing needs under the proviso that existing relationships found in the firm€™s financial statements remain the same over the period. Of particular interest is whether Phillips will be able to further reduce its reliance on debt financing. You may assume that Phillips€™s projected sales (in millions) for 1993 through 1997 are as follows: $ 13,000; $ 13,500; $ 14,000; $ 14,500; and $ 15,500.
a. Project net income for 1993 to 1997 using the percent of sales method based on an average of this ratio for 1986 to 1992.
b. Project total assets and current liabilities for 1993 to 1997 using the percent of sales method and your sales projections from part (a).
c. Assuming that common equity increases only as a result of the retention of earnings and holding long- term debt and preferred stock equal to its 1992 balances, project Phillips€™s discretionary financing needs for 1993 to 1997.

Transcribed Image Text:

Summary Financial Information for Phillips Petroleum Corporation: 1986 to 1992 (in Millions of Dollars Except for per Share Figures) 1986 1987 1988 1989 1990 1991 1992 Sales 10,018.00 Net income $10,917.00 $11,490.00 $12,492.00 $13,975.00 $13,259.00 $12,140.00 228.00 0.89 35.00 650. 219.00 541.00 98.00 270.00 2.18 EPS Current assets Total assets Current liabilities Long-term debt Total liabilities Preferred stock Common equity Dividends per share 2,802.00 2855.00 3,062.00 2,876.00 3322.00 2459.00 2349.00 12,403.00 12,111.00 11,968.00 11,256.00 2,130.00 11473.00 11,468.00 223400 2402.00 2,468.00 2,70600 291000 2503.00 2,517.00 8,175.00 8700 7,387.00 641800 6,505.00 6,113.00 5,894.00 10,409.00 10289.00 9,855.00 9,12400 9411.00 8716.00 8411.00 359.00 1724.00 161700 2,113.00 2,132.00 2,719.00 275700 2,698.00 1.12 270.00 205.00 0.00 2.02 1.73 1.03 1.12