The sections of a plan in Business Planner keep tables below their questions. The Money section works out the plan's numbers from them: sales, costs, profit and cash for every month, the break-even month and the money needed.

The questions, examples and checklists in Business Planner are general texts, not legal, tax or financial advice. The numbers are arithmetic on what you typed, before tax.

The tables

Table Section What a row holds
Products and services What you sell Name, kind (product, service, or subscription per month), price, cost to provide one (materials, a subcontractor, payment fees; may be 0), what one is sold per (a walk, an hour, an item), a note
Competitors Customers Name, website, what they offer, their price, what they do better, what you do better
Channels Getting customers Name, kind (such as word of mouth, social media or advertising), cost a month, the month it starts, a note
Founders and hires People Name, founder or hire, role, what they bring, a founder's share, the month they are paid from, cost a month, and who they are linked to
Costs Money Name, kind (to start, paid once; or to run, every month), amount, what it is for, the month, until when, a note
Sales forecast Money How many of each product or service are sold each month
Funding Funding and ownership Name, kind (such as own money, a loan, a grant or an investor), amount, month, state (planned, applied, received or refused), deadline, terms, contact
Risks Risks What could go wrong, how likely, how bad, what you would do, and whether it is in the plan

A marketing cost is a channel, on Getting customers, not a cost. A risk set to Team only is left out of the finished plan.

Each table's Add button asks only for the name (and, for a person or a cost, its kind) and adds the row. Add and add another keeps the drawer open. Every other value is changed on the row, where it saves at once. Months are chosen from the plan's months, never typed.

Drag a row, or use Move up and Move down, to change the order. Delete removes a row at once, and the message has Undo.

Add from Store

When the team has products in Store that are not yet in the table, Add from Store on What you sell adds the chosen ones with their name and lowest price. A product priced in another currency than the plan's is added without a price. Changing the product in Store afterwards does not change the plan.

People

A founder's share is typed as a percentage, such as 50 or 33.33. Below the table, the founders' shares are added up; a total other than 100% shows a line, and nothing is refused. A founder is paid from the month you choose, or Not paid yet; a hire is paid from the month they start.

Linked to links a founder to a team member or a contact, and a hire to a job in Hiring. A founder with an email address is offered as a signer when you ask for signatures on a version.

The sales forecast

The forecast on Money is a grid of the plan's months by products and services. Type how many of each are sold in each month; for a subscription, type the subscribers that month. Quantities are whole numbers, and an empty cell is 0.

Fill in… on a row asks for the number in the first month, the month to start from, and a growth each month, as a number (5 more each month) or a percentage. It writes every month from that one to the end of the plan. A percentage is applied month by month and rounded to a whole number each month, halves rounded up. A number may be negative; the forecast stops at 0. What it wrote can be changed cell by cell afterwards.

How the numbers are worked out

The Numbers band on Money shows each month and each year of the plan. Every figure is worked out again each time the page is opened. For each month:

  • Sales: each product's quantity that month times its price.
  • Cost of sales: each product's quantity that month times its cost to provide one.
  • Running costs: every running cost from its month to its last month (or with no end), every channel from its month, every hire from the month they start, and every founder from the month they are paid from.
  • Startup costs: every startup cost in its month.
  • Profit before tax: sales less cost of sales and running costs. Startup costs are in cash, not in profit.
  • Funding received: the funding whose state is Received, in its month.
  • Cash change: profit, less startup costs, plus funding received.
  • Cash at month end: the month before's cash plus this month's change, starting from 0.

Below the months:

  • Break-even is the first month whose profit is 0 or more, when every later month's profit is too. "Not within the plan" means no such month.
  • Lowest cash, before funding is the lowest cash at any month end with all funding left out.
  • Money needed is that lowest cash as a positive amount, or 0 when cash never goes below zero.
  • Still to find is the money needed less the funding received in the plan's months, or 0.

