Spreadsheet: 91759d1291409145-lease-car-vs-buy-calculator-please-comment-car-lease-vs-buy
Sheet: Sheet1

Lease |  |  | Buy |  |  | Month | Payment | Interest | Principal | Balance | Depreciation | Equity
Purchase Price | 36469 |  | Purchase Price | 36469 |  |  |  |  |  | 36469
0.065 | 0 |  | 0.065 | 2370.485 |  | 1 | 1109.457636920795 | 182.345 | 927.1126369207948 | 35541.88736307921 | 526.7744444444445 | 400.3381924763503
Tag & Title | 500 |  | Tag & Title | 500 |  | 2 | 1109.457636920795 | 177.709436815396 | 931.7482001053988 | 34610.13916297381 | 519.1654802469136 | 412.5827198584852
Dealer Incentives | 0 |  |  |  |  | 3 | 1109.457636920795 | 173.050695814869 | 936.4069411059257 | 33673.73222186788 | 511.6664233100137 | 424.740517795912
Refundable Security Deposit | 700 |  |  |  |  | 4 | 1109.457636920795 | 168.3686611093394 | 941.0889758114554 | 32732.64324605642 | 504.2756860844247 | 436.8132897270307
1st Month's Payment | 0 |  |  |  |  | 5 | 1109.457636920795 | 163.6632162302821 | 945.7944206905127 | 31786.84882536591 | 496.9917039520942 | 448.8027167384185
Down Payment | 0 |  | Down Payment | 0 |  | 6 | 1109.457636920795 | 158.9342441268296 | 950.5233927939653 | 30836.32543257195 | 489.8129348950083 | 460.710457898957
 |  |  |  |  |  | 7 | 1109.457636920795 | 154.1816271628597 | 955.2760097579351 | 29881.04942281401 | 482.7378591687471 | 472.538150589188
Last Month's Payment in Advance | 0 |  |  |  |  | 8 | 1109.457636920795 | 149.4052471140701 | 960.0523898067247 | 28920.99703300729 | 475.764978980754 | 484.2874108259707
0.52 | 18963.88 |  | Resale Value | 18963.88 |  | 9 | 1109.457636920795 | 144.6049851650364 | 964.8526517557584 | 27956.14438125153 | 468.8928181732542 | 495.9598335825042
Monthly Lease Payment | 518.419088584 |  | Monthly Loan Payment | 1109.457636920795 |  | 10 | 1109.457636920795 | 139.7807219062576 | 969.6769150145371 | 26986.46746623699 | 462.1199219107517 | 507.5569931037854
0.072 | 3e-05 |  |  |  |  | 11 | 1109.457636920795 | 134.932337331185 | 974.5252995896099 | 26011.94216664738 | 455.4448563720408 | 519.080443217569
[NAME] | 36 |  | [NAME] | 36 |  | 12 | 1109.457636920795 | 130.0597108332369 | 979.397926087558 | 25032.54424055982 | 448.8662084466669 | 530.531717640891
Discount for PV | 0.05 |  | Interest Rate | 0.06 |  | 13 | 1109.457636920795 | 125.1627212027991 | 984.2949157179957 | 24048.24932484183 | 442.3825854357706 | 541.912330282225
Investment Rate | 0.01 |  |  |  |  | 14 | 1109.457636920795 | 120.2412466242091 | 989.2163902965857 | 23059.03293454524 | 435.9926147572539 | 553.2237755393318
FV of Pmt Difference Invested | 21590.63379969459 |  |  |  |  | 15 | 1109.457636920795 | 115.2951646727262 | 994.1624722480686 | 22064.87046229717 | 429.6949436552047 | 564.467528592864
 |  |  |  |  |  | 16 | 1109.457636920795 | 110.3243523114859 | 999.1332846093089 | 21065.73717768786 | 423.4882389135184 | 575.6450456957905
