{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Portfolio Analysis "],"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":"Portfolio Analysis ","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Unit Mix","Actual","Pro Forma Rents"]
[null,"24x 3 Bed 2 Bath (Station) ",{"$f":"975*24*12","v":280800},{"$f":"1000*24*12","v":288000}]
[null,"16x 1 Bed 1 Bath (Station)",{"$f":"750*16*12","v":144000},{"$f":"775*16*12","v":148800}]
[null,"11x 3 Bed 2.5 Bath (Campus) ",{"$f":"1000*11*12","v":132000},{"$f":"1100*11*12","v":145200}]
[null,"24 Studios (Campus)",{"$f":"650*24*12","v":187200},{"$f":"700*24*12","v":201600}]
[null,"Total",{"$f":"SUM(C3:C6)","v":744000},{"$f":"SUM(D3:D6)","v":783600}]
[]
[null,null,"Actual ","Pro Forma"]
[null,"Gross Income",{"$f":"55625*12+48000","v":715500},{"$f":"D7","v":783600}]
[null,"HOA Income",{"$f":"2216*12","v":26592},38064]
[null,"Laundry Income",5199,{"$f":"C12","v":5199}]
[null,"Pet Fees",3525,{"$f":"C13","v":3525}]
[null,"Forfeited Deposits",4778,{"$f":"C14","v":4778}]
[null,"Other Income ",625,{"$f":"C15","v":625}]
[null,"Total Income",{"$f":"SUM(C10:C15)","v":756219},{"$f":"SUM(D10:D15)","v":835791}]
[]
[null,"Taxes",{"$f":"18392+29489","v":47881},{"$f":"C18","v":47881}]
[null,"Insurance",{"$f":"3232.44*12","v":38789.279999999999},38789.279999999999]
[null,"Water and Sewer",34465,34465]
[null,"Vacancy ",{"$f":"C10*0.025","v":17887.5},{"$f":"D10*0.025","v":19590}]
[null,"Internet",38064,{"$f":"C22","v":38064}]
[null,"Trash",6832,6832]
[null,"Electric",2901,2901]
[null,"Maintenance",{"$f":"C10*0.02","v":14310},{"$f":"D10*0.02","v":15672}]
[null,"MGMT",{"$f":"C10*0.085","v":60817.500000000007},{"$f":"D10*0.085","v":66606}]
[null,"Total Expenses",{"$f":"SUM(C18:C26)","v":261947.28},{"$f":"SUM(D18:D26)","v":270800.28000000003}]
[]
[null,"NOI",{"$f":"C16-C27","v":494271.72},{"$f":"D16-D27","v":564990.71999999997}]
[null,"CAP Rate",{"$f":"C29/C31","v":6.8175409655172409E-2},7.7929754482758615E-2]
[null,"Sale Price",7250000,7250000]