{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":32,"n_cols":25,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,17,20,20],[22,17,26,20],[30,2,30,3],[2,2,2,4],[2,17,2,24],[8,17,8,20],[9,2,9,4],[12,17,12,20],[16,17,16,20]]}
[]
[]
[null,null,"72 & 80 Granite St Manchester NH ",null,null,null,"Tenant","SF","Pro Rata share ","Rent Type ","Proposed Rent ","Rent/year","Lease XP","Options ","Rent PSF ",null,null,"Loan Calculator "]
[{"$nulls":16},"%down","Down Payment ","Loan Amount","Interest rate","Year Loan","n (total payments)","i","D","Monthly Payment "]
[null,null,"Sales Price",2000000,null,null,"Hometown Coffee Roasters ",3588,{"$f":"H5/H11","v":0.32893289328932895},"NNN",3200,{"$f":"K5*12","v":38400},null,null,{"$f":"L5/H5","v":10.702341137123746},null,0.54,{"$f":"Q5*D5","v":1080000},{"$f":"D5-R5","v":920000},7.0000000000000007E-2,20,240,{"$f":"T5/12","v":5.8333333333333336E-3},{"$f":"(((1+W5)^V5)-1)/((W5*(1+W5)^V5))","v":128.98250649625379},{"$f":"S5/X5","v":7132.7502076936362}]
[{"$nulls":19},"Assumes 7% Int","20 yr AMORT "]
[null,null,"Potential Gross Income ",{"$f":"L11","v":116400},null,null,"Republic Brewery ",7320,{"$f":"H7/H11","v":0.67106710671067105},"NNN",6500,{"$f":"K7*12","v":78000},null,null,{"$f":"L7/H7","v":10.655737704918034}]
[]
[{"$nulls":6},"CAM Reimbursment ",{"$nulls":10},"Cash on Cash Return  (CoC)"]
[null,null,"Estimated Operating Expenses ",{"$nulls":14},"Monthly Cash Flow ","Down Payment ","Est Closing Costs","CoC"]
[null,null,"Water & Sewer (common)",null,0,"Paid","Total ",{"$f":"SUM(H5:H8)","v":10908},{"$f":"SUM(I5:I8)","v":1},null,{"$f":"SUM(K5:K9)","v":9700},{"$f":"SUM(L5:L9)","v":116400},null,null,{"$f":"L11/H11","v":10.671067106710671},null,null,{"$f":"K11","v":9700},{"$f":"R5","v":1080000},{"$f":"D5*0.02","v":40000},{"$f":"((R19-S19))/(S11+T11)","v":1.3995533488996756E-2}]
[null,null,"Insurance",null,0,"By "]
[null,null,"Taxes",null,0,"Tenant ",{"$nulls":11},"Break Even Ratio "]
[null,null,"Management ",0.08,{"$f":"D14*$D$7","v":9312},{"$nulls":12},"Annual Debt Service ","Total Opex ","Gross Income ","Break Even Ratio "]
[null,null,"Reserve ",0.05,{"$f":"D7*D15","v":5820},{"$nulls":12},{"$f":"E25","v":85593.002492323634},{"$f":"E20","v":15132},{"$f":"D7","v":116400},{"$f":"((R15+S15)/T15)","v":0.86533507295810685}]
[null,null,"Utilities not passed through ",null,0]
[null,null,"(House lights etc )",{"$nulls":14},"Debt Service Coverage Ratio "]
[{"$nulls":17},"NOI","Annual Debt Service ",null,"DSCR"]
[{"$nulls":17},{"$f":"E23","v":101268},{"$f":"E25","v":85593.002492323634},null,{"$f":"R19/S19","v":1.1831341003498759},"                                      "]
[null,null,"Total Operating Expenses ",null,{"$f":"SUM(E11:E18)","v":15132}]
[]
[{"$nulls":17},"Notes"]
[null,null,"Net Operating Income ",null,{"$f":"D7-E20","v":101268}]
[]
[null,null,"Annual Debt Service ",null,{"$f":"Y5*12","v":85593.002492323634}]
[]
[null,null,"Profit/ Loss ",null,{"$f":"E23-E25","v":15674.997507676366}]
[]
[null,null,"Cap Rate ",null,{"$f":"(E23/D5)*100","v":5.0633999999999997}]
[]
[]
[null,null,"Yellow Highlight = Broker Adjusted "]