Every scenario in TreBranch is a safe, live copy of your model. Change three cells in the copy — everything else stays connected to the original. The version that works is always one click away.
You know this folder. TreBranch is one file, and every scenario you ever tried lives inside it.
A toy 3-year deal model, live on this page. Click a scenario, nudge an assumption, and trace a difference to the exact assumption that caused it — the real mechanics of the app.
Click through scenarios, compare two of them down to the driving assumption, flip on dark mode, and run a Monte Carlo risk simulation — recorded live from the app.
Walk an LBO's case fan — Base, Buy-and-Build, Bull/Bear exits — with Gross IRR and MOIC live on every scenario. Compare Base vs Bear down to the leverage assumption, open the Decision Sheet for the IC, then stress a project-finance model's DSCR with a 2,000-trial Monte Carlo.
The three tools that turn a pile of scenario tabs into an actual decision — and that no copy-sheet workflow can do at all.
Bull vs Bear differs by $14M — but why? Compare any two scenarios and TreBranch lists every changed assumption and every output it drives, each difference traced to the exact cell that caused it. No more Ctrl+F across eight tabs.
Give your key assumptions a range — normal, uniform, or triangular — and run thousands of trials. Read P10 / P50 / P90 for every key output with live histograms. The analysis that needs a paid add-in in other spreadsheets, built in.
The Decision Sheet lines up all your scenarios side-by-side — key assumptions, key outputs, live values, probability-weighted expected value. The exhibit you'd spend an hour building by hand, generated in one click and never stale.
Every scenario shows its Key Metrics inline — profit, margin, payback — with deltas vs its parent
Project Cardinal — Base, Buy-and-Build, Bull/Bear exits with Gross IRR & MOIC per scenario, in dark mode
Shake the assumptions, read the distribution — P10 / P50 / P90 and a live histogram for every key output
"3 changed assumptions drive 50 differing outputs" — every difference traced to the assumption driving it
Chart any range — a floating line or bar chart that recalculates as the model changes
All scenarios side-by-side with live values — Key Assumptions and Key Outputs in one shareable panel
One input, a full family of scenarios — TreBranch sweeps a range and creates every one in seconds
Full-time, part-time, and premium positioning — revenue & margin for each scenario at a glance
Every analyst knows the drill: Base_Case_v3_FINAL_USE_THIS.xlsx.
Scenarios drift. A fix on one sheet never makes it to the others. You're maintaining five models simultaneously.
Bull vs Bear differs by $14M. But where? You're Ctrl+F-ing across 8 tabs trying to find the one cell that changed.
Your LP asked "what did the model look like at signing?" — that version is gone, buried under 40 saves.
Every scenario is a safe, live copy of your model. Change one cell and only that cell differs — everything else stays connected to the original. Compare any two scenarios and see the exact assumption that caused the difference, in one click.
Three simple ideas that will change how you model forever.
Picture a tree. Your original spreadsheet is the trunk. A scenario is a "what if?" — like "what if we open a second location?" When you create one, it starts as an exact copy. Change one cell and only that cell is different. Everything else stays connected to the original. Fix a mistake in the trunk? It fixes in every scenario automatically.
Open any two scenarios side-by-side and TreBranch shows every number that's different — then highlights the one cell that caused it all. It's like a detective that finds the one clue that explains the whole case. No more hunting across 8 tabs trying to figure out why the numbers are different.
TreBranch remembers every cell change you've ever made — like a video game save file. Need to see what the model looked like before last week's assumptions changed? Just scroll the history. Found it? Turn that old snapshot into a brand new scenario — without losing any of your current work.
No half-measures. No browser tab. Full desktop power with a spreadsheet you actually understand.
Create as many scenarios as you need. The tree is always your source of truth — and scenarios can never leak into each other.
A floating panel shows every cell that differs between any two scenarios, sorted by impact, traced to the root assumption.
Pick any input cell, define a range, hit Sweep — TreBranch auto-generates a full family of scenarios with charts ready.
Set a target output and let TreBranch back-solve for the input. Works in every scenario, with the full history kept.
Auto-generated side-by-side comparison of every scenario with charts, delta bars, and probability weighting.
Every cell change is recorded. Scrub back in time, start a new scenario from any past state, audit the full change log.
FILTER, UNIQUE, SORT, XLOOKUP, XLOOKUPALL, MEDIANIFS, STDEVIFS, WAVERAGE, REGEX*, DATEADD, dynamic array spill.
Save, open, and share files locally. Works fully offline. No cloud dependency — your model stays yours.
No cloud, no sync, no subscription. Your models stay on your machine. Works on a plane, in a data room, or anywhere with no internet.
Open any .csv or .xlsx file directly in TreBranch. Bring your existing models with you and start exploring scenarios immediately — no re-entry required.
Export the active scenario to .csv or Excel for clients, boards, or anyone who lives in Excel. Final outputs leave TreBranch cleanly — nothing to install on their end.
One toggle turns on cell highlighting for every value you've changed from the parent scenario. See your changes at a glance — green means you own it here.
Whether you're modeling a buyout or planning a coffee chain expansion, TreBranch removes the copy-sheet tax.
Model base, bull, and bear cases from a single source. Sweep entry multiples, generate sensitivity scenarios automatically, and show LPs exactly which assumption drives the difference.
Model capacity scenarios — what happens if you add 2 ORs vs 4? What if patient volume grows 15%? Spin a scenario off your base plan and compare outcomes instantly.
Fundraising scenarios, hiring plan sensitivities, runway calculations — model them all in one file. Show investors the bull/bear/base in a single, clean Decision Sheet.
New store openings, pricing changes, supply chain scenarios — model every what-if without duplicating your entire model. Scenario the coffee chain expansion and let the numbers flow.
Build/buy/partner scenarios, synergy modeling, integration planning — TreBranch handles the complexity so the strategy conversation can be about outcomes, not spreadsheet maintenance.
TreBranch ships with features built specifically for scenario modeling — things that should have existed in Excel 20 years ago.
Right-click any input cell → Sweep. Set a range (e.g. growth rate 4%–14%). TreBranch auto-creates a scenario for every step — with a bar chart ready. Ten scenarios in 10 seconds.
Know the answer you need but not the input? Set a target — like "IRR ≥ 20%" — and Solve backs out exactly which growth rate, price, or margin gets you there.
Mark any cell as a Key Metric and it shows up in the sidebar for every scenario — so you can see IRR, revenue, or payback across the whole tree without opening the model.
Select any two scenarios and the Compare panel instantly lists every cell that changed — sorted by impact — and pinpoints the single root assumption driving the whole difference.
One click opens a live side-by-side table of all your scenarios — Key Metrics, Key Assumptions, and charts together. The fastest way to present options to a room.
Every cell change is stored forever. Scroll back to any point in time and see exactly what the model looked like. Find the right moment? Turn it into a new scenario without touching current work.
Open any .csv or .xlsx file in TreBranch. Bring your existing models with you — no re-entry needed. Your data comes in ready to explore.
Export the active scenario to .csv or Excel for sharing with anyone — no TreBranch required. Final outputs leave cleanly for clients, boards, or anyone who lives in Excel.
One button highlights every cell in the grid that differs from the parent scenario — green means you changed it here. See your changes at a glance, no separate panel needed.
300+ standard functions — IRR, XIRR, NPV, SUMIFS, XLOOKUP, dynamic arrays that spill — plus a set you won't find in other popular spreadsheets.
XLOOKUPALL(key, range, return)
The wished-for lookup: returns every match, spilled as a column — not just the first hit.
XLOOKUPJOIN(key, range, return, ", ")
All matches joined in one cell — "Ann, Cy, Bob" — perfect for labels and summaries.
XLOOKUP2(key1, r1, key2, r2, return)
Two-criteria lookup in a single call. No helper columns, no INDEX/MATCH gymnastics.
MEDIANIFS · MODEIFS · QUARTILEIFS
The conditional statistics spreadsheets never shipped. Median deal size by sector, one formula.
STDEVIFS(range, criteria…)
Conditional volatility — standard deviation over exactly the rows that match.
WAVERAGE(values, weights)
Weighted average as a first-class function. Retire the SUMPRODUCT÷SUM ritual.
REGEXMATCH · REGEXEXTRACT · REGEXREPLACE
Real regular expressions over text — match, extract, and rewrite messy data with one formula.
EXTRACTNUMBER("$1,240/mo")
Pulls the number out of messy text → 1240. Pastes from PDFs become data.
COUNTUNIQUE(range)
Distinct count in one function — no SUMPRODUCT(1/COUNTIF()) incantations.
DATEADD(date, n, "m")
Date math that reads like English — add days, months, or years without EDATE edge cases.
NUMBERTOWORDS(1250)
→ "one thousand two hundred fifty" — for invoices, checks, and letters.
FILTER · UNIQUE · SORT · SEQUENCE
Full dynamic arrays that spill — and recalculate across every scenario and point in time.
Every fix applied to one copy has to be re-applied to all the others. Put your numbers in — this runs entirely on this page.
Scenario modeling best practices, TreBranch walkthroughs, and financial analysis ideas — straight to the point.
Questions, feedback, or suggestions? We read every message and reply to every one.