Build a simple 3-statement financial model for a new business

Step by step

1. 01

   Start with revenue assumptions

   Price × units × growth. Keep it monthly for year 1.

2. 02

   Build the income statement

   Revenue − COGS = gross profit. Subtract operating expenses to get EBITDA.

3. 03

   Link the cash flow

   Start with net income, add back non-cash items, account for working capital.

4. 04

   Balance the balance sheet

   Assets = liabilities + equity. If it doesn't balance, your linking is off.

5. 05

   Add scenarios

   Best, base, worst — toggle with a single cell.