# Help me understand this worksheet **URL:** \ **Category:** Ask the Hackrs\ **Tags:** nj\ **Created:** [June 11, 2024, 11:36pm UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926 "2024-06-11T23:36:42Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mjr0483](https://leasehackr.b-cdn.net/letter_avatar/mjr0483/32/5_5575768a8748004e209b776fc1b2916d.png) [@mjr0483](https://forum.leasehackr.com/u/mjr0483)\ **Post date:** [June 11, 2024, 11:36pm UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/1 "2024-06-11T23:36:42Z")
I am very new to this and this worksheet is very, very busy. How do I get this into the calculator to understand the deal? Location: NJ Car: 2024 Nissan Rogue SV MSRP: $37,230 Selling: $35,530 Mileage: 12k 36 months Monthly Payment: $528 DAS: $528 ![image](https://leasehackr-assets.b-cdn.net/original/3X/c/f/cf3bc54c0ba53950151da08f10fc41808a03874d.jpeg) ---
**Author:** ![Phat](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/phat/32/1087_2.png) [@Phat](https://forum.leasehackr.com/u/Phat)\ **Post date:** [June 11, 2024, 11:43pm UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/2 "2024-06-11T23:43:15Z")
> [@mjr0483](#): > > Monthly Payment: $528 run quickly ---
**Author:** ![mllcb42](https://leasehackr.b-cdn.net/letter_avatar/mllcb42/32/5_5575768a8748004e209b776fc1b2916d.png) [@mllcb42](https://forum.leasehackr.com/u/mllcb42)\ **Post date:** [June 11, 2024, 11:44pm UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/3 "2024-06-11T23:44:30Z")
> [@mjr0483](#): > > How do I get this into the calculator to understand the deal? This will walk you through how to get it into the calculator. With that said, if you dont know what the deal should be before you ever talk to a dealer, youre setting yourself up for failure. > [@LH Calculator and how to use it](https://forum.leasehackr.com/t/lh-calculator-and-how-to-use-it/246415/1): > > One of the more common posts we see here are from people trying to utilize the [LH Calculator](https://leasehackr.com/calculator/) and struggling to get the correct numbers. More often than not, this is the result of user error, so let this be a guide on how to use the calculator and what values go where. With that said, a few starting notes. Read these 3 times before continuing: The calculator is not perfect, there are some limitations in how things are calculated. Do not expect to match an offer perfectly. There are often diffe… ---
**Author:** ![gohawks23](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/gohawks23/32/191452_2.png) [@gohawks23](https://forum.leasehackr.com/u/gohawks23)\ **Post date:** [June 12, 2024, 12:13am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/4 "2024-06-12T00:13:47Z")
You will get more help if you post your LH calc attempt for review…it will be a good exercise for you to do and help you to eventually generate your own target payment/DAS to propose to dealers. ---
**Author:** ![delta737h](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/delta737h/32/11316_2.png) [@delta737h](https://forum.leasehackr.com/u/delta737h)\ **Post date:** [June 12, 2024, 1:23am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/5 "2024-06-12T01:23:55Z")
> [@mjr0483](#): > > How do I get this into the calculator to understand the deal? > **[Leasehackr Calculator - Hack your next lease | Leasehackr](https://leasehackr.com/calculator?make=Nissan&miles=12000&msrp=37230&sales_price=35530.35&months=36&mf=.00237&msd=0&dp=0&dealer_fee=799&acq_fee=695&disp_fee=395&taxed_inc=0&untaxed_inc=0&rebate=0&resP=66&gov_fee=339&sales_tax=6.625&demo_mileage=0&memo=&tradein=0&fin_sp=37230&fin_taxed_fee=0&fin_untaxed_fee=0&fin_term=60&fin_apr=0&fin_dp=0&fin_rebate=0&fin_ps_rebate=0&fin_tax=0&keep_term=60&exp_rv=0&service_fee=0&totalLeaseTax_radio=true&cap_tax=true&bmw_demo_25=true&lease_result_mode=true&dealerFee_check=false)** > > Score the best deal with real-time lease and finance data on demand and the ultimate lease/finance calculator trusted by America’s expert leasing community. To be exact, your DAS = 866.75 with 35 remaining monthly payments of 527.25 each. The knucklehead dealer computed taxes (52.93) on the 799-doc fee and capped them which is why they show a slightly inflated payment of 528.85. That is completely wrong. Your sales tax in NJ is levied on the sum of the base payments as follows… 491.88 x 36 x 6.625% = 1173.13 If you would like to see more calculations (e.g., base payment, lease payment, etc.), please let me know. PS: I frown on using online calculators and prefer to use only those that I’ve created (Excel, Mathematica). And, frankly, I would refuse to do business with dealers that can’t perform calculations correctly. There is no excuse. ---
**Author:** ![delta737h](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/delta737h/32/11316_2.png) [@delta737h](https://forum.leasehackr.com/u/delta737h)\ **Post date:** [June 12, 2024, 1:25am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/6 "2024-06-12T01:25:28Z")
Now, do as @gohawks23 suggests… > [@gohawks23](#): > > You will get more help if you post your LH calc attempt for review…it will be a good exercise for you to do and help you to eventually generate your own target payment/DAS to propose to dealers. ---
**Author:** ![forbs](https://leasehackr.b-cdn.net/letter_avatar/forbs/32/5_5575768a8748004e209b776fc1b2916d.png) [@forbs](https://forum.leasehackr.com/u/forbs)\ **Post date:** [June 12, 2024, 1:37am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/7 "2024-06-12T01:37:19Z")
You are in NJ and not looking at some kind of EV? ---
**Author:** ![aronchi](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/aronchi/32/258551_2.png) [@aronchi](https://forum.leasehackr.com/u/aronchi)\ **Post date:** [June 12, 2024, 1:43am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/8 "2024-06-12T01:43:45Z")
> [@delta737h](#): > > your DAS = 866.75 no it isn’t. ---
**Author:** ![aronchi](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/aronchi/32/258551_2.png) [@aronchi](https://forum.leasehackr.com/u/aronchi)\ **Post date:** [June 12, 2024, 1:47am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/9 "2024-06-12T01:47:51Z")
ps OP i’d be at 454 w just broker fee due at signing on the SV premium. ---
**Author:** ![delta737h](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/delta737h/32/11316_2.png) [@delta737h](https://forum.leasehackr.com/u/delta737h)\ **Post date:** [June 12, 2024, 1:47am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/10 "2024-06-12T01:47:58Z")
> [@aronchi](#): > > no it isn’t. Really? Look at the dealer WS. What conclusion am I supposed to arrive at? Total lease inception fees, according to the WS is 868.35 which is wrong for reasons explained above. ---
**Author:** ![mllcb42](https://leasehackr.b-cdn.net/letter_avatar/mllcb42/32/5_5575768a8748004e209b776fc1b2916d.png) [@mllcb42](https://forum.leasehackr.com/u/mllcb42)\ **Post date:** [June 12, 2024, 1:49am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/11 "2024-06-12T01:49:02Z")
> [@delta737h](#): > > Total lease inception fees, according to the WS is 868.35 Thats what the inception fees are, not the cash due at sale. Per that sheet, its $529 due at sale. ---
**Author:** ![aronchi](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/aronchi/32/258551_2.png) [@aronchi](https://forum.leasehackr.com/u/aronchi)\ **Post date:** [June 12, 2024, 1:49am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/12 "2024-06-12T01:49:12Z")
really. ![image](https://leasehackr-assets.b-cdn.net/original/3X/c/c/ccb8e1075f25c1a123fbec4f2fad1574975d90ea.jpeg) ---
**Author:** ![mjr0483](https://leasehackr.b-cdn.net/letter_avatar/mjr0483/32/5_5575768a8748004e209b776fc1b2916d.png) [@mjr0483](https://forum.leasehackr.com/u/mjr0483)\ **Post date:** [June 12, 2024, 1:49am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/13 "2024-06-12T01:49:58Z")
I need 3 leases. I am coming out of 3 Nissan Rogues now. I am looking at whatever I can get into for a decent price. I can do 2 EV but I want 1 of them to be ICE. I drove the Polestar 2 today and loved it. I am trying to get a deal on the Ariya. Looking at the EV6 later this week. ---
**Author:** ![delta737h](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/delta737h/32/11316_2.png) [@delta737h](https://forum.leasehackr.com/u/delta737h)\ **Post date:** [June 12, 2024, 1:52am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/14 "2024-06-12T01:52:07Z")
> [@mllcb42](#): > > Per that sheet, its $529 due at sale. Which leaves a cash deficiency of 339.35 per the WS. Who pays that? Santa Claus? Customer cash is 529 leaving a deficiency of 339.35. ---
**Author:** ![mllcb42](https://leasehackr.b-cdn.net/letter_avatar/mllcb42/32/5_5575768a8748004e209b776fc1b2916d.png) [@mllcb42](https://forum.leasehackr.com/u/mllcb42)\ **Post date:** [June 12, 2024, 1:52am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/15 "2024-06-12T01:52:46Z")
It gets capitalized ---
**Author:** ![aronchi](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/aronchi/32/258551_2.png) [@aronchi](https://forum.leasehackr.com/u/aronchi)\ **Post date:** [June 12, 2024, 1:53am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/16 "2024-06-12T01:53:09Z")
> [@delta737h](#): > > Who pays that? paid out of funding proceeds… ---
**Author:** ![aronchi](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/aronchi/32/258551_2.png) [@aronchi](https://forum.leasehackr.com/u/aronchi)\ **Post date:** [June 12, 2024, 1:53am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/17 "2024-06-12T01:53:50Z")
i can do the rogue, the nissan and a polestar 2 in 1 deal for you lol ---
**Author:** ![delta737h](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/delta737h/32/11316_2.png) [@delta737h](https://forum.leasehackr.com/u/delta737h)\ **Post date:** [June 12, 2024, 1:56am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/18 "2024-06-12T01:56:13Z")
> [@mllcb42](#): > > It gets capitalized No, they don’t Show me in the WS where they’re capitalized. I made the calculations myself and they’re not capped. Would you like to see the base payment and lease payment calculations proving they’re not capped? ---
**Author:** ![mllcb42](https://leasehackr.b-cdn.net/letter_avatar/mllcb42/32/5_5575768a8748004e209b776fc1b2916d.png) [@mllcb42](https://forum.leasehackr.com/u/mllcb42)\ **Post date:** [June 12, 2024, 1:57am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/19 "2024-06-12T01:57:15Z")
> [@delta737h](#): > > No, they don’t Show me in the WS where they’re capitalized Yes they do ![Screenshot_20240611_215823_Chrome](https://leasehackr-assets.b-cdn.net/original/3X/c/5/c5a39278ad6d2b1ef6e220e843be0680a3ed0207.jpeg) It gets rolled into the adjusted selling price, which increases the adjusted cap cost and plus ups the selling price to the dealer to actually pay the registration to the dmv. ---
**Author:** ![delta737h](https://leasehackr.b-cdn.net/user_avatar/forum.leasehackr.com/delta737h/32/11316_2.png) [@delta737h](https://forum.leasehackr.com/u/delta737h)\ **Post date:** [June 12, 2024, 1:59am UTC](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926/20 "2024-06-12T01:59:25Z")
> [@aronchi](#): > > paid out of funding proceeds… And, you know this how? Where does the funding for the deficit come from? Out of the goodness of the dealer’s heart? Can’t really trust the WS. They already made a mistake by capping the tax on the doc fee. What else is wrong? [Next page](https://forum.leasehackr.com/t/help-me-understand-this-worksheet/565926.md?page=2)