Generated by Pacioli version 45d7c8c (updated 2 years, 7 months ago). Analysis at 2025-11-21T21:10:03+0000 for myAUDTaddress. Return to MAIN PAGE  
TypeDefinedBoundDerivedOKFail
calculation19500500

Calculations

#TypeName Rule Expression
1calculationus-gaap:Assets (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=AssetsCurrent_6+(PropertyPlantAndEquipmentNet_5+(LongTermInvestments_4+(Goodwill_3+(FiniteLivedIntangibleAssetsNet_2+OtherAssetsNoncurrent_1))))

2 instances:

us-gaap:Assets[193,468,000,000] = us-gaap:AssetsCurrent[139,660,000,000] + us-gaap:PropertyPlantAndEquipmentNet[18,356,000,000] + us-gaap:LongTermInvestments[10,431,000,000] + us-gaap:Goodwill[17,872,000,000] + us-gaap:FiniteLivedIntangibleAssetsNet[3,733,000,000] + us-gaap:OtherAssetsNoncurrent[3,416,000,000]

us-gaap:Assets[241,086,000,000] = us-gaap:AssetsCurrent[159,851,000,000] + us-gaap:PropertyPlantAndEquipmentNet[23,734,000,000] + us-gaap:LongTermInvestments[6,023,000,000] + us-gaap:Goodwill[35,122,000,000] + us-gaap:FiniteLivedIntangibleAssetsNet[10,106,000,000] + us-gaap:OtherAssetsNoncurrent[6,250,000,000]

2calculationus-gaap:AssetsCurrent (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=CashCashEquivalentsAndShortTermInvestments_4+(AccountsReceivableNetCurrent_3+(InventoryNet_2+OtherAssetsCurrent_1))

2 instances:

us-gaap:AssetsCurrent[139,660,000,000] = us-gaap:CashCashEquivalentsAndShortTermInvestments[113,240,000,000] + us-gaap:AccountsReceivableNetCurrent[18,277,000,000] + us-gaap:InventoryNet[2,251,000,000] + us-gaap:OtherAssetsCurrent[5,892,000,000]

us-gaap:AssetsCurrent[159,851,000,000] = us-gaap:CashCashEquivalentsAndShortTermInvestments[132,981,000,000] + us-gaap:AccountsReceivableNetCurrent[19,792,000,000] + us-gaap:InventoryNet[2,181,000,000] + us-gaap:OtherAssetsCurrent[4,897,000,000]

3calculationus-gaap:CashCashEquivalentsAndShortTermInvestments (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=CashAndCashEquivalentsAtCarryingValue_2+AvailableForSaleSecuritiesCurrent_1

2 instances:

us-gaap:CashCashEquivalentsAndShortTermInvestments[113,240,000,000] = us-gaap:CashAndCashEquivalentsAtCarryingValue[6,510,000,000] + us-gaap:AvailableForSaleSecuritiesCurrent[106,730,000,000]

us-gaap:CashCashEquivalentsAndShortTermInvestments[132,981,000,000] = us-gaap:CashAndCashEquivalentsAtCarryingValue[7,663,000,000] + us-gaap:AvailableForSaleSecuritiesCurrent[125,318,000,000]

4calculationus-gaap:Liabilities (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=LiabilitiesCurrent_5+(LongTermDebtNoncurrent_4+(DeferredRevenueNoncurrent_3+(DeferredTaxLiabilitiesNoncurrent_2+OtherLiabilitiesNoncurrent_1)))

2 instances:

us-gaap:Liabilities[121,471,000,000] = us-gaap:LiabilitiesCurrent[59,357,000,000] + us-gaap:LongTermDebtNoncurrent[40,557,000,000] + us-gaap:DeferredRevenueNoncurrent[6,441,000,000] + us-gaap:DeferredTaxLiabilitiesNoncurrent[1,476,000,000] + us-gaap:OtherLiabilitiesNoncurrent[13,640,000,000]

us-gaap:Liabilities[168,692,000,000] = us-gaap:LiabilitiesCurrent[64,527,000,000] + us-gaap:LongTermDebtNoncurrent[76,073,000,000] + us-gaap:DeferredRevenueNoncurrent[10,377,000,000] + us-gaap:DeferredTaxLiabilitiesNoncurrent[531,000,000] + us-gaap:OtherLiabilitiesNoncurrent[17,184,000,000]

5calculationus-gaap:LiabilitiesAndStockholdersEquity (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=Liabilities_3+(CommitmentsAndContingencies_2+StockholdersEquity_1)

2 instances:

us-gaap:LiabilitiesAndStockholdersEquity[193,468,000,000] = us-gaap:Liabilities[121,471,000,000] + us-gaap:CommitmentsAndContingencies[0] + us-gaap:StockholdersEquity[71,997,000,000]

us-gaap:LiabilitiesAndStockholdersEquity[241,086,000,000] = us-gaap:Liabilities[168,692,000,000] + us-gaap:CommitmentsAndContingencies[0] + us-gaap:StockholdersEquity[72,394,000,000]

6calculationus-gaap:LiabilitiesCurrent (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=AccountsPayableCurrent_8+(ShortTermBorrowings_7+(LongTermDebtCurrent_6+(EmployeeRelatedLiabilitiesCurrent_5+(AccruedIncomeTaxesCurrent_4+(DeferredRevenueCurrent_3+(DepositsReceivedForSecuritiesLoanedAtCarryingValue_2+OtherLiabilitiesCurrent_1))))))

2 instances:

us-gaap:LiabilitiesCurrent[59,357,000,000] = us-gaap:AccountsPayableCurrent[6,898,000,000] + us-gaap:ShortTermBorrowings[12,904,000,000] + us-gaap:LongTermDebtCurrent[0] + us-gaap:EmployeeRelatedLiabilitiesCurrent[5,264,000,000] + us-gaap:AccruedIncomeTaxesCurrent[580,000,000] + us-gaap:DeferredRevenueCurrent[27,468,000,000] + us-gaap:DepositsReceivedForSecuritiesLoanedAtCarryingValue[294,000,000] + us-gaap:OtherLiabilitiesCurrent[5,949,000,000]

us-gaap:LiabilitiesCurrent[64,527,000,000] = us-gaap:AccountsPayableCurrent[7,390,000,000] + us-gaap:ShortTermBorrowings[9,072,000,000] + us-gaap:LongTermDebtCurrent[1,049,000,000] + us-gaap:EmployeeRelatedLiabilitiesCurrent[5,819,000,000] + us-gaap:AccruedIncomeTaxesCurrent[718,000,000] + us-gaap:DeferredRevenueCurrent[34,102,000,000] + us-gaap:DepositsReceivedForSecuritiesLoanedAtCarryingValue[97,000,000] + us-gaap:OtherLiabilitiesCurrent[6,280,000,000]

7calculationus-gaap:StockholdersEquity (in Role_StatementBALANCESHEETS)
  • ok:2
  • failed:0
 

total=CommonStocksIncludingAdditionalPaidInCapital_3+(RetainedEarningsAccumulatedDeficit_2+AccumulatedOtherComprehensiveIncomeLossNetOfTax_1)

2 instances:

us-gaap:StockholdersEquity[71,997,000,000] = us-gaap:CommonStocksIncludingAdditionalPaidInCapital[68,178,000,000] + us-gaap:RetainedEarningsAccumulatedDeficit[2,282,000,000] + us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax[1,537,000,000]

us-gaap:StockholdersEquity[72,394,000,000] = us-gaap:CommonStocksIncludingAdditionalPaidInCapital[69,315,000,000] + us-gaap:RetainedEarningsAccumulatedDeficit[2,648,000,000] + us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax[431,000,000]

8calculationus-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease (in Role_StatementCASHFLOWSSTATEMENTS)
  • ok:3
  • failed:0
 

total=NetCashProvidedByUsedInOperatingActivitiesContinuingOperations_4+(NetCashProvidedByUsedInFinancingActivitiesContinuingOperations_3+(NetCashProvidedByUsedInInvestingActivitiesContinuingOperations_2+EffectOfExchangeRateOnCashAndCashEquivalents_1))

3 instances:

us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease[-3,074,000,000] = us-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[29,668,000,000] + us-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-9,668,000,000] + us-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23,001,000,000] + us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents[-73,000,000]

us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease[915,000,000] = us-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[33,325,000,000] + us-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-8,393,000,000] + us-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23,950,000,000] + us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents[-67,000,000]

us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease[1,153,000,000] = us-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[39,507,000,000] + us-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[8,408,000,000] + us-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-46,781,000,000] + us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents[19,000,000]

9calculationus-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations (in Role_StatementCASHFLOWSSTATEMENTS)
  • ok:3
  • failed:0
 

total=ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess_7+(ProceedsFromDebtMaturingInMoreThanThreeMonths_6+(-RepaymentsOfDebtMaturingInMoreThanThreeMonths_5+(ProceedsFromIssuanceOfCommonStock_4+(-PaymentsForRepurchaseOfCommonStock_3+(-PaymentsOfDividendsCommonStock_2+ProceedsFromPaymentsForOtherFinancingActivities_1)))))

3 instances:

us-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-9,668,000,000] = us-gaap:ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess[4,481,000,000] + us-gaap:ProceedsFromDebtMaturingInMoreThanThreeMonths[10,680,000,000] + - us-gaap:RepaymentsOfDebtMaturingInMoreThanThreeMonths[1,500,000,000] + us-gaap:ProceedsFromIssuanceOfCommonStock[634,000,000] + - us-gaap:PaymentsForRepurchaseOfCommonStock[14,443,000,000] + - us-gaap:PaymentsOfDividendsCommonStock[9,882,000,000] + us-gaap:ProceedsFromPaymentsForOtherFinancingActivities[362,000,000]

