Car leasing can be very tricky, especially for the first time. In order to help you with your decision, we put together a video showing you how to build your own lease calculator using Microsoft Excel. Your lease calculator will be a great tool in establishing a baseline payment and help you get the best deal possible
Follow these steps to create your calculator
1.Launch excel
2.In column A type in these in order
a. Residual
b. Money factor
c. Msrp
d. Selling price
e. Residual value
f. Depreciation cost
g. Interest cost
h. Total w/o tax
i. Tax
j. Total w tax
3.Create formulas
Residual = b4*b2
Depreciation=(B5-B7)/36
Interest =(B5+B7)*B3
Total w/o tax =B8+B9
Tax =B10*0.09
Total w tax=B10+B11
4.Final formatting
a. Residual as a %
b. Msrp as number
c. Selling price as number
d. Residual as number
5.Plug in numbers
INSTAGRAM- / drivesteady
FACEBOOK- / drive.steady.37
16 окт 2024
