Here's How To Calculate A Car Lease Payment

Опубликовано: 24 Апрель 2019
на канале: Drive Steady

28,953

446

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

Смотрите видео Here's How To Calculate A Car Lease Payment онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Drive Steady 24 Апрель 2019. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 28,953 раз и оно понравилось 446 посетителям.

219