2012 335i Lease Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJK
1
2012 335i ED2014 M32016 340xi2018 Audi Q52018 Audi SQ5
2
3
MSRP$58,145$85,000$63,020$54,400$65,850
4
Residual65.00%58.00%62.00%61%67%
5
Residual Value$37,794$49,300$39,072$33,184$44,120
6
7
Invoice$50,750$75,000$58,425$50,000$58,425
8
Discount10.14%10.00%5.31%6.25%9.38%
9
Dealer$1,500$1,500$1,250$1,000$1,250
10
Selling Price$52,250$76,500$59,675$51,000$59,675
11
12
Aquisition Fee$925$925$925$925$925
13
Documentation Fee$45$45$45$45$45
14
CA Title & Reg$449$449$449$449$449
15
Tire/Battery/MVWEA$7$7$7$7$7
16
County Fee$30$30$30$30$30
17
Other$29$29$29$29$29
18
Total Fees$1,450$1,450$1,450$1,450$1,450
19
20
Tax8.50%8.50%8.50%8.50%8.50%
21
Up-front sales tax$0$0$0$0$0
22
23
Trade-in$0$0$0$0$0
24
Money down$1,450$2,000$2,000$5,000$5,000
25
ED Trip$0$0$0$0$0
26
Security Deposit$0$0$0$0$0
27
Net Capitalized$52,250$75,950$59,125$47,450$56,125
28
29
MF0.002250.00130.00130.001910.00205
30
31
Depreciation$14,456$26,650$20,053$14,266$12,006
32
Monthly Depreciation$401.55$740.28$557.02$396.28$333.49
33
34
Net Cap Cost + Residual$90,044$125,250$98,197$80,634$100,245
35
Monthly Interest$202.60$162.83$127.66$154.01$205.50
36
37
Monthly Payment$604.15$903.10$684.67$550.29$538.99
38
Monthly Sales Tax$51.35$76.76$58.20$46.77$45.81
39
40
Total payment$655.50$979.87$742.87$597.06$584.80
41
42
Total payed over term of lease$25,048.03$37,275.19$28,743.34$26,494.28$26,052.85
43
Monthly$695.78$1,035.42$798.43$735.95$723.69
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
Loading...
 
 
 
Sheet1