Financial Ratio Calculations

profileSuperClass
 (Not rated)
 (Not rated)
Chat

12 Month Period Ending: Currency is US Dollar

2/1/2014
52 Weeks

2/2/2013
53 Weeks
Reclassified
2/1/2014

1/28/2012
52 Weeks
Reclassified
2/1/2014

1/29/2011
52 Weeks
Reclassified
2/2/2013

1/30/2010
52 Weeks

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
52 Weeks

2/2/2013
53 Weeks

1/28/2012
52 Weeks

1/29/2011
52 Weeks

1/30/2010
52 Weeks

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...

 

 

    • 5 years ago
    Financial Ratio Calculations A+ Tutorial use as Guide
    NOT RATED

    Purchase the answer to view it

    • attachment
      financial_ratio_calculations.xlsx