Using Excel and WorldComs income statement and balance sheet for 2001, provided on pages F-2 and F-3 of Form 10-K, ( http://www.sec.gov/Archives/edgar/data/723527/000100547702001226/d02-36461.txt) prepare a common-size balance sheet and income statement for the years 2000 and 2001. Using formulas, compute the following ratios: gross margin percent, return on sales, return on assets, return on equity, total asset turnover, accounts receivable turnover, accounts receivable days, debt to assets, equity to assets, debt to equity, equity multiplier, current ratio, acid test, net working capital, book value per share, earnings per share, and price earnings.

***see below for pages f-2 and f-3 of form 10-k****

 F-2  WORLDCOM, INC. AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In Millions, Except Share Data) 
 
 December 31, December 31, 2000 2001 ------------ ------------    ASSETS Current assets: Cash and cash equivalents $ 761 $ 1,416 Accounts receivable, net of allowance for bad debts of $1,532 in 2000 and $1,086 in 2001 6,815 5,308 Deferred tax asset 172 251 Other current assets 2,007 2,230 --------- --------- Total current assets 9,755 9,205 --------- --------- Property and equipment: Transmission equipment 20,288 23,814 Communications equipment 8,100 7,878 Furniture, fixtures and other 9,342 11,263 Construction in progress 6,897 5,706 --------- --------- 44,627 48,661 Accumulated depreciation (7,204) (9,852) --------- --------- 37,423 38,809 --------- --------- Goodwill and other intangible assets 46,594 50,537 Other assets 5,131 5,363 --------- --------- $ 98,903 $ 103,914 ========= ========= LIABILITIES AND SHAREHOLDERS' INVESTMENT Current liabilities: Short-term debt and current maturities of long-term debt $ 7,200 $ 172 Accrued interest 446 618 Accounts payable and accrued line costs 6,022 4,844 Other current liabilities 4,005 3,576 --------- --------- Total current liabilities 17,673 9,210 --------- --------- Long-term liabilities, less current portion: Long-term debt 17,696 30,038 Deferred tax liability 3,611 4,066 Other liabilities 1,124 576 --------- --------- Total long-term liabilities 22,431 34,680 --------- --------- Commitments and contingencies Minority interests 2,592 101 Company obligated mandatorily redeemable and other preferred securities 798 1,993 Shareholders' investment: Series B preferred stock, par value $.01 per share; authorized, issued and outstanding: 10,693,437 shares in 2000 and none in 2001 (liquidation preference of $1.00 per share plus unpaid dividends) -- -- Preferred stock, par value $.01 per share; authorized: 31,155,008 shares in 2000 and 30,967,637 shares in 2001; none issued -- -- Common stock: WorldCom, Inc. common stock, par value $.01 per share; authorized: 5,000,000,000 shares in 2000 and none in 2001; issued and outstanding: 2,887,960,378 shares in 2000 and none in 2001 29 -- WorldCom group common stock, par value $.01 per share; authorized: none in 2000 and 4,850,000,000 shares in 2001; issued and outstanding : none in 2000 and 2,967,436,680 shares in 2001 -- 30 MCI group common stock, par value $.01 per share; authorized: none in 2000 and 150,000,000 shares in 2001; issued and outstanding: none in 2000 and 118,595,711 in 2001 -- 1 Additional paid-in capital 52,877 54,297 Retained earnings 3,160 4,400 Unrealized holding gain (loss) on marketable equity securities 345 (51) Cumulative foreign currency translation adjustment (817) (562) Treasury stock, at cost, 6,765,316 shares of WorldCom, Inc. in 2000, 6,765,316 shares of WorldCom group stock and 270,613 shares of MCI group stock in 2001 (185) (185) --------- --------- Total shareholders' investment 55,409 57,930 --------- --------- $ 98,903 $ 103,914 ========= ========= 
 The accompanying notes are an integral part of these statements. F-3  WORLDCOM, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF OPERATIONS (In Millions, Except Per Share Data) 
 
 For the Years Ended December 31, ---------------------------------- 1999 2000 2001 -------- -------- --------     Revenues $ 35,908 $ 39,090 $ 35,179 -------- -------- -------- Operating expenses: Line costs 14,739 15,462 14,739 Selling, general and administrative 8,935 10,597 11,046 Depreciation and amortization 4,354 4,878 5,880 Other charges (8) -- -- -------- -------- -------- Total 28,020 30,937 31,665 -------- -------- -------- Operating income 7,888 8,153 3,514 Other income (expense): Interest expense (966) (970) (1,533) Miscellaneous 242 385 412 -------- -------- -------- Income before income taxes, minority interests and cumulative effect of accounting change 7,164 7,568 2,393 Provision for income taxes 2,965 3,025 927 -------- -------- -------- Income before minority interests and cumulative effect of accounting change 4,199 4,543 1,466 Minority interests (186) (305) 35 -------- -------- -------- Income before cumulative effect of accounting change 4,013 4,238 1,501 Cumulative effect of accounting change (net of income tax of $50 in 2000) -- (85) -- -------- -------- -------- Net income 4,013 4,153 1,501 Distributions on mandatorily redeemable preferred securities and other preferred dividend requirements 72 65 117 -------- -------- -------- Net income applicable to common shareholders $ 3,941 $ 4,088 $ 1,384 ======== ======== ======== Net income attributed to WorldCom group before cumulative effect of accounting change $ 2,294 $ 2,608 $ 1,407 ======== ======== ======== Cumulative effect of accounting change $ -- $ (75) $ -- ======== ======== ======== Net income attributed to WorldCom group $ 2,294 $ 2,533 $ 1,407 ======== ======== ======== Net income (loss) attributed to MCI group before cumulative effect of accounting change $ 1,647 $ 1,565 $ (23) ======== ======== ======== Cumulative effect of accounting change $ -- $ (10) $ -- ======== ======== ======== Net income (loss) attributed to MCI group $ 1,647 $ 1,555 $ (23) ======== ======== ======== 
     Earnings (loss) per common share: PRO FORMA WorldCom group: ---------------------------------- Net income attributed to WorldCom group before cumulative effect of accounting change: Basic $ 0.81 $ 0.91 $ 0.48 ======== ======== ======== Diluted $ 0.78 $ 0.90 $ 0.48 ======== ======== ======== Cumulative effect of accounting change $ -- $ (0.03) $ -- ======== ======== ======== Net income attributed to WorldCom group: Basic $ 0.81 $ 0.88 $ 0.48 ======== ======== ======== Diluted $ 0.78 $ 0.87 $ 0.48 ======== ======== ======== MCI group: Net income (loss) attributed to MCI group before cumulative effect of accounting change: Basic $ 14.32 $ 13.61 $ (0.20) ======== ======== ======== Diluted $ 14.32 $ 13.61 $ (0.20) ======== ======== ======== Cumulative effect of accounting change $ -- $ (0.09) $ -- ======== ======== ======== Net income (loss) attributed to MCI group: Basic $ 14.32 $ 13.52 $ (0.20) ======== ======== ======== Diluted $ 14.32 $ 13.52 $ (0.20) ======== ======== ======== 
 The accompanying notes are an integral part of these statements.