Financial Modelling
Three-way models, cash flow forecasting, business valuation, sensitivity analysis, and property feasibility, all built in Excel.
87 posts in this category
Jul 13 2026
Construction Profitability Tracking in Excel
Track profitability at the job level in Excel. Covers cost allocation, variation tracking, overhead recovery, and profit fade analysis for construction businesses.
Jul 11 2026
Excel for Due Diligence: Building a Deal Review Workbook
Walk through a structured due diligence workbook in Excel. Financial statement analysis, valuation cross-checks, synergy modelling, and red flag tracking for SME acquisitions.
Jul 10 2026
Excel for Government Reporting and Compliance Tracking
Government teams use Excel differently. Audit trails, data integrity controls, multi-stakeholder reporting, and template standardisation for compliance-heavy environments.
Jul 6 2026
How to Build a Break-Even Calculator in Excel
Build an interactive break-even calculator in Excel step by step. Data tables, goal seek, scenario selectors, and dynamic charts for pricing decisions.
Jul 4 2026
How to Build Dynamic Financial Models in Excel (Step by Step)
A practical guide to building flexible, auditable financial models in Excel. Covers model structure, dynamic formulas, scenario switching, and integrated statements.
Jul 1 2026
Monthly P&L Forecasting in Excel for Small Business
Build a monthly profit and loss forecast in Excel that actually helps you make decisions. Step-by-step instructions with driver-based assumptions, variance tracking, and scenario planning.
Jun 28 2026
Build vs Buy: Financial Models for Your Business
Not sure whether to buy a template, build your own financial model, or hire a consultant? Here is a practical framework for deciding based on your business stage, complexity, and budget.
Jun 27 2026
GST, PAYG & Super in Excel Models
Australian tax rules create specific modelling challenges. Learn how to handle GST, PAYG withholding, superannuation guarantee, and ATO compliance timing in your Excel financial models.
Jun 25 2026
Cash Flow Forecasting: Direct vs Indirect Method in Excel
Two ways to forecast cash flow, one practical guide. Learn the difference between direct and indirect cash flow methods, when to use each, and how to build both in Excel with Australian GST and PAYG considerations.
Jun 23 2026
Which Excel Financial Model Do You Need?
Not sure which financial model to build? This decision framework helps you choose between cash flow forecasting, break-even analysis, 3-way models, pricing calculators, DCF valuations, and more - based on your business stage and decision type.
Jun 22 2026
Property Development Cash Flow Model in Excel
Build a comprehensive cash flow model for property development in Excel. Covers cost phasing, revenue milestones, debt draw schedules, IRR calculations, and sensitivity analysis for Australian developers.
Jun 17 2026
Excel for Australian Tax & Compliance (2026)
Master ATO compliance, BAS preparation, payroll reconciliation, depreciation schedules, and tax reporting in Excel. A comprehensive pillar guide for Australian accountants, bookkeepers, and business owners.
Jun 14 2026
SaaS and Technology Business Valuation in Australia
A practical guide to valuing SaaS and technology businesses in Australia. Covers ARR multiples, churn analysis, R&D tax offset valuation, capitalised development costs, and the specific adjustments valuers make for subscription-based technology companies.
Jun 6 2026
Negative Gearing in Excel: Model the 2026 Budget Changes
Build an Excel model to calculate how the 2026 Federal Budget negative gearing and CGT changes affect your property investment returns. Includes before/after scenarios, break-even analysis, and hold vs sell decision framework.
Jun 6 2026
Valuing the Unprofitable Giants: OpenAI, SpaceX and Anthropic
How do you value companies worth a combined $3.75 trillion with almost no current profits? The excess earnings and revenue multiple methods applied to three of the most anticipated IPOs in history.
Page 1 of 6 (87 posts)