Tablet showing a candlestick chart beside monitors - business model canvas template

Business Model Canvas Template (Excel)

Free Excel business model canvas with the nine blocks, a risk-ranked assumptions list and a revenue and break-even sheet.

Download the free Excel file

What is in the Business Model Canvas template

This workbook has four sheets: Canvas, Assumptions, Revenue and How to use. It gives you the one-page canvas plus the numbers behind it, so the model gets tested rather than just drawn.

Canvas

Nine blocks in the standard layout: key partners, key activities, key resources, value propositions, customer relationships, channels, customer segments, cost structure and revenue streams. Each block is a merged, wrapped cell where you write bullet points. The sheet prints on one landscape page.

Assumptions

A list of up to 30 assumptions your model depends on. Each has a block, a risk level (High, Medium, Low) and a status (Not tested, Testing, Validated, Invalidated) chosen from drop-downs, plus columns for how you will test it, what you learned and a review date. Counts by status sit at the top so you can see how much is still unproven.

Revenue

Enter each revenue stream with a price per unit and units per month, and each cost as Fixed or Variable. The sheet calculates total revenue, total costs, monthly profit, profit margin and break-even sales. A bar chart compares revenue with costs, with no data labels.

Sample data

The template opens with a made-up mobile bike repair business: monthly revenue of $8,870, costs of $4,075, profit of $4,795, a margin of 54.06 percent and break-even sales of $1,624.40. These are illustrations only. Replace them with your own.

How to use it

  1. Fill the Canvas, starting with customer segments and value propositions.
  2. Move each guess into the Assumptions sheet and rank by risk.
  3. Enter prices, volumes and costs on the Revenue sheet.
  4. Test the riskiest assumptions first and update their status.

See how to use the business model canvas for the method. Check break-even with the break-even calculator.

Free pricing tips for your business

Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.

    Frequently asked questions

    Can I use it for more than one customer segment?

    Make one copy of the workbook per segment so the revenue and costs stay separate.

    What are the Assumptions for?

    They list guesses you must test. Rank by risk and test the riskiest first.

    How is break-even calculated?

    Fixed costs divided by the share of each sale left after variable costs.

    Are the sample numbers benchmarks?

    No. They are invented for illustration.

    Need a custom calculator or spreadsheet built for your business?

    Talk to us

    More free tools: All free calculators · Break-even calculator · How to use the business model canvas · Marketing plan template