{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Inc Retail II (30% down payment"],"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":"Inc Retail II (30% down payment","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Rent","Rent Sq ft /floor","Rent per sq ft","Com Rent sq ft","NNN","Total Payment","Tenant"]
["Floor 3",{"$f":"(E2*C2)/12","v":1925},700.0,{"$f":"B2/700","v":2.75},33.0,{"$f":"$F$19*0.33","v":1237.39},{"$f":"B2+F2","v":3162.39},"HOA"]
["Floor 2",2216.666667,700.0,3.166666667,38.0,1237.39,3454.056667,"HOA"]
["Floor 1",3400.0,700.0,4.857142857,{"$f":"B4*12/C4","v":58.28571429},1237.39,4637.39,"Foundation"]
["Total",{"$f":"sum(B2:B4)","v":7541.666667},2100,null,null,{"$f":"sum(F2:F4)","v":3712.17},11253.83667]
[]
["Income",null,null,null,"Building Info"]
["Monthly Gross Income",{"$f":"B5","v":7541.666667},null,null,"Lot size",1000.0]
["Annual Gross Income",{"$f":"B8*12","v":90500},null,null,"Total Building Size",{"$f":"sum(C2:C4)/0.875","v":2400}]
["NOI",{"$f":"B9","v":90500}]
["Annual Net Income",{"$f":"(B8-B14)*12","v":18283.74931},null,null,"Triple Nets"]
[{"$nulls":4},"Tax Rate",0.029]
["Financing",null,null,null,"Assessments/sq ft",2.3]
["Mortgage",{"$f":"-PMT(B16/12, 12*20, B18*(1-B15))","v":6018.020891},"Down Payment ",null,"Taxes",{"$f":"B18*F12","v":34800}]
["Down Payment (%)",0.3,{"$f":"B18*B15","v":360000},null,"Assessments",{"$f":"F8*F13","v":2300}]
["Interest Rate",0.06,null,null,"Insurance",7896.0]
["Cap Rate",{"$f":"B10/B18","v":0.07541666667},null,null,"Annual NNN",{"$f":"sum(F14:F16)","v":44996}]
["Purchase Price",1200000.0]
["DSCR",{"$f":"(B10/12)/B14","v":1.253180539},null,null,"Monthly NNN",{"$f":"F17/12","v":3749.666667}]
["Cash on Cash",{"$f":"B11/C15","v":0.05078819252},null,null,"NNN/ft",{"$f":"F17/sum(C2:C4)","v":21.42666667}]