{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FSA","BS","IS","CI","CF","Disclaimer"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"FSA","index":0,"n_rows":66,"n_cols":7,"rows_kept":66,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
[]
[]
[]
[]
[null,"Version: 1.0 (Copyright 2019)"]
[null,"Author: Entdeckergeist Analytics UG (haftungsbeschränkt), www.edg-analytics.de, info@edg-analytics.de"]
[null,"Description: Excel basiertes Analysetool zur vollautomatisierten Berechnung von 18 typisierten Finanzkennzahlen aus veröffentlichten XBRL 10-K Filings (US-Kapitalmarkt)"]
[null,"Disclaimer | Anleitung"]
[]
[null,"XBRL Financial Statement Scanner"]
[]
[]
[]
[]
[]
[null,"Document and Entity Information "]
[]
[null,"Zip-File","Instance","Entity Registrant Name","CIK","Entity Filer Category"]
[]
[null,"Document Type","Fiscal Period Focus","Fiscal Year Focus","Period End Date","Amendment Flag"]
[]
[]
[]
[]
[null,"Selected Financial Data (scaled by Total Assets)","Mapped US-GAAP Taxonomy Line Items and Formula-Calculation:","t0","t-1","Δ (in %)"]
[null,"Cash & cash equivalents","= CashAndCashEquivalentsAtCarryingValue / Assets",null,null,{"$f":"IF(OR(E26=\"\",D26=\"\"),\"NA\",D26-E26)","v":"NA"},{"$f":"IF(F26<>\"NA\",IF(D26-E26>0,\"↑\",IF(D26-E26<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Property plant & equipment","= PropertyPlantAndEquipmentNet / Assets",null,null,{"$f":"IF(OR(E28=\"\",D28=\"\"),\"NA\",D28-E28)","v":"NA"},{"$f":"IF(F28<>\"NA\",IF(D28-E28>0,\"↑\",IF(D28-E28<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Accounts receivables","= AccountsReceivableNetCurrent / Assets",null,null,{"$f":"IF(OR(E30=\"\",D30=\"\"),\"NA\",D30-E30)","v":"NA"},{"$f":"IF(F30<>\"NA\",IF(D30-E30>0,\"↑\",IF(D30-E30<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Inventory","= InventoryNet / Assets",null,null,{"$f":"IF(OR(E32=\"\",D32=\"\"),\"NA\",D32-E32)","v":"NA"},{"$f":"IF(F32<>\"NA\",IF(D32-E32>0,\"↑\",IF(D32-E32<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Total accruals","= (NetIncomeLoss or ProfitLoss - (NetCashProvidedByUsedInOperatingActivities or NetCashProvidedByUsedInOperatingActivitiesContinuingOperations)) / Assets",null,null,{"$f":"IF(OR(E34=\"\",D34=\"\"),\"NA\",D34-E34)","v":"NA"},{"$f":"IF(F34<>\"NA\",IF(D34-E34>0,\"↑\",IF(D34-E34<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Total equity","= StockholdersEquity / Assets",null,null,{"$f":"IF(OR(E36=\"\",D36=\"\"),\"NA\",D36-E36)","v":"NA"},{"$f":"IF(F36<>\"NA\",IF(D36-E36>0,\"↑\",IF(D36-E36<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[]
[null,"Activity Analysis","Mapped US-GAAP Taxonomy Line Items and Formula-Calculation:","t0","t-1","Δ (in %)"]
[null,"Inventory turnover","= (CostOfGoodsAndServicesSold or (CostOfGoodsSold + CostOfServices)) / InventoryNet",null,null,{"$f":"IF(OR(E40=\"\",D40=\"\"),\"NA\",D40-E40)","v":"NA"},{"$f":"IF(F40<>\"NA\",IF(D40-E40>0,\"↑\",IF(D40-E40<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Receivables turnover","= (Revenues or SalesRevenueNet) / AccountsReceivableNetCurrent",null,null,{"$f":"IF(OR(E42=\"\",D42=\"\"),\"NA\",D42-E42)","v":"NA"},{"$f":"IF(F42<>\"NA\",IF(D42-E42>0,\"↑\",IF(D42-E42<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Working capital turnover","= (Revenues or SalesRevenueNet) / (AssetsCurrent - LiabilitiesCurrent)",null,null,{"$f":"IF(OR(E44=\"\",D44=\"\"),\"NA\",D44-E44)","v":"NA"},{"$f":"IF(F44<>\"NA\",IF(D44-E44>0,\"↑\",IF(D44-E44<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Total assets turnover","= (Revenues or SalesRevenueNet) / Assets",null,null,{"$f":"IF(OR(E46=\"\",D46=\"\"),\"NA\",D46-E46)","v":"NA"},{"$f":"IF(F46<>\"NA\",IF(D46-E46>0,\"↑\",IF(D46-E46<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[]
[null,"Liquidity & Solvency Analysis","Mapped US-GAAP Taxonomy Line Items and Formula-Calculation:","t0","t-1","Δ (in %)"]
[null,"Current ratio","= AssetsCurrent / LiabilitiesCurrent",null,null,{"$f":"IF(OR(E50=\"\",D50=\"\"),\"NA\",D50-E50)","v":"NA"},{"$f":"IF(F50<>\"NA\",IF(D50-E50>0,\"↑\",IF(D50-E50<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Cash ratio","= CashAndCashEquivalentsAtCarryingValue / LiabilitiesCurrent",null,null,{"$f":"IF(OR(E52=\"\",D52=\"\"),\"NA\",D52-E52)","v":"NA"},{"$f":"IF(F52<>\"NA\",IF(D52-E52>0,\"↑\",IF(D52-E52<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Debt-to-equity ratio","= Liabilities / StockholdersEquity",null,null,{"$f":"IF(OR(E54=\"\",D54=\"\"),\"NA\",D54-E54)","v":"NA"},{"$f":"IF(F54<>\"NA\",IF(D54-E54>0,\"↑\",IF(D54-E54<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[]
[null,"Profitability Analysis","Mapped US-GAAP Taxonomy Line Items and Formula-Calculation:","t0","t-1","Δ (in %)"]
[null,"Gross profit margin","= GrossProfit / (Revenues or SalesRevenueNet)",null,null,{"$f":"IF(OR(E58=\"\",D58=\"\"),\"NA\",D58-E58)","v":"NA"},{"$f":"IF(F58<>\"NA\",IF(D58-E58>0,\"↑\",IF(D58-E58<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Operating profit margin","= OperatingIncomeLoss / (Revenues or SalesRevenueNet)",null,null,{"$f":"IF(OR(E60=\"\",D60=\"\"),\"NA\",D60-E60)","v":"NA"},{"$f":"IF(F60<>\"NA\",IF(D60-E60>0,\"↑\",IF(D60-E60<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Net profit margin","= (NetIncomeLoss or ProfitLoss) / (Revenues or SalesRevenueNet)",null,null,{"$f":"IF(OR(E62=\"\",D62=\"\"),\"NA\",D62-E62)","v":"NA"},{"$f":"IF(F62<>\"NA\",IF(D62-E62>0,\"↑\",IF(D62-E62<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Return-on-assets (ROA)","= (NetIncomeLoss or ProfitLoss) / Assets",null,null,{"$f":"IF(OR(E64=\"\",D64=\"\"),\"NA\",D64-E64)","v":"NA"},{"$f":"IF(F64<>\"NA\",IF(D64-E64>0,\"↑\",IF(D64-E64<0,\"↓\",\"←\")),\"\")","v":""}]
[]
[null,"Return-on-equity (ROE)","= (NetIncomeLoss or ProfitLoss) / StockholdersEquity",null,null,{"$f":"IF(OR(E66=\"\",D66=\"\"),\"NA\",D66-E66)","v":"NA"},{"$f":"IF(F66<>\"NA\",IF(D66-E66>0,\"↑\",IF(D66-E66<0,\"↓\",\"←\")),\"\")","v":""}]

{"sheet":"BS","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"IS","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CI","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CF","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Disclaimer","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}