Here's How To Calculate A Car Lease Payment
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
Watch video Here's How To Calculate A Car Lease Payment online without registration, duration hours minute second in high quality. This video was added by user Drive Steady 24 April 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 28,953 once and liked it 446 people.