{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sale"],"not_rendered":{"charts":0,"images":1,"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":"Sale","index":0,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,5,7,6],[0,1,2,8],[3,1,3,8],[5,2,5,4],[5,5,5,6],[6,2,6,4],[57,1,57,8],[58,1,62,8],[8,1,9,1],[8,7,9,7],[12,3,12,4],[38,1,38,5],[55,1,55,8],[56,1,56,8]]}
[]
[]
[]
[]
[null,"# Units",null,"Address",null,"City",null,"Zip","Map Code"]
[null,4,"320 Willie James Jones Ave",null,null,"San Diego",null,92102]
[]
[null,"Price","Cap Ex/Basis","GRM",null,"CAP Rate",null,"$ / Unit"]
[null,1450000,0,"Projected","Market","Projected","Market",{"$f":"B9/B6","v":362500}]
[null,null,{"$f":"B9+C9","v":1450000},{"$f":"B9/E41","v":13.087115058305354},{"$f":"C10/F41","v":12.113617376775272},{"$f":"E45/B9","v":5.3687062068965508E-2},{"$f":"F45/C10","v":5.9643531034482757E-2}]
[null,"Price","Avg ","Gross Sq. Ft.",null,"Parcel Size"]
[null,"Per SF","Unit SF","(Approx.)",null,"(Approx.)","Parking","Yr. Built"]
[null,{"$f":"B9/D13","v":467.13917525773195},{"$f":"D13/B6","v":776},3104,null,7915,"10 spots (tandem)",1974]
[null," ","Income Detail",null,null,null,"Annual Operating Expenses"]
[null,"# of Units","Type","Rent","Total",null,"(Estimated)"]
[null,"Projected Income",null,null,null,"Esti. Expenses",null,"Prop Mgmt"]
[null,1,"MTM 2BR / 2BA w/ yard",1958,{"$f":"D17*B17","v":1958},"Utilities",1000,"OnSite Mgmt"]
[null,1,"2BR / 2BA",2500,2500,"Water/Sewer",{"$f":"60*12*B6","v":2880},"Insurance",2400]
[null,1,"1BR + small BR / 1BA",2300,2300,"Contracted",1200,"License/Fees"]
[null,1,"1BR / 1BA",2100,{"$f":"D20*B20","v":2100},"Trash ",0,"Pool"]
[{"$nulls":5},"Pest Control",0,"Misc/Reserves",1000]
[{"$nulls":5},"Maintenance ",3000,"Taxes*",{"$f":"B9*0.0125144","v":18145.88}]
[null,null,"Laundry",null,75,"Total Annual Expenses",null,{"$f":"SUM(G16:G22)+SUM(I16:I22)","v":29625.88}]
[null,10,"Parking",0,{"$f":"B24*D24","v":0},"Expenses per:","Est. Sq. Ft.",{"$f":"H23/D13","v":9.5444201030927847}]
[null,4,"RUBS",75,{"$f":"B25*D25","v":300},null,"Unit",{"$f":"H23/B6","v":7406.47}]
[null,"Total Monthly Income",null,null,{"$f":"SUM(E17:E25)","v":9233},null,"% of GSI",{"$f":"H23/E41","v":0.26739124156106719}]
[]
[null,"Stabilized Income",{"$nulls":4},"Stabilized Expenses"]
[null,1,"2BR / 2BA w/ yard",2700,{"$f":"D29*B29","v":2700},"Esti. Expenses",{"$f":"G16","v":0},"Prop Mgmt"]
[null,1,"2BR / 1BA",2500,2500,"Utilities",{"$f":"G17","v":1000},"OnSite Mgmt",{"$f":"I17","v":0}]
[null,1,"1BR + small BR / 1BA",2300,2300,"Water/Sewer",2880,"Insurance",2400]
[null,1,"1BR / 1BA",2100,2100,"Contracted ",1200,"License/Fees",0]
[{"$nulls":5},"Trash ",0,"Pool",0]
[null,null,"Laundry",null,75,"Pest Control",0,"Misc/Reserves",1000]
[null,10,"Parking",0,{"$f":"D35*B35","v":0},"Maintenance ",3000,"Taxes*",18145.88]
[null,4,"RUBS",75,{"$f":"B36*D36","v":300},"Total Annual Expenses",null,{"$f":"SUM(G29:G35)+SUM(I29:I35)","v":29625.88}]
[null,"Total Monthly Income",null,null,{"$f":"SUM(E29:E36)","v":9975},null,"% of GSI",{"$f":"H36/F41","v":0.24750108604845447}]
[]
[null,"Annual Operating Proforma",{"$nulls":4},"Financing Summary"]
[{"$nulls":4},"Current","Market"]
[null,"Gross Scheduled Income",null,null,{"$f":"E26*12","v":110796},{"$f":"E37*12","v":119700},"Down Payment",null,{"$f":"B9*I42","v":362500}]
[null,"Less:  Vacancy Factor",null,0.03,{"$f":"E41*D42","v":3323.8799999999997},{"$f":"F41*D42","v":3591},null,null,0.25]
[null,"Gross Operating Income",null,null,{"$f":"E41-E42","v":107472.12},{"$f":"F41-F42","v":116109}]
[null,"Less:  Expenses ",null,{"$f":"H26","v":0.26739124156106719},{"$f":"H23","v":29625.88},{"$f":"H36","v":29625.88},{"$f":"F44/F41","v":0.24750108604845447},null,"   "]
[null,"Net Operating Income",null,null,{"$f":"E43-E44","v":77846.239999999991},{"$f":"F43-F44","v":86483.12},"Proposed Financing:",null,{"$f":"B9-I41","v":1087500}]
[{"$nulls":6},"Interest Rate:",null,6.5000000000000002E-2]
[null,"Less:  1st TD Payments",null,null,{"$f":"PMT(I46/12,I47*12,I45,0,0)*12","v":-82484.877065831766},{"$f":"PMT(I46/12,I47*12,I45,0,0)*12","v":-82484.877065831766},"Amortized over:",null,30]
[null," ",null,null," "," "]
[{"$nulls":6},"Debt Coverage Ratio:"]
[null,"Pre-Tax Cash Flow",null,null,{"$f":"E45+E47","v":-4638.6370658317755},{"$f":"F45+F47","v":3998.2429341682291},"Current:",null,{"$f":"E45/E47*-1","v":0.94376378760764057}]
[{"$nulls":6},"Market:",null,{"$f":"F45/F47*-1","v":1.0484724361167101}]
[null,"Cash On Cash Return",null,null,{"$f":"E50/I41","v":-1.2796240181604898E-2},{"$f":"F50/(I41+C9)","v":1.102963568046408E-2}]
[]
[null,"Principal Reduction",null,null,{"$f":"(-E47)-(I45*I46)","v":11797.377065831766},{"$f":"(-F47)-(I45*I46)","v":11797.377065831766}]
[null,"Earned Return",null,null,{"$f":"(E50+E54)/I41","v":1.9748248275862045E-2},{"$f":"(F50+F54)/(I41+C9)","v":4.357412413793102E-2}]
[null,"The Browar Group"]
[null,"Florian Sighe | 619.894.3030 | florian@thebrowargroup.com"]
[]
[null,"The information contained herein has been obtained from sources believed reliable.  While The Browar Group does not doubt its accuracy, we have not verified it, and make no guarantee, warranty or representation about it.  It is your responsibility to independently confirm its accuracy and completeness.  Any projections, opinions, assumptions, or estimates are used for example only and do not represent the current or future performance of the property.  The value of this transaction to you depends on tax, financial, and legal advisors.  You and your advisors should  conduct a careful, independent, investigation of the property to determine to your satisfaction the suitability of the property to your needs."]