155. Startup Calculators

Calculators are not truth machines. They are structured guesses.

Use them to expose assumptions, compare scenarios, and decide what to do next. Do not use them to create fake certainty.

Finance calculators

Calculator	Basic formula	Founder use
Runway	Cash in bank divided by monthly net burn	Shows how many months you can operate.
Gross burn	Total monthly cash expenses	Shows spending pace before revenue.
Net burn	Cash expenses minus cash collected	Shows actual monthly cash loss.
Break-even	Fixed costs divided by contribution margin per unit	Shows required volume or revenue for operating break-even.
Hiring cost	Salary plus benefits, tools, recruiting, onboarding, and management time	Prevents underestimating the true cost of hiring.

Runway example

If cash in bank is Rs 60,00,000 and net burn is Rs 10,00,000 per month, runway is 6 months.

But founders should also model:

• Conservative case: revenue slips, collections slow, expenses rise
• Base case: current trend continues
• Upside case: revenue grows and collections improve

Runway is not just a number. It is a decision clock.

Acquisition and revenue calculators

Calculator	Basic formula	Founder use
CAC	Sales and marketing cost divided by new customers acquired	Shows acquisition cost by channel or segment.
CAC payback	CAC divided by monthly gross profit per customer	Shows how long cash is tied up.
LTV	Average gross profit per customer over expected lifetime	Useful only when retention history is credible.
LTV/CAC	LTV divided by CAC	Broad efficiency signal, dangerous if LTV is guessed.
Sales velocity	Opportunities times win rate times average deal size divided by sales cycle length	Shows how pipeline turns into revenue.

CAC example

If you spend Rs 2,00,000 on a channel and acquire 10 customers, cash CAC is Rs 20,000.

Then ask:

• Were these customers qualified?
• Did they activate?
• Did they pay?
• Did they retain?
• Did you include founder time, tools, commissions, agency fees, and events?

Cheap CAC with poor retention is expensive.

SaaS calculators

Calculator	Basic formula	Founder use
MRR	Sum of recurring monthly subscription revenue	Shows recurring revenue base.
ARR	MRR multiplied by 12	Annualized view of recurring revenue.
Net new MRR	New MRR plus expansion MRR minus contraction MRR minus churned MRR	Shows revenue movement quality.
Logo churn	Customers lost divided by starting customers	Shows account loss.
Revenue churn	Revenue lost divided by starting revenue	Shows revenue loss.
GRR	Revenue retained before expansion divided by starting revenue	Measures retention quality.
NRR	Revenue after expansion, contraction, and churn divided by starting revenue	Measures whether existing revenue expands or shrinks.

Churn example

If you start the month with 50 customers and lose 3, logo churn is 6 percent for that month.

But if the 3 customers were your largest accounts, revenue churn may be much higher. Always review logo churn and revenue churn together.

Fundraising and ownership calculators

Calculator	Basic idea	Founder use
Dilution	New investor ownership reduces existing ownership percentage	Helps founders understand the cost of capital.
ESOP pool impact	Option pool size affects founder and investor ownership	Helps plan hiring and negotiation.
Post-money ownership	Investment divided by post-money valuation	Shows investor percentage in a priced round.
Use of funds	Planned spend by milestone	Connects fundraising amount to progress.

These calculations affect legal and economic rights. Treat them as planning tools, then review actual terms with qualified counsel.

Dilution example

If a company raises Rs 1 crore at a Rs 9 crore pre-money valuation, the post-money valuation is Rs 10 crore. The new investor owns 10 percent after the round, before considering option pool changes or other terms.

Founder questions:

• Is the option pool created before or after the investment?
• Are there existing notes, SAFEs, CCPS, or other instruments that convert?
• What ownership do founders, employees, and investors have after the full round?
• What rights come with the shares, not just the percentage?

The percentage is only one part of the deal. Control, preferences, governance, and future financing terms also matter.

Pricing calculators

Calculator	Founder use
Cost-plus floor	Finds the minimum price needed to avoid losing money.
Value-based price	Estimates price from customer value created, saved, or protected.
Willingness-to-pay range	Compares price signals from customer conversations and pilots.
Gross margin by plan	Shows whether each plan can scale profitably.
Discount impact	Shows how discounts affect payback and perceived value.

Pricing is not only math. It is positioning, buyer psychology, sales motion, and value proof.

Pricing floor worksheet

Use this before offering discounts.

Input	Value
Direct cost to serve one customer	Rs.
Onboarding/support cost	Rs.
Payment gateway/platform/vendor cost	Rs.
Expected gross margin target	%
Minimum viable monthly price	Rs.
Founder time required	Hours
Custom work required	Yes/No

If a customer needs high support, the plan should either cost more or include less. Low price plus high service is how founders accidentally build a stressful agency.

