A car buyer has two financing alternatives: to lease or to purchase. It is important to evaluate all the options and analyze the consequences of lease versus purchase decision. The understanding of a comparative worksheet that analyzes the automobile lease versus purchase decision will help in making an informed choice.

How should a lease$-$versus$-$purchase analysis be conducted? How can this worksheet be applied to help you or someone else make their financing decision? Consider the following scenario:

Should Kenji lease or purchase?

Kenji is considering the purchase of a Ford F$-150$ Pickup and has negotiated a final price of $$27,690.$ He's trying to decide whether to

lease or purchase the vehicle.

If he leases, he'll have to pay a $$550$ security deposit, a capital cost reduction $($down payment$)$ equal to $10\%$ of the vehicle's cost, and monthly payments of $$491$ over the three$-$year term of the closed$-$end lease. The truck will have a residual value of $$11,076.$

On the other hand, if he buys the truck, he'll have to make a $10\%$ down payment, pay sales tax equal to $8\%$ of the vehicle's price, and make monthly payments of $$736$ on a three$-$year loan that charges $4\%$ interest.

Be aware that funds used as down payments and security deposits incur an opportunity cost of $4\%,$ as they could have earned interest for Kenji over the period of the lease or loan.

Use the automobile lease$-$versus$-$purchase analysis worksheet that follows to determine the total cost of both the lease and the purchase strategy fo Kenji. To complete the worksheet, enter the appropriate values in their corresponding blanks. $($Note: Round each value to the nearest whole dollar.$)$

$\backslash$table$[[$LEASE$,$Item Description,$\backslash$table$[[$Amoun$],[($$$)]]],[,$Initial Payment,$],[1a.,$Capital Cost Reduction,$