JupiterMoon
Posts: 245
Joined: Mon Dec 12, 2016 2:16 am

Re: Now I'm Ready to Negotiate

Thu Jan 19, 2017 2:13 am

fromport wrote:
JupiterMoon wrote:You come out a bit high. If you want, I can email you my spreadsheet and see if you can play around with it and give me feedback.


Could you upload your spreadsheet to google spreadsheet and post a URL ?
That way we can all learn from it


Ok very good. I'm fine tuning it a bit as soon as I am finished I'll do exactly that.

JupiterMoon
Posts: 245
Joined: Mon Dec 12, 2016 2:16 am

Re: Now I'm Ready to Negotiate

Thu Jan 19, 2017 2:45 am

https://docs.google.com/spreadsheets/d/ ... =964577275

Here you guys go.

Just make sure when you receive an MSRP value from a dealer, to note if the MSRP given includes destination or not. There is a Yes/No tab to include/exclude it.

Let me know what you guys think. I've cross-referenced it with two other sites and it comes out exactly as it should.

Cheers.

fromport
Posts: 19
Joined: Thu Sep 22, 2016 6:18 pm

Re: Now I'm Ready to Negotiate

Thu Jan 19, 2017 4:45 am

JupiterMoon wrote:https://docs.google.com/spreadsheets/d/1Wu1M4pVKXxcGrKkl1ONe9oj7IJL3e9JEuo-ENiJgfaE/edit#gid=964577275

Here you guys go.

Just make sure when you receive an MSRP value from a dealer, to note if the MSRP given includes destination or not. There is a Yes/No tab to include/exclude it.

Let me know what you guys think. I've cross-referenced it with two other sites and it comes out exactly as it should.

Cheers.


*excellent*

Very informative, thanks a lot !
2011-2014 nissan leaf 32kmiles (returned at end of lease)
2 x 2014 toyoya rave4ev (leased until 2017) 33k &17k miles
2016-now 2002 GEM NEV E825 6K miles
2016-now 2002 GEM NEV E825 with truck bed, converting to li-ion
2019 -now bolt premier

adamsocb
Posts: 29
Joined: Tue Nov 29, 2016 3:38 pm

Re: Now I'm Ready to Negotiate

Sun Jan 22, 2017 11:29 pm

JupiterMoon wrote:You come out a bit high. If you want, I can email you my spreadsheet and see if you can play around with it and give me feedback.


Thanks for the interest JupiterMoon. Where do you see it high?
I too have a detailed calculating spreadsheet and it matches my actual lease contract within $0.03 on the total of all payments. Monthly payment is a match to the penny and drive-off is within $0.01. It also matches using the GM Financial Dealer Workbook calculation sheet. As the sale price goes up and down the DMV fees will change by a few $$ but not enough to make much difference in the payment with a fixed $2,500 drive-off. In my sheet you have to adjust the "Buyer Down Payment" as other parameters change to keep the drive-off at $2,500. The math to work the "Buyer Down Payment" backwards from the desired drive-off or "due at signing" is not worth the effort for me. I will try your sheet as well and see if it matches my lease contract.

Here is a link to my calc sheet:
http://www.projectcba.com/2017_bolt/2017_bolt_ev_lease_calculator_loaded_premier_msrp.xlsx
EV's:
2011 Volt (turned in Feb 2014)
2014 Spark EV (Lease Up Feb 2017)
2017 Bolt EV Premier, all options
Gas Cars:
2014 Corvette Stingray
2013 Fiat 500 Abarth
2000 ASA Stock Car

adamsocb
Posts: 29
Joined: Tue Nov 29, 2016 3:38 pm

Re: Now I'm Ready to Negotiate

Mon Jan 23, 2017 12:11 am

JupiterMoon wrote:https://docs.google.com/spreadsheets/d/1Wu1M4pVKXxcGrKkl1ONe9oj7IJL3e9JEuo-ENiJgfaE/edit#gid=964577275

Here you guys go.

Just make sure when you receive an MSRP value from a dealer, to note if the MSRP given includes destination or not. There is a Yes/No tab to include/exclude it.

Let me know what you guys think. I've cross-referenced it with two other sites and it comes out exactly as it should.

Cheers.


I just ran it with your sheet and got exactly the same numbers as mine. Very cool the numbers are the same and I am confident these calculators are accurate!

Your Sheet with my numbers

I did notice that your sheet subtracts the $7,500 Federal Tax Credit from the "Adjusted Capital Cost" calculation. The GM Financial Bolt lease does not do this. Instead they inflate the residual (it would normally be less than 50% for 36 month, 36,000 miles) and they provide a $2,500 rebate (CCR). Also the wholesale Money Factor was 0.00072 as of January 17, 2017. It may have changed since then.
EV's:
2011 Volt (turned in Feb 2014)
2014 Spark EV (Lease Up Feb 2017)
2017 Bolt EV Premier, all options
Gas Cars:
2014 Corvette Stingray
2013 Fiat 500 Abarth
2000 ASA Stock Car

