Car Lease Calc

	A	B	D	E	G	I	K	L
1	2019 Honda Civic Hatchback				Fees included in lease	Extra Rebates	Fees not included in lease
2	Lease Details						Document Processing	386
3	Negotiated Sale Price	18400	MSRP	22370			SF Registration Fees	85
4	Residual %	64	Lease Term	36			Acquisition	595
5	Money Factor	0.0015	Annual Mileage	12000
6	Down Payment	0	SF Tax	0.085
7
8	Total Fees	0
9	Total Rebates	0
10	Calculated
11	Monthly Lease Payment Before Tax	162.4974222	OTD	1242.309703
12	Monthly Lease Payment After Tax	176.3097031
13			Over 3 Years	7413.149312
14	Gross Cap.
15	Negotiated + Fees	18400
16
17	Cap. Cost Reduction
18	Rebates + Down Payment	0
19
20	Adjusted Cap.
21	Gross Cap. - Cap. Cost Reduction	18400
22
23	Residual Value
24	(MSRP * Residual)/100	14316.8
25
26	Monthly Depreciation
27	(Adj. Cap. - Residual Value)/Lease Term	113.4222222
28
29	Monthly Finance Charge
30	(Adj. Cap. + Residual Value) * MF	49.0752
31
32	APR
33	Money Factor * 2400	3.6
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100