Entrepreneurship and Innovation LabTool 05 of 06

How long will the money last?

Most start-ups that fail do not run out of ideas; they run out of cash. List what it costs to open the doors, what goes out every month, and where the money is coming from. The calculator shows how long the cash lasts with the sales you expect and with none at all, when sales start to cover the bills, and how much more you would need to raise.

Back to 1.1 What is a business? Also for 3.2 Sources of finance, 3.3 Costs and revenues and 3.7 Cash flow

Tool
Start-up cost calculator
IB status
IB content and enrichment; draws on 1.1, 3.2, 3.3, 3.7
Example
Refill Round, fictional; figures simulated
Saved
On this device only

Section 01: Start-up cost calculator

IB content and enrichment Source: Enrichment Source: Simulated data

The example. Refill Round, the fictional subscription refill service, needs electric cargo bikes, reusable bottles and a washing unit before its first delivery. The founders have raised $45,000 from their savings, a family loan, a bank loan, a business angel and rewards crowdfunding. The expected contribution of $1,400 in the first month comes from the revenue planner's first month; the founders assume it grows by 15% a month, more slowly than their revenue forecast, to leave room for error. Every figure is simulated.

Without JavaScript the figures below are for Refill Round's example, and changing an input does not recalculate them.

One-off costs

Paid once, before or as trading starts.

Total one-off costs $27,200

Monthly outgoings

Paid every month whatever the sales, including loan repayments.

Total each month $5,050

Funding

Where the money comes from, and what kind it is.

Total funding $45,000

Sales and settings
Revenue minus variable costs. The revenue planner and unit economics calculator help.

Results

One-off costs
$27,200paid before trading starts
Monthly outgoings
$5,050including loan repayments
Funding
$45,000
Cash at launch
$17,800funding minus one-off costs
Runway with expected sales
5 monthsruns out in month 6
Runway with no sales
3.5 monthscash at launch ÷ monthly outgoings
Sales cover outgoings
Month 11first month contribution ≥ outgoings
Funding gap
$4,275to stay above zero

Reading. Funding of $45,000 covers the one-off costs of $27,200, leaving $17,800 when trading starts. Monthly outgoings are $5,050: with no sales at all, the cash would last 3.5 months. With the expected contribution, the cash runs out in month 6: a runway of 5 months. Contribution first covers the month's outgoings in month 11.

Implication. To stay above zero for the 24 months projected, the plan needs about $4,275 more, lower outgoings or faster growth: the lowest balance is −$4,275 at the end of month 10. Founders usually raise more than the gap, because sales tend to arrive later and grow more slowly than planned.

Your figures are kept on this device only.

Cash in the bank month by month, with the expected sales and with noneCash at launch $17,800. With the expected sales the balance runs out in month 6 and reaches its lowest, −$4,275, at the end of month 10. Sales cover the monthly outgoings from month 11. With no sales the cash would last 3.5 months. The chart shows months 0 to 15.−$10,000$0$10,000$20,000Below zero: more funding needed03691215Month of tradingCash in the bank, $Sales cover outgoings from month 11No sales: 3.5 monthsAt launch $17,800Runs out in month 6Lowest −$4,275, month 10
Cash in the bank at the end of each month with the expected sales (solid blue) and with no sales at all (dashed red). The chart shows the first 15 months, the ones that decide the runway; the table has all 24.

What the funding costs the founders

  • Founders' own money$10,000 · 22%Nothing to repay and no one else to answer to, but the founders carry the whole loss if the business fails.
  • Loan$21,000 · 47%Repaid with interest whatever happens to sales; the founders keep ownership and control.
  • Shares sold to investors$10,000 · 22%Never repaid, but investors own part of the business, share its profits and usually want a say.
  • Pre-sales or rewards crowdfunding$4,000 · 9%Customers pay in advance, so the business owes them the product: the cash comes with a cost still to be paid.

Of the funding, 47% is borrowed and must be repaid whatever happens to sales; 22% was raised by selling shares, so investors share the ownership and the profits; 9% is customers' money paid in advance, owed back as products; 22% is the founders' own money, at risk if the business fails.

Month by month

Opening balance, outgoings, contribution and closing balance each month, and the closing balance with no sales
Month Opening Outgoings Contribution Closing No sales
1$17,800−$5,050$1,400$14,150$12,750
2$14,150−$5,050$1,610$10,710$7,700
3$10,710−$5,050$1,851$7,512$2,650
4$7,512−$5,050$2,129$4,591−$2,400
5$4,591−$5,050$2,449$1,989−$7,450
6 (cash runs out)$1,989−$5,050$2,816−$245−$12,500
7−$245−$5,050$3,238−$2,056−$17,550
8−$2,056−$5,050$3,724−$3,382−$22,600
9−$3,382−$5,050$4,283−$4,150−$27,650
10−$4,150−$5,050$4,925−$4,275−$32,700
11−$4,275−$5,050$5,664−$3,661−$37,750
12−$3,661−$5,050$6,513−$2,198−$42,800
13−$2,198−$5,050$7,490$243−$47,850
14$243−$5,050$8,614$3,807−$52,900
15$3,807−$5,050$9,906$8,663−$57,950
16$8,663−$5,050$11,392$15,004−$63,000
17$15,004−$5,050$13,101$23,055−$68,050
18$23,055−$5,050$15,066$33,071−$73,100
19$33,071−$5,050$17,326$45,347−$78,150
20$45,347−$5,050$19,924$60,221−$83,200
21$60,221−$5,050$22,913$78,084−$88,250
22$78,084−$5,050$26,350$99,384−$93,300
23$99,384−$5,050$30,303$124,637−$98,350
24$124,637−$5,050$34,848$154,435−$103,400

Section 02: How to use it, and what to watch for

Steps

  1. List the one-off costs of starting: equipment, stock, premises, the website, legal fees and the launch.
  2. List the outgoings that recur every month whatever the sales, including loan repayments. Leave out costs that rise with each sale; they are netted off in the contribution.
  3. List the funding by source and say what kind each one is, because a loan, shares and pre-sales cost the founders different things.
  4. Enter the contribution expected in the first month of sales (revenue minus variable costs), how fast it will grow, and the month sales start. Then read the runway and the chart.

Section 03: What the terms mean here

One-off costs

Spending needed once, before or at the start of trading: equipment, fitting out premises, the first stock, launch marketing.

Monthly outgoings

Cash that goes out every month whatever the sales: rent, pay, insurance, software, loan repayments.

Contribution

Revenue minus variable costs: what sales add towards the monthly outgoings.

Burn rate

How fast a start-up spends its cash. Gross burn is the monthly outgoings; net burn is outgoings minus contribution.

Runway

How many months the cash lasts at the expected burn rate before it runs out.

Funding gap

How much more money is needed for the cash never to fall below zero over the months projected.

Section 04: Where it sits in the IB course

Start-up costs, the sources of finance and cash flow are IB content: the challenges of starting up (1.1), sources of finance (3.2), fixed and variable costs (3.3) and cash flow (3.7). Runway and burn rate are enrichment: start-up terms the guide does not use. A full cash flow forecast in the guide's layout is on the Finance Desk.

The ideas behind the tool are in the briefing Funding a start-up: control, risk and the right money.