{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Home","Pro Forma","Rent Roll"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Pro Forma","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,6],[26,2,26,4]]}
["Pro Forma Statement"]
[]
["INCOME",null,2018,2017,2016,2015,2014]
["Rental Income"]
[]
["Enter misc. income here eg. Laundry machines"]
["Enter misc. income here eg. Laundry machines"]
["Enter misc. income here eg. Laundry machines"]
[]
["Potential Gross Income",null,{"$f":"SUM(C4:C8)","v":0},{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(E4:E8)","v":0},{"$f":"SUM(F4:F8)","v":0},{"$f":"SUM(G4:G8)","v":0}]
["Vacancy Allowance",null,{"$f":"-SUM(C10)*$B$27","v":0},{"$f":"-SUM(D10)*$B$27","v":0},{"$f":"-SUM(E10)*$B$27","v":0},{"$f":"-SUM(F10)*$B$27","v":0},{"$f":"-SUM(G10)*$B$27","v":0}]
["Effective Gross Income",null,{"$f":"SUM(C10,C11)","v":0},{"$f":"SUM(D10,D11)","v":0},{"$f":"SUM(E10,E11)","v":0},{"$f":"SUM(F10,F11)","v":0},{"$f":"SUM(G10,G11)","v":0}]
[]
["OPERATING EXPENSES"]
["Enter operating expenses here eg. Property tax"]
["Enter operating expenses here eg. Advertising"]
["Enter operating expenses here eg. Advertising"]
["Enter operating expenses here eg. Advertising"]
["Enter operating expenses here eg. Advertising"]
["Enter operating expenses here eg. Advertising"]
["Enter operating expenses here eg. Advertising"]
["Enter operating expenses here eg. Advertising"]
["TOTAL OPERATING EXPENSES",null,{"$f":"SUM(C15:C22)","v":0},{"$f":"SUM(D15:D22)","v":0},0,0,0]
["NET OPERATING INCOME",null,{"$f":"C12-C23","v":0},{"$f":"D12-D23","v":0},{"$f":"E12-E23","v":0},{"$f":"F12-F23","v":0},{"$f":"G12-G23","v":0}]
[]
[]
["Vacancy Allowance Percentage",0,"<-- Enter vacancy allowance here"]

{"sheet":"Rent Roll","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,4],[20,0,20,1]]}
["RENT ROLL"]
["Suite No.","Suite Type","\nMonthly\nRent","Effective Lease Start Date (dd/mm/yy)","Date of\nLast Rental\nIncrease\n(dd/mm/yy)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C3:C18)","v":0}]
[null,null,"x 12"]
["Gross Annual Rental Income",null,{"$f":"C19*12","v":0}]