us-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-8,393,000,000] = us-gaap:ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess[7,195,000,000] + us-gaap:ProceedsFromDebtMaturingInMoreThanThreeMonths[13,884,000,000] + - us-gaap:RepaymentsOfDebtMaturingInMoreThanThreeMonths[2,796,000,000] + us-gaap:ProceedsFromIssuanceOfCommonStock[668,000,000] + - us-gaap:PaymentsForRepurchaseOfCommonStock[15,969,000,000] + - us-gaap:PaymentsOfDividendsCommonStock[11,006,000,000] + us-gaap:ProceedsFromPaymentsForOtherFinancingActivities[-369,000,000]

us-gaap:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[8,408,000,000] = us-gaap:ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess[-4,963,000,000] + us-gaap:ProceedsFromDebtMaturingInMoreThanThreeMonths[44,344,000,000] + - us-gaap:RepaymentsOfDebtMaturingInMoreThanThreeMonths[7,922,000,000] + us-gaap:ProceedsFromIssuanceOfCommonStock[772,000,000] + - us-gaap:PaymentsForRepurchaseOfCommonStock[11,788,000,000] + - us-gaap:PaymentsOfDividendsCommonStock[11,845,000,000] + us-gaap:ProceedsFromPaymentsForOtherFinancingActivities[-190,000,000]

