{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Buy vs. Lease Car","Variables"],"not_rendered":{"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"Buy vs. Lease Car","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[1,6,1,7]]}
[]
[null,"Buy vs. Lease Car",{"$nulls":3},"Make & Model:"]
[]
[null,null,"LEASE",{"$nulls":3},"BUY"]
[]
[null,"Suggested retail price",{"$nulls":3},"Suggested retail price",{"$f":"IF(C6,C6,\"\")","v":""}]
[null,"Tax, title, etc.",{"$nulls":3},"Tax, title, etc.",{"$f":"IF(C7,C7,\"\")","v":""}]
[null,"Refundable security deposit"]
[null,"First month's payment"]
[null,"Capital cost reduction payment",{"$nulls":3},"Down payment"]
[]
[null,"Last month payment in advance?"]
[null,"Payment (if yes)",{"$f":"IF(CELL(\"type\",C12)=\"b\",\"\",IF(LEFT(C12,1)=\"y\",C9,0))","v":""}]
[null,"Selling price at end of lease",{"$nulls":3},"Resale value ",{"$f":"IF(C14,C14,\"\")","v":""}]
[null,"Monthly lease payment",{"$nulls":3},"Monthly loan payment",{"$f":"IF(AND(OR(SUM(G6)>0,SUM(G17)),SUM(G16)),PMT(G17/12,G16,-(G6-G10)),\"\")","v":""}]
[null,"Lease term",{"$nulls":3},"Term of loan",{"$f":"IF(C16,C16,\"\")","v":""}]
[null,"Discount for present value",{"$nulls":3},"Loan rate"]
[]
[null,"Future value of last payment",{"$f":"IF(OR(OR(C17>0,C16),C13),(1+C17/12)^C16*C13,\"\")","v":""},null,null,"Present value of resale",{"$f":"IF(OR(OR(C17>0,C16),C14),((1+C17/12)^-C16)*C14,\"\")","v":""}]
[]
[null,"Initial costs",{"$f":"IF(SUM(C7:C10,C13),SUM(C7:C10,C13),\"\")","v":""},null,null,"Initial costs",{"$f":"IF(OR(SUM(G7)>0,G10),+G7+G10,\"\")","v":""}]
[null,"Financing costs",{"$f":"IF(AND(C15>0,C17),PV(C17/12,C16-IF(C13,1,0),-C15),\"\")","v":""},null,null,"Financing costs",{"$f":"IF(OR(OR(SUM(G15)>0,C17),G16),PV(C17/12,G16,-G15),\"\")","v":""}]
[null,"Present value of refund",{"$f":"IF(OR(OR(C17>0,C16),C8),((1+C17/12)^-C16)*-C8,\"\")","v":""}]
[null,"Present value of total costs",{"$f":"IF(SUM(C21:C23),SUM(C21:C23),\"\")","v":""},null,null,"Present value of total costs",{"$f":"IF(OR(OR(SUM(G21)>0,SUM(G22)),SUM(G19)),SUM(G21)+SUM(G22)-SUM(G19),\"\")","v":""}]
[]
[{"$nulls":5},"DIFFERENCE",{"$f":"IF(OR(SUM(G24)>0,C24),+G24-C24,\"\")","v":""}]
[{"$nulls":5}," Note: Positive value favors leasing."]
[]
[]
[null,"TAXATION"]
[]
[null,null,"Tax bracket"]
[null,null,"Business use percentage"]
[null,null,"Sales tax percentage"]
[]
[]
[null,"TAXATION","LEASE",null,null,"TAXATION","BUY"]
[]
[null,"Title",{"$nulls":3},"Title",{"$f":"IF(C39,C39,\"\")","v":""}]
[null,"Fees",{"$nulls":3},"Fees",{"$f":"IF(C40,C40,\"\")","v":""}]
[null,"Sales tax",{"$f":"IF(OR(F34>0,C6),+F34*C6,\"\")","v":""},null,null,"Sales tax",{"$f":"IF(SUM(C41),C41,\"\")","v":""}]
[null,"Potential financing deduction",{"$f":"IF(OR(C15>0,C16),+C15*C16,\"\")","v":""},null,null,"Interest deduction",{"$f":"IF(OR(OR(OR(SUM(G15)>0,G16),G6),G10),(G15*G16)-(G6-G10),\"\")","v":""}]
[null,"Total potential deductions",{"$f":"IF(SUM(C39:C42),SUM(C39:C42),\"\")","v":""},null,null,"Total potential deductions",{"$f":"IF(SUM(G39:G42),SUM(G39:G42),\"\")","v":""}]
[null,"Potential tax savings",{"$f":"IF(OR(OR(F32>0,F33),C43),(1-F32)*F33*C43,\"\")","v":""},null,null,"Potential tax savings",{"$f":"IF(OR(OR(F32>0,F33),G43),(1-F32)*F33*G43,\"\")","v":""}]
[]
[]
[null,"Note: Depreciation deductions may be available that could change the results of this analysis."]

{"sheet":"Variables","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
["_Example",false]
["_Shading",false]
["_Series","OfficeReady 3.0"]
["_Look",1]