Most entrepreneurs tend to avoid this area of the business, and as a result are badly surprised by cost realities, and investor expectations. They seem to think that financial projections are simply invented numbers for investors, and not useful. In reality, it’s like jumping in your car for a long hard drive with no destination in mind. Chances are, you won’t enjoy success from the trip.
What is a business financial model, really? In most cases, it is merely a Microsoft Excel spread sheet loaded with your cost and revenue projections for your startup, starting now in time and extending at five years into the future. For more value, a few variables can be added, like product volume growth rate, and number of salesmen, for “what if” analyses.
Why? For you to make decisions and manage the business - because we are all mere mortals and can’t possibly keep all these numbers and calculations in our head – to decide whether and when the business is going to be profitable given rational projections of costs and income (these assumptions are referred to as your business model). Secondarily, it will be required by potential investors to validate how much money you need to get started, and how much return they can expect on their investment.
When? The financial model should be running even before you incorporate the business and build prototype products (would you start driving your car on a long trip before you knew where you were going?). If you can’t make that objective, then at least don’t approach potential investors until your model is working – investors have little tolerance for startups with no financial plan.
How? Start with a “sample” business model, available in generic form or customized for specific industries, from many sources on the Internet. Another alternative is to download from my website a free sample model that I built for a specific startup, with elements suggested by Angel investors and venture capitalists, ready to be customized to your business.
If you are not computer literate in Microsoft Excel, your first task is to find someone who has the time and expertise to convert your base set of costs and revenues into projection formulas, cash flow summaries, and a profit and loss statement.
Do your own, if you can, because you know the numbers. In fact, this is the easy part. More challenging is ‘defining’ the business model (assembling all the real variables of your projected business, pricing assumptions, staffing requirements, marketing costs, sales costs, and revenue flows).
This business model can then be used for many purposes, such as risk and profit assessment, projecting the values of assumptions that are made based on existing market conditions, calculating the margins that are needed to avoid adverse situations, and various forms of sensitivity analysis. These are necessary to estimate capital investment requirements, plan capital allocation, and measure financial performance.
Creating financial projections allows you to see areas of strength and weakness in your proposed business model, enabling you to make critical changes that will allow your business to run more successfully.
While people start businesses for many reasons, making money is usually important. Even a non-profit can’t afford to lose money. You won't know if you can meet these expectations until you build a financial model with reasonable financial projections.
It’s a great learning experience, and you can do it yourself, but don’t hesitate to ask for help from a professional if you need it. You will be amazed at how clear the relationship becomes between pricing, cost, and volume. When you lose money on every item, it’s hard to make it up in volume.
Marty Zwilling




Thanks for this awesome post Marty. We as a small business service providers need to be more careful about what we spend on and should monitor our ROI. Thanks for the great share.
ReplyDeleteI have tried doing the financial plan section of a business plan. While interviewing the entrepreneur, I found out that he was kinda blank on figures. More so on pricing. How does one assist such kind of entrepreneurs? Another hard truth is that these are purely projections, coming up with a long term plan for say 5 years I have a feeling this may not hold much water, further more, there are no any historical data to act as a guide. Lastly, most investors are hard to convince, they are quick to ask this questions, How much have you sold? What was your net profit?...etc
ReplyDeleteAs a start up how do you answer to such?
Regards,
John
@John, I've had the same experience as you in working with many entrepreneurs. Granted, the questions are not easy, but some founders are quick to investigate similar businesses, or consult with advisors, and come up with quite reasonable projections and expectations. As an investor, those are the ones I look for. A startup that tries to run blind on financials is clearly high risk, so that's why investors like to test them in this area, and run away from these.
ReplyDeleteI agree with the title of the article, that start-ups without financials are doomed.
ReplyDeleteHowever, in practice I have never yet met an entrepreneur who has the technical financial and accounting knowledge to put a credible set of financial projections together. The start-up entrepreneur needs to be heavily involved with the numbers, sure, but they need professional help to convert the raw numbers into credible financials. They need a professional who asks the right questions and can convert those answers into financial data. A balance sheet, not mentioned above, is a vital component of financial data and its absence should scream a loud warning to any would-be-investor. I have seen crazy figures presented as “a robust P & L” which an investor could blow out of the water in one minute. The non- accountant may be used to preparing lists and calculations with spreadsheets, and they can probably even make it look pretty, but for example, will not even notice if they accidentally key in $700,000 for rent instead of $7,000 in year 3.
The process of preparing the financials should reveal flaws in the business model, and force the entrepreneur to consider customers, sales, pricing, profits and cash in a real way. It should force the entrepreneur to consider the financial feasibility of the project and how it will be financed. While I do like your post and agree with the sentiments expressed, there’s one other thing I disagree with. If you lose money on every item, it is not merely hard to make it up on volume – it’s impossible! If you lose $1 on every item, and sell 1,000 items, you will lose $1,000. If you lose $1 on every item, and sell 100,000 items, you will lose $100,000. Volume can’t fix a broken business model, and in this case the more you would sell, the more you would lose.
Entrepreneurs need to focus on their numbers from the outset, but when they seek outside investors, they do need professional help with the financials. A balance sheet is not just “nice to have”, it is essential.
At the end of the day, as you say in your article; “Even a non-profit can’t afford to lose money”.
Thanks for this awesome post Marty.This business model can then be used for many purposes, such as risk and profit assessment, projecting the values of assumptions that are made based on existing market conditions, calculating the margins that are needed to avoid adverse situations, and various forms of sensitivity analysis.
ReplyDeleteMore challenging is ‘defining’ the business model (assembling all the real variables of your projected business, pricing assumptions, staffing requirements, marketing costs, sales costs, and revenue flows).
ReplyDelete