METRICS DASHBOARD TEMPLATE
The Money Wall · Formulas + Setup + Meeting Agenda
Black Flag Media

===============================================================================
THE MONEY WALL · 11 NUMBERS
===============================================================================

DAILY (3 numbers, 60 seconds):
  1. Cash in bank (operating account balance)
  2. Leads received today
  3. Sales closed today (count + total dollars)

WEEKLY (5 numbers, 10 minutes every Monday):
  4. Revenue for the week
  5. New customers acquired
  6. Response time (median from lead to first reply)
  7. Ad spend for the week
  8. Reviews received this week

MONTHLY (3 numbers, 15 minutes on the 1st):
  9. Gross margin per job (or per customer type)
  10. Customer Acquisition Cost (ad spend / new customers)
  11. Runway (cash / average monthly burn)

===============================================================================
FORMULAS (paste into Google Sheets)
===============================================================================

Gross Margin:      =(SUM(Revenue) - SUM(COGS)) / SUM(Revenue)
CAC:               =SUM(AdSpend) / COUNT(NewCustomers)
Runway (months):   =CashBalance / AverageMonthlyBurn
Lead → Customer:   =COUNT(NewCustomers) / COUNT(Leads)
Rolling Avg (12w): =AVERAGE(OFFSET(A2, 0, 0, 12, 1))
Response Median:   =MEDIAN(ResponseTimeColumn)

Color coding (Conditional Formatting):
  Cash < 30 days burn         → RED
  Response time > 30 min      → RED
  CAC > Avg Sale              → RED
  Gross Margin < 40%          → RED
  Everything else             → AMBER if in yellow zone, GREEN if healthy

===============================================================================
MONDAY MONEY MEETING AGENDA (10 min · every Monday)
===============================================================================

1. OPEN the Money Wall sheet.
2. READ every red cell out loud (even if alone).
3. PICK one red cell to move toward green this week.
4. DECIDE the ONE action to take by Friday.
5. WRITE that action in the "This Week's Move" cell.
6. CLOSE the sheet. Go run the business.

Total time: 10 minutes. Compound impact: massive.

===============================================================================
STARTER TEMPLATE · SIMPLE ROW STRUCTURE
===============================================================================

Date, Cash, Leads, Sales Count, Sales $, Revenue Week, New Customers,
Response Median (min), Ad Spend Week, Reviews Week, Gross Margin %,
CAC, Runway (months), Status (auto-color), This Week's Move

===============================================================================
THRESHOLDS BY BUSINESS SIZE
===============================================================================

Pre-revenue / < $100K/yr:
  Cash: > 60 days burn
  Response: < 15 min
  CAC: < 30% of avg sale
  Gross margin: > 50%

$100K - $500K/yr:
  Cash: > 45 days burn
  Response: < 10 min
  CAC: < 40% of avg sale
  Gross margin: > 45%

$500K+ /yr:
  Cash: > 60 days burn (higher because more overhead)
  Response: < 5 min
  CAC: < 50% of avg sale (can afford more)
  Gross margin: > 40%

Adjust for your industry norms.

===============================================================================
ONE-LINE REMINDER (tape on your monitor)
===============================================================================

Numbers Monday. Every Monday. 10 minutes.
The businesses that grow are the ones that look.