{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Investment Analysis"],"not_rendered":{"charts":0,"images":1,"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":"Investment Analysis","index":0,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["150 E HOLT BLVD. ONTARIO, CA 91761"]
["Building Size:",null,58000,null,null,"Annual Rental Increase",null,0.02]
["Purchase Price:",null,23000000,{"$f":"C3/C2","v":396.55172413793105},null,"Annual OpEx Increase",null,0.02]
["Going In CAP Rate:",null,{"$f":"C29/C3","v":5.0098521739130437E-2}]
[]
[null,"Monthly","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
["Rental Income",{"$f":"C7/12","v":143087},1717044,{"$f":"C7*(1+$H$2)","v":1751384.8800000001},1786412.5776000002,1822140.8291520001,1858583.6457350401,1895755.3186497409,1933670.4250227357,1972343.8335231906,2011790.7101936545,2052026.5243975276]
[]
["Operating Expenses:"]
["New Property Taxes",{"$f":"C10/12","v":22233.333333333332},{"$f":"C3*1.16%","v":266800},{"$f":"C10*(1+$H$3)","v":272136},277578.72000000003,283130.29440000001,288792.900288,294568.75829376001,300460.1334596352,306469.33612882788,312598.72285140445,318850.69730843254]
["Insurance",1546.6666666666667,18560,{"$f":"C11*(1+$H$3)","v":18931.2},19309.824000000001,19696.020479999999,20089.940889599999,20491.739707392,20901.574501539839,21319.605991570636,21745.998111402048,22180.918073630091]
["Repairs & Maintenance",2791.6666666666665,33500,{"$f":"C12*(1+$H$3)","v":34170},34853.4,35550.468000000001,36261.477360000004,36986.706907200009,37726.441045344007,38480.969866250889,39250.589263575908,40035.601048847428]
["Janitorial Service",7047,84564,{"$f":"C13*(1+$H$3)","v":86255.28},87980.385599999994,89739.993311999991,91534.793178239997,93365.489041804802,95232.798822640892,97137.454799093714,99080.203895075596,101061.80797297711]
["Janitorial Supply",1554.1666666666667,18650,{"$f":"C14*(1+$H$3)","v":19023},19403.46,19791.529200000001,20187.359784,20591.10697968,21002.929119273602,21422.987701659073,21851.447455692254,22288.476404806101]
["Elevator Maint.",750,9000,{"$f":"C15*(1+$H$3)","v":9180},9363.6,9550.8720000000012,9741.8894400000008,9936.7272288000004,10135.461773376001,10338.171008843521,10544.934429020392,10755.8331176008]
["HVAC Maint.",2416.6666666666665,29000,{"$f":"C16*(1+$H$3)","v":29580},30171.600000000002,30775.032000000003,31390.532640000005,32018.343292800004,32658.710158656006,33311.884361829128,33978.122049065714,34657.684490047031]
["Fire Alarm & Security",65,780,{"$f":"C17*(1+$H$3)","v":795.6},811.51200000000006,827.74224000000004,844.29708480000011,861.18302649600014,878.40668702592018,895.9748207664386,913.89431718176741,932.17220352540278]
["Landscape Maint.",1175,14100,{"$f":"C18*(1+$H$3)","v":14382},14669.64,14963.032799999999,15262.293455999999,15567.53932512,15878.890111622401,16196.467913854849,16520.397272131948,16850.805217574587]
["Pest Control",64,768,{"$f":"C19*(1+$H$3)","v":783.36},799.02719999999999,815.007744,831.30789888000004,847.93405685760001,864.892737994752,882.19059275464701,899.83440460973998,917.83109270193484]
["Utilities"]
["Water/Sewer/Irrigation",{"$f":"C21/12","v":2458.3333333333335},29500,{"$f":"C21*(1+$H$3)","v":30090},30691.8,31305.635999999999,31931.74872,32570.3836944,33221.791368288003,33886.227195653766,34563.951739566844,35255.230774358184]
["Gas",{"$f":"C22/12","v":1000},12000,{"$f":"C22*(1+$H$3)","v":12240},12484.800000000001,12734.496000000001,12989.185920000002,13248.969638400002,13513.949031168002,13784.228011791361,14059.91257202719,14341.110823467734]
["Telephone/Internet",363,4356,{"$f":"C23*(1+$H$3)","v":4443.12},4531.9823999999999,4622.6220480000002,4715.0744889600001,4809.3759787392,4905.5634983139844,5003.6747682802643,5103.7482636458699,5205.8232289187872]
[]
["Management",{"$f":"C25/12","v":3600},43200,{"$f":"C25*(1+$H$3)","v":44064},44945.279999999999,45844.185599999997,46761.069312,47696.290698240002,48650.216512204803,49623.2208424489,50615.685259297876,51627.998964483835]
[]
["Total Expenses",{"$f":"C27/12","v":47064.833333333336},{"$f":"SUM(C10:C26)","v":564778},{"$f":"SUM(D10:D26)","v":576073.55999999994},587595.03120000008,599346.93182399997,611333.87046047987,623560.54786968965,636031.75882708351,648752.39400362503,661727.44188369776,674961.99072137161]
[]
["Net Operating Income",{"$f":"C29/12","v":96022.166666666672},{"$f":"C7-C27","v":1152266},{"$f":"D7-D27","v":1175311.3200000003},1198817.5464000001,1222793.8973280001,1247249.7752745603,1272194.7707800511,1297638.6661956522,1323591.4395195656,1350063.2683099569,1377064.5336761558]
[]
["CAP Rate",null,{"$f":"C29/$C$3","v":5.0098521739130437E-2},5.1100492173913055E-2,5.2122502017391312E-2,5.3164952057739134E-2,5.4228251098893926E-2,5.5312816120871786E-2,5.6419072443289225E-2,5.7547453892155022E-2,5.8698402969998127E-2,5.9872371029398082E-2]