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.

Analysis of Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Microchip Technology Inc., adjustment to 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
Net income (as reported) 1,285,500 349,400 570,600 355,900 255,400 164,639
Add: Available-for-sale securities 1,600 (36)
Net income (adjusted) 1,285,500 349,400 570,600 355,900 257,000 164,603

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


Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Microchip Technology Inc., adjusted profitability ratios

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
Net Profit Margin
Reported net profit margin 18.85% 6.42% 10.82% 6.65% 6.42% 4.83%
Adjusted net profit margin 18.85% 6.42% 10.82% 6.65% 6.46% 4.83%
Return on Equity (ROE)
Reported ROE 21.81% 6.55% 10.22% 6.73% 7.79% 5.03%
Adjusted ROE 21.81% 6.55% 10.22% 6.73% 7.84% 5.03%
Return on Assets (ROA)
Reported ROA 7.94% 2.12% 3.27% 1.94% 3.09% 2.14%
Adjusted ROA 7.94% 2.12% 3.27% 1.94% 3.11% 2.14%

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

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Microchip Technology Inc. adjusted net profit margin ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Microchip Technology Inc. adjusted ROE deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by 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., Profitability Ratios: Reported vs. Adjusted


Adjusted Net Profit Margin

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Selected Financial Data (US$ in thousands)
Net income 1,285,500 349,400 570,600 355,900 255,400 164,639
Net sales 6,820,900 5,438,400 5,274,200 5,349,500 3,980,800 3,407,807
Profitability Ratio
Net profit margin1 18.85% 6.42% 10.82% 6.65% 6.42% 4.83%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income 1,285,500 349,400 570,600 355,900 257,000 164,603
Net sales 6,820,900 5,438,400 5,274,200 5,349,500 3,980,800 3,407,807
Profitability Ratio
Adjusted net profit margin2 18.85% 6.42% 10.82% 6.65% 6.46% 4.83%

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 Net profit margin = 100 × Net income ÷ Net sales
= 100 × 1,285,500 ÷ 6,820,900 = 18.85%

2 Adjusted net profit margin = 100 × Adjusted net income ÷ Net sales
= 100 × 1,285,500 ÷ 6,820,900 = 18.85%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Microchip Technology Inc. adjusted net profit margin ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.

Adjusted Return on Equity (ROE)

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Selected Financial Data (US$ in thousands)
Net income 1,285,500 349,400 570,600 355,900 255,400 164,639
Stockholders’ equity 5,894,800 5,337,100 5,585,500 5,287,500 3,279,800 3,270,711
Profitability Ratio
ROE1 21.81% 6.55% 10.22% 6.73% 7.79% 5.03%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income 1,285,500 349,400 570,600 355,900 257,000 164,603
Stockholders’ equity 5,894,800 5,337,100 5,585,500 5,287,500 3,279,800 3,270,711
Profitability Ratio
Adjusted ROE2 21.81% 6.55% 10.22% 6.73% 7.84% 5.03%

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 ROE = 100 × Net income ÷ Stockholders’ equity
= 100 × 1,285,500 ÷ 5,894,800 = 21.81%

2 Adjusted ROE = 100 × Adjusted net income ÷ Stockholders’ equity
= 100 × 1,285,500 ÷ 5,894,800 = 21.81%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Microchip Technology Inc. adjusted ROE deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.

Adjusted Return on Assets (ROA)

Microsoft Excel
Mar 31, 2022 Mar 31, 2021 Mar 31, 2020 Mar 31, 2019 Mar 31, 2018 Mar 31, 2017
As Reported
Selected Financial Data (US$ in thousands)
Net income 1,285,500 349,400 570,600 355,900 255,400 164,639
Total assets 16,199,500 16,478,800 17,426,100 18,350,000 8,257,200 7,686,881
Profitability Ratio
ROA1 7.94% 2.12% 3.27% 1.94% 3.09% 2.14%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in thousands)
Adjusted net income 1,285,500 349,400 570,600 355,900 257,000 164,603
Total assets 16,199,500 16,478,800 17,426,100 18,350,000 8,257,200 7,686,881
Profitability Ratio
Adjusted ROA2 7.94% 2.12% 3.27% 1.94% 3.11% 2.14%

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 × 1,285,500 ÷ 16,199,500 = 7.94%

2 Adjusted ROA = 100 × Adjusted net income ÷ Total assets
= 100 × 1,285,500 ÷ 16,199,500 = 7.94%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Microchip Technology Inc. adjusted ROA deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.