Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Facts and Assumptions: Lease Term in Months 24 Lease Down Payment $ 500.00 Month

ID: 2653826 • Letter: F

Question

Facts and Assumptions:

Lease Term in Months

24

Lease Down Payment

$      500.00

Monthly Lease Payments

$      300.00

Sales Tax Rate

8%

Lease Buyout at End

$ 15,000.00

Title Fee

$        25.00

Car Loan Market Rate

7%

Outright Purchase Price Before Tax and Title

$ 19,500.00

What is the NPV of the lease? Round you answer to the nearest whole number. Do not use $, commas, or decimal points and enter as a positive number. For example, -$34,567.50 would be entered as 34568.

What would it cost you to buy the car today if you were paying cash? Round you answer to the nearest whole number. Do not use $, commas, or decimal points and enter as a positive number. For example, $34,567.50 would be entered as 34568

Facts and Assumptions:

Lease Term in Months

24

Lease Down Payment

$      500.00

Monthly Lease Payments

$      300.00

Sales Tax Rate

8%

Lease Buyout at End

$ 15,000.00

Title Fee

$        25.00

Car Loan Market Rate

7%

Outright Purchase Price Before Tax and Title

$ 19,500.00

Explanation / Answer

We will have to calculate the the present value of all the payments (including down payment and lease buy out price at the end which will include sales tax and title fee as well)

The present value of all the payments can be calculated with the use of PV Function/Formula of EXCEL/Financial Calculator. The function/formula for PV is PV(Rate,Nper,PMT,FV) where Rate = Market Rate, Nper = Number of Months, PMT = Monthly Lease Payment and FV = Future Value (which will comprise of lease buy out price, title fee and sales tax)

_____________

Here, Rate = 7%/12, Nper = 24, PMT = 300 and FV = 15,000 + 15,000*8% + 25 = $16,225

Net Present Value = 500 (Down Payment) + PV(7%/12,24,300,16625) = -$21,311.61 or $21,312 (since the value has to be entered as positive number)