Lease worksheet help - Audi Q7

Hi there,
I’m going to put an offer on an audi q7 (with the intention of negotiating to a middle ground). I wanted to transfer my offer into a lease worksheet format to help make the sales guys job easier.

Does my worksheet below translate to the parameters I’m asking for?

I really appreciate your help!

I want:
10k miles, 36 months
MSRP 60365
12.5 % off MSRP
$1500 off for season of audi
$1000 off for additional incentives
Add $999 for audi Care
Residual 57%
MF 0.00089
Roll all drive offs and first month into the lease
Only want to Bring 9 MSD to closing

CAPITALIZATION
MSRP $60,365.00
DISCOUNT 12.5% $7,545.63
SELLING PRICE $52,819.38
AFTER MARKETS (Audi Care) $999.00
DOC FEE $85.00
ACQUISITION FEE $895.00
LICENSE FEE $300.00
GROSS CAP COST $55,098.38
CAP COST REDUCTION
CASH DOWN
TOTAL REBATES
SEASON OF AUDI $1,500.00
WESTERN LEASE INCREMENTAL BONUS $1,000.00
MARKETING ALLOWANCE
AMT APPLIED UPFRONT $647.85
TOTAL CAP REDUCTION $1,852.15
NET CAP COST $53,246.23
RESIDUAL
MSRP $60,365.00
OPT PKG DISCOUNT
HARD ADDS
ADJ MSRP $60,365.00
MRM
RESIDUAL % 57.00%
RESIDUAL AMOUNT $34,408.05
MILEAGE PROGRAM 10,000
ANNUAL PLANNED MILES 10,000
PREPAID CENTS/MI $0.15
ADJ RESIDUAL $34,408.05
PAYMENT
TERM 36
RATE/MONEY FACTOR 0.00089
# OF ADV PAYMENTS 1
# DAYS OF 2ND PAYMENT 30
2ND PAYMENT DATE 1/17/2021
SECURITY DEPOSIT $6,075.00
ADVANCE PAYMENT $647.85
TOTAL CAP REDUCTION $1,852.15
UPFRONT CHARGES
INITIAL PAYMENT $8,575.00
DUE ON DELIVERY $6,075.00
MONTHLY BASE CHARGE $601.30
MONTHLY TAX 7.75% $46.60
PAYMENT $647.90

7 posts were merged into an existing topic: Good Lease Deal? 2021 Audi Q7, 45, Premium. MSRP $60,365, Monthly payment $631 (pre-tax)