10calculationus-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations (in Role_StatementCASHFLOWSSTATEMENTS)
  • ok:3
  • failed:0
 

total= -PaymentsToAcquirePropertyPlantAndEquipment_6+(-AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets_5+(-PaymentsToAcquireInvestments_4+(ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities_3+(ProceedsFromSaleOfAvailableForSaleSecurities_2+ -IncreaseDecreaseInCollateralHeldUnderSecuritiesLending_1))))

3 instances:

us-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23,001,000,000] = - us-gaap:PaymentsToAcquirePropertyPlantAndEquipment[5,944,000,000] + - msft:AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets[3,723,000,000] + - us-gaap:PaymentsToAcquireInvestments[98,729,000,000] + us-gaap:ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities[15,013,000,000] + us-gaap:ProceedsFromSaleOfAvailableForSaleSecurities[70,848,000,000] + - us-gaap:IncreaseDecreaseInCollateralHeldUnderSecuritiesLending[466,000,000]

us-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23,950,000,000] = - us-gaap:PaymentsToAcquirePropertyPlantAndEquipment[8,343,000,000] + - msft:AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets[1,393,000,000] + - us-gaap:PaymentsToAcquireInvestments[129,758,000,000] + us-gaap:ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities[22,054,000,000] + us-gaap:ProceedsFromSaleOfAvailableForSaleSecurities[93,287,000,000] + - us-gaap:IncreaseDecreaseInCollateralHeldUnderSecuritiesLending[-203,000,000]

