Bimmerfest - BMW Forums - View Single Post - Pen and Pencil Lease Payment Calculation
View Single Post
Old 09-10-2006, 12:31 PM
jd101 jd101 is offline
Officially Welcomed to the 'Fest
Location: Bay Area
Join Date: Aug 2006
Posts: 106
Mein Auto: 2010 535xiT; '97 A4
Originally Posted by knmol View Post

I've attached the updated sheet. It would be nice if there was a listing of how each state calculates tax, so people could easily enter their taxes into this sheet.
This is a really helpful spreadsheet and I'm using it to figure out my lease for an ED 2007 X3.

One question: How should I determine the "State Taxes" amount for California (cell D19 in your spreadsheet)? Is it simply the tax rate times the Total Monthly Lease Payment times the number of months? I don't think the entire tax payment is due at the time of signing in California. So, should I zero out the number in D19 and simply add the monthly tax to the monthly lease payment?
Reply With Quote