{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Buy vs. Lease Car"],"read":"whole","date_system":"1900"}

{"sheet":"Buy vs. Lease Car","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"merged":[[3,2,3,5],[32,2,32,4],[33,2,33,4],[34,2,34,4]]}
[]
[null,"BUY vs. LEASE"]
[]
[null,"MAKE & MODEL","[MAKE] [MODEL]"]
[]
[null,"LEASE",null,null,"BUY"]
[]
[null,"Suggested retail price",{"v":12000,"d":"$12,000.00"},null,"Suggested retail price",{"$f":"IF(C8,C8,\"\")","v":{"v":12000,"d":"$12,000.00"}}]
[null,"Tax, title, etc.",{"v":250,"d":"$250.00"},null,"Tax, title, etc.",{"$f":"IF(C9,C9,\"\")","v":{"v":250,"d":"$250.00"}}]
[null,"Refundable security deposit",{"v":150,"d":"$150.00"}]
[null,"First month's payment",{"v":200,"d":"$200.00"}]
[null,"Capital cost reduction payment",{"v":100,"d":"$100.00"},null,"Down payment",{"v":2000,"d":"$2,000.00"}]
[]
[null,"Last month payment in advance?","Yes"]
[null,"Payment (if yes)",{"$f":"IF(ISBLANK(C14),\"\",IF(C14=\"Yes\",C11,0))","v":{"v":200,"d":"$200.00"}}]
[null,"Selling price at end of lease",{"v":7500,"d":"$7,500.00"},null,"Resale value ",{"$f":"IF(C16,C16,\"\")","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Monthly lease payment",{"v":225,"d":"$225.00"},null,"Monthly loan payment",{"$f":"IF(AND(OR(F8>0,F19),F18*12),PMT(F19/12,F18*12,-(F8-F12)),\"\")","v":{"v":188.71233644010937,"d":"$188.71"}}]
[null,"Lease term (years)",5,null,"Term of loan (years)",{"$f":"IF(C18,C18,\"\")","v":5}]
[null,"Discount for present value",{"v":0.05,"d":"5.00%"},null,"Loan rate",{"v":0.05,"d":"5.00%"}]
[]
[null,"Future value of last payment",{"$f":"IF(OR(OR(C19>0,C18*12),C15),(1+C19/12)^(C18*12)*C15,\"\")","v":{"v":256.6717357007028,"d":"$256.67"}},null,"Present value of resale",{"$f":"IF(OR(OR(C19>0,C18*12),C16),((1+C19/12)^(-C18*12))*C16,\"\")","v":{"v":5844.0404273772665,"d":"$5,844.04"}}]
[]
[null,"Initial costs",{"$f":"IF(SUM(C9:C12,C15),SUM(C9:C12,C15),\"\")","v":{"v":900,"d":"$900.00"}},null,"Initial costs",{"$f":"IF(OR(SUM(F9)>0,F12),F9+F12,\"\")","v":{"v":2250,"d":"$2,250.00"}}]
[null,"Financing costs",{"$f":"IF(AND(C17>0,C19),PV(C19/12,C18*12-IF(C15,1,0),-C17),\"\")","v":{"v":11747.58771006236,"d":"$11,747.59"}},null,"Financing costs",{"$f":"IF(OR(OR(F17>0,C19),F18*12),PV(C19/12,F18*12,-F17),\"\")","v":{"v":10000.000000000035,"d":"$10,000.00"}}]
[null,"Present value of refund",{"$f":"IF(OR(OR(C19>0,C18*12),C10),((1+C19/12)^(-C18*12))*-C10,\"\")","v":{"v":-116.88080854754533,"d":"-$116.88"}}]
[null,"Present value of total costs",{"$f":"IF(SUM(C23:C25),SUM(C23:C25),\"\")","v":{"v":12530.706901514815,"d":"$12,530.71"}},null,"Present value of total costs",{"$f":"IF(OR(OR(SUM(F23)>0,F24),F21),F23+F24-F21,\"\")","v":{"v":6405.959572622768,"d":"$6,405.96"}}]
[]
[{"$nulls":4},"DIFFERENCE",{"$f":"IF(OR(SUM(F26)>0,C26),+F26-C26,\"\")","v":{"v":-6124.747328892047,"d":"-$6,124.75"}}]
[{"$nulls":4},"Note: Positive value favors leasing."]
[]
[null,"TAXATION"]
[]
[null,null,"Tax bracket",null,null,{"v":0.25,"d":"25.00%"}]
[null,null,"Business use percentage",null,null,{"v":0.065,"d":"6.50%"}]
[null,null,"Sales tax percentage",null,null,{"v":0.095,"d":"9.50%"}]
[]
[null,"TAXATION","LEASE",null,"TAXATION","BUY"]
[]
[null,"Title",{"v":150,"d":"$150.00"},null,"Title",{"$f":"IF(C39,C39,\"\")","v":{"v":150,"d":"$150.00"}}]
[null,"Fees",{"v":150,"d":"$150.00"},null,"Fees",{"$f":"IF(C40,C40,\"\")","v":{"v":150,"d":"$150.00"}}]
[null,"Sales tax",{"$f":"IF(OR(F35>0,C8),F35*C8,\"\")","v":{"v":1140,"d":"$1,140.00"}},null,"Sales tax",{"$f":"IF(SUM(C41),C41,\"\")","v":{"v":1140,"d":"$1,140.00"}}]
[null,"Potential financing deduction",{"$f":"IF(OR(C17>0,C18),C17*C18*12,\"\")","v":{"v":13500,"d":"$13,500.00"}},null,"Interest deduction",{"$f":"IF(OR(OR(OR(F17>0,F18*12),F8),F12),(F17*F18*12)-(F8-F12),\"\")","v":{"v":1322.7401864065614,"d":"$1,322.74"}}]
[null,"Total potential deductions",{"$f":"IF(SUM(C39:C42),SUM(C39:C42),\"\")","v":{"v":14940,"d":"$14,940.00"}},null,"Total potential deductions",{"$f":"IF(SUM(F39:F42),SUM(F39:F42),\"\")","v":{"v":2762.7401864065614,"d":"$2,762.74"}}]
[null,"Potential tax savings",{"$f":"IF(OR(OR(F33>0,F34),C43),(1-F33)*F34*C43,\"\")","v":{"v":728.325,"d":"$728.33"}},null,"Potential tax savings",{"$f":"IF(OR(OR(F33>0,F34),F43),(1-F33)*F34*F43,\"\")","v":{"v":134.68358408731987,"d":"$134.68"}}]
[]
[null,"Note: Depreciation deductions may be available that could change the results of this analysis."]