Sheet 1 — Calculator (6 Sections):
- Section 1 – Property & transaction details (address, parties, dates, GST registration)
- Section 2 – Acquisition cost (purchase price + GST paid on acquisition + other costs)
- Section 3 – Sale price (contract price + adjustments)
- Section 4 – Margin calculation using the correct ATO formula:
Margin × Rate ÷ (1 + Rate) - Section 5 – Results summary showing GST payable, net margin, and effective GST rate as %
- Section 6 – Eligibility checklist (pre-2000 acquisition, written agreement, GST registration, etc.)
Sheet 2 — Notes & Guide: Explains what the scheme is, who qualifies, how to use the calculator, and key formula references.
Colour coding follows industry standards:
- 🔵 Blue = input cells (user-editable)
- ⚫ Black = formula cells (auto-calculated)
- 🔵 Light blue = summary result rows
Just fill in the blue cells with your transaction values and all GST calculations update automatically.