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
Microchip Technology Inc. pages available for free this week:
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Microchip Technology 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)
Microchip Technology Inc., future operating lease payments (before adoption of FASB Topic 842)
US$ in thousands
| Mar 31, 2022 | Mar 31, 2021 | Mar 31, 2020 | Mar 31, 2019 | Mar 31, 2018 | Mar 31, 2017 | ||
|---|---|---|---|---|---|---|---|
| Total undiscounted future operating lease payments | |||||||
| Discount rate1 | |||||||
| Total present value of future operating lease payments | |||||||
Based on: 10-K (reporting date: 2022-03-31), 10-K (reporting date: 2021-03-31), 10-K (reporting date: 2020-03-31), 10-K (reporting date: 2019-03-31), 10-K (reporting date: 2018-03-31), 10-K (reporting date: 2017-03-31).
1 Weighted-average interest rate for Microchip Technology 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 | ||||
| Total: |
Based on: 10-K (reporting date: 2019-03-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 | |||
| Total: |
Based on: 10-K (reporting date: 2018-03-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 | 2023 | |||
| Total: |
Based on: 10-K (reporting date: 2017-03-31).
Adjustments to Financial Statements for Operating Leases
Microchip Technology Inc., adjustments to financial statements
US$ in thousands
Based on: 10-K (reporting date: 2022-03-31), 10-K (reporting date: 2021-03-31), 10-K (reporting date: 2020-03-31), 10-K (reporting date: 2019-03-31), 10-K (reporting date: 2018-03-31), 10-K (reporting date: 2017-03-31).
1, 2 Equal to total present value of future operating lease payments.
Microchip Technology Inc., Financial Data: Reported vs. Adjusted
Adjusted Financial Ratios for Operating Leases (Summary)
Microchip Technology Inc., adjusted financial ratios
Based on: 10-K (reporting date: 2022-03-31), 10-K (reporting date: 2021-03-31), 10-K (reporting date: 2020-03-31), 10-K (reporting date: 2019-03-31), 10-K (reporting date: 2018-03-31), 10-K (reporting date: 2017-03-31).
| Financial ratio | Description | The company |
|---|---|---|
| Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Microchip Technology Inc. adjusted total asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022. |
| Adjusted debt to equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Microchip Technology Inc. adjusted debt to equity ratio improved from 2020 to 2021 and from 2021 to 2022. |
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Microchip Technology Inc. adjusted ROA deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level. |
Microchip Technology Inc., Financial Ratios: Reported vs. Adjusted
Adjusted Total Asset Turnover
Based on: 10-K (reporting date: 2022-03-31), 10-K (reporting date: 2021-03-31), 10-K (reporting date: 2020-03-31), 10-K (reporting date: 2019-03-31), 10-K (reporting date: 2018-03-31), 10-K (reporting date: 2017-03-31).
2022 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. | Microchip Technology Inc. adjusted total asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022. |
Adjusted Debt to Equity
Based on: 10-K (reporting date: 2022-03-31), 10-K (reporting date: 2021-03-31), 10-K (reporting date: 2020-03-31), 10-K (reporting date: 2019-03-31), 10-K (reporting date: 2018-03-31), 10-K (reporting date: 2017-03-31).
2022 Calculations
1 Debt to equity = Total debt ÷ Stockholders’ equity
= ÷ =
2 Adjusted debt to equity = Adjusted total debt ÷ Stockholders’ equity
= ÷ =
| Solvency ratio | Description | The company |
|---|---|---|
| Adjusted debt-to-equity | A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. | Microchip Technology Inc. adjusted debt-to-equity ratio improved from 2020 to 2021 and from 2021 to 2022. |
Adjusted Return on Assets (ROA)
Based on: 10-K (reporting date: 2022-03-31), 10-K (reporting date: 2021-03-31), 10-K (reporting date: 2020-03-31), 10-K (reporting date: 2019-03-31), 10-K (reporting date: 2018-03-31), 10-K (reporting date: 2017-03-31).
2022 Calculations
1 ROA = 100 × Net income ÷ Total assets
= 100 × ÷ =
2 Adjusted ROA = 100 × Net income ÷ Adjusted total assets
= 100 × ÷ =
| Profitability ratio | Description | The company |
|---|---|---|
| Adjusted ROA | A profitability ratio calculated as net income divided by adjusted total assets. | Microchip Technology Inc. adjusted ROA deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level. |