Generated by Logical Toolkit for XBRL version f512f32 (updated 14 hours ago). Analysis at 2021-06-12T15:41:37+0000 for charles.hoffman@me.com. This page will remain online at https://pacioli.logicalcontracts.com/reportAnalysis/fb48e93daa9dbb638fa73b35727499980ab8a256.report/index.html for about 28 days.

TypeDefinedBoundDerivedOKFail
calculation7424802480

Rule Details

TypeName Rule Expression
calculationfac:Assets (in BalanceSheetClassified)
  • derived:0
  • ok:0
  • failed:0
 

total=CurrentAssets_2+NoncurrentAssets_1

0 instance:

calculationfac:Equity (in BalanceSheetClassified)
  • derived:0
  • ok:3
  • failed:0
 

total=EquityAttributableToParent_2+EquityAttributableToNoncontrollingInterest_1

3 instances:

fac:Equity[71997000000] = fac:EquityAttributableToParent[71997000000] + fac:EquityAttributableToNoncontrollingInterest[0]

fac:Equity[72394000000] = fac:EquityAttributableToParent[72394000000] + fac:EquityAttributableToNoncontrollingInterest[0]

fac:Equity[80083000000] = fac:EquityAttributableToParent[80083000000] + fac:EquityAttributableToNoncontrollingInterest[0]

calculationfac:Liabilities (in BalanceSheetClassified)
  • derived:0
  • ok:2
  • failed:0
 

total=CurrentLiabilities_2+NoncurrentLiabilities_1

2 instances:

fac:Liabilities[168692000000] = fac:CurrentLiabilities[64527000000] + fac:NoncurrentLiabilities[104165000000]

fac:Liabilities[121471000000] = fac:CurrentLiabilities[59357000000] + fac:NoncurrentLiabilities[62114000000]

calculationfac:LiabilitiesAndEquity (in BalanceSheetClassified)
  • derived:0
  • ok:0
  • failed:0
 

total=Liabilities_4+(CommitmentsAndContingencies_3+(TemporaryEquity_2+Equity_1))

0 instance:

calculationfac:NetCashFlow (in CashFlowStatement)
  • derived:0
  • ok:3
  • failed:0
 

total=NetCashFlowFromOperatingActivities_4+(NetCashFlowFromInvestingActivities_3+(NetCashFlowFromFinancingActivities_2+ExchangeGainsLosses_1))

3 instances:

fac:NetCashFlow[1153000000] = fac:NetCashFlowFromOperatingActivities[39507000000] + fac:NetCashFlowFromInvestingActivities[-46781000000] + fac:NetCashFlowFromFinancingActivities[8408000000] + fac:ExchangeGainsLosses[19000000]

fac:NetCashFlow[915000000] = fac:NetCashFlowFromOperatingActivities[33325000000] + fac:NetCashFlowFromInvestingActivities[-23950000000] + fac:NetCashFlowFromFinancingActivities[-8393000000] + fac:ExchangeGainsLosses[-67000000]

fac:NetCashFlow[-3074000000] = fac:NetCashFlowFromOperatingActivities[29668000000] + fac:NetCashFlowFromInvestingActivities[-23001000000] + fac:NetCashFlowFromFinancingActivities[-9668000000] + fac:ExchangeGainsLosses[-73000000]

calculationfac:NetCashFlowFromFinancingActivities (in CashFlowStatement)
  • derived:0
  • ok:0
  • failed:0
 

total=NetCashFlowFromFinancingActivitiesContinuing_2+NetCashFlowFromFinancingActivitiesDiscontinued_1

0 instance:

calculationfac:NetCashFlowFromInvestingActivities (in CashFlowStatement)
  • derived:0
  • ok:0
  • failed:0
 

total=NetCashFlowFromInvestingActivitiesContinuing_2+NetCashFlowFromInvestingActivitiesDiscontinued_1

0 instance:

calculationfac:NetCashFlowFromOperatingActivities (in CashFlowStatement)
  • derived:0
  • ok:0
  • failed:0
 

total=NetCashFlowFromOperatingActivitiesContinuing_2+NetCashFlowFromOperatingActivitiesDiscontinued_1

0 instance:

calculationfac:ComprehensiveIncomeLoss (in ComprehensiveIncomeBreakdown)
  • derived:0
  • ok:11
  • failed:0
 

total=ComprehensiveIncomeLossAttributableToParent_2+ComprehensiveIncomeLossAttributableToNoncontrollingInterest_1

11 instances:

