{"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":4,"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":[[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],[50,2,50,11],[50,13,50,14],[51,3,51,4],[51,5,51,8],[51,10,51,11],[51,13,51,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],[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],[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],[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],[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],[38,13,38,15],[39,2,39,3],[39,4,39,7],[39,9,39,11],[39,13,39,14],[31,8,31,11],[32,8,32,11],[33,8,33,11],[34,8,34,11],[38,2,38,11],[22,8,22,15],[23,8,23,11],[23,12,23,13],[23,14,23,15],[30,8,30,11],[15,2,15,6],[19,2,20,4],[19,8,19,15],[20,8,20,15],[21,8,21,15],[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]]}
[]
[]
[null,null,"CRESCENT                                                                                                                                                REALTY"]
[]
[null,null,"Alex Galuz "]
[null,null,"SENIOR ASSOCIATE"]
[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) 291-2667 Fax: (877) 320-5662"]
[null,null,"email: Alex@galuzgroup.com"]
[null,null,"www.galuzgroup.com"]
[null,null,"Property Address: ","2731 Beverly Bl."]
[null,null,null,"Los Angeles, CA 90057"]
[]
[null,null,"LIST PRICE",8995000]
[]
[]
[]
[]
[null,null,"INVESTMENT SUMMARY",{"$nulls":5},"INVESTMENT HIGHLIGHT"]
[]
[null,null,"Down Payment:",{"$f":"D15*E22","v":4047750},0.45,null,null,null,"All Units have their own bathrooms and closets. Many units have city and Hollywood sign views."]
[null,null,"Year Built",1927]
[null,null,"Zoning","LAC2",{"$nulls":4},"SCHEDULED INCOME",null,null,null,"Current",null,"Proforma"]
[null,null,"Units",66,{"$nulls":4},"Units","Beds","Baths","Units S.F","Rent Average","Monthly Income","Rent","Monthly Income"]
[null,null,"Appx. Lot Size:",6826,"SQ. FT",null,null,null,63,"Room",1,220,1180,{"$f":"M26*I26","v":74340},1350,{"$f":"O26*I26","v":85050}]
[null,null,"Appx. Bldg NRSF:",24795,"SQ. FT",null,null,null,2,1,1,750,1612,{"$f":"M27*I27","v":3224},1800,{"$f":"O27*I27","v":3600}]
[null,null,"Cost per NRSF:",{"$f":"D15/D27","v":362.77475297439003},{"$nulls":4},1,"Comm.",1,2500,4561,{"$f":"M28*I28","v":4561},5000,{"$f":"O28*I28","v":5000}]
[null,null,"Cost per Unit:",{"$f":"D15/D25","v":136287.87878787878},{"$nulls":10},1900,0]
[null,null,"Expense/ NRSF:",{"$f":"P52/D27","v":13.11684281306715}]
[null,null,"Expense/ Unit:",{"$f":"P52/D25","v":4927.759356818181},{"$nulls":4},"Total Schedule Rent:",{"$nulls":4},{"$f":"SUM(N26:N30)","v":82125},null,{"$f":"SUM(P26:P30)","v":93650}]
[null,null,null,"Current","Pro Forma",null,null,null,"Laundry:",{"$nulls":4},0,null,500]
[null,null,"GRM:",{"$f":"D15/N35","v":9.1273465246067982},{"$f":"D15/P35","v":7.9615861214374224},null,null,null,"Other Income:",{"$nulls":4},0,null,0]
[null,null,"CAP:",{"$f":"E45/D15","v":7.0117051967759872E-2},{"$f":"J45/D15","v":8.5678030289049481E-2},null,null,null,"Monthly Gross Income:",{"$nulls":4},{"$f":"N31+N32+N33","v":82125},null,{"$f":"P31+P32+P33","v":94150}]
[null,null,"ROI:",{"$f":"E49/D22","v":8.3341374727120429E-2},{"$f":"J49/D22","v":0.11792132655220844},null,null,null,"Annual Gross Income:",{"$nulls":4},{"$f":"N34*12","v":985500},null,{"$f":"P34*12","v":1129800}]
[]
[]
[]
[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":985500},{"$nulls":4},{"$f":"P35","v":1129800},null,null,null,"Taxes:",null,{"$f":"D15*0.01245849","v":112064.11755}]
[null,null,"Less Vacancy Reserve Rate:",null,{"$f":"E41*F42","v":29565},0.03,null,null,"*",{"$f":"J41*L42","v":33894},null,0.03,null,"Insurance:",null,48000]
[null,null,"Gross Operating Income:",null,{"$f":"E41-E42","v":955935},{"$f":"E43/E41","v":0.97},null,null,null,{"$f":"J41-J42","v":1095906},null,{"$f":"J43/J41","v":0.97},null,"Utilities:",null,65000]
[null,null,"Less Expenses:",null,{"$f":"P52","v":325232.11754999997},{"$f":"E44/E41","v":0.33001736940639265},null,null,"*",{"$f":"P52","v":325232.11754999997},null,{"$f":"J44/J41","v":0.28786698313860859},null,"Maintenance & Repair's:",null,25000]
[null,null,"Net Operating Income:",null,{"$f":"E43-E44","v":630702.88245000003},{"$f":"E45/E41","v":0.63998263059360738},null,null,null,{"$f":"J43-J44","v":770673.88245000003},null,{"$f":"J45/J41","v":0.68213301686139138},null,"Trash:",null,10000]
[null,null,"Less Debt Service:",null,{"$f":"J54*12","v":355935.16026743449},{"$f":"E46/E41","v":0.36117215653722423},null,null,null,{"$f":"J54*12","v":355935.16026743449},null,{"$f":"J46/J41","v":0.31504262725034032},null,"Pest:",null,3000]
[null,null,"Pre-Tax Cash Flow:",null,{"$f":"E45-E46","v":274767.72218256554},{"$f":"E47/D53","v":6.7881594017062702E-2},null,null,"**",{"$f":"J45-J46","v":414738.72218256554},null,{"$f":"J47/D53","v":0.10246154584215071},null,"Misc/Reserves:",null,7000]
[null,null,"Plus Principal Reduction:",null,{"$f":"PPMT(J53,1,J52,-D54)","v":62577.327369136146},{"$f":"E48/D53","v":1.5459780710057722E-2},null,null,null,{"$f":"PPMT(J53,1,J52,-D54)","v":62577.327369136146},null,{"$f":"J48/D53","v":1.5459780710057722E-2},null,"Off site Management",null,29668]
[null,null,"Total Return Before Taxes:",null,{"$f":"E47+E48","v":337345.0495517017},{"$f":"E49/D53","v":8.3341374727120429E-2},null,null,"**",{"$f":"J47+J48","v":477316.0495517017},null,{"$f":"J49/D53","v":0.11792132655220844},null,"On site Management",null,24000]
[null,null,"*As a Percent of Scheduled Gross Income                         ** As a Percent of Down Payment",{"$nulls":10},"Elevator ",null,1500]
[null,null,"FINANCING INFORMATION"]
[null,null,"Price:",{"$f":"D15","v":8995000},null,"Terms:",null,null,null,30,"Year",null,null,"TOTAL EXPENSES:",null,{"$f":"SUM(P41,P42:P51)","v":325232.11754999997}]
[null,null,"Down Payment:",{"$f":"D22","v":4047750},null,"Interest Rate:",null,null,null,0.06,null,null,null,"Expense / NRSF:",null,{"$f":"P52/D27","v":13.11684281306715}]
[null,null,"Loan Amount:",{"$f":"D52-D53","v":4947250},null,"Monthly Payment:",null,null,null,{"$f":"PMT(J53/12,J52*12,-D54)","v":29661.26335561954},null,null,null,"Expense / Unit:",null,{"$f":"P52/D25","v":4927.759356818181}]
[]
[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":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[[81,0,81,5],[14,11,14,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[50,11,50,12],[51,11,51,12],[52,11,52,12],[53,11,53,12],[54,11,54,12],[55,11,55,12],[56,11,56,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[72,11,72,12],[73,11,73,12],[74,11,74,12],[80,11,80,12],[75,11,75,12],[76,11,76,12],[77,11,77,12],[78,11,78,12],[79,11,79,12]]}
{"$rows_empty":11}
["Unit #","Status","Section 8","Unit Type","Unit Size","Move In","Curret Rent","Market Rent","Notes"]
[]
[]
["100",null,null,"Retail",null,null,4561]
["Loft",null,null,"Loft"]
["101",null,null,"Bachelor",null,null,1225]
["102",null,null,"Bachelor",null,null,1200]
["103",null,null,"Bachelor",null,null,1100]
["104",null,"Manager","1 bedroom",null,null,1500]
["105",null,null,"big 1 bedroom",null,null,1696]
["201",null,null,"Bachelor",null,null,1200]
["202",null,null,"Bachelor",null,null,1200]
["203",null,null,"Bachelor",null,null,1200]
["204",null,null,"Bachelor",null,null,1200]
["205",null,null,"Bachelor",null,null,759.62]
["206",null,null,"Bachelor",null,null,1250]
["207",null,null,"Bachelor",null,null,1200]
["208",null,null,"Bachelor",null,null,1100]
["209",null,null,"Bachelor",null,null,1050]
["210",null,null,"Bachelor",null,null,1250]
["211",null,null,"Bachelor",null,null,1250]
["212",null,null,"Bachelor",null,null,1200]
["214",null,null,"Bachelor",null,null,1250]
["215",null,null,"Bachelor",null,null,1248]
["216",null,null,"Bachelor",null,null,1200]
["217",null,null,"Bachelor",null,null,1250]
["218",null,null,"Bachelor",null,null,1225]
["219",null,null,"Bachelor",null,null,1250]
["220",null,null,"Bachelor",null,null,1200]
["221",null,null,"Bachelor",null,null,1200]
["301",null,null,"Bachelor",null,null,1100]
["302",null,null,"Bachelor",null,null,1075]
["303",null,null,"Bachelor",null,null,1200]
["304",null,null,"Bachelor",null,null,1200]
["305",null,null,"Bachelor",null,null,1200]
["306",null,null,"Bachelor",null,null,1248]
["307",null,null,"Bachelor",null,null,1200]
["308",null,null,"Bachelor",null,null,1166]
["309",null,null,"Bachelor",null,null,1200]
["310",null,null,"Bachelor",null,null,1195]
["311",null,null,"Bachelor",null,null,1250]
["312",null,null,"Bachelor",null,null,1200]
["314",null,null,"Bachelor",null,null,1200]
["315",null,null,"Bachelor",null,null,1200]
["316",null,null,"Bachelor",null,null,1200]
["317",null,null,"Bachelor",null,null,1200]
["318",null,null,"Bachelor",null,null,1200]
["319",null,null,"Bachelor",null,null,1200]
["320",null,null,"Bachelor",null,null,1100]
["321",null,null,"Bachelor",null,null,1200]
["401",null,null,"Bachelor",null,null,1166]
["402",null,null,"Bachelor",null,null,1200]
["403",null,null,"Bachelor",null,null,1200]
["404",null,null,"Bachelor",null,null,1272]
["405",null,null,"Bachelor",null,null,1200]
["406",null,null,"Bachelor",null,null,1250]
["407",null,null,"Bachelor",null,null,1166]
["408",null,null,"Bachelor",null,null,1200]
["409",null,null,"Bachelor",null,null,1168.6500000000001]
["410",null,null,"Bachelor",null,null,1195]
["411",null,null,"Bachelor",null,null,1200]
["412",null,null,"Bachelor",null,null,1100]
["414",null,null,"Bachelor",null,null,1200]
["415",null,null,"Bachelor",null,null,1200]
["416",null,null,"Bachelor",null,null,1200]
["417",null,null,"Bachelor",null,null,1250]
["418",null,null,"Bachelor",null,null,1200]
["419",null,null,"Bachelor",null,null,759.62]
["420",null,null,"Bachelor",null,null,1250]
["421",null,null,"Bachelor",null,null,1050]
["TOTAL",{"$nulls":5},{"$f":"SUM(G15:G81)","v":82125.889999999985},{"$f":"SUM(H17:H81)","v":0}]

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