Magic behind financial projections in a startup

3678 reads

One question I have been repeatedly asked in all entrepreneurship events recently has been "How important is Financial Projection for a startup?". Like all

subjective questions, the answer can range from "highly important" to "not important at all". I have never seen any investor writing a cheque without looking

at the financial projections, neither have I seen them making the projections the sole base for investment decision. It does not matter whether it is a 1, 3

or 5 year projection. All investors know that the 1st version of projections are going to change - still we insist on projections to determine how well

prepared the entrepreneur is.

Let me list down the important things to keep in mind while building the financial model:

Clearly Stated Assumptions

While all models contain balance sheet, cash flow, and profit and loss statements in fair details, the basis on which it is arrived at should not be missed

out. This can be easily captured in a simple sheet containing all assumptions. Give some thought to the important factors - if the market size is a billion

dollar and growing by 50% a year, then the revenues sheet should show how fast you are growing. Investors have low attention span, and by looking at the

assumptions list, they form an opinion on how thorough the entrepreneur is. It also gives an idea to the entrepreneurs on what the likely cash requirement is

and when it may be required.

Make the model flexible

One exercise I have frequently done while arriving at the investment decision is make all revenue numbers 0 and cost projections 1.5 times - then look at how

long the cash will last. The scenario is extreme but gives an idea about how the business is likely to shape up. Startups can look at building an aggressive,

a conservative and a realistic model. If the model is flexible, it is sure to attract investor attention.

Projecting a revenue over 10 Crore in Year 1

I have never seen a startup achieving this magic number in year 1 and the higher this number, the less its credibility. Large numbers do not

impress investors - what impresses them is a solid plan to execute (which means team expansion plans, sales and marketing plans etc. ). Spend lot of time

with your customers and be realistic in revenue projections - thats how you will get the real revenues.

Basics of Accounting

During our days as accounting students, we would introduce a "suspense account" just to match the assets with liabilities. In real life financial

projections, make sure assets = liabilities, ending cash balance for year 1 is opening cash balance for year 2 and all statements are linked perfectly! Excel

is a powerful tool, but do not hard code numbers so that they "match up".

Professional look and feel

After all the hard work is done, spend a little time in "beautification" of the statements - not cook up the numbers but use the fonts, colours, style etc. to make the projections look professional and easy to follow.

I am sure with all this and a little more, you will be able to attract investors and get your next funding! All the best!

This article was originally published on:

http://yourstory.in/resources/business-talk/3323-magic-behind-financial-projections-in-a-startup

Trending

190
jackcanfield's picture

Try This Simple Night Meditation Called “The Evening Review”

Successful people maintain a positive focus in life no matter what is going on around them. They stay focused on their past successes rather than their past failures, and on the next action steps that will get them closer to the fulfillment of their
97
adamgrant's picture

The Two Traits of the Best Problem-Solving Teams

You want teams that are cognitively diverse and psychologically safe. A variety of thinking styles—coupled with the freedom to take risks without being punished—enables groups to generate, test, and implement creative ideas.Imagine you are a fly on
123
changethis's picture

Making ‘Agile’ Business as Usual

“There is more to Agility than putting lipstick on a pig. Organizations that attempt to migrate to Agile approaches need to take accountability for their 'inner pig.' Any sector can espouse Agile practices, such as SCRUMS, Sprints, and Stand-ups.
114
danielhpink's picture

Things: The secrets of high standards and happiness

1. WHAT TO READ: Can you teach high standards? Each year, Amazon founder Jeff Bezos — whose current personal net worth exceeds the GDP of nearly 150 nations — writes a letter to shareholders. Most corporate missives are snoozers, but Bezos’s is
151
mashable's picture

Google just slashed the price on its massive storage plans with Google One upgrade

Google's storage plans are getting cheaper. The company has launched a new storage plan called Google One, which offers significantly better deals than Google Drive storage plans. There's no need to switch, because all current Drive storage
412
changethis's picture

Start Imagining a Future of Human + Machine

“In the first wave of transformation, businesses standardized processes. Think Henry Ford and the assembly line, where steps in the overall process were broken down, measured, and optimized to achieve gains in efficiency. The second wave of
157
davecrenshaw's picture

How far would you go for a friend?

I recently witnessed an act of compassion and friendship so unexpected, it moved me to tears. And it happened in a very unlikely place: Pelican Bay super-maximum security prison. I support a program called Defy Ventures, an organization that works
155
johnsullivan's picture

Here We Go Again – LinkedIn Updates Its User Agreement

There are times in my life when I hate that I am right about something. Like the time I thought an employee was stealing from my store back in the day and two days later I caught them doing just...
292
changethis's picture

How Women Rise: Helping Women Change the Behaviors that Get in Their Way

“It’s not surprising that many of the behaviors that hold men and women back would be different. After all, women often have very different experiences at work. And experience shapes habits and responses.Familiar habits and responses may feel