{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["705-711 MAIN STREET"]
["Income & Expense Proforma"]
[2020]
[]
["Income"]
[]
["Suite No.","Tenant","SF","Mo. Rent","Mo. Rent/SF","Annual Rent","Annual Rent/SF","Lease Start Date","Lease Expiration",null,"Comments"]
["703 Main St.","Lorena Lopez - Bar",1450,3100,{"$f":"D9/C9","v":2.1379310344827585},{"$f":"D9*12","v":37200},{"$f":"F9/C9","v":25.655172413793103},"2019-10-01","2024-09-30",null,"Full Service Gross"]
["705 Main St.","Available Office",1080,2000,{"$f":"D10/C10","v":1.8518518518518519},24000,{"$f":"F10/C10","v":22.222222222222221},null,null,null,"Full Service Gross"]
["707 Main St.","Alliance Entertainment",1210,1857,{"$f":"D11/C11","v":1.534710743801653},{"$f":"D11*12","v":22284},{"$f":"E11*12","v":18.416528925619836},"2015-05-01","2021-12-31",null,"Full Service Gross"]
["710 Dead Cat Alley","Brad Parsons",1060,1500,{"$f":"D12/C12","v":1.4150943396226414},{"$f":"D12*12","v":18000},{"$f":"E12*12","v":16.981132075471699},"2018-08-01","2021-07-31",null,"Modified Gross - Tenant pays util. & janitorial"]
["720-750 Dead Cat Alley","Blue Note Brewery",5250,4507.95,{"$f":"D13/C13","v":0.85865714285714279},{"$f":"D13*12","v":54095.399999999994},{"$f":"F13/C13","v":10.303885714285713},"2016-05-01","2025-01-31",null,"Modified Gross - Tenant pays util. & janitorial"]
["709 Main St.","Subway",960,1550,{"$f":"D14/C14","v":1.6145833333333333},18600,{"$f":"F14/C14","v":19.375},"2015-02-20","2021-06-30",null,"Modified Gross - Tenant pays util. & janitorial"]
["711 Main St.","Daily Democrat",3400,{"$f":"C15*1.65","v":5610},1.65,67320,19.8,"2013-05-01","2021-03-31",null,"Full Service Gross"]
["Reimbursement","Common Areas",1240,{"$f":"(D23+D25+D26+D28+D29+D30)","v":1258.33},1.0147822580645161,15099.96,12.177387096774194,null,null,null,"Reimbursements"]
[]
["TOTALS",null,{"$f":"SUM(C9:C16)","v":15650},{"$f":"SUM(D9:D16)","v":21383.279999999999},{"$f":"D18/C18","v":1.366343769968051},{"$f":"SUM(F9:F16)","v":256599.36},16.396125239616612]
[]
["Expenses"]
["Property Taxes*",null,null,{"$f":"F21/12","v":2291.6666666666665},{"$f":"D21/$C$18","v":0.14643237486687966},27500,{"$f":"F21/$C$18","v":1.7571884984025559}]
["Insurance",null,null,350,{"$f":"D22/$C$18","v":2.2364217252396165E-2},3900,0.24920127795527156]
["Landscaping",null,null,0,0,{"$f":"D23*12","v":0},0]
["Utilities (Gas, Electric, etc.)",null,null,1500,9.5846645367412137E-2,18600,1.1884984025559104]
["Fire Alarm monitoring",null,null,125,7.9872204472843447E-3,1500,9.5846645367412137E-2]
["Janitorial",null,null,600,3.8338658146964855E-2,7200,0.46006389776357826]
["Water, Sewer & Garbage",null,null,300,1.9169329073482427E-2,3600,0.23003194888178913]
["Pest Control",null,null,75,4.7923322683706068E-3,900,5.7507987220447282E-2]
["Repairs & Maintenance","HVAC, etc.",null,208.33,{"$f":"D29/$C$18","v":1.3311821086261982E-2},2499.96,{"$f":"F29/$C$18","v":0.15974185303514377}]
["Accounting/Tax Prep. ",null,null,250,{"$f":"D30/$C$18","v":1.5974440894568689E-2},3000,{"$f":"F30/$C$18","v":0.19169329073482427}]
["Management Fees",null,null,{"$f":"SUM(D9:D15)*0.04","v":804.99800000000005},{"$f":"D31/$C$18","v":5.1437571884984032E-2},{"$f":"D31*12","v":9659.9760000000006},{"$f":"F31/C18","v":0.61725086261980833}]
[]
["TOTALS",null,null,{"$f":"SUM(D21:D31)","v":6504.9946666666656},{"$f":"SUM(E21:E31)","v":0.41565461128860492},{"$f":"SUM(F21:F31)","v":78359.936000000002},5.0070246645367416]
[]
["NET OPERATING INCOME",{"$nulls":4},{"$f":"F18-F33","v":178239.424}]
[]
["Cap Rate",{"$f":"F35/F37","v":6.7260159999999999E-2},null,null,null,2650000,{"$f":"F37/C18","v":169.32907348242813}]
[]
["* Taxes at Market Value"]