14 Four Steps to Building the Perfect Financial Model

Of course, no financial model is perfect. In fact, every financial model you build will be wrong.

But creating a financial model is less about being right or wrong, and more about going through the process of detailing how a business “works”. The result, a set of financial statements, key operational metrics, and a set of key drivers and assumptions, creates a map for you to explore how your tactical product, marketing, organizational and strategic decisions impact your company’s profitability. It will help you determine your key milestones, capital needs and types of potential investors.

Here’s the key: your model will be wrong. Instead of focusing on the bottom-line income statement and the hockey-stick growth you’re projecting in year 3 of your venture, focus on your process, assumptions and key drivers and build a detailed month-by-month model that you can modify and update over time.

How?

1. Focus on expenses
You’ve probably already spent a lot of time thinking about your product, users, marketing plan and exit plan. Therefore, start your financial model by estimating your expenses. Because people are the foundation of successful startups, start with your hiring plan. Project the types of positions you’ll need to hire, when you’ll need to hire, and how much you’ll have to pay them (salary, benefits and equity). Estimate office expenses, rent, insurance, legal, accounting, taxes, equipment, and travel and entertainment costs. Create space in your model for your marketing, hosting, sales support and delivery costs to fill in later.

2. Outline how the product or service is built, marketed, sold and delivered
Create your revenue plan with a very concrete, tactical, bottoms-up look at the entire chain of events necessary to take your product or service from a plan to the customer. How long will it take to develop your product and build the organization? Think about your sales staff, website and marketing plan and how your budget for each channel translates to impressions, click-throughs, visitors, trials and sales.

Your model will vary depending on the type of business and business model. Are you B2B or B2C? Are you pursuing a freemium model? Do you have different levels of service at different price points? Are sales one-time or subscription-based? How long will the average customer keep using your product? Consider pricing, discounts, sales, coupons and free trials, when customers pay, and how long it will take to collect invoices.

Then, consider your partners, commissions, affiliate fees, monthly and per-transaction costs. What kind of hosting and customer support do you need to support your estimated level of sales?

Then, combine your expenses and revenue estimates to create your first profit and loss statement.

3. Analyze your assumptions, addressable market and benchmark your projections
Start digging into what your model means. How big is the addressable market for your product or service, and is it growing or declining? Who are your major competitors and what portion of the market do they currently have? What percentage of the market are you estimating you’ll be capturing within 3 months, 6 months and a year? Is it reasonable?

Analyze key metrics and drivers. Which assumptions have the most impact on your projections? Will a small change in price have a big impact on profits?

Just like you build products, iterate and refine your financial model by testing, analyzing, benchmarking and running your model by people you trust.

4. Create detailed financial statements
If you’re an early-stage company and you’re not looking for funding, you probably won’t create the detailed statements necessary for late-stage investors. Creating a balance sheet, statement of cash flows, financing structure and capitalization table requires a bit of finance and accounting knowledge. Scour the web for template financial models, talk to other entrepreneurs, potential investors and consultants, and you’ll have a good idea on how to finish your detailed model.

One bit of advice: don’t hire someone just to build a financial model. Either a) work with a consultant who is gifted at translating strategies into Excel equations while you learn how models work, or b) hire someone in your business who has the skills to build the basic financial models necessary for your stage. You won’t need a CFO until you’ve reached significant traction and have the types of opportunities to leverage the skills of a quality startup CFO.

If you can answer all these questions, then you’ve done the analysis necessary to build a strong financial model. It won’t be completely right, but that’s not the point.

(How does this all of this come together in Excel? Download one of my sample financial models for entrepreneurs for a working example, free to download and use. Also download Gif Constable’s financial model for freemium tech startup business and Glenn Kelman’s financial model from Redfin, and then start asking friends for the best examples they have seen for other startups. Find companies with comparable business models, acquisition strategies and operational plans. And have fun hunting.)

About Taylor Davidson ()

Taylor Davidson builds financial models to help companies make business decisions. Over 6,000 people have downloaded his sample financial models for entrepreneurs.

He is also a professional photographer, oft-traveler, aspiring do-gooder, and a Co-Founder of NOLAlicious, an award-winning email newsletter about New Orleans.

Check out his about page to learn more.

Tagged: , , , ,
  • http://twitter.com/PazzaArchitect Pascale Scheurer

    Great article. I like the “Your model will be wrong but do it anyway and update it often” approach. One of our VC advisers told us: “I take any financial plan I get, double the estimated costs and halve the projected income. If it’s still showing a decent profit I’ll take a look.” sounds harsh but it works, we still use it now for quick-fire testing new ideas – pretty soon you get a feel for the serious “ker-ching!” flyers and the dead dogs.

    • http://www.taylordavidson.com/writing/ Taylor Davidson

      Kind of a “minimum viable model” approach. We always say things take twice as long and are twice as expensive as planned, and that heuristic is a simple way to port that to financial projections. Pretty similar to how I typically adjust financial projections at first glance.

  • Johann

    Vumero.com could also be a useful tool in building a Financial Model. Either by buying a template to use as a guide or by hiring someone to build it for you.

  • VanessaElizebeth

    That’s a great piece of article.I will be back in the future for sure.

    Choose your Finance wisely