Sales velocity calculator

Formula:

Number of opportunities x win rate x average deal value / average sales cycle length

Use it to understand whether pipeline is real.

Input	Example
Opportunities	20 qualified deals
Win rate	25 percent
Average deal value	Rs 2,00,000
Sales cycle	60 days
Sales velocity	About Rs 16,667 per day of pipeline movement

Founder interpretation:

• More opportunities help only if they are qualified.
• A higher win rate may come from narrowing ICP.
• Larger deals may slow sales cycles and increase support.
• A shorter cycle may come from better proof, urgency, or buyer access.

Scenario table

Every calculator should have scenarios.

Metric	Conservative	Base	Upside	Decision affected
Monthly net burn				Hiring/fundraising/cost cuts
Collections				Cash planning
CAC				Channel budget
Churn				Product/customer success focus
Sales cycle				Pipeline forecast
Gross margin				Pricing/delivery model

If the company survives only in the upside case, the plan is fragile.

Calculator discipline

For every calculator, write:

• Inputs
• Source of each input
• Confidence level
• Best case
• Base case
• Worst case
• Decision affected
• Date last updated

If the input is a guess, label it as a guess. Honesty beats precision.

Input confidence table

A calculator is only as strong as its inputs. Add confidence before discussing the output.

Input type	Confidence level	How to treat it
Actual cash in bank	High	Use directly, but reconcile with bank/accounting records.
Cash collected from customers	High if reconciled	Separate collected cash from booked revenue and signed contracts.
Current monthly expenses	Medium to high	Include upcoming hires, annual software renewals, taxes, refunds, and vendor dues.
Pipeline value	Low to medium	Discount by stage, buyer clarity, next step, sales cycle, and probability.
CAC from a new channel	Low	Treat as experiment data until quality and retention are visible.
LTV before retention history	Low	Use scenarios, not a single confident number.
Churn from a tiny customer base	Low to medium	Inspect individual customer stories instead of relying on the percentage.
Market size assumptions	Low until bottom-up	Use to compare opportunity direction, not to prove certainty.

If a decision depends on low-confidence inputs, reduce the size of the decision. Run a smaller test, delay the hire, narrow the channel, or add a review date.

Calculator decision triggers

Use calculators to force decisions, not to decorate updates.

Calculator signal	Possible decision
Runway below 6 months and fundraising not started	Freeze non-critical hiring, tighten collections, prepare fundraising or cost plan.
Runway below 3 months	Move from optimization mode to survival mode: cash, cuts, collection, bridge, sale, or shutdown options.
CAC payback too long for current cash position	Narrow ICP, improve activation, raise price, reduce sales cost, or pause the channel.
Gross margin weak because of support/manual work	Increase price, reduce service scope, productize repeated work, or reposition as service-led.
Churn concentrated in one segment	Stop selling to that segment until the cause is understood.
Sales cycle expands every month	Recheck buyer, urgency, procurement, proof, pricing, and champion strength.
Pipeline grows but cash does not	Review qualification, closing, invoicing, collections, and payment terms separately.
Hiring cost shortens runway below a milestone	Delay, hire part-time/contract, cut elsewhere, or raise before committing.

The number is not the point. The decision is the point.

Assumption register

Every serious calculator should keep an assumption register. This is where founders separate facts, estimates, and hopes.

Assumption	Current value	Source	Confidence	Owner	Review trigger
Monthly burn		Bank/accounting/model	High/medium/low		End of month
Sales cycle		CRM or founder notes	High/medium/low		After 10 new opportunities
Conversion rate		Funnel data	High/medium/low		After campaign/pipeline review
Churn		Cohort/customer list	High/medium/low		Monthly
CAC		Channel spend and customers acquired	High/medium/low		After each channel experiment
Gross margin		Revenue and direct costs	High/medium/low		Monthly
Hiring cost		Salary plus tools, taxes, management, recruiting	High/medium/low		Before offer

The register protects the company from spreadsheet confidence. When an assumption is weak, the decision should be smaller, more reversible, or reviewed sooner.

Founder finance review rhythm

Use calculators in a rhythm, not randomly.

Rhythm	Calculators to review	Decision it supports
Weekly during cash pressure	Cash in bank, collections, net burn, runway	Survival, cuts, collection focus, bridge planning.
Monthly operating review	Burn, revenue, margin, churn, pipeline, hiring cost	Hiring, pricing, GTM, product/customer success focus.
Before a hire	Runway after hire, milestone impact, management capacity	Whether to hire, delay, contract, or narrow role.
Before channel spend	CAC, payback, activation, retention, gross margin	Whether to scale, change, or stop the channel.
Before fundraising	Runway, use of funds, dilution, milestone model	Round size, timing, narrative, investor readiness.

