Spreadsheet: 91747d1291405779-lease-car-vs-buy-calculator-please-comment-car-lease-vs-buy
Sheet: Sheet1

Lease |  |  | Buy |  |  | Month | Payment | Interest | Principal | Balance | Depr | Equity
Purchase Price | 36469 |  | Purchase Price | 36469 |  |  |  |  |  | 36469
0.065 | 0 |  | 0.065 | 2370.485 |  | 1 | 1109.457636920795 | 182.345 | 927.1126369207948 | 35541.88736307921 | 656.4420000000001 | 270.6706369207947
Tag & Title | 500 |  | Tag & Title | 500 |  | 2 | 1109.457636920795 | 177.709436815396 | 931.7482001053988 | 34610.13916297381 | 644.626044 | 287.1221561053989
Dealer Incentives | 0 |  |  |  |  | 3 | 1109.457636920795 | 173.050695814869 | 936.4069411059257 | 33673.73222186788 | 633.0227752080001 | 303.3841658979256
Refundable Security Deposit | 700 |  |  |  |  | 4 | 1109.457636920795 | 168.3686611093394 | 941.0889758114554 | 32732.64324605642 | 621.628365254256 | 319.4606105571994
1st Month's Payment | 0 |  |  |  |  | 5 | 1109.457636920795 | 163.6632162302821 | 945.7944206905127 | 31786.84882536591 | 610.4390546796794 | 335.3553660108332
Down Payment | 0 |  | Down Payment | 0 |  | 6 | 1109.457636920795 | 158.9342441268296 | 950.5233927939653 | 30836.32543257195 | 599.4511516954452 | 351.0722410985201
 |  |  |  |  |  | 7 | 1109.457636920795 | 154.1816271628597 | 955.2760097579351 | 29881.04942281401 | 588.6610309649272 | 366.6149787930078
Last Month's Payment in Advance | 0 |  |  |  |  | 8 | 1109.457636920795 | 149.4052471140701 | 960.0523898067247 | 28920.99703300729 | 578.0651324075585 | 381.9872573991662
0.52 | 18963.88 |  | Resale Value | 18963.88 |  | 9 | 1109.457636920795 | 144.6049851650364 | 964.8526517557584 | 27956.14438125153 | 567.6599600242225 | 397.1926917315359
Monthly Lease Payment | 518.419088584 |  | Monthly Loan Payment | 1109.457636920795 |  | 10 | 1109.457636920795 | 139.7807219062576 | 969.6769150145371 | 26986.46746623699 | 557.4420807437864 | 412.2348342707508
0.072 | 3e-05 |  |  |  |  | 11 | 1109.457636920795 | 134.932337331185 | 974.5252995896099 | 26011.94216664738 | 547.4081232903983 | 427.1171762992116
[NAME] | 36 |  | [NAME] | 36 |  | 12 | 1109.457636920795 | 130.0597108332369 | 979.397926087558 | 25032.54424055982 | 537.5547770711711 | 441.8431490163869
Discount for PV | 0.05 |  | Interest Rate | 0.06 |  | 13 | 1109.457636920795 | 125.1627212027991 | 984.2949157179957 | 24048.24932484183 | 527.8787910838901 | 456.4161246341056
Investment Rate | 0.01 |  |  |  |  | 14 | 1109.457636920795 | 120.2412466242091 | 989.2163902965857 | 23059.03293454524 | 518.37697284438 | 470.8394174522057
FV of Pmt Difference Invested | 21590.63379969459 |  |  |  |  | 15 | 1109.457636920795 | 115.2951646727262 | 994.1624722480686 | 22064.87046229717 | 509.0461873331812 | 485.1162849148874
 |  |  |  |  |  | 16 | 1109.457636920795 | 110.3243523114859 | 999.1332846093089 | 21065.73717768786 | 499.883355961184 | 499.249928648125
PV of Last Payment | 0 |  | PV of [NAME] | 15832.81383785226 |  | 17 | 1109.457636920795 | 105.3286858884393 | 1004.128951032356 | 20061.60822665551 | 490.8854555538826 | 513.2434954784729
Initial Costs | 1200 |  | Initial Costs | 500 |  | 18 | 1109.457636920795 | 100.3080411332775 | 1009.149595787517 | 19052.45863086799 | 482.0495173539127 | 527.1000784336045
PV of Financing Costs | 17297.41644948296 |  | PV of Financing Costs | 3258.995095375544 |  | 19 | 1109.457636920795 | 95.26229315433996 | 1014.195343766455 | 18038.26328710153 | 473.3726260415423 | 540.8227177249125
PV of Refund | -602.3068085680361 |  | PV of [NAME] | -33210.00490462555 |  | 20 | 1109.457636920795 | 90.19131643550767 | 1019.266320485287 | 17018.99696661625 | 464.8519187727945 | 554.4144017124926
PV of Invested Differential | -18589.02280849772 |  |  |  |  | 21 | 1109.457636920795 | 85.09498483308124 | 1024.362652087714 | 15994.63431452853 | 456.4845842348843 | 567.8780678528292
PV of Total Costs | -693.9131675827994 |  | PV of Total Costs | -13618.19597139775 |  | 22 | 1109.457636920795 | 79.97317157264267 | 1029.484465348152 | 14965.14984918038 | 448.2678617186563 | 581.2166036294957
 |  |  |  |  |  | 23 | 1109.457636920795 | 74.8257492459019 | 1034.631887674893 | 13930.51796150549 | 440.1990402077205 | 594.4328474671722
