{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["123 N LUMBER","128 N 8TH"],"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":"123 N LUMBER","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"123 North Lumber- Final Proforma"]
[]
["Basement","Unit 0","1Bed/w Den 1600 sq feet",2200]
["Floor 1","1A","1 Bed/w Den 1090 sq feet",1525]
[null,"1C","1Bed 805 sq feet",1650]
[null,"1D","1 Bed/w Den 915 sq feet",1600]
[null,"1E","1 Bed/w Den 1,083 sq feet",1650]
["Floor 2","2A","studio 500 sq feet",1350]
[null,"2B","1 Bed 685 sq feet",1500]
[null,"2C","1 Bed/w Den 804 sq feet",1600]
[null,"2D","1 Bed/w Den 915 sq feet",1600]
[null,"2E","1 Bed/w den 1085 sq feet",1732]
["Floor 3","3A","studio 500 sq feet",1325]
[null,"3B","1 Bed 685 sq feet",1450]
[null,"3C","1 Bed/w Den 804 sq feet",1730]
[null,"3D","1 Bed/w Den 915 sq feet",1695]
[null,"3E","1 Bed/w Den 1,083 sq feet",1700]
["Floor 4","4A","studio 500 sq feet",1300]
[null,"4B","1 Bed 685 sq feet",1550,null,null,null,"Total"]
[null,"4C","1 Bed/w Den 804 sq feet",1575,null,null,"Pet Fees",12000,"TOTAL FOR AL PARCELS PER YEAR"]
[null,"4D","1 Bed/w Den 915 sq feet",1627,null,null,"Parking fee ",12000,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"4E","1 Bed/w Den 1,083 sq feet",1650,null,null,"Storage Fees",4560,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,null,"Total Rent",{"$f":"SUM(D4:D23)","v":32009},null,null,null,28560]
[]
[null,"Description (All Figures are Annual)",{"$nulls":6},"Annual\nAmount",null,"Notes"]
[null,"POTENTIAL RENTAL INCOME",{"$nulls":6},701880,null,"100% OCCUPIED"]
[null,"Less: Vacancy"]
[null,"EFFECTIVE RENTAL INCOME",{"$nulls":6},701880]
[null,"Plus: Other Income",{"$nulls":6},28560,null,"PARKING, PET FEES, STORAGE"]
[null,"GROSS OPERATING INCOME",{"$nulls":6},{"$f":"I29+I30","v":730440},null,"Total Revenue"]
[]
[null,"OPERATING EXPENSES"]
[null,"Real Estate Taxes",{"$nulls":5},94290,"TOTAL FOR ALL PARCELS PER YEAR",null,"Property Taxes"]
[null,"Personal Property Taxes"]
[null,"Property Insurance",{"$nulls":5},31300,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Off Site Management",{"$nulls":5},13200,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Payroll"]
[null,"Expenses/Benefits"]
[null,"Taxes/Worker's Compensation"]
[null,"Repairs and Maintenance",{"$nulls":5},2000,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Utilities",{"$nulls":5},17500,"TOTAL FOR ALL PARCELS PER YEAR",null,"ELECTRIC, WATER/SEWAGE/TRASH, ELEVATOR FEES"]
[null,"Accounting and Legal",{"$nulls":5},1500,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Licenses/Permits",{"$nulls":5},1850,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Advertising"]
[null,"Supplies",{"$nulls":5},1500,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Lawn and Grounds Keeping"]
[null,"Off Site Parking "]
[]
[]
[]
[null,"TOTAL OPERATING EXPENSES",{"$nulls":6},163140]
[null,"NET OPERATING INCOME",{"$nulls":6},{"$f":"I31-I52","v":567300}]
[null,"Less: Annual Debt Service"]
[null,"CASH FLOW BEFORE TAXES",{"$nulls":6},{"$f":"SUM(I53:I54)","v":567300}]
[null,"Add Back:  Principal Payments"]
[null,"- Depreciation"]
[null,"TAXABLE NET INCOME (LOSS)",{"$nulls":6},{"$f":"I55+I56+I57","v":567300}]

{"sheet":"128 N 8TH","index":1,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"123 N 8th Street- Final Proforma"]
[]
["Floor 1","Comm","Commercial sp/2200 SF",2000]
["Floor 2","2A","900 SF LOFT",1425]
[null,"2B","1200 SF LOFT",1425]
[null,"2C","1200 SF LOFT",1450,"vacant"]
[null,"2D","1000 SF LOFT",1325]
[null,"2E","1500 SF LOFT",1550]
["FLOOR 3","3A","1500 SF LOFT",1538]
[null,"3B","1200 SF LOFT",1627]
[null,"3C","1200 SF LOFT",1550]
[null,"3D","1000 SF LOFT",1300]
[null,"3E","1500 SF LOFT",1700]
["FLOOR 4","4A","1500 SF LOFT",1260]
[null,"4B","1200 SF LOFT",1500,null,null,"TOTAL"]
[null,"4C","1200 SF LOFT",1451,null,"PET FEES",12000,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"4D","1000 SF LOFT",1340,null,"PARKING FEE",12000,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"4E","1500 SF LOFT",1650,null,"STORAGE FEE",4560,"TOTAL FOR ALL PARCELS PER YEAR"]
["FLOOR 5","5A","PENTHOUSE 3400 SF",2750,null,null,28560]
[null,null,"Total Rent",{"$f":"SUM(D4:D20)","v":26841}]
[]
[null,"Description (All Figures are Annual)",{"$nulls":6},"Annual\nAmount",null,"Notes"]
[null,"POTENTIAL RENTAL INCOME",{"$nulls":6},701880,null,"100% OCCUPIED"]
[null,"Less: Vacancy"]
[null,"EFFECTIVE RENTAL INCOME",{"$nulls":6},701880]
[null,"Plus: Other Income",{"$nulls":6},28560,null,"PARKING, PET FEES, STORAGE"]
[null,"GROSS OPERATING INCOME",{"$nulls":6},{"$f":"I26+I27","v":730440},null,"Total Revenue"]
[]
[null,"OPERATING EXPENSES"]
[null,"Real Estate Taxes",{"$nulls":5},94290,"TOTAL FOR ALL PARCELS PER YEAR",null,"PROPERTY TAXES"]
[null,"Personal Property Taxes"]
[null,"Property Insurance",{"$nulls":5},31300,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Off Site Management",{"$nulls":5},13200,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Payroll"]
[null,"Expenses/Benefits"]
[null,"Taxes/Worker's Compensation"]
[null,"Repairs and Maintenance",{"$nulls":5},2000,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Utilities",{"$nulls":5},17500,"TOTAL FOR ALL PARCELS PER YEAR",null,"ELECTRIC, WATER/SEWAGE/TRASH, ELEVATOR FEES"]
[null,"Accounting and Legal",{"$nulls":5},1500,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Licenses/Permits",{"$nulls":5},1850,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Advertising",{"$nulls":5},0]
[null,"Supplies",{"$nulls":5},1500,"TOTAL FOR ALL PARCELS PER YEAR"]
[null,"Lawn and Grounds Keeping"]
[null,"Off Site Parking "]
[]
[]
[]
[null,"TOTAL OPERATING EXPENSES",{"$nulls":6},{"$f":"SUM(H31:H48)","v":163140}]
[null,"NET OPERATING INCOME",{"$nulls":6},{"$f":"I28-I49","v":567300}]
[null,"Less: Annual Debt Service"]
[null,"CASH FLOW BEFORE TAXES",{"$nulls":6},{"$f":"SUM(I50:I51)","v":567300}]
[null,"Add Back:  Principal Payments"]
[null,"- Depreciation"]
[null,"TAXABLE NET INCOME (LOSS)",{"$nulls":6},{"$f":"I52+I53+I54","v":567300}]