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, duration hours minute second in high quality that is uploaded to the channel Drive Steady 24 April 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 28,953 times and liked it 446 visitors.
