Free Resources

This Excel template, “Cash Burn Rate and Runway,” provides practical examples for calculating Burn Rate and Cash Runway using two widely used approaches.

1) Direct Method: Cash Flow Basis

The most accurate approach is based on actual cash movements from bank statements. The template demonstrates how to:

1. Sum all operating cash outflows (e.g., payroll, rent, marketing, suppliers, other operating expenses)

2. Sum all operating cash inflows (e.g., customer receipts, advances received, other operating inflows)

3. Calculate the net cash movement for each month (inflows minus outflows)

4. Average the results across the period to determine the monthly burn rate

This method provides clear visibility into monthly cash consumption patterns, including seasonality, timing effects, and short-term volatility.

2) Alternative Quick Method: Balance Sheet Approach

Investors often use a faster, high-level method based on the change in cash balances over a period:

Net Burn Rate = (Opening Cash Balance − Closing Cash Balance) ÷ Number of Months

Example:

• Opening cash balance (1 January): £1,000,000

• Closing cash balance (31 December): £160,000

• Period: 12 months

Net Burn Rate = (£1,000,000 − £160,000) ÷ 12 = £70,000 per month

This approach is efficient for quick assessments and trend snapshots, but it is less detailed: it does not show month-to-month fluctuations, and it may blend operational burn with one-off items or non-operating cash movements.

A cap table (short for capitalisation table) is a document—usually a spreadsheet—that shows the ownership structure of a company. It outlines who owns what in terms of shares, options and other equity instruments.

What a Cap Table Includes:

• Founders’ equity (how much each founder owns)
• Investors’ shares (from different funding rounds)
• Stock options (allocated to employees or advisors)
• Convertible notes or SAFEs
• Valuation info (pre – and post – money)

What a Cap Table Includes:

• Helps track equity dilution as new funding rounds happen
• Essential during fundraising, mergers, or exits
• Used by founders, investors, accountants, and legal teams
• Gives a clear picture of who owns what stake

financial model depicts a company’s performance by combining historical data, assumptions and forecasts. It projects future income, expenses and cash flow, providing essential insights for business decisions, investment assessment and growth planning.

A Monthly P&L Review is the regular analysis of a company’s income statement to assess its financial performance over a given month. It compares revenues, costs, and expenses to track profitability, spot trends, and make informed decisions.

Why Monthly P&L Reviews Are Important:

• Monitor Financial Health :
  Helps ensure the business is profitable and on track with its financial goals.

• Identify Trends :
  Monthly reviews reveal revenue growth, cost spikes, or seasonal patterns that may require strategic action.

• Control Costs :
  Allows leaders to detect and manage overspending before it becomes a bigger issue.

• Improve Decision-Making :
  Provides timely insights for budgeting, forecasting, and resource allocation.

• Accountability :
  Encourages departments to stay aligned with budgets and targets.

• Investor and Stakeholder Confidence :
  Demonstrates financial discipline and transparency.

Essential KPIs (Key Performance Indicators) are the most important metrics used to measure the performance and success of a business or specific business area. These KPIs give decision-makers clear, quantifiable insights into how well the company is meeting its goals.

Examples of Essential KPIs

Financial KPIs

• Revenue Growth – Measures the increase in sales over time
• Gross Profit Margin – Shows how efficiently a company produces its goods/services
• Net Profit Margin – Indicates how much profit is made after all expenses
• EBITDA – Earnings before interest, tax, depreciation, and amortisation
• Operating Cash Flow – Tracks the cash generated from normal business operations

Customer KPIs

• Customer Acquisition Cost (CAC) – Cost to acquire a new customer
• Customer Lifetime Value (CLV) – Value a customer brings over their lifespan
• Customer Retention Rate – Percentage of customers who stay over time
• Net Promoter Score (NPS) – Measures customer satisfaction and loyalty

Operational KPIs

• Inventory Turnover – How often stock is sold and replaced
• Days Sales Outstanding (DSO) – How quickly receivables are collected
• On-Time Delivery Rate – Percentage of orders delivered on time

Employee KPIs

• Employee Turnover Rate – Rate at which employees leave
• Absenteeism Rate – Frequency of unplanned absences
• Productivity Rate – Output per employee or team

Why Essential KPIs Matter

• Help monitor performance in real time
• Support data-driven decision-making
• Identify areas needing improvement
• Align departments with strategic goals