us-gaap:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-46,781,000,000] = - us-gaap:PaymentsToAcquirePropertyPlantAndEquipment[8,129,000,000] + - msft:AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets[25,944,000,000] + - us-gaap:PaymentsToAcquireInvestments[176,905,000,000] + us-gaap:ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities[28,044,000,000] + us-gaap:ProceedsFromSaleOfAvailableForSaleSecurities[136,350,000,000] + - us-gaap:IncreaseDecreaseInCollateralHeldUnderSecuritiesLending[197,000,000]

11calculationus-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations (in Role_StatementCASHFLOWSSTATEMENTS)
  • ok:3
  • failed:0
 

total=NetIncomeLoss_15+(AssetImpairmentCharges_14+(DepreciationAmortizationAndOther_13+(ShareBasedCompensation_12+(-GainLossOnInvestmentsAndDerivativeInstruments_11+(DeferredIncomeTaxExpenseBenefit_10+(IncreaseDecreaseInDeferredRevenue_9+(-RecognitionOfDeferredRevenue_8+(-IncreaseDecreaseInAccountsReceivable_7+(-IncreaseDecreaseInInventories_6+(-IncreaseDecreaseInOtherCurrentAssets_5+(-IncreaseDecreaseInOtherNoncurrentAssets_4+(IncreaseDecreaseInAccountsPayable_3+(IncreaseDecreaseInOtherCurrentLiabilities_2+IncreaseDecreaseInOtherNoncurrentLiabilities_1)))))))))))))

3 instances:

us-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[29,668,000,000] = us-gaap:NetIncomeLoss[12,193,000,000] + us-gaap:AssetImpairmentCharges[7,498,000,000] + msft:DepreciationAmortizationAndOther[5,957,000,000] + us-gaap:ShareBasedCompensation[2,574,000,000] + - msft:GainLossOnInvestmentsAndDerivativeInstruments[443,000,000] + us-gaap:DeferredIncomeTaxExpenseBenefit[224,000,000] + us-gaap:IncreaseDecreaseInDeferredRevenue[45,072,000,000] + - us-gaap:RecognitionOfDeferredRevenue[44,920,000,000] + - us-gaap:IncreaseDecreaseInAccountsReceivable[-1,456,000,000] + - us-gaap:IncreaseDecreaseInInventories[272,000,000] + - us-gaap:IncreaseDecreaseInOtherCurrentAssets[-62,000,000] + - us-gaap:IncreaseDecreaseInOtherNoncurrentAssets[-346,000,000] + us-gaap:IncreaseDecreaseInAccountsPayable[-1,054,000,000] + us-gaap:IncreaseDecreaseInOtherCurrentLiabilities[-624,000,000] + us-gaap:IncreaseDecreaseInOtherNoncurrentLiabilities[1,599,000,000]

us-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[33,325,000,000] = us-gaap:NetIncomeLoss[16,798,000,000] + us-gaap:AssetImpairmentCharges[630,000,000] + msft:DepreciationAmortizationAndOther[6,622,000,000] + us-gaap:ShareBasedCompensation[2,668,000,000] + - msft:GainLossOnInvestmentsAndDerivativeInstruments[223,000,000] + us-gaap:DeferredIncomeTaxExpenseBenefit[332,000,000] + us-gaap:IncreaseDecreaseInDeferredRevenue[57,072,000,000] + - us-gaap:RecognitionOfDeferredRevenue[48,498,000,000] + - us-gaap:IncreaseDecreaseInAccountsReceivable[530,000,000] + - us-gaap:IncreaseDecreaseInInventories[-600,000,000] + - us-gaap:IncreaseDecreaseInOtherCurrentAssets[1,167,000,000] + - us-gaap:IncreaseDecreaseInOtherNoncurrentAssets[41,000,000] + us-gaap:IncreaseDecreaseInAccountsPayable[88,000,000] + us-gaap:IncreaseDecreaseInOtherCurrentLiabilities[-260,000,000] + us-gaap:IncreaseDecreaseInOtherNoncurrentLiabilities[-766,000,000]

