ACC646_wordcom_financial_analysis

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

646

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

27

Uploaded by fisher.burns8

Report
CONSO Current assets $ Property and equipment, net 3 Goodwill and other intangibles 3 Other assets Total assets $ 8 Current liabilities $ 1 Long-term debt 1 Noncurrent liabilities Minority interests Company obligated mandatorily redeemable preferred securities Shareholders' investment 5 Total liabilities and shareholders' investment $ 8 WORLDCO GR
OLIDATING BALANCE SHEET (In millions) AT DECEMBER 31, 2000 ELIMINATIONS WORLDCOM 8,092.00 $ 2,312.00 $ (649.00) $ 9,755.00 35,177.00 2,246.00 - 37,423.00 36,685.00 9,909.00 - 46,594.00 5,939.00 168.00 (976.00) 5,131.00 85,893.00 $ 14,635.00 $ 1,625.00 $ 98,903.00 14,213.00 $ 4,109.00 $ (649.00) $ 17,673.00 11,696.00 6,000.00 - 17,696.00 3,648.00 2,063.00 (976.00) 4,735.00 2,592.00 - - 2,592.00 798.00 - - 798.00 52,946.00 2,463.00 - 55,409.00 85,893.00 $ 14,635.00 $ (1,625.00) $ 98,903.00 OM ROUP MCI GROUP
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CONSO Current assets $ Property and equipment, net 3 Goodwill and other intangibles 4 Other assets Total assets $ 9 Current liabilities $ Long-term debt 2 Noncurrent liabilities Minority interests Company obligated mandatorily redeemable preferred securities Shareholders' investment 5 Total liabilities and shareholders' investment $ 9 WORLDCO GR
OLIDATING BALANCE SHEET (In millions) AT DECEMBER 31, 2001 ELIMINATIONS WORLDCOM 8,179.00 $ 1,926.00 $ (900.00) $ 9,205.00 36,792.00 2,017.00 - 38,809.00 40,818.00 9,719.00 - 50,537.00 6,112.00 227.00 (976.00) 5,363.00 91,901.00 $ 13,889.00 $ 1,876.00 $ 103,914.00 5,915.00 $ 4,195.00 $ (900.00) $ 9,210.00 24,533.00 5,505.00 - 30,038.00 3,742.00 1,876.00 (976.00) 4,642.00 101.00 - - 101.00 1,993.00 - - 1,993.00 55,617.00 2,313.00 - 57,930.00 91,901.00 $ 13,889.00 $ (1,876.00) $ 103,914.00 OM ROUP MCI GROUP
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CONSOLIDATING STA (In Revenues $ 2 Operating expenses: Line costs: Attributed costs (1) Intergroup allocated expenses (2) Selling, general and administrative: Attributed costs (1) Shared corporate services (3) Other intergroup allocated expenses (4) Depreciation and amortization: Attributed costs (1) Intergroup allocated expenses (5) Total 1 Operating income Interest expense Miscellaneous income Income before income taxes, minority interests and cumulative effect of accounting change Provision for income taxes Income before minority interests and cumulative effect of accounting change Minority interests Income before cumulative effect of accounting change Cumulative effect of accounting change Net income before distributions on mandatorily WORLDCO GR
redeemable preferred securities Distributions on mandatorily redeemable preferred securities and other preferred dividend requirements Net income $
ATEMENT OF OPERATIONS millions) YEAR ENDED DECEMBER 31, 2000 ELIMINATIONS WORLDCOM 22,755.00 $ 16,335.00 $ - $ 39,090.00 8,658.00 6,804.00 - 15,462.00 87.00 373.00 (460.00) - 3,682.00 2,981.00 3,934.00 10,597.00 2,007.00 1,927.00 (3,934.00) - - 254.00 (254.00) - 3,907.00 971.00 - 4,878.00 (627.00) (87.00) 714.00 - 17,714.00 13,223.00 - 30,937.00 5,041.00 3,112.00 - 8,153.00 (458.00) (512.00) - (970.00) 385.00 - - 385.00 4,968.00 2,600.00 - 7,568.00 1,990.00 1,035.00 - 3,025.00 2,978.00 1,565.00 - 4,543.00 (305.00) - - (305.00) 2,673.00 1,565.00 - 4,238.00 (75.00) (10.00) - (85.00) OM ROUP MCI GROUP
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2,598.00 1,555.00 - 4,153.00 65.00 - - 65.00 2,533.00 $ 1,555.00 $ - $ 4,088.00
CONSOLIDATING Revenues $ 2 Operating expenses: Line costs: Attributed costs (1) Intergroup allocated expenses (2) Selling, general and administrative: Attributed costs (1) Shared corporate services (3) Other intergroup allocated expenses (4) Depreciation and amortization: Attributed costs (1) Intergroup allocated expenses (5) Total 1 Operating income Interest expense Miscellaneous income Income (loss) before income taxes and minority interests Income tax expense (benefit) Income (loss) before minority interests Minority interests Net income (loss) before distributions on mandatorily redeemable preferred securities Distributions on mandatorily redeemable preferred securities and other preferred dividend requirements Net income (loss) $ WORLDCO GR
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Net income (loss) $
G STATEMENT OF OPERATIONS (In millions) YEAR ENDED DECEMBER 31, 2001 ELIMINATIONS WORLDCOM 21,348.00 $ 13,831.00 $ - $ 35,179.00 8,019.00 6,720.00 - 14,739.00 101.00 360.00 (461.00) - 4,052.00 3,438.00 3,556.00 11,046.00 2,006.00 1,550.00 3,556.00 - - 360.00 (360.00) - 4,841.00 1,039.00 - 5,880.00 (627.00) (87.00) 714.00 - 18,299.00 13,366.00 - 31,665.00 3,049.00 465.00 - 3,514.00 1,029.00 (504.00) - (1,533.00) 412.00 - - 412.00 2,432.00 (39.00) - 2,393.00 943.00 (16.00) - 927.00 1,489.00 (23.00) - 1,466.00 35.00 - - 35.00 1,524.00 (23.00) - (1,501.00) 117.00 - - 117.00 1,407.00 $ (23.00) $ - $ 1,384.00 OM ROUP MCI GROUP
1,407.00 1,407.00 $ (23.00) $ - $ 1,384.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Financial Analysis 2000 Gross Margin Percent Gross margin as a percentage is: Gross Margin = (Total Revenue – Cost of Goods Sold)/Total Revenue x 100. Worldcom's revenue for FY2000 was $ 39,090.00 Worldcoms COGS for FY2000 was $ 30,937.00 Gross margin $ 8,153.00 % Return on Sales Return on sales: Worldcom's EBIT for FY2000 is calculated Net income $ 4,088.00 Interest expense $ 970.00 Taxes $ 3,025.00 EBIT $ 8,083.00 Worldcom 2000 net sales $ 39,090.00 21% Return on assets Return on assets: Net profits ÷ Total assets. Worldcom's return on assets for FY2000 is calculated Net income $ 4,088.00 Total assets $ 98,903.00 4 % Return on equity Return on equity: Worldcom's Return on equity for FY2000 is calculated Revenue $ 39,090.00 Expenses $ 30,937.00 Net income $ 4,088.00 $8,153.00 ÷ $39,090.00 × 100 Earnings Before Interest and Taxes ÷ Net sales. Return on sales (8,083.00 ÷ 39,090.00) Return on assets ($4,088.00 ÷ $98,903.00) To calculate the return on equity, divide net income by the total amount of equity or Net income ÷ Equity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Shareholders' Equity 2000 $ 55,409.00 7 % Total Asset Turnover Total asset turnover: Worldcom's Total asset turnover for FY2000 is calculated: Revenue $ 39,090.00 Total assets $ 98,903.00 % Accounts Receivable Turnover Accounts receivable turnover: Worldcom's accounts receivable turnover for FY2000 is calculated: Net credit sales $ 39,090.00 Beginning Accounts Receivable $ 6,815.00 5.73 Accounts Receivable Days Accounts receivable days: Worldcom's accounts receivable days for FY2000 is calculated: Beginning Accounts Receivable $ 6,815.00 Annual Revenue $ 39,090.00 63.63 % Debt to Assets Ratio Debt to assets ratio: Worldcoms debt to assets ratio for FY2000 is calculated: Total liabilities $ 43,494.00 Return on equity = ($4,088.00 ÷ 55,409) To calculate total asset turnover, divide net sales by total assets or Net sales ÷ Total assets Total asset turnover ($39,090.00 ÷ $98,903.00) To calculate accounts receivable turnover, add together beginning and ending accounts receivable to arrive at the average accounts receivable for the measurement period, and divide into the net credit sales for the year or Net Annual Credit Sales ÷ ((Beginning Accounts Receivable + Ending Accounts Receivable) / 2) Total asset turnover ($39,090.00 ÷ $6,815.00) To calculate accounts receivable days, divided accounts receivable by annual revenue mutiplied by the number of days in the year or (Accounts receivable ÷ Annual revenue) x Number of days in the year Accounts receivable days ($9,755.00 ÷ $39,090.00) × 365 To calculate debt to assets ratio, divide total liabilities by total assets or Total liabilities ÷ Total assets
Total assets $ 98,903.00 44 % $ 55,409.00 $ 98,903.00 56 % Debt to Equity Debt to equity: Worldcom's debt to equity for FY2000 is calculated: $ 18,494.00 $ 55,409.00 33 % Equity Multiplier Equity multiplier: Worldcoms equity multiplier for FY2000 is calculated: $ 98,903.00 $ 55,409.00 1.78 % Current Ratio Current ratio: Worldcom's current ratio for FY2000 is calculated: Current assets $ 9,775.00 Current liabilities $ 17,673.00 6 % Debt to assets ratio ($43,494.00 ÷ $98,903.00) Shareholder's Equity Ratio Shareholder's equity ratio: To calculate Shareholder's equity ratio, divide total shareholder equity by total assets or Total Shareholder Equity ÷ Total Assets Worldcom's shareholder equity ratio for FY2000 is calculated: Total shareholder equity Total assets Shareholder's equity ratio ($55,409.00 ÷ $98,903.00) To calculate debt to equity, divide short term debt + long term debt + other fixed payments by total shareholder equity Total Liabilitiess ÷ Total Shareholder Equity Total Liabilities Total shareholder equity Debt to equity ($18,494.00 ÷ $55,409.00) To calculate equity multiplier, divide total assets by total shareholder equity or Total Assets ÷ Total Shareholder Equity Total assets Total shareholder equity Equity Multiplier ($98,903.00 ÷ $55,409.00) To calculate current ratio, divide current assets by current liabilities or Current Assets ÷ Current Liabilities Current ratio ($9,775.00 ÷ $17,673.00)
6 % Net Working Capital Net working capital: Worldcom's net working capital for FY2000 is calculated: Current assets $ 9,775.00 Current liabilities $ 17,673.00 -7,898.00 Price Earnings P/E Ratio Price earnings P/E ratio: Worldcom's price earnings for FY2000 is calculated: Market Value of Price Per Share (yearly average) $ 32.13 Earnings per Share $ 1.37 23.45 Earnings Per Shares Earnings per shares: Worldcom's earnings per shares for FY2000 is calculated: Net Income $ 4,088.00 Shares Outstanding 2,962,645,459 $ 1.37 Book Value Per Share Book value per share: Current ratio ($9,775.00 ÷ $17,673.00) To calculate net working capital, subtract current assets from current liabilities or Current Assets – Current Liabilities Net working capital ($9,775.00 - $17,673.00) To calculate price earnings, divided market value of price per share by earning per share or Market Value per Share ÷ Earnings per Share. Price earnings P/E ratio ($32.13 ÷ $1.37) To calculate earnings per shares, subtract perferred dividends from net income and divided the total by weighted average shares outstanding or (Net Income - Perferred Dividends) ÷ Weighted Average Shares Outstanding Earnings per share ($4,088.00 ÷ 2,962,645,459) To calculate book value per share, subtract preferred equity from total shareholder equity and divided the total by total outstanding shares or (Total Shareholder Equity - Preferred Equity) ÷ Total Outstanding Shares.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Worldcom's book value per share for FY2000 is calculated: Total Shareholder Equity $ 55,409.00 Shares Outstanding 2,962,645,459 1.87 Book value per share ($55,09.00 ÷ 2,962,645,459)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Financial Analysis 2001 Gross Margin Percent Gross margin as a percentage is: Gross Margin = (Total Revenue – Cost of Goods Sold)/Total Revenue x 100. Worldcom's revenue for FY2001 was $ 35,179.00 Worldcoms COGS for FY2000 was $ 31,665.00 Gross margin $ 3,514.00 10% % Return on Sales Return on sales: Worldcom's EBIT for FY2001 is calculated Net income $ 1,384.00 Interest expense $ 1,533.00 Taxes $ 3,025.00 EBIT $ 5,942.00 Worldcom 2001 net sales $ 35,179.00 17% Return on assets Return on assets: Net profits ÷ Total assets. Worldcom's return on assets for FY2001 is calculated Net income $ 1,384.00 Total assets $ 103,914.00 Return on assets ($1,384.00 ÷ $103,914.00) % Return on equity Return on equity: Worldcom's Return on equity for FY2001 is calculated Revenue $ 35,179.00 Expenses $ 31,665.00 Net income $ 1,384.00 $3,514.00 ÷ $35,179.00 × 100 Earnings Before Interest and Taxes ÷ Net sales. Return on sales (5,942.00 ÷ 35,179.00) To calculate the return on equity, divide net income by the total amount of equity or Net income ÷ Equity
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Average Shareholders' Equity $ 56,669.00 Return on equity 2 % Total Asset Turnover Total asset turnover: Worldcom's Total asset turnover for FY2000 is calculated: Revenue $ 35,179.00 $ 101,409.00 % Accounts Receivable Turnover Accounts receivable turnover: Worldcom's accounts receivable turnover for FY2001 is calculated: Net credit sales $ 35,179.00 $ 6,062.00 5.8 Accounts Receivable Days Accounts receivable days: Worldcom's accounts receivable days for FY2001 is calculated: Beginning Accounts Receivable $ 5,308.00 Annual Revenue $ 35,179.00 55.07 % Debt to Assets Ratio Debt to assets ratio: Worldcoms debt to assets ratio for FY2001 is calculated: To calculate total asset turnover, divide net sales by total assets or Net sales ÷ Total assets Begining assets + Ending assets ÷ 2 Total asset turnover ($35,179.00 ÷ $101,409.00) To calculate accounts receivable turnover, add together beginning and ending accounts receivable to arrive at the average accounts receivable for the measurement period, and divide into the net credit sales for the year or Net Annual Credit Sales ÷ ((Beginning Accounts Receivable + Ending Accounts Receivable) / 2) Beginning Accounts Receivable + Ending Accounts Receivable ÷ 2 Total asset turnover ($39,090.00 ÷ $6,062.00) To calculate accounts receivable days, divided accounts receivable by annual revenue mutiplied by the number of days in the year or (Accounts receivable ÷ Annual revenue) x Number of days in the year Accounts receivable days ($5,308.00 ÷ $39,179.00) × 365 To calculate debt to assets ratio, divide total liabilities by total assets or Total liabilities ÷ Total assets
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Total liabilities $ 45,984.00 Total assets $ 103,914.00 44 % $ 57,930.00 $ 103,914.00 56 % Debt to Equity Debt to equity: Worldcom's debt to equity for FY2001 is calculated: $ 32,031.00 $ 57,930.00 55 % Equity Multiplier Equity multiplier: Worldcoms equity multiplier for FY2001 is calculated: $ 103,914.00 $ 57,930.00 1.79 % Current Ratio Current ratio: Worldcom's current ratio for FY2001 is calculated: Current assets $ 9,205.00 Current liabilities $ 9,210.00 Debt to assets ratio ($45,984.00 ÷ $103,914.00) Shareholder Equity Ratio Shareholder equity ratio: To calculate Shareholder equity ratio, divide total shareholder equity by total assets or Total Shareholder Equity ÷ Total Assets Worldcom's shareholder equity ratio for FY2001 is calculated: Total shareholder equity Total assets Shareholder's equity ratio ($57,930.00 ÷ $98,903.00) To calculate debt to equity, divide short term debt + long term debt + other fixed payments by total shareholder equity Total Liabilitiess ÷ Total Shareholder Equity Total Liabilities Total shareholder equity Debt to equity ($32,031.00 ÷ $57,930.00) To calculate equity multiplier, divide total assets by total shareholder equity or Total Assets ÷ Total Shareholder Equity Total assets Total shareholder equity Equity Multiplier ($103,91400 ÷ $57,930.00) To calculate current ratio, divide current assets by current liabilities or Current Assets ÷ Current Liabilities
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10 % Net Working Capital Net working capital: Worldcom's net working capital for FY2000 is calculated: Current assets $ 9,205.00 Current liabilities $ 9,210.00 -5.00 Price Earnings P/E Ratio Price earnings P/E ratio: Worldcom's price earnings for FY2001 is calculated: Market Value of Price Per Share (two quarter average) $ 19.13 Earnings per Share $ 4.62 $ 4.14 Earnings Per Shares Earnings per shares: Worldcom's earnings per shares for FY2001 is calculated: Net Income $ 1,384.00 Shares Outstanding 2,962,645,459 $ 4.62 Book Value Per Share Book value per share: Current ratio ($9,205.00 ÷ $17,673.00) To calculate net working capital, subtract current assets from current liabilities or Current Assets – Current Liabilities Net working capital ($9,205.00 - $9,210.00) To calculate price earnings, divided market value of price per share by earning per share or Market Value per Share ÷ Earnings per Share. Price earnings P/E ratio ($19.13 ÷ $4.62) To calculate earnings per shares, subtract perferred dividends from net income and divided the total by weighted average shares outstanding or (Net Income - Perferred Dividends) ÷ Weighted Average Shares Outstanding Earnings per share ($1,384.00 ÷ 2,962,645,459) To calculate book value per share, subtract preferred equity from total shareholder equity and divided the total by total outstanding shares or (Total Shareholder Equity - Preferred Equity) ÷ Total Outstanding Shares.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Worldcom's book value per share for FY2000 is calculated: Total Shareholder Equity $ 57,930.00 Shares Outstanding 2,962,645,459 1.95 Preferred Equity) ÷ Total Outstanding Shares. Book value per share ($57,930.00 ÷ $2,962,645,459)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help