Financial Modelling
Three-way models, cash flow forecasting, business valuation, sensitivity analysis, and property feasibility, all built in Excel.
103 posts in this category
Oct 18 2026
The Annual Budgeting Process in Excel for SMEs
A practical guide to the annual budgeting process in Excel for SMEs: the budget calendar, department templates, consolidation, review and locking the budget.
Oct 15 2026
Management and Board Reporting Packs in Excel
How to design a monthly management and board reporting pack in Excel: page order, variance sign conventions, one data sheet and version control.
Oct 12 2026
Quote Generator for Small Business
How to build and store quotes for a small business: the fields a quote needs, GST treatment, deposit limits and how to track which quotes actually win.
Oct 7 2026
Build an Excel Scenario Selector With One Input
How to switch a whole model between Base, Upside and Downside from one drop-down cell, using a scenario driver table with CHOOSE or INDEX and MATCH.
Oct 5 2026
Excel Custom Number Formats for Financial Reporting
How the four-section custom format works, how to scale figures to thousands and millions, and when a helper column beats a format in a report.
Oct 2 2026
Profit vs Cash Flow: Why Profitable Businesses Run Out
Why an Australian business can report a profit and still run short of cash, and how to build a monthly profit to cash bridge in Excel that reconciles.
Sep 28 2026
Headcount Planning and Cost Model in Excel (Australia)
How to build an Australian headcount plan in Excel with fully loaded role costs, super, leave loading, payroll tax and start-month timing.
Sep 24 2026
Debt Schedule and Covenant Tracking in Excel
How to build a debt schedule in Excel that rolls every facility forward, feeds the balance sheet debt line and tracks covenant headroom each period.
Sep 9 2026
Overtime & Penalty Rate Calculator in Excel (Australia)
Build an Excel overtime and penalty rate calculator for Australian awards, covering weekend percentages, public holiday rates, casual loading and pay checks.
Sep 4 2026
Financial Model Review: What an Independent Review Covers
What an independent financial model review checks in Australia: formula consistency, circular references, scenario integrity, debt logic and tie-outs, plus what it costs and when to get one.
Aug 30 2026
Driver-Based Financial Forecasting in Excel
Build an Excel forecast from operating drivers like price, volume and headcount instead of a flat growth percentage, with an Australian worked example.
Aug 24 2026
Budget vs Actual for Not-for-Profits in Excel
Track grant funding, restricted funds and program budgets in Excel: a practical budget vs actual framework for Australian not-for-profits.
Aug 12 2026
Industry-Specific Financial Modelling: Key Considerations by Sector
What to model first in your industry: sector-specific drivers, risk factors and metrics for financial modelling and valuation across 9 industries.
Aug 8 2026
Check Register Template: Bank Reconciliation in Excel
Keep a running balance of every transaction with a check register template in Excel. Reconcile against bank statements quickly and accurately.
Jul 31 2026
Travel Expense Tracker Template: ATO-Friendly Excel Spreadsheet
Track business travel costs with this Excel travel expense template. Built for ATO record keeping: dates, amounts, GST, kilometres and receipts.
Page 1 of 7 (103 posts)