Stock Analysis on Net

Walgreens Boots Alliance Inc. (NASDAQ:WBA)

This company has been moved to the archive! The financial data has not been updated since July 9, 2020.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Walgreens Boots Alliance Inc., adjusted current assets

US$ in millions

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Current assets 18,700 17,846 19,753 25,883 19,657 12,242
Adjustments
Add: Allowance for doubtful accounts 95 75 158 166 172 173
Add: LIFO reserve1 3,200 3,000 3,000 2,800 2,500 2,300
After Adjustment
Adjusted current assets 21,995 20,921 22,911 28,849 22,329 14,715

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 LIFO reserve. See details »


Adjustments to Total Assets

Walgreens Boots Alliance Inc., adjusted total assets

US$ in millions

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Total assets 67,598 68,124 66,009 72,688 68,782 37,182
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 26,628 26,624 26,194 27,480 29,803 27,399
Add: Allowance for doubtful accounts 95 75 158 166 172 173
Add: LIFO reserve2 3,200 3,000 3,000 2,800 2,500 2,300
After Adjustment
Adjusted total assets 97,521 97,823 95,361 103,134 101,257 67,054

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 LIFO reserve. See details »


Adjustments to Total Liabilities

Walgreens Boots Alliance Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Total liabilities 43,447 41,435 37,735 42,407 37,482 16,621
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 26,628 26,624 26,194 27,480 29,803 27,399
Less: Deferred income taxes2 1,785 1,815 2,281 2,644 3,538 1,048
Less: Liabilities related to the exit and disposal activities 897 750 600
After Adjustment
Adjusted total liabilities 67,393 65,494 61,048 67,243 63,747 42,972

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred income taxes. See details »


Adjustments to Stockholders’ Equity

Walgreens Boots Alliance Inc., adjusted total Walgreens Boots Alliance, Inc. shareholders’ equity

US$ in millions

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Total Walgreens Boots Alliance, Inc. shareholders’ equity 23,512 26,007 27,466 29,880 30,861 20,457
Adjustments
Less: Net deferred tax assets (liabilities)1 (1,724) (1,750) (2,274) (2,641) (3,541) (1,123)
Add: Allowance for doubtful accounts 95 75 158 166 172 173
Add: LIFO reserve2 3,200 3,000 3,000 2,800 2,500 2,300
Add: Liabilities related to the exit and disposal activities 897 750 600
Add: Noncontrolling interests 640 682 808 401 439 104
After Adjustment
Adjusted total equity 30,068 32,264 34,306 35,888 37,513 24,157

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Net deferred tax assets (liabilities). See details »

2 LIFO reserve. See details »


Adjustments to Capitalization Table

Walgreens Boots Alliance Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Short-term debt 5,738 1,966 251 323 1,068 774
Long-term debt 11,098 12,431 12,684 18,705 13,315 3,736
Total reported debt 16,836 14,397 12,935 19,028 14,383 4,510
Total Walgreens Boots Alliance, Inc. shareholders’ equity 23,512 26,007 27,466 29,880 30,861 20,457
Total reported capital 40,348 40,404 40,401 48,908 45,244 24,967
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 26,628 26,624 26,194 27,480 29,803 27,399
Adjusted total debt 43,464 41,021 39,129 46,508 44,186 31,909
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 (1,724) (1,750) (2,274) (2,641) (3,541) (1,123)
Add: Allowance for doubtful accounts 95 75 158 166 172 173
Add: LIFO reserve3 3,200 3,000 3,000 2,800 2,500 2,300
Add: Liabilities related to the exit and disposal activities 897 750 600
Add: Noncontrolling interests 640 682 808 401 439 104
Adjusted total equity 30,068 32,264 34,306 35,888 37,513 24,157
After Adjustment
Adjusted total capital 73,532 73,285 73,435 82,396 81,699 56,066

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Net deferred tax assets (liabilities). See details »

3 LIFO reserve. See details »


Adjustments to Reported Income

Walgreens Boots Alliance Inc., adjusted net earnings attributable to Walgreens Boots Alliance, Inc.

US$ in millions

Microsoft Excel
12 months ended: Aug 31, 2019 Aug 31, 2018 Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014
As Reported
Net earnings attributable to Walgreens Boots Alliance, Inc. 3,982 5,024 4,078 4,173 4,220 1,932
Adjustments
Add: Deferred income tax expense (benefit)1 100 (324) (434) (429) (39) 175
Add: Increase (decrease) in allowance for doubtful accounts 20 (83) (8) (6) (1) 19
Add: Increase (decrease) in LIFO reserve2 200 200 300 200 200
Add: Increase (decrease) in liabilities related to the exit and disposal activities 147 150 324
Add: Other comprehensive income (loss), net of tax (909) 50 (95) (2,834) (356) 276
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest (33) 8 (13) (39) 53 99
After Adjustment
Adjusted net earnings 3,507 4,825 4,052 1,165 4,077 2,701

Based on: 10-K (reporting date: 2019-08-31), 10-K (reporting date: 2018-08-31), 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31).

1 Deferred income tax expense (benefit). See details »

2 Increase (decrease) in LIFO reserve. See details »