us-gaap:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[39,507,000,000] = us-gaap:NetIncomeLoss[21,204,000,000] + us-gaap:AssetImpairmentCharges[0] + msft:DepreciationAmortizationAndOther[8,778,000,000] + us-gaap:ShareBasedCompensation[3,266,000,000] + - msft:GainLossOnInvestmentsAndDerivativeInstruments[2,073,000,000] + us-gaap:DeferredIncomeTaxExpenseBenefit[-3,296,000,000] + us-gaap:IncreaseDecreaseInDeferredRevenue[67,711,000,000] + - us-gaap:RecognitionOfDeferredRevenue[57,735,000,000] + - us-gaap:IncreaseDecreaseInAccountsReceivable[925,000,000] + - us-gaap:IncreaseDecreaseInInventories[-50,000,000] + - us-gaap:IncreaseDecreaseInOtherCurrentAssets[-1,066,000,000] + - us-gaap:IncreaseDecreaseInOtherNoncurrentAssets[539,000,000] + us-gaap:IncreaseDecreaseInAccountsPayable[81,000,000] + us-gaap:IncreaseDecreaseInOtherCurrentLiabilities[386,000,000] + us-gaap:IncreaseDecreaseInOtherNoncurrentLiabilities[1,533,000,000]

12calculationus-gaap:ComprehensiveIncomeNetOfTax (in Role_StatementCOMPREHENSIVEINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=NetIncomeLoss_2+OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent_1

3 instances:

us-gaap:ComprehensiveIncomeNetOfTax[11,007,000,000] = us-gaap:NetIncomeLoss[12,193,000,000] + us-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1,186,000,000]

us-gaap:ComprehensiveIncomeNetOfTax[15,813,000,000] = us-gaap:NetIncomeLoss[16,798,000,000] + us-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-985,000,000]

us-gaap:ComprehensiveIncomeNetOfTax[20,098,000,000] = us-gaap:NetIncomeLoss[21,204,000,000] + us-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1,106,000,000]

13calculationus-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent (in Role_StatementCOMPREHENSIVEINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax_3+(OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax_2+OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax_1)

3 instances:

us-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1,186,000,000] = us-gaap:OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax[559,000,000] + us-gaap:OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax[-362,000,000] + us-gaap:OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax[-1,383,000,000]

us-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-985,000,000] = us-gaap:OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax[-238,000,000] + us-gaap:OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax[-228,000,000] + us-gaap:OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax[-519,000,000]

us-gaap:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1,106,000,000] = us-gaap:OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax[-218,000,000] + us-gaap:OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax[-1,116,000,000] + us-gaap:OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax[228,000,000]

