Common-Size Balance Sheet: Assets
Quarterly Data
Paying user area
Try for free
Microsoft Corp. pages available for free this week:
- Income Statement
- Analysis of Liquidity Ratios
- Analysis of Solvency Ratios
- DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
- Analysis of Reportable Segments
- Analysis of Geographic Areas
- Enterprise Value (EV)
- Enterprise Value to FCFF (EV/FCFF)
- Return on Equity (ROE) since 2005
- Price to Book Value (P/BV) since 2005
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:
Based on: 10-Q (reporting date: 2025-09-30), 10-K (reporting date: 2025-06-30), 10-Q (reporting date: 2025-03-31), 10-Q (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-K (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-Q (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30).
- Cash and Cash Equivalents
- The proportion of cash and cash equivalents relative to total assets fluctuated over the periods, ranging mostly between approximately 3% and 8%. Notably, there was a sharp increase observed in mid-2023, reaching over 18%, before declining again to levels closer to the historical average in subsequent quarters.
- Short-term Investments
- This category showed a clear declining trend as a percentage of total assets, decreasing steadily from more than 44% in late 2019 to near 9-11% by later periods around 2025. This decline suggests a strategic reduction in liquid marketable securities over time.
- Cash, Cash Equivalents, and Short-term Investments Combined
- Overall liquidity, measured by the sum of cash, equivalents, and short-term investments as a percentage of total assets, decreased from nearly 49% down to ranges between 13% and 16% in later periods. There was an exceptional dip around late 2023, coinciding with the peak in cash equivalents, implying possible reallocation within liquid assets categories.
- Accounts Receivable, Net
- Accounts receivable as a percentage of total assets showed variability with spikes around mid-2020 and mid-2023, reaching above 11%. The pattern suggests periodic increases in credit extended to customers or changes in collections, with intermediate quarters reflecting decreases back toward 7% to 9%.
- Inventories
- Inventories maintained a low percentage relative to total assets, generally under 1%, with minor fluctuations over the period. This low level reflects limited inventory holdings consistent with a business model less reliant on physical stock.
- Other Current Assets
- This category demonstrated moderate growth over time, rising from about 2.7% to consistently above 4%, nearing 5%, indicating expanding miscellaneous current asset holdings.
- Current Assets
- The share of current assets in total assets gradually declined over time from nearly 60% toward roughly 30% by later periods. This points to a strategic shift towards long-term investments or assets, away from current asset accumulation.
- Property and Equipment, Net
- There was a strong upward trend in property and equipment as a percentage of total assets, rising from around 14% to above 36% by the latest periods. This steady increase evidences significant investment in fixed assets over time.
- Operating Lease Right-of-Use Assets
- The percentage allocated to operating lease right-of-use assets remained fairly stable in the 2.8%-4.3% range, with slight gradual increases evident, reflecting sustained lease commitments.
- Equity and Other Investments
- Equity and other investments grew moderately from under 1% to a peak above 3% before tapering back closer to 1.8% by the last period, indicating some fluctuation in strategic investments outside core operations.
- Goodwill
- Goodwill showed moderate variation, initially close to 15%, then rising sharply to over 25% around late 2023, followed by a decline to near 19% subsequently. This pattern may reflect acquisition activity and subsequent impairment or reassessment.
- Intangible Assets, Net
- Intangible assets as a share of total assets decreased from around 2.7% to about 3.3% mid-period before spiking significantly to over 6% in late 2023 and then falling back to approximately 3.3%. These swings suggest valuing or acquisition changes in intellectual property or similar assets.
- Other Long-term Assets
- Other long-term assets showed modest growth, moving from around 5.2% up to about 7.4%, indicating gradual accumulation of assets classified as other long-term.
- Long-term Assets
- Overall, long-term assets increased notably as a percentage of total assets, from about 40.5% up to over 70% by the end of the latest period, underscoring a strategic focus on long-term holdings.
- Total Assets
- By definition, total assets remain constant at 100% throughout all periods, serving as the baseline for all ratio calculations.