Every entrepreneur has at least once sat down at Excel with fire in their eyes. "Month one - 500 customers, average order value $55, costs next to nothing, we'll ask a friend for the office space." Three hours later you have a perfect spreadsheet where break-even arrives in two weeks. Beautiful, inspiring - and rarely has anything to do with reality.
The problem is not Excel, but the fact that a business plan for a bank or an investor is a game by someone else's rules. There you need to show growth, stability and, inevitably, "pessimistic, realistic and optimistic" scenarios. A business plan for yourself, on the other hand, is a hard conversation with your own illusions. And you have to learn not to lie to yourself in the spreadsheets.
Take every figure not from the average or optimistic estimate, but from the lower bound of what is possible. Then any real result will turn out to be a pleasant surprise rather than a disappointment.
How to stop lying: 5 hard rules
The average conversion rate in your niche is 3%. But that average includes both giants with a million-dollar budget and newcomers like you. Your real conversion in the first six months will be 0.5-1%. Take the lower bound, and the forecast becomes truthful.
In reality growth is more often linear or step-shaped, with setbacks and adjustments for the seasonality of your product or service.
You should pay yourself a market salary from the very first month. Record in your costs at least 70% of what you would earn as an employee.
Defects, returns, tax penalties, a broken laptop, a sudden jump in purchase prices, customer payments delayed by 60 days. Add a "contingency costs" column - 15-20% of all operating expenses.
Write a pessimistic scenario. Cut revenue by 40%, raise costs by 25%, add a three-month delay to the launch. Will the business survive? Will your personal savings be enough? If yes - the plan is realistic.
Why "average market" conversion is a trap
Take e-commerce. An average market conversion of 5% is not your conversion, but the arithmetic mean of completely different players. Top players with contextual advertising budgets of $22,000 a month squeeze out 8%. Mid-tier players hold 4%. And newcomers with a hastily built site and traffic bought on an exchange get just 0.7%. If you are only starting out, your honest number is the lower one, not the average.
Stress test: what happens in the pessimistic scenario
The fifth rule is not for the beauty of the report, but for survival. Before you invest money, run the plan through a stress test: simultaneously cut revenue by 40%, raise costs by 25% and push the launch back by three months. If at the bottom of this scenario your personal savings are enough - the plan is realistic.
Help from G-Invest Consulting
G-Invest Consulting specializes in honest financial models for business owners. Our approach:
- An audit of your current assumptions and hidden risks
- Building a financial model
- Calculating the real break-even point and margin of safety
The result is a business plan you can base decisions on, not just draw inspiration from.
We will build a financial model in which you are not ashamed to see the truth
G-Invest will stress-test your assumptions, calculate the real break-even point and run the plan through a pessimistic scenario - so that you make decisions based on facts, not on pretty spreadsheets.
Frequently asked questions
How do you build a business plan for yourself, not for the bank, without inflating the forecasts?
The main rule - take all figures from the lower bound of what is possible, not from the average or optimistic estimate. To do this:
- Run a mini-survey: ask 5-10 fellow entrepreneurs in your niche about their real figures at the start (conversion, average order value, customer churn).
- If there is no data - assume a conversion of 0.5-1% for cold traffic and 3-5% for warm traffic.
- Set your price not "like the leaders", but 20-30% lower - you are a newcomer, you have no trust yet.
- Multiply the time to reach your target figures by 2. Planned to reach 300 customers in 3 months? Budget for 6.
What mistakes do entrepreneurs most often make in Excel when financial planning?
- Mistake 1: they count revenue, not contribution margin. They forget that from every dollar you have to subtract the cost of goods, taxes and payment processing fees.
- Mistake 2: they use the formula "=previous month * 1.2" to infinity. The market does not grow exponentially.
- Mistake 3: they copy someone else's financial model from the internet.
Why can't you use average market conversion figures in a business plan for yourself?
Using e-commerce as an example: an average market conversion of 5% is the mean between:
- top players with contextual advertising budgets of $22,000 a month (their conversion is 8%);
- mid-tier players (4%);
- newcomers with a hastily built site and traffic bought on an exchange (0.7%).
Take not the market average, but the average for micro-businesses under a year old - if you can find such data.
How often should you revise a business plan for yourself?
Once a month - mandatory. Once a quarter - in depth. And every time after any shock (the loss of a major customer, a currency rate spike, a new competitor). Revising means not just looking at the figures, but changing the assumptions. If you budgeted a conversion of 2% but the actual figure is 0.8% over two months - recalculate the whole plan with the new assumption.