I need help with the four questions below, based on these facts. Please show work in an Excel sheet:

LEASE FACTS:

Down Payment	$1,500.00
Lease Term	36 Months
Lease Payments	$189/month
Buy Out Price - End of Lease	$12,000.00
Market Loan Rate	8%
Sales Tax	6.75%
Title Fee	$15.00
Your Highest Credit Card Rate	15.00%
Outright Purchase of Car *before tax and title*	$17,000

1. Assume that you can buy the vehicle for $17,000 before tax and title. TheNPV of the car if you lease will be:

A. -18,229

B. -20,987

C. -17,365

D. -10,500

2.Assume that you can buy the vehicle for $17,000 before tax and title. The NPV of the car if you buy it is:

A. -17,004

B. -20,090

C. -19,076

D. -18,163

For the next two questions, assume that the lease and buy are both reasonable values and that you are paying a 15% interest rate (after tax) on credit card debt. You also plan to keep the vehicle beyond the lease term. In other words, you would exercise the purchase option at the end of the lease term.

3. Assume further that you take advantage of the opportunity to pay off credit card debt with the monthly lease savings.

What is the NPV of the lease?

A. -18,089

B. -17,091

C. -17,004

D. -19,000

4.Assume further that youdo nottake advantage of the opportunity to pay off credit card debt with the monthly lease savings.

What is the NPV of the lease?

A. -19,045

B. -17,900

C. -23,767

D. -28,299