Joined
·
189 Posts
Hi all,
I like messing around with Google Sheets and teaching myself how to do new things. I made one to calculate leases based on which VW ID.4 you reserved. Feel free to download and copy it. As viewers you should have the option to do that. Most columns have drop down menus except state taxes, down payment, and fees. If you are signed into Google Sheets, go to File -> Make a copy, this should preserve the coding and data validations so you can change the numbers to your hearts' content! If you would like to add more fields to the drop down menus, you can do that on the data tab.
docs.google.com
If there are any issues, let me know in case I need to make changes to the permissions.
I like messing around with Google Sheets and teaching myself how to do new things. I made one to calculate leases based on which VW ID.4 you reserved. Feel free to download and copy it. As viewers you should have the option to do that. Most columns have drop down menus except state taxes, down payment, and fees. If you are signed into Google Sheets, go to File -> Make a copy, this should preserve the coding and data validations so you can change the numbers to your hearts' content! If you would like to add more fields to the drop down menus, you can do that on the data tab.
VW ID.4 Lease Payment Calculation
Lease Payment Calculation Model,MSRP,Residual Value,Money Factor,Incentive,Down Payment,Fees,Lease Term,State Taxes 2021 ID.4 1st Edition,$43,995.00,46%,0.000375,$7,500.00,$0.00,$1,500.00,36,6.625% Money Factor to APR Conversion Residual Value,$20,237.70,0.000375,0.90% Gross Capitalized Cost,$45...
If there are any issues, let me know in case I need to make changes to the permissions.