Skip to content
The Financial Modeller
Build free
Insights

What we learn building financial models, written up.

Articles on forecasts, cash flow and valuation, drawn from the models we build and the mistakes we see most often.

Follow by RSS

The first article is on its way. Until then, the guides below cover the basics.

Guides

Or start with a guide.

  1. 01How to build a financial modelThe 7 steps to build a financial model in Excel, the mistakes to avoid, and three routes compared: a template, a consultant, or built free by us.
  2. 02Three-statement modelHow the P&L, balance sheet and cash flow link, the checks that prove they balance, and a three-statement model built free in Excel for your business.
  3. 03Cash flow forecastHow to forecast cash in Australia: debtor days, GST and BAS, seasonal dips, monthly or 13-week. Then have a cash flow model built free in Excel.
  4. 04Financial projections5-year financial projections for a business plan, loan or grant: what to include, how far out to go, what lenders check. Have yours built free in Excel.
  5. 05DCF valuation modelGet a DCF business valuation model built free in Excel: free cash flow, WACC and terminal value on a full forecast, with multiples and NAV beside it.