RED BRICK SYSTEMS INC

EDGAR

11 filing records in this dataset, filed from 1996-05-03 to 1998-11-16. Explore the available filing history and original sources.

Watchlist

Latest quarter

Revenue

8.05 million USD

1998-09-30 · USD

Exact inputs and evidence

Operating margin

-64.09%

1998-09-30 · %

Exact inputs and evidence
  • Operating Income: -5157000 USD Source
  • Revenue: 8047000 USD Source
Cash and cash equivalents
7.36 million USD Source
Exact value

7357000 USD

Long-term debt including current maturities
Not available
Shares outstanding
Not available

Trailing twelve months

The four most recent complete quarters added together. This gives a full-year view that includes the latest quarterly results.

Net income

-14.6 million USD

1997-10-01 – 1998-09-30

Exact inputs and evidence
  • Net income: -18023000 USD · 1997-01-01 – 1997-12-31 Source
  • Net income: -18437000 USD · 1997-01-01 – 1997-09-30 Source
  • Net income: -3938000 USD · 1998-01-01 – 1998-03-31 Source
  • Net income: -6072000 USD · 1998-04-01 – 1998-06-30 Source
  • Net income: -4996000 USD · 1998-07-01 – 1998-09-30 Source

Operating cash flow

1.08 million USD

1997-01-01 – 1997-12-31

Exact inputs and evidence
  • Operating cash flow: 3355000 USD · 1997-01-01 – 1997-03-31 Source
  • Operating cash flow: 3976000 USD · 1997-01-01 – 1997-06-30 Source
  • Operating cash flow: 3355000 USD · 1997-01-01 – 1997-03-31 Source
  • Operating cash flow: 1549000 USD · 1997-01-01 – 1997-09-30 Source
  • Operating cash flow: 3976000 USD · 1997-01-01 – 1997-06-30 Source
  • Operating cash flow: 1083000 USD · 1997-01-01 – 1997-12-31 Source
  • Operating cash flow: 1549000 USD · 1997-01-01 – 1997-09-30 Source

Capital expenditure

2.81 million USD

1997-07-01 – 1998-06-30

Exact inputs and evidence
  • Capital expenditure: 1109000 USD · 1997-01-01 – 1997-09-30 Source
  • Capital expenditure: 953000 USD · 1997-01-01 – 1997-06-30 Source
  • Capital expenditure: 1676000 USD · 1997-01-01 – 1997-12-31 Source
  • Capital expenditure: 1109000 USD · 1997-01-01 – 1997-09-30 Source
  • Capital expenditure: 415000 USD · 1998-01-01 – 1998-03-31 Source
  • Capital expenditure: 2089000 USD · 1998-01-01 – 1998-06-30 Source
  • Capital expenditure: 415000 USD · 1998-01-01 – 1998-03-31 Source

Company performance

Up to ten complete financial years · consolidated figures

Includes later revisions to earlier periods. Annual charts exclude incomplete years.

Latest filing recorded: 1998-11-16.

Financial data available through: 1997-12-31.

Coverage by financial measure
  • Revenue: 4 of 11 periods available· newest 1997-12-31
  • Operating income: 4 of 11 periods available· newest 1997-12-31
  • Net income: 4 of 11 periods available· newest 1997-12-31
  • Operating cash flow: 4 of 11 periods available· newest 1997-12-31
  • Capital expenditure: 4 of 11 periods available· newest 1997-12-31
  • Total assets: 3 of 11 periods available· newest 1997-12-31
  • liabilities: No compatible figures in this window
  • Current assets: 3 of 11 periods available· newest 1997-12-31
  • Current liabilities: 3 of 11 periods available· newest 1997-12-31
  • Cash and cash equivalents: 4 of 11 periods available· newest 1997-12-31
  • long term debt: No compatible figures in this window
  • shares outstanding: No compatible figures in this window

Coverage describes values retained in this snapshot. Missing values are not zero; loading limits are reported separately.

What changed year over year