Funding that is planned, applied for or refused is never in the numbers; the line under Funding says how much is planned or applied for. Funding with no month is not in the numbers even when received. A row dated before the plan's first month says "Before the plan starts, so not in the numbers". When the plan is made shorter, forecast months past its end are kept and left out.

A worked example

A dog walker's plan runs for 12 months in US dollars. It sells a walk at $20.00 that costs $1.00 to provide, and a monthly package at $300.00 that costs $20.00. Walks start at 40 in month 1 and grow 25% a month (40, 50, 63, 79, 99, 124, 155, 194, 243, 304, 380, 475); packages start at 2 and grow by 1 a month, to 13.

Startup costs in month 1 are a van sign at $300.00 and insurance at $600.00. Running costs every month are fuel at $150.00, software at $20.00, flyers (a channel) at $50.00, and the founder, paid $2,000.00 a month: $2,220.00 a month in all. Funding is $1,000.00 of the owner's money, received in month 1, and a council grant of $300.00 for month 2, applied for.

Month Sales Cost of sales Profit Cash change Cash
1 $1,400.00 $80.00 −$900.00 −$800.00 −$800.00
2 $1,900.00 $110.00 −$430.00 −$430.00 −$1,230.00
3 $2,460.00 $143.00 $97.00 $97.00 −$1,133.00
4 $3,080.00 $179.00 $681.00 $681.00 −$452.00
5 $3,780.00 $219.00 $1,341.00 $1,341.00 $889.00
12 $13,400.00 $735.00 $10,445.00 $10,445.00 $40,574.00

Month 1's cash change is $1,400.00 − $80.00 − $2,220.00 − $900.00 (startup)

  • $1,000.00 (own money) = −$800.00. The grant is applied for, not received, so it is never in. With funding left out, cash is −$1,800.00 after month 1 and −$2,230.00 after month 2, its lowest point, so the money needed is $2,230.00 and still to find is $2,230.00 − $1,000.00 = $1,230.00. Break-even is month 3: its profit is above 0, and so is every later month's. The year's sales are $71,120.00 and its profit $40,474.00.

The CSV

Download CSV on the Numbers band downloads the numbers: one row per month, one per year, then the break-even month, the money needed, the funding received and the amount still to find. Amounts are plain numbers in the plan's currency.

Compare with Accounting and Budgets

When the team keeps its books in Accounting, Money has an Accounting band for the people who can use Accounting. Others do not see it. It needs the plan and the books to be in the same currency; when they differ, the band says which two, and no amount is converted.

Compare with Accounting opens a table of each month of the plan that has ended: the forecast sales, costs and profit beside Accounting's income, costs (cost of sales and expenses) and net profit for that month, and the difference. Nothing is changed in either.

Send the first year to Budgets… writes the plan's months that fall in the financial year of its first month into that year's budget in Accounting. A plan that starts late in the financial year sends fewer than twelve months. The drawer lists the lines (sales, cost of sales, each category of running cost, getting customers, and people) and asks which account each goes to. Someone who can edit the plan sends it. Startup costs are not budgeted. When the year already has a budget, Magpie asks before replacing all of its lines with the plan's.

Ownership and the cap table

The Who owns the business band on Funding and ownership shows the founders and their shares from People, with their total.

When the plan names a company in Company Records (in Edit details…), the band shows that company's cap table instead, fully diluted, as of today, with Open in Company Records. The founders' shares in People are then for the plan only. Only people who can use Company Records see the cap table's figures; others see a line saying the ownership is kept in Company Records. A saved version, a reading link, and a Document, spreadsheet or deck made from the plan show the founders' split, with a line that the register is kept in Company Records.

Without a company, Keep the real register in Company Records opens Add company in Company Records with the business's name.

If a figure in the numbers does not match what you expect from these rules, Contact support.

Ask Magpie support

Send Magpie staff a question about anything this article does not answer.