Thoughts on startups by investors that
fund them & entrepreneurs that run them

How and Why To Do Your Own Business Financial Model

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.

Written by Martin Zwilling

user Martin Zwilling Founder and CEO,
Startup Professionals

Martin is a veteran startup mentor, executive, blogger, author, tech professional, and angel investor. He is the Founder and CEO of Startup Professionals, a company that provides products and services to startup founders and small business owners.

prev next

You might also be interested in

What Belongs in a Startup’s Pitch Deck?

So you’ve developed a game-changing product, formed a business with a killer team, quit your job, and are rolling the product out to market. Your business is the next unicorn, and all is good in the world. Fantastic. Now only one thing is inhibiting your company’s growth: you have no money.

For many founders of high-growth startups, bootstrapping has limits.

Read more >

From Accelerators to Venture Capital: What is best for your startup?

With startup growth up 61% since 2014 and more investment programs emerging, it can be overwhelming for founders to know just where to jump in. As the most startup-friendly accelerator on the planet, MassChallenge has helped 835 startup companies around the world, who have raised over $1.1 billion in funding and created over 6,500 jobs. We have seen startups at

Read more >

Ask A Founder: Startup Lessons Learned from Work Truck Solutions’ Kathryn Schifferle

Kathryn Schifferle, Founder and CEO of Work Truck Solutions, turned being a woman in work trucks into an oversubscribed $2.1 million round.

We sat down with Kathryn as she shared what her fundraising journey was like, the startup lessons she learned, and her advice to fellow founders, especially women. Here is what she had to say:

HK: Tell

Read more >

Valuation Part I: Peeling the Onion, or How Top Investors Value the Startups They Invest In

Update 2017: To help you understand how your startup will look to investors according to this methodology, we’ve created a fundraising feedback tool that will give you investor-level insight into your startup’s performance. In just about 15 minutes, it will tell you how much money your startup is likely to raise, where you can find that capital, and what to

Read more >

Trying to Raise Money? Thinking About Gust for Startup Fundraising?

How to Make Your Gust Account Stand Out to Investors

Before you read any further, I want you to know that I’ve personally used Gust to raise money for my first tech startup. I know a lot of other entrepreneurs who use or have used Gust to seek funds, but their profiles don’t always get attention from investors. Below are

Read more >