10-03-2018, 12:48 PM | #1 |
Not a BMW Genius
48
Rep 118
Posts |
Spreadsheet for Lease vs Finance
Anybody want to take a crack at my spreadsheet I put together yesterday and let me know if I miscalculated anything or left something out. There is a BMW lease example on the right I used to see if I could get the numbers to match, but they leave so much nuance out in their little grift fine details disclaimer. Tried uploading xlsx file but wouldn't let me. If you would like file to check calculations just message me with your email. Thanks.
Last edited by basque76; 10-03-2018 at 12:59 PM.. |
10-04-2018, 08:15 AM | #3 |
Not a BMW Genius
48
Rep 118
Posts |
No I just slipped that in because I wasn’t sure if there was some bs origination fee for the loan or not. Is that not the case? Car comes in this weekend.
|
Appreciate
0
|
10-04-2018, 10:21 AM | #5 |
Not a BMW Genius
48
Rep 118
Posts |
Not according to BMW website anymore. I just had that in there if possible. The rebate numbers are variable and may or may not be possible. Not sure how strict BMW is about that. I'm going to see what I can get, but if they are going to be dicks I'll just walk away.
|
Appreciate
0
|
10-04-2018, 01:22 PM | #6 |
Lieutenant General
19353
Rep 10,166
Posts |
Just a quick snap shot look but:
- MF and residuals are off depending on age of unit but I think you knew that. 36/10k on 19's is 51%. Destination is included in the MSRP so dont re add it. Gas Guzzler is included in the MSRP so dont re add it. Disposition fee is not collected at inception. and yes there is no acq fee on a retail loan only lease.
__________________
2024 BMW M3 CS Frozen Solid White
2023 BMW M8 Coupe Competition Alpine White 2022 Porsche Carrera GTS Coupe Shark Blue 2020 Audi R8 V10 Performance Suzuka Gray 2012 Mercedes Benz C63 AMG Black Series Obsidian Black |
Appreciate
1
basque7648.00 |
10-04-2018, 03:29 PM | #7 | |
Not a BMW Genius
48
Rep 118
Posts |
Quote:
And yes residuals suck on 19s. Thanks again. |
|
Appreciate
0
|
10-04-2018, 03:41 PM | #8 | ||
Major
1433
Rep 1,361
Posts |
Quote:
|
||
Appreciate
0
|
10-04-2018, 03:50 PM | #9 |
Not a BMW Genius
48
Rep 118
Posts |
5K down with everything else static...about $354/mth difference...and what I have in there now is 2018 rebates...I'm delusional in thinking they'll honor those since they screwed up my order once....but I haven't erased those just yet because it's sad and I'm still romanticizing.
|
Appreciate
1
Neptune71432.50 |
10-04-2018, 04:48 PM | #10 | |
Lieutenant General
19353
Rep 10,166
Posts |
Quote:
So if a 120k msrp car has 10% lower residual, you are rolling 12k plus interest plus tax on that gain in depreciation divided by the term into your payment if the other factors remain static like money factor sell rates. This is a rough view of course since a lower residual over all yields a lower money factor dollar amount since rent charge = net cap plus residual times money factor.
__________________
2024 BMW M3 CS Frozen Solid White
2023 BMW M8 Coupe Competition Alpine White 2022 Porsche Carrera GTS Coupe Shark Blue 2020 Audi R8 V10 Performance Suzuka Gray 2012 Mercedes Benz C63 AMG Black Series Obsidian Black |
|
Appreciate
1
Neptune71432.50 |
Post Reply |
Bookmarks |
|
|