research paper about Apollo Group Inc (APOL) needed some finance

profilealaa_1
i_did_the_finanical_part_but_you_need_to_anlazy_them.xlsx

b1

APOLLO GROUP INC -CL A ANNUAL BALANCE SHEET
TICKER: APOL ($ MILLIONS)
SIC: 8200
GICS: 25302010 FINANCIAL RATIOS
12-Aug 11-Aug 10-Aug 9-Aug 8-Aug 12-Dec 11-Dec 10-Dec
ASSETS Liquidity Ratio:
Cash & Equivalents 1,594.71 1,951.07 1,728.90 1,400.55 870.41 Quick ratio 1.17 1.43 1.26
Net Receivables 198.279 215.567 264.377 298.27 221.919 Cash ratio= 0.9635476868 1.1786904627 0.9639756879
Inventories 0 0 0 0 0 Leverage ratio:
Prepaid Expenses 26.341 35.629 39.409 @CF @CF Total debt ratio 1.00 1.00 1.00
Other Current Assets 118.661 168.519 220.525 181.197 77.214 Asset Management:
------------------ ------------------ ------------------ ------------------ ------------------ Total Asset turnover 2.194715659 1.9963936011 2.1861320639
Total Current Assets 1,937.99 2,370.79 2,253.21 1,880.02 1,169.54 Receivable turnover 21.4512732059 21.9561528434 18.6317985301
Gross Plant, Property & Equipment 1,221.28 1,104.84 1,094.32 965.31 873.94 Profitability Measures:
Accumulated Depreciation 649.648 551.813 474.78 407.803 434.805 Return on Equity 422.678 572.427 553.002
------------------ ------------------ ------------------ ------------------ ------------------ Profit Margin 0.0993756197 0.1209432367 0.1122660008
Net Plant, Property & Equipment 571.629 553.027 619.537 557.507 439.135 Market Value Measure:
Investments at Equity 0 0 0 0 0 Price-Earnings per ratio 5.7959770115 0.1212098765 10.4532967033
Other Investments 5.946 5.946 15.174 19.579 42.966
Intangibles 252.379 254.414 472.752 726.029 109.064
Deferred Charges 0 0 0 @CF 0
Other Assets 100.378 85.533 240.776 80.245 99.704
------------------ ------------------ ------------------ ------------------ ------------------
TOTAL ASSETS 2,868.32 3,269.71 3,601.45 3,263.38 1,860.41
LIABILITIES
Long Term Debt Due In One Year 638.588 419.318 416.361 461.365 15.4
Notes Payable 0 0 0 @CF 0
Accounts Payable 74.872 69.551 90.83 66.928 46.589
Taxes Payable 0 0 0 0 6.111
Accrued Expenses 264.698 398.806 375.461 268.418 121.2
Other Current Liabilities 676.881 767.612 910.859 958.567 676.309
------------------ ------------------ ------------------ ------------------ ------------------
Total Current Liabilities 1,655.04 1,655.29 1,793.51 1,755.28 865.609
Long Term Debt 81.323 179.691 168.039 127.701 15.516
Deferred Taxes 15.881 26.4 38.875 55.636 2.743
Investment Tax Credit 0 0 0 0 0
Other Liabilities 191.756 164.339 212.286 100.149 130.379
------------------ ------------------ ------------------ ------------------ ------------------
Liabilities - Total 1,944.00 2,025.72 2,212.71 2,038.76 1,014.25
Redeemable Noncontrolling Int. 0 0 0 67.003 11.956
APOLLO GROUP INC -CL A 12-Aug 11-Aug 10-Aug 9-Aug 8-Aug
EQUITY
Preferred Stock - Redeemable 0 0 0 0 0
Preferred Stock - Nonredeemable 0 0 0 0 0
------------------ ------------------ ------------------ ------------------ ------------------
Total Preferred Stock 0 0 0 0 0
Common Stock 0.104 0.104 0.104 0.104 0.104
Capital Surplus 93.77 68.724 46.865 1.139 0
Retained Earnings 4,713.12 4,296.71 3,716.87 3,178.99 2,591.38
Less: Treasury Stock 3,878.61 3,125.18 2,407.79 2,022.62 1,757.28
------------------ ------------------ ------------------ ------------------ ------------------
Common Equity 928.378 1,240.36 1,356.05 1,157.61 834.209
------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Parent 928.378 1,240.36 1,356.05 1,157.61 834.209
Nonredeemable Noncontrolling Int. -4.055 3.625 32.69 0 @NA
------------------ ------------------ ------------------ ------------------ ------------------
Stockholder's Equity - Total 924.323 1,243.99 1,388.74 1,157.61 @NA
------------------ ------------------ ------------------ ------------------ ------------------
TOTAL LIABILITIES & EQUITY 2,868.32 3,269.71 3,601.45 3,263.38 1,860.41
COMMON SHARES OUTSTANDING 112.243 130.479 147.768 154.736 158.946
APOLLO GROUP INC -CL A ANNUAL INCOME STATEMENT
TICKER: APOL ($ MILLIONS, EXCEPT PER SHARE)
SIC: 8200
GICS: 25302010
12-Aug 11-Aug 10-Aug 9-Aug 8-Aug
Sales 4,253.34 4,733.02 4,925.82 3,974.20 3,140.93
Cost of Goods Sold 1,800.17 1,774.09 1,978.05 1,503.83 1,292.48
------------------- ------------------ ------------------ ------------------ ------------------
Gross Profit 2,453.16 2,958.94 2,947.77 2,470.37 1,848.45
Selling, General, &
Administrative Expense 1,538.42 1,606.10 1,427.46 1,241.13 1,020.59
------------------- ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. 914.745 1,352.84 1,520.31 1,229.25 827.866
Depreciation, Depletion, &
Amortization 178.2 159.006 147.035 99.872 78.4
------------------- ------------------ ------------------ ------------------ ------------------
Operating Profit 736.545 1,193.83 1,373.28 1,129.38 749.466
Interest Expense 11.745 8.931 11.891 4.46 3.5
Non-Operating Income/Expense 1.663 1.634 2.235 11.715 27.388
Special Items -60.208 -232.589 -362.552 -95.416 9.5
------------------- ------------------ ------------------ ------------------ ------------------
Pretax Income 666.255 953.947 1,001.07 1,041.22 782.854
Total Income Taxes 283.072 420.638 464.063 445.985 306.927
------------------- ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary Items
& Noncontrolling Interests 383.183 533.309 537.005 595.23 @NA
Noncontrolling Interest - Inc Acc -10.543 -36.631 -31.421 -3.089 -0.598
------------------- ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations 393.726 569.94 568.426 598.319 476.525
Preferred Dividends 0 0 0 0 0
------------------- ------------------ ------------------ ------------------ ------------------
Available for Common 393.726 569.94 568.426 598.319 476.525
Savings Due to Common
Stock Equivalents 0 0 0 0 0
------------------- ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common 393.726 569.94 568.426 598.319 476.525
Extraordinary Items 0 0 0 0 0
Discontinued Operations 28.952 2.487 -15.424 0 0
------------------- ------------------ ------------------ ------------------ ------------------
Adjusted Net Income 422.678 572.427 553.002 598.319 476.525
Income to Company Incl Extrordinary
Items & Disc Ops 412.135 535.796 521.581 595.23 @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op 3.24 4.03 3.74 3.79 2.9
Earnings Per Share Basic -
Including Extra Items & Disc Op 3.48 4.05 3.64 3.79 2.9
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op 3.22 4.02 3.72 3.75 2.87
Earnings Per Share Diluted -
Including Extra Items & Disc Op 3.45 4.04 3.62 3.75 2.87
EPS Basic from Operations 3.58 4.96 5.38 4.26 2.87
EPS Diluted from Ops 3.56 4.95 5.35 4.22 2.84
Dividends Per Share 0 0 0 0 0
Com Shares for Basic EPS 121.607 141.269 151.955 157.76 164.109
Com Shares for Diluted EPS 122.357 141.75 152.906 159.514 165.87
APOLLO GROUP INC -CL A ANNUAL INCOME STATEMENT
TICKER: APOL ($ MILLIONS, EXCEPT PER SHARE)
SIC: 8200
GICS: 25302010
12-Aug 11-Aug 10-Aug 9-Aug 8-Aug
Sales 4,253.34 4,733.02 4,925.82 3,974.20 3,140.93
Cost of Goods Sold 1,800.17 1,774.09 1,978.05 1,503.83 1,292.48
------------------- ------------------ ------------------ ------------------ ------------------
Gross Profit 2,453.16 2,958.94 2,947.77 2,470.37 1,848.45
Selling, General, &
Administrative Expense 1,538.42 1,606.10 1,427.46 1,241.13 1,020.59
------------------- ------------------ ------------------ ------------------ ------------------
Operating Income Before Deprec. 914.745 1,352.84 1,520.31 1,229.25 827.866
Depreciation, Depletion, &
Amortization 178.2 159.006 147.035 99.872 78.4
------------------- ------------------ ------------------ ------------------ ------------------
Operating Profit 736.545 1,193.83 1,373.28 1,129.38 749.466
Interest Expense 11.745 8.931 11.891 4.46 3.5
Non-Operating Income/Expense 1.663 1.634 2.235 11.715 27.388
Special Items -60.208 -232.589 -362.552 -95.416 9.5
------------------- ------------------ ------------------ ------------------ ------------------
Pretax Income 666.255 953.947 1,001.07 1,041.22 782.854
Total Income Taxes 283.072 420.638 464.063 445.985 306.927
------------------- ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary Items
& Noncontrolling Interests 383.183 533.309 537.005 595.23 @NA
Noncontrolling Interest - Inc Acc -10.543 -36.631 -31.421 -3.089 -0.598
------------------- ------------------ ------------------ ------------------ ------------------
Income Before Extraordinary
Items & Discontinued Operations 393.726 569.94 568.426 598.319 476.525
Preferred Dividends 0 0 0 0 0
------------------- ------------------ ------------------ ------------------ ------------------
Available for Common 393.726 569.94 568.426 598.319 476.525
Savings Due to Common
Stock Equivalents 0 0 0 0 0
------------------- ------------------ ------------------ ------------------ ------------------
Adjusted Available for Common 393.726 569.94 568.426 598.319 476.525
Extraordinary Items 0 0 0 0 0
Discontinued Operations 28.952 2.487 -15.424 0 0
------------------- ------------------ ------------------ ------------------ ------------------
Adjusted Net Income 422.678 572.427 553.002 598.319 476.525
Income to Company Incl Extrordinary
Items & Disc Ops 412.135 535.796 521.581 595.23 @NA
Earnings Per Share Basic -
Excluding Extra Items & Disc Op 3.24 4.03 3.74 3.79 2.9
Earnings Per Share Basic -
Including Extra Items & Disc Op 3.48 4.05 3.64 3.79 2.9
Earnings Per Share Diluted-
Excluding Extra Items & Disc Op 3.22 4.02 3.72 3.75 2.87
Earnings Per Share Diluted -
Including Extra Items & Disc Op 3.45 4.04 3.62 3.75 2.87
EPS Basic from Operations 3.58 4.96 5.38 4.26 2.87
EPS Diluted from Ops 3.56 4.95 5.35 4.22 2.84
Dividends Per Share 0 0 0 0 0
Com Shares for Basic EPS 121.607 141.269 151.955 157.76 164.109
Com Shares for Diluted EPS 122.357 141.75 152.906 159.514 165.87