If a calculator is not tied to a decision, it becomes admin. If it is tied to a decision, it becomes operating leverage.

India cash reality adjustments

Indian startups should often adjust calculators for cash reality, not only accounting revenue.

Area	Adjustment
B2B collections	Separate signed contract, invoice raised, payment due, cash received, and overdue amount.
GST and taxes	Model tax timing and advisor-reviewed treatment separately from revenue.
TDS/withholding	Track deductions and reconciliation where relevant.
Payment gateway/UPI/platform fees	Include transaction costs in contribution margin.
Implementation/support	Count founder, ops, training, WhatsApp, phone, and field effort where relevant.
Annual software renewals	Spread or reserve for large renewals that can surprise runway.
Foreign revenue	Track currency, payment fees, settlement timing, and compliance/advisor questions.

A beautiful P&L can still hide a cash problem. Founders should run the company from cash reality first.

Mini calculator examples

Use these examples as formats for your own spreadsheet.

Runway after hiring

Item	Amount
Cash in bank	Rs 60,00,000
Current net burn	Rs 8,00,000/month
Planned hire total monthly cost	Rs 2,50,000/month
New net burn	Rs 10,50,000/month
Runway before hire	7.5 months
Runway after hire	5.7 months

Founder question: does this hire create a milestone that is worth losing 1.8 months of runway?

Collection-adjusted runway

Item	Amount
Cash in bank	Rs 40,00,000
Booked monthly revenue	Rs 12,00,000
Average cash collected monthly	Rs 7,00,000
Gross burn	Rs 15,00,000
Net burn using booked revenue	Rs 3,00,000
Net burn using collected cash	Rs 8,00,000

Founder question: are we managing runway from actual cash or optimistic accounting?

Discount impact

Item	No discount	25 percent discount
Monthly price	Rs 40,000	Rs 30,000
Gross margin	75 percent	67 percent if service cost stays fixed
CAC payback	5 months	7+ months
Customer expectation	Standard plan	May expect negotiation every renewal

Founder question: is the discount buying speed, proof, reference value, or just avoiding a hard pricing conversation?

Common calculator mistakes

• Treating booked revenue as collected cash.
• Averaging CAC across channels with very different customer quality.
• Using LTV before retention history exists.
• Ignoring founder time in early sales and support.
• Ignoring gross margin when revenue grows.
• Treating pipeline as revenue.
• Forgetting GST, payment delays, refunds, discounts, or implementation cost where relevant.
• Making the spreadsheet look precise while the inputs are guesses.

Formula quick sheet

Use this as a starting point, then adapt definitions to your business.

Metric	Simple formula	Founder caution
Gross burn	Total cash expenses per month	Include founder salaries, tools, contractors, rent, cloud, advisors, marketing, travel.
Net burn	Cash out minus cash collected	Use collected cash, not only booked revenue.
Runway	Cash in bank / net monthly burn	Recalculate after hiring, collection delays, or revenue changes.
Gross margin	(Revenue - direct delivery cost) / revenue	Include support, implementation, transaction fees, hosting, and service costs where relevant.
CAC	Sales and marketing cost / new customers acquired	Segment by channel and customer quality.
Payback	CAC / monthly gross profit per customer	Do not use revenue if margin is low.
Churn	Customers lost / starting customers	Track logo churn and revenue churn separately where useful.
Expansion	Expansion revenue / starting revenue	Separate true expansion from delayed billing or one-time setup.
Sales velocity	Opportunities x win rate x deal value / sales cycle	Garbage in, garbage out; qualify opportunities honestly.

The formula is less important than consistent definition. A startup should not change metric definitions whenever the story needs help.

Calculator review prompts

Use these prompts after updating a calculator.

Calculator	Founder question
Runway	What decision changes if this number is true?
Burn	Which expense is not buying learning, revenue, retention, quality, or risk reduction?
Collections	Which customer needs a founder-level follow-up?
CAC/payback	Which channel looks good only because we ignore low-quality leads or founder time?
Pricing	Which discount teaches us something, and which discount is fear?
Gross margin	Which customer type is quietly unprofitable?
Hiring cost	What milestone must this hire unlock before runway cost is justified?
Fundraising dilution	What ownership and control will remain after this and the next round?

Calculators should create questions that change behavior.

Decision thresholds

Write thresholds before the numbers arrive.

Area	Example threshold
Runway	If runway falls below 9 months, pause discretionary hiring and review burn weekly.
Collections	If overdue receivables exceed one month of burn, collections becomes a founder priority.
Channel spend	If payback is not credible after a defined test, stop or change the channel.
Hiring	If the hire reduces runway below the agreed threshold without a clear milestone, delay or redesign the role.
Pricing	If discounting becomes the default close tactic, revisit value, buyer, and packaging.
Margin	If gross margin worsens as revenue grows, inspect support, implementation, hosting, and transaction costs.

