{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Rent Roll","Expenses","Water Bill (Monthly)","T12"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Rent Roll","index":0,"n_rows":62,"n_cols":24,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Address ","HUD Numbers",{"$nulls":4},"Rent","Term","Tech ","Septic","Garbage ","Due date","August ","September ","October ","November ","December ","January '26 ","February '26","March '26","April '26","May '26","June '26","July '26"]
["9690 Hildebrandt #1",null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9690 Hildebrandt #2",null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9690 Hildebrandt #3","TEX 525112","Ariel Salas ","210-668-7364",null,null,1300.0,null,10.0,20.0,15.0,"1st ",1300.0,1300.0,1300.0,1300.0,1300.0]
["9690 Hildebrandt #4",null,"Delilah Robinson","915-216-4808","Delilarobinson27@gmail.com",null,1000.0,null,10.0,20.0,15.0,"1st",1000.0,1000.0,1000.0,1000.0,1000.0]
["9690 Hildebrandt #5",null,"Petra Uballe","210-765-6423","petrauballe17@gmail.com",null,1200.0,null,10.0,20.0,15.0,"1st ",1200.0,1200.0,1200.0,1200.0,1200.0,1100.0]
["9690 Hildebrandt #7","TEX 332288","Leo Neal ",null,null,null,1000.0,null,10.0,20.0,15.0,"1st ",1000.0,1000.0,1000.0,1000.0,1000.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
[null,null,"EMPTY",{"$nulls":5},10.0,20.0,15.0]
["9690 Hildebrandt #9","TEX 227690","Krystal Martinez","210-762-2511",null,null,1000.0,null,10.0,20.0,15.0,"5th","NA","NA",1000.0,1000.0,500.0]
["9720 Hildebrandt #1","TEX 391098","Stacie Arnson","210-847-6894","jazzedu@gmail.com",null,1400.0,null,10.0,20.0,15.0,"15th ",1400.0,1400.0,1400.0,1400.0]
["9720 Hildebrandt #2",null,"Available soon ",{"$nulls":5},10.0,20.0,15.0]
["9720 Hildebrandt #3 ",null,"Amanda Villarreal ","210-452-5388",null,null,900.0,null,10.0,20.0,15.0,"15th","NA",900.0,850.0,450.0]
["9720 Hildebrandt #4","PFS 551148","Cipriano Gomez ",null,null,null,1300.0,null,10.0,20.0,15.0,"1st",1300.0,1300.0,1300.0,1300.0,1300.0]
["9720 Hildebrandt #6",null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9720 Hildebrandt #7",null,"Isabel Suarez ","210-636-7724",null,null,1400.0,null,10.0,20.0,15.0,"15th",1400.0,1400.0,1400.0,1500.0]
["9720 Hildebrandt #8",null,"Juan Sanchez ","726-233-9290","Timelesswelding@gmail.com",null,1300.0,"$100 storage fee ",10.0,20.0,15.0,"5th ","NA",1300.0,-1000.0,1300.0]
["9720 Hildebrandt #9",null,"Robert Goldbach ",null,null,null,1100.0,null,10.0,20.0,15.0,"15th",-1100.0,null,300.0,-1100.0,null,"might not pay"]
["9720 Hildebrandt #10",null,"Brian Seals","210-909-7089",null,null,450.0,"Lot payment ",10.0,20.0,15.0,"10th ",450.0,450.0,450.0,450.0,450.0]
["9720 Hildebrandt #11",null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9720 Hildebrandt #12 ",null,"STORAGE ",{"$nulls":5},10.0,20.0,15.0]
["9720 Hildebrandt #13","TEX 011075","Camron Sutton ","210-975-7591",null,null,1100.0,null,10.0,20.0,15.0,"15th ",1070.0,550.0,550.0,-1240.0,-1100.0]
["9720 Hildebrandt #14",null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9720 Hildebrandt #15",null,"Reina Casas ","915-497-7796","Reinacasas13@gmail.com",null,1000.0,null,10.0,20.0,15.0,"22nd","Na","Na","Na",1000.0]
["9720 Hildebrandt #16",null,"Available ",null,null,null,1000.0,null,10.0,20.0,15.0,"10th","NA","NA",1000.0,"NA"]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9673 S Foster Rd ","NTA 488383","Rocky & Amy ","830-580-5550 ","angelmartinez277@gmail.com",null,1000.0,null,10.0,20.0,15.0,"15th ",1200.0,1200.0,300.0,1000.0]
["9669 S Foster Rd ",null,"Jesse Lopez ","210-762-8336",null,null,1300.0,null,10.0,20.0,15.0,"1st",1300.0,1300.0,1300.0,1300.0,1300.0]
["9665 S Foster Rd ","TEX 176926","Francis Quintanilla","210-504-4258","Fnq8569@gmail.com",null,1300.0,null,10.0,20.0,15.0,"1st",1300.0,1300.0,1300.0,1274.0,1300.0]
["9661 S Foster Rd",null,"Christopher Valle","210-762-8315",null,null,1300.0,null,10.0,20.0,15.0,null,"NA",1300.0,1300.0,1300.0,1300.0]
["9657 S Foster Rd ","TEX 529834","Chris Price ","210-842-4088","Mrsprice57@yahoo.com",null,1200.0,null,10.0,20.0,15.0,"15th",1200.0,1200.0,1200.0,600.0,600.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9641 S Foster Rd ","NTA 1991059","Jessica Whithey","210-809-7853","giggles_monkey04@yahoo.com",null,450.0,"Lot payment ",10.0,20.0,15.0,"1st",450.0,450.0,450.0,450.0,450.0]
["9637 S Foster Rd ",null,"Liliana Baker ",null,null,null,1200.0,null,10.0,20.0,15.0,"15th","NA",-1200.0,"EVICTED","NA",1200.0]
["9617 S Foster Rd ",null,"Rick Koenig","830-214-5604",null,null,900.0,null,10.0,20.0,15.0,"1st",900.0,900.0,600.0,900.0]
["9625 S Foster Rd ",null,"Fidelia Muniz ",null,null,null,425.0,null,10.0,20.0,15.0,"10th ",425.0,425.0,425.0,425.0,450.0]
["9629 S Foster Rd",null,"Johnny Barnes ","210-589-3744","libbybarnes86@gmail.com",null,450.0,"Lot payment ",10.0,20.0,15.0,"1st ",450.0,450.0,450.0,450.0,250.0]
["9633 S Foster Rd ",null,"Manuel Contreras",null,null,null,450.0,"Lot payment ",10.0,20.0,15.0,"15th ",450.0,450.0,450.0,450.0]
["9615 S Foster Rd",null,"Grace Chapa ","726-239-1535",null,null,900.0,null,10.0,20.0,10.0,"15th",900.0,900.0,950.0,950.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
[null,null,"EMPTY ",{"$nulls":5},10.0,20.0,15.0]
["9587 S Foster Rd ","TEX 299851","Julie Thomson","726-246-1761",null,null,1400.0,null,10.0,20.0,15.0,"15th",1400.0,1400.0,1000.0,null,null,"might not pay"]
["9581 S Foster Rd ",null,"Xavier Flores",null,null,null,1000.0,null,10.0,20.0,15.0,"15th",1000.0,1000.0,1000.0,null,null,"might not pay"]
["GROSS INCOME ",{"$nulls":5},{"$f":"SUM(G4:G46)","v":29725},null,350.0,700.0,525.0,null,{"$f":"SUM(M4:M46)","v":19995},22875,22475,{"$f":"SUM(P2:P46)","v":19659},12500]
["Purple = Needs Unit Replacement/Reno"]
["Orange = Septic Replacement/Repair is needed",null,null,null,"Expenses "]
["RENT READY",{"$nulls":4},3300.0,"Taxes "]
["Leased- these are the lease agreement amounts",{"$nulls":4},850.0,"Lawn "]
["actually collected rents-true numbers",{"$nulls":4},"NA ","Insurance "]
["charged back to the tenants",{"$nulls":4},740.0,"Garbage (billed back to tenants starting January 2026) "]
["still owes money",{"$nulls":4},350.0,"Tech (billed back to tenants starting January 2026)"]
[{"$nulls":5},2750.0,"Water Bill(Billed back to tenants)"]
[{"$nulls":5},"300/pump","Septic ","only when tanks are emptied"]
[]
[{"$nulls":4},"Total",4150.0]
[]
[{"$nulls":4},"Projected Gross income",29725.0]
[{"$nulls":4},"Expenses",-4150.0]
[{"$nulls":4},"Projected net",{"$f":"SUM(F60:F61)","v":25575}]

{"sheet":"Expenses","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Projected Expenses ",null,"Oct","Nov","Dec"]
["Taxes ",-3300.0]
["Lawn ",-850.0,"contract ends June 2026"]
[]
["Total",{"$f":"SUM(B2:B4)","v":-4150}]
[]
["Gross Income ",29725.0]
[null,{"$f":"SUM(B2:B4)","v":-4150}]
["Projected Net ",{"$f":"SUM(B7:B8)","v":25575}]

{"sheet":"Water Bill (Monthly)","index":2,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Address ",{"$nulls":4},"August ","September ","October ","November ","December ","January '26 ","February '26","March '26","April '26","May '26","June '26","July '26"]
["9690 Hildebrandt #1","EMPTY ",null,null,null,"NA"]
["9690 Hildebrandt #2","EMPTY ",null,null,null,"NA "]
["9690 Hildebrandt #3","Ariel Salas ","210-668-7364",null,null,62.79,47.86,43.6,37.19]
["9690 Hildebrandt #4","Delilah Robinson","915-216-4808","Delilarobinson27@gmail.com",null,54.26,49.99,54.26,60.65]
["9690 Hildebrandt #5","Petra Uballe","210-765-6423","petrauballe17@gmail.com",null,45.72,43.79,56.39,43.6]
["9690 Hildebrandt #7","Leo Neal",null,null,null,116.11,56.12,43.59,45.67]
[null,"EMPTY "]
[null,"EMPTY"]
["9690 Hildebrandt #9","Krystal Martinez","210-762-2511",null,null,"NA","NA",45.73,54.0]
["9720 Hildebrandt #1","Stacie Arnson","210-847-6894","jazzedu@gmail.com",null,69.19,64.92,69.19,54.25]
["9720 Hildebrandt #2","Available soon "]
["9720 Hildebrandt #3 ","Amanda Villarreal ","210-452-5388",null,null,"NA",50.0,94.79,148.27]
["9720 Hildebrandt #4","Cipriano Gomez ",null,null,null,77.72,86.25,84.12,92.69]
["9720 Hildebrandt #6","EMPTY "]
["9720 Hildebrandt #7","Isabel Suarez ","210-636-7724",null,null,28.66,37.22,52.05,41.32]
["9720 Hildebrandt #8","Juan Sanchez ","726-233-9290","Timelesswelding@gmail.com",null,45.72,59.79,47.86,49.73]
["9720 Hildebrandt #9","Robert Goldbach ",null,null,null,58.52,56.39,69.19,65.73]
["9720 Hildebrandt #10","Brian Seals","210-909-7089",null,null,30.79,30.79,32.93,32.93]
["9720 Hildebrandt #11","EMPTY "]
["9720 Hildebrandt #12 ","STORAGE "]
["9720 Hildebrandt #13","Camron Sutton ","210-975-7591",null,null,71.32,58.52,62.79,71.33]
["9720 Hildebrandt #14","EMPTY "]
["9720 Hildebrandt #15","Available "]
["9720 Hildebrandt #16"]
[null,"EMPTY "]
[null,"EMPTY "]
["9673 S Foster Rd ","Rocky & Amy ","830-580-5550 ","angelmartinez277@gmail.com",null,107.31,137.18,85.99,83.45]
["9669 S Foster Rd ","Jesse Lopez ","210-762-8336",null,null,85.98,51.86,60.39,56.15]
["9665 S Foster Rd ","Francis Quintanilla","210-504-4258","Fnq8569@gmail.com",null,90.25,75.32,58.26,37.6]
["9661 S Foster Rd","Christopher Valle","210-762-8315",null,null,41.46,45.46,56.13,51.87]
["9657 S Foster Rd ","Chris Price ","210-842-4088","Mrsprice57@yahoo.com",null,83.85,77.45,68.93,49.67]
[null,"EMPTY "]
[null,"EMPTY "]
[null,"EMPTY "]
["9641 S Foster Rd ","Jessica Whithey","210-809-7853","giggles_monkey04@yahoo.com",null,88.12,92.38,90.25,98.78]
["9637 S Foster Rd "]
["9617 S Foster Rd ","Ricky Koenig","830-214-5604",null,null,73.19,85.89,77.46,73.2]
["9625 S Foster Rd ","Fidelia Muniz ",null,null,null,66.79,64.65,64.66,62.54]
["9629 S Foster Rd","Johnny Barnes ","210-589-3744","libbybarnes86@gmail.com",null,83.85,66.79,117.98,63.0]
["9633 S Foster Rd ","Manuel Contreras",null,null,null,47.59,34.79,54.0,53.99]
["9615 S Foster Rd","Grace Chapa ","726-239-1535",null,null,34.79,36.93,38.37,35.07]
[null,"EMPTY "]
[null,"EMPTY "]
["9587 S Foster Rd ","Julie Thomson","726-246-1761",null,null,35.45,34.86,56.05,74.5]
["9581 S Foster Rd ","Xavier Flores",null,null,null,41.85,44.34,56.05,74.5]
["TOTAL",{"$nulls":4},{"$f":"SUM(F4:F46)","v":1541.28},{"$f":"SUM(G2:H46)","v":3130.55},{"$f":"SUM(H4:H46)","v":1641.01},1611.68]
["Unpaid by tenants",{"$nulls":4},0.0,0.0,0.0,0.0]
[{"$nulls":5},{"$f":"SUM(F47:F48)","v":1541.28},3130.55,1641.01,1611.68]

{"sheet":"T12","index":3,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Income",null,"August","September","October","November","December","January","February","March","April","May","June","July","Total"]
["Rental Income",null,19995.0,22875.0,22475.0,19659.0,12500.0]
[null,"Tech Services fee",290.0,290.0,290.0,290.0,290.0]
[null,"Total",{"$f":"SUM(C2:C3)","v":20285},23165,22765,19949,12790]
[]
["Expense"]
[null,"Lawn",-850.0,-850.0,-850.0,-850.0,-850.0]
[null,"Garbage",-740.0,-740.0,-740.0,-740.0,-740.0]
[null,"Property Taxes",-3300.0,-3300.0,-3300.0,-3300.0,-3300.0]
[null,"Unpaid Tech (tenant)"]
[null,"Unpaid water (tenant)"]
[null,"Unpaid Garbage (tenant)"]
["Total",null,{"$f":"SUM(C7:C12)","v":-4890},-4890,-4890,-4890,-4890]
[]
["Net Income",null,{"$f":"C4+C13","v":15395},18275,17875,15059,7900]