{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Page 1 - Table 1","Rent Roll Sample 2 - Table 1","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":2,"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":"Page 1 - Table 1","index":0,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,2,2,15],[4,2,4,6],[4,8,14,15],[5,2,5,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,12,2],[11,3,11,6],[12,3,12,6],[14,3,14,6],[15,2,15,6],[19,2,20,4],[19,8,19,15],[20,8,20,15],[21,8,21,15],[22,8,22,15],[23,8,23,11],[23,12,23,13],[23,14,23,15],[30,8,30,11],[31,8,31,11],[32,8,32,11],[33,8,33,11],[34,8,34,11],[38,2,38,11],[38,13,38,15],[39,2,39,3],[39,4,39,7],[39,9,39,11],[39,13,39,14],[40,2,40,3],[40,5,40,7],[40,9,40,10],[40,13,40,14],[41,2,41,3],[41,5,41,7],[41,9,41,10],[41,13,41,14],[42,2,42,3],[42,5,42,7],[42,9,42,10],[42,13,42,14],[43,2,43,3],[43,5,43,7],[43,9,43,10],[43,13,43,14],[44,2,44,3],[44,5,44,7],[44,9,44,10],[44,13,44,14],[45,2,45,3],[45,5,45,7],[45,9,45,10],[45,13,45,14],[46,2,46,3],[46,5,46,7],[46,9,46,10],[46,13,46,14],[47,2,47,3],[47,5,47,7],[47,9,47,10],[47,13,47,14],[48,2,48,3],[48,5,48,7],[48,9,48,10],[48,13,48,14],[49,2,49,11],[49,13,49,14],[50,2,50,11],[50,13,50,14],[51,3,51,4],[51,5,51,8],[51,10,51,11],[51,13,51,14],[55,2,55,15],[56,2,56,15],[52,3,52,4],[52,5,52,8],[52,10,52,11],[52,13,52,14],[53,3,53,4],[53,5,53,8],[53,9,53,11],[53,13,53,14]]}
[]
[]
[null,null,"CRESCENT                                                                                                                                                REALTY"]
[]
[null,null,"Alex Galuz"]
[null,null,"President/ Galuz Group"]
[null,null,"23975 Park Sorrento, Suite 110 \nCalabasas, CA 91302\n23975 Park Sorrento, Suite 110 \nCalabasas, CA 91302\n"]
[null,null,"Calabasas, CA 91302"]
[null,null,"Tel: (310) 466-0888"]
[null,null,"email: Alex@galuzgroup.com"]
[null,null,"www.galuzgroup.com"]
[null,null,"Property Address: ","4300 Tujunga Ave "]
[null,null,null,"Sudio City CA 91604"]
[]
[null,null,"LIST PRICE",2975000]
[null,null,"."]
[]
[]
[]
[null,null,"INVESTMENT SUMMARY",{"$nulls":5},"INVESTMENT HIGHLIGHT"]
[]
[null,null,"Down Payment:",{"$f":"D15*E22","v":1190000},0.4]
[null,null,"Year Built",1963]
[null,null,"Zoning","LAR3 ",{"$nulls":4},"SCHEDULED INCOME",null,null,null,"Current",null,"Proforma"]
[null,null,"Units",10,{"$nulls":4},"Units","Beds","Baths","Units S.F","Rent Average","Monthly Income","Rent","Monthly Income"]
[null,null,"Appx. Lot Size:",8765,"SQ. FT",null,null,null,4,1,1,800,1650,{"$f":"M26*I26","v":6600},2200,{"$f":"O26*I26","v":8800}]
[null,null,"Appx. Bldg NRSF:",8892,"SQ. FT",null,null,null,3,2,1,1150,2080,{"$f":"M27*I27","v":6240},2600,{"$f":"O27*I27","v":7800}]
[null,null,"Cost per NRSF:",{"$f":"D15/D27","v":334.57040035987404},{"$nulls":4},2,"S",1,600,1800,3600,1950,3900]
[null,null,"Cost per Unit:",{"$f":"D15/D25","v":297500},{"$nulls":4},1,2,2,1200,2565,2565,2800,2800]
[null,null,"Expense/ NRSF:",{"$f":"P52/D27","v":8.2843013663967593}]
[null,null,"Expense/ Unit:",{"$f":"P52/D25","v":7366.4007749999992},{"$nulls":4},"Total Schedule Rent:",{"$nulls":4},{"$f":"SUM(N26:N30)","v":19005},null,{"$f":"SUM(P26:P30)","v":23300}]
[null,null,null,"Current","Pro Forma",null,null,null,"Laundry:",{"$nulls":4},100,null,200]
[null,null,"GRM:",{"$f":"D15/N35","v":12.976533193753816},{"$f":"D15/P35","v":10.549645390070921},null,null,null,"Other Income:",{"$nulls":4},0,null,0]
[null,null,"CAP:",{"$f":"E45/D15","v":4.9989308319327741E-2},{"$f":"J45/D15","v":6.7185207478991593E-2},null,null,null,"Monthly Gross Income:",{"$nulls":4},{"$f":"N31+N32+N33","v":19105},null,{"$f":"P31+P32+P33","v":23500}]
[null,null,"ROI:",{"$f":"E49/D22","v":4.3479335074943178E-2},{"$f":"J49/D22","v":8.6469082974102829E-2},null,null,null,"Annual Gross Income:",{"$nulls":4},{"$f":"N34*12","v":229260},null,{"$f":"P34*12","v":282000}]
[]
[]
[]
[null,null,"ANNUAL INCOME",{"$nulls":10},"ESTIMATED ANNUAL EXPENSE"]
[{"$nulls":4},"Current",{"$nulls":4},"Pro Forma",null,null,null,"ITEM",null,"AMOUNT"]
[null,null,"Scheduled Gross Income:",null,{"$f":"N35","v":229260},{"$nulls":4},{"$f":"P35","v":282000},null,null,null,"Taxes:",null,{"$f":"D15*0.01245849","v":37064.007749999997}]
[null,null,"Less Vacancy Reserve Rate:",null,{"$f":"E41*F42","v":6877.8},0.03,null,null,"*",{"$f":"J41*L42","v":8460},null,0.03,null,"Insurance:",null,7900]
[null,null,"Gross Operating Income:",null,{"$f":"E41-E42","v":222382.2},{"$f":"E43/E41","v":0.97000000000000008},null,null,null,{"$f":"J41-J42","v":273540},null,{"$f":"J43/J41","v":0.97},null,"Utilities:",null,9000]
[null,null,"Less Expenses:",null,{"$f":"P52","v":73664.00774999999},{"$f":"E44/E41","v":0.32131208126144983},null,null,"*",{"$f":"P52","v":73664.00774999999},null,{"$f":"J44/J41","v":0.26121988563829784},null,"Maintenance & Repair's:",null,5000]
[null,null,"Net Operating Income:",null,{"$f":"E43-E44","v":148718.19225000002},{"$f":"E45/E41","v":0.64868791873855025},null,null,null,{"$f":"J43-J44","v":199875.99225000001},null,{"$f":"J45/J41","v":0.70878011436170218},null,"Trash:",null,3900]
[null,null,"Less Debt Service:",null,{"$f":"J54*12","v":121620.40408852801},{"$f":"E46/E41","v":0.53049116325799539},null,null,null,{"$f":"J54*12","v":121620.40408852801},null,{"$f":"J46/J41","v":0.43127802868272347},null,"Gardener and Pest:",null,1800]
[null,null,"Pre-Tax Cash Flow:",null,{"$f":"E45-E46","v":27097.78816147201},{"$f":"E47/D53","v":2.2771250555858831E-2},null,null,"**",{"$f":"J45-J46","v":78255.588161471998},null,{"$f":"J47/D53","v":6.5760998455018482E-2},null,"Misc/Reserves:",null,1000]
[null,null,"Plus Principal Reduction:",null,{"$f":"PPMT(J53,1,J52,-D54)","v":24642.620577710371},{"$f":"E48/D53","v":2.0708084519084347E-2},null,null,null,{"$f":"PPMT(J53,1,J52,-D54)","v":24642.620577710371},null,{"$f":"J48/D53","v":2.0708084519084347E-2},null,"           off site Management",null,8000]
[null,null,"Total Return Before Taxes:",null,{"$f":"E47+E48","v":51740.408739182385},{"$f":"E49/D53","v":4.3479335074943178E-2},null,null,"**",{"$f":"J47+J48","v":102898.20873918237},null,{"$f":"J49/D53","v":8.6469082974102829E-2}]
[null,null,"*As a Percent of Scheduled Gross Income                         ** As a Percent of Down Payment"]
[null,null,"FINANCING INFORMATION"]
[null,null,"Price:",{"$f":"D15","v":2975000},null,"Terms:",null,null,null,30,"Year",null,null,"TOTAL EXPENSES:",null,{"$f":"SUM(P41,P42:P51)","v":73664.00774999999}]
[null,null,"Down Payment:",{"$f":"D22","v":1190000},null,"Interest Rate:",null,null,null,5.5E-2,null,null,null,"Expense / NRSF:",null,{"$f":"P52/D27","v":8.2843013663967593}]
[null,null,"Loan Amount:",{"$f":"D52-D53","v":1785000},null,"Monthly Payment:",null,null,null,{"$f":"PMT(J53/12,J52*12,-D54)","v":10135.033674044002},null,null,null,"Expense / Unit:",null,{"$f":"P52/D25","v":7366.4007749999992}]
[]
[null,null,"This information has been secured from sources we believe to be reliable, but we make no representation or warranties, expressed or implied as to the accuracy of the information"]
[null,null,"References to square footage or age are approximate. Buyer must independently verify the information and bears all risks for any accurancies. Expenses are estimates."]

{"sheet":"Rent Roll Sample 2 - Table 1","index":1,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[48,0,48,5]]}
{"$rows_empty":11}
["Unit #","Status",null,"Unit Type","Move In","Curret Rent",null,"Market Rent","Notes"]
[]
[1,null,null,"Single",null,1800]
[2,null,null,"2+1",null,1690]
[3,null,null,"2+1",null,2500]
[4,null,null,"Single",null,1800]
[5,null,null,"1+1",null,1430]
[6,null,null,"2+2",null,2565]
[7,null,null,"1+1",null,1648]
[8,null,null,"1+1",null,1817]
[9,null,null,"2+1",null,2163]
[10,null,null,"1+1",null,1725]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"SUM(F14:F47)","v":19138}]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}