SHOW ONLY IN EXCEL. No hard coded formulas.

You are considering leasing or purchasing a car. The details of each of the methods are above.

A. If the lease is for 24 months. What should you do?

B. What will your answer be if the estimated market value of the car at the end of the lease is $10,000? Show a data table with your answer for market value of the car at the end of the lease between $10,000 and $18,000 jumping by $500.

2 MSRP 3 Capitalized cost 4 Destination charge 5 Acquisition fee 6 Security deposit AUTO LEASE VERSUS PURCHASE 50,000.00