Buy and save $12,924 |  |  |  |  |  | 24 | 1109.457636920795 | 69.65258980752743 | 1039.805047113267 | 12890.71291439222 | 432.2754574839816 | 607.5295896292857
 |  |  |  |  |  | 25 | 1109.457636920795 | 64.45356457196111 | 1045.004072348834 | 11845.70884204339 | 424.4944992492698 | 620.5095730995638
 |  |  |  |  |  | 26 | 1109.457636920795 | 59.22854421021693 | 1050.229092710578 | 10795.47974933281 | 416.853598262783 | 633.3754944477948
 |  |  |  |  |  | 27 | 1109.457636920795 | 53.97739874666404 | 1055.480238174131 | 9739.999511158678 | 409.3502334940529 | 646.130004680078
 |  |  |  |  |  | 28 | 1109.457636920795 | 48.69999755579339 | 1060.757639365002 | 8679.241871793676 | 401.98192929116 | 658.7757100738415
 |  |  |  |  |  | 29 | 1109.457636920795 | 43.39620935896838 | 1066.061427561826 | 7613.18044423185 | 394.7462545639191 | 671.3151729979072
 |  |  |  |  |  | 30 | 1109.457636920795 | 38.06590222115925 | 1071.391734699636 | 6541.788709532214 | 387.6408219817686 | 683.7509127178671
 |  |  |  |  |  | 31 | 1109.457636920795 | 32.70894354766107 | 1076.748693373134 | 5465.040016159081 | 380.6632871860967 | 696.0854061870372
 |  |  |  |  |  | 32 | 1109.457636920795 | 27.3252000807954 | 1082.132436839999 | 4382.907579319081 | 373.8113480167469 | 708.3210888232525
 |  |  |  |  |  | 33 | 1109.457636920795 | 21.91453789659541 | 1087.543099024199 | 3295.364480294882 | 367.0827437524455 | 720.4603552717538
 |  |  |  |  |  | 34 | 1109.457636920795 | 16.47682240147441 | 1092.98081451932 | 2202.383665775562 | 360.4752543649015 | 732.5055601544188
 |  |  |  |  |  | 35 | 1109.457636920795 | 11.01191832887781 | 1098.445718591917 | 1103.937947183645 | 353.9866997863333 | 744.4590188055838
 |  |  |  |  |  | 36 | 1109.457636920795 | 5.519689735918225 | 1103.937947184877 | -1.231683199875988e-09 | 347.6149391901793 | 756.3230079946973
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 341.3578702847561 | -341.3578702847561
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 335.2134286196305 | -335.2134286196305
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 329.1795869044772 | -329.1795869044772
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 323.2543543401966 | -323.2543543401966
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 317.4357759620731 | -317.4357759620731
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 311.7219319947558 | -311.7219319947558
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 306.1109372188502 | -306.1109372188502
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 300.6009403489109 | -300.6009403489109
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 295.1901234226304 | -295.1901234226304
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 289.8767012010231 | -289.8767012010231
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 284.6589205794047 | -284.6589205794047
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 279.5350600089754 | -279.5350600089754
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 274.5034289288138 | -274.5034289288138
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 269.5623672080952 | -269.5623672080952
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 264.7102445983494 | -264.7102445983494
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 259.9454601955791 | -259.9454601955791
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 255.2664419120587 | -255.2664419120587
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 250.6716459576416 | -250.6716459576416
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 246.1595563304041 | -246.1595563304041
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 241.7286843164568 | -241.7286843164568
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 237.3775679987606 | -237.3775679987606
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 233.1047717747829 | -233.1047717747829
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 228.9088858828368 | -228.9088858828368
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 224.7885259369457 | -224.7885259369457
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 220.7423324700807 | -220.7423324700807
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 216.7689704856193 | -216.7689704856193
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 212.8671290168781 | -212.8671290168781
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 209.0355206945743 | -209.0355206945743
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 205.272881322072 | -205.272881322072
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 201.5779694582747 | -201.5779694582747
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 197.9495660080257 | -197.9495660080257
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 194.3864738198813 | -194.3864738198813
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 190.8875172911234 | -190.8875172911234
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 187.4515419798831 | -187.4515419798831
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 184.0774142242452 | -184.0774142242452
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 180.7640207682088 | -180.7640207682088
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 177.5102683943811 | -177.5102683943811
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 174.3150835632822 | -174.3150835632822
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 171.1774120591432 | -171.1774120591432
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 168.0962186420786 | -168.0962186420786
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 165.0704867065211 | -165.0704867065211
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 162.0992179458038 | -162.0992179458038
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 159.1814320227793 | -159.1814320227793
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 156.3161662463692 | -156.3161662463692
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 153.5024752539346 | -153.5024752539346
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 150.7394306993638 | -150.7394306993638
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 148.0261209467753 | -148.0261209467753
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 145.3616507697333 | -145.3616507697333
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 142.7451410558781 | -142.7451410558781
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 140.1757285168723 | -140.1757285168723
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 137.6525654035686 | -137.6525654035686
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 135.1748192263044 | -135.1748192263044
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 132.7416724802309 | -132.7416724802309
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 130.3523223755867 | -130.3523223755867
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 128.0059805728261 | -128.0059805728261
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 125.7018729225152 | -125.7018729225152
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 123.43923920991 | -123.43923920991
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 121.2173329041316 | -121.2173329041316
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 119.0354209118572 | -119.0354209118572
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 116.8927833354438 | -116.8927833354438
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 114.7887132354058 | -114.7887132354058
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 112.7225163971685 | -112.7225163971685
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 110.6935111020195 | -110.6935111020195
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09 | 108.7010279021831 | -108.7010279021831