PV of Last Payment | 0 |  | PV of [NAME] | -15832.81383785226 |  | 17 | 1109.457636920795 | 105.3286858884393 | 1004.128951032356 | 20061.60822665551 | 417.3711865736565 | 586.7577644586991
Initial Costs | 1200 |  | Initial Costs | 2870.485 |  | 18 | 1109.457636920795 | 100.3080411332775 | 1009.149595787517 | 19052.45863086799 | 411.3424916564815 | 597.8071041310358
PV of Financing Costs | 17297.41644948296 |  | PV of Financing Costs | 36469 |  | 19 | 1109.457636920795 | 95.26229315433996 | 1014.195343766455 | 18038.26328710153 | 405.40087788811 | 608.7944658783448
PV of Refund | -602.3068085680361 |  | PV of [NAME] | -19526.96103797986 |  | 20 | 1109.457636920795 | 90.19131643550767 | 1019.266320485287 | 17018.99696661625 | 399.5450874297262 | 619.7212330555609
PV of Invested Differential | -18589.02280849772 |  |  |  |  | 21 | 1109.457636920795 | 85.09498483308124 | 1024.362652087714 | 15994.63431452853 | 393.7738806112969 | 630.5887714764167
PV of Total Costs | -693.9131675827994 |  | PV of Total Costs | 3979.710124167883 |  | 22 | 1109.457636920795 | 79.97317157264267 | 1029.484465348152 | 14965.14984918038 | 388.0860356691337 | 641.3984296790184
 |  |  |  |  |  | 23 | 1109.457636920795 | 74.8257492459019 | 1034.631887674893 | 13930.51796150549 | 382.4803484872462 | 652.1515391876467
Lease and save $4,674 |  |  |  |  |  | 24 | 1109.457636920795 | 69.65258980752743 | 1039.805047113267 | 12890.71291439222 | 376.9556323424304 | 662.849414770837
 |  |  |  |  |  | 25 | 1109.457636920795 | 64.45356457196111 | 1045.004072348834 | 11845.70884204339 | 371.5107176530397 | 673.493354695794
 |  |  |  |  |  | 26 | 1109.457636920795 | 59.22854421021693 | 1050.229092710578 | 10795.47974933281 | 366.1444517313847 | 684.0846409791932
 |  |  |  |  |  | 27 | 1109.457636920795 | 53.97739874666404 | 1055.480238174131 | 9739.999511158678 | 360.8556985397091 | 694.6245396344217
 |  |  |  |  |  | 28 | 1109.457636920795 | 48.69999755579339 | 1060.757639365002 | 8679.241871793676 | 355.6433384496911 | 705.1143009153104
 |  |  |  |  |  | 29 | 1109.457636920795 | 43.39620935896838 | 1066.061427561826 | 7613.18044423185 | 350.5062680054178 | 715.5551595564086
 |  |  |  |  |  | 30 | 1109.457636920795 | 38.06590222115925 | 1071.391734699636 | 6541.788709532214 | 345.443399689784 | 725.9483350098517
 |  |  |  |  |  | 31 | 1109.457636920795 | 32.70894354766107 | 1076.748693373134 | 5465.040016159081 | 340.4536616942648 | 736.295031678869
 |  |  |  |  |  | 32 | 1109.457636920795 | 27.3252000807954 | 1082.132436839999 | 4382.907579319081 | 335.5359976920143 | 746.596439147985
 |  |  |  |  |  | 33 | 1109.457636920795 | 21.91453789659541 | 1087.543099024199 | 3295.364480294882 | 330.6893666142408 | 756.8537324099585
 |  |  |  |  |  | 34 | 1109.457636920795 | 16.47682240147441 | 1092.98081451932 | 2202.383665775562 | 325.9127424298129 | 767.0680720895075
 |  |  |  |  |  | 35 | 1109.457636920795 | 11.01191832887781 | 1098.445718591917 | 1103.937947183645 | 321.2051139280489 | 777.2406046638681
 |  |  |  |  |  | 36 | 1109.457636920795 | 5.519689735918225 | 1103.937947184877 | -1.231683199875988e-09 | 316.5654845046438 | 787.3724626802327
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 0 | 0