{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet1","index":0,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[[18,1,18,3],[24,0,24,3],[40,1,40,3],[46,0,46,2]]}
["Current Rent:",null,{"$f":"((B1*(1-B4))-B9)*12","v":0},"annual w/loan"]
["Original Rent:"]
["Rent increase per year (%)",null,{"$f":"(B1*(1-B4))*12","v":0},{"$f":"IF(B17>B7,C3,C1)","v":0},{"$f":"ABS((FV(B3,(C18),0,D3,0)))","v":0}]
["Expenses (% of Rent)",null,{"$f":"CONCATENATE((TEXT((B1*B4),\"$#,##0.00\")),\" per month\")","v":"$0.00 per month"},null,{"$f":"FV(B3,C18,0,-C3,0)","v":0}]
[]
["Original Loan Amount:",null,null,{"$f":"IF(B17>B7,B6,(ABS(CUMPRINC(B8/12,B7*12,B6,1,B17*12,0))))","v":{"$error":"#NUM!"}},{"$f":"IF(C17>B7,B6,(ABS(CUMPRINC(B8/12,B7*12,B6,1,C17*12,0))))","v":{"$error":"#NUM!"}}]
["Duration:",null,"years"]
["Interest Rate:"]
["Monthly Payment:",{"$f":"IF(ISERROR(IF(B6=\"\",0,(PMT(B8/12,B7*12,-B6,0,0))))=TRUE,0,(IF(B6=\"\",0,(PMT(B8/12,B7*12,-B6,0,0)))))","v":0}]
[]
["Cap. Rate:",null,null,{"$f":"C3/B11","v":{"$error":"#DIV/0!"}},{"$f":"E4/B11","v":{"$error":"#DIV/0!"}}]
["Inflation:"]
["Current Value:",{"$f":"IF(B11=\"\",\"\",(C3/B11))","v":""}]
["Take Home Value:",{"$f":"IF(C17=\"\",\"\",(B13-(B6-(IF(C17>B7,B6,(ABS((CUMPRINC(B8/12,B7*12,B6,1,(C17*12),0)))))))))","v":""}]
[]
[null,"Start Year (End of Year)","End Year (End of Year)"]
["Year:"]
[null,null,{"$f":"C17-B17","v":0}]
[null,"Future Gains From Current Investment"]
[null,null,"Cash Flow:"]
[null,null,"Equity Increase:",{"$f":"IF(ISERROR((E6-D6))=TRUE,\"\",(E6-D6))","v":""}]
[null,null,"Sale Value Increase:",{"$f":"IF(ISERROR(E11-D11)=TRUE,\"\",(E11-D11))","v":""}]
[null,null,"Total",{"$f":"SUM(D20:D22)","v":0}]
[null,null,"With Inflation",{"$f":"PV(B12,C18,0,-D23,0)","v":0}]
["New Investment"]
[]
["New Property Sale Price:"]
["Cap. Rate"]
["Expense % Rent:",null,{"$f":"(B31*(1-B29))*12","v":0},{"$f":"C29-(B38*12)","v":0},{"$f":"ABS((FV(B32,(C18),0,D29,0)))","v":0}]
["Needed Rent:",{"$f":"((B27*B28)/(1-B29))/12","v":0},null,null,{"$f":"ABS((FV(B32,(C18),0,C29,0)))","v":0}]
["Rent:"]
["Rent Increase:"]
[]
["Loan"]
["Loan Amount:",{"$f":"IF(B27=\"\",\"\",(IF(B14>=B27,0,(B27-B14))))","v":""}]
["Duration:"]
["Interest Rate:"]
["Monthly Payment:",{"$f":"IF(ISERROR(IF(B35=0,0,(IF(B35=\"\",0,(PMT(B37/12,B36*12,-B35,0,0))))))=TRUE,0,(IF(B35=0,0,(IF(B35=\"\",0,(PMT(B37/12,B36*12,-B35,0,0)))))))","v":0}]
["NOI:",{"$f":"IF(B31=\"\",\"\",(((B31*(1-B29))-B38)*12))","v":""}]
[null,null,null,{"$f":"B27","v":0},{"$f":"E30/B28","v":{"$error":"#DIV/0!"}}]
[null,"Potential Gains From New Investment "]
[null,null,"Cash Flow:"]
[null,null,"Equity Increase:",{"$f":"IF(ISERROR((IF(B36=\"\",\"\",(IF(C18>B36,B35,(ABS((CUMPRINC((B37/12),(B36*12),B35,1,(C18*12),0)))))))))=TRUE,\"\",(IF(B36=\"\",\"\",(IF(C18>B36,B35,(ABS((CUMPRINC((B37/12),(B36*12),B35,1,(C18*12),0)))))))))","v":""}]
[null,null,"Sale Value Increase:",{"$f":"IF(ISERROR(E40-D40)=TRUE,\"\",(E40-D40))","v":""}]
[null,null,"Total",{"$f":"SUM(D42:D44)","v":0}]
[null,null,"With Inflation",{"$f":"PV(B12,C18,0,-D45,0)","v":0}]
["Analysis"]
["Total Selling vs. Keeping Difference:",{"$f":"IF(B27=\"\",\"\",(D45-D23))","v":""},{"$f":"IF(B48=\"\",\"\",(CONCATENATE(\"(Over\",\" \",C18+1,\" \",\"years)\")))","v":""}]
["Per year Average:",{"$f":"IF(B48=\"\",\"\",(B48/(C18+1)))","v":""},"per year"]
["Selling vs. Keeping % Increase/Decrease:",{"$f":"IF(B27=\"\",\"\",(IF(ISERROR((D45-D23)/D23)=TRUE,\"\", ((D45-D23)/D23))))","v":""}]
["Recommendation:",{"$f":"IF(B27=\"\",\"\",(IF(B48<=1,\"Keep\",\"Sell\")))","v":""}]
["Why Sell?"]
[{"$f":"IF(B51=\"Sell\",(IF(B38<B9,\"Lower Loan Payment\",\"\")),\"\")","v":""}]
[{"$f":"IF(B51=\"Sell\",(IF(B31>B1,\"More Rent\",\"\")),\"\")","v":""}]
[{"$f":"IF(B51=\"Sell\",(IF(B29<B4,\"Less Expensive to Maintain\",\"\")),\"\")","v":""}]
[{"$f":"IF(B51=\"Sell\",(IF(B28<B11,\"Lower Cap. Rate Area\",\"\")),\"\")","v":""}]