What does a "good" Financial Model look like?

  • Financial Models should be Excel-based and presented on a monthly basis with up-to-date actual / historical figures (ideally from past 2 years, if company has been in operation that long) and at least 2 years of forecasts
  • Financial Models should include all three, core financial statements:
    • Income / P&L Statement – demonstrates to investors the nature of the company's revenues & expenses and thus gives insights into profitability and the long-term viability of the business
    • Cashflow Statement – demonstrates to investors the company's sources and uses of cash and the expected rate of cash burn should they invest
    • Balance Sheet – demonstrates to investors the current and projected “book value” of the business, which is critical to making an educated investment decision
  • Financial Models should include the following core KPIs:
    • Revenue – demonstrates to investors the scale of the business and traction with paying customers over time, which is used to evaluate the company's investment potential
    • EBITDA – demonstrates to investors the company's short-term operational efficiency, which is a more accurate reflection of operating profitability since EBITDA margin ignores the impacts of non-operating factors such as interest expenses, taxes, or intangible assets
    • Total Costs – demonstrates to investors the total expenses incurred in business operations
    • Total Staff Costs – demonstrates to investors the total expenditure incurred for staff time used to deliver goods and services
    • Cash Receipts From The Sale Of Goods Or Rendering Of Services – demonstrates to investors how much cash the company generates from its core business operations
    • Cash Payments To Suppliers And Employees – demonstrates to investors how much the company spends on day-to-day operations and allows them to better understand how the company intends to spend their cash should they invest
    • Net Cashflow – demonstrates to investors the company's financial viability, as a consistent positive net cash flow is an excellent indicator of the business's potential to succeed
    • Gross Runway – demonstrates to investors how many months the company can keep operating before it runs out of money. Investors generally want to see 12 – 18 months of runway, allowing time for essential projects to finish before additional funding is required
    • Total Assets – demonstrates to investors the tangible “book value” of the company and the ratio of assets to bank debt (as applicable)
    • Cash & Cash Equivalents (Closing Balance) – demonstrates to investors the liquidity of the business and addresses whether the company has sufficient cash and cash equivalents to meet urgent liabilities when they fall due
    • Total Equity (as applicable) – demonstrates to investors the capacity of the company to finance future growth and expansion, as well as give investors a sense of how well the company generates cash
    • Team Size – demonstrates to investors the scale of the company's human capital resources and needs
    • Total Users (as applicable)– demonstrates to investors how large the company's client base is and gives a sense of how much of the target market has been captured