Financial Ratio Calculations
SuperClass12 Month Period Ending: Currency is US Dollar | 2/1/2014 | 2/2/2013 | 1/28/2012 | 1/29/2011 | 1/30/2010 |
Revenue and Gross Profit | |||||
Total Revenue | 12,540 | 12,134 | 10,860 | 9,700 | 8,627 |
Operating Expenses | |||||
Cost of Revenue, Total | 7,737 | 7,432 | 6,592 | 5,897 | 5,328 |
Sell/Gen/AdminExpenses,Tot | 3,453 | 3,357 | 3,019 | 2,685 | 2,465 |
Unusual Expense (Income) | -- | -- | -- | -- | 0 |
Total Operating Expense | 11,190 | 10,789 | 9,611 | 8,582 | 7,793 |
Operating Income | 1,350 | 1,345 | 1,249 | 1,118 | 834 |
Non-Operating Income & Expenses | |||||
Inter Expse, Non-Operating | (176) | (167) | (139) | (133) | (148) |
Inter Capital, Non-Operat | 14 | 5.00 | 7.00 | 5.00 | 7.00 |
Inter Expse,Net Non-Operat | (162) | (162) | (132) | (128) | (141) |
Inter/Invest Inc, Non-Oper | 1.00 | 2.00 | 2.00 | 1.00 | 3.00 |
Income Before Tax | 1,189 | 1,185 | 1,119 | 991 | 696 |
Income Taxes | |||||
Income Tax - Total | 455 | 450 | 436 | 378 | 255 |
Income After Tax | 734 | 735 | 683 | 613 | 441 |
Minority Interest and Equity in Affiliates | |||||
Net Inc Before Extra Items | 734 | 735 | 683 | 613 | 441 |
Net Income | 734 | 735 | 683 | 613 | 441 |
Adjustments to Net Income | |||||
Income Available to Common Excl. Extra. Items | 734 | 735 | 683 | 613 | 441 |
Income Available to Common Incl. Extra. Items | 734 | 735 | 683 | 613 | 441 |
EPS Reconciliation | |||||
Basic/Primary Weighted Average Shares | 195 | 203 | 214 | 219 | 217 |
Basic/Primary EPS Excl. Extra. Items | 3.77 | 3.62 | 3.20 | 2.80 | 2.03 |
Basic/Primary EPS Incl. Extra. Items | 3.77 | 3.62 | 3.20 | 2.80 | 2.03 |
Dilution Adjustment | 0 | 1 | 0 | -- | -- |
Diluted Weighted Average Shares | 198 | 207 | 218 | 223 | 220 |
Diluted EPS Excl. Extra. Items | 3.71 | 3.56 | 3.14 | 2.75 | 2.01 |
Diluted EPS Incl. Extra. Items | 3.71 | 3.56 | 3.14 | 2.75 | 2.01 |
Common Stock Dividends | |||||
Div/Share-ComStockPrimIssue | 1.20 | 1.08 | 0.92 | 0.76 | 0.64 |
Gross Divid - Common Stock | 234 | 220 | 197 | 167 | 139 |
Pro Forma Income | |||||
Pro Forma Net Income | -- | -- | -- | -- | -- |
Supplemental Items | |||||
Interest Expense, Suppl | 162 | 162 | 132 | 128 | 141 |
Interest Capitalized, Suppl | (14) | (5.00) | (7.00) | (5.00) | (7.00) |
Depreciat/Amort, Suppl | 444 | 410 | 371 | 327 | 313 |
Normalized Income | |||||
Total Special Items | -- | -- | -- | -- | 0 |
Normalzd Income Before Tax | 1,189 | 1,185 | 1,119 | 991 | 696 |
Efct/SpecItemsIncTxs (STEC) | -- | -- | -- | -- | 0 |
IncTxsExcl ImpctofSpec Itms | 455 | 450 | 436 | 378 | 255 |
Normalized Income After Tax | 734 | 735 | 683 | 613 | 441 |
Normalzd Inc Avail to Common | 734 | 735 | 683 | 613 | 441 |
Basic Normalized EPS | 3.77 | 3.62 | 3.20 | 2.80 | 2.03 |
Diluted Normalized EPS | 3.71 | 3.56 | 3.14 | 2.75 | 2.01 |
12 Month Period Ending: Currency is US Dollar | 2/1/2014 | 2/2/2013 | 1/28/2012 | 1/29/2011 | 1/30/2010 |
Assets | |||||
Cash and Short Term Inv | 1,194 | 1,285 | 1,877 | 1,506 | 795 |
Trade Accts Recvble, Gross | 2,184 | 2,142 | 2,074 | 2,103 | 2,162 |
Prov. for Doubtful Accts | (80) | (85) | (115) | (145) | (190) |
Trade Accts Recvble, Net | 2,104 | 2,057 | 1,959 | 1,958 | 1,972 |
Other Receivables | 73 | 72 | 74 | 68 | 63 |
Total Receivables, Net | 2,177 | 2,129 | 2,033 | 2,026 | 2,035 |
Total Inventory | 1,531 | 1,360 | 1,148 | 977 | 898 |
Prepaid Expenses | 87 | 80 | 282 | 79 | 88 |
Other Curr. Assets, Total | 239 | 227 | 220 | 236 | 238 |
Total Current Assets | 5,228 | 5,081 | 5,560 | 4,824 | 4,054 |
Buildings | 3,321 | 3,184 | 3,022 | 2,833 | 2,659 |
Land/Improvements | 80 | 76 | 76 | 72 | 70 |
Machinery/Equipment | 3,522 | 3,197 | 2,989 | 2,745 | 2,649 |
Construction in Progress | 421 | 186 | 173 | 188 | 180 |
Prop./Plant/Equip. - Gross | 7,344 | 6,643 | 6,260 | 5,838 | 5,558 |
Accumulated Depreciation | (4,395) | (4,064) | (3,791) | (3,520) | (3,316) |
Prop./Plant/Equip. - Net | 2,949 | 2,579 | 2,469 | 2,318 | 2,242 |
Goodwill, Net | 175 | 175 | 175 | 53 | 53 |
Other Long Term Assets | 222 | 254 | 287 | 267 | 230 |
Total Assets | 8,574 | 8,089 | 8,491 | 7,462 | 6,579 |
Liabilities | |||||
Accounts Payable | 1,263 | 1,011 | 917 | 846 | 726 |
Accrued Expenses | 395 | 404 | 388 | 375 | 336 |
Notes Payable/ST Debt | 0 | 0 | 0 | 0 | 0 |
Curr. Port. LT Dbt/Cap Ls. | 7.00 | 7.00 | 506 | 6.00 | 356 |
Other Curr. Lblts, Total | 876 | 804 | 764 | 652 | 596 |
Total Current Liabilities | 2,541 | 2,226 | 2,575 | 1,879 | 2,014 |
Total Long Term Debt | 3,106 | 3,124 | 3,141 | 2,775 | 2,257 |
Total Debt | 3,113 | 3,131 | 3,647 | 2,781 | 2,613 |
Pension Benefits - Underfunded | -- | -- | -- | 117 | 97 |
Other LT Liabilities | 847 | 826 | 819 | 670 | 639 |
Other Liabilities, Total | 847 | 826 | 819 | 787 | 736 |
Total Liabilities | 6,494 | 6,176 | 6,535 | 5,441 | 5,007 |
Shareholder Equity | |||||
Common Stock | 1,827 | 1,645 | 1,484 | 1,168 | 1,066 |
Ret. Earn.(Accum. Deficit) | 292 | 315 | 517 | 882 | 525 |
Other Equity, Total | (39) | (47) | (45) | (29) | (19) |
Total Equity | 2,080 | 1,913 | 1,956 | 2,021 | 1,572 |
Total Liabilities & Shareholders' Equity | 8,574 | 8,089 | 8,491 | 7,462 | 6,579 |
Ttl Comm. Shares Outs. | 191 | 197 | 208 | 218 | 218 |
Trsy. Shrs-Comm. Primary Iss. | 0 | 0 | 0 | 0 | 0 |
() = Negative Value
Values are displayed in Millions
12 Month Period Ending: Currency is US Dollar | 2/1/2014 | 2/2/2013 | 1/28/2012 | 1/29/2011 | 1/30/2010 |
Cash From (used by) Operating Activities | |||||
Net Income | 734 | 735 | 683 | 613 | 441 |
Depreciation/Depletion | 454 | 429 | 371 | 327 | 313 |
Deferred Taxes | 12 | 22 | 14 | 2.00 | (58) |
Unusual Items | -- | -- | -- | -- | 0 |
Other Non-Cash Items | 50 | 45 | 103 | 136 | 240 |
Non-Cash Items | 50 | 45 | 103 | 136 | 240 |
Cash Taxes Pd, Supplemental | 445 | 429 | 398 | 381 | 240 |
Cash Interest Pd, Suppl | 170 | 169 | 124 | 121 | 134 |
Accounts Receivable | (93) | (113) | (98) | (74) | (159) |
Inventories | (157) | (170) | (137) | (80) | (1.00) |
Other Assets | (6.00) | 5.00 | 0 | 1.00 | (38) |
Accounts Payable | 167 | 48 | 54 | 72 | 168 |
Accrued Expenses | (12) | 13 | 6.00 | 37 | 120 |
Changes in Working Capital | 70 | (121) | 6.00 | 99 | 315 |
Total Cash from Operations | 1,320 | 1,110 | 1,177 | 1,177 | 1,251 |
Plus: Cash From (used by) Investing Activities | |||||
Capital Expenditures | (803) | (513) | (511) | (399) | (360) |
Sale of Business | -- | -- | -- | -- | 0 |
Other Investing Cash Flow | (19) | 144 | (217) | (63) | (181) |
OtherInvestCashFlowItms,Tot | (19) | 144 | (217) | (63) | (181) |
Total Cash from Investing | (822) | (369) | (728) | (462) | (541) |
Plus: Cash From (used by) Financing Activities | |||||
Financing Cash Flow Items | 18 | 113 | 171 | 20 | 10.00 |
Total Cash Dividends Paid | (234) | (220) | (197) | (167) | (139) |
Sale/Issuance of Common | 103 | -- | -- | 13 | 13 |
Repurch/Retirement Common | (515) | (725) | (840) | (84) | 0 |
Common Stock, Net | (412) | (725) | (840) | (71) | 13 |
Options Exercised | -- | -- | -- | 35 | 21 |
Iss (Retirmnt) of Stock,Net | (412) | (725) | (840) | (36) | 34 |
Short Term Debt, Net | 47 | 5.00 | (30) | 37 | (266) |
Long Term Debt Issued | 399 | 0 | 824 | 498 | 399 |
Long Term Debt Reduction | (407) | (506) | (6.00) | (356) | (25) |
Long Term Debt, Net | (8.00) | (506) | 818 | 142 | 374 |
Iss (Retirmnt) of Debt, Net | 39 | (501) | 788 | 179 | 108 |
Total Cash From Financing | (589) | (1,333) | (78) | (4.00) | 13 |
Equals: Increase (Decrease) in Cash | |||||
Net Change in Cash | (91) | (592) | 371 | 711 | 723 |
NetCash-BeginBal/RsvdforFutUse | 1,285 | 1,877 | 1,506 | 795 | 72 |
NetCash-EndBal/RsrvforFutUse | 1,194 | 1,285 | 1,877 | 1,506 | 795 |
Depreciation, Supplemental | 454 | 429 | 371 | 327 | 313 |
Cash Interest Pd, Suppl | 170 | 169 | 124 | 121 | 134 |
Cash Taxes Pd, Supplemental | 445 | 429 | 398 | 381 | 240 |
() = Negative Value
Values are displayed in Millions
Loading...
Loading...
10 years ago
Purchase the answer to view it
financial_ratio_calculations.xlsx
