UPDATED 2017After years of building financial models for over 18,050 people in 98 countries I have seen a lot of commonly asked questions about best practices, resources and templates. I started compiling a list of financial modeling resources on the web, and over time that list has grown. I’m constantly updating this so if I missed something let me know. Contact me.
Financial Model Best Practices and Spreadsheet Design
General Startup Financial Model Excel Templates
- Eloquens, multiple financial models and business planning tools available to download (free and paid)
- 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
- Tim Raybould, A cash model template for startups
- Taylor Davidson of Foresight, Financial model templates for startups for SaaS, subscription, ecommerce, marketplace, and advertising businesses
- Michael Herman’s Startup Financial Model, $$ Excel Templates
- Startup Model, $$ Excel Templates
- OpStarts, $$ Financial Projections
SaaS Financial Model Templates and How-To
- Christoph Janz, SaaS Financial Plan 2.0
- David Skok, SaaS Metrics 2.0 – A Guide to Measuring and Improving what Matters
- Taylor Davidson of Foresight, SaaS Financial Model
- Brandon Marker, early-stage SaaS financial model template
- Baremetrics SaaS Financial Model
- Nikos Moraitakis, Financial planning for SaaS startups
- Garrett Dimon, Starting and Sustaining, a guide for SaaS web apps
- Christoph Janz, A KPI Dashboard for early-stage SaaS Startups
- Andreessen Horowitz, Understanding SaaS, a Valuation Primer
- Sean Moran, How to project customer retention for a subscription business
- Ali Rahimtula, Fundraise Like a Pro Using this Internal SaaS Metrics Playbook
- Jeff Bussgang of Flybridge Capital, Your LTV Math is Wrong
- Ben Murray, SaaS metric and forecasting models
- Thomas Smale of FE International, How to Value a SaaS Business
Ecommerce Financial Model Templates and How-To
Marketplace Templates and How-To
Financial Models and Portfolio Math for Venture and Angel Investors
Resourcing and Operations Tempates for Agencies
User Acquisition and Growth
Revenue Models and Forecasts
Metrics and Datapoints for Startup Financial Models
Cap Tables, Valuation, Equity, and Convertible Note Mechanics
- Taylor Davidson of Foresight, How-to - Cap Tables, Liquidation Preferences and Exit Proceeds
- Venturehacks, How to make a cap table
- Mark Suster, valuation and sample capitalization table
- Raj Bedi, Discount or cap? A spreadsheet that shows what happens when a note converts.
- Michael Dempsey, Liquidation Preferences, A Waterfall Analysis, and Educating Startup Employees
- Derek Colla of Cooley, Calculating Share Price with Outstanding Convertible Notes
- Carlos Eduardo Espinal, How does an early-stage investor value a startup?
Metrics and Dashboards How-To
- Christoph Janz, The Easiest Spreadsheet for churn, MRR, and Cohort Analysis
- Jeremy Liew, How to estimate lifetime value (with sample cohort analysis)
- Andrew Chen, What Factors Influence DAU/MAU? Nature v. Nuture (also, Appdata is a great resource for DAU/MAU data)
- Andreas Klinger, The simplest and most important dashboard for early stage startups
- Dave McClure, Startup Metrics for Pirates
- 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
Pitch Decks
Fundraising
Employee Equity Valuation and Structure
Board Meetings and Metrics Dashboards