Paying users zone. Data is hidden behind 
.
Get 1-month access to Medtronic PLC for $19.99, or
get full access to the entire website for at least 3 months from $49.99.
We accept:
This is a one-time payment. There is no automatic renewal.
Medtronic PLC (MDT)
Analysis of Operating Leases
High level of difficulty
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.
Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)
Medtronic PLC, future operating lease payments (before adoption of FASB Topic 842)
US$ in millions
| Apr 26, 2019 | Apr 27, 2018 | Apr 28, 2017 | Apr 29, 2016 | Apr 24, 2015 | Apr 25, 2014 | ||
|---|---|---|---|---|---|---|---|
| Total undiscounted future operating lease payments | |
|
|
|
|
|
|
| Discount rate1 | |
|
|
|
|
|
|
| Total present value of future operating lease payments | |
|
|
|
|
|
|
Based on: 10-K (filing date: 2019-06-21), 10-K (filing date: 2018-06-22), 10-K (filing date: 2017-06-27), 10-K (filing date: 2016-06-28), 10-K (filing date: 2015-06-23), 10-K (filing date: 2014-06-20).
1 Internal rate of return on capital leases
| 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 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2019-06-21).
| 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 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2018-06-22).
| 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 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2017-06-27).
| 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 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2016-06-28).
| 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 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2015-06-23).
| 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 | |
|
||
| Total: | |
|
|
Based on: 10-K (filing date: 2014-06-20).
Adjustments to Financial Statements for Operating Leases
Medtronic PLC, adjustments to financial statements
US$ in millions
Based on: 10-K (filing date: 2019-06-21), 10-K (filing date: 2018-06-22), 10-K (filing date: 2017-06-27), 10-K (filing date: 2016-06-28), 10-K (filing date: 2015-06-23), 10-K (filing date: 2014-06-20).
1, 2 Equal to total present value of future operating lease payments.
Medtronic PLC, Financial Data: Reported vs. Adjusted
Adjusted Financial Ratios for Operating Leases (Summary)
Medtronic PLC, adjusted financial ratios
Based on: 10-K (filing date: 2019-06-21), 10-K (filing date: 2018-06-22), 10-K (filing date: 2017-06-27), 10-K (filing date: 2016-06-28), 10-K (filing date: 2015-06-23), 10-K (filing date: 2014-06-20).
| Financial ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Medtronic PLC’s 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. | |
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Medtronic PLC’s adjusted ROA deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level. |
Medtronic PLC, Financial Ratios: Reported vs. Adjusted
Adjusted Total Asset Turnover
Based on: 10-K (filing date: 2019-06-21), 10-K (filing date: 2018-06-22), 10-K (filing date: 2017-06-27), 10-K (filing date: 2016-06-28), 10-K (filing date: 2015-06-23), 10-K (filing date: 2014-06-20).
2019 Calculations
1 Total asset turnover = Net sales ÷ Total assets
= ÷ =
2 Adjusted total asset turnover = Net 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. | Medtronic PLC’s adjusted total asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019. |
Adjusted Debt to Equity
Based on: 10-K (filing date: 2019-06-21), 10-K (filing date: 2018-06-22), 10-K (filing date: 2017-06-27), 10-K (filing date: 2016-06-28), 10-K (filing date: 2015-06-23), 10-K (filing date: 2014-06-20).
2019 Calculations
1 Debt to equity = Total debt ÷ Shareholders’ equity
= ÷ =
2 Adjusted debt to equity = Adjusted total debt ÷ Shareholders’ equity
= ÷ =
| Solvency ratio | Description | The company |
|---|---|---|
| Adjusted debt-to-equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. |
Adjusted Return on Assets (ROA)
Based on: 10-K (filing date: 2019-06-21), 10-K (filing date: 2018-06-22), 10-K (filing date: 2017-06-27), 10-K (filing date: 2016-06-28), 10-K (filing date: 2015-06-23), 10-K (filing date: 2014-06-20).
2019 Calculations
1 ROA = 100 × Net income attributable to Medtronic ÷ Total assets
= 100 × ÷ =
2 Adjusted ROA = 100 × Net income attributable to Medtronic ÷ Adjusted total assets
= 100 × ÷ =
| Profitability ratio | Description | The company |
|---|---|---|
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Medtronic PLC’s adjusted ROA deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level. |