Latest complete year compared with the corresponding period one year earlier. These are measured changes; they do not establish their business causes.

  • Revenue

    +20.2%

    Prior period

    USD 36.04 million

    –

    Current period

    USD 43.32 million

    –

    Exact inputs and evidence

    43315000 − 36035000 = 7280000 USD

    36035000 USD · 1996-01-01 – 1996-12-31

    Inspect prior input Prior source

    43315000 USD · 1997-01-01 – 1997-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

  • Net income

    -572.1%

    Prior period

    USD 3.82 million

    –

    Current period

    −USD 18.02 million

    –

    Exact inputs and evidence

    -18023000 − 3818000 = -21841000 USD

    3818000 USD · 1996-01-01 – 1996-12-31

    Inspect prior input Prior source

    -18023000 USD · 1997-01-01 – 1997-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

  • Operating cash flow

    +USD 1.24 million

    Prior period

    −USD 158,000

    –

    Current period

    USD 1.08 million

    –

    Exact inputs and evidence

    1083000 − -158000 = 1241000 USD

    -158000 USD · 1996-01-01 – 1996-12-31

    Inspect prior input Prior source

    1083000 USD · 1997-01-01 – 1997-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

  • Capital expenditure

    -4.1%

    Prior period

    USD 1.75 million

    –

    Current period

    USD 1.68 million

    –

    Exact inputs and evidence

    1676000 − 1748000 = -72000 USD

    1748000 USD · 1996-01-01 – 1996-12-31

    Inspect prior input Prior source

    1676000 USD · 1997-01-01 – 1997-12-31

    Inspect current input Current source
    Share or cite

    The citation records this snapshot. The page link may show a newer release later.

Where revenue goes

How a period’s revenue divides into costs and what remains as profit. Items marked Derived are calculated by subtraction from reported figures.

1997 1997-01-01 – 1997-12-31

  • Revenue USD 43.32 million 100% of revenue
  • Cost of revenue USD 9.94 million 23% of revenue
  • Operating expenses USD 52.09 million 120% of revenue
  • Operating income −USD 18.72 million −43% of revenue
  • Tax, interest and other Derived −USD 694,000 −1.6% of revenue
  • Net income −USD 18.02 million −42% of revenue

Cash

  • Operating cash flow USD 1.08 million 2.5% of revenue
  • Capital expenditure USD 1.68 million 3.9% of revenue
  • Free cash flow Derived −USD 593,000 −1.4% of revenue

Share of revenue by period

  • Net income
  • Tax, interest and other
  • Operating costs
  • 1994 Operating loss: operating costs were 117% of revenue.
  • 1995 97%
  • 1996 Net income was higher than operating income, so the split is not drawn.
  • 1997 Operating loss: operating costs were 143% of revenue.
Values and sources
Revenue breakdown by annual reporting period
PeriodRevenueOperating costsOperating incomeTax, interest and otherNet incomeFree cash flowSource
1994 1994-01-01 – 1994-12-318502000 9918000 Derived -1416000 65000 Derived -1481000 -1785000 Derived
Source
1995 1995-01-01 – 1995-12-3120605000 20026000 Derived 579000 271000 Derived 308000 711000 Derived
Source
1996 1996-01-01 – 1996-12-3136035000 34498000 Derived 1537000 -2281000 Derived 3818000 -1906000 Derived
Source
1997 1997-01-01 – 1997-12-3143315000 62032000 Derived -18717000 -694000 Derived -18023000 -593000 Derived
Source

Amounts are exact, in USD.

Growth

Sales over time and how quickly they are changing.

Revenue

Revenue reported for each complete financial period.

USD 43.3M 1997
Revenue historyRevenue reported for each complete financial period. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.46.8M35.1M23.4M11.7M0.01994199519961997
Values and sources
Revenue values and source evidence
PeriodSeriesValue(USD)Source evidence
1994Revenue8502000
1995Revenue20605000
1996Revenue36035000
1997Revenue43315000

Revenue growth

Change in revenue from the same financial period one year earlier.

20.2% 1997
Revenue growth historyChange in revenue from the same financial period one year earlier. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.154%115%77%38%0%1994199519961997
Values and sources
Revenue growth values and source evidence
PeriodSeriesValueSource evidence
1994Year over yearNo prior comparable period
1995Year over year142.4%
1996Year over year74.9%
1997Year over year20.2%

Profit and cash

How much revenue becomes profit, and how much cash operations generate.

Profit margins

Operating income, net income and free cash flow as a share of revenue.

Operating margin -43.2% 1997
Net margin -41.6% 1997
Free cash flow margin -1.4% 1997
Profit margins historyOperating income, net income and free cash flow as a share of revenue. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.15%-1%-16%-32%-48%1994199519961997
  • Operating margin
  • Net margin
  • Free cash flow margin
Values and sources
Profit margins values and source evidence
PeriodSeriesValueSource evidence
1994Operating margin-16.7%
1995Operating margin2.8%
1996Operating margin4.3%
1997Operating margin-43.2%
1994Net margin-17.4%
1995Net margin1.5%
1996Net margin10.6%
1997Net margin-41.6%
1994Free cash flow margin-21%
1995Free cash flow margin3.5%
1996Free cash flow margin-5.3%
1997Free cash flow margin-1.4%

Operating cash flow

Cash generated by the company’s normal business operations.

USD 1.1M 1997
Operating cash flow historyCash generated by the company’s normal business operations. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.1.3M495.6K-315.5K-1.1M-1.9M1994199519961997
Values and sources
Operating cash flow values and source evidence
PeriodSeriesValue(USD)Source evidence
1994Operating cash flow-1714000
1995Operating cash flow796000
1996Operating cash flow-158000
1997Operating cash flow1083000

