{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cap. Rate","Summary"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"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":"Cap. Rate","index":0,"n_rows":51,"n_cols":22,"rows_kept":51,"cut":false,"hidden":false,"merged":[[32,11,33,11],[37,1,37,2],[43,1,43,2],[31,8,31,10],[39,1,39,2],[41,1,41,2],[40,1,40,2],[42,1,42,2],[38,1,38,2],[15,0,18,0],[41,0,44,0],[26,8,26,10],[1,0,1,6],[29,1,29,2],[32,1,32,3],[3,1,3,2],[6,1,6,3],[44,1,44,2]]}
[]
["Current Situation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,"Owner's Name:",null,null,null,"Market Cap. Rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[null,null,null,null,null,"Value:",{"$f":"IF(G4=\"\",\"\",(VLOOKUP(G4,F16:G25,2)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,"Property Address:",null,null,null,"Asking Price:",null,null,null,null,null,null,"Salt Lake County",null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,"Cap. Rate:",{"$f":"IF(ISERROR(D18/G7)=TRUE,\"\",(D18/G7))","v":""},null,null,null,null,null,"Utah County",null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,"Rent:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,"Operating Expenses (%):",null,null,null,"Cap. Rate:","Purchase Price:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]
[null,"Operating Expenses ($):",null,{"$f":"C10*D12","v":0},null,0.04,{"$f":"$D$18/F13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,"NOI",null,{"$f":"C10-D13","v":0},null,4.4999999999999998E-2,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,0.05,0,null,"New",1.2E-2,null,null,null,null,null,null,null,null,null,null,null,0.7]
[null,"Annual EGI:",null,{"$f":"C10*12","v":0},null,5.5E-2,0,null,"Good",1.7999999999999999E-2,null,1,1,null,null,null,null,null,null,null,null,0.75]
[null,"Est. Annual Expenses:",null,{"$f":"D13*12","v":0},null,0.06,0,null,"Fair",2.7E-2,null,2,1.25,null,null,null,null,null,null,null,null,0.8]
[null,"Annual NOI:",null,{"$f":"D16-D17","v":0},null,6.5000000000000002E-2,0,null,"Poor",4.7E-2,null,3,1.5]
[null,null,null,null,null,7.0000000000000007E-2,0,null,null,null,null,4,1.75]
[null,null,null,null,null,7.4999999999999997E-2,0,null,null,null,null,5,2]
[null,null,null,null,null,0.08,0,null,null,null,null,6,2.25]
[null,null,null,null,null,8.5000000000000006E-2,0,null,null,null,null,7,2.5]
[null,null,null,null,null,0.09,0]
[null,null,null,null,null,9.5000000000000001E-2,0]
[null,null,null,null,null,0.1,0,null,null,null,null,8,2.75]
[null,null,null,null,null,null,null,null,null,null,null,9,3]
["Recommended Scenario ",null,null,null,null,null,null,null,"Impact of Changes Made",null,null,10,3.25]
[null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,null,null,null,null,null,null,null,"Added Value",null,"Percent Increase/Decrease",null,3.75]
[null,"Owner's Name:",null,null,null,"Market Cap. Rate:",null,null,{"$f":"IF(G31=\"\",\"\",(G31-G5))","v":""},null,{"$f":"IF(I30=\"\",\"\",(I30/G5))","v":""},null,4]
[null,{"$f":"IF(B5=\"\",\"\",B5)","v":""},null,null,null,"Value:",{"$f":"IF(G30=\"\",\"\",(VLOOKUP(G30,F39:G48,2)))","v":""},null,null,null,null,null,4.25]
[null,null,null,null,null,null,null,null,"Changes Made:",null,null,null,4.5]
[null,"Property Address:",null,null,null,"Asking Price:",null,null,"Change in Rent:",null,{"$f":"IF((C36-C10)=0,\"None\",(IF(C36=\"\",\"\",(C36-C10))))","v":"None"},"Monthly",4.75]
[null,{"$f":"IF(B8=\"\",\"\",B8)","v":""},null,null,null,"Cap. Rate:",{"$f":"IF(ISERROR(D44/G33)=TRUE,\"\",(D44/G33))","v":""},null,"Change in Expenses:",null,{"$f":"CONCATENATE((TEXT((D39-D13),\"+ $#,##0;- $#,##0\")),\" \",\"or\",\" \",(TEXT((D38-D12),\"+ 0.00%_);- 0.00%\")))","v":"+ $0 or + 0.00% "},null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,5.25]
[null,"Rent:",null,null,null,null,null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,null,null,null,null,null,null,5.75]
[null,"Operating Expenses (%):",null,null,null,"Cap. Rate:","Purchase Price:",null,null,null,null,null,6]
[null,"Operating Expenses ($):",null,{"$f":"D38*C36","v":0},null,0.04,{"$f":"$D$44/F39","v":0},null,null,null,null,null,6.25]
[null,"NOI",null,{"$f":"C36-D39","v":0},null,4.4999999999999998E-2,0,null,null,null,null,null,6.5]
[null,null,null,null,null,0.05,0,null,null,null,null,null,6.75]
[null,"Annual EGI:",null,{"$f":"C36*12","v":0},null,5.5E-2,0,null,null,null,null,null,7]
[null,"Est. Annual Expenses:",null,{"$f":"D39*12","v":0},null,0.06,0,null,null,null,null,null,7.25]
[null,"Annual NOI:",null,{"$f":"D42-D43","v":0},null,6.5000000000000002E-2,0,null,null,null,null,null,7.5]
[null,null,null,null,null,7.0000000000000007E-2,0,null,null,null,null,null,7.75]
[null,null,null,null,null,7.4999999999999997E-2,0,null,null,null,null,null,8]
[null,null,null,null,null,0.08,0]
[null,null,null,null,null,8.5000000000000006E-2,0]
[null,null,null,null,null,0.09,0]
[null,null,null,null,null,9.5000000000000001E-2,0]
[null,null,null,null,null,0.1,0]

{"sheet":"Summary","index":1,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Agent's Name:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Company:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Email Address:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone Number:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mailing Address:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Web Site:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Notes:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Original Value",{"$f":"'Cap. Rate'!G5","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Market  Cap. Rate",{"$f":"'Cap. Rate'!G4","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"New Value",{"$f":"'Cap. Rate'!G31","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Difference",{"$f":"'Cap. Rate'!I30","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Change",{"$f":"'Cap. Rate'!K30","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Rent:",{"$f":"'Cap. Rate'!K33","v":"None"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Management:",{"$f":"'Cap. Rate'!K34","v":"+ $0 or + 0.00% "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Maintenance:",{"$f":"'Cap. Rate'!K35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Utilities:",{"$f":"'Cap. Rate'!K36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Other:",{"$f":"'Cap. Rate'!K37","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner's Name",{"$f":"IF(('Cap. Rate'!B5)=0,\"\",('Cap. Rate'!B5))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Address",{"$f":"IF(('Cap. Rate'!B8)=0,\"\",('Cap. Rate'!B8))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap. Rate'!C36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap. Rate'!D39","v":0}]