{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["EF Group - Finance Quote Sheet"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"EF Group - Finance Quote Sheet","index":0,"n_rows":44,"n_cols":30,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,21,16,25],[20,21,20,25],[2,8,2,12],[3,8,3,12]]}
[]
[]
[]
[null,null," ",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logistical Test"]
[null,null,null,null,null,null,null,"Lease Payment Proposal"]
[]
[null,null,null,null,null,"Quote Provided for:"]
[]
[null,null,null,null,null,"Quote Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Sales Rep:"]
[]
[null,null,null,null,null,"System Description:"]
[]
[null,null,null,null,null,"System Cost:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loan Amount","< = $50,000","> $50,000 - < $100,000","> =  $100,000","Total"]
[]
[null,null,null,null,null,"No Upfront Payment *",null,null,null,null,null,"1st & Last Upfront Payment ¥",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!<=49999,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>=50000,2,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>=100000,1,0)","v":{"$error":"#REF!"}},{"$f":"SUM(W20:Y20)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"ELA Financed Amount",null,{"$f":"$H$17+(H23*2)+AA28+AB28","v":379.16666666666663},null,null,null,"ELA Financed Amount",null,{"$f":"H17","v":0},null,null,null,null,null,null,null,"Rate Chart"]
[null,null,null,null,null,"Out of Pocket at Closing",null,0,null,null,null,"Out of Pocket at Closing",null,{"$f":"AD28","v":350}]
[null,null,null,null,null,"24 monthly payments",null,{"$f":"AC28+(AD28/V28)","v":14.583333333333334},null,null,null,"24 monthly payments",null,{"$f":"AC28","v":0}]
[]
[null,null,null,null,null,"ELA Financed Amount",null,{"$f":"$H$17+(H27*2)+AA29+AB29","v":369.44444444444446},null,null,null,"ELA Financed Amount",null,{"$f":"H17","v":0}]
[null,null,null,null,null,"Out of Pocket at Closing",null,0,null,null,null,"Out of Pocket at Closing",null,{"$f":"AD29","v":350},null,null,null,null,null,null,null,"Term","Rate 1","Rate 2","Add to Cost","Rate Used"]
[null,null,null,null,null,"36 monthly payments",null,{"$f":"AC29+(AD29/V29)","v":9.7222222222222214},null,null,null,"36 monthly payments",null,{"$f":"AC29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Doc Prep","UCC","Base Payment before Fees","1st Invoice Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(Z19=1,0.095,\"\")","v":""},0.1575,0.11,0.42,200,150,{"$f":"-PMT(Z28/12,V28,$H$17,,0)","v":0},{"$f":"AC28*2+SUM(AA28:AB28)","v":350}]
[null,null,null,null,null,"ELA Financed Amount",null,{"$f":"$H$17+(H31*2)+AA30+AB30","v":364.58333333333337},null,null,null,"ELA Financed Amount",null,{"$f":"H17","v":0},null,null,null,null,null,null,null,36,{"$f":"IF(Z20=1,0.095,\"\")","v":{"$error":"#REF!"}},0.1575,0.11,0.35,200,150,{"$f":"-PMT(Z29/12,V29,$H$17,,0)","v":0},{"$f":"AC29*2+SUM(AA29:AB29)","v":350}]
[null,null,null,null,null,"Out of Pocket at Closing",null,0,null,null,null,"Out of Pocket at Closing",null,{"$f":"AD30","v":350},null,null,null,null,null,null,null,48,{"$f":"IF(Z20=1,0.085,\"\")","v":{"$error":"#REF!"}},0.1575,9.35E-2,0.28999999999999998,200,150,{"$f":"-PMT(Z30/12,V30,$H$17,,0)","v":0},{"$f":"AC30*2+SUM(AA30:AB30)","v":350}]
[null,null,null,null,null,"48 monthly payments",null,{"$f":"AC30+(AD30/V30)","v":7.291666666666667},null,null,null,"48 monthly payments",null,{"$f":"AC30","v":0},null,null,null,null,null,null,null,60,{"$f":"IF(Z20=1,0.075,\"\")","v":{"$error":"#REF!"}},0.1575,8.2000000000000003E-2,0.24,200,150,{"$f":"-PMT(Z31/12,V31,$H$17,,0)","v":0},{"$f":"AC31*2+SUM(AA31:AB31)","v":350}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"ELA Financed Amount",null,{"$f":"$H$17+(H35*2)+AA31+AB31","v":361.66666666666663},null,null,null,"ELA Financed Amount",null,{"$f":"H17","v":0}]
[null,null,null,null,null,"Out of Pocket at Closing",null,0,null,null,null,"Out of Pocket at Closing",null,{"$f":"AD31","v":350}]
[null,null,null,null,null,"60 monthly payments",null,{"$f":"AC31+(AD31/V31)","v":5.833333333333333},null,null,null,"60 monthly payments",null,{"$f":"AC31","v":0}]
[]
[]
[null,null,null,null,null,"*Quote includes 1st & Last payment, doc prep & UCC filing fees held from proceeds. Customer has no out of pocket expense at closing"]
[null,null,null,null,null,"¥Quote includes doc prep & UCC filing fees within 1st invoice"]
[]
[null,null,null,null,null,"- Payments are subject to state and local taxes"]
[null,null,null,null,null,"- All quotes are subject to credit approval and receipt of required documents"]
[null,null,null,null,null,"- Lease proposal is to be used for estimation purposes"]
[null,null,null,null,null,"- Pricing are subject to change"]