{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Page 1 - Table 1","Page 2 Rent Roll - Table 1"],"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":[[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],[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],[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],[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],[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],[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],[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],[19,2,20,4],[38,13,38,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],[19,8,19,15],[20,8,20,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],[15,2,15,6]]}
[]
[]
[null,null,"CRESCENT                                                                                                                                                REALTY"]
[]
[null,null,"Alex Galuz "]
[null,null,"Keller Williams "]
[null,null,"23975 Park Sorrento, Suite 110 "]
[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: ","14827 Victory Blvd."]
[null,null,null,"Van Nuys CA 91411"]
[]
[null,null,"LIST PRICE",4950000]
[]
[]
[]
[]
[null,null,"INVESTMENT SUMMARY",{"$nulls":5},"INVESTMENT HIGHLIGHT"]
[{"$nulls":8},"Good unit mix with low maintenance "]
[null,null,"Down Payment:",{"$f":"D15*E22","v":1980000},0.4,null,null,null,"New Construction  Central Valley Location"]
[null,null,"Year Built",2020,{"$nulls":4},"Non Rent Control "]
[null,null,"Zoning","LAR3",{"$nulls":4},"SCHEDULED INCOME",null,null,null,"Current",null,"Proforma"]
[null,null,"Units",9,{"$nulls":4},"Units","Beds","Baths","Units S.F","Rent Average","Monthly Income","Rent","Monthly Income"]
[null,null,"Appx. Lot Size:",6534,"SQ. FT",null,null,null,1,1,1,588,2250,{"$f":"M26*I26","v":2250},2300,2300]
[null,null,"Appx. Bldg NRSF:",14279,"SQ. FT",null,null,null,3,3,3.5,1350,3400,{"$f":"M27*I27","v":10200},3600,10800]
[null,null,"Cost per NRSF:",{"$f":"D15/D27","v":346.66293157784156},{"$nulls":4},2,3,2,1350,3500,{"$f":"M28*I28","v":7000},3600,7200]
[null,null,"Cost per Unit:",{"$f":"D15/D25","v":550000},{"$nulls":4},3,4,3,1650,3600,10800,3950,11850]
[null,null,"Expense/ NRSF:",{"$f":"P52/D27","v":7.2365673716646812}]
[null,null,"Expense/ Unit:",{"$f":"P52/D25","v":11481.216166666665},{"$nulls":4},"Total Schedule Rent:",{"$nulls":4},{"$f":"SUM(N26:N30)","v":30250},null,{"$f":"SUM(P26:P30)","v":32150}]
[null,null,null,"Current","Pro Forma",null,null,null,"Laundry:"]
[null,null,"GRM:",{"$f":"D15/N35","v":13.636363636363637},{"$f":"D15/P35","v":12.830482115085536},null,null,null,"Other Income:"]
[null,null,"CAP:",{"$f":"E45/D15","v":5.0258394848484857E-2},{"$f":"J45/D15","v":5.4726273636363641E-2},null,null,null,"Monthly Gross Income:",{"$nulls":4},{"$f":"N31+N32+N33","v":30250},null,{"$f":"P31+P32+P33","v":32150}]
[null,null,"ROI:",{"$f":"E49/D22","v":4.0427230887193938E-2},{"$f":"J49/D22","v":5.1596927856890906E-2},null,null,null,"Annual Gross Income:",{"$nulls":4},{"$f":"N34*12","v":363000},null,{"$f":"P34*12","v":385800}]
[]
[]
[]
[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":363000},{"$nulls":4},{"$f":"P35","v":385800},null,null,null,"Taxes:",null,{"$f":"D15*0.01245849","v":61669.525499999996}]
[null,null,"Less Vacancy Reserve Rate:",null,{"$f":"E41*F42","v":10890},0.03,null,null,"*",{"$f":"J41*L42","v":11574},null,0.03,null,"Insurance:",null,{"$f":"0.45*D27","v":6425.55}]
[null,null,"Gross Operating Income:",null,{"$f":"E41-E42","v":352110},{"$f":"E43/E41","v":0.97},null,null,null,{"$f":"J41-J42","v":374226},null,{"$f":"J43/J41","v":0.97},null,"Utilities:",null,13285.87]
[null,null,"Less Expenses:",null,{"$f":"P52","v":103330.94549999999},{"$f":"E44/E41","v":0.28465825206611567},null,null,"*",{"$f":"P52","v":103330.94549999999},null,{"$f":"J44/J41","v":0.26783552488335921},null,"Maintenance & Repair's:",null,4500]
[null,null,"Net Operating Income:",null,{"$f":"E43-E44","v":248779.05450000003},{"$f":"E45/E41","v":0.68534174793388436},null,null,null,{"$f":"J43-J44","v":270895.05450000003},null,{"$f":"J45/J41","v":0.70216447511664082},null,"Trash:",null,3750]
[null,null,"Less Debt Service:",null,{"$f":"J54*12","v":207985.36603648227},{"$f":"E46/E41","v":0.572962440871852},null,null,null,{"$f":"J54*12","v":207985.36603648227},null,{"$f":"J46/J41","v":0.53910151901628378},null,"Pest:",null,1200]
[null,null,"Pre-Tax Cash Flow:",null,{"$f":"E45-E46","v":40793.688463517756},{"$f":"E47/D53","v":2.0602872961372604E-2},null,null,"**",{"$f":"J45-J46","v":62909.688463517756},null,{"$f":"J47/D53","v":3.1772569931069576E-2},null,"Gardener/Grounds:",null,1200]
[null,null,"Plus Principal Reduction:",null,{"$f":"PPMT(J53,1,J52,-D54)","v":39252.228693126235},{"$f":"E48/D53","v":1.982435792582133E-2},null,null,null,{"$f":"PPMT(J53,1,J52,-D54)","v":39252.228693126235},null,{"$f":"J48/D53","v":1.982435792582133E-2},null,"Misc/Reserves:",null,4000]
[null,null,"Total Return Before Taxes:",null,{"$f":"E47+E48","v":80045.917156643991},{"$f":"E49/D53","v":4.0427230887193938E-2},null,null,"**",{"$f":"J47+J48","v":102161.91715664399},null,{"$f":"J49/D53","v":5.1596927856890906E-2},null,"Management: ",null,7300]
[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":4950000},null,"Terms:",null,null,null,30,"Year",null,null,"TOTAL EXPENSES:",null,{"$f":"SUM(P41,P42:P51)","v":103330.94549999999}]
[null,null,"Down Payment:",{"$f":"D22","v":1980000},null,"Interest Rate:",null,null,null,5.7500000000000002E-2,null,null,null,"Expense / NRSF:",null,{"$f":"P52/D27","v":7.2365673716646812}]
[null,null,"Loan Amount:",{"$f":"D52-D53","v":2970000},null,"Monthly Payment:",null,null,null,{"$f":"PMT(J53/12,J52*12,-D54)","v":17332.113836373523},null,null,null,"Expense / Unit:",null,{"$f":"P52/D25","v":11481.216166666665}]
[]
[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":"Page 2 Rent Roll - Table 1","index":1,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,2,53,4],[53,8,53,10],[53,11,53,12],[53,13,53,14],[56,2,56,15],[57,2,57,15],[51,2,51,4],[51,9,51,10],[51,11,51,12],[51,13,51,14],[52,2,52,4],[52,9,52,10],[52,11,52,12],[52,13,52,14],[49,2,49,4],[49,9,49,10],[49,11,49,12],[49,13,49,14],[50,2,50,4],[50,9,50,10],[50,11,50,12],[50,13,50,14],[47,2,47,4],[47,9,47,10],[47,11,47,12],[47,13,47,14],[48,2,48,4],[48,9,48,10],[48,11,48,12],[48,13,48,14],[45,2,45,4],[45,9,45,10],[45,11,45,12],[45,13,45,14],[46,2,46,4],[46,9,46,10],[46,11,46,12],[46,13,46,14],[43,2,43,4],[43,9,43,10],[43,11,43,12],[43,13,43,14],[44,2,44,4],[44,9,44,10],[44,11,44,12],[44,13,44,14],[41,2,41,4],[41,9,41,10],[41,11,41,12],[41,13,41,14],[42,2,42,4],[42,9,42,10],[42,11,42,12],[42,13,42,14],[39,2,39,4],[39,9,39,10],[39,11,39,12],[39,13,39,14],[40,2,40,4],[40,9,40,10],[40,11,40,12],[40,13,40,14],[37,2,37,4],[37,9,37,10],[37,11,37,12],[37,13,37,14],[38,2,38,4],[38,9,38,10],[38,11,38,12],[38,13,38,14],[35,2,35,4],[35,9,35,10],[35,11,35,12],[35,13,35,14],[36,2,36,4],[36,9,36,10],[36,11,36,12],[36,13,36,14],[33,2,33,4],[33,9,33,10],[33,11,33,12],[33,13,33,14],[34,2,34,4],[34,9,34,10],[34,11,34,12],[34,13,34,14],[31,2,31,4],[31,9,31,10],[31,11,31,12],[31,13,31,14],[32,2,32,4],[32,9,32,10],[32,11,32,12],[32,13,32,14],[29,2,29,4],[29,9,29,10],[29,11,29,12],[29,13,29,14],[30,2,30,4],[30,9,30,10],[30,11,30,12],[30,13,30,14],[27,2,27,4],[27,9,27,10],[27,11,27,12],[27,13,27,14],[28,2,28,4],[28,9,28,10],[28,11,28,12],[28,13,28,14],[25,2,25,4],[25,9,25,10],[25,11,25,12],[25,13,25,14],[26,2,26,4],[26,9,26,10],[26,11,26,12],[26,13,26,14],[23,2,23,4],[23,9,23,10],[23,11,23,12],[23,13,23,14],[24,2,24,4],[24,9,24,10],[24,11,24,12],[24,13,24,14],[21,2,21,4],[21,9,21,10],[21,11,21,12],[21,13,21,14],[22,2,22,4],[22,9,22,10],[22,11,22,12],[22,13,22,14],[11,3,11,6],[12,3,12,6],[14,3,14,6],[15,2,15,6],[19,2,20,4],[19,8,20,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]]}
[]
[]
[null,null,"CRESCENT                                                                                                                                                REALTY"]
{"$rows_empty":16}
[null,null,"NOTES",{"$nulls":5},"RENT ROLL"]
[]
[{"$nulls":8},"Unit #","Unit Mix",null,"Current Rent ",null,"Market Rent",null,"SqFt."]
[{"$nulls":8},1,"4+3",null,3525,null,3995,null,1867]
[{"$nulls":8},2,"3+3.5",null,3725,null,3799,null,1508]
[{"$nulls":8},3,"3+3.5",null,3395,null,3500,null,1168]
[{"$nulls":8},4,"3+2.5",null,3295,null,3600,null,1314]
[{"$nulls":8},5,"3+2.5",null,3495,null,3600,null,1133]
[{"$nulls":8},6,"4+2.5",null,3595,null,3900,null,1434]
[{"$nulls":8},7,"1+1",null,2248,null,2300,null,588]
[{"$nulls":8},8,"4+3.5",null,3925,null,3925,null,1624]
[{"$nulls":8},9,"3+2.5",null,3515,null,3700,null,1587]
{"$rows_empty":22}
[{"$nulls":11},{"$f":"SUM(L23:M45)","v":30718},null,{"$f":"SUM(N23:N45)","v":32319}]