dlastx,
It appears that the MF is marked-up and so, you need to determine the top tier rate (i.e., buy rate) with 0% reserves. I’m betting that joeblogs is right when he says that the buy rate is 0.00166 which is equivalent to an interest rate of approximately 3.98% … still very high. Go to edmunds.com to confirm. If it’s not provided, ask the moderators in the appropriate forum. Also, check edmiunds to see what others a paying in terms of sell price. You can also check truecar to get a very rough but, somewhat inflated estimate.
As for the lease worksheet, this is what happens when either programmers or sales people don’t know what they’re doing. The gross cap is not 46,781.75. It should be 49,178.31 calculated as follows…
Gross Cap = 45,845 + 11.75 + 925 + 2,396.56 = 49,178.31
The Net cap is…
Net Cap = 49,178.31 - 7500 = 41,678.31
The payment is…
0.00227 x (41,678.31 + 27,750.10) + (41,678.31 - 27,750.10)/36 = 544.49
Cash due upfront is…
544.49 + 341.25 = 885.74
There seems to be something missing in the 341.25 figure which is…
150 (Doc fee) + 118.25 (license) + 73 (???) = 341.25
Can’t account for the additional 73 charge. The only other thing missing is the sales tax rate which is somewhere between 6.25% and 8.25%. Texas, as far as I know, still levies sales tax on the selling price. As far as I can tell, the 2,396.56 seems to include the application of a tax credit as the tax would be at least 0.0625 x 45,845 = 2,865.31