Thresholds reduce emotional decision-making. They also make hard conversations easier because the rule was written before the pressure peaked.

Weekly calculator bundle

For a small startup, these five calculations are enough for most weekly operating reviews.

Calculator	Input	Decision it should inform
Runway	Cash in bank, net burn, expected collections.	Do we need to cut, sell harder, fundraise, or delay hiring?
Pipeline quality	Qualified opportunities, win rate, deal size, cycle.	Which deals deserve founder attention?
Activation	New customers/users reaching first value.	Is onboarding or product value working?
Gross margin / delivery cost	Revenue minus direct delivery and support cost.	Are we selling profitable value or expensive custom work?
Collections	Invoices due, overdue amount, owner, next action.	Which cash conversation must happen this week?

Weekly output:

One number improved:
One number worsened:
One assumption changed:
One founder decision required:
One action before next review:

If a calculator does not change a decision, stop updating it weekly. Keep the finance system useful, not ornamental.

Input quality checklist

Before trusting a calculator, grade the inputs.

Input type	Strong input	Weak input
Cash	Bank balance and committed payments.	Memory or outdated spreadsheet.
Revenue	Signed invoices, subscriptions, collections.	Verbal pipeline or optimistic forecast.
Pipeline	Qualified opportunities with buyer, need, timing, and next step.	Everyone who liked a demo.
CAC	Actual channel spend and closed customers.	Blended marketing spend and weak attribution.
Churn	Cohort-based lost customers/revenue.	Anecdotal “customers seem happy.”
Gross margin	Includes delivery, support, hosting, transaction, implementation.	Revenue minus only obvious direct costs.
Hiring cost	Salary, taxes/benefits/advisors/equipment/tools/management time.	Salary only.

If an input is weak, label it. A labelled weak input is useful. An unlabelled weak input creates false confidence.

Copy-paste dilution calculator

Use this to understand a round before terms get emotional.

Item	Value
Current founder ownership
Current investor/other ownership
Current ESOP pool
Pre-money valuation
New money raised
Post-money valuation	Pre-money + new money
New investor ownership	New money / post-money
ESOP increase before round
Founder ownership after round

Founder questions:

• What ownership remains after this round?
• What ownership remains after the next likely round?
• Is the ESOP increase coming from founders before investment or everyone after investment?
• Does the dilution buy a milestone that materially increases company value?
• Are control rights changing, not only ownership percentages?

Dilution is not automatically bad. Unclear dilution is bad.

Copy-paste sales velocity calculator

Use only for qualified pipeline.

Input	Value
Qualified opportunities
Average deal value
Win rate
Average sales cycle in days
Sales velocity	Opportunities x deal value x win rate / sales cycle

Example interpretation:

Pattern	Meaning
Opportunities increasing, win rate falling	Targeting or qualification is weak.
Deal value rising, cycle lengthening	Enterprise path may need more process.
Win rate high, opportunities low	Distribution is the bottleneck.
Cycle short, churn high	You may be selling to low-quality customers.

Do not use sales velocity to make bad pipeline look scientific. Remove deals without buyer, budget path, urgency, and next step.

Copy-paste break-even calculator

Use this when deciding whether the company can become self-sustaining.

Item	Value
Monthly fixed cost
Average revenue per customer
Gross margin
Gross profit per customer	Revenue x gross margin
Customers needed to cover fixed cost	Fixed cost / gross profit per customer
Current customers
Gap

Founder questions:

• Is the required customer count realistic for the current sales motion?
• Does support load increase linearly with customers?
• Are collections reliable enough to count this revenue?
• Would price, packaging, or segment change the break-even path?

Calculator Sanity Review

Before using a calculator result in a board update, investor memo, hiring decision, or fundraising pitch, run a sanity review.

Review question	Why it matters
What inputs are actuals, committed, forecast, or guesses?	Prevents fake precision.
Which number changes the answer most?	Shows the main assumption risk.
Is cash collection different from revenue?	Indian startups often face payment delays, credit terms, and collection gaps.
Are hidden costs included?	Support, founder time, services, infra, refunds, taxes, compliance, and payment fees matter.
Does the result hold by segment or only in aggregate?	Blended averages can hide bad customers or channels.
What decision will this calculator change?	If no decision changes, the calculation is noise.

Write the conclusion in plain language:

If [input] is true, we can [decision].
If [input] is wrong by [amount], we must [fallback].

Calculators are decision aids, not truth machines. The founder’s job is to make assumptions visible before they become commitments.

Related chapters

• 89. Startup Finance Basics
• 92. Startup Metrics Basics
• 94. SaaS Metrics
• 58. Pricing and Negotiation
• 152. Finance Templates