dashboard

4.2 Dashboard

DashboardOverview
Y5 Revenue$68,304,0002.251630824
Y5 EBITDA$33,185,3600.4858479738
Gross Margin Y50.45strong upward
Cash Trough$1,542,698Month 12 (Year 1 end)
24 Month Forecast
$-395k$2.2M$4.8M$7.4M$10.0MM1M5M9M13M17M21M24Share CapitalRevenueOperating ExpensesEBITDACash at end of per
Revenue by Category
$0$125k$250k$375k$500kM1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24Row 281
New Client Growth
025810M1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24
Gross Profit Margin
0%25%50%75%100%M1M11M21M31M41M51M60
Forecast24 Month Forecast
Month 1 Raise$3.0MSeed
Lowest CashMonth 12 (Year 1 end)$1,542,698
EBITDA PositiveMonth 40 (Year 4){{}}
Exit Run Rate$68,304,0005692000
24 Month Forecast - combo: revenue line + EBITDA line + cash bars
$-395k$2.2M$4.8M$7.4M$10.0MM1M5M9M13M17M21M24Share CapitalRevenueOperating ExpensesEBITDACash at end of per
Allocation24 Month Use of Funds Cash Flow
24 Month Use of Funds Cash Flow (waterfall)
$0$3.8M$7.5M$11.2M$15.0MCash InjRevenueCOGSMarketinOverheadProduct Tax PaymCAPEXEnding$8.0M$3.4M$-366k$-1.2M$-2.9M$-2.4M$0$0$4.5M
Use of Funds Allocation (pie / donut)
24M SPEND$6.9MCOGS$366k - 5%Marketing$1.2M - 17%Overheads$2.9M - 43%Product Dev.$2.4M - 35%
Use of Funds Scorecard (KPI tiles)
OVERHEADS$2.9M43% of 24m spendPRODUCT DEV.$2.4M35% of 24m spendMARKETING$1.2M17% of 24m spendCOGS$366k5% of 24m spend
Long View60 Month Forecast + 5 Year Forecast
60 Month Forecast - combo chart
$-2.4M$10.7M$23.8M$36.9M$50.0MM1M11M21M31M41M51M60Share CapitalRevenueOperating ExpensesEBITDACash at end of per
5 Year Forecast - annual summary combo
$-27.7M$4.2M$36.1M$68.1M$100.0MY1Y2Y3Y4Y5Share CapitalRevenueOperating ExpensesEBITDACash at end of per
GrowthNew Client Growth + 60 Months Unit Economics
New Client Growth - monthly cohort bars
025810M1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24
60 Months Unit Economics - LTV / CAC / payback
$0$125k$250k$375k$500kM1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24M25M26M27M28M29M30M31M32M33M34M35M36M37M38M39M40M41M42M43M44M45M46M47M48M49M50M51M52M53M54M55M56M57M58M59M60Row 275Row 276Row 277Row 278
Revenue and COGSRevenue by Category + Cost of Goods Sold
Revenue by Category - stacked column
$0$125k$250k$375k$500kM1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24Row 281
Cost of Goods Sold - stacked column
$0$12k$25k$38k$50kM1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24Row 300Row 301
ProfitabilityGross Profit Margin
GM Y189.17%{{}}
GM Y389.17%{{}}
GM Y50.45{{}}
Trajectorydeclining{{}}
Gross Profit Margin - combo: gross profit bars + margin line
0%25%50%75%100%M1M11M21M31M41M51M60
MarketingMarketing + Marketing Highlights
Marketing - spend by channel column
$0$25k$50k$75k$100kM1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24Row 309Row 310
Marketing Highlights - combo: spend + CAC + leads
$0$12k$25k$38k$50kM1M11M21M31M41M51M60CACLTV / CAC
Operating CostsOverheads + Product Development
Overheads - column by category
$0$25k$50k$75k$100kM1M2M3M4M5M6M7M8M9M10M11M12M13M14M15M16M17M18M19M20M21M22M23M24Row 317
Product Development - column by category
PRODUCT DEV PENDING
PeopleSalary Split + Number of Employees + Revenue per Employee
Salary Split - stacked column
$0$7.5M$15.0M$22.5M$30.0MY1Y2Y3Y4Y5Row 340Row 342Row 343
Number of Employees - column
050100150200Y1Y2Y3Y4Y5Row 346Row 348Row 349
Revenue per Employee - combo
$0$125k$250k$375k$500kY1Y2Y3Y4Y5Revenue / employeeTrend