Paying user area
Try for free
Microsoft Corp. pages available for free this week:
- Cash Flow Statement
- Analysis of Liquidity Ratios
- Analysis of Short-term (Operating) Activity Ratios
- Analysis of Long-term (Investment) Activity Ratios
- Price to FCFE (P/FCFE)
- Capital Asset Pricing Model (CAPM)
- Operating Profit Margin since 2005
- Price to Earnings (P/E) since 2005
- Analysis of Revenues
- Aggregate Accruals
The data is hidden behind: . Unhide it.
Get full access to the entire website from $10.42/mo, or
get 1-month access to Microsoft Corp. for $24.99.
This is a one-time payment. There is no automatic renewal.
We accept:
Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities
12 months ended: | Jun 30, 2024 | Jun 30, 2023 | Jun 30, 2022 | Jun 30, 2021 | Jun 30, 2020 | Jun 30, 2019 | |
---|---|---|---|---|---|---|---|
Net income (as reported) | |||||||
Add: Net change related to investments | |||||||
Net income (adjusted) |
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
- Net Income Trends
- The reported net income shows a generally increasing trend over the six-year period from June 30, 2019, to June 30, 2024. It rises from $39,240 million in 2019 to $88,136 million in 2024, indicating strong profitability growth. However, the increase is not entirely smooth; for instance, there is a slight decrease from $72,738 million in 2022 to $72,361 million in 2023 before it surges again in 2024.
- The adjusted net income similarly exhibits an overall upward trajectory, starting at $41,645 million in 2019 and reaching $89,093 million in 2024. Unlike the reported net income, the adjusted net income shows more consistent growth with only minor fluctuations, reflecting modifications for non-recurring items or investments that may impact the reported figures.
- Comparison between Reported and Adjusted Net Income
- Adjusted net income values are consistently higher than reported net income across all years, indicating that the adjustments, likely accounting for one-time factors or investment-related expenses, add value back to the net income. The gap between the two measures fluctuates but generally remains substantial, which suggests that investment adjustments are significant in understanding the company's profitability.
- Notable Observations
- The reported net income growth is particularly notable between 2020 and 2021, where it increases by nearly 38%, followed by a more moderate growth rate in subsequent years. Adjusted net income, though growing steadily, shows a decrease from 2020 to 2021, which contrasts with the reported figure, implying adjustments made in that period potentially exclude some profitable elements reported as net income.
- The largest single year increase for both metrics occurs from 2023 to 2024, with reported net income rising by approximately 22% and adjusted net income surging by around 25%. This steep rise may indicate improved operational performance or favorable adjustment factors during that fiscal year.
- Summary
- Overall, both reported and adjusted net income demonstrate robust growth over the analyzed period, with adjusted net income providing a more smoothed view of profitability excluding investment-related impacts. The difference between the two metrics highlights the significance of investment adjustments in assessing the company's financial health. The data suggests the company has been able to expand its income base steadily, with particular acceleration in the most recent year.
Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
- Net Profit Margin
- The reported net profit margin displays an overall upward trend from 31.18% in 2019, peaking at 36.69% in 2022, before experiencing a slight decline to 34.15% in 2023 and a subsequent rise to 35.96% in 2024. The adjusted net profit margin, while generally following a similar pattern, indicates a somewhat steadier performance with marginal fluctuations, reaching its highest point at 36.35% in 2024. This suggests consistent profitability with minor variations influenced by adjustments.
- Return on Equity (ROE)
- The reported ROE demonstrates a significant increase from 38.35% in 2019 to a peak of 43.68% in 2022, followed by a notable decline to 35.09% in 2023 and further to 32.83% in 2024. Adjusted ROE follows a comparable trajectory, rising to 41.56% in 2021 and slightly decreasing thereafter, ending at 33.18% in 2024. The downward trend after 2022 indicates a reduction in equity efficiency or increased equity base effects.
- Return on Assets (ROA)
- Reported ROA shows a clear increasing trend from 13.69% in 2019 to 19.94% in 2022, marking substantial improvement in asset utilization efficiency. However, there is a decline beginning 2023, decreasing to 17.56% and 17.21% in 2024. Adjusted ROA reflects a similar pattern with steady growth up to 18.47% in 2022 and a slight decline afterward, stabilizing near 17.4% in 2024. These patterns suggest a peak in asset profitability with a modest pullback in recent years.
- Insights
- The data reveals strong profitability and return metrics peaking around 2021-2022, followed by a downward adjustment period primarily in ROE and ROA, while net profit margins remain relatively stable. This may indicate challenges in maintaining previous returns on equity and assets, potentially due to changes in operational efficiency, capital structure, or market conditions. The adjusted figures consistently present a more moderated but closely aligned perspective to the reported results, reinforcing the reliability of observed trends.
Microsoft Corp., Profitability Ratios: Reported vs. Adjusted
Adjusted Net Profit Margin
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
2024 Calculations
1 Net profit margin = 100 × Net income ÷ Revenue
= 100 × ÷ =
2 Adjusted net profit margin = 100 × Adjusted net income ÷ Revenue
= 100 × ÷ =
The financial data reveals several notable trends over the analyzed periods. Both reported and adjusted net incomes exhibit a consistent upward trajectory, indicating overall growth in profitability. Reported net income increased from 39,240 million US dollars in 2019 to 88,136 million US dollars in 2024, representing more than a twofold increase. Adjusted net income follows a similar pattern, rising from 41,645 million US dollars in 2019 to 89,093 million US dollars in 2024, with some fluctuations in the intermediate years.
Analyzing net profit margins, the reported net profit margin shows an improvement over the years, moving from 31.18% in 2019 to a peak of 36.69% in 2022 before slightly declining in 2023 to 34.15% and rebounding to 35.96% in 2024. This suggests effective management of costs relative to revenues, with temporary margin compression in 2023.
Similarly, the adjusted net profit margin begins at 33.09% in 2019 and generally remains stable, with minor fluctuations. The margin rises to 35.10% in 2021, dips slightly in subsequent years to around 33.46% in 2023, and then improves to 36.35% in 2024. This pattern aligns closely with the reported margin trends, reflecting consistent profitability after adjusting for certain items.
- Income Trends
- Both reported and adjusted net incomes have more than doubled over the measured five-year period, demonstrating sustained earnings growth.
- The adjusted net income figures are consistently higher than the reported, indicating the presence of adjustments that increase recognized profitability.
- Profit Margin Analysis
- Reported net profit margin improved notably between 2019 and 2022, peaking near 37%, before a slight decline and recovery.
- Adjusted net profit margin remained relatively stable but displayed similar movements, suggesting stable operational efficiency despite external variances.
- Overall Insights
- The upward trend in net income alongside stable to improving profit margins points to strong financial performance and effective cost management.
- Fluctuations in margins around 2023 may indicate temporary pressures or strategic investments impacting profitability.
Adjusted Return on Equity (ROE)
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
2024 Calculations
1 ROE = 100 × Net income ÷ Stockholders’ equity
= 100 × ÷ =
2 Adjusted ROE = 100 × Adjusted net income ÷ Stockholders’ equity
= 100 × ÷ =
- Net Income Trends
- Reported net income demonstrates a consistent upward trajectory from 2019 through 2024, rising from $39,240 million to $88,136 million. The most significant increase occurred in the period ending June 30, 2021, followed by steady growth in subsequent years. Adjusted net income follows a similar pattern, increasing from $41,645 million in 2019 to $89,093 million in 2024. Notably, adjusted net income values are consistently higher than reported net income, implying there are adjustments that augment the underlying profitability figures.
- Return on Equity (ROE) Observations
- Reported ROE shows variability across the periods. Starting at 38.35% in 2019, it slightly decreases to 37.43% in 2020 before rising to a peak of 43.68% in 2022. After this peak, there is a marked decline to 35.09% in 2023 and further to 32.83% in 2024. Adjusted ROE follows a similar trend but remains consistently higher than the reported ROE. It begins at 40.7% in 2019, peaks at 41.56% in 2021, and then gradually declines to 33.18% in 2024. The decline in ROE in the last two years indicates either a reduction in net income relative to shareholder equity or an increase in equity without proportional income growth.
- Comparative Insights Between Reported and Adjusted Data
- The adjusted figures for both net income and ROE tend to be higher than the reported figures throughout the period under review. This suggests that adjustments made in the calculation of adjusted net income and ROE, such as excluding certain expenses or non-recurring items, result in a more favorable financial performance portrayal. The gap between reported and adjusted net income narrows somewhat in recent years, reflecting possibly fewer adjustments or smaller impact of such adjustments.
- Overall Financial Performance
- The company exhibits strong earnings growth over the six-year period with both reported and adjusted net income showing substantial increases. However, the declining ROE in recent years may be a signal warranting further examination of capital efficiency or changes in financial structure. The elevated and relatively stable adjusted ROE suggests underlying profitability remains sound despite these fluctuations.
Adjusted Return on Assets (ROA)
Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30).
2024 Calculations
1 ROA = 100 × Net income ÷ Total assets
= 100 × ÷ =
2 Adjusted ROA = 100 × Adjusted net income ÷ Total assets
= 100 × ÷ =
- Net Income Trends
- Reported net income exhibited a consistent upward trend from 2019 to 2024, increasing from $39,240 million to $88,136 million. A notable acceleration occurred between 2020 and 2022, where income rose sharply from $44,281 million to $72,738 million, followed by a slight dip in 2023 before reaching a peak in 2024.
- Adjusted net income, which provides an investment-adjusted perspective, also showed continuous growth over the same period. Values increased from $41,645 million in 2019 to $89,093 million in 2024. The increase was somewhat steadier compared to reported net income, with minor fluctuations in growth rate, yet maintaining a positive slope throughout.
- Return on Assets (ROA) Analysis
- Reported ROA revealed an initial rise from 13.69% in 2019 to a peak of 19.94% in 2022, suggesting improving efficiency in asset utilization during this timeframe. Subsequently, there was a decline through 2023 and 2024, ending at 17.21%, which indicates a slight reduction in asset profitability after 2022.
- Adjusted ROA followed a similar trajectory but displayed a more stable pattern, increasing from 14.53% in 2019 to 18.47% in 2022. Afterward, it experienced a smaller decrement, settling at 17.40% in 2024. This stability in adjusted ROA suggests that investment adjustments smooth out some volatility observed in the reported figures.
- Comparative Insights
- Adjusted financial metrics tend to be higher than their reported counterparts, consistent across net income and ROA, indicating that the adjustments likely account for non-operating items or investments that positively affect returns and income measures.
- The growth in net income and ROA until 2022 reflects strong operating performance and effective asset management, while the subsequent moderate decline in ROA points to either increased asset base or diminishing marginal returns despite sustained income growth.
- Overall, the data suggests a period of robust financial enhancement up to 2022, with some signs of stabilizing or slightly tapering asset efficiency thereafter, while profitability continues to expand.