📌 Data Tables — Every Permutation, Instantly

"One formula. Hundreds of outcomes."

This section highlights one of Excel’s most powerful yet underutilized tools: Data Tables. With just a single formula as the base, these tables evaluate dozens (or hundreds) of input permutations in one go — no VBA, no copy-pasting, no redundancy.

🔄 How It Works

In this project, Data Tables are used to show:

• 💰 Net Present Value of Leasing for each car model across 1–5 year terms

• 📉 Percentage Discounts vs. outright purchase for over 40 vehicle types

Each row represents a vehicle. Each column is a lease term. Behind the scenes, a single engine formula calculates the present value or discount, and Excel's What-If engine fills in the rest.

🚀 Why Data Tables Are a Game-Changer

• ✅ Speed: Model all possible scenarios without duplicating formulas or sheets

• ✅ Simplicity: One formula drives the entire matrix

• ✅ Clarity: Easily present ranges of outcomes for decision-makers or stakeholders

• ✅ Power: Perfect for pricing models, contract negotiation prep, budgeting tools, or capital investment trade-offs

🧠 Applications Beyond This Model

This technique can be used in:

• 🏦 Capital management: testing multiple discount rate and duration scenarios

• 📝 Contract negotiation: comparing vendor terms and payment timing

• 📅 Budget planning: projecting operating cost ranges across departments or portfolios

📊 Examples in This Report

• $ Discount Table — Shows cash benefit from leasing for every vehicle and term

• % Discount Table — Shows how much value is retained vs. full purchase over time

• Scenario Table for Q8 e-tron — Highlights the benefit curve across lease durations

With structured inputs, a clean logic engine, and a Data Table view, the model provides instant insight at scale — and can easily be extended to other financial use cases.