Monthly Payment Tool

centra28

Badlands
Well-Known Member
First Name
Dale
Joined
Jul 24, 2020
Threads
13
Messages
636
Reaction score
1,363
Location
Kansas City, MO
Vehicle(s)
2021 Jeep Gladiator Mojave
Your Bronco Model
Badlands
Clubs
 
I built this tool for myself to use to try and figure out what my monthly payment would be if financed. I tweaked it a little bit after some more info came out. I left all cells unprotected so you can change at will. The formula I am using for calculating the financing is visible in column S.

For myself I wanted to compare monthly payments of what I would want in a Black Diamond trim vs Badland trim, so that is the explanation for the colors and the data left populated in the cells. I left the data in the cells as an example of how to use. Just delete the items in blue or black and customize with your own data. I also listed some of the pricing from the surveys in columns O & P - but not all as I only listed the items for the trims that I was interested in keeping.

Hope this helps you. I'll try to answer questions but I think it is self explanatory. Keep in mind this is just for fun and should not be considered to be exact as I could not possible consider all variables, though I did validate the results against the pricing tool on the ford site.

note, for the finance percent enter the decimal not the % number. so in the examples I left I used 3.5% entered as 0.035. If you wanted to use 5%, as an example, then enter as 0.05. It does not work at 0% so just use a really small decimal (like .000001) to get a decent result.


Advertisement
 

Attachments

Lordbam

Outer Banks
New Member
First Name
Biagio
Joined
Jul 30, 2020
Threads
0
Messages
2
Reaction score
4
Location
Texas
Vehicle(s)
Bmw
Your Bronco Model
Outer Banks
Clubs
 
This is awesome thanks for sharing!!
 
OP
OP
centra28

centra28

Badlands
Well-Known Member
First Name
Dale
Joined
Jul 24, 2020
Threads
13
Messages
636
Reaction score
1,363
Location
Kansas City, MO
Vehicle(s)
2021 Jeep Gladiator Mojave
Your Bronco Model
Badlands
Clubs
 
If it makes anyone feel any better, my Badlands/Lux package dreams are pretty well crushed.
 

Advertisement

sprtsmac

Big Bend
Well-Known Member
First Name
AJ
Joined
Jul 27, 2020
Threads
0
Messages
144
Reaction score
200
Location
Oregon
Vehicle(s)
2000 F-150 XLT, 2019 Ford Escape
Your Bronco Model
Big Bend
So cool. Thanks for sharing.
 

Bronco4lyfe85

Banned
Badlands
Banned
Banned
First Name
William
Joined
Aug 17, 2020
Threads
21
Messages
5,039
Reaction score
17,877
Location
Colorado
Vehicle(s)
2019 Challenger Scat Pack
Your Bronco Model
Badlands
If it makes anyone feel any better, my Badlands/Lux package dreams are pretty well crushed.
Why would that make anyone feel any better?
 

Bronco4lyfe85

Banned
Badlands
Banned
Banned
First Name
William
Joined
Aug 17, 2020
Threads
21
Messages
5,039
Reaction score
17,877
Location
Colorado
Vehicle(s)
2019 Challenger Scat Pack
Your Bronco Model
Badlands

Bronco4lyfe85

Banned
Badlands
Banned
Banned
First Name
William
Joined
Aug 17, 2020
Threads
21
Messages
5,039
Reaction score
17,877
Location
Colorado
Vehicle(s)
2019 Challenger Scat Pack
Your Bronco Model
Badlands
OP. This is awesome!! Thanks a ton, very easy to use and get an idea of what i’m looking at.
Advertisement

 

 
Top