{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":[". figueroa st. proposals.xls)Se","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":". figueroa st. proposals.xls)Se","index":0,"n_rows":61,"n_cols":22,"rows_kept":61,"cut":false,"hidden":false,"merged":[[37,2,37,14],[1,15,1,21],[59,17,59,19],[6,2,6,10],[39,2,39,3],[45,2,45,3],[38,7,38,9],[41,2,41,3],[42,2,42,3],[41,15,41,18],[6,11,6,22],[12,13,12,22],[9,8,9,9],[8,13,8,17],[10,18,10,19],[11,18,11,19],[9,13,9,17],[37,15,37,21],[2,16,2,21],[10,13,10,16],[3,16,3,21],[4,16,4,21],[5,2,5,21],[8,18,8,19],[9,18,9,19],[20,2,20,21],[1,2,4,12],[60,2,61,22],[54,2,54,3],[55,2,55,3],[21,8,21,12],[21,16,21,20],[47,2,47,3],[38,11,38,13],[35,2,36,22],[52,2,52,3],[53,2,53,3],[45,15,45,18],[40,15,40,18],[46,15,46,18],[43,2,43,3],[40,2,40,3],[43,15,43,18],[46,2,46,7],[44,2,44,3]]}
[]
[{"$nulls":15},"Roy Belson"]
[{"$nulls":16},"818-707-7514"]
[{"$nulls":16},"818-707-7578 Fax"]
[]
[null,null,"Multi-Residential - Investment Summary"]
[null,null,"PRICING SUMMARY",{"$nulls":8},"PROPERTY DESCRIPTION"]
[]
[null,null," ",{"$nulls":8},"Property:",null,"1200 paeo camarillo",{"$nulls":4},"No. Units:",null," ",20]
[null,null,"Listed Price:",{"$nulls":5},5000000,null,null,"Address:",null,"camarillo, ca",{"$nulls":4},"Gross SF:",null," ",20914]
[null,null,"Down Payment:",{"$nulls":4},0.5,null,2000000,{"$nulls":8},"Lot Size:",null," ",84071]
[null,null,"Price per Unit:",{"$nulls":6},{"$f":"I10/V9","v":250000},{"$nulls":8},"Year Built:",null,null,1980]
[null,null,"Price per SF",{"$nulls":6},{"$f":"I10/V10","v":239.0743042937745},null,null,null,"FINANCING TERMS"]
[null,null,"Current GRM:",{"$nulls":6},{"$f":"I10/(J23+J25)","v":12.975082651276489},null,"Loan Amount:",{"$nulls":5},2000000]
[null,null,"Current CAP:",{"$nulls":6},{"$f":"J28/I10*100","v":5.3950800000000001},null,"Terms (Years):",null,null,null," ",null,30," "," ",null,30]
[null,null,"Market GRM:",{"$nulls":6},{"$f":"I10/(R23+R25)","v":9.9614293455739382},null,"Interest Rate:",null,null,null," ",null,5.2499999999999998E-2," "," ",null,0.06]
[null,null,"Market CAP:",{"$nulls":6},{"$f":"R28/I10*100","v":6.5367839999999999},null,"Monthly Payment:",null,null,null," ",null,{"$f":"PMT(R16/12,30*12,-R14)","v":11044.074042837967}," "," ",null,{"$f":"PMT(V16/12,30*12,-V14,0)","v":0}]
[{"$nulls":11},"Yearly Payment:",{"$nulls":5},{"$f":"R17*12","v":132528.88851405561},null," ",null,{"$f":"V17*12","v":0}]
[null,null," ",{"$nulls":14},1.2,null," ",null,1.2]
[]
[null,null,"ANNUALIZED OPERATING DATA"]
[{"$nulls":8},"Current ",{"$nulls":7},"Market"]
[null,null,"Scheduled Gross Income:",{"$nulls":6},385354,{"$nulls":6}," ",501936]
[null,null,"Less Vacancy Rate Reserve:",{"$nulls":8},0.05,{"$nulls":5},{"$f":"R23*T24","v":25096.800000000003},null,0.05]
[null,null,"Laundry Income:"]
[null,null,"Gross Operating Income:",{"$nulls":6},385354,{"$nulls":7},{"$f":"(R23+R25)-R24","v":476839.2}]
[null,null,"Less Expenses:",{"$nulls":6},115600,null,0.3,"*",{"$nulls":4},150000,null,{"$f":"R27/R23","v":0.29884288036721812},"*"]
[null,null,"Net Operating Income:",{"$nulls":6},{"$f":"J26-J27","v":269754},{"$nulls":7},{"$f":"R26-R27","v":326839.2}]
[null,null,"Less Loan Payments:",{"$nulls":6},{"$f":"R18","v":132528.88851405561},null,{"$f":"SUM(J28/J29)","v":2.0354354663692114},{"$nulls":5},{"$f":"J29","v":132528.88851405561}]
[null,null,"Pre-Tax Cash Flow:",{"$nulls":6},{"$f":"$J$28-$J$29","v":137225.11148594439},null,{"$f":"J30/J11","v":6.8612555742972189E-2},{"$nulls":5},{"$f":"R28-R29","v":194310.3114859444},null,{"$f":"R30/J11","v":9.7155155742972205E-2}]
[null,null,"Plus Principal Reduction:",{"$nulls":6},{"$f":"PPMT(R16,1,30,-R14,,0)","v":28833.86704617921},{"$nulls":7},{"$f":"$J$31","v":28833.86704617921}]
[null,null,"Total Return Before Taxes:",{"$nulls":6},{"$f":"J30+J31","v":166058.97853212361},null,{"$f":"J32/J11","v":8.3029489266061809E-2},"**",{"$nulls":4},{"$f":"R30+R31","v":223144.17853212362},null,{"$f":"R32/J11","v":0.11157208926606181},"**"]
[]
[null,null,"* As a percent of Scheduled Gross Income."]
[null,null,"** As a percent of Down Payment."]
[]
[]
[null,null,"SCHEDULED INCOME",{"$nulls":12},"ESTIMATED EXPENSES"]
[{"$nulls":7},"Current ",null,null,null,"Market",null,null,null,"Taxes (1.15%xSales Price)",{"$nulls":5},{"$f":"I10*0.0115","v":57500}]
[null,null,"Unit ",null,null,"# of",null,"Average",null,"Monthly",null,"Avg Market",null,"Monthly",null,"Management (4%xGOI)",{"$nulls":5},0]
[null,null,"Type",null,null,"Unit",null,"Rent",null,"Totals",null,"Rent",null,"Totals",null,"Insurance ",{"$nulls":5},5519]
[null,null,"1+1",null,null,3,null,975,null,2925,null,1000,null,{"$f":"L42*F42","v":3000},null,"Maintenance ",{"$nulls":5},8000]
[null,null,"2+2",null,null,1,null,1400,null,1400,null,1425,null,{"$f":"L43*F43","v":1425},null,"Utilities",{"$nulls":5},6000]
[null,null,"3+2",null,null,4,null,1800,null,{"$f":"F44*H44","v":7200},null,1825,null,{"$f":"L44*F44","v":7300},null,"Landscaping",{"$nulls":5},1080]
{"$rows_empty":8}
[null,null," "]
[]
[]
[]
[{"$nulls":15},"Total:",{"$nulls":5},{"$f":"SUM(V39:V54)","v":78099}]
[null,null,"Monthly Total Scheduled Rent:",{"$nulls":6},{"$f":"SUM(J42:J56)","v":11525},null,null,null,{"$f":"SUM(N42:N47)","v":11725},null,"Per Gross SF:",{"$nulls":5},{"$f":"V57/$V$10","v":3.7342928182078992}]
[null,null,"Annual Scheduled Gross Income:",{"$nulls":6},{"$f":"J58*12","v":138300},null,null,null,{"$f":"N58*12","v":140700},null,"Per Unit:",{"$nulls":5},{"$f":"V57/$V$9","v":3904.95}]
[]
[null,null,"This information has been secured from sources we believe to be reliable, however we make no representations or warranties, expressed or implied, as to the accuracy of the information.  References to square footage or age are approximate.  Buyer must verify the information and bears all risk for any inaccuracies."]

{"sheet":"Sheet1","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Compatibility Report for quick calc sheet.xls"]
[null,"Run on 8/26/2022 13:49"]
[]
[null,"If the workbook is saved in an earlier file format or opened in an earlier version of Microsoft Excel, the listed features will not be available."]
[]
[null,"Minor loss of fidelity",null,null,"# of occurrences","Version"]
[]
[null,"An embedded object in this worksheet can't be edited because it was created in a newer version of Microsoft Office.",null,null,1,"Excel 97-2003"]