Free cash flow

Operating cash flow minus capital expenditure for the same period and unit.

USD -593K 1997
Free cash flow historyOperating cash flow minus capital expenditure for the same period and unit. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.920.4K161.4K-597.5K-1.4M-2.1M1994199519961997
Values and sources
Free cash flow values and source evidence
PeriodSeriesValue(USD)Source evidence
1994Free cash flow-1785000
1995Free cash flow711000
1996Free cash flow-1906000
1997Free cash flow-593000

Balance sheet

Liabilities and short-term ability to meet obligations at each period end.

Liabilities to assets

Total liabilities as a share of total assets.

Not enough comparable data to show this history.
Values and sources
Liabilities to assets values and source evidence
PeriodSeriesValueSource evidence
1994-12-31Liabilities / assetsNot reportedNo source recorded
1995-12-31Liabilities / assetsNot reported
1996-12-31Liabilities / assetsNot reported
1997-12-31Liabilities / assetsNot reported

Current assets to current liabilities

Current assets divided by current liabilities.

2.86× 1997
Current assets to current liabilities historyCurrent assets divided by current liabilities. Values are shown by financial reporting period. Open Values and sources below for the exact observations and evidence.5.43×4.07×2.71×1.36×0.00×1994-12-31199519961997
Values and sources
Current assets to current liabilities values and source evidence
PeriodSeriesValueSource evidence
1994-12-31Current assets / current liabilitiesNot reportedNo source recorded
1995Current assets / current liabilities1.42×
1996Current assets / current liabilities5.03×
1997Current assets / current liabilities2.86×

Cash generation

Compare reported profit with operating cash and capital spending. Free cash flow is calculated as operating cash flow minus capital expenditure when both exact, consolidated amounts match the same period and unit.

Cash generation by annual reporting period
PeriodNet incomeOperating cash flowCapital expenditureFree cash flow
1994 1994-01-01 – 1994-12-31
−USD 1.48 million
Exact value

Exact value: -1481000 USD

1994-01-01 – 1994-12-31: -1481000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 1.71 million
Exact value

Exact value: -1714000 USD

1994-01-01 – 1994-12-31: -1714000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 71,000
Exact value

Exact value: 71000 USD

1994-01-01 – 1994-12-31: 71000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 1.79 million
Calculation and evidence

-1714000 − 71000 USD

Exact free cash flow: -1785000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

1995 1995-01-01 – 1995-12-31
USD 308,000
Exact value

Exact value: 308000 USD

1995-01-01 – 1995-12-31: 308000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 796,000
Exact value

Exact value: 796000 USD

1995-01-01 – 1995-12-31: 796000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 85,000
Exact value

Exact value: 85000 USD

1995-01-01 – 1995-12-31: 85000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 711,000
Calculation and evidence

796000 − 85000 USD

Exact free cash flow: 711000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

1996 1996-01-01 – 1996-12-31
USD 3.82 million
Exact value

Exact value: 3818000 USD

1996-01-01 – 1996-12-31: 3818000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 158,000
Exact value

Exact value: -158000 USD

1996-01-01 – 1996-12-31: -158000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.75 million
Exact value

Exact value: 1748000 USD

1996-01-01 – 1996-12-31: 1748000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 1.91 million
Calculation and evidence

-158000 − 1748000 USD

Exact free cash flow: -1906000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

1997 1997-01-01 – 1997-12-31
−USD 18.02 million
Exact value

Exact value: -18023000 USD

1997-01-01 – 1997-12-31: -18023000 USD Inspect Net Income Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.08 million
Exact value

Exact value: 1083000 USD

1997-01-01 – 1997-12-31: 1083000 USD Inspect Operating Cash Flow Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

USD 1.68 million
Exact value

Exact value: 1676000 USD

1997-01-01 – 1997-12-31: 1676000 USD Inspect Capital Expenditure Open source
Share or cite

The citation records this snapshot. The page link may show a newer release later.

−USD 593,000
Calculation and evidence

1083000 − 1676000 USD

Exact free cash flow: -593000 USD

Share or cite

The citation records this snapshot. The page link may show a newer release later.

Capital expenditure uses the canonical mapped positive-spending convention. A missing, ambiguous, incompatible, or negative-sign input is left blank. Values use the latest reported version.

Dataset coverage and company identifiers

Coverage reflects filings processed into this Fundies dataset; it does not imply every source filing is loaded.

11 filings · 0 latest values · 0 originally reported values

Dataset published . Source filing dates and reporting periods are shown separately.

Identifiers: 0001001489, 1001489, edgar:1001489