{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Website Form ","Quote Graphs","Quote"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Website Form ","index":0,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[51,2,51,12],[53,2,53,12],[55,2,55,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please fill out the open fields and return form in this exact format.  Thank you!!"]
[]
[]
[]
[]
[]
[]
[null,null,"Form:"]
[null,null,"Team Information"]
[null,null,"Spomsor / Developer",null,null,null,null,null,"Borrower (Entity)"]
[null,null,"Website"]
[]
[null,null,"Property Description"]
[null,null,"Project Name",null,null,null,null,null,"Property Type",null,"Drop down"]
[]
[null,null,"Project Type",null,null,"drop down",null,null,"Property Size",null,null,null,"SF","drop down"]
[]
[null,null,"Project Address",null,null,null,null,null,"City"]
[]
[null,null,"State",null,null,null,"MSA",null,null,null,"Submarket"]
[]
[null,null,"Closing Date",null,null,null,null,null,"Months to Complete - if Const./Rehab/Value Add"]
[]
[null,null,"Financial Information"]
[null,null,"Total Project Cost",null,null,null,null,"Loan %",null,null,"Loan Amount","Calculated ",{"$f":"+E33*I33","v":0}]
[]
[null,null,"LGIS Coverage Needed",null,null,null,null,"% of Loan",null,null,"Insured Amount","Calculated ",{"$f":"+M33*I35","v":0}]
[]
[]
[null,null,"Loan Term (months)",null,36,null,null,"Rate",null,null,"Interest Only (Y / N)",null,"Y"]
[]
[null,null,"Lender Type",null,null,"drop down",null,"Name of Lender"]
[]
[null,null,"Take Out Information"]
[null,null,"Net Operating Income (Stabiized)",null,null,null,null,"Cap Rate (Stabilized)"]
[]
[null,null,"Refinance Rate",null,null,null,null,"DSCR"]
[]
[null,null,"Other Information"]
[null,null,"Loan Commitment Date",null,null,null,null,null,"Loan Closing Date"]
[]
[]
[null,null,"Notes: Sponsor information and any project specifics"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Attache Files - Upload (ex. Lender packages, brochures, financials, etc.)"]
[null,null,"Drop files or clip to select files to Upload"]
[]
[null,null,"Contact Information"]
[null,null,"Name 1",null,null,null,null,"Phone",null,null,"Email"]
[null,null,"Name 2",null,null,null,null,"Phone",null,null,"Email"]
[null,null,"Name 3",null,null,null,null,"Phone",null,null,"Email"]

{"sheet":"Quote Graphs","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[[2,1,2,2],[6,1,6,2],[10,1,10,2],[14,1,14,2],[18,1,18,2]]}
[]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Quote","index":2,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Preliminary Quote",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Project","Name of Project",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Size"]
[null,"City / Submarket"]
[null,"Quote Prepared for:"]
[null,"Date"]
[]
[null,"Loan Amount",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"LTC / LTV"]
[]
[null,"Insured Amount",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Deductible (% of Loan Amt.)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Premium",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Premium % of Total Cost",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["TATA - Stack LGIS Origional over LGIS Alternative - will allow for better printing and copy / paste."]
[]
[null," LGIS Original",null,null,null," LGIS Alternative- Increased Loan"]
[null,"Capital Stack",null,null,null,"Capital Stack",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Loan - Uninsured",null,null,null,"Loan - Uninsured",{"$f":"G30-SUM(G32:G34)","v":{"$error":"#REF!"}},{"$f":"IFERROR(G31/$G$125,0)","v":0}]
[null,"Loan - LGIS Insured",null,null,null,"Loan - LGIS Insured",{"$f":"E17-E10","v":0},{"$f":"IFERROR(G32/$G$125,0)","v":0}]
[null,"Deductible",null,null,null,"Deductible",{"$f":"E12","v":0},{"$f":"IFERROR(G33/$G$125,0)","v":0}]
[null,"Equity",null,null,null,"Equity",{"$f":"G30-E3","v":{"$error":"#REF!"}},{"$f":"IFERROR(G34/$G$125,0)","v":0}]
[null,"  Total",null,null,null,"  Total",{"$f":"SUM(G31:G34)","v":{"$error":"#REF!"}},{"$f":"IFERROR(G35/$G$125,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTE:  Customer does not need to see ROL - just LGIS Internally"]
[]
[null,"ROL",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]