Exhibit 12.2
WAL-MART STORES, INC. AND SUBSIDIARIES
Ratio of Adjusted Cash Flow from Operations to Adjusted Average Debt
Adjusted cash flow from operations as the numerator is defined as cash flow from operations of continuing operations for the current year plus two–thirds of the current year operating rent expense less current year capitalized interest expense. Adjusted average debt as the denominator is defined as average debt plus eight times average operating rent expense. Average debt is the simple average of beginning and ending commercial paper, long–term debt due within one year, obligations under capital leases due in one year, long–term debt, and long–term obligations under capital leases. Average operating rent expense is the simple average of current year and prior year operating rent expense. We believe this metric is useful to investors as it provides them with a tool to measure our leverage. Ratios as of July 31, 2007 and January 31, 2007 are calculated as follows:
| | | | | | | | |
| Amounts in millions except for the calculated ratio | | Twelve Months Ended
July 31, 2007 | | | Fiscal Year Ended
January 31, 2007 | |
Cash flows from operating activities of continuing operations | | $ | 19,495 | | | $ | 20,209 | |
+ Two-thirds current period operating rent expense (1) | | | 1,008 | | | | 961 | |
- Current year capitalized interest expense | | | 158 | | | | 182 | |
| | | | | | | | |
Numerator | | $ | 20,345 | | | $ | 20,988 | |
| | |
Average debt (2) | | $ | 41,764 | | | $ | 38,874 | |
Eight times average operating rent expense (3) | | | 10,908 | | | | 9,604 | |
| | | | | | | | |
Denominator | | $ | 52,672 | | | $ | 48,478 | |
| | |
Adjusted cash flow from operations to average debt (4) | | | 39 | % | | | 43 | % |
Cash flows from operating activities of continuing operations to average debt | | | 47 | % | | | 52 | % |
| | |
Selected Financial Information | | | | | | | | |
Current period operating rent expense | | $ | 1,512 | | | $ | 1,441 | |
Prior period operating rent expense | | | 1,215 | | | | 960 | |
Current period capitalized interest | | | 158 | | | | 182 | |
| | |
Certain Balance Sheet Information | | | | | | | | |
| | | July 31, 2007 | | | July 31, 2006 | |
Commercial paper | | $ | 8,117 | | | $ | 6,072 | |
Long-term debt due in one year | | | 3,176 | | | | 6,235 | |
Obligations under capital leases due within one year | | | 189 | | | | 196 | |
Long-term debt | | | 27,966 | | | | 24,099 | |
Long-term obligations under capital leases | | | 3,594 | | | | 3,883 | |
| | | | | | | | |
Total debt | | $ | 43,042 | | | $ | 40,485 | |
| | | | | | | | |
| | |
| | | January 31, 2007 | | | January 31, 2006 | |
Commercial paper | | $ | 2,570 | | | $ | 3,754 | |
Long-term debt due in one year | | | 5,428 | | | | 4,595 | |
Obligations under capital leases due within one year | | | 285 | | | | 284 | |
Long-term debt | | | 27,222 | | | | 26,429 | |
Long-term obligations under capital leases | | | 3,513 | | | | 3,667 | |
| | | | | | | | |
Total debt | | $ | 39,018 | | | $ | 38,729 | |
| | | | | | | | |
| (1) | 2/3 X $1,512 for the trailing twelve months ending July 31, 2007 and 2/3 X $1,441 for the fiscal year 2007 |
| (2) | ($43,042+ $40,485)/2 for the trailing twelve months ending July 31, 2007 and ($39,018 + $38,729)/2 for the fiscal year 2007 |
| (3) | 8 X (($1,512 + $1,215)/2) for the trailing twelve months ending July 31, 2007 and 8 X (($1,441 + $960)/2) for the fiscal year 2007. |
| (4) | The calculation of the ratio as defined. |
The most recognized directly comparable GAAP measure is the ratio of cash flow from operations of continuing operations for the current year to average total debt (which excludes any affect of operating leases or capitalized interest) and for which the trailing twelve months ending July 31, 2007 was 47% and the fiscal year 2007 was 52%.
