Business Plan Numbers for Beginners: Sales, Costs, and Startup Funds Tables

Business & Strategy

Business Plan Numbers for Beginners: Sales, Costs, and Startup Funds Tables

Founders stuck on the numbers after outlining their business plan use this beginner template to fill in three tables - sales, costs, and startup funds - for their plan. The whiteboard holds a sales plan grid across four periods, an expense list split into fixed and variable costs, five steps for building the numbers, three basis frames for customer count, price, and costs, a startup funds and financing frame, and a monthly cash flow frame. The task board runs five columns from gathering numbers to done, opening with four parent tasks and twelve subtasks, all not started. Sales come from customers times price times days open, then costs split into fixed and variable to find the sales level that turns a profit, so this suits anyone about to apply for a startup loan or pitch an internal proposal who needs to explain where the numbers come from. Every example amount is filled in, so you only need to swap in your own numbers to complete all three tables.

0 Likes 0 Copies Author: WeProcess
business plan sales forecast cash flow startup loan financial planning
Sign up free and use this template

Once you have a free account, you can copy this template from the marketplace

Whiteboard preview

Preview mode Business Plan Numbers for Beginners: Sales, Costs, and Startup Funds Tables

Whiteboard preview

1. Sales Plan Table (customers × pric... 2. Expense List (split fixed and vari... 3. How to Build the Numbers (fill in ... 4. Why This Many Customers 5. Why This Price 6. Cost Basis (easy to miss something) 7. Startup Funds and Financing (match... 8. Monthly Cash Flow (see the gap bet... Business Plan Num... How to use: (1) F... Sales and target ... Decisions and for... Funding gaps and ... Basis and researc... Customers (per day) Unit price Days open Monthly sales Month 1 e.g. 10 e.g. $8 e.g. 22 $1,760 Month 3 15 $8 22 $2,640 Month 6 20 $9 24 $4,320 Month 12 25 $9 24 $5,400 Fixed/Variable Monthly amount How it is set Rent Fixed e.g. $800 Straight from the lease Wages Fixed e.g. $1,200 $8/hr x 5h x 30 days Supplies Variable e.g. $616 Sales $1,760 x 35% cost ratio Other costs Fixed e.g. $470 Utilities $170 + ads $200 + other $100 Monthly total Fixed + Variable $3,086 Fixed $2,470 + variable $616. A loss at month 1 sales of $1,760 Step 1Pick the sales formulaDecide first whether you'll use customers times price times days, or contracts times monthly fee. Keep every line consistent with it. Step 2Enter customers and pricePut your researched figures straight into month 1. Save any increase for month 3 onward, and note why in the basis boards. Step 3Split costs in twoList costs that stay the same every month as fixed, and costs that grow with sales as variable, in the expense list (board 2). Step 4Find the breakeven linee.g. fixed $2,470 divided by (1 minus 0.35) = about $3,800. The 0.35 is the variable cost ratio from board 2 (35% cost ratio). Divide that by an $8 price and 22 days and you get about 22 customers a day. Step 5Fill in funds and financingFill in startup funds (board 7) and cash flow (board 8), then paste all three tables into the matching plan chapters to finish. e.g. counted 8 people an hour at three nearby competitors on a weekday afternoon e.g. 12 seats x 2 turns a day x 40% occupancy = about 10 customers Always note the date and place you checked For any month you raise the count, explain why in one line e.g. main item $6 + a drink $2 = $8 e.g. nearby competitors charge $6 to $10 For any month you raise the price, note what changed to justify it If you plan discounts or coupons, write the price after they're applied e.g. rent is $800 from the lease, common fees included e.g. wages $8/hr x 5h x 30 days = $1,200 Easy to forget - insurance, accountant fees, software subscriptions For any line without a quote yet, write TBD next to the amount What you need, and how muche.g. interior work $16,000 / kitchen equipment $8,000 /deposit & key money $4,000 / fixtures $2,000 /3 months' working capital $9,300 = total $39,300 Where it comes frome.g. self-funded $13,300 + startup loan $26,000= total $39,300 (matches what you need)Owner: ____ / Planned application date: ____ If you're shorte.g. switch to a turnkey space and cut interior costs by $3,200.If that's still not enough, push opening back a monthand save more before you apply. When money comes ine.g. cash sales land the same day, card sales on the 15th of the next month.About half of month 1's $1,760 in sales arrives the next month.The slower it comes in, the faster your cash on hand drops. When money goes oute.g. rent is due at the end of the prior month, supplies are due atmonth-end for the month before, wages are paid on the 25th.Some months, payments land before the sales that cover them. Cash to keep on hande.g. keep 3 months of monthly costs ($3,086 x 3 = about $9,300) in theaccount as working capital (same as board 7's working capital line).If the balance drops below that, review your spending.
100%

Drag to move, scroll to zoom

Task board contents

Gathering numbers 16 items

Gather the materials
Build sales table
Build costs & funds
Paste into the plan
Confirm the chapter
Check price & count
Get cost estimates
Pick the formula
Fill in each period
Note why it grows
Split fixed/variable
Find the breakeven
Write funds & source
Add source notes
Get outside eyes
Review it monthly

Filling in tables 0 items

Checking the basis 0 items

Pasting into the plan 0 items

Done 0 items

← Back to templates