π EV Lease vs Buy Model β Salary Sacrifice Scenario Engine
This project explores the financial advantage of novated leasing electric vehicles compared to buying outright. Built entirely in Excel, the model calculates net present value savings across dozens of vehicle types, lease durations, and Australian states β all through salary packaging.
Key features:
π° Full lease vs purchase cost comparison (pre-tax vs post-tax dollars)
π Calculates NPV savings and percentage discounts by vehicle and lease term
π§Ύ Incorporates local tax rules, stamp duty, GST thresholds, and registration fees
π Dynamic data tables let users instantly see results across 30+ scenarios
π§ Designed for low-maintenance β update one input and the entire model adjusts
Rather than just crunch numbers, this model demonstrates structured financial modelling in Excel β clear inputs, readable logic, and scalable analysis, ideal for real-world decision-making.
