📌 Tables — Structure Without Overhead

"Simple, structured, and scalable — without Power Query."

While many models pull data dynamically using Power Query, this report demonstrates that well-structured native Excel tables can be just as powerful when working with static or rarely-changing inputs.

All external cost assumptions — stamp duty, registration, vehicle pricing, dealer fees, and residual values — are stored as formal Excel Tables. This enables:

• 🔄 Auto-expansion when new rows or vehicles are added

• 🔍 Easy filtering and sorting for audit or review

• 📘 Structured references like TableVehicles[Cost (AUD, excl. GST)] instead of confusing G14:G52

• 🧠 Readable formulas that work seamlessly with functions like XLOOKUP, INDEX/MATCH, and FILTER

• ⚙️ Dynamic calculations — changes in the source table flow directly into the downstream model logic

By keeping the data embedded in structured tables rather than scattered across ad hoc ranges, we ensure:

• ✳️ Low maintenance over time

• 👁️‍🗨️ Clear traceability from input to output

• 📊 Tabular logic that supports matrix-style calculations later in the model

This approach balances transparency with power — perfect for models meant to be audited, modified, or handed off to others.

🖼️ Screenshots in this section include:

• Stamp Duty by State

• Dealer Delivery Fee Matrix

• Full EV Vehicle List with Pricing

• Registration Costs by State

• Residual Value Table by Lease Term