I have to make spreadsheet for cash flow statement. I filled up most of parts for common-size and percentage. However, I couldn’t find more calculation from the web.

I have to make spreadsheet for cash flow statement.

I filled up most of parts for common-size and percentage.

However, I couldn’t find more calculation from the web.

ATTACHMENT PREVIEW

Download attachment

Wal-Mart Stores Inc
Cash Flow Statement
Common-Size Cash Flow
Percentage Change Cash Flow
2012
%
2011
%
2010
%
2012
2011
2010
2012
2011
Consolidated net income
$16,387.00
67.56
$16,993.00
71.87
$14,883.00
56.7
67.56
71.87
56.7
-3.57
14.18
Loss (income) from discontinued operations,
$67.00
$(1,034.00)
$79.00
net of income taxes
Income from continuing operations
$16,454.00
67.84
$15,959.00
67.5
$14,962.00
67.84
67.5
3.1
Depreciation and amortization
$8,130.00
33.52
$7,641.00
32.32
$7,157.00
27.27
33.52
32.32
6.4
6.76
Deferred income taxes
$1,050.00
4.33
$651.00
2.75
$(504.00)
4.33
2.75
61.29
Other operating activities
$398.00
1.64
$1,087.00
4.6
$318.00
1.21
1.64
4.6
-63.39
Receivables, net
$(796.00)
-3.28
$(733.00)
-3.1
$(297.00)
-3.28
-3.1
8.59
Inventories
$(3,727.00)
-15.37
$(3,205.00)
-13.56
$2,213.00
-15.37
-13.56
16.29
Accounts payable
$2,687.00
11.08
$2,676.00
4.15
$1,052.00
11.08
4.15
0.41
Other liabilities
$(935.00)
-3.85
$(280.00)
-1.18
$1,348.00
-3.85
-1.18
233.93
Taxes payable
$994.00
4.1
$(153.00)
-0.65


4.1
-0.65

79.4
Net cash provided by operating activities
$24,255.00
100%
$23,643.00
100%
$26,249.00
100%
100%
100%
100%
2.59
Payments for property and equipment
$(13,510.00)
-55.7
-12699.00
-53.71
$(12,184.00)
-46.42
-55.7
-53.71
6.39
Proceeds from disposal of property and equipment
$580.00
2.39
$489.00
2.07
$1,002.00
2.39
2.07
18.61
(Payments for) proceeds from disposal of











certain international operations, net
Investments and business acquisitions,
$(3,548.00)
-14.63
$(202.00)
-0.85


-14.63
-0.85

1656.44
net of cash acquired
Other investing activities
$(131.00)
-0.54
$219.00
0.93
$(438.00)
-0.54
0.93
-159.82
Net cash used in investing activities
$(16,609.00)
-68.48
-12193.00
-51.57
$(11,620.00)
-44.27
-68.48
-51.57
-44.27
36.22
Net change in short-term borrowings
$3,019.00
$503.00
$(1,033.00)
Proceeds from issuance of long-term debt
$5,050.00
$11,396.00
$5,546.00
Payments of long-term debt
$(4,584.00)
$(4,080.00)
$(6,033.00)
Dividends paid
$(5,048.00)
-20.81
$(4,437.00)
-18.77
$(4,217.00)
-16.07
-20.81
-18.77
-16.07
Purchase of Company stock
$(6,298.00)
-25.97
-14776.00
-62.5
$(7,276.00)
-29.38
-25.97
-62.5
-29.38
Purchase of redeemable noncontrolling interest




$(436.00)



Other financing activities
$(597.00)
-2.46
$(634.00)
-2.68
$(396.00)
-1.51
-2.46
-2.68
-1.51
Net cash used in financing activities
$(8,458.00)
-34.87
-12028.00
-50.87
$(14,191.00)
-54.06
-34.87
-50.87
-54.06
-29.68
Effect of exchange rates on cash and cash equivalents
$(33.00)
$66.00
$194.00
Net increase (decrease) in cash and cash equivalents
$(845.00)
-3.48
$(512.00)
-2.17
$632.00
2.41
-3.48
-2.17
2.41
Cash and cash equivalents at beginning of year
$7,395.00
30.49
$7,907.00
33.44
$7,275.00
30.49
33.44
-6.48
Cash and cash equivalents at end of year
$6,550.00
27
$7,395.00
31.28
$7,907.00
27
31.28
-11.43

Leave a Comment