Generated by Logical Toolkit for XBRL version f512f32 (updated 14 hours ago). Analysis at 2021-06-12T15:41:33+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.

Block Pivots (one per detected block)
Network
100630 - Disclosure - Derivatives - Additional Information (Detail)
(http://www.xbrlsite.com/msft/role/DisclosureDerivativesAdditionalInformationDetail)
Table(implied)

Concept arrangement pattern: 1.1.7.1.set []
Entity: 0000789019 (http://www.sec.gov/CIK)


Component as one Pivot (ALL presented facts)
Network
100630 - Disclosure - Derivatives - Additional Information (Detail)
(http://www.xbrlsite.com/msft/role/DisclosureDerivativesAdditionalInformationDetail)
Table(implied)

Entity: 0000789019 (http://www.sec.gov/CIK)


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

Fact Table
Network
100630 - Disclosure - Derivatives - Additional Information (Detail)
(http://www.xbrlsite.com/msft/role/DisclosureDerivativesAdditionalInformationDetail)
Table(implied)
#BlockReporting Entity [Aspect]Period [Aspect]Dimension MembersConceptFact ValueUnitRoundingParenthetical ExplanationsOrigin
11.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-07-01 to 2017-06-30Derivative Contract [Domain] * Long term Debt, Type [Domain] * Position [Domain]Maximum length of time hedged in cash flow hedgeP3Y Reported
21.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Commodity Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts631000000 iso4217:USD-6Reported
31.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Commodity Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts19000000 iso4217:USD-6Reported
41.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Commodity Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts162000000 iso4217:USD-6Reported
51.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Credit Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts440000000 iso4217:USD-6Reported
61.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Credit Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts267000000 iso4217:USD-6Reported
71.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Credit Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts273000000 iso4217:USD-6Reported
81.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Credit Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts63000000 iso4217:USD-6Reported
91.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Equity Contracts * Designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts737000000 iso4217:USD-6Reported
101.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Equity Contracts * Designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts1600000000 iso4217:USD-8Reported
111.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Equity Contracts * Designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts986000000 iso4217:USD-6Reported
121.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Equity Contracts * Designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts1800000000 iso4217:USD-8Reported
131.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Equity Contracts * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts1300000000 iso4217:USD-8Reported
141.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Equity Contracts * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts1900000000 iso4217:USD-8Reported
151.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Equity Contracts * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts2200000000 iso4217:USD-8Reported
161.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Equity Contracts * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts2400000000 iso4217:USD-8Reported
171.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Foreign Exchange Contracts * Cash flow hedging * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts8400000000 iso4217:USD-8Reported
181.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Foreign Exchange Contracts * Cash flow hedging * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts8900000000 iso4217:USD-8Reported
191.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Foreign Exchange Contracts * Fair value hedging * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts5300000000 iso4217:USD-8Reported
201.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Foreign Exchange Contracts * Fair value hedging * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts5100000000 iso4217:USD-8Reported
211.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Foreign Exchange Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts12000000000 iso4217:USD-8Reported
221.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Foreign Exchange Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts8800000000 iso4217:USD-8Reported
231.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Foreign Exchange Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts11700000000 iso4217:USD-8Reported
241.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Foreign Exchange Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts10600000000 iso4217:USD-8Reported
251.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Interest Rate Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts328000000 iso4217:USD-6Reported
261.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Interest Rate Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts233000000 iso4217:USD-6Reported
271.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Interest Rate Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts2400000000 iso4217:USD-8Reported
281.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Interest Rate Contracts * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives SoldNotional amounts352000000 iso4217:USD-6Reported
291.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-06-30Mortgage-backed securities * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts548000000 iso4217:USD-6Reported
301.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Mortgage-backed securities * Non-designated Hedge Derivatives * Long term Debt, Type [Domain] * Derivatives PurchasedNotional amounts567000000 iso4217:USD-6Reported
311.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-07-01 to 2017-06-30Derivative Contract [Domain] * Long term Debt, Type [Domain] * Position [Domain]Minimum required liquidity under certain counterparty agreements1000000000 iso4217:USDINFReported
321.1.7.1.set0000789019 (http://www.sec.gov/CIK)2016-07-01 to 2017-06-30Derivative Contract [Domain] * Senior Unsecured Obligations * Position [Domain]Debt instrument credit ratingAAA Reported
331.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Derivative Contract [Domain] * Long term Debt, Type [Domain] * Position [Domain]Minimum liquidity for the period as defined by certain counterparty agreements1000000000 iso4217:USDINFReported
341.1.7.1.set0000789019 (http://www.sec.gov/CIK)2017-06-30Derivative Contract [Domain] * Long term Debt, Type [Domain] * Position [Domain]Estimated derivative net gains (losses) included in AOCI that will be reclassified into earnings within 12 months130000000 iso4217:USD-6Reported
Model Structure
Network
100630 - Disclosure - Derivatives - Additional Information (Detail)
(http://www.xbrlsite.com/msft/role/DisclosureDerivativesAdditionalInformationDetail)
Table(implied)
#LabelReport Element ClassPeriod TypeBalanceName
1Derivative Instruments And Hedging Activities Disclosure [Abstract]Abstractdurationbase:DerivativeInstrumentsAndHedgingActivitiesDisclosureAbstract
2 Derivative [Table]Hypercubedurationbase:DerivativeTable
3 Legal Entity [Axis]Dimensiondurationother:LegalEntityAxis
4 Entity [Domain]Memberdurationother:EntityDomain
5 Position [Axis]Dimensiondurationbase:PositionAxis
6 Position [Domain]Memberdurationbase:PositionDomain
7 Derivatives SoldMemberdurationbase:ShortMember
8 Derivatives PurchasedMemberdurationbase:LongMember
9 Hedging Relationship [Axis]Dimensiondurationbase:DerivativeInstrumentsGainLossByHedgingRelationshipAxis
10 Hedging Relationship [Domain]Memberdurationbase:HedgingRelationshipDomain
11 Cash flow hedgingMemberdurationbase:CashFlowHedgingMember
12 Fair value hedgingMemberdurationbase:FairValueHedgingMember
13 Derivative Instrument [Axis]Dimensiondurationbase:DerivativeInstrumentRiskAxis
14 Derivative Contract [Domain]Memberdurationbase:DerivativeContractTypeDomain
15 Foreign Exchange ContractsMemberdurationbase:ForeignExchangeContractMember
16 Equity ContractsMemberdurationbase:EquityContractMember
17 Interest Rate ContractsMemberdurationbase:InterestRateContractMember
18 Mortgage-backed securitiesMemberdurationbase:MortgageBackedSecuritiesMember
19 Credit ContractsMemberdurationbase:CreditRiskContractMember
20 Commodity ContractsMemberdurationbase:CommodityContractMember
21 Hedging DesignationDimensiondurationbase:HedgingDesignationAxis
22 Hedging Designation [Domain]Memberdurationbase:HedgingDesignationDomain
23 Non-designated Hedge DerivativesMemberdurationbase:NondesignatedMember
24 Designated Hedge DerivativesMemberdurationbase:DesignatedAsHedgingInstrumentMember
25 Long-term Debt, TypeDimensiondurationbase:LongtermDebtTypeAxis
26 Long term Debt, Type [Domain]Memberdurationbase:LongtermDebtTypeDomain
27 Senior Unsecured ObligationsMemberdurationbase:UnsecuredDebtMember
28 Derivative [Line Items]LineItemsdurationbase:DerivativeLineItems
29 Maximum length of time hedged in cash flow hedgeConcept (Duration)durationbase:MaximumLengthOfTimeForeignCurrencyCashFlowHedge
30 Notional amountsConcept (Monetary)instantinvest:DerivativeNotionalAmount
31 Minimum required liquidity under certain counterparty agreementsConcept (Monetary)durationdebitmsft:FinancialInstrumentCovenantMinimumLiquidityRequirement
32 Debt instrument credit ratingConcept (String)durationbase:DebtInstrumentCreditRating
33 Minimum liquidity for the period as defined by certain counterparty agreementsConcept (Monetary)instantdebitmsft:FinancialInstrumentCovenantMinimumLiquidity
34 Estimated derivative net gains (losses) included in AOCI that will be reclassified into earnings within 12 monthsConcept (Monetary)instantcreditbase:ForeignCurrencyCashFlowHedgeGainLossToBeReclassifiedDuringNext12Months

Definition Graphs

Definition Links Graph
Network
100630 - Disclosure - Derivatives - Additional Information (Detail)
(http://www.xbrlsite.com/msft/role/DisclosureDerivativesAdditionalInformationDetail)
Table(implied)
%3 base:CashFlowHedgingMember base:CashFlowHedgingMember base:CommodityContractMember base:CommodityContractMember base:CreditRiskContractMember base:CreditRiskContractMember base:DebtInstrumentCreditRating base:DebtInstrumentCreditRating base:DerivativeContractTypeDomain base:DerivativeContractTypeDomain base:DerivativeContractTypeDomain->base:CommodityContractMember domain-member base:DerivativeContractTypeDomain->base:CreditRiskContractMember domain-member base:EquityContractMember base:EquityContractMember base:DerivativeContractTypeDomain->base:EquityContractMember domain-member base:ForeignExchangeContractMember base:ForeignExchangeContractMember base:DerivativeContractTypeDomain->base:ForeignExchangeContractMember domain-member base:InterestRateContractMember base:InterestRateContractMember base:DerivativeContractTypeDomain->base:InterestRateContractMember domain-member base:MortgageBackedSecuritiesMember base:MortgageBackedSecuritiesMember base:DerivativeContractTypeDomain->base:MortgageBackedSecuritiesMember domain-member base:DerivativeInstrumentRiskAxis base:DerivativeInstrumentRiskAxis base:DerivativeInstrumentRiskAxis->base:DerivativeContractTypeDomain dimension-default base:DerivativeInstrumentRiskAxis->base:DerivativeContractTypeDomain dimension-domain base:DerivativeInstrumentsGainLossByHedgingRelationshipAxis base:DerivativeInstrumentsGainLossByHedgingRelationshipAxis base:HedgingRelationshipDomain base:HedgingRelationshipDomain base:DerivativeInstrumentsGainLossByHedgingRelationshipAxis->base:HedgingRelationshipDomain dimension-domain base:DerivativeLineItems base:DerivativeLineItems base:DerivativeLineItems->base:DebtInstrumentCreditRating domain-member base:DerivativeTable base:DerivativeTable base:DerivativeLineItems->base:DerivativeTable all base:ForeignCurrencyCashFlowHedgeGainLossToBeReclassifiedDuringNext12Months base:ForeignCurrencyCashFlowHedgeGainLossToBeReclassifiedDuringNext12Months base:DerivativeLineItems->base:ForeignCurrencyCashFlowHedgeGainLossToBeReclassifiedDuringNext12Months domain-member base:MaximumLengthOfTimeForeignCurrencyCashFlowHedge base:MaximumLengthOfTimeForeignCurrencyCashFlowHedge base:DerivativeLineItems->base:MaximumLengthOfTimeForeignCurrencyCashFlowHedge domain-member invest:DerivativeNotionalAmount invest:DerivativeNotionalAmount base:DerivativeLineItems->invest:DerivativeNotionalAmount domain-member msft:FinancialInstrumentCovenantMinimumLiquidity msft:FinancialInstrumentCovenantMinimumLiquidity base:DerivativeLineItems->msft:FinancialInstrumentCovenantMinimumLiquidity domain-member msft:FinancialInstrumentCovenantMinimumLiquidityRequirement msft:FinancialInstrumentCovenantMinimumLiquidityRequirement base:DerivativeLineItems->msft:FinancialInstrumentCovenantMinimumLiquidityRequirement domain-member base:DerivativeTable->base:DerivativeInstrumentRiskAxis hypercube-dimension base:DerivativeTable->base:DerivativeInstrumentsGainLossByHedgingRelationshipAxis hypercube-dimension base:HedgingDesignationAxis base:HedgingDesignationAxis base:DerivativeTable->base:HedgingDesignationAxis hypercube-dimension base:LongtermDebtTypeAxis base:LongtermDebtTypeAxis base:DerivativeTable->base:LongtermDebtTypeAxis hypercube-dimension base:PositionAxis base:PositionAxis base:DerivativeTable->base:PositionAxis hypercube-dimension other:LegalEntityAxis other:LegalEntityAxis base:DerivativeTable->other:LegalEntityAxis hypercube-dimension base:DesignatedAsHedgingInstrumentMember base:DesignatedAsHedgingInstrumentMember base:FairValueHedgingMember base:FairValueHedgingMember base:HedgingDesignationDomain base:HedgingDesignationDomain base:HedgingDesignationAxis->base:HedgingDesignationDomain dimension-domain base:HedgingDesignationDomain->base:DesignatedAsHedgingInstrumentMember domain-member base:NondesignatedMember base:NondesignatedMember base:HedgingDesignationDomain->base:NondesignatedMember domain-member base:HedgingRelationshipDomain->base:CashFlowHedgingMember domain-member base:HedgingRelationshipDomain->base:FairValueHedgingMember domain-member base:LongMember base:LongMember base:LongtermDebtTypeDomain base:LongtermDebtTypeDomain base:LongtermDebtTypeAxis->base:LongtermDebtTypeDomain dimension-default base:LongtermDebtTypeAxis->base:LongtermDebtTypeDomain dimension-domain base:UnsecuredDebtMember base:UnsecuredDebtMember base:LongtermDebtTypeDomain->base:UnsecuredDebtMember domain-member base:PositionDomain base:PositionDomain base:PositionAxis->base:PositionDomain dimension-default base:PositionAxis->base:PositionDomain dimension-domain base:PositionDomain->base:LongMember domain-member base:ShortMember base:ShortMember base:PositionDomain->base:ShortMember domain-member other:EntityDomain other:EntityDomain other:LegalEntityAxis->other:EntityDomain dimension-domain

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