carlease - Sheet1 This spreadsheet analyzes the...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 This spreadsheet analyzes the lease/purchase decision. In the case of a purchase, it is assumed sales tax is paid on the negotiated price at the time of purchase, and property taxes are paid annually. In the case of a lease, it is assumed sales tax is paid on the difference between the list price and the payoff at the time of purchase, sales tax is paid on the payoff when the lease expires, and property taxes are paid by the lessor. This spreadsheet assumes the item is purchased at the payoff price at the time the lease expires. The lease has additional value to the lessee because of the option not to purchase. The features of your lease may be different than assumed here. Assumptions List price $26,000 Negotiated price $24,000 Lease period (months) 36 Payoff $20,000 Interest rate (APR) 9.00% Effective annual rate 9.38% Sales tax rate 6% Property tax (annual) $300 Lease payment $280 Results Purchase Lease Present value of payments $24,000 $24,154 Present value of sales tax
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

carlease - Sheet1 This spreadsheet analyzes the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online