Use this template to analyze whether to buy or lease a car. It assumes that the discount for present value and the cost of borrowing are different, though they could be equal.
Enter lease and purchase data in unlocked cells. The tax consequences of a lease and a purchase may be decisive and will vary in each instance, so you should see your tax advisor if taxation enters the picture. Always check with your professional advisors before you make an important financial decision.
To view the template, click the worksheet tab labeled Template at the bottom of the screen or press Ctrl-PgDn. With the exception of data entry cells, all cells are protected. Use the Tab key to move from one unprotected cell to the next.