Tracelight Apps
A new kind of deliverable
Flex assumptions, build interactive reports, construct EBITDA bridges, and animate cash flows with interactive apps that calculate live from your sheet.
tracelight.ai
Scenario
Bear
Base
Bull
Drivers
Revenue Growth (m/m)
1.4%
DSO (days)
55
Capex % of Revenue
7%
Pick a scenario or drag any slider — the workbook recalculates in your browser
EBITDA Margin34.0%
Free Cash Flow$1,800,000
Ending Cash$1,816,430
Monthly Cash Balance$2200k$1800k$1600k$1200k$800k$400k
Dec-25Mar-26Jun-26Sep-26Dec-26
AutoSave
Search (Cmd + Ctrl + U)
A1
×✓fx
A
B
C
D
E
1
Line Item
Current
Bear Case
Link App Value
Period
2
Scenario
Bear
Bear
Selected Scenario
Monthly
3
Revenue Growth
0.5%
0.5%
Driver Input
Monthly
4
DSO (days)
75
75
Driver Input
Monthly
5
Capex % of Revenue
12.0%
12.0%
Driver Input
Monthly
6
7
EBITDA Margin (FY)
30.0%
30.0%
KPI Output
2026E
8
Free Cash Flow (FY)
$1,316,430
$1,316,430
KPI Output
2026E
9
Ending Cash
$1,816,430
$1,816,430
KPI Output
2026E
10
11
Monthly Cash Balance
12
Dec-25
$1,481.00
4.30 / 9.60
$1,481.00
2025E
13
Jan-26
$522.00
3.23 / 4.50
$522.00
2025E
14
Mar-26
$1,170.00
15.32 / 10.38
$1,170.00
2024E
15
Jun-26
$648.00
8.53 / 19.80
$648.00
2023E
16
Sept-26
$648.00
8.53 / 19.80
$648.00
2023E
tracelight.ai
Scenario
Bear
Base
Bull
Drivers
Revenue Growth (m/m)
0.5%
DSO (days)
75
Capex % of Revenue
12%
Pick a scenario or drag any slider — the workbook recalculates in your browser
EBITDA Margin30.0%
Free Cash Flow$1,316,430
Ending Cash$1,816,430
Monthly Cash Balance$2200k$1800k$1600k$1200k$800k$400k
Dec-25Mar-26Jun-26Sep-26Dec-26
Interactive
Runs on the spreadsheet
The app runs directly on your spreadsheet's logic. Every figure comes from the model, and every input you change is recalculated within it, live.
tracelight.ai
Scenario
Bear
Base
Bull
Drivers
Revenue Growth (m/m)
0.5%
DSO (days)
75
Capex % of Revenue
12%
Pick a scenario or drag any slider — the workbook recalculates in your browser
EBITDA Margin30.0%
Free Cash Flow$1,316,430
Ending Cash$1,816,430
Monthly Cash Balance$2200k$1800k$1600k$1200k$800k$400k
Dec-25Mar-26Jun-26Sep-26Dec-26
Shared this link
AnyoneEveryone with link can access
Copy
JR
James RuskinOwner
JS
John SmithCan EditCan View
BS
Bob SimonsCan View
CH
Charolette HanlinCan View
Can Edit
Can View
Shareable
Share with a link
Send your app as a link. Access is authenticated, so you control exactly who can open it.
AutoSave
Tracelight
Search (Cmd + Ctrl + U)A1
Metric
FY2024A
FY2025E
FY2026E
FY2027E
FY2028E
1
Revenue
125.0
137.5
151.3
166.4
181.4
2
Revenue Growth
10.0%
10.0%
10.0%
9.0%
3
Gross Profit
81.3
90.8
101.4
112.3
123.4
4
Gross Margin
65.0%
66.0%
67.0%
108.0%
68.0%
5
EBITDA
31.3
35.8
40.8
46.6
52.6
6
EBITDA Margin
25.0%
26.0%
27.0%
28.0%
29.0%
7
D&A
5.0
5.5
6.1
6.7
7.3
8
EBIT
26.3
30.3
34.7
39.9
45.3
9
Capex
6.3
6.9
7.6
8.3
9.1
10
Capex % of Revenue
5.0%
5.0%
5.0%
5.0%
5.0%
11
Revenue
125.0
137.5
151.3
166.4
181.4
12
Revenue Growth
10.0%
10.0%
10.0%
9.0%
13
Gross Profit
81.3
90.8
101.4
112.3
123.4
14
Gross Margin
65.0%
66.0%
67.0%
108.0%
68.0%
15
EBITDA
31.3
35.8
40.8
46.6
52.6
16
EBITDA Margin
25.0%
26.0%
27.0%
28.0%
29.0%
17
D&A
5.0
5.5
6.1
6.7
7.3
18
EBIT
26.3
30.3
34.7
39.9
45.3
19
Capex
6.3
6.9
7.6
8.3
9.1
20
Capex % of Revenue
5.0%
5.0%
5.0%
5.0%
5.0%
Scenario analysis
BaseRunningCompletedUpsideRunningCompletedDownsideRunningCompleted
StressRunningFailed
Gross margin exceeds 100%FY2027E • 108.0% • Output crossed a hard bound. Check the COGS driver.
Dynamic
Stress-test your model by flexing assumptions
Explore hundreds of scenarios to surface cases where the logic breaks
One workflow, across every deliverable
tracelight.ai
TracelightNew Chat
Compare Spreadsheets
Resources
Integrations
Projects
Acme Corp
Spreadsheet Sensitivity Mo…
Chats
Revenue Insights Model
Financial Model Review Snapsh…
Acme Corp/Spreadsheet…
Show research
The project is a spreadsheet sensitivity model built
for animating driver-to-output flow-through, where a
driver block feeds the income statement, working
capital, and cash - recalculating live in the browser
from a small set of assumptions.
•
Drivers
—DSO 45 days•
Full through to
Balance sheetreads “— the model stays internally consistent”
•
Key Metrics
Free Cash FlowEnding Cash
Tracelight
Chat
Audit
Trace
Review this model for formula issues. inconsistent logic, and broken links
Got it. I’ll scan the workbook, trace cross-sheet logic, check key formulas and assumptions, and flag anything that needs review.
Wrote 4 todos
Searchingformulas across workbook
Checkinghardcoded inputs and links
Looking at'IS'!B12:H64
Tracing precedents'IS'!F20:F30
Reviewing
1/5tracelight.ai
Scenario
Bear
Base
Bull
Drivers
Revenue Growth (m/m)12%
→ IS · BS (AR, Equity) · CF
DSO (days)45
→ BS (AR) · CF (ΔWC)
Capex % of Revenue5%
→ IS (D&A) · BS (PP&E) · CF
Pick a scenario or drag any slider - the workbook recalculates in your browser
EBITDA Margin30.0%
Free Cash Flow$1,316,430
Ending Cash$1,816,430
Monthly Cash Balance$2200k$1800k$1600k$1200k$800k$400k
Dec-25Mar-26Jun-26Sep-26Dec-26
AutoSave
A1
×✓fx
Metric
FY2024A
FY2025E
1
Revenue
125.0
137.5
2
Revenue Growth
10.0%
10.0%
3
Gross Profit
81.3
90.8
4
Gross Margin
65.0%
66.0%
5
EBITDA
31.3
35.8
6
EBITDA Margin
25.0%
26.0%
7
D&A
5.0
5.5
8
EBIT
26.3
30.3
9
Capex
6.3
6.9
10
Capex % of Revenue
5.0%
5.0%
11
Revenue
125.0
137.5
12
Revenue Growth
10.0%
10.0%
13
Gross Profit
81.3
90.8
14
Gross Margin
65.0%
66.0%
Key Metrics
$138.2MEnding ARR
$97.1MTotal Revenue
84.4%Gross Margin
ARR scales 22x from FY22 to FY26E, revenue 25x as the cohort base matures
$6.3M$138M