Auto Lease Vs Buy Analysis Excel [WORKING]

This is the "deep" part of the analysis. If leasing saves you $200 per month compared to a loan payment, you should calculate the of that $200 invested in the S&P 500.

Negotiated sales price (MSRP minus discounts). Down Payment: Cash provided upfront. Trade-in Value: Equity from your current car. auto lease vs buy analysis excel

To build this analysis, set up your Excel workbook with these distinct sections: 1. The Inputs (Assumptions) This is the "deep" part of the analysis