{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Actuals","Pro Forma","Cash on Cash","Rent Roll"],"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":"Actuals","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Fast Lane Industrial Complex"]
["Rents",null,"Monthly Rent",null,null,"Net Operating Income"]
["34 Units",null,"Actual",null,null,{"$f":"SUM(C13-D24)","v":213420.33000000002}]
["C Building - 11 units",null,5200]
["D Building - 11 Units",null,5753]
["E Building - 12 units ",null,7750]
["E Building - 2 Offices",null,2000,null,null,"Price"]
[{"$nulls":5},3200000]
["Utility Charge",null,365]
[{"$nulls":5},"Cap Rate *"]
[{"$nulls":5},{"$f":"SUM(F3/F8)","v":6.6693853125000008E-2}]
[null,null,{"$f":"SUM(C4:C11)","v":21068}]
["Total Rental Income",null,{"$f":"SUM(C12*12)","v":252816}]
["Annual Gross Rents"]
[]
["Expenses",null,null,"Yearly Amount"]
["Utility Charges Water, Septic, Road",null,null,10500]
["Property Taxes",null,null,18965.669999999998]
["Insurance",null,null,9250]
["Landscaping ",null,null,360]
["Pest Control",null,null,320]
[]
[]
["Total Expenses",null,null,{"$f":"SUM(D17:D23)","v":39395.67}]
[]
[]
[]
["Inclusions"]

{"sheet":"Pro Forma","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Fast Lane Industrial Complex"]
["Rents",null,"Monthly Rent",null,null,"Net Operating Income"]
["34 Units",null,"Actual",null,null,{"$f":"SUM(C12-D23)","v":247404.33000000002}]
["C Building - 11 units",null,6000]
["D Building - 11 Units",null,6000]
["E Building - 12 units plus 2 offices",null,8500,null,null,"Price"]
["E Building - 2 offices",null,2400,null,null,3200000]
["Utility Charge",null,1000]
[{"$nulls":5},"Cap Rate *"]
[{"$nulls":5},{"$f":"SUM(F3/F7)","v":7.7313853124999998E-2}]
[null,null,{"$f":"SUM(C4:C10)","v":23900}]
["Total Rental Income",null,{"$f":"SUM(C11*12)","v":286800}]
["Annual Gross Rents"]
[]
["Expenses",null,null,"Yearly Amount"]
["Utility Charges Water, Septic, Road",null,null,10500]
["Property Taxes",null,null,18965.669999999998]
["Insurance",null,null,9250]
["Landscaping ",null,null,360]
["Pest Control",null,null,320]
[]
[]
["Total Expenses",null,null,{"$f":"SUM(D16:D22)","v":39395.67}]
[]
[]
[]
["Inclusions"]
["12% rent increases"]

{"sheet":"Cash on Cash","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Cash on Cash Analysis"]
["Actual"]
["NOI",{"$f":"(Actuals!F3)","v":213420.33000000002}]
["Monthly Payment with loan terms:",15875]
[7.0000000000000007E-2]
["30 year Amort."]
["25% down"]
["Cash to purchase",{"$f":"'Pro Forma'!F7*0.25","v":800000}]
["Monthly Cash Flow",null,{"$f":"SUM(B3/12)-B4","v":1910.0275000000001}]
[null,null,null,"cash on cash return",{"$f":"SUM(C9*12)/(B8)","v":2.8650412500000003E-2}]
["Pro Forma"]
["NOI",{"$f":"('Pro Forma'!F3)","v":247404.33000000002}]
["Monthly Payment with loan terms:",{"$f":"B4","v":15875}]
[7.0000000000000007E-2]
["30 year Amort."]
["25% down"]
["Cash to purchase",{"$f":"'Pro Forma'!F7*0.25","v":800000}]
["Monthly Cash Flow",null,{"$f":"SUM(B12/12)-B13","v":4742.0275000000001}]
[null,null,null,"cash on cash return",{"$f":"SUM(C18*12)/(B17)","v":7.1130412500000004E-2}]

{"sheet":"Rent Roll","index":3,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["C Building",null,"Monthly Rent"]
[1,null,440]
[2,null,440]
[3,null,438]
[4,null,440]
[5,null,300]
[6,null,440]
[7,null,440]
[8,null,440]
[9,null,440]
[10,null,440]
[11,null,440]
["D Building"]
[1,null,687.5]
[2,null,687.5]
[3,null,816]
[4,null,816]
[5,null,816]
[6,null,816]
[7,null,750]
[8,null,750]
[9,null,816]
[10,null,650]
[11,null,1300,{"$nulls":12},"Actual","$14,317 with 6% seller financing"]
[12,null,1300,{"$nulls":13},3468,5.1999999999999998E-2]
[13,null,650]
[14,null,650]
["E Building"]
[1,null,1500]
[2,null,330]
[3,null,330]
[4,null,330]
[5,null,328]
[6,null,330]
[7,null,330]
[8,null,328]
[9,null,330]
[10,null,399]
[11,null,330]