Spreadsheet: 91751d1291406594-lease-car-vs-buy-calculator-please-comment-car-lease-vs-buy
Sheet: Sheet1

Lease |  |  | Buy |  |  | Month | Payment | Interest | Principal | Balance
Purchase Price | 36469 |  | Purchase Price | 36469 |  |  |  |  |  | 36469
0.065 | 0 |  | 0.065 | 2370.485 |  | 1 | 1109.457636920795 | 182.345 | 927.1126369207948 | 35541.88736307921
Tag & Title | 500 |  | Tag & Title | 500 |  | 2 | 1109.457636920795 | 177.709436815396 | 931.7482001053988 | 34610.13916297381
Dealer Incentives | 0 |  |  |  |  | 3 | 1109.457636920795 | 173.050695814869 | 936.4069411059257 | 33673.73222186788
Refundable Security Deposit | 700 |  |  |  |  | 4 | 1109.457636920795 | 168.3686611093394 | 941.0889758114554 | 32732.64324605642
1st Month's Payment | 0 |  |  |  |  | 5 | 1109.457636920795 | 163.6632162302821 | 945.7944206905127 | 31786.84882536591
Down Payment | 0 |  | Down Payment | 0 |  | 6 | 1109.457636920795 | 158.9342441268296 | 950.5233927939653 | 30836.32543257195
 |  |  |  |  |  | 7 | 1109.457636920795 | 154.1816271628597 | 955.2760097579351 | 29881.04942281401
Last Month's Payment in Advance | 0 |  |  |  |  | 8 | 1109.457636920795 | 149.4052471140701 | 960.0523898067247 | 28920.99703300729
0.52 | 18963.88 |  | Resale Value | 18963.88 |  | 9 | 1109.457636920795 | 144.6049851650364 | 964.8526517557584 | 27956.14438125153
Monthly Lease Payment | 518.419088584 |  | Monthly Loan Payment | 1109.457636920795 |  | 10 | 1109.457636920795 | 139.7807219062576 | 969.6769150145371 | 26986.46746623699
0.072 | 3e-05 |  |  |  |  | 11 | 1109.457636920795 | 134.932337331185 | 974.5252995896099 | 26011.94216664738
[NAME] | 36 |  | [NAME] | 36 |  | 12 | 1109.457636920795 | 130.0597108332369 | 979.397926087558 | 25032.54424055982
Discount for PV | 0.05 |  | Interest Rate | 0.06 |  | 13 | 1109.457636920795 | 125.1627212027991 | 984.2949157179957 | 24048.24932484183
Investment Rate | 0.01 |  |  |  |  | 14 | 1109.457636920795 | 120.2412466242091 | 989.2163902965857 | 23059.03293454524
FV of Pmt Difference Invested | 21590.63379969459 |  |  |  |  | 15 | 1109.457636920795 | 115.2951646727262 | 994.1624722480686 | 22064.87046229717
 |  |  |  |  |  | 16 | 1109.457636920795 | 110.3243523114859 | 999.1332846093089 | 21065.73717768786
PV of Last Payment | 0 |  | PV of [NAME] | -15832.81383785226 |  | 17 | 1109.457636920795 | 105.3286858884393 | 1004.128951032356 | 20061.60822665551
Initial Costs | 1200 |  | Initial Costs | 2870.485 |  | 18 | 1109.457636920795 | 100.3080411332775 | 1009.149595787517 | 19052.45863086799
PV of Financing Costs | 17297.41644948296 |  | PV of Financing Costs | 36469 |  | 19 | 1109.457636920795 | 95.26229315433996 | 1014.195343766455 | 18038.26328710153
PV of Refund | -602.3068085680361 |  | PV of [NAME] | -15983.64121639673 |  | 20 | 1109.457636920795 | 90.19131643550767 | 1019.266320485287 | 17018.99696661625
PV of Invested Differential | -18589.02280849772 |  |  |  |  | 21 | 1109.457636920795 | 85.09498483308124 | 1024.362652087714 | 15994.63431452853
PV of Total Costs | -693.9131675827994 |  | PV of Total Costs | 7523.029945751015 |  | 22 | 1109.457636920795 | 79.97317157264267 | 1029.484465348152 | 14965.14984918038
 |  |  |  |  |  | 23 | 1109.457636920795 | 74.8257492459019 | 1034.631887674893 | 13930.51796150549
Lease and save $8,217 |  |  |  |  |  | 24 | 1109.457636920795 | 69.65258980752743 | 1039.805047113267 | 12890.71291439222
 |  |  |  |  |  | 25 | 1109.457636920795 | 64.45356457196111 | 1045.004072348834 | 11845.70884204339
 |  |  |  |  |  | 26 | 1109.457636920795 | 59.22854421021693 | 1050.229092710578 | 10795.47974933281
 |  |  |  |  |  | 27 | 1109.457636920795 | 53.97739874666404 | 1055.480238174131 | 9739.999511158678
 |  |  |  |  |  | 28 | 1109.457636920795 | 48.69999755579339 | 1060.757639365002 | 8679.241871793676
 |  |  |  |  |  | 29 | 1109.457636920795 | 43.39620935896838 | 1066.061427561826 | 7613.18044423185
 |  |  |  |  |  | 30 | 1109.457636920795 | 38.06590222115925 | 1071.391734699636 | 6541.788709532214
 |  |  |  |  |  | 31 | 1109.457636920795 | 32.70894354766107 | 1076.748693373134 | 5465.040016159081
 |  |  |  |  |  | 32 | 1109.457636920795 | 27.3252000807954 | 1082.132436839999 | 4382.907579319081
 |  |  |  |  |  | 33 | 1109.457636920795 | 21.91453789659541 | 1087.543099024199 | 3295.364480294882
 |  |  |  |  |  | 34 | 1109.457636920795 | 16.47682240147441 | 1092.98081451932 | 2202.383665775562
 |  |  |  |  |  | 35 | 1109.457636920795 | 11.01191832887781 | 1098.445718591917 | 1103.937947183645
 |  |  |  |  |  | 36 | 1109.457636920795 | 5.519689735918225 | 1103.937947184877 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09
 |  |  |  |  |  |  | 0 | 0 | 0 | -1.231683199875988e-09