When clients lean toward purchasing instead of leasing, use this spreadsheet tool to demonstrate the financial impact of their decision. All you have to do is enter a few numbers related to the deal, and it will automatically generate actual after-tax monthly costs for an outright purchase, a lease and a loan for the same acquisition.
The file includes a user guide. You'll need Microsoft® Excel 2000 or later, with the Analysis ToolPak and the Analysis ToolPak-VBA installed.