The Chief Modeller
The financial modelling blog.
Financial modelling argued and checked: business decisions, technical deep dives, and AI and modelling.
Follow by RSS- Business · Cash flowBy The Chief Modeller6 min read
Payday Super didn't change your super bill. It called in a loan
Super still costs 12% of wages. What changed is when it leaves the bank, and most forecasts built before July still show the old timetable.
- Technical deep dives · Modelling craftBy The Chief Modeller9 min read
Circular interest: solve it in one cell, or know the error
Iterate, paste a breaker macro or use opening balances? For one tranche with a sweep the loop has a one-cell answer, and the shortcut has a known cost.
Guides
Or start with a guide.
- 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.
- 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.
- 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.
- 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.
- 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.