14calculationus-gaap:CostOfRevenue (in Role_StatementINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=CostOfGoodsSold_2+CostOfServicesAndOther_1

3 instances:

us-gaap:CostOfRevenue[33,038,000,000] = us-gaap:CostOfGoodsSold[21,410,000,000] + msft:CostOfServicesAndOther[11,628,000,000]

us-gaap:CostOfRevenue[32,780,000,000] = us-gaap:CostOfGoodsSold[17,880,000,000] + msft:CostOfServicesAndOther[14,900,000,000]

us-gaap:CostOfRevenue[34,261,000,000] = us-gaap:CostOfGoodsSold[15,175,000,000] + msft:CostOfServicesAndOther[19,086,000,000]

15calculationus-gaap:GrossProfit (in Role_StatementINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=SalesRevenueNet_2+ -CostOfRevenue_1

3 instances:

us-gaap:GrossProfit[60,542,000,000] = us-gaap:SalesRevenueNet[93,580,000,000] + - us-gaap:CostOfRevenue[33,038,000,000]

us-gaap:GrossProfit[52,540,000,000] = us-gaap:SalesRevenueNet[85,320,000,000] + - us-gaap:CostOfRevenue[32,780,000,000]

us-gaap:GrossProfit[55,689,000,000] = us-gaap:SalesRevenueNet[89,950,000,000] + - us-gaap:CostOfRevenue[34,261,000,000]

16calculationus-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments (in Role_StatementINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=OperatingIncomeLoss_2+NonoperatingIncomeExpense_1

3 instances:

us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[18,507,000,000] = us-gaap:OperatingIncomeLoss[18,161,000,000] + us-gaap:NonoperatingIncomeExpense[346,000,000]

us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[19,751,000,000] = us-gaap:OperatingIncomeLoss[20,182,000,000] + us-gaap:NonoperatingIncomeExpense[-431,000,000]

us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[23,149,000,000] = us-gaap:OperatingIncomeLoss[22,326,000,000] + us-gaap:NonoperatingIncomeExpense[823,000,000]

17calculationus-gaap:NetIncomeLoss (in Role_StatementINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments_2+ -IncomeTaxExpenseBenefit_1

3 instances:

us-gaap:NetIncomeLoss[12,193,000,000] = us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[18,507,000,000] + - us-gaap:IncomeTaxExpenseBenefit[6,314,000,000]

us-gaap:NetIncomeLoss[16,798,000,000] = us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[19,751,000,000] + - us-gaap:IncomeTaxExpenseBenefit[2,953,000,000]

us-gaap:NetIncomeLoss[21,204,000,000] = us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[23,149,000,000] + - us-gaap:IncomeTaxExpenseBenefit[1,945,000,000]

18calculationus-gaap:OperatingIncomeLoss (in Role_StatementINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=GrossProfit_5+(-ResearchAndDevelopmentExpense_4+(-SellingAndMarketingExpense_3+(-GeneralAndAdministrativeExpense_2+ -ImpairmentIntegrationAndRestructuringExpenses_1)))

3 instances:

us-gaap:OperatingIncomeLoss[18,161,000,000] = us-gaap:GrossProfit[60,542,000,000] + - us-gaap:ResearchAndDevelopmentExpense[12,046,000,000] + - us-gaap:SellingAndMarketingExpense[15,713,000,000] + - us-gaap:GeneralAndAdministrativeExpense[4,611,000,000] + - msft:ImpairmentIntegrationAndRestructuringExpenses[10,011,000,000]

us-gaap:OperatingIncomeLoss[20,182,000,000] = us-gaap:GrossProfit[52,540,000,000] + - us-gaap:ResearchAndDevelopmentExpense[11,988,000,000] + - us-gaap:SellingAndMarketingExpense[14,697,000,000] + - us-gaap:GeneralAndAdministrativeExpense[4,563,000,000] + - msft:ImpairmentIntegrationAndRestructuringExpenses[1,110,000,000]

us-gaap:OperatingIncomeLoss[22,326,000,000] = us-gaap:GrossProfit[55,689,000,000] + - us-gaap:ResearchAndDevelopmentExpense[13,037,000,000] + - us-gaap:SellingAndMarketingExpense[15,539,000,000] + - us-gaap:GeneralAndAdministrativeExpense[4,481,000,000] + - msft:ImpairmentIntegrationAndRestructuringExpenses[306,000,000]

19calculationus-gaap:SalesRevenueNet (in Role_StatementINCOMESTATEMENTS)
  • ok:3
  • failed:0
 

total=SalesRevenueGoodsNet_2+SalesRevenueServicesAndOtherNet_1

3 instances:

us-gaap:SalesRevenueNet[93,580,000,000] = us-gaap:SalesRevenueGoodsNet[75,956,000,000] + msft:SalesRevenueServicesAndOtherNet[17,624,000,000]

us-gaap:SalesRevenueNet[85,320,000,000] = us-gaap:SalesRevenueGoodsNet[61,502,000,000] + msft:SalesRevenueServicesAndOtherNet[23,818,000,000]

us-gaap:SalesRevenueNet[89,950,000,000] = us-gaap:SalesRevenueGoodsNet[57,190,000,000] + msft:SalesRevenueServicesAndOtherNet[32,760,000,000]

The colours used for the rules are significant, and have the following meanings:

For more information: http://accounting.auditchain.finance/index.html
DISCLAIMER: this analysis is provided by software still under development, and likely incomplete or even erroneous; do NOT use it other than for experimental, inconsequential purposes