Business Viability Dashboard
—Yr 1 take-away /mo
—Yr 1 coverage /mo
—Runway
What this is. A cash model for deciding whether starting or buying a small business actually works
— for you, not just for the business. You enter what you have, what it costs to get set up, what you need
to live on, what the business costs to run, and a few revenue scenarios. It tells you whether the money
lasts, and for how long.
How to use it. Work down the page in order; every figure is yours to change and nothing is required. The tab bar at the top holds independent scenarios — the Example — service business tab is filled in so you can see a complete model, and My plan is empty for your own. Duplicate a tab (⧉) to try a what-if without disturbing the original. Everything is saved in this browser only; use Export JSON to back it up or move it.
How to use it. Work down the page in order; every figure is yours to change and nothing is required. The tab bar at the top holds independent scenarios — the Example — service business tab is filled in so you can see a complete model, and My plan is empty for your own. Duplicate a tab (⧉) to try a what-if without disturbing the original. Everything is saved in this browser only; use Export JSON to back it up or move it.
Available funds
Everything you can put on the table. Type in either currency — the other updates instantly.
⇄
Leave the second currency blank if you
only work in one. When set, the funds box and the relocation sheet show both, linked by the rate.
Relocation & setup
One-off cost of getting set up — moving, visas, deposits, anything you pay once before
trading starts. With a second currency set, each row shows both and either side updates the other.
Personal living expenses
Monthly household cost of living. Add or delete any row. With two people, each row is
split 50/50 by default — click 50/50 in the Who pays column to flip a row to Mine.
Business startup cost
The one-off cost of opening the doors. This plus relocation is what comes out of your funds before month 1.
Business running costs monthly burn
One tab per period of the ramp-up. Duplicate a tab to model months 0–6 / 6–8 / 8+ separately. The
Salaries row is calculated from the staff table below it.
Staff for this phase
Whoever is on the payroll during this phase. Their total feeds the Salaries row above.
Rate — what the person is paid, in whatever unit the Pay basis says. Pick
Yearly salary and it's their gross salary per year; Monthly salary is per month;
Hourly is per hour (then set hours / week). Each box says its own unit underneath.
This is gross pay — what lands on their payslip before their own tax is withheld, not what
they cost you.
Paying by the project — three ways. They differ only in where the project count comes from, and that is what decides whether the pay moves when work picks up:
Per project (set count) — a set amount per project, and you type how many. Count them per month or per year, whichever way you think about it; the box under the count switches between the two and the monthly cost is identical either way (40 a year is 3.3 a month). Because the count is yours, this line does not move when your revenue does — right for someone who only takes the overflow, a fixed retainer of work, or a set number of installs.
Per project (from income) — the same amount per project, but the count is read straight from the Projects row of your income projections, for the months this phase covers. Nothing to type and nothing to keep in sync: raise the project count there, or switch to a bigger scenario, and this pay follows. Right for someone who is paid on every project you do. It shows $0 until that sheet has a project count — type a Projects or an Avg / project figure and it appears.
% of each project — a cut of what the project bills: commission, a partner's share, a finder's fee. Enter just the percentage; no count is needed at all, because taking 10% of every project is the same number as 10% of everything you bill that month, which the income projection already gives. It moves with revenue like the one above. If the person only takes a cut of some of the work, use their share of total billing rather than their headline rate — 20% of the half of the projects they touch is 10% overall.
Burden % — the extra you pay on top of their gross pay, as a percentage of it: the employer's share of payroll taxes and social contributions, unemployment or redundancy funds, and any compulsory employer insurance. It varies a lot by country and by trade — in the US it is commonly 10–15% for an employee (the employer half of Social Security and Medicare alone is 7.65%), while elsewhere employer contributions can be considerably higher. Put in your own country's number and confirm it with an accountant. A self-employed contractor who invoices you is normally 0% — they pay all of it themselves, which is why their headline rate is higher.
So Cost to you = gross pay × (1 + burden%), and that is the figure the business actually spends.
One warning about income-linked pay and break-even. Pay that follows your revenue never gets you closer to covering your fixed costs — every extra dollar billed hands part of itself straight back. That is true of % of each project, and just as true of Per project (from income), because the income sheet keeps the average project value fixed and adds projects when gross rises, so more billing means more of them to pay for. The Break-even gross revenue row on the Conclusions tab accounts for both, treating them like a material cost — a slice off the top, not a fixed monthly bill. If those slices and materials together ever reach 100% of a project, break-even shows —, because no amount of revenue would get you there.
Paying by the project — three ways. They differ only in where the project count comes from, and that is what decides whether the pay moves when work picks up:
Per project (set count) — a set amount per project, and you type how many. Count them per month or per year, whichever way you think about it; the box under the count switches between the two and the monthly cost is identical either way (40 a year is 3.3 a month). Because the count is yours, this line does not move when your revenue does — right for someone who only takes the overflow, a fixed retainer of work, or a set number of installs.
Per project (from income) — the same amount per project, but the count is read straight from the Projects row of your income projections, for the months this phase covers. Nothing to type and nothing to keep in sync: raise the project count there, or switch to a bigger scenario, and this pay follows. Right for someone who is paid on every project you do. It shows $0 until that sheet has a project count — type a Projects or an Avg / project figure and it appears.
% of each project — a cut of what the project bills: commission, a partner's share, a finder's fee. Enter just the percentage; no count is needed at all, because taking 10% of every project is the same number as 10% of everything you bill that month, which the income projection already gives. It moves with revenue like the one above. If the person only takes a cut of some of the work, use their share of total billing rather than their headline rate — 20% of the half of the projects they touch is 10% overall.
Burden % — the extra you pay on top of their gross pay, as a percentage of it: the employer's share of payroll taxes and social contributions, unemployment or redundancy funds, and any compulsory employer insurance. It varies a lot by country and by trade — in the US it is commonly 10–15% for an employee (the employer half of Social Security and Medicare alone is 7.65%), while elsewhere employer contributions can be considerably higher. Put in your own country's number and confirm it with an accountant. A self-employed contractor who invoices you is normally 0% — they pay all of it themselves, which is why their headline rate is higher.
So Cost to you = gross pay × (1 + burden%), and that is the figure the business actually spends.
One warning about income-linked pay and break-even. Pay that follows your revenue never gets you closer to covering your fixed costs — every extra dollar billed hands part of itself straight back. That is true of % of each project, and just as true of Per project (from income), because the income sheet keeps the average project value fixed and adds projects when gross rises, so more billing means more of them to pay for. The Break-even gross revenue row on the Conclusions tab accounts for both, treating them like a material cost — a slice off the top, not a fixed monthly bill. If those slices and materials together ever reach 100% of a project, break-even shows —, because no amount of revenue would get you there.
One-time expenses
Unplanned or non-recurring spend after launch. These feed the yearly conclusion below.
Business income projections
Each row is a gross-revenue scenario, set per year — pick a year tab and type that year's figures.
Years past the last tab reuse it. Materials come off first, then that year's running burn, then the one-time share.
Swap the sheet between yearly and monthly — it just ×12 or ÷12 every figure, the model underneath is the same.
Conclusions
Cash timeline
Your cash balance month by month: funds, minus relocation and startup, plus what the business
leaves you, minus your share of living costs. Phase burn switches automatically at the month boundaries you set.
Cash in the black
Cash gone / in the red
Balance line
Phase boundary