Analysis of Operating Leases
An operating lease is treated like a rental contract. Neither the leased asset nor the associated liability is reported on the lessee balance sheet, but the rights may be very similar to the rights of an owner. The lessee only records the lease payments as a rental expense in income statement.
Paying user area
Try for free
Walgreens Boots Alliance Inc. pages available for free this week:
- Balance Sheet: Assets
- Common-Size Income Statement
- Dividend Discount Model (DDM)
- Present Value of Free Cash Flow to Equity (FCFE)
- Selected Financial Data since 2005
- Net Profit Margin since 2005
- Return on Equity (ROE) since 2005
- Current Ratio since 2005
- Price to Earnings (P/E) since 2005
- Price to Sales (P/S) since 2005
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Walgreens Boots Alliance Inc. for $22.49.
This is a one-time payment. There is no automatic renewal.
We accept:
Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)
Walgreens Boots Alliance Inc., future operating lease payments (before adoption of FASB Topic 842)
US$ in millions
| Aug 31, 2019 | Aug 31, 2018 | Aug 31, 2017 | Aug 31, 2016 | Aug 31, 2015 | Aug 31, 2014 | ||
|---|---|---|---|---|---|---|---|
| Total undiscounted future operating lease payments | |||||||
| Discount rate1 | |||||||
| Total present value of future operating lease payments | |||||||
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 Weighted-average interest rate for Walgreens Boots Alliance Inc. debt
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 | 2022 | |||
| 2023 | 2023 | |||
| 2024 | 2024 | |||
| 2025 and thereafter | 2025 | |||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2019-08-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 | 2022 | |||
| 2023 | 2023 | |||
| 2024 and thereafter | 2024 | |||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2018-08-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2018 | 2018 | |||
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 | 2022 | |||
| 2023 and thereafter | 2023 | |||
| 2024 | ||||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2017-08-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2017 | 2017 | |||
| 2018 | 2018 | |||
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 | 2021 | |||
| 2022 and thereafter | 2022 | |||
| 2023 | ||||
| 2024 | ||||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2016-08-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2016 | 2016 | |||
| 2017 | 2017 | |||
| 2018 | 2018 | |||
| 2019 | 2019 | |||
| 2020 | 2020 | |||
| 2021 and thereafter | 2021 | |||
| 2022 | ||||
| 2023 | ||||
| 2024 | ||||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| 2030 | ||||
| Total: |
Based on: 10-K (reporting date: 2015-08-31).
| Year | Future operating lease payments (as reported) | Year | Future operating lease payments (estimated) | Present value at |
|---|---|---|---|---|
| 2015 | 2015 | |||
| 2016 | 2016 | |||
| 2017 | 2017 | |||
| 2018 | 2018 | |||
| 2019 | 2019 | |||
| 2020 and thereafter | 2020 | |||
| 2021 | ||||
| 2022 | ||||
| 2023 | ||||
| 2024 | ||||
| 2025 | ||||
| 2026 | ||||
| 2027 | ||||
| 2028 | ||||
| 2029 | ||||
| Total: |
Based on: 10-K (reporting date: 2014-08-31).
Adjustments to Financial Statements for Operating Leases
Walgreens Boots Alliance Inc., adjustments to financial statements
US$ in millions
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, 2 Equal to total present value of future operating lease payments.
Walgreens Boots Alliance Inc., Financial Data: Reported vs. Adjusted
Adjusted Financial Ratios for Operating Leases (Summary)
Walgreens Boots Alliance Inc., adjusted financial ratios
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).
| Financial ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Walgreens Boots Alliance Inc. adjusted total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019. |
| Adjusted debt to equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Walgreens Boots Alliance Inc. adjusted debt to equity ratio deteriorated from 2017 to 2018 and from 2018 to 2019. |
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Walgreens Boots Alliance Inc. adjusted ROA improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019. |
Walgreens Boots Alliance Inc., Financial Ratios: Reported vs. Adjusted
Adjusted Total Asset Turnover
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).
2019 Calculations
1 Total asset turnover = Sales ÷ Total assets
= ÷ =
2 Adjusted total asset turnover = Sales ÷ Adjusted total assets
= ÷ =
| Activity ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Walgreens Boots Alliance Inc. adjusted total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019. |
Adjusted Debt to Equity
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).
2019 Calculations
1 Debt to equity = Total debt ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =
2 Adjusted debt to equity = Adjusted total debt ÷ Total Walgreens Boots Alliance, Inc. shareholders’ equity
= ÷ =
| Solvency ratio | Description | The company |
|---|---|---|
| Adjusted debt-to-equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Walgreens Boots Alliance Inc. adjusted debt-to-equity ratio deteriorated from 2017 to 2018 and from 2018 to 2019. |
Adjusted Return on Assets (ROA)
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).
2019 Calculations
1 ROA = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Total assets
= 100 × ÷ =
2 Adjusted ROA = 100 × Net earnings attributable to Walgreens Boots Alliance, Inc. ÷ Adjusted total assets
= 100 × ÷ =
| Profitability ratio | Description | The company |
|---|---|---|
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Walgreens Boots Alliance Inc. adjusted ROA improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019. |