Keystone Builders (DEMO)
Construction · USD · data through Jul 2026 ▲▲ Needs immediate attention
Alerts (2)
- ▲▲ CriticalLargest customer is 43% of revenue
Largest customer: County School District. Based on uploaded invoices.
Evidence: Largest customer share (TTM invoices) (2026-07): 43.4%
→ Secure a multi-year renewal with the largest customer and set a pipeline target to diversify revenue.
- ▲ WarningGross margin down 5.3 points
Gross margin was 9.0% in 2026-07 versus a 14.3% average over the prior three months.
Evidence: Gross margin (2026-04): 19.0% · Gross margin (2026-05): 13.0% · Gross margin (2026-06): 11.0% · Gross margin (2026-07): 9.0%
→ Investigate COGS drivers: input prices, discounting, mix shift, and whether price increases were passed through.
Key metrics for construction · click a metric to see how it is calculated
Revenue
$1.9M
Actual · Jul 2026 · how?
Formula: Reported revenue for the month
Revenue growth (MoM)
-1.3%
Calculated · Jul 2026 · how?
Formula: (Revenue this month − last month) ÷ last month
Gross margin
9.0%
Calculated · Jul 2026 · how?
Formula: (Revenue − COGS) ÷ Revenue
EBITDA
$27.2K
Calculated · Jul 2026 · how?
Formula: Revenue − COGS − Operating expenses + D&A
Cash
$3.9M
Actual · Jul 2026 · how?
Formula: Reported cash balance at month end
Net burn (3-mo avg)
-$28.3K
Calculated · Jul 2026 · how?
Formula: Average of −(Δcash − equity raised − debt proceeds) over the last 3 months
Cash balance grew from operations — the company is not burning cash.
Cash runway
Cash-flow positive
Calculated · Jul 2026 · how?
Formula: Cash ÷ average monthly net burn
Not limited by burn (cash-flow positive over the last 3 months).
Backlog coverage
6.4 mo
Calculated · Jul 2026 · how?
Formula: Backlog ÷ average monthly revenue (last 3 months)
Days sales outstanding
49 days
Calculated · Jul 2026 · how?
Formula: AR ÷ average monthly revenue (last 3 months) × 30.42
Working capital
$5.4M
Calculated · Jul 2026 · how?
Formula: Current assets − Current liabilities
Current ratio
4.34
Calculated · Jul 2026 · how?
Formula: Current assets ÷ Current liabilities
Revenue vs budget
Cash balance
EBITDA
Operating expenses
Additional metrics
Revenue growth (YoY)
+9.3%
Calculated · Jul 2026 · how?
Formula: (Revenue this month − same month last year) ÷ same month last year
Revenue (TTM)
$18.9M
Calculated · Jul 2026 · how?
Formula: Sum of the last 12 months of revenue
EBITDA margin
1.4%
Calculated · Jul 2026 · how?
Formula: EBITDA ÷ Revenue
Operating expenses
$165K
Actual · Jul 2026 · how?
Formula: Total operating expenses
Opex trend (3 mo vs prior 3 mo)
0.0%
Calculated · Jul 2026 · how?
Formula: (Avg opex last 3 months − avg prior 3 months) ÷ avg prior 3 months
Accounts receivable
$3M
Actual · Jul 2026 · how?
Formula: Reported AR at month end
Accounts payable
$1.2M
Actual · Jul 2026 · how?
Formula: Reported AP at month end
Days payables outstanding
20 days
Calculated · Jul 2026 · how?
Formula: AP ÷ average monthly (COGS + opex) × 30.42
Approximation: includes payroll, which is rarely in AP.
Revenue per employee (TTM)
$222.3K
Calculated · Jul 2026 · how?
Formula: TTM revenue ÷ headcount
Revenue vs budget
+11.7%
vs budget · Jul 2026 · how?
Formula: (Actual revenue − budget) ÷ budget
Opex vs budget
-2.9%
vs budget · Jul 2026 · how?
Formula: (Actual opex − budget) ÷ budget (positive = over budget)
Largest customer share
43.4%
Calculated · Jul 2026 · how?
Formula: Largest customer's TTM invoiced revenue ÷ total TTM invoiced revenue
Largest customer: County School District. Based on uploaded invoices.
Top 5 customers share
100.0%
Calculated · Jul 2026 · how?
Formula: Top 5 customers' TTM invoiced revenue ÷ total
Accounting notes · Construction
Revenue model: Contracts billed by progress (percentage-of-completion), change orders, retainage
- Over/under-billings (contract assets/liabilities) distort revenue vs invoicing.
- Retainage receivable is collected at completion — exclude from near-term cash forecasts.
- Unapproved change orders are a major leakage source.
No cross-industry benchmarks are applied; alerts compare this company with its own history and budget.