Let’s be honest they aren’t for 99.999% of those that come here. 90% wont even use or understand the already done for them calc.
I really like you but just out of curiosity have you ever worked anywhere but academia? Tried to create or sell a tech product for/to real companies/people? You would learn a whole lot about the real world…
hmmmm… that’s a real stretch. I’ve had several emails from people interested in those calculations. They were very motivated and had no problem understanding them. To be honest, I had a formula with a typo and the guy actually caught it.
Spent 22 years in industry. Worked at Boeing on the B-737 first generation wing design (undergrad is aero engineering). Designed flight management systems (FMS) for the 737. Worked as an actuary and in telecommunications performing revenue/cost analysis for many years.
Cool. I worked with Honeywell in Phoenix for many years on TCAS/FMS/other avionics architecture and design for 737 and business commuter. Designed in a bunch of Intel x86/Pentium processors.
One of the biggest things I learned was knowing my audience and I worked with C level down to techs…so adapt to each levels interests and needs…otherwise would be wasting a lot of time depending on audience.
I’m saying there has to be hundreds/thousands of posts here every day and most reference a dealer quote or made up payment number…hardly any posts reference the math behind their numbers. It’s a lot of ‘it seems high’ or similar. Hardly any of them follow up by doing the math. Most just want to match or beat a number they have seen elsewhere. Haha
I’m pretty good at Excel and tried to create a spreadsheet, but couldn’t get the formula for the CCR to work. 
Post the equations you used.
I served as a consultant to Lear Seigler on the 737 in the late 70’s. At that time, it was known as the performance data computer system which evolved to the FMC with some mods. Today, it’s known as the FMS which is a huge improvement over the PDCS. Also did some work for Sperry Rand close to the Deer Valley airport in Phoenix.
Yes, sadly there is a lot of truth in what you say. It’s always going to be an uphill battle, but I am encouraged by what I’ve seen. Check out @lookbmwi4 post above. He wants to put the formula in his Excel worksheet. Kudos to him.
Guys, no need for a dick measuring contest. Utmost respect for what you both provide to the community. To each their own. Some people enjoy learning the ins and outs and some just want someone else to figure it out for them.
Broke down the formulas in parts tied it to inputs - still couldn’t get it to work.
I was the CEO of Boeing in 1972
Can you post the vales you’re using for each of the variables? Also, the problem is that too much data is missing from the dealer worksheet. I have no idea what money factor they are using. You mentioned .0008… but, how do you know for sure? The gross cap is missing. These are issues that I pointed out in my above posts. I had to make some assumptions hat may or may not be true. Frankly, their worksheet is garbage.
Your calc here basically matches proper software that is capable of using rebates to cover upfronts.
The issue is somewhere in the dealers software/math
This approach is a waste of your time compared to calculating what your target should be.
That’s the only thing you need to do rn and don’t ask for quotes because you’re burning those bridges to get your own offers out there
The math isn’t very complicated and any HS kid should understand it, but if you failed math in HS, or just feel overwhelmed use ChatGPT.
Once again, the dealer’s worksheet is garbage. The only way you’re going to get CCR = 8279.78 is to use the following data some, of which, does not align with the dealer’s garbage worksheet…
Sell Price… 71331.00 (assume initial cap cost = sell price)
Capped Fees… 152.85 … ???
Gross Cap… 71483.85 = S + M
CCR… 8279.78
Adjusted Cap… 63204.07
Res. Value… 39886.60 = R
Term… 36 = N
MF… .00080 = F
Sales Tax Rate… 10.25% = t
U = 0
C = 11900 = Rebate
K = 1966.52 = Sum of the fixed lease inception fees
C - K = 9933.48
Base Pay = .00080 x (63204.07 + 39886.60) + (63204.07 - 39886.60) /36
= 730.18
Monthly Pay = 730.18 x 1.1025
= 805.02
Chapstick is not always right. I never use chapstick and can promise you it won’t calculate the CCR correctly. People need to start relying on themselves instead of others or calculators. Calculators won’t teach them squat. Computer software often contains bugs and that goes for dealer desking software.
We needed all this to tell OP they can do better than 7% off?
Ahhhhh.. Unless your name is Thornton A. Wilson, I might believe you… except he died 26 years ago. Are you deceased?
