Stock Analysis on Net

Microchip Technology Inc. (NASDAQ:MCHP)

This company has been moved to the archive! The financial data has not been updated since February 2, 2023.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Microchip Technology Inc., adjusted current assets

US$ in thousands

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Current assets 2,452,600 2,145,200 2,217,200 2,214,800 3,356,300 2,305,040
Adjustments
Add: Allowance for expected credit losses 6,200 5,200 4,900 2,000 2,200 2,084
After Adjustment
Adjusted current assets 2,458,800 2,150,400 2,222,100 2,216,800 3,358,500 2,307,124

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).


Adjustments to Total Assets

Microchip Technology Inc., adjusted total assets

US$ in thousands

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Total assets 16,199,500 16,478,800 17,426,100 18,350,000 8,257,200 7,686,881
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 142,998 61,468 74,830
Add: Allowance for expected credit losses 6,200 5,200 4,900 2,000 2,200 2,084
Less: Non-current deferred tax assets2 1,797,100 1,749,200 1,748,500 1,677,200 100,200 68,870
After Adjustment
Adjusted total assets 14,408,600 14,734,800 15,682,500 16,817,798 8,220,668 7,694,925

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Non-current deferred tax assets. See details »


Adjustments to Current Liabilities

Microchip Technology Inc., adjusted current liabilities

US$ in thousands

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Current liabilities 1,399,000 2,409,600 1,637,400 2,374,500 2,017,400 704,450
Adjustments
Less: Current deferred revenue 73,200
After Adjustment
Adjusted current liabilities 1,325,800 2,409,600 1,637,400 2,374,500 2,017,400 704,450

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).


Adjustments to Total Liabilities

Microchip Technology Inc., adjusted total liabilities

US$ in thousands

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Total liabilities 10,304,700 11,141,700 11,840,600 13,062,500 4,977,400 4,416,170
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 142,998 61,468 74,830
Less: Non-current deferred tax liability2 39,800 43,900 318,500 706,100 205,800 409,045
Less: Deferred revenue 117,600
Less: Liability for restructuring and other exit costs 16,000 15,900 24,300 47,800 28,100 40,225
After Adjustment
Adjusted total liabilities 10,131,300 11,081,900 11,497,800 12,451,598 4,804,968 4,041,730

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Non-current deferred tax liability. See details »


Adjustments to Stockholders’ Equity

Microchip Technology Inc., adjusted stockholders’ equity

US$ in thousands

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Stockholders’ equity 5,894,800 5,337,100 5,585,500 5,287,500 3,279,800 3,270,711
Adjustments
Less: Net deferred tax asset (liability)1 1,757,300 1,705,300 1,430,000 971,100 (105,600) (340,175)
Add: Allowance for expected credit losses 6,200 5,200 4,900 2,000 2,200 2,084
Add: Deferred revenue 117,600
Add: Liability for restructuring and other exit costs 16,000 15,900 24,300 47,800 28,100 40,225
After Adjustment
Adjusted stockholders’ equity 4,277,300 3,652,900 4,184,700 4,366,200 3,415,700 3,653,195

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 Net deferred tax asset (liability). See details »


Adjustments to Capitalization Table

Microchip Technology Inc., adjusted capitalization table

US$ in thousands

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Current portion of long-term debt 1,322,900 608,800 1,360,800 1,309,900 49,952
Long-term debt excluding current maturities 7,687,400 7,581,200 8,873,400 8,946,200 1,758,400 2,900,524
Total reported debt 7,687,400 8,904,100 9,482,200 10,307,000 3,068,300 2,950,476
Stockholders’ equity 5,894,800 5,337,100 5,585,500 5,287,500 3,279,800 3,270,711
Total reported capital 13,582,200 14,241,200 15,067,700 15,594,500 6,348,100 6,221,187
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 142,998 61,468 74,830
Add: Current portion of operating lease liabilities2 33,800 39,800 44,500
Add: Non-current portion of operating lease liabilities (included in Other long-term liabilities)3 128,900 125,400 94,700
Adjusted total debt 7,850,100 9,069,300 9,621,400 10,449,998 3,129,768 3,025,306
Adjustments to Equity
Less: Net deferred tax asset (liability)4 1,757,300 1,705,300 1,430,000 971,100 (105,600) (340,175)
Add: Allowance for expected credit losses 6,200 5,200 4,900 2,000 2,200 2,084
Add: Deferred revenue 117,600
Add: Liability for restructuring and other exit costs 16,000 15,900 24,300 47,800 28,100 40,225
Adjusted stockholders’ equity 4,277,300 3,652,900 4,184,700 4,366,200 3,415,700 3,653,195
After Adjustment
Adjusted total capital 12,127,400 12,722,200 13,806,100 14,816,198 6,545,468 6,678,501

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current portion of operating lease liabilities. See details »

3 Non-current portion of operating lease liabilities (included in Other long-term liabilities). See details »

4 Net deferred tax asset (liability). See details »


Adjustments to Revenues

Microchip Technology Inc., adjusted net sales

US$ in thousands

Microsoft Excel
12 months ended: Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Net sales 6,820,900 5,438,400 5,274,200 5,349,500 3,980,800 3,407,807
Adjustment
Add: Increase (decrease) in deferred revenue 117,600
After Adjustment
Adjusted net sales 6,938,500 5,438,400 5,274,200 5,349,500 3,980,800 3,407,807

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).


Adjustments to Reported Income

Microchip Technology Inc., adjusted net income

US$ in thousands

Microsoft Excel
12 months ended: Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Net income 1,285,500 349,400 570,600 355,900 255,400 164,639
Adjustments
Add: Deferred income tax expense (benefit)1 7,900 (138,900) (490,300) (62,200) 51,200 (126,888)
Add: Increase (decrease) in allowance for expected credit losses 1,000 300 2,900 (200) 100 (456)
Add: Increase (decrease) in deferred revenue 117,600
Add: Increase (decrease) in liability for restructuring and other exit costs 100 (8,400) (23,500) 600 (12,100) 40,167
Less: Net loss from discontinued operations (5,953)
Add: Other comprehensive income (loss), net of tax effect 5,600 (4,600) 400 (1,400) (3,200) (11,021)
After Adjustment
Adjusted net income 1,417,700 197,800 60,100 292,700 291,400 72,394

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 Deferred income tax expense (benefit). See details »