📌 Named Ranges & Centralised Config Page

This model is built around a dedicated Config sheet that houses all user-editable variables — highlighted in yellow for clarity. Every input, from tax rates to vehicle parameters, is defined just once and referenced throughout the workbook.

Using Named Ranges across the model:

• 🚫 Avoids hard-to-follow cell references like C10 or Sheet3!$B$5

• ✅ Replaces them with intuitive names like LCT, GST_threshold, TaxRate, and CoC

• 👀 Makes every formula read like a sentence, improving transparency and maintainability

This approach ensures:

• Clear guidance for users on where to update assumptions

• Complete separation of logic and inputs

• High auditability with a single source of truth

🔍 Whether you’re handing off the workbook or revisiting it months later, this structure guarantees it’s immediately understandable.