Adjusted Financial Ratios (Summary)
Based on: 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), 10-K (reporting date: 2018-06-30).
Financial ratio | Description | The company |
---|---|---|
Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Microsoft Corp. adjusted total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023. |
Adjusted current ratio | A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. | Microsoft Corp. adjusted current ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023. |
Adjusted debt-to-equity ratio | A solvency ratio calculated as adjusted total debt divided by adjusted total equity. | Microsoft Corp. adjusted debt-to-equity ratio improved from 2021 to 2022 and from 2022 to 2023. |
Adjusted debt-to-capital ratio | A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity. | Microsoft Corp. adjusted debt-to-capital ratio improved from 2021 to 2022 and from 2022 to 2023. |
Adjusted financial leverage | A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity. Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income. |
Microsoft Corp. adjusted financial leverage ratio decreased from 2021 to 2022 and from 2022 to 2023. |
Adjusted net profit margin | An indicator of profitability, calculated as adjusted net income divided by total revenue. | Microsoft Corp. adjusted net profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023. |
Adjusted ROE | A profitability ratio calculated as adjusted net income divided by adjusted total equity. | Microsoft Corp. adjusted ROE deteriorated from 2021 to 2022 and from 2022 to 2023. |
Adjusted ROA | A profitability ratio calculated as adjusted net income divided by adjusted total assets. | Microsoft Corp. adjusted ROA deteriorated from 2021 to 2022 and from 2022 to 2023. |
Microsoft Corp., Financial Ratios: Reported vs. Adjusted
Adjusted Total Asset Turnover
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Total asset turnover = Revenue ÷ Total assets
= 211,915 ÷ 411,976 = 0.51
2 Adjusted revenue. See details »
3 Adjusted total assets. See details »
4 2023 Calculation
Adjusted total asset turnover = Adjusted revenue ÷ Adjusted total assets
= 217,320 ÷ 392,463 = 0.55
Activity ratio | Description | The company |
---|---|---|
Adjusted total asset turnover | An activity ratio calculated as total revenue divided by adjusted total assets. | Microsoft Corp. adjusted total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023. |
Adjusted Current Ratio
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= 184,257 ÷ 104,149 = 1.77
2 Adjusted current assets. See details »
3 Adjusted current liabilities. See details »
4 2023 Calculation
Adjusted current ratio = Adjusted current assets ÷ Adjusted current liabilities
= 184,907 ÷ 53,248 = 3.47
Liquidity ratio | Description | The company |
---|---|---|
Adjusted current ratio | A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. | Microsoft Corp. adjusted current ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023. |
Adjusted Debt to Equity
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Debt to equity = Total debt ÷ Stockholders’ equity
= 64,304 ÷ 206,223 = 0.31
2 Adjusted total debt. See details »
3 Adjusted stockholders’ equity. See details »
4 2023 Calculation
Adjusted debt to equity = Adjusted total debt ÷ Adjusted stockholders’ equity
= 79,441 ÷ 240,956 = 0.33
Solvency ratio | Description | The company |
---|---|---|
Adjusted debt-to-equity ratio | A solvency ratio calculated as adjusted total debt divided by adjusted total equity. | Microsoft Corp. adjusted debt-to-equity ratio improved from 2021 to 2022 and from 2022 to 2023. |
Adjusted Debt to Capital
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Debt to capital = Total debt ÷ Total capital
= 64,304 ÷ 270,527 = 0.24
2 Adjusted total debt. See details »
3 Adjusted total capital. See details »
4 2023 Calculation
Adjusted debt to capital = Adjusted total debt ÷ Adjusted total capital
= 79,441 ÷ 320,397 = 0.25
Solvency ratio | Description | The company |
---|---|---|
Adjusted debt-to-capital ratio | A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity. | Microsoft Corp. adjusted debt-to-capital ratio improved from 2021 to 2022 and from 2022 to 2023. |
Adjusted Financial Leverage
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Financial leverage = Total assets ÷ Stockholders’ equity
= 411,976 ÷ 206,223 = 2.00
2 Adjusted total assets. See details »
3 Adjusted stockholders’ equity. See details »
4 2023 Calculation
Adjusted financial leverage = Adjusted total assets ÷ Adjusted stockholders’ equity
= 392,463 ÷ 240,956 = 1.63
Solvency ratio | Description | The company |
---|---|---|
Adjusted financial leverage | A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity. Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income. |
Microsoft Corp. adjusted financial leverage ratio decreased from 2021 to 2022 and from 2022 to 2023. |
Adjusted Net Profit Margin
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
Net profit margin = 100 × Net income ÷ Revenue
= 100 × 72,361 ÷ 211,915 = 34.15%
2 Adjusted net income. See details »
3 Adjusted revenue. See details »
4 2023 Calculation
Adjusted net profit margin = 100 × Adjusted net income ÷ Adjusted revenue
= 100 × 70,059 ÷ 217,320 = 32.24%
Profitability ratio | Description | The company |
---|---|---|
Adjusted net profit margin | An indicator of profitability, calculated as adjusted net income divided by total revenue. | Microsoft Corp. adjusted net profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023. |
Adjusted Return on Equity (ROE)
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
ROE = 100 × Net income ÷ Stockholders’ equity
= 100 × 72,361 ÷ 206,223 = 35.09%
2 Adjusted net income. See details »
3 Adjusted stockholders’ equity. See details »
4 2023 Calculation
Adjusted ROE = 100 × Adjusted net income ÷ Adjusted stockholders’ equity
= 100 × 70,059 ÷ 240,956 = 29.08%
Profitability ratio | Description | The company |
---|---|---|
Adjusted ROE | A profitability ratio calculated as adjusted net income divided by adjusted total equity. | Microsoft Corp. adjusted ROE deteriorated from 2021 to 2022 and from 2022 to 2023. |
Adjusted Return on Assets (ROA)
Based on: 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), 10-K (reporting date: 2018-06-30).
1 2023 Calculation
ROA = 100 × Net income ÷ Total assets
= 100 × 72,361 ÷ 411,976 = 17.56%
2 Adjusted net income. See details »
3 Adjusted total assets. See details »
4 2023 Calculation
Adjusted ROA = 100 × Adjusted net income ÷ Adjusted total assets
= 100 × 70,059 ÷ 392,463 = 17.85%
Profitability ratio | Description | The company |
---|---|---|
Adjusted ROA | A profitability ratio calculated as adjusted net income divided by adjusted total assets. | Microsoft Corp. adjusted ROA deteriorated from 2021 to 2022 and from 2022 to 2023. |