{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["READ ME FIRST","Lease vs Buy Tool"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":46,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME FIRST","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,0,4,10]]}
[]
[]
[]
[]
["All information is provided \"as is\" with no guarantee as to completeness, accuracy or appropriateness for your needs.  See Terms of Service."]

{"sheet":"Lease vs Buy Tool","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[37,7,37,8],[33,0,33,3],[11,5,11,8],[25,0,25,3],[26,0,26,3],[22,1,22,3],[30,1,30,3],[28,1,28,3],[29,1,29,3],[11,0,11,3],[24,1,24,3],[19,6,19,8],[20,0,20,3],[26,5,26,8],[28,6,28,8],[30,6,30,8],[0,0,0,3],[19,1,19,3],[13,1,13,3],[14,0,14,3],[16,0,16,3],[17,0,17,3],[2,0,3,0],[10,0,10,3],[5,1,5,3],[9,1,9,3],[6,0,6,3],[15,0,15,3],[2,1,3,3],[7,0,7,3],[29,6,29,8],[2,5,3,5],[2,6,3,8],[5,6,5,8],[7,5,7,8],[6,5,6,8],[9,6,9,8],[10,5,10,8],[13,6,13,8],[17,5,17,8],[14,5,14,8],[15,5,15,8],[16,5,16,8],[0,5,0,8],[20,5,20,8],[22,6,22,8],[24,6,24,8],[25,5,25,8]]}
["LEASE VS. BUY (full asset life) ",null,null,null,null,"LEASE VS. CORPORATE FINANCE  (partial asset life)"]
[]
["Asset Description","ENTER DESCRIPTION HERE",null,null,null,"Asset Description","ENTER DESCRIPTION HERE"]
[]
[]
["Purchase price - outright",200000,null,null,null,"Purchase price - outright",724000]
["Enter the lowest price you can buy the asset for at lease inception",null,null,null,null,"Enter the lowest price you can buy the asset for at lease inception"]
["Include GST if GST is not recoverable",null,null,null,null,"Include GST if GST is not recoverable"]
[]
["Proposed lease payment per month ",10692,null,null,null,"Proposed lease payment per month ",{"$f":"4000*2","v":8000}]
["Divide annual payments by 12, quarterly payments by 3",null,null,null,null,"Divide annual payments by 12, quarterly payments by 3"]
["Excluding maintenance (assumed to be the responsibility of the lessee under both buy and lease scenarios)",null,null,null,null,"Excluding maintenance (assumed to be the responsibility of the lessee under both finance and lease scenarios)"]
[]
["Proposed initial costs of entering into lease (including any downpayments) less upfront lease incentives",0,null,null,null,"Proposed initial costs of entering into lease (including any downpayments) less upfront lease incentives",0]
["Include GST if GST is not recoverable",null,null,null,null,"Include GST if GST is not recoverable"]
["If lease incentives exceed upfront costs, enter a negative amount",null,null,null,null,"If lease incentives exceed upfront costs, enter a negative amount"]
["If there are significant future incentives, consult finance",null,null,null,null,"If there are significant future incentives, consult finance"]
["If there is a guarantee of residual value or other special terms including lease extensions, lease termination fees or different buyout options in different periods, consult finance",null,null,null,null,"If there is a guarantee of residual value or other special terms including lease extensions, lease termination fees or different buyout options in different periods, consult finance"]
[]
["Proposed final buyout amount under lease (paid at end of term) if title is expected to transfer OR estimated FMV of asset at end of lease if asset will be returned",0,null,null,null,"Estimated FMV of asset at end of lease ",170000]
["Include GST if GST is not recoverable",null,null,null,null,"Include GST if GST is not recoverable"]
[]
["Proposed lease term (in months)",17,null,null,null,"Proposed lease term (in months)",84]
[]
["Incremental borrowing rate (monthly)",{"$f":"0.0355/12","v":2.9583333333333332E-3},null,null,null,"Incremental borrowing rate (monthly)",{"$f":"0.0355/12","v":2.9583333333333332E-3}]
["Obtain incremental borrowing rate from treasury for a secured loan with the term consistent with the term of the proposed lease; convert the annual rate to monthly rate by dividing it by 12 (note: there is approximation in this calculation; however, for practical purposes, it will produce a reasonable financial decision)",null,null,null,null,"Obtain incremental borrowing rate from treasury for a secured loan with the term consistent with the term of the proposed lease; convert the annual rate to monthly rate by dividing it by 12 (note: there is a level of approximation in this calculation; however, for practical purposes, it will produce a reasonable financial decision)"]
["Example for cell entry: annual rate is 3.5%, monthly rate is 0.29%, entered as \"0.29%\". ",null,null,null,null,"Example for cell entry: annual rate is 3.5%, monthly rate is 0.29%, entered as \"0.29%\". "]
[]
["PV of lease payments",{"$f":"($B$10*((1-(1/(1+$B$25)^$B$23))/$B$25))+$B$14+($B$20/((1+$B$25)^$B$23))","v":177013.88156590602},null,null,null,"Incremental borrowing rate (annual)",{"$f":"G25*12","v":3.5499999999999997E-2}]
["NPV of leasing",{"$f":"B6-B29","v":22986.11843409398},null,null,null,"Rate implicit in the lease (annual) - ITERATE BELOW",{"$f":"G41","v":3.6492000000000954E-2}]
["RECOMMENDATION",{"$f":"IF(B30>0,\"LEASE\",\"BUY\")","v":"LEASE"},null,null,null,"RECOMMENDATION",{"$f":"IF(G30>G29,\"FINANCE\",\"LEASE\")","v":"FINANCE"}]
[]
[]
["NOTE: TAXES ARE NOT CONSIDERED IN THESE CALCULATIONS",null,null,null,null,"Rate Iteration"]
[null,null,null,null,null,"Monthly rate",3.0410000000000797E-3]
[null,null,null,null,null,"PV of inflows",{"$f":"$G$6+$G$14","v":724000}]
[null,null,null,null,null,"PV  of outflows",{"$f":"($G$10*((1-(1/(1+$G$35)^$G$23))/$G$35))+($G$20/((1+$G$35)^$G$23))","v":723973.54114736407}]
[null,null,null,null,null,"Check",{"$f":"G36-G37","v":26.458852635929361},"THIS AMOUNT CANNOT EXCEED ZERO AT THE START OF AUTO ITERATION; reset rate to adjust"]
[]
[]
[null,null,null,null,null,"Annual rate",{"$f":"G35*12","v":3.6492000000000954E-2}]