{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Input Sheet","Current & Market Rents","Sheet1","Rent Roll"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":9,"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":"Input Sheet","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,2,0,5],[21,5,21,6]]}
[null,null,"Input Sheet"]
[]
["This brochure is set up as a read only document - go up to File and click Save As - rename the document in order to manipulate the data"]
["      All areas in red on Set-Up Sheet contain a formula and are calculated automatically - "]
["                                  these fields do not appear on the Input Sheet"]
["Blue","All BLUE cells - Information is transferred from input sheet onto Brochures"]
["Red","All RED cells  - information is set up to automatically calculate formulas"]
[]
[]
["Summary Section",null,null,null,"Address","645 N Cummings "]
["Price",875000,null,null,"City, State","Boyle Heights, CA"]
["Down Pmt %",0.3,null,null,"Property Type","Income Property"]
["Interest Rate",6.7500000000000004E-2,null,null,"APN:","5175-031-009"]
["Number of Units",2]
["Year Built",1931,null,null,"Current Annualized Operating Data:"]
["Approx. Lot SF",5367]
["Approx. RSF:",3430,null,null,"Vacancy Reserve @ ( input %)",null,"will calculate $"]
["# Parking Spaces",2,null,null,"Equity Build Up"]
[{"$nulls":4},"Total Return"]
[{"$nulls":4},"Proposed Financing","New 1st TD proposed at 3.5% fixed 30 yrs amtz. Over 30"]
[]
[{"$nulls":5},"information below not on CURRENT RENT set up"]
[null,"Current Rental Income",null,null,"input $ for Rent-Range only","   Market Rental Income"]
["# Units","Type","Apx SF","Rent/Unit","Income","Rent/Unit","Income"]
[]
[1,null,null,2706,2706,3400]
[1,null,null,2472.4699999999998,2472.4699999999998,3400]
[]
[]
["total;",null,null,{"$f":"SUM(D26:D29)","v":5178.4699999999993}]
[{"$nulls":5},{"$f":"SUM(F26:F30)","v":6800}]
[]
["Laundry",0,null,null,"Laundry",0]
["Other Income",null,null,null,"Other Income"]
["Annualized Expenses"]
["Property Tax ",{"$f":"B11*1.125%","v":9843.75}]
["Insurance",2800]
["Utilities & rubbish",0]
["Gardening",0]
["Repairs & Maintenance",1000]
["Internet",0]
["Off Site Mgt"]
[]
[]
["Rubbish"]
["Legal/Acct.",0]
["Misc. & Res.",2000]

{"sheet":"Current & Market Rents","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[23,5,23,6],[4,6,4,8],[43,0,50,4],[0,0,4,4]]}
[]
[{"$nulls":7},{"$f":"'Input Sheet'!F10","v":"645 N Cummings "}]
[{"$nulls":7},{"$f":"'Input Sheet'!F11","v":"Boyle Heights, CA"}]
[{"$nulls":7},{"$f":"'Input Sheet'!F12","v":"Income Property"}]
[{"$nulls":5},"APN:","5175-031-009"]
["118 N Larchmont Blvd. Los Angeles, Ca 90010",{"$nulls":7},"DRE 01379619"]
["Summary",null,null,null,"Annualized Operating Data",null,null,"CURRENT","PROFORMA"]
["     Price:",null,null,{"$f":"'Input Sheet'!B11","v":875000},"Scheduled Gross Income:",null,null,{"$f":"SUM(E40*12)","v":62141.639999999992},{"$f":"SUM(G40*12)","v":96000}]
["Down Pmt @",null,{"$f":"'Input Sheet'!B12","v":0.3},{"$f":"D8*C9","v":262500},"Vacancy Reserve @",null,{"$f":"'Input Sheet'!F17","v":0},{"$f":"-H8*G9","v":0},{"$f":"-SUM(I8*G9)","v":0}]
["First Loan Amount:",null,null,{"$f":"D8*(1-C9)","v":612500},"Gross Operating Income:",null,null,{"$f":"SUM(H8:H9)","v":62141.639999999992},{"$f":"SUM(I8:I9)","v":96000}]
["Interest Rate:",null,null,{"$f":"'Input Sheet'!B13","v":6.7500000000000004E-2},"Expenses:",null,null,{"$f":"-SUM(I27:I38)","v":-15643.75},{"$f":"-I39","v":-15643.75}]
["Price per unit",null,null,{"$f":"D8/2","v":437500},"Net Operating Income:",null,null,{"$f":"SUM(H10:H11)","v":46497.889999999992},{"$f":"SUM(I10:I11)","v":80356.25}]
["GRM:",null,null,{"$f":"D8/H8","v":14.080735558314846},"Estimated Loan Payments:",null,null,{"$f":"PMT(0.0325,360/12,D10)","v":-32267.551626813754},{"$f":"H13","v":-32267.551626813754}]
[{"$nulls":4},"Pre-Tax Cash Flow:",null,null,{"$f":"SUM(H12:H13)","v":14230.338373186238},{"$f":"SUM(I12:I13)","v":48088.698373186242}]
["CAP:",{"$f":"SUM(H12/D8)","v":5.3140445714285708E-2},"PROF.",{"$f":"SUM(I12/D8)","v":9.1835714285714284E-2},"Cash on Cash Return:",null,null,{"$f":"(H14)/D9","v":5.4210812850233284E-2},{"$f":"SUM(I14/D9)","v":0.18319504142166187}]
["Year Built:",null,null,{"$f":"'Input Sheet'!B15","v":1931},"Equity Build Up:",null,null,{"$f":"'Input Sheet'!F18","v":0}]
["Approx. Lot SF",null,null,{"$f":"'Input Sheet'!B16","v":5367},"Total Return:",null,null,{"$f":"'Input Sheet'!F19","v":0}]
["Approx. RSF:",null,null,{"$f":"'Input Sheet'!B17","v":3430}]
["Cost per RSF:",null,null,{"$f":"D8/D18","v":255.10204081632654},"Proposed Financing:"]
["Parking spaces ",null,null,{"$f":"'Input Sheet'!B18","v":2},{"$f":"'Input Sheet'!F20","v":"New 1st TD proposed at 3.5% fixed 30 yrs amtz. Over 30"}]
["Zoning "]
[null,"Scheduled Income"]
[]
[null,null,"CURRENT",null,null,"PROFORMA"]
[]
["# Units","Type","Apx. SF","Rent/Unit","Income","Rent/Unit","Income","  Est. Annualized Expenses"]
[{"$nulls":7},"Taxes",{"$f":"'Input Sheet'!B36","v":9843.75}]
[null,"5+2",1715,2472.4699999999998,2472.4699999999998,null,4000,"Insurance",{"$f":"'Input Sheet'!B37","v":2800}]
[null,"5+2",1715,2706,2706,null,4000,"Utilities "]
[{"$nulls":7},"Repairs & Maint.",{"$f":"'Input Sheet'!B40","v":1000}]
[{"$nulls":7},{"$f":"'Input Sheet'!A47","v":"Misc. & Res."},{"$f":"'Input Sheet'!B47","v":2000}]
[{"$nulls":7},{"$f":"'Input Sheet'!A42","v":"Off Site Mgt"},{"$f":"'Input Sheet'!B42","v":0}]
[{"$nulls":7},{"$f":"'Input Sheet'!A45","v":"Rubbish"}]
[{"$nulls":7},"Gardening",{"$f":"'Input Sheet'!B39","v":0}]
[]
[]
["Total Scheduled Monthly Rent:",null,null,null,{"$f":"SUM(E28:E36)","v":5178.4699999999993},null,{"$f":"SUM(G28:G36)","v":8000}]
[null,"Laundry: ",null,null,{"$f":"'Input Sheet'!B33","v":0},null,{"$f":"'Input Sheet'!F33","v":0}]
[null,"Other Income",null,null,{"$f":"'Input Sheet'!B34","v":0},null,{"$f":"'Input Sheet'!F34","v":0},"Total Expenses:",{"$f":"SUM(I27:I38)","v":15643.75}]
["Monthly Scheduled Gross Income:",null,null,null,{"$f":"SUM(E37:E39)","v":5178.4699999999993},null,{"$f":"SUM(G37:G38)","v":8000},"Per Net SF:",{"$f":"-I39/D18","v":-4.5608600583090375}]
["Annual Gross Income:",null,null,null,{"$f":"SUM(E40*12)","v":62141.639999999992},null,{"$f":"SUM(G40*12)","v":96000}]
[{"$nulls":7},"% of Gross:",{"$f":"SUM(I39/I8)","v":0.16295572916666667}]
[null,null,"PROPERTY DESCRIPTION:"]
["TREMENDOUS UPSIDE! This spacious duplex offers incredible rental growth potential, perfectly positioned to benefit from the rapid development happening in the area. Each unit is approximately 1,715 sq ft, featuring 5 bedrooms and 2 bathrooms—rare, large layouts that are ideal for attracting long-term tenants or maximizing rental income.\nLocated in a quiet residential neighborhood, this property blends suburban tranquility with urban opportunity.\nBONUS OPPORTUNITY: The neighboring building at 649 N Cummings is also available for sale—perfect for investors looking to expand their portfolio or secure a prime multi-property location. Details available upon request."]

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

{"sheet":"Rent Roll","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Rent Roll - "]
[]
["Unit #","Tenant","Tenant Name","Recurring Chgs","Deposit Held","Lease Expires","Rent/SF"]
[]
[1,null,"Occupied",3600]
[2,null,"Occupied",3600]
[3,null,"Occupied",3800]
[4,null,"Occupied",3500]
[null,null,"Total",{"$f":"SUM(D4:D8)","v":14500},{"$f":"SUM(E4:E8)","v":0}]
[]
[]
["Average",null,{"$f":"AVERAGE(D4:D8)","v":3625}]