To start, financial models are always wrong. But it’s important to create one anyway. I have created, modified, and delivered hundreds of custom financial models in Excel for a range of clients over the past decade, and learned a lot about how to create and use financial models in decision-making.
Creating a financial model forces an entrepreneur to outline very specifically how a business “works”: how a company creates their products, how users and customers find and use their products and how those processes create revenues and costs. The result, a set of operational metrics, financial statements and the “equation of the business”, is one view of a potential reality of the business. While any one view is inevitably wrong, by digging deeper and analyzing the key drivers and testing a range of assumptions an entrepreneur can create multiple views to help make crucial product design, marketing, organizational and strategy decisions.
Instead of focusing on the bottom line profit and net income, focus on the assumptions and key drivers of the business. Developing a financial model creates the type of thought and data that helps entrepreneurs figure out what they are betting on and how likely their bets will pay off.
Sounds hard? Financial models are easier than you think.
Resources for Business and Financial Modeling
Financial Model Excel Templates
- David Teten’s startup financial model
- Giff Constable’s freemium business model template
- Glenn Kelman’s financial model from Redfin
- Andrew Chen’s freemium business model
- Vince Scafaria’s simple Financial Model for a Startup
- Matthew Carroll’s sample financial model (explanation in detailed Quora thread)
- Mark Suster, valuation and sample capitalization table
- Michael Herman’s Startup Financial Model, $$ Excel Templates
- Christoph Janz, Financial Planning for SaaS Startups
- Jamie Quint, on modeling retention and virality, Retention is King (Guest Post)
Best Practices and Guidelines
- Kostas Stavreas, Is the Financial Model Dead?
- Great Quora thread on building a financial model for a web-only product startup
- David Teten, Best Practices in Spreadsheet Design
- Thomas Tunguz, The 10 Most Important Metrics In A Startup’s Financial Statements
- Taylor Davidson, Why Financial Models are Easier Than You Think
- Nathan Beckord, Your Financial Model is a Work of Fiction; Build it Anyway
- Joe Stump, How To Spend your Investors’ Money
- Thomas Tunguz, The Ratio Of Engineers To Sales People In Billion Dollar SaaS Startups
- Thomas Tunguz, How Much Cash Does Your Startup Need To Go Public?
- Fred Wilson, Forecasting
User Acquisition, Lifetime Value, Cohort Analysis, Analytics
- David Skok, Modeling User Acquisition
- Christoph Janz, The Easiest Spreadsheet for churn, MRR, and Cohort Analysis
- Andrew Chen’s post on Facebook Viral Marketing (commentary and links to cohort analysis)
- Jeremy Liew’s how to estimate lifetime value for an ecommerce business (with cohort analysis)
- Jeremy Liew’s earlier post on how to estimate lifetime value (with sample cohort analysis)
- Andrew Chen’s how to calculate cost per acquisition for startups
- Andrew Chen on What Factors Influence DAU/MAU? Nature v. Nuture (also, Appdata is a great resource for DAU/MAU data)
- Sean Moran, How to project customer retention for a subscription business
- Andreas Klinger, The simplest and most important dashboard for early stage startups
- David Skok, SaaS Metrics 2.0 – A Guide to Measuring and Improving what Matters
- Christoph Janz, A KPI Dashboard for early-stage SaaS Startups
- Andrew Chen, What’s Your Viral Loop?
- Dave McClure, Startup Metrics for Pirates
- Rahul Vohra, How to Model Viral Growth
- Kyle Rush, Optimization at the Obama Campaign, A/B Testing
- Ben Sesser, Memo to this year’s YC class: It’s damn hard to build an enterprise company, including some stats about enterprise companies
- Andreessen Horowitz, Understanding SaaS, a Valuation Primer
Revenue Models and Forecasts
- Fred Wilson, Web and Mobile Revenue Models
- Steve Blank, The Business Development / Customer Development Stack
- Tim Berry, Creating a Sales Forecast
- Paul Graham of Y Combinator, How to Raise Money
- Steve Schlafman of RRE Ventures, Raising Seed Capital
- Taylor Davidson, Fundraising for Entrepreneurs
- Sam Altman of Y Combinator, Fundraising Mistakes Founders Make
- Venture Hacks, What Should I Send Investors: Deck
- Bing Gordon of KPCB, How To Craft A Concise Pitch Investors Will Care About
- Garage Ventures, Perfecting your Pitch
- Mark Suster and Mark Jeffrey, What Makes a Good Pitch
- Examples of web pitch decks by Piccsy, Dressrush, CSS Piffle