{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cap. Rate","Summary"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"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":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[18,1,18,2],[21,1,21,2],[17,1,17,2],[20,1,20,2],[14,0,16,0],[15,1,15,2],[16,1,16,2],[2,1,2,2],[5,1,5,3],[11,1,11,2],[14,1,14,2],[12,1,12,2],[13,1,13,2]]}
[]
[]
[null,"Owner's Name:",null,null,null,"Market Cap. Rate:"]
[null,null,null,null,null,"Value:",{"$f":"IFERROR((D23/G3),\"\")","v":""}]
[]
[null,"Property Address:",null,null,null,"Asking Price:"]
[null,null,null,null,null,"Cap. Rate:",{"$f":"IF(G6=\"\",\"\",(D23/G6))","v":""}]
[null,"Beds:","Baths:","Sq. Feet:"]
[]
[null,"Rent:"]
[null,null,null,null,null,"Cap. Rate:","Purchase Price:"]
[null,"Condition:",null,null,null,5.5E-2,{"$f":"IF($C$10=\"\",\"\",($D$23/F12))","v":""}]
[null,"Property Taxes:",null,null,null,0.06,{"$f":"IF($C$10=\"\",\"\",($D$23/F13))","v":""}]
[null,"Insurance:",null,null,null,6.5000000000000002E-2,""]
["Monthly","Maintenance:",null,{"$f":"IF(D12=\"\",\"\",(((VLOOKUP(D12,I32:J35,2,FALSE)))*D9))","v":""},null,7.0000000000000007E-2,"",null,null,null,null,1,1]
[null,"Management Fee:",null,null,{"$f":"C10*D16","v":0},7.4999999999999997E-2,"",null,null,null,null,2,1.25]
[null,"Utilities:",null,null,null,0.08,"",null,null,null,"Utah County",3,1.5]
[null,"Operating Expenses ($):",null,{"$f":"SUM(D13/12,D14/12,D15,(D16*C10),D17)","v":0},null,8.5000000000000006E-2,"",null,null,null,"Salt Lake County",4,1.75]
[null,"NOI",null,{"$f":"C10-D18","v":0},null,0.09,"",null,null,null,null,5,2]
[null,null,null,null,null,9.5000000000000001E-2,"",null,null,null,null,6,2.25]
[null,"Annual EGI:",null,{"$f":"C10*12","v":0},null,0.1,"",null,null,null,null,7,2.5]
[null,"Est. Annual Expenses:",null,{"$f":"D18*12","v":0},null,null,null,null,null,null,null,8,2.75]
[null,"Annual NOI:",null,{"$f":"D21-D22","v":0},null,null,null,null,null,null,null,9,3]
[null,null,null,null,null,null,null,null,null,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,null,null,{"$f":"(D15+E16+D17)*12","v":{"$error":"#VALUE!"}},null,3.75]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K26+D13+D14","v":{"$error":"#VALUE!"}},null,4]
[null,null,null,null,null,null,null,null,{"$f":"K29-K27","v":{"$error":"#VALUE!"}},null,null,null,4.25]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C10*12","v":0},null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,4.75]
[null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,"New",1.1111111111111112E-2,null,null,5.25]
[null,null,null,null,null,null,null,null,"Good",1.7777777777777778E-2,null,null,5.5]
[null,null,null,null,null,null,null,null,"Fair",2.6666666666666668E-2,null,null,5.75]
[null,null,null,null,null,null,null,null,"Poor",4.4444444444444446E-2,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,6.25]
[null,null,null,null,null,null,null,null,null,null,null,null,6.5]
[null,null,null,null,null,null,null,null,null,null,null,null,6.75]
[null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,7.25]
[null,null,null,null,null,null,null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,7.75]
[null,null,null,null,null,null,null,null,null,null,null,null,8]

{"sheet":"Summary","index":1,"n_rows":31,"n_cols":14,"rows_kept":31,"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'!G4","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Market  Cap. Rate",{"$f":"'Cap. Rate'!G3","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"New Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Change"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Rent:",{"$f":"'Cap. Rate'!C10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Management:",{"$f":"'Cap. Rate'!D18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Maintenance:",{"$f":"'Cap. Rate'!D19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Utilities:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Change in Other:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Owner's Name",{"$f":"IF(('Cap. Rate'!B4)=0,\"\",('Cap. Rate'!B4))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Address",{"$f":"IF(('Cap. Rate'!B7)=0,\"\",('Cap. Rate'!B7))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap. Rate'!D21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap. Rate'!D22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Cap. Rate'!D23","v":0}]