Do the same thing but do it for a different scenarioShould Mai Lease or Purchase?

Mai is considering the purchase of a Ford F$-150$ Pickup and has negotiated a final price of $$27,690.$ She's trying to decide whether to lease or purchase the vehide.

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

On the other hand, if she buys the truck, she'll have to make a $10\%$ down payment, pay sales tax equal to $8\%$ of the vehicle's price, and make monthly payments of $$563$ on a four$-$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 Mai 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 and then recommend the best strategy for Mai. To complete the worksheet, enter the appropriate values in their corresponding blanks. $($Note: Round each value to the nearest whole dollar.$)$

AUTOMOBILE LEASE$-$VERSUS PURCHASE$-$ANALYSIS