<?xml version="1.0" encoding="utf-8"?>
<NumberSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Formulas>
    <Formula name="FremFinanGrad">
      <Text>Fremdfinanzierungsgrad</Text>
      <Expr>Sum("2000";"2799") / Sum("2000";"2999") *100</Expr>
    </Formula>
    <Formula name="EigeFinanGrad">
      <Text>Eigenfinanzierungsgrad</Text>
      <Expr>Sum("2800";"2999") / Sum("2000";"2999") *100</Expr>
    </Formula>
    <Formula name="FinanVerhältn">
      <Text>Finanzierungsverhältnis</Text>
      <Expr>Sum("2000";"2799") / Sum("2800";"2999") *100</Expr>
    </Formula>
    <Formula name="SelbFinanGrad">
      <Text>Selbstfinanzierungsgrad</Text>
      <Expr>Sum("2900";"2999") / Sum("2800";"2999") *100</Expr>
    </Formula>
    <Formula name="IntensitätUV">
      <Text>Intensität des Umlaufvermögens</Text>
      <Expr>Sum("1000";"1399") / Sum("1000";"1999") *100</Expr>
    </Formula>
    <Formula name="IntensitätAV">
      <Text>Intensität des Anlagevermögens</Text>
      <Expr>Sum("1000";"1399") / Sum("1000";"1999") *100</Expr>
    </Formula>
    <Formula name="InvestVerhäl">
      <Text>Investitionsverhältnis</Text>
      <Expr>Sum("1000";"1399") / Sum("1400";"1999") *100</Expr>
    </Formula>
    <Formula name="LiqGrad1">
      <Text>Liquiditätsgrad 1</Text>
      <Expr>-Sum("1000";"1099") / Sum("2000";"2399") *100</Expr>
    </Formula>
    <Formula name="LiqGrad2">
      <Text>Liquiditätsgrad 2</Text>
      <Expr>-(Sum("1000";"1099") + Sum("1100";"1199")) / Sum("2000";"2399") *100</Expr>
    </Formula>
    <Formula name="LiqGrad3">
      <Text>Liquiditätsgrad 3</Text>
      <Expr>-Sum("1000";"1399") / Sum("2000";"2399") *100</Expr>
    </Formula>
    <Formula name="AnlDeckGrad1">
      <Text>Anlagedeckungsgrad 1</Text>
      <Expr>Sum("2800";"2999") / (-Sum("1400";"1999")) *100</Expr>
    </Formula>
    <Formula name="AnlDeckGrad2">
      <Text>Anlagedeckungsgrad 2</Text>
      <Expr>(Sum("2800";"2999") + Sum("2400";"2799")) / (-Sum("1400";"1999")) *100</Expr>
    </Formula>
    <Formula name="EKRendite">
      <Text>Eigenkapitalrendite</Text>
      <Expr>(Sum("3000";"3999") - Sum("4000";"9000")) / Avg2("2800";"2999") *100</Expr>
    </Formula>
    <Formula name="GesamtKapRend">
      <Text>Geamtkapitalrendite</Text>
      <Expr>(Sum("3000";"3999") - Sum("4000";"9000") + Sum("6800";"6899")) / Avg2("2000";"2999")</Expr>
    </Formula>
    <Formula name="RGMarge">
      <Text>Reingewinnmarge</Text>
      <Expr>(Sum("3000";"3999") - Sum("4000";"9000")) / Sum("3000";"3999") *100</Expr>
    </Formula>
    <Formula name="EBIT-Marge">
      <Text>EBIT-Marge</Text>
      <Expr>(Sum("3000";"3999") - Sum("4000";"9000") + Sum("6800";"6899")) / Sum("3000";"3999")</Expr>
    </Formula>
    <Formula name="CashflowMarge">
      <Text>Cashflow-Marge</Text>
      <Expr>(Sum("3000";"3999") - Sum("4000";"9000") + Sum("6900";"6999")) / Sum("3000";"3999")</Expr>
    </Formula>
    <Formula name="VerschFaktor">
      <Text>Verschuldungsfaktor</Text>
      <Expr>(Sum("2000";"2699") - Sum("1000";"1099") - Sum("1100";"1199")) / (Sum("3000";"3999") - Sum("4000";"9000"))</Expr>
    </Formula>
    <Formula name="°DebiUmschlag">
      <Text>° Debitorenumschlag</Text>
      <Expr>Sum("3000";"3999") / (-Avg2("1100";"1108"))</Expr>
    </Formula>
    <Formula name="°DebiFrist">
      <Text>° Debitorenfrist</Text>
      <Expr>-Avg2("1100";"1108") * 360 / Sum("3000";"3999")</Expr>
    </Formula>
    <Formula name="°Lagerumschl">
      <Text>° Lagerumschlag</Text>
      <Expr>Sum("4000";"4299") / Avg2("1200";"1299")</Expr>
    </Formula>
    <Formula name="°Lagerdauer">
      <Text>° Lagerdauer</Text>
      <Expr>Avg2("1200";"1299") * 360 / Sum("4000";"4299")</Expr>
    </Formula>
    <Formula name="°KrediFrist">
      <Text>° Kreditorenfrist</Text>
      <Expr>Avg2("2000";"2009") * 360 / (-Sum("4000";"4299"))</Expr>
    </Formula>
    <Formula name="°KapitUmschl">
      <Text>° Kapitalumschlag</Text>
      <Expr>Sum("3000";"3999") / Avg2("2000";"2999")</Expr>
    </Formula>
  </Formulas>
  <Columns>
    <Column name="Wert.">
      <ColumnType xsi:type="ColTypePeriod">
        <ValueType>balance</ValueType>
        <Period>variable</Period>
        <PeriodIndex>-1</PeriodIndex>
      </ColumnType>
    </Column>
  </Columns>
  <Options>
    <Title>Kennzahlen</Title>
    <Description>Das sind die standard Buchhaltungskennzahlen.</Description>
    <EditorSize>
      <Width>1059</Width>
      <Height>697</Height>
    </EditorSize>
    <ColWidths>
      <Col>108</Col>
      <Col>162</Col>
      <Col>415</Col>
      <Col>75</Col>
    </ColWidths>
  </Options>
  <Report>
    <Rows>
      <Row name="" level="9">
        <values>
          <Col>Gruppen</Col>
          <Col />
          <Col />
          <Col>Wert in % und Tagen</Col>
        </values>
      </Row>
      <Row level="1">
        <values>
          <Col>BILANZBEZOGENE KENNZAHLEN</Col>
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Kapitalstruktur (Passiven)</Col>
        </values>
      </Row>
      <Row name="FremFinanGrad" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="EigeFinanGrad" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="FinanVerhältn" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="SelbFinanGrad" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Vermögensstruktur (Aktiven)</Col>
        </values>
      </Row>
      <Row name="IntensitätUV" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="IntensitätAV" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="InvestVerhäl" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Liquidität (Bonität)</Col>
        </values>
      </Row>
      <Row name="LiqGrad1" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="LiqGrad2" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="LiqGrad3" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Anlagedeckung (Bilanzregel)</Col>
        </values>
      </Row>
      <Row name="AnlDeckGrad1" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="AnlDeckGrad2" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="1">
        <values>
          <Col>AKTIVITÄTSKENNZAHLEN</Col>
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Debitorenkennzahlen</Col>
        </values>
      </Row>
      <Row name="°DebiFrist" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="°DebiUmschlag" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Lagerkennzahlen</Col>
        </values>
      </Row>
      <Row name="°Lagerdauer" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="°Lagerumschl" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Kreditorenkennzahlen</Col>
        </values>
      </Row>
      <Row name="°KrediFrist" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="°KrediUmschlag" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="2">
        <values>
          <Col>Kapitalkennzahlen</Col>
        </values>
      </Row>
      <Row name="°KapitUmschl" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="" level="8">
        <values>
          <Col />
        </values>
      </Row>
      <Row name="" level="1">
        <values>
          <Col>CASHFLOWBEZOGENE KENNZAHLEN</Col>
        </values>
      </Row>
      <Row name="CashflowMarge" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
      <Row name="VerschFaktor" level="0">
        <values>
          <Col>[0]</Col>
          <Col />
          <Col />
          <Col>[1]</Col>
        </values>
      </Row>
    </Rows>
  </Report>
</NumberSet>