JupiterMoon
Posts: 245
Joined: Mon Dec 12, 2016 2:16 am

Re: Now I'm Ready to Negotiate

Mon Jan 23, 2017 1:27 am

DorthyWilliams wrote:Wow, thanks for sharing your calculations here. I think this should be more exciting for me as I am looking also to lease Bolt EV. I have found the calculations from DSR Leasing and they have just $279/month . I just want to know the difference of this calculations and in your calculations here. I don't know how to solve or calculate it on my own as I am just new in car leasing. What do you think about this listing?


So I saw this deal and this is what I can say about it given what they tell us:

ANN. MILES: 10000
PAYMENT: $279
CAPITAL REDUCTION: $2,999
REBATE: $2,500


This is an LT with no packages...which will be hard to find but let's say you do....

Residual: 61%
MF: .0005
Price Sold: (unknown) - but we can figure this out using Excel's goal seek.

Down-payment: $2999 (which INCLUDES drive off fees - make a note of that!).
Tax Rate: 8.75% (for where I'm at)

The results we get:

Price Sold then is: $36,651 (3.2% off MSRP)

Final Monthly Payment: $333.63 ($278.90 + $27.89 interest + $26.74 tax).

What goes towards the cap cost?

$2500 lease cash ( which is from the $7500 federal rebate they aren't giving you)
$1239.13 down-payment that you write a check for
$1759.87 drive off fees and taxes and first down

So $3739.13 goes towards cap cost reduction.

I hope this makes sense.

JupiterMoon
Posts: 245
Joined: Mon Dec 12, 2016 2:16 am

Re: Now I'm Ready to Negotiate

Mon Jan 23, 2017 1:38 am

adamsocb wrote:
JupiterMoon wrote:https://docs.google.com/spreadsheets/d/1Wu1M4pVKXxcGrKkl1ONe9oj7IJL3e9JEuo-ENiJgfaE/edit#gid=964577275

Here you guys go.

Just make sure when you receive an MSRP value from a dealer, to note if the MSRP given includes destination or not. There is a Yes/No tab to include/exclude it.

Let me know what you guys think. I've cross-referenced it with two other sites and it comes out exactly as it should.

Cheers.


I just ran it with your sheet and got exactly the same numbers as mine. Very cool the numbers are the same and I am confident these calculators are accurate!

Your Sheet with my numbers

I did notice that your sheet subtracts the $7,500 Federal Tax Credit from the "Adjusted Capital Cost" calculation. The GM Financial Bolt lease does not do this. Instead they inflate the residual (it would normally be less than 50% for 36 month, 36,000 miles) and they provide a $2,500 rebate (CCR). Also the wholesale Money Factor was 0.00072 as of January 17, 2017. It may have changed since then.


Adam,

You can change that number in my spreadsheet to accurately reflect what they are offering at this particular time. This will drastically alter the payments as you'll see. Let me know if you need help in figuring out what's going on but from what it sounds like you've got it all figured out :)

wq2345
Posts: 8
Joined: Thu Jan 07, 2016 8:07 pm

Re: Now I'm Ready to Negotiate

Wed Feb 01, 2017 2:29 am

Bumping this thread up cause I have a feeling there might be others who could find it as useful as I did. As I searched for a reasonable deal on our car yesterday, I found this thread one of the more useful ones especially adamsocb's original post. Thanks for the posts everyone.
I've posted this elsewhere on the 'How much did I pay' thread, but here is the deal I got yesterday (1/30/2017):

Bolt EV Premier +Infotainment +DriverConfidence Packages, DC Charging
Arctic Blue, Dark gray leather interior
MSRP: $43,510
CCR: -$3,739.32 ($2,500 rebate + further discounts)
Capitalized cost: $39,952.38
Miles/yr: 10000
Payment: $432.18 + tax = $470.00/month (LA County)
36 month lease
Residual = $26,106 (60%)
Due at signing: $2,500 (incl first month's payment, taxes, fees)

I'm sure others might be able to do better. I negotiated with 3-4 dealers till I got numbers I was happy enough with.
______________EV History_________
2008 Mini-E
2011 BMW Active-E
2011 Nissan Leaf SL
2013 Toyota RAV4EV
2014 Tesla Model S
2016 Kia Soul EV+
2017 Chevy Bolt Premier, Arctic Blue/Dark Gray, +Pkgs, DCFC

siennared
Posts: 30
Joined: Wed Feb 01, 2017 3:07 am

Re: Now I'm Ready to Negotiate

Wed Feb 01, 2017 3:16 am

In the SF Bay Area, the best dealership I found is Dublin Chevrolet. They have $1600 off MSRP and their online correspondence is upfront and detailed. They have a few LT with fast charging options still available, I think. I backed off because I am cheap :P and wanted more discount than what is being offered. Came across impressed with their communication and never felt like they they would play games.

Return to “Buying / Leasing / Dealerships”