Adjust these numbers to your lease (hover mouse over cell for help):
MSRP: $35,550.00 Term (months): 36 Mileage rate info:
Negotiated Price: $33,050.00 Money factor: 0.00125 Pre-Paid per mile: $0.15
Inception Fee(s): $450.00 Sales tax rate: 3.00% Lease end per mile: $0.18
Disposition Fee: $395.00 Residual: $16,000
Down payment: $2,000.00
New York lease
Miles allowed (total for term): 36,000
calculation?
Roll inceptions into payment? Projected excess miles (total): 0
How to pay for excess miles:
Roll taxes into payment?
Your Lease Details:
Capitalized cost: Lease terms:
MSRP: $35,550.00 Term (months): 36
Cap Cost: $33,050.00 Money factor [%]: 0.00125 3.000%
Tax rate: 3.00%
Acquisition Inc'd: $450.00 Residual [%]: $16,000 45.0%
Cap Cost Red: ($2,000.00) Overage (per mile): $0.18
Extra Mileage Cost: $0.00
Adj. Cap Cost: $31,500.00 Mileage Included: 36,000
Overage planned: 0
TERM DEPREC: $15,500.00 Overage Cost: $0.00
INTEREST: $2,137.50
Payment details: Total due up front (at signing):
TERM DEPREC/MO: $430.56 TOTAL TAX: $0.00
INTEREST/MO: $59.38 EXTRA MILEAGE: $0.00
TAX/MO [total]: $14.70 $529.20 INCEPTION FEE(S): $0.00
TOTAL/MO: $504.63 FIRST PAYMENT + DP: $2,504.63
TOTAL DUE: $2,504.63
Tax-up-front savings:
IN-PAYMENT TAX: $529.20 Total due at lease termination:
UP-FRONT TAX: $465.00 EXTRA MILEAGE FEE: $0.00
SAVINGS: $64.20 DISPOSITION FEE: $395.00
SAVINGS/MO: $1.78 TOTAL DUE: $395.00
TOTAL LEASE COST
$20,561.70
Written by Chris Blessing (webguy@330i.net) | v1.07 | Last revised: 4/5/2005
Description Code Invoice MSRP
Base price --- $30,000 $35,000
Destination charge (req'd) --- $550 $550
Gas Guzzler Tax ---
Any other taxes (luxury, etc.) ---
$0 $0
$30,550 $35,550
($2,500)
$33,050
Discount:
MSRP Discount: $2,500
Options Totals
Sub Totals
less discount off msrp
Total pre-tax
Help
Have a question? Drop me an email, webguy@330i.net
I am also interested in hearing from you if you have any particular
feature requests or bug reports! To the best of my knowledge, the
calculations here are accurate but you know I can't be held
responsible for any mishaps, miscalculations, misunderstandings, or
missed deals because you pissed off your sales guy by printing this
out and bringing it to him. ;)
Changelog
v1.07 - added NY state options
- fixed tax calculation error
- added aggregate lease term cost
v1.06 - fixed car config options addition
v1.05 - fixed comment box for residual value
v1.04 - added option fields to car config sheet
- colorized some cells for ease of editing
- implemented "cell security"
v1.03 - added car configuration sheet
- updated lease details display config
v1.02 - fixed residual percentage bug
v1.0?? - I can't remember, but Sarafil helped ;)