{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Seller Net Sheet","Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Seller Net Sheet","index":0,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,4,8,7],[19,3,19,5],[19,6,19,7],[15,2,15,7],[17,2,17,7],[11,4,11,7],[13,4,13,7]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Escrow Officer"]
[]
[]
[]
[null,"Listing Agent",null,"Phone"]
[]
[null,"Brokerage",null,"Email"]
[]
[null,"Seller"]
[]
[null,"Property Address"]
[]
[null,"Annual Taxes",null,"HOA/Condo Fees"]
[]
[null,"Est. Closing Date"]
[]
[]
[null,null,null,"SCENARIO 1",null,"SCENARIO 2",null,"SCENARIO 3"]
[null,null,"Sales Price"]
[null,null,"1st Mortgage Payoff"]
[null,null,"2nd Mortgage Payoff"]
[null,null,"Other Liens"]
[null,null,"% Commission"]
[null,null,"Listing Commission",{"$f":"IF(D26=\"\",\"\",D26*D30)","v":""},null,{"$f":"IF(F26=\"\",\"\",F26*F30)","v":""},null,{"$f":"IF(H26=\"\",\"\",H26*H30)","v":""}]
[null,null,"Other Fees"]
[null,null,"Prorated Taxes",{"$f":"IF(D26=\"\",\"\",(($C$20/((DATE(YEAR($C$22),12,31) - DATE(YEAR($C$22),1,1)) + 1))*($C$22-DATE(YEAR($C$22),1,1)+1)))","v":""},null,{"$f":"IF(F26=\"\",\"\",(($C$20/((DATE(YEAR($C$22),12,31) - DATE(YEAR($C$22),1,1)) + 1))*($C$22-DATE(YEAR($C$22),1,1)+1)))","v":""},null,{"$f":"IF(H26=\"\",\"\",(($C$20/((DATE(YEAR($C$22),12,31) - DATE(YEAR($C$22),1,1)) + 1))*($C$22-DATE(YEAR($C$22),1,1)+1)))","v":""}]
[null,null,"Prorated HOA/Condo Fees",{"$f":"G20/DAY(EOMONTH(C22,0))*DAY(C22)","v":0},null,{"$f":"G20/DAY(EOMONTH(C22,0))*DAY(C22)","v":0},null,{"$f":"G20/DAY(EOMONTH(C22,0))*DAY(C22)","v":0}]
[null,null,"Settlement/Closing Fee",350,null,350,null,350]
[null,null,"Doc Prep/Wire/Courier Fees",50,null,50,null,50]
[null,null,"Homeowner's Title Fee",{"$f":"IF(D26=\"\",\"\",ROUNDUP((IF(D26<10000,200,IF(D26<100000,200+(D26-10000)/10000*46.95,IF(D26<200000,622.55+(D26-100000)/10000*45,IF(D26<500000,1072.55+(D26-200000)/10000*36,IF(D26<2000000,2152.55+(D26-500000)/10000*18,IF(D26<5000000,4852.55+(D26-2000000)/10000*15.75,IF(D26<10000000,9577.55+(D26-5000000)/10000*13.5,IF(D26<50000000,16327.55+(D26-10000000)/10000*11.25,\"n/a\")))))))))*1.15,0))","v":""},null,{"$f":"IF(F26=\"\",\"\",ROUNDUP((IF(F26<10000,200,IF(F26<100000,200+(F26-10000)/10000*46.95,IF(F26<200000,622.55+(F26-100000)/10000*45,IF(F26<500000,1072.55+(F26-200000)/10000*36,IF(F26<2000000,2152.55+(F26-500000)/10000*18,IF(F26<5000000,4852.55+(F26-2000000)/10000*15.75,IF(F26<10000000,9577.55+(F26-5000000)/10000*13.5,IF(F26<50000000,16327.55+(F26-10000000)/10000*11.25,\"n/a\")))))))))*1.15,0))","v":""},null,{"$f":"IF(H26=\"\",\"\",ROUNDUP((IF(H26<10000,200,IF(H26<100000,200+(H26-10000)/10000*46.95,IF(H26<200000,622.55+(H26-100000)/10000*45,IF(H26<500000,1072.55+(H26-200000)/10000*36,IF(H26<2000000,2152.55+(H26-500000)/10000*18,IF(H26<5000000,4852.55+(H26-2000000)/10000*15.75,IF(H26<10000000,9577.55+(H26-5000000)/10000*13.5,IF(H26<50000000,16327.55+(H26-10000000)/10000*11.25,\"n/a\")))))))))*1.15,0))","v":""}]
[null,null,"Home Warranty"]
[null,null,"Utilities/Assessments"]
[null,null,"Seller Concessions"]
[null,null,"Other"]
[null,null,"Other"]
[null,null,"Miscellaneous 3"]
[]
[null,null,"Estimated Net to Seller",{"$f":"IF(D26=\"\",\"\",D26-(SUM(D27:D29)+SUM(D31:D41)))","v":""},null,{"$f":"IF(F26=\"\",\"\",F26-(SUM(F27:F29)+SUM(F31:F41)))","v":""},null,{"$f":"IF(H26=\"\",\"\",H26-(SUM(H27:H29)+SUM(H31:H41)))","v":""}]

{"sheet":"Data","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Column1","Escrow Officers"]
[1,"Andy Keys"]
[2,"Beau Pili"]
[3,"Brenda Christensen"]
[4,"Cassie Jackson"]
[5,"Chet Thomas"]
[6,"Debbie Hemingway"]
[7,"Jared Plewe"]
[8,"Kristina Twedt"]
[9,"Lori Sutton-Harrison"]
[10,"Marcy Reynolds"]
[11,"Mike Bennion"]
[12,"Mitch Montgomery"]
[13,"Nate Christensen"]
[14,"Patti Hess"]
[15,"Rick Smith"]
[16,"Rob Grim"]
[17,"Stephanie Ercanbreck"]
[18,"Zach Jones"]