ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
2
3
Input Assumptions Here
Cap CostPurchase Interest
4
MSRP
sale price (including gas guzzler & destination)
426453061.4445706.44
5
sale price
cap reduction (down payment)
18065.59
6
incentivesincentives28554.75
7
down payment
acquisition fee2322.1948942.53
8
security deposit
0.00cap cost
9
acquisition fee
10
registration, etc.
Residual3236.09
11
sales taxMSRP
12
miles/yearresidual %lowmidhigh
13
lease term0.00residual
Depreciation 3 years
157711996524264
14
residual
15
money factor
16
0.00%
interest rate (calculated from money factor)
17
18
Monthly Depreciation
Monthly Interest
19
0.00cap cost0.00cap cost
20
0.00residual0.00residual
21
0.000.00
22
lease termmoney factor
23
#DIV/0!
monthly depreciation
0.00monthly interest
24
25
26
Total Monthly Payment
27
#DIV/0!
monthly depreciation
28
0.00
monthly interest
29
#DIV/0!
base payment
30
#DIV/0!sales tax
31
#DIV/0!
total monthly payment
32
Money put aside5000
33
BMW CCA Rebate500
34
Drive Off Amount
Civic trade in
35
down payment
Total5000
36
0.00
cap reduction sales tax
37
security deposit
Monthly offset138.8888889
38
registration, etc.
39
#DIV/0!
first month payment
Monthly payment after offset
#DIV/0!
40
#DIV/0!
total drive off
41
Estimated insurance
120/month
42
43
Total Lease Cost
Total car expenses monthly
#DIV/0!
44
#DIV/0!
total drive off
45
#DIV/0!
monthly payments
Total Lease cost
46
#DIV/0!
total payments
47
security deposit refund
48
#DIV/0!
total lease cost
49