fac:ComprehensiveIncomeLoss[11007000000] = fac:ComprehensiveIncomeLossAttributableToParent[11007000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[15813000000] = fac:ComprehensiveIncomeLossAttributableToParent[15813000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[20098000000] = fac:ComprehensiveIncomeLossAttributableToParent[20098000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[3122000000] = fac:ComprehensiveIncomeLossAttributableToParent[3122000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[3756000000] = fac:ComprehensiveIncomeLossAttributableToParent[3756000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[4690000000] = fac:ComprehensiveIncomeLossAttributableToParent[4690000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[4801000000] = fac:ComprehensiveIncomeLossAttributableToParent[4801000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[4902000000] = fac:ComprehensiveIncomeLossAttributableToParent[4902000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[5018000000] = fac:ComprehensiveIncomeLossAttributableToParent[5018000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[5200000000] = fac:ComprehensiveIncomeLossAttributableToParent[5200000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

fac:ComprehensiveIncomeLoss[6513000000] = fac:ComprehensiveIncomeLossAttributableToParent[6513000000] + fac:ComprehensiveIncomeLossAttributableToNoncontrollingInterest[0]

calculationfac:NetCashFlowContinuing (in ContinuingDiscontuedBreakdown)
  • derived:0
  • ok:3
  • failed:0
 

total=NetCashFlowFromOperatingActivitiesContinuing_3+(NetCashFlowFromInvestingActivitiesContinuing_2+NetCashFlowFromFinancingActivitiesContinuing_1)

3 instances:

fac:NetCashFlowContinuing[-3001000000] = fac:NetCashFlowFromOperatingActivitiesContinuing[29668000000] + fac:NetCashFlowFromInvestingActivitiesContinuing[-23001000000] + fac:NetCashFlowFromFinancingActivitiesContinuing[-9668000000]

fac:NetCashFlowContinuing[982000000] = fac:NetCashFlowFromOperatingActivitiesContinuing[33325000000] + fac:NetCashFlowFromInvestingActivitiesContinuing[-23950000000] + fac:NetCashFlowFromFinancingActivitiesContinuing[-8393000000]

fac:NetCashFlowContinuing[1134000000] = fac:NetCashFlowFromOperatingActivitiesContinuing[39507000000] + fac:NetCashFlowFromInvestingActivitiesContinuing[-46781000000] + fac:NetCashFlowFromFinancingActivitiesContinuing[8408000000]

calculationfac:NetCashFlowDiscontinued (in ContinuingDiscontuedBreakdown)
  • derived:0
  • ok:0
  • failed:0
 

total=NetCashFlowFromOperatingActivitiesDiscontinued_3+(NetCashFlowFromInvestingActivitiesDiscontinued_2+NetCashFlowFromFinancingActivitiesDiscontinued_1)

0 instance:

calculationfac:GrossProfit (in IncomeStatementSingleStep_Special6)
  • derived:0
  • ok:11
  • failed:0
 

total=Revenues_2+ -CostOfRevenue_1

11 instances:

fac:GrossProfit[55689000000] = fac:Revenues[89950000000] + - fac:CostOfRevenue[34261000000]

fac:GrossProfit[52540000000] = fac:Revenues[85320000000] + - fac:CostOfRevenue[32780000000]

fac:GrossProfit[60542000000] = fac:Revenues[93580000000] + - fac:CostOfRevenue[33038000000]

fac:GrossProfit[12609000000] = fac:Revenues[20453000000] + - fac:CostOfRevenue[7844000000]

fac:GrossProfit[14189000000] = fac:Revenues[24090000000] + - fac:CostOfRevenue[9901000000]

fac:GrossProfit[14030000000] = fac:Revenues[22090000000] + - fac:CostOfRevenue[8060000000]

fac:GrossProfit[14861000000] = fac:Revenues[23317000000] + - fac:CostOfRevenue[8456000000]

fac:GrossProfit[13172000000] = fac:Revenues[20379000000] + - fac:CostOfRevenue[7207000000]

fac:GrossProfit[13924000000] = fac:Revenues[23796000000] + - fac:CostOfRevenue[9872000000]

fac:GrossProfit[12809000000] = fac:Revenues[20531000000] + - fac:CostOfRevenue[7722000000]

fac:GrossProfit[12635000000] = fac:Revenues[20614000000] + - fac:CostOfRevenue[7979000000]

calculationfac:IncomeLossFromContinuingOperationsAfterTax (in IncomeStatementSingleStep_Special6)
  • derived:0
  • ok:3
  • failed:0
 

total=IncomeLossFromContinuingOperationsBeforeTax_2+ -IncomeTaxExpenseBenefit_1

3 instances:

fac:IncomeLossFromContinuingOperationsAfterTax[21204000000] = fac:IncomeLossFromContinuingOperationsBeforeTax[23149000000] + - fac:IncomeTaxExpenseBenefit[1945000000]

fac:IncomeLossFromContinuingOperationsAfterTax[16798000000] = fac:IncomeLossFromContinuingOperationsBeforeTax[19751000000] + - fac:IncomeTaxExpenseBenefit[2953000000]

fac:IncomeLossFromContinuingOperationsAfterTax[12193000000] = fac:IncomeLossFromContinuingOperationsBeforeTax[18507000000] + - fac:IncomeTaxExpenseBenefit[6314000000]

calculationfac:IncomeLossFromContinuingOperationsBeforeTax (in IncomeStatementSingleStep_Special6)
  • derived:0
  • ok:0
  • failed:0
 

total=OperatingIncomeLoss_2+NonoperatingIncomePlusInterestAndDebtExpensePlusIncomeFromEquityMethodInvestments_1

0 instance:

calculationfac:NetIncomeLoss (in IncomeStatementSingleStep_Special6)
  • derived:0
  • ok:0
  • failed:0
 

total=IncomeLossFromContinuingOperationsAfterTax_2+IncomeLossFromDiscontinuedOperationsNetOfTax_1

0 instance:

calculationfac:OperatingIncomeLoss (in IncomeStatementSingleStep_Special6)
  • derived:0
  • ok:11
  • failed:0
 

total=GrossProfit_2+ -OperatingExpenses_1

11 instances:

fac:OperatingIncomeLoss[22326000000] = fac:GrossProfit[55689000000] + - fac:OperatingExpenses[33363000000]

fac:OperatingIncomeLoss[20182000000] = fac:GrossProfit[52540000000] + - fac:OperatingExpenses[32358000000]

fac:OperatingIncomeLoss[18161000000] = fac:GrossProfit[60542000000] + - fac:OperatingExpenses[42381000000]

fac:OperatingIncomeLoss[5225000000] = fac:GrossProfit[12609000000] + - fac:OperatingExpenses[7384000000]

fac:OperatingIncomeLoss[6177000000] = fac:GrossProfit[14189000000] + - fac:OperatingExpenses[8012000000]

fac:OperatingIncomeLoss[5594000000] = fac:GrossProfit[14030000000] + - fac:OperatingExpenses[8436000000]

fac:OperatingIncomeLoss[5330000000] = fac:GrossProfit[14861000000] + - fac:OperatingExpenses[9531000000]

fac:OperatingIncomeLoss[5793000000] = fac:GrossProfit[13172000000] + - fac:OperatingExpenses[7379000000]

fac:OperatingIncomeLoss[6026000000] = fac:GrossProfit[13924000000] + - fac:OperatingExpenses[7898000000]

fac:OperatingIncomeLoss[5283000000] = fac:GrossProfit[12809000000] + - fac:OperatingExpenses[7526000000]

fac:OperatingIncomeLoss[3080000000] = fac:GrossProfit[12635000000] + - fac:OperatingExpenses[9555000000]

calculationfac:NetCashFlow (in NetCashFlowBreakdown)
  • derived:0
  • ok:0
  • failed:0
 

total=NetCashFlowContinuing_3+(NetCashFlowDiscontinued_2+ExchangeGainsLosses_1)

0 instance:

calculationfac:NetIncomeLossAvailableToCommonStockholdersBasic (in NetIncomeLossAvailableToCommonBreakdown)
  • derived:0
  • ok:11
  • failed:0
 

total=NetIncomeLossAttributableToParent_2+ -PreferredStockDividendsAndOtherAdjustments_1

11 instances:

fac:NetIncomeLossAvailableToCommonStockholdersBasic[3122000000] = fac:NetIncomeLossAttributableToParent[3122000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[3756000000] = fac:NetIncomeLossAttributableToParent[3756000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[4690000000] = fac:NetIncomeLossAttributableToParent[4690000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[4801000000] = fac:NetIncomeLossAttributableToParent[4801000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[4902000000] = fac:NetIncomeLossAttributableToParent[4902000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[5018000000] = fac:NetIncomeLossAttributableToParent[5018000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[5200000000] = fac:NetIncomeLossAttributableToParent[5200000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[6513000000] = fac:NetIncomeLossAttributableToParent[6513000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[12193000000] = fac:NetIncomeLossAttributableToParent[12193000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[16798000000] = fac:NetIncomeLossAttributableToParent[16798000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

fac:NetIncomeLossAvailableToCommonStockholdersBasic[21204000000] = fac:NetIncomeLossAttributableToParent[21204000000] + - fac:PreferredStockDividendsAndOtherAdjustments[0]

calculationfac:NetIncomeLoss (in NetIncomeLossBreakdown)
  • derived:0
  • ok:11
  • failed:0
 

total=NetIncomeLossAttributableToParent_2+NetIncomeLossAttributableToNoncontrollingInterest_1

11 instances:

fac:NetIncomeLoss[3122000000] = fac:NetIncomeLossAttributableToParent[3122000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[3756000000] = fac:NetIncomeLossAttributableToParent[3756000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[4690000000] = fac:NetIncomeLossAttributableToParent[4690000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[4801000000] = fac:NetIncomeLossAttributableToParent[4801000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[4902000000] = fac:NetIncomeLossAttributableToParent[4902000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[5018000000] = fac:NetIncomeLossAttributableToParent[5018000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[5200000000] = fac:NetIncomeLossAttributableToParent[5200000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[6513000000] = fac:NetIncomeLossAttributableToParent[6513000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[12193000000] = fac:NetIncomeLossAttributableToParent[12193000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[16798000000] = fac:NetIncomeLossAttributableToParent[16798000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

fac:NetIncomeLoss[21204000000] = fac:NetIncomeLossAttributableToParent[21204000000] + fac:NetIncomeLossAttributableToNoncontrollingInterest[0]

calculationfac:ComprehensiveIncomeLoss (in StatementOfComprehensiveIncome)
  • derived:0
  • ok:11
  • failed:0
 

total=NetIncomeLoss_2+OtherComprehensiveIncomeLoss_1

11 instances:

fac:ComprehensiveIncomeLoss[11007000000] = fac:NetIncomeLoss[12193000000] + fac:OtherComprehensiveIncomeLoss[-1186000000]

fac:ComprehensiveIncomeLoss[15813000000] = fac:NetIncomeLoss[16798000000] + fac:OtherComprehensiveIncomeLoss[-985000000]

fac:ComprehensiveIncomeLoss[20098000000] = fac:NetIncomeLoss[21204000000] + fac:OtherComprehensiveIncomeLoss[-1106000000]

fac:ComprehensiveIncomeLoss[3122000000] = fac:NetIncomeLoss[3122000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[3756000000] = fac:NetIncomeLoss[3756000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[4690000000] = fac:NetIncomeLoss[4690000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[4801000000] = fac:NetIncomeLoss[4801000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[4902000000] = fac:NetIncomeLoss[4902000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[5018000000] = fac:NetIncomeLoss[5018000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[5200000000] = fac:NetIncomeLoss[5200000000] + fac:OtherComprehensiveIncomeLoss[0]

fac:ComprehensiveIncomeLoss[6513000000] = fac:NetIncomeLoss[6513000000] + fac:OtherComprehensiveIncomeLoss[0]

calculationbase:WeightedAverageNumberOfDilutedSharesOutstanding (in DisclosureBasicAndDilutedEarningsPerShareDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=WeightedAverageNumberOfSharesOutstandingBasic_2+IncrementalCommonSharesAttributableToShareBasedPaymentArrangements_1

3 instances:

base:WeightedAverageNumberOfDilutedSharesOutstanding[7832000000] = base:WeightedAverageNumberOfSharesOutstandingBasic[7746000000] + base:IncrementalCommonSharesAttributableToShareBasedPaymentArrangements[86000000]

base:WeightedAverageNumberOfDilutedSharesOutstanding[8013000000] = base:WeightedAverageNumberOfSharesOutstandingBasic[7925000000] + base:IncrementalCommonSharesAttributableToShareBasedPaymentArrangements[88000000]

base:WeightedAverageNumberOfDilutedSharesOutstanding[8254000000] = base:WeightedAverageNumberOfSharesOutstandingBasic[8177000000] + base:IncrementalCommonSharesAttributableToShareBasedPaymentArrangements[77000000]

calculationbase:InventoryNet (in DisclosureComponentsOfInventoriesDetail)
  • derived:0
  • ok:2
  • failed:0
 

total=InventoryRawMaterialsNetOfReserves_3+(InventoryWorkInProcessNetOfReserves_2+InventoryFinishedGoodsNetOfReserves_1)

2 instances:

base:InventoryNet[2181000000] = base:InventoryRawMaterialsNetOfReserves[797000000] + base:InventoryWorkInProcessNetOfReserves[145000000] + base:InventoryFinishedGoodsNetOfReserves[1239000000]

base:InventoryNet[2251000000] = base:InventoryRawMaterialsNetOfReserves[612000000] + base:InventoryWorkInProcessNetOfReserves[158000000] + base:InventoryFinishedGoodsNetOfReserves[1481000000]

calculationbase:NonoperatingIncomeExpense (in DisclosureComponentsOfOtherIncomeExpenseNetDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=InvestmentIncomeNet_6+(-InterestExpense_5+(GainLossOnInvestments_4+(GainLossOnDerivativeInstrumentsNetPretax_3+(ForeignCurrencyTransactionGainLossBeforeTax_2+OtherNonoperatingIncomeExpense_1))))

3 instances:

base:NonoperatingIncomeExpense[823000000] = base:InvestmentIncomeNet[1387000000] + - base:InterestExpense[2222000000] + base:GainLossOnInvestments[2583000000] + base:GainLossOnDerivativeInstrumentsNetPretax[-510000000] + base:ForeignCurrencyTransactionGainLossBeforeTax[-164000000] + base:OtherNonoperatingIncomeExpense[-251000000]

base:NonoperatingIncomeExpense[-431000000] = base:InvestmentIncomeNet[903000000] + - base:InterestExpense[1243000000] + base:GainLossOnInvestments[668000000] + base:GainLossOnDerivativeInstrumentsNetPretax[-443000000] + base:ForeignCurrencyTransactionGainLossBeforeTax[-121000000] + base:OtherNonoperatingIncomeExpense[-195000000]

base:NonoperatingIncomeExpense[346000000] = base:InvestmentIncomeNet[766000000] + - base:InterestExpense[781000000] + base:GainLossOnInvestments[716000000] + base:GainLossOnDerivativeInstrumentsNetPretax[-423000000] + base:ForeignCurrencyTransactionGainLossBeforeTax[335000000] + base:OtherNonoperatingIncomeExpense[-267000000]

calculationbase:PropertyPlantAndEquipmentGross (in DisclosureComponentsOfPropertyAndEquipmentDetail)
  • derived:0
  • ok:2
  • failed:0
 

total=Land_5+(BuildingsAndImprovementsGross_4+(LeaseholdImprovementsGross_3+(ComputerHardwareAndSoftware_2+FurnitureAndFixturesGross_1)))

2 instances:

base:PropertyPlantAndEquipmentGross[47913000000] = base:Land[1107000000] + base:BuildingsAndImprovementsGross[16284000000] + base:LeaseholdImprovementsGross[5064000000] + msft:ComputerHardwareAndSoftware[21414000000] + base:FurnitureAndFixturesGross[4044000000]

base:PropertyPlantAndEquipmentGross[38156000000] = base:Land[824000000] + base:BuildingsAndImprovementsGross[12393000000] + base:LeaseholdImprovementsGross[3659000000] + msft:ComputerHardwareAndSoftware[17391000000] + base:FurnitureAndFixturesGross[3889000000]

calculationbase:PropertyPlantAndEquipmentNet (in DisclosureComponentsOfPropertyAndEquipmentDetail)
  • derived:0
  • ok:2
  • failed:0
 

total=PropertyPlantAndEquipmentGross_2+ -AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment_1

2 instances:

base:PropertyPlantAndEquipmentNet[23734000000] = base:PropertyPlantAndEquipmentGross[47913000000] + - base:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment[24179000000]

base:PropertyPlantAndEquipmentNet[18356000000] = base:PropertyPlantAndEquipmentGross[38156000000] + - base:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment[19800000000]

calculationbase:AvailableForSaleDebtSecuritiesAmortizedCostBasis (in DisclosureDebtInvestmentMaturitiesDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=AvailableForSaleSecuritiesDebtMaturitiesNextRollingTwelveMonthsAmortizedCostBasis_4+(AvailableForSaleSecuritiesDebtMaturitiesRollingYearTwoThroughFiveAmortizedCostBasis_3+(AvailableForSaleSecuritiesDebtMaturitiesRollingYearSixThroughTenAmortizedCostBasis_2+AvailableForSaleSecuritiesDebtMaturitiesRollingAfterYearTenAmortizedCostBasis_1))

1 instance:

base:AvailableForSaleDebtSecuritiesAmortizedCostBasis[128063000000] = base:AvailableForSaleSecuritiesDebtMaturitiesNextRollingTwelveMonthsAmortizedCostBasis[18212000000] + base:AvailableForSaleSecuritiesDebtMaturitiesRollingYearTwoThroughFiveAmortizedCostBasis[102374000000] + base:AvailableForSaleSecuritiesDebtMaturitiesRollingYearSixThroughTenAmortizedCostBasis[6478000000] + base:AvailableForSaleSecuritiesDebtMaturitiesRollingAfterYearTenAmortizedCostBasis[999000000]

calculationbase:AvailableForSaleSecuritiesDebtSecurities (in DisclosureDebtInvestmentMaturitiesDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=AvailableForSaleSecuritiesDebtMaturitiesNextRollingTwelveMonthsFairValue_4+(AvailableForSaleSecuritiesDebtMaturitiesRollingYearTwoThroughFiveFairValue_3+(AvailableForSaleSecuritiesDebtMaturitiesRollingYearSixThroughTenFairValue_2+AvailableForSaleSecuritiesDebtMaturitiesRollingAfterYearTenFairValue_1))

1 instance:

base:AvailableForSaleSecuritiesDebtSecurities[127879000000] = base:AvailableForSaleSecuritiesDebtMaturitiesNextRollingTwelveMonthsFairValue[18188000000] + base:AvailableForSaleSecuritiesDebtMaturitiesRollingYearTwoThroughFiveFairValue[102168000000] + base:AvailableForSaleSecuritiesDebtMaturitiesRollingYearSixThroughTenFairValue[6504000000] + base:AvailableForSaleSecuritiesDebtMaturitiesRollingAfterYearTenFairValue[1019000000]

calculationbase:DeferredIncomeTaxLiabilities (in DisclosureDeferredIncomeTaxAssetsAndLiabilitiesDetail)
  • derived:0
  • ok:2
  • failed:0
 

total=DeferredTaxLiabilitiesUndistributedForeignEarnings_4+(DeferredTaxLiabilitiesUnrealizedGainsInvestmentsAndDebt_3+(DeferredTaxLiabilitiesDepreciationAndAmortization_2+DeferredTaxLiabilitiesOther_1))

2 instances:

base:DeferredIncomeTaxLiabilities[4142000000] = base:DeferredTaxLiabilitiesUndistributedForeignEarnings[1107000000] + msft:DeferredTaxLiabilitiesUnrealizedGainsInvestmentsAndDebt[1384000000] + msft:DeferredTaxLiabilitiesDepreciationAndAmortization[1630000000] + base:DeferredTaxLiabilitiesOther[21000000]

base:DeferredIncomeTaxLiabilities[4406000000] = base:DeferredTaxLiabilitiesUndistributedForeignEarnings[1242000000] + msft:DeferredTaxLiabilitiesUnrealizedGainsInvestmentsAndDebt[2102000000] + msft:DeferredTaxLiabilitiesDepreciationAndAmortization[1008000000] + base:DeferredTaxLiabilitiesOther[54000000]

calculationbase:DeferredTaxAssetsGross (in DisclosureDeferredIncomeTaxAssetsAndLiabilitiesDetail)
  • derived:0
  • ok:2
  • failed:0
 

total=DeferredTaxAssetsTaxDeferredExpenseCompensationAndBenefitsShareBasedCompensationCost_8+(DeferredTaxAssetsTaxDeferredExpenseOther_7+(DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsRestructuringCharges_6+(DeferredTaxAssetsDeferredIncome_5+(DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsImpairmentLosses_4+(DeferredTaxAssetsOperatingLossCarryforwards_3+(DeferredTaxAssetsDepreciationAndAmortization_2+DeferredTaxAssetsOther_1))))))

2 instances:

base:DeferredTaxAssetsGross[9333000000] = base:DeferredTaxAssetsTaxDeferredExpenseCompensationAndBenefitsShareBasedCompensationCost[777000000] + base:DeferredTaxAssetsTaxDeferredExpenseOther[1550000000] + base:DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsRestructuringCharges[66000000] + base:DeferredTaxAssetsDeferredIncome[1889000000] + base:DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsImpairmentLosses[59000000] + base:DeferredTaxAssetsOperatingLossCarryforwards[4809000000] + msft:DeferredTaxAssetsDepreciationAndAmortization[53000000] + base:DeferredTaxAssetsOther[130000000]

base:DeferredTaxAssetsGross[7878000000] = base:DeferredTaxAssetsTaxDeferredExpenseCompensationAndBenefitsShareBasedCompensationCost[809000000] + base:DeferredTaxAssetsTaxDeferredExpenseOther[1609000000] + base:DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsRestructuringCharges[284000000] + base:DeferredTaxAssetsDeferredIncome[494000000] + base:DeferredTaxAssetsTaxDeferredExpenseReservesAndAccrualsImpairmentLosses[226000000] + base:DeferredTaxAssetsOperatingLossCarryforwards[4252000000] + msft:DeferredTaxAssetsDepreciationAndAmortization[115000000] + base:DeferredTaxAssetsOther[89000000]

calculationbase:DeferredTaxAssetsLiabilitiesNet (in DisclosureDeferredIncomeTaxAssetsAndLiabilitiesDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=DeferredTaxAssetsNet_2+ -DeferredIncomeTaxLiabilities_1

1 instance:

base:DeferredTaxAssetsLiabilitiesNet[1881000000] = base:DeferredTaxAssetsNet[6023000000] + - base:DeferredIncomeTaxLiabilities[4142000000]

calculationbase:DeferredTaxAssetsNet (in DisclosureDeferredIncomeTaxAssetsAndLiabilitiesDetail)
  • derived:0
  • ok:2
  • failed:0
 

total=DeferredTaxAssetsGross_2+ -DeferredTaxAssetsValuationAllowance_1

2 instances:

base:DeferredTaxAssetsNet[6023000000] = base:DeferredTaxAssetsGross[9333000000] + - base:DeferredTaxAssetsValuationAllowance[3310000000]

base:DeferredTaxAssetsNet[3149000000] = base:DeferredTaxAssetsGross[7878000000] + - base:DeferredTaxAssetsValuationAllowance[4729000000]

calculationbase:DeferredTaxLiabilities (in DisclosureDeferredIncomeTaxAssetsAndLiabilitiesDetail)
  • derived:0
  • ok:1
  • failed:0
 

total= -DeferredTaxAssetsNet_2+DeferredIncomeTaxLiabilities_1

1 instance:

base:DeferredTaxLiabilities[1257000000] = - base:DeferredTaxAssetsNet[3149000000] + base:DeferredIncomeTaxLiabilities[4406000000]

calculationbase:EffectiveIncomeTaxRateContinuingOperations (in DisclosureDifferenceBetweenIncomeTaxesComputedAtFederalStatutoryRateAndProvisionForIncomeTaxesDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=EffectiveIncomeTaxRateReconciliationAtFederalStatutoryIncomeTaxRate_7+(EffectiveIncomeTaxRateReconciliationForeignIncomeTaxRateDifferential_6+(EffectiveIncomeTaxRateReconciliationPhoneBusinessGainsLosses_5+(-EffectiveIncomeTaxRateReconciliationDeductionsExcessTaxBenefitsStockBasedCompensation_4+(-EffectiveIncomeTaxRateReconciliationDeductionsQualifiedProductionActivities_3+(EffectiveIncomeTaxRateReconciliationInterestIncomeExpense_2+EffectiveIncomeTaxRateReconciliationOtherAdjustments_1)))))

3 instances:

base:EffectiveIncomeTaxRateContinuingOperations[0.084] = base:EffectiveIncomeTaxRateReconciliationAtFederalStatutoryIncomeTaxRate[0.35] + base:EffectiveIncomeTaxRateReconciliationForeignIncomeTaxRateDifferential[-0.157] + msft:EffectiveIncomeTaxRateReconciliationPhoneBusinessGainsLosses[-0.073] + - msft:EffectiveIncomeTaxRateReconciliationDeductionsExcessTaxBenefitsStockBasedCompensation[0.027] + - base:EffectiveIncomeTaxRateReconciliationDeductionsQualifiedProductionActivities[0.014] + msft:EffectiveIncomeTaxRateReconciliationInterestIncomeExpense[0.018] + base:EffectiveIncomeTaxRateReconciliationOtherAdjustments[-0.013]

base:EffectiveIncomeTaxRateContinuingOperations[0.15] = base:EffectiveIncomeTaxRateReconciliationAtFederalStatutoryIncomeTaxRate[0.35] + base:EffectiveIncomeTaxRateReconciliationForeignIncomeTaxRateDifferential[-0.194] + msft:EffectiveIncomeTaxRateReconciliationPhoneBusinessGainsLosses[0.013] + - msft:EffectiveIncomeTaxRateReconciliationDeductionsExcessTaxBenefitsStockBasedCompensation[0.02] + - base:EffectiveIncomeTaxRateReconciliationDeductionsQualifiedProductionActivities[0.006] + msft:EffectiveIncomeTaxRateReconciliationInterestIncomeExpense[0.012] + base:EffectiveIncomeTaxRateReconciliationOtherAdjustments[-0.005]

base:EffectiveIncomeTaxRateContinuingOperations[0.341] = base:EffectiveIncomeTaxRateReconciliationAtFederalStatutoryIncomeTaxRate[0.35] + base:EffectiveIncomeTaxRateReconciliationForeignIncomeTaxRateDifferential[-0.209] + msft:EffectiveIncomeTaxRateReconciliationPhoneBusinessGainsLosses[0.191] + - msft:EffectiveIncomeTaxRateReconciliationDeductionsExcessTaxBenefitsStockBasedCompensation[0.0] + - base:EffectiveIncomeTaxRateReconciliationDeductionsQualifiedProductionActivities[0.024] + msft:EffectiveIncomeTaxRateReconciliationInterestIncomeExpense[0.015] + base:EffectiveIncomeTaxRateReconciliationOtherAdjustments[0.018]

calculationbase:FiniteLivedIntangibleAssetsNet (in DisclosureEstimatedFutureAmortizationExpenseRelatedToIntangibleAssetsDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=FiniteLivedIntangibleAssetsAmortizationExpenseNextTwelveMonths_6+(FiniteLivedIntangibleAssetsAmortizationExpenseYearTwo_5+(FiniteLivedIntangibleAssetsAmortizationExpenseYearThree_4+(FiniteLivedIntangibleAssetsAmortizationExpenseYearFour_3+(FiniteLivedIntangibleAssetsAmortizationExpenseYearFive_2+FiniteLivedIntangibleAssetsAmortizationExpenseAfterYearFive_1))))

1 instance:

base:FiniteLivedIntangibleAssetsNet[10106000000] = base:FiniteLivedIntangibleAssetsAmortizationExpenseNextTwelveMonths[2190000000] + base:FiniteLivedIntangibleAssetsAmortizationExpenseYearTwo[1698000000] + base:FiniteLivedIntangibleAssetsAmortizationExpenseYearThree[1180000000] + base:FiniteLivedIntangibleAssetsAmortizationExpenseYearFour[1006000000] + base:FiniteLivedIntangibleAssetsAmortizationExpenseYearFive[932000000] + base:FiniteLivedIntangibleAssetsAmortizationExpenseAfterYearFive[3100000000]

calculationmsft:DerivativeAssetsNetAmountsPresentedInBalanceSheet (in DisclosureFairValuesOfDerivativeInstrumentsDetail)
  • derived:0
  • ok:7
  • failed:0
 

total=DerivativeFairValueOfDerivativeAsset_2+ -DerivativeAssetFairValueGrossLiability_1

7 instances:

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[80000000] = base:DerivativeFairValueOfDerivativeAsset[100000000] + - base:DerivativeAssetFairValueGrossLiability[20000000]

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[204000000] = base:DerivativeFairValueOfDerivativeAsset[336000000] + - base:DerivativeAssetFairValueGrossLiability[132000000]

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[0] = base:DerivativeFairValueOfDerivativeAsset[67000000] + - base:DerivativeAssetFairValueGrossLiability[67000000]

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[-2000000] = base:DerivativeFairValueOfDerivativeAsset[6000000] + - base:DerivativeAssetFairValueGrossLiability[8000000]

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[-5000000] = base:DerivativeFairValueOfDerivativeAsset[69000000] + - base:DerivativeAssetFairValueGrossLiability[74000000]

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[246000000] = base:DerivativeFairValueOfDerivativeAsset[548000000] + - base:DerivativeAssetFairValueGrossLiability[302000000]

msft:DerivativeAssetsNetAmountsPresentedInBalanceSheet[-7000000] = base:DerivativeFairValueOfDerivativeAsset[18000000] + - base:DerivativeAssetFairValueGrossLiability[25000000]

calculationmsft:DerivativeAssetsPotentialNetAmountsNotPresentedInBalanceSheet (in DisclosureFairValuesOfDerivativeInstrumentsDetail)
  • derived:0
  • ok:0
  • failed:0
 

total=DerivativeAssetsNetAmountsPresentedInBalanceSheet_3+(DerivativeFairValueOfDerivativeAssetAmountNotOffset_2+DerivativeCollateralRightToReclaimCash_1)

0 instance:

calculationmsft:DerivativeLiabilitiesNetAmountsPresentedInBalanceSheet (in DisclosureFairValuesOfDerivativeInstrumentsDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=DerivativeFairValueOfDerivativeLiability_2+ -DerivativeLiabilityFairValueGrossAsset_1

3 instances:

msft:DerivativeLiabilitiesNetAmountsPresentedInBalanceSheet[113000000] = base:DerivativeFairValueOfDerivativeLiability[334000000] + - base:DerivativeLiabilityFairValueGrossAsset[221000000]

msft:DerivativeLiabilitiesNetAmountsPresentedInBalanceSheet[1000000] = base:DerivativeFairValueOfDerivativeLiability[8000000] + - base:DerivativeLiabilityFairValueGrossAsset[7000000]

msft:DerivativeLiabilitiesNetAmountsPresentedInBalanceSheet[232000000] = base:DerivativeFairValueOfDerivativeLiability[630000000] + - base:DerivativeLiabilityFairValueGrossAsset[398000000]

calculationmsft:DerivativeLiabilitiesPotentialNetAmountsNotPresentedInBalanceSheet (in DisclosureFairValuesOfDerivativeInstrumentsDetail)
  • derived:0
  • ok:0
  • failed:0
 

total=DerivativeLiabilitiesNetAmountsPresentedInBalanceSheet_3+(DerivativeFairValueOfDerivativeLiabilityAmountNotOffset_2+DerivativeCollateralObligationToReturnCash_1)

0 instance:

calculationbase:FiniteLivedIntangibleAssetsNet (in DisclosureFiniteLivedIntangibleAssetsDetail)
  • derived:0
  • ok:10
  • failed:0
 

total=FiniteLivedIntangibleAssetsGross_2+ -FiniteLivedIntangibleAssetsAccumulatedAmortization_1

10 instances:

base:FiniteLivedIntangibleAssetsNet[10106000000] = base:FiniteLivedIntangibleAssetsGross[16667000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[6561000000]

base:FiniteLivedIntangibleAssetsNet[3733000000] = base:FiniteLivedIntangibleAssetsGross[9100000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[5367000000]

base:FiniteLivedIntangibleAssetsNet[3447000000] = base:FiniteLivedIntangibleAssetsGross[7765000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[4318000000]

base:FiniteLivedIntangibleAssetsNet[3187000000] = base:FiniteLivedIntangibleAssetsGross[4016000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[829000000]

base:FiniteLivedIntangibleAssetsNet[119000000] = base:FiniteLivedIntangibleAssetsGross[841000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[722000000]

base:FiniteLivedIntangibleAssetsNet[3353000000] = base:FiniteLivedIntangibleAssetsGross[4045000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[692000000]

base:FiniteLivedIntangibleAssetsNet[2322000000] = base:FiniteLivedIntangibleAssetsGross[5970000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[3648000000]

base:FiniteLivedIntangibleAssetsNet[1253000000] = base:FiniteLivedIntangibleAssetsGross[1869000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[616000000]

base:FiniteLivedIntangibleAssetsNet[78000000] = base:FiniteLivedIntangibleAssetsGross[796000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[718000000]

base:FiniteLivedIntangibleAssetsNet[80000000] = base:FiniteLivedIntangibleAssetsGross[465000000] + - base:FiniteLivedIntangibleAssetsAccumulatedAmortization[385000000]

calculationbase:CapitalLeasesFutureMinimumPaymentsDue (in DisclosureFutureMinimumLeasePaymentsUnderNonCancellableCapitalLeasesDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=CapitalLeasesFutureMinimumPaymentsDueCurrent_6+(CapitalLeasesFutureMinimumPaymentsDueInTwoYears_5+(CapitalLeasesFutureMinimumPaymentsDueInThreeYears_4+(CapitalLeasesFutureMinimumPaymentsDueInFourYears_3+(CapitalLeasesFutureMinimumPaymentsDueInFiveYears_2+CapitalLeasesFutureMinimumPaymentsDueThereafter_1))))

1 instance:

base:CapitalLeasesFutureMinimumPaymentsDue[3460000000] = base:CapitalLeasesFutureMinimumPaymentsDueCurrent[209000000] + base:CapitalLeasesFutureMinimumPaymentsDueInTwoYears[217000000] + base:CapitalLeasesFutureMinimumPaymentsDueInThreeYears[222000000] + base:CapitalLeasesFutureMinimumPaymentsDueInFourYears[227000000] + base:CapitalLeasesFutureMinimumPaymentsDueInFiveYears[232000000] + base:CapitalLeasesFutureMinimumPaymentsDueThereafter[2353000000]

calculationbase:OperatingLeasesFutureMinimumPaymentsDue (in DisclosureFutureMinimumRentalCommitmentsUnderNonCancellableOperatingLeasesDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=OperatingLeasesFutureMinimumPaymentsDueCurrent_6+(OperatingLeasesFutureMinimumPaymentsDueInTwoYears_5+(OperatingLeasesFutureMinimumPaymentsDueInThreeYears_4+(OperatingLeasesFutureMinimumPaymentsDueInFourYears_3+(OperatingLeasesFutureMinimumPaymentsDueInFiveYears_2+OperatingLeasesFutureMinimumPaymentsDueThereafter_1))))

1 instance:

base:OperatingLeasesFutureMinimumPaymentsDue[7872000000] = base:OperatingLeasesFutureMinimumPaymentsDueCurrent[1292000000] + base:OperatingLeasesFutureMinimumPaymentsDueInTwoYears[1220000000] + base:OperatingLeasesFutureMinimumPaymentsDueInThreeYears[1115000000] + base:OperatingLeasesFutureMinimumPaymentsDueInFourYears[908000000] + base:OperatingLeasesFutureMinimumPaymentsDueInFiveYears[749000000] + base:OperatingLeasesFutureMinimumPaymentsDueThereafter[2588000000]

calculationbase:GainLossOnFairValueHedgeIneffectivenessNet (in DisclosureGainsLossesOnFairValueHedgesAndRelatedHedgedItemsDetail)
  • derived:0
  • ok:6
  • failed:0
 

total=ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1_2+ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1_1

6 instances:

base:GainLossOnFairValueHedgeIneffectivenessNet[55000000] = base:ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1[441000000] + base:ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1[-386000000]

base:GainLossOnFairValueHedgeIneffectivenessNet[41000000] = base:ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1[-797000000] + base:ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1[838000000]

base:GainLossOnFairValueHedgeIneffectivenessNet[16000000] = base:ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1[741000000] + base:ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1[-725000000]

base:GainLossOnFairValueHedgeIneffectivenessNet[0] = base:ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1[-74000000] + base:ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1[74000000]

base:GainLossOnFairValueHedgeIneffectivenessNet[0] = base:ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1[-76000000] + base:ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1[76000000]

base:GainLossOnFairValueHedgeIneffectivenessNet[0] = base:ChangeInUnrealizedGainLossOnFairValueHedgingInstruments1[-107000000] + base:ChangeInUnrealizedGainLossOnHedgedItemInFairValueHedge1[107000000]

calculationbase:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments (in DisclosureIncomeLossBeforeIncomeTaxesDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=IncomeLossFromContinuingOperationsBeforeIncomeTaxesDomestic_2+IncomeLossFromContinuingOperationsBeforeIncomeTaxesForeign_1

3 instances:

base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[23149000000] = base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesDomestic[453000000] + base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesForeign[22696000000]

base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[19751000000] = base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesDomestic[-325000000] + base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesForeign[20076000000]

base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[18507000000] = base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesDomestic[7363000000] + base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesForeign[11144000000]

calculationbase:AvailableForSaleSecuritiesAmortizedCost (in DisclosureInvestmentComponentsIncludingAssociatedDerivativesDetail)
  • derived:0
  • ok:20
  • failed:0
 

total= -AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax_3+(AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax_2+AvailableForSaleSecurities_1)

20 instances:

base:AvailableForSaleSecuritiesAmortizedCost[1478000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[1478000000]

base:AvailableForSaleSecuritiesAmortizedCost[319000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[319000000]

base:AvailableForSaleSecuritiesAmortizedCost[1358000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[1358000000]

base:AvailableForSaleSecuritiesAmortizedCost[112119000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[85000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[360000000] + base:AvailableForSaleSecurities[111844000000]

base:AvailableForSaleSecuritiesAmortizedCost[5276000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[2000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[13000000] + base:AvailableForSaleSecurities[5265000000]

base:AvailableForSaleSecuritiesAmortizedCost[3921000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[14000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[4000000] + base:AvailableForSaleSecurities[3931000000]

base:AvailableForSaleSecuritiesAmortizedCost[4786000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[61000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[12000000] + base:AvailableForSaleSecurities[4835000000]

base:AvailableForSaleSecuritiesAmortizedCost[284000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[43000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[327000000]

base:AvailableForSaleSecuritiesAmortizedCost[2472000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[3062000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[34000000] + base:AvailableForSaleSecurities[5500000000]

base:AvailableForSaleSecuritiesAmortizedCost[136160000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[3267000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[423000000] + base:AvailableForSaleSecurities[139004000000]

base:AvailableForSaleSecuritiesAmortizedCost[1012000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[1012000000]

base:AvailableForSaleSecuritiesAmortizedCost[298000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[298000000]

base:AvailableForSaleSecuritiesAmortizedCost[1000000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[1000000000]

base:AvailableForSaleSecuritiesAmortizedCost[89970000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[245000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[11000000] + base:AvailableForSaleSecurities[90204000000]

base:AvailableForSaleSecuritiesAmortizedCost[5502000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[10000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[18000000] + base:AvailableForSaleSecurities[5494000000]

base:AvailableForSaleSecuritiesAmortizedCost[4789000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[21000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[2000000] + base:AvailableForSaleSecurities[4808000000]

base:AvailableForSaleSecuritiesAmortizedCost[6509000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[110000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[35000000] + base:AvailableForSaleSecurities[6584000000]

base:AvailableForSaleSecuritiesAmortizedCost[285000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[57000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:AvailableForSaleSecurities[342000000]

base:AvailableForSaleSecuritiesAmortizedCost[5597000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[4452000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[236000000] + base:AvailableForSaleSecurities[9813000000]

base:AvailableForSaleSecuritiesAmortizedCost[119078000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[4895000000] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[302000000] + base:AvailableForSaleSecurities[123671000000]

calculationbase:EquityMethodInvestmentAggregateCost (in DisclosureInvestmentComponentsIncludingAssociatedDerivativesDetail)
  • derived:0
  • ok:2
  • failed:0
 

total= -AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax_3+(AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax_2+EquityMethodInvestments_1)

2 instances:

base:EquityMethodInvestmentAggregateCost[523000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:EquityMethodInvestments[523000000]

base:EquityMethodInvestmentAggregateCost[615000000] = - base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedGainBeforeTax[0] + base:AvailableForSaleSecuritiesAccumulatedGrossUnrealizedLossBeforeTax[0] + base:EquityMethodInvestments[615000000]

calculationbase:BusinessCombinationRecognizedIdentifiableAssetsAcquiredGoodwillAndLiabilitiesAssumedNet (in DisclosureMajorClassesOfAssetsAndLiabilitiesToWhichWeAllocatedPurchasePriceDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCashAndEquivalents_10+(BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentAssetsMarketableSecurities_9+(BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentAssetsOther_8+(BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedPropertyPlantAndEquipment_7+(BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedIntangibles_6+(Goodwill_5+(-BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentLiabilitiesShortTermDebt_4+(-BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentLiabilitiesOther_3+(-BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedDeferredTaxLiabilitiesNoncurrent_2+ -BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedOtherLiabilitiesNet_1))))))))

1 instance:

base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredGoodwillAndLiabilitiesAssumedNet[27009000000] = base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCashAndEquivalents[1328000000] + base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentAssetsMarketableSecurities[2110000000] + base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentAssetsOther[697000000] + base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedPropertyPlantAndEquipment[1529000000] + base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedIntangibles[7887000000] + base:Goodwill[16803000000] + - msft:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentLiabilitiesShortTermDebt[1323000000] + - base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedCurrentLiabilitiesOther[1117000000] + - base:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedDeferredTaxLiabilitiesNoncurrent[774000000] + - msft:BusinessCombinationRecognizedIdentifiableAssetsAcquiredAndLiabilitiesAssumedOtherLiabilitiesNet[131000000]

calculationbase:DebtInstrumentFaceAmount (in DisclosureMaturitiesOfLongTermDebtDetail)
  • derived:0
  • ok:1
  • failed:0
 

total=LongTermDebtMaturitiesRepaymentsOfPrincipalInNextTwelveMonths_6+(LongTermDebtMaturitiesRepaymentsOfPrincipalInYearTwo_5+(LongTermDebtMaturitiesRepaymentsOfPrincipalInYearThree_4+(LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFour_3+(LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFive_2+LongTermDebtMaturitiesRepaymentsOfPrincipalAfterYearFive_1))))

1 instance:

base:DebtInstrumentFaceAmount[77837000000] = base:LongTermDebtMaturitiesRepaymentsOfPrincipalInNextTwelveMonths[1050000000] + base:LongTermDebtMaturitiesRepaymentsOfPrincipalInYearTwo[4000000000] + base:LongTermDebtMaturitiesRepaymentsOfPrincipalInYearThree[5518000000] + base:LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFour[3750000000] + base:LongTermDebtMaturitiesRepaymentsOfPrincipalInYearFive[7996000000] + base:LongTermDebtMaturitiesRepaymentsOfPrincipalAfterYearFive[55523000000]

calculationbase:GainLossOnInvestments (in DisclosureNetRecognizedGainsLossesOnInvestmentsDetail)
  • derived:0
  • ok:3
  • failed:0
 

total= -MarketableSecuritiesRealizedGainLossOtherThanTemporaryImpairmentsAmount_3+(AvailableForSaleSecuritiesGrossRealizedGains_2+ -AvailableForSaleSecuritiesGrossRealizedLosses_1)

3 instances:

base:GainLossOnInvestments[2583000000] = - base:MarketableSecuritiesRealizedGainLossOtherThanTemporaryImpairmentsAmount[55000000] + base:AvailableForSaleSecuritiesGrossRealizedGains[3064000000] + - base:AvailableForSaleSecuritiesGrossRealizedLosses[426000000]

base:GainLossOnInvestments[668000000] = - base:MarketableSecuritiesRealizedGainLossOtherThanTemporaryImpairmentsAmount[322000000] + base:AvailableForSaleSecuritiesGrossRealizedGains[1376000000] + - base:AvailableForSaleSecuritiesGrossRealizedLosses[386000000]

base:GainLossOnInvestments[716000000] = - base:MarketableSecuritiesRealizedGainLossOtherThanTemporaryImpairmentsAmount[183000000] + base:AvailableForSaleSecuritiesGrossRealizedGains[1176000000] + - base:AvailableForSaleSecuritiesGrossRealizedLosses[277000000]

calculationbase:CurrentIncomeTaxExpenseBenefit (in DisclosureProvisionForIncomeTaxesDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=CurrentFederalTaxExpenseBenefit_3+(CurrentStateAndLocalTaxExpenseBenefit_2+CurrentForeignTaxExpenseBenefit_1)

3 instances:

base:CurrentIncomeTaxExpenseBenefit[5241000000] = base:CurrentFederalTaxExpenseBenefit[2739000000] + base:CurrentStateAndLocalTaxExpenseBenefit[30000000] + base:CurrentForeignTaxExpenseBenefit[2472000000]

base:CurrentIncomeTaxExpenseBenefit[2621000000] = base:CurrentFederalTaxExpenseBenefit[545000000] + base:CurrentStateAndLocalTaxExpenseBenefit[136000000] + base:CurrentForeignTaxExpenseBenefit[1940000000]

base:CurrentIncomeTaxExpenseBenefit[6090000000] = base:CurrentFederalTaxExpenseBenefit[3661000000] + base:CurrentStateAndLocalTaxExpenseBenefit[364000000] + base:CurrentForeignTaxExpenseBenefit[2065000000]

calculationbase:IncomeTaxExpenseBenefit (in DisclosureProvisionForIncomeTaxesDetail)
  • derived:0
  • ok:3
  • failed:0
 

total=CurrentIncomeTaxExpenseBenefit_2+DeferredIncomeTaxExpenseBenefit_1

3 instances:

base:IncomeTaxExpenseBenefit[1945000000] = base:CurrentIncomeTaxExpenseBenefit[5241000000] + base:DeferredIncomeTaxExpenseBenefit[-3296000000]

base:IncomeTaxExpenseBenefit[2953000000] = base:CurrentIncomeTaxExpenseBenefit[2621000000] + base:DeferredIncomeTaxExpenseBenefit[332000000]

base:IncomeTaxExpenseBenefit[6314000000] = base:CurrentIncomeTaxExpenseBenefit[6090000000] + base:DeferredIncomeTaxExpenseBenefit[224000000]

calculationbase:AvailableForSaleSecurities (in DisclosureReconciliationOfTotalAssetsMeasuredAtFairValueOnRecurringBasisToBalanceSheetPresentationDetail)
  • derived:0
  • ok:0
  • failed:0
 

total=AssetsFairValueDisclosureRecurring_6+(Cash_5+(CostMethodInvestments_4+(EquityMethodInvestments_3+(DerivativeAssets_2+OtherAssetsFairValueDisclosure_1))))

0 instance:

calculationbase:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent (in DisclosureSummaryOfChangesInAccumulatedOtherComprehensiveIncomeByComponentDetail)
  • derived:0
  • ok:6
  • failed:0
 

total=OciBeforeReclassificationsNetOfTaxAttributableToParent_2+ -ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent_1

6 instances:

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-218000000] = base:OciBeforeReclassificationsNetOfTaxAttributableToParent[328000000] + - base:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent[546000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-238000000] = base:OciBeforeReclassificationsNetOfTaxAttributableToParent[351000000] + - base:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent[589000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[559000000] = base:OciBeforeReclassificationsNetOfTaxAttributableToParent[1152000000] + - base:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent[593000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1116000000] = base:OciBeforeReclassificationsNetOfTaxAttributableToParent[517000000] + - base:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent[1633000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-228000000] = base:OciBeforeReclassificationsNetOfTaxAttributableToParent[219000000] + - base:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent[447000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-362000000] = base:OciBeforeReclassificationsNetOfTaxAttributableToParent[110000000] + - base:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent[472000000]

calculationbase:ReclassificationFromAociCurrentPeriodNetOfTaxAttributableToParent (in DisclosureSummaryOfChangesInAccumulatedOtherComprehensiveIncomeByComponentDetail)
  • derived:0
  • ok:0
  • failed:0
 

total=ReclassificationFromAociCurrentPeriodBeforeTaxAttributableToParent_2+ -ReclassificationFromAociCurrentPeriodTax_1

0 instance:

calculationbase:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss (in DisclosureUnrealizedLossesOnInvestmentsDetail)
  • derived:0
  • ok:12
  • failed:0
 

total=AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss_2+AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss_1

12 instances:

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[360000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[348000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[12000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[13000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[2000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[11000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[4000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[3000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[1000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[12000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[8000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[4000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[34000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[6000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[28000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[423000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[367000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[56000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[11000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[3000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[8000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[18000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[3000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[15000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[2000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[1000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[1000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[35000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[11000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[24000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[236000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[147000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[89000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionAccumulatedLoss[302000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThan12MonthsAccumulatedLoss[165000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPosition12MonthsOrLongerAccumulatedLoss[137000000]

calculationbase:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue (in DisclosureUnrealizedLossesOnInvestmentsDetail)
  • derived:0
  • ok:12
  • failed:0
 

total=AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue_2+AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue_1

12 instances:

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[87929000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[87558000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[371000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[4029000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[4006000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[23000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[1266000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[1068000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[198000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[846000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[669000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[177000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[217000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[69000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[148000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[94287000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[93370000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[917000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[6248000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[5816000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[432000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[3487000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[3452000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[35000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[1166000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[844000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[322000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[1968000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[1180000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[788000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[1286000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[896000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[390000000]

base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionFairValue[14155000000] = base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionLessThanTwelveMonthsFairValue[12188000000] + base:AvailableForSaleSecuritiesContinuousUnrealizedLossPositionTwelveMonthsOrLongerFairValue[1967000000]

calculationbase:Assets (in StatementBALANCESHEETS)
  • derived:0
  • ok:2
  • failed:0
 

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

2 instances:

base:Assets[241086000000] = base:AssetsCurrent[159851000000] + base:PropertyPlantAndEquipmentNet[23734000000] + base:LongTermInvestments[6023000000] + base:Goodwill[35122000000] + base:FiniteLivedIntangibleAssetsNet[10106000000] + base:OtherAssetsNoncurrent[6250000000]

base:Assets[193468000000] = base:AssetsCurrent[139660000000] + base:PropertyPlantAndEquipmentNet[18356000000] + base:LongTermInvestments[10431000000] + base:Goodwill[17872000000] + base:FiniteLivedIntangibleAssetsNet[3733000000] + base:OtherAssetsNoncurrent[3416000000]

calculationbase:AssetsCurrent (in StatementBALANCESHEETS)
  • derived:0
  • ok:2
  • failed:0
 

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

2 instances:

base:AssetsCurrent[159851000000] = base:CashCashEquivalentsAndShortTermInvestments[132981000000] + base:AccountsReceivableNetCurrent[19792000000] + base:InventoryNet[2181000000] + base:OtherAssetsCurrent[4897000000]

base:AssetsCurrent[139660000000] = base:CashCashEquivalentsAndShortTermInvestments[113240000000] + base:AccountsReceivableNetCurrent[18277000000] + base:InventoryNet[2251000000] + base:OtherAssetsCurrent[5892000000]

calculationbase:CashCashEquivalentsAndShortTermInvestments (in StatementBALANCESHEETS)
  • derived:0
  • ok:2
  • failed:0
 

total=CashAndCashEquivalentsAtCarryingValue_2+AvailableForSaleSecuritiesCurrent_1

2 instances:

base:CashCashEquivalentsAndShortTermInvestments[132981000000] = base:CashAndCashEquivalentsAtCarryingValue[7663000000] + base:AvailableForSaleSecuritiesCurrent[125318000000]

base:CashCashEquivalentsAndShortTermInvestments[113240000000] = base:CashAndCashEquivalentsAtCarryingValue[6510000000] + base:AvailableForSaleSecuritiesCurrent[106730000000]

calculationbase:Liabilities (in StatementBALANCESHEETS)
  • derived:0
  • ok:2
  • failed:0
 

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

2 instances:

base:Liabilities[168692000000] = base:LiabilitiesCurrent[64527000000] + base:LongTermDebtNoncurrent[76073000000] + base:DeferredRevenueNoncurrent[10377000000] + base:DeferredTaxLiabilitiesNoncurrent[531000000] + base:OtherLiabilitiesNoncurrent[17184000000]

base:Liabilities[121471000000] = base:LiabilitiesCurrent[59357000000] + base:LongTermDebtNoncurrent[40557000000] + base:DeferredRevenueNoncurrent[6441000000] + base:DeferredTaxLiabilitiesNoncurrent[1476000000] + base:OtherLiabilitiesNoncurrent[13640000000]

calculationbase:LiabilitiesAndStockholdersEquity (in StatementBALANCESHEETS)
  • derived:0
  • ok:0
  • failed:0
 

total=Liabilities_3+(CommitmentsAndContingencies_2+StockholdersEquity_1)

0 instance:

calculationbase:LiabilitiesCurrent (in StatementBALANCESHEETS)
  • derived:0
  • ok:2
  • failed:0
 

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

2 instances:

base:LiabilitiesCurrent[64527000000] = base:AccountsPayableCurrent[7390000000] + base:ShortTermBorrowings[9072000000] + base:LongTermDebtCurrent[1049000000] + base:EmployeeRelatedLiabilitiesCurrent[5819000000] + base:AccruedIncomeTaxesCurrent[718000000] + base:DeferredRevenueCurrent[34102000000] + base:DepositsReceivedForSecuritiesLoanedAtCarryingValue[97000000] + base:OtherLiabilitiesCurrent[6280000000]

base:LiabilitiesCurrent[59357000000] = base:AccountsPayableCurrent[6898000000] + base:ShortTermBorrowings[12904000000] + base:LongTermDebtCurrent[0] + base:EmployeeRelatedLiabilitiesCurrent[5264000000] + base:AccruedIncomeTaxesCurrent[580000000] + base:DeferredRevenueCurrent[27468000000] + base:DepositsReceivedForSecuritiesLoanedAtCarryingValue[294000000] + base:OtherLiabilitiesCurrent[5949000000]

calculationbase:StockholdersEquity (in StatementBALANCESHEETS)
  • derived:0
  • ok:2
  • failed:0
 

total=CommonStocksIncludingAdditionalPaidInCapital_3+(RetainedEarningsAccumulatedDeficit_2+AccumulatedOtherComprehensiveIncomeLossNetOfTax_1)

2 instances:

base:StockholdersEquity[72394000000] = base:CommonStocksIncludingAdditionalPaidInCapital[69315000000] + base:RetainedEarningsAccumulatedDeficit[2648000000] + base:AccumulatedOtherComprehensiveIncomeLossNetOfTax[431000000]

base:StockholdersEquity[71997000000] = base:CommonStocksIncludingAdditionalPaidInCapital[68178000000] + base:RetainedEarningsAccumulatedDeficit[2282000000] + base:AccumulatedOtherComprehensiveIncomeLossNetOfTax[1537000000]

calculationbase:CashAndCashEquivalentsPeriodIncreaseDecrease (in StatementCASHFLOWSSTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

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

3 instances:

base:CashAndCashEquivalentsPeriodIncreaseDecrease[1153000000] = base:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[39507000000] + base:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[8408000000] + base:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-46781000000] + base:EffectOfExchangeRateOnCashAndCashEquivalents[19000000]

base:CashAndCashEquivalentsPeriodIncreaseDecrease[915000000] = base:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[33325000000] + base:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-8393000000] + base:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23950000000] + base:EffectOfExchangeRateOnCashAndCashEquivalents[-67000000]

base:CashAndCashEquivalentsPeriodIncreaseDecrease[-3074000000] = base:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[29668000000] + base:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-9668000000] + base:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23001000000] + base:EffectOfExchangeRateOnCashAndCashEquivalents[-73000000]

calculationbase:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations (in StatementCASHFLOWSSTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

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

3 instances:

base:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[8408000000] = base:ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess[-4963000000] + base:ProceedsFromDebtMaturingInMoreThanThreeMonths[44344000000] + - base:RepaymentsOfDebtMaturingInMoreThanThreeMonths[7922000000] + base:ProceedsFromIssuanceOfCommonStock[772000000] + - base:PaymentsForRepurchaseOfCommonStock[11788000000] + - base:PaymentsOfDividendsCommonStock[11845000000] + base:ProceedsFromPaymentsForOtherFinancingActivities[-190000000]

base:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-8393000000] = base:ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess[7195000000] + base:ProceedsFromDebtMaturingInMoreThanThreeMonths[13884000000] + - base:RepaymentsOfDebtMaturingInMoreThanThreeMonths[2796000000] + base:ProceedsFromIssuanceOfCommonStock[668000000] + - base:PaymentsForRepurchaseOfCommonStock[15969000000] + - base:PaymentsOfDividendsCommonStock[11006000000] + base:ProceedsFromPaymentsForOtherFinancingActivities[-369000000]

base:NetCashProvidedByUsedInFinancingActivitiesContinuingOperations[-9668000000] = base:ProceedsFromRepaymentsOfShortTermDebtMaturingInThreeMonthsOrLess[4481000000] + base:ProceedsFromDebtMaturingInMoreThanThreeMonths[10680000000] + - base:RepaymentsOfDebtMaturingInMoreThanThreeMonths[1500000000] + base:ProceedsFromIssuanceOfCommonStock[634000000] + - base:PaymentsForRepurchaseOfCommonStock[14443000000] + - base:PaymentsOfDividendsCommonStock[9882000000] + base:ProceedsFromPaymentsForOtherFinancingActivities[362000000]

calculationbase:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations (in StatementCASHFLOWSSTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

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

3 instances:

base:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-46781000000] = - base:PaymentsToAcquirePropertyPlantAndEquipment[8129000000] + - msft:AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets[25944000000] + - base:PaymentsToAcquireInvestments[176905000000] + base:ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities[28044000000] + base:ProceedsFromSaleOfAvailableForSaleSecurities[136350000000] + - base:IncreaseDecreaseInCollateralHeldUnderSecuritiesLending[197000000]

base:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23950000000] = - base:PaymentsToAcquirePropertyPlantAndEquipment[8343000000] + - msft:AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets[1393000000] + - base:PaymentsToAcquireInvestments[129758000000] + base:ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities[22054000000] + base:ProceedsFromSaleOfAvailableForSaleSecurities[93287000000] + - base:IncreaseDecreaseInCollateralHeldUnderSecuritiesLending[-203000000]

base:NetCashProvidedByUsedInInvestingActivitiesContinuingOperations[-23001000000] = - base:PaymentsToAcquirePropertyPlantAndEquipment[5944000000] + - msft:AcquisitionsNetOfCashAcquiredAndPurchasesOfIntangibleAndOtherAssets[3723000000] + - base:PaymentsToAcquireInvestments[98729000000] + base:ProceedsFromMaturitiesPrepaymentsAndCallsOfAvailableForSaleSecurities[15013000000] + base:ProceedsFromSaleOfAvailableForSaleSecurities[70848000000] + - base:IncreaseDecreaseInCollateralHeldUnderSecuritiesLending[466000000]

calculationbase:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations (in StatementCASHFLOWSSTATEMENTS)
  • derived:0
  • 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:

base:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[39507000000] = base:NetIncomeLoss[21204000000] + base:AssetImpairmentCharges[0] + msft:DepreciationAmortizationAndOther[8778000000] + base:ShareBasedCompensation[3266000000] + - msft:GainLossOnInvestmentsAndDerivativeInstruments[2073000000] + base:DeferredIncomeTaxExpenseBenefit[-3296000000] + base:IncreaseDecreaseInDeferredRevenue[67711000000] + - base:RecognitionOfDeferredRevenue[57735000000] + - base:IncreaseDecreaseInAccountsReceivable[925000000] + - base:IncreaseDecreaseInInventories[-50000000] + - base:IncreaseDecreaseInOtherCurrentAssets[-1066000000] + - base:IncreaseDecreaseInOtherNoncurrentAssets[539000000] + base:IncreaseDecreaseInAccountsPayable[81000000] + base:IncreaseDecreaseInOtherCurrentLiabilities[386000000] + base:IncreaseDecreaseInOtherNoncurrentLiabilities[1533000000]

base:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[33325000000] = base:NetIncomeLoss[16798000000] + base:AssetImpairmentCharges[630000000] + msft:DepreciationAmortizationAndOther[6622000000] + base:ShareBasedCompensation[2668000000] + - msft:GainLossOnInvestmentsAndDerivativeInstruments[223000000] + base:DeferredIncomeTaxExpenseBenefit[332000000] + base:IncreaseDecreaseInDeferredRevenue[57072000000] + - base:RecognitionOfDeferredRevenue[48498000000] + - base:IncreaseDecreaseInAccountsReceivable[530000000] + - base:IncreaseDecreaseInInventories[-600000000] + - base:IncreaseDecreaseInOtherCurrentAssets[1167000000] + - base:IncreaseDecreaseInOtherNoncurrentAssets[41000000] + base:IncreaseDecreaseInAccountsPayable[88000000] + base:IncreaseDecreaseInOtherCurrentLiabilities[-260000000] + base:IncreaseDecreaseInOtherNoncurrentLiabilities[-766000000]

base:NetCashProvidedByUsedInOperatingActivitiesContinuingOperations[29668000000] = base:NetIncomeLoss[12193000000] + base:AssetImpairmentCharges[7498000000] + msft:DepreciationAmortizationAndOther[5957000000] + base:ShareBasedCompensation[2574000000] + - msft:GainLossOnInvestmentsAndDerivativeInstruments[443000000] + base:DeferredIncomeTaxExpenseBenefit[224000000] + base:IncreaseDecreaseInDeferredRevenue[45072000000] + - base:RecognitionOfDeferredRevenue[44920000000] + - base:IncreaseDecreaseInAccountsReceivable[-1456000000] + - base:IncreaseDecreaseInInventories[272000000] + - base:IncreaseDecreaseInOtherCurrentAssets[-62000000] + - base:IncreaseDecreaseInOtherNoncurrentAssets[-346000000] + base:IncreaseDecreaseInAccountsPayable[-1054000000] + base:IncreaseDecreaseInOtherCurrentLiabilities[-624000000] + base:IncreaseDecreaseInOtherNoncurrentLiabilities[1599000000]

calculationbase:ComprehensiveIncomeNetOfTax (in StatementCOMPREHENSIVEINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=NetIncomeLoss_2+OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent_1

3 instances:

base:ComprehensiveIncomeNetOfTax[20098000000] = base:NetIncomeLoss[21204000000] + base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1106000000]

base:ComprehensiveIncomeNetOfTax[15813000000] = base:NetIncomeLoss[16798000000] + base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-985000000]

base:ComprehensiveIncomeNetOfTax[11007000000] = base:NetIncomeLoss[12193000000] + base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1186000000]

calculationbase:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent (in StatementCOMPREHENSIVEINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax_3+(OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax_2+OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax_1)

3 instances:

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1106000000] = base:OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax[-218000000] + base:OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax[-1116000000] + base:OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax[228000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-985000000] = base:OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax[-238000000] + base:OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax[-228000000] + base:OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax[-519000000]

base:OtherComprehensiveIncomeLossNetOfTaxPortionAttributableToParent[-1186000000] = base:OtherComprehensiveIncomeLossDerivativesQualifyingAsHedgesNetOfTax[559000000] + base:OtherComprehensiveIncomeLossAvailableForSaleSecuritiesAdjustmentNetOfTax[-362000000] + base:OtherComprehensiveIncomeLossForeignCurrencyTransactionAndTranslationAdjustmentNetOfTax[-1383000000]

calculationbase:CostOfRevenue (in StatementINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=CostOfGoodsSold_2+CostOfServicesAndOther_1

3 instances:

base:CostOfRevenue[34261000000] = base:CostOfGoodsSold[15175000000] + msft:CostOfServicesAndOther[19086000000]

base:CostOfRevenue[32780000000] = base:CostOfGoodsSold[17880000000] + msft:CostOfServicesAndOther[14900000000]

base:CostOfRevenue[33038000000] = base:CostOfGoodsSold[21410000000] + msft:CostOfServicesAndOther[11628000000]

calculationbase:GrossProfit (in StatementINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=SalesRevenueNet_2+ -CostOfRevenue_1

3 instances:

base:GrossProfit[55689000000] = base:SalesRevenueNet[89950000000] + - base:CostOfRevenue[34261000000]

base:GrossProfit[52540000000] = base:SalesRevenueNet[85320000000] + - base:CostOfRevenue[32780000000]

base:GrossProfit[60542000000] = base:SalesRevenueNet[93580000000] + - base:CostOfRevenue[33038000000]

calculationbase:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments (in StatementINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=OperatingIncomeLoss_2+NonoperatingIncomeExpense_1

3 instances:

base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[23149000000] = base:OperatingIncomeLoss[22326000000] + base:NonoperatingIncomeExpense[823000000]

base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[19751000000] = base:OperatingIncomeLoss[20182000000] + base:NonoperatingIncomeExpense[-431000000]

base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[18507000000] = base:OperatingIncomeLoss[18161000000] + base:NonoperatingIncomeExpense[346000000]

calculationbase:NetIncomeLoss (in StatementINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments_2+ -IncomeTaxExpenseBenefit_1

3 instances:

base:NetIncomeLoss[21204000000] = base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[23149000000] + - base:IncomeTaxExpenseBenefit[1945000000]

base:NetIncomeLoss[16798000000] = base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[19751000000] + - base:IncomeTaxExpenseBenefit[2953000000]

base:NetIncomeLoss[12193000000] = base:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments[18507000000] + - base:IncomeTaxExpenseBenefit[6314000000]

calculationbase:OperatingIncomeLoss (in StatementINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

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

3 instances:

base:OperatingIncomeLoss[22326000000] = base:GrossProfit[55689000000] + - base:ResearchAndDevelopmentExpense[13037000000] + - base:SellingAndMarketingExpense[15539000000] + - base:GeneralAndAdministrativeExpense[4481000000] + - msft:ImpairmentIntegrationAndRestructuringExpenses[306000000]

base:OperatingIncomeLoss[20182000000] = base:GrossProfit[52540000000] + - base:ResearchAndDevelopmentExpense[11988000000] + - base:SellingAndMarketingExpense[14697000000] + - base:GeneralAndAdministrativeExpense[4563000000] + - msft:ImpairmentIntegrationAndRestructuringExpenses[1110000000]

base:OperatingIncomeLoss[18161000000] = base:GrossProfit[60542000000] + - base:ResearchAndDevelopmentExpense[12046000000] + - base:SellingAndMarketingExpense[15713000000] + - base:GeneralAndAdministrativeExpense[4611000000] + - msft:ImpairmentIntegrationAndRestructuringExpenses[10011000000]

calculationbase:SalesRevenueNet (in StatementINCOMESTATEMENTS)
  • derived:0
  • ok:3
  • failed:0
 

total=SalesRevenueGoodsNet_2+SalesRevenueServicesAndOtherNet_1

3 instances:

base:SalesRevenueNet[89950000000] = base:SalesRevenueGoodsNet[57190000000] + msft:SalesRevenueServicesAndOtherNet[32760000000]

base:SalesRevenueNet[85320000000] = base:SalesRevenueGoodsNet[61502000000] + msft:SalesRevenueServicesAndOtherNet[23818000000]

base:SalesRevenueNet[93580000000] = base:SalesRevenueGoodsNet[75956000000] + msft:SalesRevenueServicesAndOtherNet[17624000000]

For more information: http://logicalcontracts.com/xbrl-and-sbrm-reporting/
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