ExcelWiz Insights
Expert articles on financial modeling, business automation, Excel tips, and data analytics to help you make better business decisions.
Jun 17 2026
Excel for Australian Tax & Compliance: A Complete Guide for Finance Professionals (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
Excel for Business Decision-Making: A Complete Guide for Australian Finance Professionals (2026)
Make better business decisions with Excel - from KPI dashboards and sensitivity analysis to scenario modelling, budget vs actual variance, and what-if analysis. A comprehensive pillar guide for Australian finance professionals and business owners.
Jun 14 2026
SaaS and Technology Business Valuation in Australia: The Complete Guide
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 to Your Property Portfolio
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 Through the Lens of Excess Earnings
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.
Jun 2 2026
Construction Business Valuation: A Guide for Australian Builders and Contractors
How to value a construction business in Australia. Covers WIP contracts, retentions, project-based revenue recognition, tendering history, and the specific adjustments valuers make for builders and contractors.
Jun 2 2026
Building a Pricing Calculator in Excel for Trades and Service Businesses
Build a practical pricing calculator in Excel for tradies and service businesses - with quoting, subcontractor margin management, and a dashboard that shows you if you're actually making money.
Jun 1 2026
Anomaly Detection in Excel for Forensic Accounting and Fraud Detection
A practical guide to using Excel for anomaly detection in forensic accounting and data analytics to identify fraud and irregularities.
May 29 2026
Pharmacy and Medical Practice Valuation: A Complete Guide for Australian Healthcare Owners
How to value a pharmacy or medical practice in Australia. Covers the community pharmacy agreement, AHPRA regulations, patient list valuation, earnings multiples, and what buyers actually pay in 2026.
May 25 2026
EBITDA Adjustments and Normalisation: A Practical Guide for Business Valuation
How to adjust EBITDA for one-off items, owner benefits, and non-recurring expenses when preparing a business valuation. Real Australian examples for SME owners and advisors.
May 22 2026
SME Valuation Multiples by Industry in Australia: 2026 Guide
Practical guide to business valuation multiples by industry for Australian SMEs. Find the right EBITDA multiple range for your sector and understand what drives the number up or down.
May 21 2026
Using Excel to Build an Efficient Employee Rostering System
Learn how to use Excel to design and manage employee rosters efficiently with database-style structures, pivot tables, and charts.
May 19 2026
Business Valuation for CGT Purposes in Australia: A Complete Guide for SME Owners (2026)
How business valuation works for capital gains tax purposes in Australia, including the impact of the proposed CGT discount reforms, small business concessions, and what you need for ATO compliance.
May 18 2026
Cash Flow Forecasting in Excel: A Practical Guide for Australian SMEs
Build a rolling 13-week cash flow forecast in Excel. Practical steps, real formulas, and how to use it for business decisions - not just compliance.
May 16 2026
Business Valuation in Australia: The Complete Guide for SME Owners, Investors and Advisors (2026)
A comprehensive guide to business valuation in Australia covering every method, when to use each approach, how to interpret valuation reports, and what Australian SME owners need to know about the 2026 CGT reform proposals.
Page 1 of 10 (139 posts)