{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["About","Definitions","Internal","All Trans","Select Tools","Manual Select","Trans Selected","Statistics","Export Tools","Price to Annual Gross","Price to SDE","Multiples Analysis","Equity Value & Minority Int"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":110,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Price to Annual Gross","index":9,"reason":"not_a_worksheet"},{"sheet":"Price to SDE","index":10,"reason":"not_a_worksheet"}],"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":"About","index":0,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,1,6],[1,11,1,14],[38,1,39,10],[3,1,6,10],[9,1,9,10],[3,11,3,14],[25,1,27,10],[34,1,35,10],[12,1,13,10],[16,1,17,10],[20,1,22,10],[30,1,31,10]]}
["ABOUT the BIZCOMPS® Analyzer™"]
[null,null,null,null,null,null,null,null,null,null,null,"Learn More About BIZCOMPS Here"]
[]
[null,"The BIZCOMPS Analyzer was created to assist BIZCOMPS subscribers in analyzing transactions from the database. The Analyzer contains a worksheet that will allow you to select and deselect transactions in Excel, which will update all the summary statistics for your comparables, create scatter graphs using your selected comparables, and will provide regression equations and valuation multiples for use in analyzing your transactions. Below is a summary of the worksheets provided in this Excel workbook.",null,null,null,null,null,null,null,null,null,"Read the BIZCOMPS® FAQ Page Here"]
[]
[]
[]
[]
[null,"Definitions"]
[null,"This worksheet provides definitions for all the fields in the BIZCOMPS database."]
[]
[null,"All Trans"]
[null,"This worksheet contains all the transactions you exported from the website into Excel. If you need to make adjustments to selling prices or other transactional details, do so on this sheet."]
[]
[]
[null,"Select Tools"]
[null,"Use this worksheet to narrow down your selected comparables based on search parameters. Your selected comparables will appear on the  \"Manual Select\" and \"Trans Selected\" worksheets. You can always revisit this sheet and make revisions."]
[]
[]
[null,"Manual Select"]
[null,"Use this worksheet if you would like to manually select or deselect individual transactions based on criteria not included on the \"Select Tools\" worksheet. Your selected comparables will appear on the \"Trans Selected\" worksheet. You can always revisit this sheet and make revisions."]
[]
[]
[]
[null,"Trans Selected"]
[null,"This worksheet displays all the comparable transactions you have selected using the \"Select Tools\" worksheet and \"Manual Select\" worksheet. These will be the transactions that will be used to calculate your summary statistics, scatter graphs, regression equations, and valuation multiples."]
[]
[]
[]
[null,"Statistics"]
[null,"This worksheet will give you all your summary statistics for the transactions on your \"Trans Selected\" worksheet and your \"All Trans\" worksheet. You can always revisit the \"Select Tools\" worksheet and \"Manual Select\" worksheet to make revisions to your comparables."]
[]
[]
[null,"Scatter Graphs"]
[null,"This series of worksheets contain scatter graphs of your selected transactions that appear on your \"Trans Selected\" worksheet. These graphs may be helpful in identifying outliers. The graphs also contain regression equations for your comparables."]
[]
[]
[null,"Multiples Analysis"]
[null,"This worksheet calculates valuation multiples for your comparables that appear on the \"Trans Selected\" worksheet. This worksheet may serve as a sanity check for your valuation work, or another way to analyze the data."]
[]
[]
[]
[]
[]
[null,"Note: The BIZCOMPS Analyzer may not be compatible with Apple's iWorks Numbers or Microsoft Excel for Apple. "]

{"sheet":"Definitions","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,2,23,18],[24,2,24,18],[25,2,25,18],[0,0,1,6],[12,2,12,18],[18,2,18,18],[13,2,13,18],[22,2,22,18],[14,2,14,18],[15,2,15,18],[17,2,17,18],[21,2,21,18],[16,2,16,18],[11,2,11,18],[10,2,10,18],[20,2,20,18],[19,2,19,18],[9,2,9,18],[5,2,5,18],[4,1,4,18],[7,2,7,18],[6,2,6,18],[8,2,8,18]]}
["BIZCOMPS® Definitions"]
[]
[]
[]
[null,"Legend for BIZCOMPS® Transaction Details"]
[null,"Term","Definition"]
[null,"SIC","Standard Industrial Classification code"]
[null,"NAICS","North American Industry Classification System code"]
[null,"Business Description","Products and services of business"]
[null,"Annual Gross Sales","Annual Gross Sales ($000's), normally net of sales tax"]
[null,"Sale Date","Actual date of sale"]
[null,"SDE","Seller's discretionary earnings ($000's) is calculated by adding to the most recent full year’s Net Income Before Taxes (NIBT): Amortization, Depreciation, Interest, Owner’s compensation, Owner’s benefits, Non-business related expenses, and onetime-only expenses. Normally to one working owner"]
[null,"Sale Price","Actual sale price ($000's), inventory has been deducted if it was included in sale price"]
[null,"Ask Price","Asking sale price of business ($000's), does not include inventory"]
[null,"SDE/Annual Gross Sales","Seller’s discretionary earnings divided by Annual Gross Sales"]
[null,"Sale Price/Annual Gross Sales","Sale price divided by Annual Gross Sales"]
[null,"Sale Price/SDE","Sale price divided by seller's discretionary earnings"]
[null,"Percent Down","Down payment as a percent of sale price"]
[null,"Terms","Terms of primary new or assumed loan"]
[null,"Inventory Value","Inventory at the time of sale ($000's)"]
[null,"Furniture, Fixtures & Equipment (FFE)","Estimate of value of furniture, fixtures & equipment ($000's)"]
[null,"Rent/Annual Gross Sales","Yearly rent divided by Annual Gross Sales"]
[null,"Area","Region or geographical location of business"]
[null,"Days On Market","Actual number of days business was on market"]
[null,"Franchise Royalty","Actual royalty less advertising percentage"]
[null,"Number Of Employees","Number of employees"]

{"sheet":"Internal","index":2,"n_rows":128,"n_cols":16,"rows_kept":128,"cut":false,"hidden":true,"merged":[]}
["Transaction Selection",null,null,"Custom Criteria","Value","Min Value","Meets Min?","Max Value","Meets Max?","Meets Criteria?",null,"Available SIC:","5812",null,"Available NAICS:","722410"]
["Transaction ID",null,null,"SaleDate",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D2, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D2, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,{"$f":"IF($F2 = \"\", TRUE, IF($E2 = \"\", FALSE, $E2 >= $F2))","v":true},null,{"$f":"IF($H2 = \"\", TRUE, IF($E2 = \"\", FALSE, $E2 <= $H2))","v":true},{"$f":"AND($G2, $I2)","v":true},null,null,"5813",null,null,"722511"]
["Transaction Row (pre)",{"$f":"MATCH($B$2, 'All Trans'!$A:$A, 0)","v":{"$error":"#N/A"}},null,"SalePrice",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D3, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D3, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true,null,null,null,null,null,"722513"]
["Transaction Row (post)",{"$f":"IF(ISERROR($B$3), -1, $B$3)","v":-1},null,"AnnualGross",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D4, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D4, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true,null,null,null,null,null,"722515"]
["Criteria","All Transactions",null,"SDEToAnnualGross",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D5, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D5, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true]
["Meets Criteria",{"$f":"OFFSET(Criteria.Options, MATCH($B$5, Criteria.Options,0) - 1, 1, 1, 1)","v":false},null,"RentToAnnualGross",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D6, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D6, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true]
[null,null,null,"SDE",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D7, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D7, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true]
["Criteria Options","Meets Criteria?",null,"InventoryAmount",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D8, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D8, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true]
["All Transactions",{"$f":"$B$4 > 0","v":false},null,"FFE",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D9, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D9, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,true,null,true,true]
["Custom Criteria",{"$f":"IF(ISERROR(AND($J$2:$J$13)), FALSE, AND($J$2:$J$13) )","v":true}]
[null,null,null,null,null,"Match Value"]
[null,null,null,"SICCode",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D12, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D12, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF($F12 & $G12 & $H12 & $I12 = \"\", TRUE, IF($E12 = \"\", FALSE, OR(($E12 & \"\") = ($F12 & \"\"), ($E12 & \"\") = ($G12 & \"\"), ($E12 & \"\") = ($H12 & \"\"), ($E12 & \"\") = ($I12 & \"\"))))","v":true}]
[null,null,null,"NAICSCode",{"$f":"IF(OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D13, 'All Trans'!$1:$1, 0) - 1, 1, 1) = \"\", \"\", OFFSET('All Trans'!$A$1, $B$4 - 1, MATCH($D13, 'All Trans'!$1:$1, 0) - 1, 1, 1))","v":{"$error":"#REF!"}},null,null,null,null,true]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Weights","Multiples","YesNo","Percentages","MinorityPercentages"]
["N/A","N/A","Yes",0,"N/A"]
[1,"10th Percentile","No",0.01,0.01]
[2,"25th Percentile",null,0.02,0.02]
[3,"Median",null,0.03,0.03]
[4,"75th Percentile",null,0.04,0.04]
[5,"90th Percentile",null,0.05,0.05]
[null,"Harmonic Mean",null,0.06,0.06]
[null,"Mean",null,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,null,0.08,0.08]
[null,null,null,0.09,0.09]
[null,null,null,0.1,0.1]
[null,null,null,0.11,0.11]
[null,null,null,0.12,0.12]
[null,null,null,0.13,0.13]
[null,null,null,0.14000000000000001,0.14000000000000001]
[null,null,null,0.15,0.15]
[null,null,null,0.16,0.16]
[null,null,null,0.17,0.17]
[null,null,null,0.18,0.18]
[null,null,null,0.19,0.19]
[null,null,null,0.2,0.2]
[null,null,null,0.21,0.21]
[null,null,null,0.22,0.22]
[null,null,null,0.23,0.23]
[null,null,null,0.24,0.24]
[null,null,null,0.25,0.25]
[null,null,null,0.26,0.26]
[null,null,null,0.27,0.27]
[null,null,null,0.28000000000000003,0.28000000000000003]
[null,null,null,0.28999999999999998,0.28999999999999998]
[null,null,null,0.3,0.3]
[null,null,null,0.31,0.31]
[null,null,null,0.32,0.32]
[null,null,null,0.33,0.33]
[null,null,null,0.34,0.34]
[null,null,null,0.35,0.35]
[null,null,null,0.36,0.36]
[null,null,null,0.37,0.37]
[null,null,null,0.38,0.38]
[null,null,null,0.39,0.39]
[null,null,null,0.4,0.4]
[null,null,null,0.41,0.41]
[null,null,null,0.42,0.42]
[null,null,null,0.43,0.43]
[null,null,null,0.44,0.44]
[null,null,null,0.45,0.45]
[null,null,null,0.46,0.46]
[null,null,null,0.47,0.47]
[null,null,null,0.48,0.48]
[null,null,null,0.49,0.49]
[null,null,null,0.5,0.5]
[null,null,null,0.51,0.51]
[null,null,null,0.52,0.52]
[null,null,null,0.53,0.53]
[null,null,null,0.54,0.54]
[null,null,null,0.55000000000000004,0.55000000000000004]
[null,null,null,0.56000000000000005,0.56000000000000005]
[null,null,null,0.56999999999999995,0.56999999999999995]
[null,null,null,0.57999999999999996,0.57999999999999996]
[null,null,null,0.59,0.59]
[null,null,null,0.6,0.6]
[null,null,null,0.61,0.61]
[null,null,null,0.62,0.62]
[null,null,null,0.63,0.63]
[null,null,null,0.64,0.64]
[null,null,null,0.65,0.65]
[null,null,null,0.66,0.66]
[null,null,null,0.67,0.67]
[null,null,null,0.68]
[null,null,null,0.69]
[null,null,null,0.7]
[null,null,null,0.71]
[null,null,null,0.72]
[null,null,null,0.73]
[null,null,null,0.74]
[null,null,null,0.75]
[null,null,null,0.76]
[null,null,null,0.77]
[null,null,null,0.78]
[null,null,null,0.79]
[null,null,null,0.8]
[null,null,null,0.81]
[null,null,null,0.82]
[null,null,null,0.83]
[null,null,null,0.84]
[null,null,null,0.85]
[null,null,null,0.86]
[null,null,null,0.87]
[null,null,null,0.88]
[null,null,null,0.89]
[null,null,null,0.9]
[null,null,null,0.91]
[null,null,null,0.92]
[null,null,null,0.93]
[null,null,null,0.94]
[null,null,null,0.95]
[null,null,null,0.96]
[null,null,null,0.97]
[null,null,null,0.98]
[null,null,null,0.99]
[null,null,null,1]

{"sheet":"All Trans","index":3,"n_rows":136,"n_cols":24,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
["TransactionID","SICCode","SICCodeGeneral","NAICSGeneral","NAICSCode","BusinessDescription","Area","Country","AnnualGross","SaleDate","SDE","SalePrice","AskPrice","SDEtoAnnualGross","SalePriceToAnnualGross","SalePriceToSDE","PercentDown","Terms","InventoryAmount","FFE","RentToAnnualGross","DaysOnMarket","FranchiseRoyalty","NumberOfEmployees"]
[11351,{"$f":"TEXT(\"5812\",\"0000\")","v":"5812"},{"$f":"TEXT(\"58\",\"00\")","v":"58"},{"$f":"TEXT(\"722\",\"000\")","v":"722"},722513,"Fast Food-Burgers","Southeast","United States",2550,"2014-03-31",315,1300,1300,0.124,0.51,4.1269999999999998,null,null,13,null,null,null,"No"]
[10989,"5812","58","722",722513,"Fast Food-Burgers","South Atlantic","United States",2500,"2014-02-28",505,2200,2400,0.20200000000000001,0.88,4.3559999999999999,null,null,15,null,null,null,"No"]
[4033,"5812","58","722",722511,"Restr-Family","Florida","United States",2235,"2014-04-14",342,650,975,0.153,0.29099999999999998,1.901,1,null,0,50,null,120,"No",7]
[5394,"5812","58","722",722511,"Restr-Ethnic","Florida","United States",2190,"2014-05-05",413,492,642,0.189,0.22500000000000001,1.1910000000000001,0.2,"1 Yr @ 4%",8,89,null,65,"Y-5%",15]
[11659,"5812","58","722",722511,"Restr W/Cocktails","Texas","United States",1702,"2014-07-14",143,388,783,8.4000000000000005E-2,0.22800000000000001,2.7130000000000001,0.3,null,0,15,null,null,"No"]
[1059,"5812","58","722",722513,"Bakery-Restaurant","Colorado","United States",1588,"2014-02-28",247,500,500,0.156,0.315,2.024,0.48,null,25,100,null,150,"No",2]
[10765,"5812","58","722",722511,"Restr-Family","San Jose, CA","United States",1543,"2014-04-28",180,250,395,0.11700000000000001,0.16200000000000001,1.389,null,null,0,null,null,null,"No"]
[7403,"5812","58","722",722511,"Restr W/Cocktails","Houston, TX","United States",1527,"2014-12-05",356,700,750,0.23300000000000001,0.45800000000000002,1.966,null,null,0,359,null,null,"No","2 FT/10 PT"]
[8932,"5812","58","722",722511,"Restr-Family","New England","United States",1411,"2014-05-19",258,325,775,0.183,0.23,1.26,0.16,"20 Yrs @ 2%",11,259,null,36,"No","5 FT/3 PT"]
[3538,"5812","58","722",722511,"Restr-Italian","Florida","United States",1381,"2014-06-30",219,400,450,0.159,0.28999999999999998,1.8260000000000001,0.45,"5 Yrs @ 5%",1,80,null,null,"No",5]
[11837,"5812","58","722",722511,"Mexican Buffett","Tyler, TX","United States",1363,"2014-03-28",229,229,239,0.16800000000000001,0.16800000000000001,1,1,null,10,130,8.9999999999999993E-3,null,"No"]
[6513,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",1200,"2014-09-08",315,575,650,0.26300000000000001,0.47899999999999998,1.825,1,null,0,125,null,null,"No","1 FT/2 PT"]
[10692,"5812","58","722",722513,"Fast Food Cafe","San Francisco, CA","United States",1134,"2014-10-15",231,650,650,0.20399999999999999,0.57299999999999995,2.8140000000000001,0.3,null,0,null,0.05,null,"No"]
[4137,"5812","58","722",722511,"Restr-Family","Florida","United States",1100,"2014-07-07",150,345,384,0.13600000000000001,0.314,2.2999999999999998,1,null,15,50,null,292,"No",7]
[11035,"5812","58","722",722511,"Restr-Family","South Dakota","United States",1100,"2014-05-21",148,532,542,0.13500000000000001,0.48399999999999999,3.5950000000000002,null,"5.5 Yrs @ 5.5%",8,null,null,null,"No"]
[9321,"5812","58","722",722511,"Restr-Family","Oklahoma","United States",1078,"2014-08-04",118,341,391,0.109,0.316,2.89,1,null,9,164,null,null,"No","7 FT/2 PT"]
[3777,"5812","58","722",722511,"Restr W/Cocktails","Florida","United States",1050,"2014-09-10",97,100,115,9.1999999999999998E-2,9.5000000000000001E-2,1.0309999999999999,0.5,"4 Yrs @ 6%",10,50,null,192,"No",6]
[6688,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",1036,"2014-08-25",174,115,190,0.16800000000000001,0.111,0.66100000000000003,1,null,35,null,null,null,"No","1 FT/5 PT"]
[7525,"5812","58","722",722511,"Restr-Family","Incline Village, NV","United States",991,"2014-09-02",117,200,259,0.11799999999999999,0.20200000000000001,1.7090000000000001,0.26,null,0,null,null,null,"No","2 FT/2 PT"]
[9210,"5812","58","722",722511,"Restr-Family","Northern Nevada","United States",991,"2014-09-02",117,200,255,0.11799999999999999,0.20200000000000001,1.7090000000000001,0.26,"5 Yrs @ 6%",4,null,4.2000000000000003E-2,100,"No","6 FT/6 PT"]
[7580,"5812","58","722",722511,"Restr-Family","Iowa","United States",960,"2014-02-28",203,408,417,0.21099999999999999,0.42499999999999999,2.0099999999999998,null,null,0,175,null,231,"No","2 FT/3 PT"]
[12361,"5812","58","722",722511,"Restr-Family","Peoria, AZ","United States",932,"2014-12-03",null,295,295,null,0.317,null,1,null,0,null,null,null,"No"]
[5389,"5812","58","722",722511,"Restr-Family","Florida","United States",858,"2014-01-09",42,92,85,4.9000000000000002E-2,0.107,2.19,0.6,null,8,null,null,null,"No",15]
[4034,"5812","58","722",722511,"Restr-Barbeque","Florida","United States",850,"2014-11-30",80,100,175,9.4E-2,0.11799999999999999,1.25,0.75,"2 Yrs @ 0%",0,null,null,120,"No",7]
[3983,"5812","58","722",722513,"Fast Food Franchise","Florida","United States",840,"2014-09-30",85,120,145,0.10100000000000001,0.14299999999999999,1.4119999999999999,0.92,"1 Yr",0,null,null,null,"No",6]
[3996,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",814,"2014-08-04",58,130,145,7.0999999999999994E-2,0.16,2.2410000000000001,1,null,5,35,null,null,"Y-12.5%",6]
[10694,"5812","58","722",722515,"Franchise-Soft Serve","San Francisco, CA","United States",790,"2014-08-01",114,185,194,0.14399999999999999,0.23400000000000001,1.623,null,null,5,null,3.7999999999999999E-2,null,"No"]
[8230,"5812","58","722",722513,"Fast Food-Yogurt","Massachusetts","United States",775,"2014-06-13",193,550,550,0.249,0.71,2.85,1,null,0,125,null,null,"No","3 FT/4 PT"]
[11721,"5812","58","722",722511,"Restr-Family","Texas","United States",752,"2014-04-30",40,355,432,5.2999999999999999E-2,0.47199999999999998,8.875,null,null,18,59,0.08,null,"No"]
[3660,"5812","58","722",722511,"Restr-Family","Florida","United States",735,"2014-01-31",251,350,450,0.34100000000000003,0.47599999999999998,1.3939999999999999,0.46,"3 Yrs @ 5%",0,50,null,240,"No",6]
[7944,"5812","58","722",722511,"Restr-Japanese","Los Angeles, CA","United States",720,"2014-10-31",12,149,149,1.7000000000000001E-2,0.20699999999999999,12.417,1,null,0,null,null,258,"No","3 FT/1 PT"]
[12426,"5812","58","722",722513,"Deli W/Starbucks","Tempe, AZ","United States",720,"2014-03-28",204,400,475,0.28299999999999997,0.55600000000000005,1.9610000000000001,1,null,0,35,null,null,"No"]
[3788,"5812","58","722",722511,"Restr-Steakhouse","Florida","United States",720,"2014-02-28",240,182,195,0.33300000000000002,0.253,0.75800000000000001,0.48,"2 Mos @ 0%",5,null,null,210,"No",6]
[1061,"5812","58","722",722513,"Restr-Breakfast Only","Colorado","United States",701,"2014-03-31",86,222,222,0.123,0.317,2.581,1,null,3,35,null,150,"No",2]
[12332,"5812","58","722",722511,"Restr-Barbeque","Casa Grande, AZ","United States",700,"2014-12-16",59,30,60,8.4000000000000005E-2,4.2999999999999997E-2,0.50800000000000001,1,null,0,10,null,null,"No"]
[5313,"5812","58","722",722511,"Restr-Family","Florida","United States",700,"2014-04-24",75,95,140,0.107,0.13600000000000001,1.2669999999999999,1,null,0,50,7.0000000000000007E-2,85,"No",15]
[7408,"5812","58","722",722513,"Fast Food-Mexican","Houston, TX","United States",658,"2014-01-02",183,450,500,0.27800000000000002,0.68400000000000005,2.4590000000000001,1,null,0,293,0.12,948,"No","2 FT/11 PT"]
[4838,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",653,"2014-06-09",97,162,194,0.14899999999999999,0.248,1.67,0.77,"3 Yrs @ 5%",5,66,null,null,"No",10]
[3532,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",650,"2014-04-30",195,168,210,0.3,0.25800000000000001,0.86199999999999999,1,null,0,150,null,null,"No",5]
[11018,"5812","58","722",722511,"Restr W/Cocktails","South Dakota","United States",644,"2014-08-12",82,25,328,0.127,3.9E-2,0.30499999999999999,null,1,61,25,null,null,"No"]
[10769,"5812","58","722",722513,"Franch-Sandwiches","San Jose, CA","United States",633,"2014-03-11",113,490,550,0.17899999999999999,0.77400000000000002,4.3360000000000003,null,null,0,null,null,null,"No"]
[9425,"5812","58","722",722515,"Fast Food-Yogurt","Orange County, CA","United States",603,"2014-02-21",52,104,104,8.5999999999999993E-2,0.17199999999999999,2,null,null,0,null,null,null,"No","8 FT/1 PT"]
[7923,"5812","58","722",722511,"Restr-Family","Los Angeles, CA","United States",600,"2014-10-21",180,450,450,0.3,0.75,2.5,1,null,0,null,null,160,"No","3 FT/1 PT"]
[7921,"5812","58","722",722515,"Coffee/Sandwiches","Los Angeles, CA","United States",576,"2014-03-10",144,275,295,0.25,0.47699999999999998,1.91,1,null,0,null,null,158,"No","3 FT/1 PT"]
[5111,"5812","58","722",722511,"Restr-Family","Florida","United States",575,"2014-12-05",115,140,204,0.2,0.24299999999999999,1.2170000000000001,0.93,"10 Yrs @ 6%",5,50,null,null,"No",12]
[3779,"5812","58","722",722511,"Restr-Family","Florida","United States",575,"2014-12-31",136,161,162,0.23699999999999999,0.28000000000000003,1.1839999999999999,null,null,3,45,null,200,"No",6]
[12362,"5812","58","722",722511,"Restr-Family","Phoenix, AZ","United States",560,"2014-03-28",71,70,100,0.127,0.125,0.98599999999999999,1,null,0,50,null,null,"No"]
[6374,"5812","58","722",722511,"Restr-Family","Florida","United States",550,"2014-09-19",190,251,271,0.34499999999999997,0.45600000000000002,1.321,1,null,4,55,null,7,"No","1 FT/2 PT"]
[8030,"5812","58","722",722511,"Restr-Family","Los Angeles, CA","United States",550,"2014-07-22",0,195,195,0,0.35499999999999998,null,1,null,3,45,null,null,"No","3 FT/1 PT"]
[10997,"5812","58","722",722513,"Bakery Restaurant","South Carolina","United States",525,"2014-06-06",110,225,225,0.21,0.42899999999999999,2.0449999999999999,0.22,"5 Yrs @ 6%",2,25,6.9000000000000006E-2,null,"No"]
[3146,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",519,"2014-08-31",138,115,140,0.26600000000000001,0.222,0.83299999999999996,1,null,5,80,null,360,"Yes",4]
[12327,"5812","58","722",722511,"Restr W/Cocktails","Tempe, AZ","United States",515,"2014-02-14",75,100,160,0.14599999999999999,0.19400000000000001,1.333,1,null,0,160,null,null,"No"]
[3453,"5812","58","722",722511,"Restr-Family","Florida","United States",514,"2014-11-30",137,219,244,0.26700000000000002,0.42599999999999999,1.599,0.67,"3 Yrs @ 6%",6,33,null,null,"No",5]
[10668,"5812","58","722",722515,"Tea House","San Francisco, CA","United States",477,"2014-06-13",80,97,132,0.16800000000000001,0.20300000000000001,1.2130000000000001,0.8,"3 Yrs@ 5%",28,null,0.25,null,"No"]
[10748,"5812","58","722",722515,"Tea House","San Jose, CA","United States",477,"2014-06-13",80,125,160,0.16800000000000001,0.26200000000000001,1.5629999999999999,null,null,0,null,null,null,"No"]
[5547,"5812","58","722",722513,"Fast Food-Yogurt","Florida","United States",475,"2014-08-28",135,413,425,0.28399999999999997,0.86899999999999999,3.0590000000000002,null,null,0,125,null,null,"No",18]
[3446,"5812","58","722",722513,"Restr-Breakfast/Lunch","Florida","United States",470,"2014-04-30",95,139,149,0.20200000000000001,0.29599999999999999,1.4630000000000001,1,null,10,60,null,null,"No",5]
[12425,"5812","58","722",722513,"Deli W/Starbucks","Phoenix, AZ","United States",468,"2014-03-28",132,260,275,0.28199999999999997,0.55600000000000005,1.97,0.81,null,0,60,null,null,"No"]
[9291,"5812","58","722",722511,"Restr-Family","Ohio","United States",450,"2014-09-29",62,112,104,0.13800000000000001,0.249,1.806,0.1,"7 Yrs @ 6%",5,30,null,138,"No","7 FT/10 PT"]
[42,"5812","58","722",722515,"Coffee House","Aptos, CA","United States",438,"2014-07-13",62,150,200,0.14199999999999999,0.34200000000000003,2.419,null,null,0,null,null,75,"No",1]
[2654,"5812","58","722",722511,"Restr-Barbeque","Florida","United States",423,"2014-02-24",65,120,120,0.154,0.28399999999999997,1.8460000000000001,0.83,"1.5 Yrs @ 6%",0,30,null,60,"No",4]
[12375,"5812","58","722",722513,"Restr-Breakfast Only","Scottsdale, AZ","United States",421,"2014-03-04",37,37,37,8.7999999999999995E-2,8.7999999999999995E-2,1,1,null,3,40,null,null,"No"]
[12381,"5812","58","722",722511,"Restr-Sushi","Phoenix, AZ","United States",420,"2014-07-28",137,100,150,0.32600000000000001,0.23799999999999999,0.73,1,null,0,45,null,null,"No"]
[5623,"5812","58","722",722511,"Restr-Family","Florida","United States",420,"2014-06-16",82,86,91,0.19500000000000001,0.20499999999999999,1.0489999999999999,0.55000000000000004,"3 Yrs @ 6%",4,15,null,425,"No",20]
[8443,"5812","58","722",722513,"Fast Food-Pizza","Minneapolis, MN","United States",414,"2014-05-16",78,215,215,0.188,0.51900000000000002,2.7559999999999998,0.9,"1Yr @ 0%",5,25,null,null,"No","4 FT/1 PT"]
[3441,"5812","58","722",722515,"Fast Food-Yogurt","Florida","United States",401,"2014-07-31",120,205,295,0.29899999999999999,0.51100000000000001,1.708,1,null,4,135,null,null,"No",5]
[12382,"5812","58","722",722511,"Restr-Sushi","Tucson, AZ","United States",400,"2014-09-29",55,150,150,0.13800000000000001,0.375,2.7269999999999999,0.27,null,5,83,null,null,"No"]
[3182,"5812","58","722",722515,"Self Serv-Yogurt","Florida","United States",395,"2014-04-01",90,215,295,0.22800000000000001,0.54400000000000004,2.3889999999999998,null,null,2,null,null,293,"No",5]
[12373,"5812","58","722",722513,"Breakfast/Lunch","Phoenix, AZ","United States",394,"2014-01-31",120,220,220,0.30499999999999999,0.55800000000000005,1.833,0.73,null,0,75,null,null,"No"]
[12365,"5812","58","722",722511,"Restr-Family","Scottsdale, AZ","United States",384,"2014-10-02",null,155,195,null,0.40400000000000003,null,1,null,0,null,null,null,"No"]
[9372,"5812","58","722",722511,"Restr-Japanese","Orange County, CA","United States",384,"2014-08-27",36,99,99,9.4E-2,0.25800000000000001,2.75,0.5,"2 Yrs",5,null,null,null,"No","7 FT/6 PT"]
[1135,"5812","58","722",722511,"Fast Food-Sushi","Costa Mesa, CA","United States",380,"2014-03-26",45,195,195,0.11799999999999999,0.51300000000000001,4.3330000000000002,1,null,0,null,0.12,32,"No",2]
[5965,"5812","58","722",722513,"Fast Food-Smoothies","Florida","United States",375,"2014-11-10",28,125,148,7.4999999999999997E-2,0.33300000000000002,4.4640000000000004,0.62,"3 Yrs @ 0%",2,null,null,null,"No",40]
[3451,"5812","58","722",722511,"Restr-Seafood","Florida","United States",360,"2014-01-17",90,73,86,0.25,0.20300000000000001,0.81100000000000005,0.8,"2 Yrs @ 4%",2,42,null,null,"No",5]
[8037,"5812","58","722",722511,"Restr-Mexican","Los Angeles, CA","United States",360,"2014-03-11",90,87,92,0.25,0.24199999999999999,0.96699999999999997,0.39,null,3,null,null,211,"No","3 FT/10 PT"]
[7867,"5812","58","722",722511,"Restr-Mexican","Los Angeles, CA","United States",360,"2014-03-11",90,35,95,0.25,9.7000000000000003E-2,0.38900000000000001,1,null,4,null,null,null,"No","3 Ft/ 2 PT"]
[10652,"5812","58","722",722513,"Bakery Restaurant","San Francisco, CA","United States",350,"2014-07-31",31,70,130,8.8999999999999996E-2,0.2,2.258,null,null,0,null,0.13,null,"No"]
[7913,"5812","58","722",722511,"Restr-Japanese","Los Angeles, CA","United States",350,"2014-08-12",20,50,50,5.7000000000000002E-2,0.14299999999999999,2.5,1,null,0,null,null,125,"No","3 FT/1 PT"]
[11672,"5812","58","722",722515,"Fast Food-Yogurt","Texas","United States",348,"2014-12-19",75,137,170,0.216,0.39400000000000002,1.827,null,null,0,null,null,null,"No"]
[2652,"5812","58","722",722513,"Deli-Submarines","Florida","United States",345,"2014-08-31",48,64,89,0.13900000000000001,0.186,1.333,0.55000000000000004,"2 Yrs @ 4%",1,30,null,57,"No",4]
[9399,"5812","58","722",722515,"Fast Food-Ice Cream","Orange County, CA","United States",317,"2014-07-09",65,124,124,0.20499999999999999,0.39100000000000001,1.9079999999999999,1,null,4,20,0.14000000000000001,null,"No","8 FT/ 5 PT"]
[7576,"5812","58","722",722511,"Restr-Steakhouse","Iowa","United States",316,"2014-10-22",33,71,233,0.104,0.22500000000000001,2.1520000000000001,1,null,9,33,null,178,"No","2 FT/3 PT"]
[11723,"5812","58","722",722511,"Restr-Family","Texas","United States",315,"2014-03-31",18,70,99,5.7000000000000002E-2,0.222,3.8889999999999998,1,null,1,70,13,null,"No"]
[2964,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",312,"2014-06-17",68,79,85,0.218,0.253,1.1619999999999999,1,null,1,35,null,null,"No",4]
[12363,"5812","58","722",722511,"Restr-Family","Prescott, AZ","United States",304,"2014-09-12",44,90,240,0.14499999999999999,0.29599999999999999,2.0449999999999999,1,null,0,null,null,null,"No"]
[1866,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",300,"2014-12-12",60,83,90,0.2,0.27700000000000002,1.383,1,null,0,25,null,30,"No",3]
[9506,"5812","58","722",722511,"Restr W/Cocktails","Oregon","United States",295,"2014-09-02",55,110,107,0.186,0.373,2,null,null,8,null,null,null,"No","9 FT/`14 PT"]
[10327,"5812","58","722",722511,"Restr-Chinese","Riverside, CA","United States",288,"2014-09-19",24,60,125,8.3000000000000004E-2,0.20799999999999999,2.5,1,null,0,null,null,null,"No"]
[12408,"5812","58","722",722513,"Fast Food-Pizza","Gilbert, AZ","United States",288,"2014-06-09",55,55,70,0.191,0.191,1,1,null,3,30,null,null,"No"]
[10326,"5812","58","722",722511,"Fast Food-Chinese","Riverside, CA","United States",288,"2014-04-09",24,55,120,8.3000000000000004E-2,0.191,2.2919999999999998,1,null,5,null,0.1,null,"No"]
[12424,"5812","58","722",722513,"Deli W/Starbucks","Phoenix, AZ","United States",288,"2014-02-13",60,115,170,0.20799999999999999,0.39900000000000002,1.917,1,null,0,25,null,null,"No"]
[12380,"5812","58","722",722511,"Restr-Sushi","N. Dallas, TX","United States",276,"2014-12-15",36,46,46,0.13,0.16700000000000001,1.278,1,null,3,50,0.26,120,"No",4]
[8715,"5812","58","722",722513,"Fast Food-Pizza","Missouri","United States",264,"2014-06-02",60,126,135,0.22700000000000001,0.47699999999999998,2.1,0.3,"6 Mos @ 6%",4,30,8.6999999999999994E-2,null,"No","4 FT/6 PT"]
[8743,"5812","58","722",722515,"Fast Food-Ice Cream","Missouri","United States",258,"2014-05-30",-10,45,150,-3.9E-2,0.17399999999999999,null,1,null,5,null,null,297,"No","4 PT"]
[6312,"5812","58","722",722511,"Restr-Family","Florida","United States",256,"2014-06-27",44,84,99,0.17199999999999999,0.32800000000000001,1.909,1,null,2,50,null,null,"No","1 FT/1 PT"]
[12421,"5812","58","722",722513,"Deli-Sandwiches","Fountain Hills, AZ","United States",253,"2014-07-07",20,176,180,7.9000000000000001E-2,0.69599999999999995,8.8000000000000007,0.43,null,0,null,null,null,"No"]
[12415,"5812","58","722",722515,"Franchise-Yogurt Store","Phoenix, AZ","United States",250,"2014-03-10",40,125,145,0.16,0.5,3.125,1,null,3,125,null,null,"No"]
[2959,"5812","58","722",722513,"Bagel Restaurant","Florida","United States",247,"2014-05-02",73,115,115,0.29599999999999999,0.46600000000000003,1.575,1,null,1,50,null,null,"No",4]
[12430,"5812","58","722",722515,"Coffee House","Phoenix, AZ","United States",245,"2014-01-14",62,120,125,0.253,0.49,1.9350000000000001,0.8,null,2,36,null,null,"No"]
[8746,"5812","58","722",722515,"Fast Food-Ice Cream","Missouri","United States",245,"2014-05-30",22,45,150,0.09,0.184,2.0449999999999999,null,null,5,null,null,null,"No","4 PT"]
[12409,"5812","58","722",722513,"Fast Food-Pizza","Prescott, AZ","United States",241,"2014-11-04",40,75,95,0.16600000000000001,0.311,1.875,1,null,0,null,null,null,"No"]
[1152,"5812","58","722",722515,"Fast Food-Ice Cream","Dallas, TX","United States",240,"2014-06-03",105,185,215,0.438,0.77100000000000002,1.762,1,null,3,50,0.25,45,"No",2]
[12376,"5812","58","722",722513,"Breakfast/Lunch","Sun City West, AZ","United States",239,"2014-01-17",56,50,55,0.23400000000000001,0.20899999999999999,0.89300000000000002,0.4,null,0,55,null,null,"No"]
[12414,"5812","58","722",722515,"Fast Food-Yogurt","Fountain Hills, AZ","United States",235,"2014-03-03",45,93,115,0.191,0.39600000000000002,2.0670000000000002,1,null,2,115,null,null,"No"]
[7979,"5812","58","722",722513,"Fast Food-Chicken","Los Angeles, CA","United States",230,"2014-11-13",25,55,59,0.109,0.23899999999999999,2.2000000000000002,1,null,0,null,null,null,"No","3 FT/1 PT"]
[12364,"5812","58","722",722511,"Restr-Diner","San Diego, CA","United States",220,"2014-10-06",40,67,77,0.182,0.30499999999999999,1.675,0.5,"4 Yrs @ 6%",3,30,0.09,210,"No",5]
[12370,"5812","58","722",722513,"Restr-Breakfast Only","Gilbert, AZ","United States",220,"2014-12-22",66,109,109,0.3,0.495,1.6519999999999999,0.47,null,2,40,null,null,"No"]
[4645,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",208,"2014-02-14",1,33,60,5.0000000000000001E-3,0.159,33,0.66,"2 Mos @ 0%",3,null,0.21,null,"No",9]
[4612,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",208,"2014-11-26",40,150,159,0.192,0.72099999999999997,3.75,1,null,3,40,null,360,"No",9]
[729,"5812","58","722",722511,"Restr-Ethnic Food","CN-Ontario","Canada",207,"2014-02-07",51,65,80,0.246,0.314,1.2749999999999999,1,null,0,65,0.18,null,"No",1]
[2307,"5812","58","722",722513,"Deli-Office Building","Florida","United States",200,"2014-06-30",43,65,77,0.215,0.32500000000000001,1.512,0.31,null,0,20,null,null,"No",3]
[12378,"5812","58","722",722515,"Restr-Coffee Shop","Gold Canyon, AZ","United States",195,"2014-09-29",55,158,165,0.28199999999999997,0.81,2.8730000000000002,0.32,null,2,3,null,null,"No"]
[8442,"5812","58","722",722513,"Fast Food-Italian/Pizza","Minneapolis, MN","United States",190,"2014-12-01",50,50,50,0.26300000000000001,0.26300000000000001,1,1,null,0,25,0.11,null,"No","4 FT/1 PT"]
[6544,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",175,"2014-05-06",84,80,159,0.48,0.45700000000000002,0.95199999999999996,1,null,1,50,0.04,147,"No","1 FT/3 PT"]
[3452,"5812","58","722",722511,"Restr-Family","Florida","United States",174,"2014-06-30",48,48,59,0.27600000000000002,0.27600000000000002,1,1,null,1,38,null,null,"No",5]
[4498,"5812","58","722",722511,"Restr-Family","Florida","United States",170,"2014-06-04",47,35,47,0.27600000000000002,0.20599999999999999,0.745,0.2,"4Yrs @ 6%",3,27,null,null,"No",8]
[9420,"5812","58","722",722515,"Coffee/Tea House","Orange County, CA","United States",168,"2014-05-30",18,85,105,0.107,0.50600000000000001,4.7220000000000004,1,null,5,null,null,null,"No","8 FT/1 PT"]
[12372,"5812","58","722",722513,"Breakfast/Lunch","Mesa AZ","United States",158,"2014-04-14",51,50,66,0.32300000000000001,0.316,0.98,null,null,1,16,null,null,"No"]
[5289,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",144,"2014-01-15",28,26,37,0.19400000000000001,0.18099999999999999,0.92900000000000005,1,null,3,16,0.17,null,"No",14]
[12394,"5812","58","722",722513,"Snack Stand","Phoenix, AZ","United States",140,"2014-03-03",40,50,55,0.28599999999999998,0.35699999999999998,1.25,1,null,1,50,null,null,"No"]
[1898,"5812","58","722",722511,"Restr-Family","Florida","United States",132,"2014-10-31",38,89,89,0.28799999999999998,0.67400000000000004,2.3420000000000001,1,null,1,8,null,180,"No",3]
[12374,"5812","58","722",722513,"Breakfast/Lunch","Scottsdale, AZ","United States",125,"2014-12-15",56,57,60,0.44800000000000001,0.45600000000000002,1.018,0.44,null,0,35,null,null,"No"]
[12013,"5812","58","722",722515,"Espresso Kiosk","Washington","United States",125,"2014-10-31",29,50,50,0.23200000000000001,0.4,1.724,1,null,2,40,0.12,null,"Yes"]
[2717,"5812","58","722",722515,"Fast Food-Yogurt","Florida","United States",120,"2014-04-30",20,48,85,0.16700000000000001,0.4,2.4,1,null,0,null,null,120,"No",4]
[9421,"5812","58","722",722511,"Deli-Sandwiches","Orange County, CA","United States",85,"2014-06-25",0,65,55,0,0.76500000000000001,null,1,null,3,null,null,null,"No","8 FT/1 PT"]
[12395,"5812","58","722",722513,"Hot Dog Stand","Tempe, AZ","United States",75,"2014-03-04",45,50,60,0.6,0.66700000000000004,1.111,1,null,2,25,null,null,"No"]
[4200,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",73,"2014-10-03",28,30,35,0.38400000000000001,0.41099999999999998,1.071,1,null,5,21,null,null,"No",7]
[9513,{"$f":"TEXT(\"5813\",\"0000\")","v":"5813"},"58","722",722410,"Adult Entertainment","Oregon","United States",1566,"2014-12-22",591,1025,1500,0.377,0.65500000000000003,1.734,1,null,2,385,null,155,"No","9 FT/1 PT"]
[10198,"5813","58","722",722410,"Cocktail Lounge","Redwood City, CA","United States",1134,"2014-10-15",231,650,650,0.20399999999999999,0.57299999999999995,2.8140000000000001,0.3,null,0,null,null,560,"No"]
[3873,"5813","58","722",722410,"Cocktail Lounge","Florida","United States",996,"2014-02-28",61,435,475,6.0999999999999999E-2,0.437,7.1310000000000002,1,null,0,55,null,1992,"No",6]
[6604,"5813","58","722",722410,"Brew Pub W/Food","Florida","United States",645,"2014-12-19",128,197,272,0.19800000000000001,0.30499999999999999,1.5389999999999999,0.4,null,3,50,null,null,"No","1 Ft/3 PT"]
[8019,"5813","58","722",722410,"Cocktails W/Food","Los Angeles, CA","United States",576,"2014-03-12",144,275,295,0.25,0.47699999999999998,1.91,1,null,0,null,0.09,null,"No","3 FT/1 PT"]
[12445,"5813","58","722",722410,"Sports Bar","Tucson AZ","United States",500,"2014-10-15",50,79,89,0.1,0.158,1.58,0.7,null,7,50,null,null,"No"]
[10719,"5813","58","722",722410,"Cocktail Lounge","San Jose, CA","United States",235,"2014-10-15",null,50,129,null,0.21299999999999999,null,1,null,0,null,null,null,"No"]
[12444,"5813","58","722",722410,"Cocktail Lounge","Phoenix, AZ","United States",200,"2014-04-09",null,150,175,null,0.75,null,0.1,null,0,110,null,null,"No"]

{"sheet":"Select Tools","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,8,1,12],[1,1,1,6],[2,1,2,6]]}
[]
[null,"Selection Criteria",null,null,null,null,null,null,"Total Population from \"All Trans\" Sheet"]
[null,"Selects transactions that meet the following criteria. Blank fields are ignored.",null,null,null,null,null,null,null,null,"Count =",{"$f":"Statistics!C19","v":135}]
[]
[null,null,null,null,"Min","Max",null,null,null,null,"Min","Max"]
[null,null,"Sale Date",null,null,null,null,null,null,"Sale Date",{"$f":"Statistics!D19","v":"2014-01-02"},{"$f":"Statistics!E19","v":"2014-12-31"}]
[null,null,"Sale Price",null,null,null,null,null,null,"Sale Price",{"$f":"Statistics!D24","v":25},{"$f":"Statistics!E24","v":2200}]
[null,null,"Annual Gross Sales",null,null,null,null,null,null,"Annual Gross Sales",{"$f":"Statistics!D20","v":73},{"$f":"Statistics!E20","v":2550}]
[null,null,"SDE to Annual Gross",null,null,null,null,null,null,"SDE to Annual Gross",{"$f":"Statistics!D25","v":-3.9E-2},{"$f":"Statistics!E25","v":0.6}]
[null,null,"Rent to Annual Gross",null,null,null,null,null,null,"Rent to Annual Gross",{"$f":"Statistics!D26","v":8.9999999999999993E-3},{"$f":"Statistics!E26","v":13}]
[null,null,"SDE",null,null,null,null,null,null,"SDE",{"$f":"Statistics!D21","v":-10},{"$f":"Statistics!E22","v":61}]
[null,null,"Inventory Value",null,null,null,null,null,null,"Inventory Value",{"$f":"Statistics!D22","v":0},{"$f":"Statistics!E23","v":385}]
[null,null,"FF&E",null,null,null,null,null,null,"FF&E",{"$f":"Statistics!D23","v":3},{"$f":"Statistics!E24","v":2200}]
[]
[null,null,"SIC"]
[]
[]
[null,null,"NAICS"]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: Enter currency fields in thousands (example: for $1 million, you would enter $1,000)."]

{"sheet":"Manual Select","index":5,"n_rows":136,"n_cols":25,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
["Select","TransactionID","SICCode","SICCodeGeneral","NAICSGeneral","NAICSCode","BusinessDescription","Area","Country","AnnualGross","SaleDate","SDE","SalePrice","AskPrice","SDEtoAnnualGross","SalePriceToAnnualGross","SalePriceToSDE","PercentDown","Terms","InventoryAmount","FFE","RentToAnnualGross","DaysOnMarket","FranchiseRoyalty","NumberOfEmployees"]
["Yes",11351,{"$f":"TEXT(\"5812\",\"0000\")","v":"5812"},{"$f":"TEXT(\"58\",\"00\")","v":"58"},{"$f":"TEXT(\"722\",\"000\")","v":"722"},722513,"Fast Food-Burgers","Southeast","United States",2550,"2014-03-31",315,1300,1300,0.124,0.51,4.1269999999999998,null,null,13,null,null,null,"No"]
["Yes",10989,"5812","58","722",722513,"Fast Food-Burgers","South Atlantic","United States",2500,"2014-02-28",505,2200,2400,0.20200000000000001,0.88,4.3559999999999999,null,null,15,null,null,null,"No"]
["Yes",4033,"5812","58","722",722511,"Restr-Family","Florida","United States",2235,"2014-04-14",342,650,975,0.153,0.29099999999999998,1.901,1,null,0,50,null,120,"No",7]
["Yes",5394,"5812","58","722",722511,"Restr-Ethnic","Florida","United States",2190,"2014-05-05",413,492,642,0.189,0.22500000000000001,1.1910000000000001,0.2,"1 Yr @ 4%",8,89,null,65,"Y-5%",15]
["Yes",11659,"5812","58","722",722511,"Restr W/Cocktails","Texas","United States",1702,"2014-07-14",143,388,783,8.4000000000000005E-2,0.22800000000000001,2.7130000000000001,0.3,null,0,15,null,null,"No"]
["Yes",1059,"5812","58","722",722513,"Bakery-Restaurant","Colorado","United States",1588,"2014-02-28",247,500,500,0.156,0.315,2.024,0.48,null,25,100,null,150,"No",2]
["Yes",10765,"5812","58","722",722511,"Restr-Family","San Jose, CA","United States",1543,"2014-04-28",180,250,395,0.11700000000000001,0.16200000000000001,1.389,null,null,0,null,null,null,"No"]
["Yes",7403,"5812","58","722",722511,"Restr W/Cocktails","Houston, TX","United States",1527,"2014-12-05",356,700,750,0.23300000000000001,0.45800000000000002,1.966,null,null,0,359,null,null,"No","2 FT/10 PT"]
["Yes",8932,"5812","58","722",722511,"Restr-Family","New England","United States",1411,"2014-05-19",258,325,775,0.183,0.23,1.26,0.16,"20 Yrs @ 2%",11,259,null,36,"No","5 FT/3 PT"]
["Yes",3538,"5812","58","722",722511,"Restr-Italian","Florida","United States",1381,"2014-06-30",219,400,450,0.159,0.28999999999999998,1.8260000000000001,0.45,"5 Yrs @ 5%",1,80,null,null,"No",5]
["Yes",11837,"5812","58","722",722511,"Mexican Buffett","Tyler, TX","United States",1363,"2014-03-28",229,229,239,0.16800000000000001,0.16800000000000001,1,1,null,10,130,8.9999999999999993E-3,null,"No"]
["Yes",6513,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",1200,"2014-09-08",315,575,650,0.26300000000000001,0.47899999999999998,1.825,1,null,0,125,null,null,"No","1 FT/2 PT"]
["Yes",10692,"5812","58","722",722513,"Fast Food Cafe","San Francisco, CA","United States",1134,"2014-10-15",231,650,650,0.20399999999999999,0.57299999999999995,2.8140000000000001,0.3,null,0,null,0.05,null,"No"]
["Yes",4137,"5812","58","722",722511,"Restr-Family","Florida","United States",1100,"2014-07-07",150,345,384,0.13600000000000001,0.314,2.2999999999999998,1,null,15,50,null,292,"No",7]
["Yes",11035,"5812","58","722",722511,"Restr-Family","South Dakota","United States",1100,"2014-05-21",148,532,542,0.13500000000000001,0.48399999999999999,3.5950000000000002,null,"5.5 Yrs @ 5.5%",8,null,null,null,"No"]
["Yes",9321,"5812","58","722",722511,"Restr-Family","Oklahoma","United States",1078,"2014-08-04",118,341,391,0.109,0.316,2.89,1,null,9,164,null,null,"No","7 FT/2 PT"]
["Yes",3777,"5812","58","722",722511,"Restr W/Cocktails","Florida","United States",1050,"2014-09-10",97,100,115,9.1999999999999998E-2,9.5000000000000001E-2,1.0309999999999999,0.5,"4 Yrs @ 6%",10,50,null,192,"No",6]
["Yes",6688,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",1036,"2014-08-25",174,115,190,0.16800000000000001,0.111,0.66100000000000003,1,null,35,null,null,null,"No","1 FT/5 PT"]
["Yes",7525,"5812","58","722",722511,"Restr-Family","Incline Village, NV","United States",991,"2014-09-02",117,200,259,0.11799999999999999,0.20200000000000001,1.7090000000000001,0.26,null,0,null,null,null,"No","2 FT/2 PT"]
["Yes",9210,"5812","58","722",722511,"Restr-Family","Northern Nevada","United States",991,"2014-09-02",117,200,255,0.11799999999999999,0.20200000000000001,1.7090000000000001,0.26,"5 Yrs @ 6%",4,null,4.2000000000000003E-2,100,"No","6 FT/6 PT"]
["Yes",7580,"5812","58","722",722511,"Restr-Family","Iowa","United States",960,"2014-02-28",203,408,417,0.21099999999999999,0.42499999999999999,2.0099999999999998,null,null,0,175,null,231,"No","2 FT/3 PT"]
["Yes",12361,"5812","58","722",722511,"Restr-Family","Peoria, AZ","United States",932,"2014-12-03",null,295,295,null,0.317,null,1,null,0,null,null,null,"No"]
["Yes",5389,"5812","58","722",722511,"Restr-Family","Florida","United States",858,"2014-01-09",42,92,85,4.9000000000000002E-2,0.107,2.19,0.6,null,8,null,null,null,"No",15]
["Yes",4034,"5812","58","722",722511,"Restr-Barbeque","Florida","United States",850,"2014-11-30",80,100,175,9.4E-2,0.11799999999999999,1.25,0.75,"2 Yrs @ 0%",0,null,null,120,"No",7]
["Yes",3983,"5812","58","722",722513,"Fast Food Franchise","Florida","United States",840,"2014-09-30",85,120,145,0.10100000000000001,0.14299999999999999,1.4119999999999999,0.92,"1 Yr",0,null,null,null,"No",6]
["Yes",3996,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",814,"2014-08-04",58,130,145,7.0999999999999994E-2,0.16,2.2410000000000001,1,null,5,35,null,null,"Y-12.5%",6]
["Yes",10694,"5812","58","722",722515,"Franchise-Soft Serve","San Francisco, CA","United States",790,"2014-08-01",114,185,194,0.14399999999999999,0.23400000000000001,1.623,null,null,5,null,3.7999999999999999E-2,null,"No"]
["Yes",8230,"5812","58","722",722513,"Fast Food-Yogurt","Massachusetts","United States",775,"2014-06-13",193,550,550,0.249,0.71,2.85,1,null,0,125,null,null,"No","3 FT/4 PT"]
["Yes",11721,"5812","58","722",722511,"Restr-Family","Texas","United States",752,"2014-04-30",40,355,432,5.2999999999999999E-2,0.47199999999999998,8.875,null,null,18,59,0.08,null,"No"]
["Yes",3660,"5812","58","722",722511,"Restr-Family","Florida","United States",735,"2014-01-31",251,350,450,0.34100000000000003,0.47599999999999998,1.3939999999999999,0.46,"3 Yrs @ 5%",0,50,null,240,"No",6]
["Yes",7944,"5812","58","722",722511,"Restr-Japanese","Los Angeles, CA","United States",720,"2014-10-31",12,149,149,1.7000000000000001E-2,0.20699999999999999,12.417,1,null,0,null,null,258,"No","3 FT/1 PT"]
["Yes",12426,"5812","58","722",722513,"Deli W/Starbucks","Tempe, AZ","United States",720,"2014-03-28",204,400,475,0.28299999999999997,0.55600000000000005,1.9610000000000001,1,null,0,35,null,null,"No"]
["Yes",3788,"5812","58","722",722511,"Restr-Steakhouse","Florida","United States",720,"2014-02-28",240,182,195,0.33300000000000002,0.253,0.75800000000000001,0.48,"2 Mos @ 0%",5,null,null,210,"No",6]
["Yes",1061,"5812","58","722",722513,"Restr-Breakfast Only","Colorado","United States",701,"2014-03-31",86,222,222,0.123,0.317,2.581,1,null,3,35,null,150,"No",2]
["Yes",12332,"5812","58","722",722511,"Restr-Barbeque","Casa Grande, AZ","United States",700,"2014-12-16",59,30,60,8.4000000000000005E-2,4.2999999999999997E-2,0.50800000000000001,1,null,0,10,null,null,"No"]
["Yes",5313,"5812","58","722",722511,"Restr-Family","Florida","United States",700,"2014-04-24",75,95,140,0.107,0.13600000000000001,1.2669999999999999,1,null,0,50,7.0000000000000007E-2,85,"No",15]
["Yes",7408,"5812","58","722",722513,"Fast Food-Mexican","Houston, TX","United States",658,"2014-01-02",183,450,500,0.27800000000000002,0.68400000000000005,2.4590000000000001,1,null,0,293,0.12,948,"No","2 FT/11 PT"]
["Yes",4838,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",653,"2014-06-09",97,162,194,0.14899999999999999,0.248,1.67,0.77,"3 Yrs @ 5%",5,66,null,null,"No",10]
["Yes",3532,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",650,"2014-04-30",195,168,210,0.3,0.25800000000000001,0.86199999999999999,1,null,0,150,null,null,"No",5]
["Yes",11018,"5812","58","722",722511,"Restr W/Cocktails","South Dakota","United States",644,"2014-08-12",82,25,328,0.127,3.9E-2,0.30499999999999999,null,1,61,25,null,null,"No"]
["Yes",10769,"5812","58","722",722513,"Franch-Sandwiches","San Jose, CA","United States",633,"2014-03-11",113,490,550,0.17899999999999999,0.77400000000000002,4.3360000000000003,null,null,0,null,null,null,"No"]
["Yes",9425,"5812","58","722",722515,"Fast Food-Yogurt","Orange County, CA","United States",603,"2014-02-21",52,104,104,8.5999999999999993E-2,0.17199999999999999,2,null,null,0,null,null,null,"No","8 FT/1 PT"]
["Yes",7923,"5812","58","722",722511,"Restr-Family","Los Angeles, CA","United States",600,"2014-10-21",180,450,450,0.3,0.75,2.5,1,null,0,null,null,160,"No","3 FT/1 PT"]
["Yes",7921,"5812","58","722",722515,"Coffee/Sandwiches","Los Angeles, CA","United States",576,"2014-03-10",144,275,295,0.25,0.47699999999999998,1.91,1,null,0,null,null,158,"No","3 FT/1 PT"]
["Yes",5111,"5812","58","722",722511,"Restr-Family","Florida","United States",575,"2014-12-05",115,140,204,0.2,0.24299999999999999,1.2170000000000001,0.93,"10 Yrs @ 6%",5,50,null,null,"No",12]
["Yes",3779,"5812","58","722",722511,"Restr-Family","Florida","United States",575,"2014-12-31",136,161,162,0.23699999999999999,0.28000000000000003,1.1839999999999999,null,null,3,45,null,200,"No",6]
["Yes",12362,"5812","58","722",722511,"Restr-Family","Phoenix, AZ","United States",560,"2014-03-28",71,70,100,0.127,0.125,0.98599999999999999,1,null,0,50,null,null,"No"]
["Yes",6374,"5812","58","722",722511,"Restr-Family","Florida","United States",550,"2014-09-19",190,251,271,0.34499999999999997,0.45600000000000002,1.321,1,null,4,55,null,7,"No","1 FT/2 PT"]
["Yes",8030,"5812","58","722",722511,"Restr-Family","Los Angeles, CA","United States",550,"2014-07-22",0,195,195,0,0.35499999999999998,null,1,null,3,45,null,null,"No","3 FT/1 PT"]
["Yes",10997,"5812","58","722",722513,"Bakery Restaurant","South Carolina","United States",525,"2014-06-06",110,225,225,0.21,0.42899999999999999,2.0449999999999999,0.22,"5 Yrs @ 6%",2,25,6.9000000000000006E-2,null,"No"]
["Yes",3146,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",519,"2014-08-31",138,115,140,0.26600000000000001,0.222,0.83299999999999996,1,null,5,80,null,360,"Yes",4]
["Yes",12327,"5812","58","722",722511,"Restr W/Cocktails","Tempe, AZ","United States",515,"2014-02-14",75,100,160,0.14599999999999999,0.19400000000000001,1.333,1,null,0,160,null,null,"No"]
["Yes",3453,"5812","58","722",722511,"Restr-Family","Florida","United States",514,"2014-11-30",137,219,244,0.26700000000000002,0.42599999999999999,1.599,0.67,"3 Yrs @ 6%",6,33,null,null,"No",5]
["Yes",10668,"5812","58","722",722515,"Tea House","San Francisco, CA","United States",477,"2014-06-13",80,97,132,0.16800000000000001,0.20300000000000001,1.2130000000000001,0.8,"3 Yrs@ 5%",28,null,0.25,null,"No"]
["Yes",10748,"5812","58","722",722515,"Tea House","San Jose, CA","United States",477,"2014-06-13",80,125,160,0.16800000000000001,0.26200000000000001,1.5629999999999999,null,null,0,null,null,null,"No"]
["Yes",5547,"5812","58","722",722513,"Fast Food-Yogurt","Florida","United States",475,"2014-08-28",135,413,425,0.28399999999999997,0.86899999999999999,3.0590000000000002,null,null,0,125,null,null,"No",18]
["Yes",3446,"5812","58","722",722513,"Restr-Breakfast/Lunch","Florida","United States",470,"2014-04-30",95,139,149,0.20200000000000001,0.29599999999999999,1.4630000000000001,1,null,10,60,null,null,"No",5]
["Yes",12425,"5812","58","722",722513,"Deli W/Starbucks","Phoenix, AZ","United States",468,"2014-03-28",132,260,275,0.28199999999999997,0.55600000000000005,1.97,0.81,null,0,60,null,null,"No"]
["Yes",9291,"5812","58","722",722511,"Restr-Family","Ohio","United States",450,"2014-09-29",62,112,104,0.13800000000000001,0.249,1.806,0.1,"7 Yrs @ 6%",5,30,null,138,"No","7 FT/10 PT"]
["Yes",42,"5812","58","722",722515,"Coffee House","Aptos, CA","United States",438,"2014-07-13",62,150,200,0.14199999999999999,0.34200000000000003,2.419,null,null,0,null,null,75,"No",1]
["Yes",2654,"5812","58","722",722511,"Restr-Barbeque","Florida","United States",423,"2014-02-24",65,120,120,0.154,0.28399999999999997,1.8460000000000001,0.83,"1.5 Yrs @ 6%",0,30,null,60,"No",4]
["Yes",12375,"5812","58","722",722513,"Restr-Breakfast Only","Scottsdale, AZ","United States",421,"2014-03-04",37,37,37,8.7999999999999995E-2,8.7999999999999995E-2,1,1,null,3,40,null,null,"No"]
["Yes",12381,"5812","58","722",722511,"Restr-Sushi","Phoenix, AZ","United States",420,"2014-07-28",137,100,150,0.32600000000000001,0.23799999999999999,0.73,1,null,0,45,null,null,"No"]
["Yes",5623,"5812","58","722",722511,"Restr-Family","Florida","United States",420,"2014-06-16",82,86,91,0.19500000000000001,0.20499999999999999,1.0489999999999999,0.55000000000000004,"3 Yrs @ 6%",4,15,null,425,"No",20]
["Yes",8443,"5812","58","722",722513,"Fast Food-Pizza","Minneapolis, MN","United States",414,"2014-05-16",78,215,215,0.188,0.51900000000000002,2.7559999999999998,0.9,"1Yr @ 0%",5,25,null,null,"No","4 FT/1 PT"]
["Yes",3441,"5812","58","722",722515,"Fast Food-Yogurt","Florida","United States",401,"2014-07-31",120,205,295,0.29899999999999999,0.51100000000000001,1.708,1,null,4,135,null,null,"No",5]
["Yes",12382,"5812","58","722",722511,"Restr-Sushi","Tucson, AZ","United States",400,"2014-09-29",55,150,150,0.13800000000000001,0.375,2.7269999999999999,0.27,null,5,83,null,null,"No"]
["Yes",3182,"5812","58","722",722515,"Self Serv-Yogurt","Florida","United States",395,"2014-04-01",90,215,295,0.22800000000000001,0.54400000000000004,2.3889999999999998,null,null,2,null,null,293,"No",5]
["Yes",12373,"5812","58","722",722513,"Breakfast/Lunch","Phoenix, AZ","United States",394,"2014-01-31",120,220,220,0.30499999999999999,0.55800000000000005,1.833,0.73,null,0,75,null,null,"No"]
["Yes",12365,"5812","58","722",722511,"Restr-Family","Scottsdale, AZ","United States",384,"2014-10-02",null,155,195,null,0.40400000000000003,null,1,null,0,null,null,null,"No"]
["Yes",9372,"5812","58","722",722511,"Restr-Japanese","Orange County, CA","United States",384,"2014-08-27",36,99,99,9.4E-2,0.25800000000000001,2.75,0.5,"2 Yrs",5,null,null,null,"No","7 FT/6 PT"]
["Yes",1135,"5812","58","722",722511,"Fast Food-Sushi","Costa Mesa, CA","United States",380,"2014-03-26",45,195,195,0.11799999999999999,0.51300000000000001,4.3330000000000002,1,null,0,null,0.12,32,"No",2]
["Yes",5965,"5812","58","722",722513,"Fast Food-Smoothies","Florida","United States",375,"2014-11-10",28,125,148,7.4999999999999997E-2,0.33300000000000002,4.4640000000000004,0.62,"3 Yrs @ 0%",2,null,null,null,"No",40]
["Yes",3451,"5812","58","722",722511,"Restr-Seafood","Florida","United States",360,"2014-01-17",90,73,86,0.25,0.20300000000000001,0.81100000000000005,0.8,"2 Yrs @ 4%",2,42,null,null,"No",5]
["Yes",8037,"5812","58","722",722511,"Restr-Mexican","Los Angeles, CA","United States",360,"2014-03-11",90,87,92,0.25,0.24199999999999999,0.96699999999999997,0.39,null,3,null,null,211,"No","3 FT/10 PT"]
["Yes",7867,"5812","58","722",722511,"Restr-Mexican","Los Angeles, CA","United States",360,"2014-03-11",90,35,95,0.25,9.7000000000000003E-2,0.38900000000000001,1,null,4,null,null,null,"No","3 Ft/ 2 PT"]
["Yes",10652,"5812","58","722",722513,"Bakery Restaurant","San Francisco, CA","United States",350,"2014-07-31",31,70,130,8.8999999999999996E-2,0.2,2.258,null,null,0,null,0.13,null,"No"]
["Yes",7913,"5812","58","722",722511,"Restr-Japanese","Los Angeles, CA","United States",350,"2014-08-12",20,50,50,5.7000000000000002E-2,0.14299999999999999,2.5,1,null,0,null,null,125,"No","3 FT/1 PT"]
["Yes",11672,"5812","58","722",722515,"Fast Food-Yogurt","Texas","United States",348,"2014-12-19",75,137,170,0.216,0.39400000000000002,1.827,null,null,0,null,null,null,"No"]
["Yes",2652,"5812","58","722",722513,"Deli-Submarines","Florida","United States",345,"2014-08-31",48,64,89,0.13900000000000001,0.186,1.333,0.55000000000000004,"2 Yrs @ 4%",1,30,null,57,"No",4]
["Yes",9399,"5812","58","722",722515,"Fast Food-Ice Cream","Orange County, CA","United States",317,"2014-07-09",65,124,124,0.20499999999999999,0.39100000000000001,1.9079999999999999,1,null,4,20,0.14000000000000001,null,"No","8 FT/ 5 PT"]
["Yes",7576,"5812","58","722",722511,"Restr-Steakhouse","Iowa","United States",316,"2014-10-22",33,71,233,0.104,0.22500000000000001,2.1520000000000001,1,null,9,33,null,178,"No","2 FT/3 PT"]
["Yes",11723,"5812","58","722",722511,"Restr-Family","Texas","United States",315,"2014-03-31",18,70,99,5.7000000000000002E-2,0.222,3.8889999999999998,1,null,1,70,13,null,"No"]
["Yes",2964,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",312,"2014-06-17",68,79,85,0.218,0.253,1.1619999999999999,1,null,1,35,null,null,"No",4]
["Yes",12363,"5812","58","722",722511,"Restr-Family","Prescott, AZ","United States",304,"2014-09-12",44,90,240,0.14499999999999999,0.29599999999999999,2.0449999999999999,1,null,0,null,null,null,"No"]
["Yes",1866,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",300,"2014-12-12",60,83,90,0.2,0.27700000000000002,1.383,1,null,0,25,null,30,"No",3]
["Yes",9506,"5812","58","722",722511,"Restr W/Cocktails","Oregon","United States",295,"2014-09-02",55,110,107,0.186,0.373,2,null,null,8,null,null,null,"No","9 FT/`14 PT"]
["Yes",10327,"5812","58","722",722511,"Restr-Chinese","Riverside, CA","United States",288,"2014-09-19",24,60,125,8.3000000000000004E-2,0.20799999999999999,2.5,1,null,0,null,null,null,"No"]
["Yes",12408,"5812","58","722",722513,"Fast Food-Pizza","Gilbert, AZ","United States",288,"2014-06-09",55,55,70,0.191,0.191,1,1,null,3,30,null,null,"No"]
["Yes",10326,"5812","58","722",722511,"Fast Food-Chinese","Riverside, CA","United States",288,"2014-04-09",24,55,120,8.3000000000000004E-2,0.191,2.2919999999999998,1,null,5,null,0.1,null,"No"]
["Yes",12424,"5812","58","722",722513,"Deli W/Starbucks","Phoenix, AZ","United States",288,"2014-02-13",60,115,170,0.20799999999999999,0.39900000000000002,1.917,1,null,0,25,null,null,"No"]
["Yes",12380,"5812","58","722",722511,"Restr-Sushi","N. Dallas, TX","United States",276,"2014-12-15",36,46,46,0.13,0.16700000000000001,1.278,1,null,3,50,0.26,120,"No",4]
["Yes",8715,"5812","58","722",722513,"Fast Food-Pizza","Missouri","United States",264,"2014-06-02",60,126,135,0.22700000000000001,0.47699999999999998,2.1,0.3,"6 Mos @ 6%",4,30,8.6999999999999994E-2,null,"No","4 FT/6 PT"]
["Yes",8743,"5812","58","722",722515,"Fast Food-Ice Cream","Missouri","United States",258,"2014-05-30",-10,45,150,-3.9E-2,0.17399999999999999,null,1,null,5,null,null,297,"No","4 PT"]
["Yes",6312,"5812","58","722",722511,"Restr-Family","Florida","United States",256,"2014-06-27",44,84,99,0.17199999999999999,0.32800000000000001,1.909,1,null,2,50,null,null,"No","1 FT/1 PT"]
["Yes",12421,"5812","58","722",722513,"Deli-Sandwiches","Fountain Hills, AZ","United States",253,"2014-07-07",20,176,180,7.9000000000000001E-2,0.69599999999999995,8.8000000000000007,0.43,null,0,null,null,null,"No"]
["Yes",12415,"5812","58","722",722515,"Franchise-Yogurt Store","Phoenix, AZ","United States",250,"2014-03-10",40,125,145,0.16,0.5,3.125,1,null,3,125,null,null,"No"]
["Yes",2959,"5812","58","722",722513,"Bagel Restaurant","Florida","United States",247,"2014-05-02",73,115,115,0.29599999999999999,0.46600000000000003,1.575,1,null,1,50,null,null,"No",4]
["Yes",12430,"5812","58","722",722515,"Coffee House","Phoenix, AZ","United States",245,"2014-01-14",62,120,125,0.253,0.49,1.9350000000000001,0.8,null,2,36,null,null,"No"]
["Yes",8746,"5812","58","722",722515,"Fast Food-Ice Cream","Missouri","United States",245,"2014-05-30",22,45,150,0.09,0.184,2.0449999999999999,null,null,5,null,null,null,"No","4 PT"]
["Yes",12409,"5812","58","722",722513,"Fast Food-Pizza","Prescott, AZ","United States",241,"2014-11-04",40,75,95,0.16600000000000001,0.311,1.875,1,null,0,null,null,null,"No"]
["Yes",1152,"5812","58","722",722515,"Fast Food-Ice Cream","Dallas, TX","United States",240,"2014-06-03",105,185,215,0.438,0.77100000000000002,1.762,1,null,3,50,0.25,45,"No",2]
["Yes",12376,"5812","58","722",722513,"Breakfast/Lunch","Sun City West, AZ","United States",239,"2014-01-17",56,50,55,0.23400000000000001,0.20899999999999999,0.89300000000000002,0.4,null,0,55,null,null,"No"]
["Yes",12414,"5812","58","722",722515,"Fast Food-Yogurt","Fountain Hills, AZ","United States",235,"2014-03-03",45,93,115,0.191,0.39600000000000002,2.0670000000000002,1,null,2,115,null,null,"No"]
["Yes",7979,"5812","58","722",722513,"Fast Food-Chicken","Los Angeles, CA","United States",230,"2014-11-13",25,55,59,0.109,0.23899999999999999,2.2000000000000002,1,null,0,null,null,null,"No","3 FT/1 PT"]
["Yes",12364,"5812","58","722",722511,"Restr-Diner","San Diego, CA","United States",220,"2014-10-06",40,67,77,0.182,0.30499999999999999,1.675,0.5,"4 Yrs @ 6%",3,30,0.09,210,"No",5]
["Yes",12370,"5812","58","722",722513,"Restr-Breakfast Only","Gilbert, AZ","United States",220,"2014-12-22",66,109,109,0.3,0.495,1.6519999999999999,0.47,null,2,40,null,null,"No"]
["Yes",4645,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",208,"2014-02-14",1,33,60,5.0000000000000001E-3,0.159,33,0.66,"2 Mos @ 0%",3,null,0.21,null,"No",9]
["Yes",4612,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",208,"2014-11-26",40,150,159,0.192,0.72099999999999997,3.75,1,null,3,40,null,360,"No",9]
["Yes",729,"5812","58","722",722511,"Restr-Ethnic Food","CN-Ontario","Canada",207,"2014-02-07",51,65,80,0.246,0.314,1.2749999999999999,1,null,0,65,0.18,null,"No",1]
["Yes",2307,"5812","58","722",722513,"Deli-Office Building","Florida","United States",200,"2014-06-30",43,65,77,0.215,0.32500000000000001,1.512,0.31,null,0,20,null,null,"No",3]
["Yes",12378,"5812","58","722",722515,"Restr-Coffee Shop","Gold Canyon, AZ","United States",195,"2014-09-29",55,158,165,0.28199999999999997,0.81,2.8730000000000002,0.32,null,2,3,null,null,"No"]
["Yes",8442,"5812","58","722",722513,"Fast Food-Italian/Pizza","Minneapolis, MN","United States",190,"2014-12-01",50,50,50,0.26300000000000001,0.26300000000000001,1,1,null,0,25,0.11,null,"No","4 FT/1 PT"]
["Yes",6544,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",175,"2014-05-06",84,80,159,0.48,0.45700000000000002,0.95199999999999996,1,null,1,50,0.04,147,"No","1 FT/3 PT"]
["Yes",3452,"5812","58","722",722511,"Restr-Family","Florida","United States",174,"2014-06-30",48,48,59,0.27600000000000002,0.27600000000000002,1,1,null,1,38,null,null,"No",5]
["Yes",4498,"5812","58","722",722511,"Restr-Family","Florida","United States",170,"2014-06-04",47,35,47,0.27600000000000002,0.20599999999999999,0.745,0.2,"4Yrs @ 6%",3,27,null,null,"No",8]
["Yes",9420,"5812","58","722",722515,"Coffee/Tea House","Orange County, CA","United States",168,"2014-05-30",18,85,105,0.107,0.50600000000000001,4.7220000000000004,1,null,5,null,null,null,"No","8 FT/1 PT"]
["Yes",12372,"5812","58","722",722513,"Breakfast/Lunch","Mesa AZ","United States",158,"2014-04-14",51,50,66,0.32300000000000001,0.316,0.98,null,null,1,16,null,null,"No"]
["Yes",5289,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",144,"2014-01-15",28,26,37,0.19400000000000001,0.18099999999999999,0.92900000000000005,1,null,3,16,0.17,null,"No",14]
["Yes",12394,"5812","58","722",722513,"Snack Stand","Phoenix, AZ","United States",140,"2014-03-03",40,50,55,0.28599999999999998,0.35699999999999998,1.25,1,null,1,50,null,null,"No"]
["Yes",1898,"5812","58","722",722511,"Restr-Family","Florida","United States",132,"2014-10-31",38,89,89,0.28799999999999998,0.67400000000000004,2.3420000000000001,1,null,1,8,null,180,"No",3]
["Yes",12374,"5812","58","722",722513,"Breakfast/Lunch","Scottsdale, AZ","United States",125,"2014-12-15",56,57,60,0.44800000000000001,0.45600000000000002,1.018,0.44,null,0,35,null,null,"No"]
["Yes",12013,"5812","58","722",722515,"Espresso Kiosk","Washington","United States",125,"2014-10-31",29,50,50,0.23200000000000001,0.4,1.724,1,null,2,40,0.12,null,"Yes"]
["Yes",2717,"5812","58","722",722515,"Fast Food-Yogurt","Florida","United States",120,"2014-04-30",20,48,85,0.16700000000000001,0.4,2.4,1,null,0,null,null,120,"No",4]
["Yes",9421,"5812","58","722",722511,"Deli-Sandwiches","Orange County, CA","United States",85,"2014-06-25",0,65,55,0,0.76500000000000001,null,1,null,3,null,null,null,"No","8 FT/1 PT"]
["Yes",12395,"5812","58","722",722513,"Hot Dog Stand","Tempe, AZ","United States",75,"2014-03-04",45,50,60,0.6,0.66700000000000004,1.111,1,null,2,25,null,null,"No"]
["Yes",4200,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",73,"2014-10-03",28,30,35,0.38400000000000001,0.41099999999999998,1.071,1,null,5,21,null,null,"No",7]
["Yes",9513,{"$f":"TEXT(\"5813\",\"0000\")","v":"5813"},"58","722",722410,"Adult Entertainment","Oregon","United States",1566,"2014-12-22",591,1025,1500,0.377,0.65500000000000003,1.734,1,null,2,385,null,155,"No","9 FT/1 PT"]
["Yes",10198,"5813","58","722",722410,"Cocktail Lounge","Redwood City, CA","United States",1134,"2014-10-15",231,650,650,0.20399999999999999,0.57299999999999995,2.8140000000000001,0.3,null,0,null,null,560,"No"]
["Yes",3873,"5813","58","722",722410,"Cocktail Lounge","Florida","United States",996,"2014-02-28",61,435,475,6.0999999999999999E-2,0.437,7.1310000000000002,1,null,0,55,null,1992,"No",6]
["Yes",6604,"5813","58","722",722410,"Brew Pub W/Food","Florida","United States",645,"2014-12-19",128,197,272,0.19800000000000001,0.30499999999999999,1.5389999999999999,0.4,null,3,50,null,null,"No","1 Ft/3 PT"]
["Yes",8019,"5813","58","722",722410,"Cocktails W/Food","Los Angeles, CA","United States",576,"2014-03-12",144,275,295,0.25,0.47699999999999998,1.91,1,null,0,null,0.09,null,"No","3 FT/1 PT"]
["Yes",12445,"5813","58","722",722410,"Sports Bar","Tucson AZ","United States",500,"2014-10-15",50,79,89,0.1,0.158,1.58,0.7,null,7,50,null,null,"No"]
["Yes",10719,"5813","58","722",722410,"Cocktail Lounge","San Jose, CA","United States",235,"2014-10-15",null,50,129,null,0.21299999999999999,null,1,null,0,null,null,null,"No"]
["Yes",12444,"5813","58","722",722410,"Cocktail Lounge","Phoenix, AZ","United States",200,"2014-04-09",null,150,175,null,0.75,null,0.1,null,0,110,null,null,"No"]

{"sheet":"Trans Selected","index":6,"n_rows":136,"n_cols":24,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
["TransactionID","SICCode","SICCodeGeneral","NAICSGeneral","NAICSCode","BusinessDescription","Area","Country","AnnualGross","SaleDate","SDE","SalePrice","AskPrice","SDEtoAnnualGross","SalePriceToAnnualGross","SalePriceToSDE","PercentDown","Terms","InventoryAmount","FFE","RentToAnnualGross","DaysOnMarket","FranchiseRoyalty","NumberOfEmployees"]
[11351,{"$f":"TEXT(\"5812\",\"0000\")","v":"5812"},{"$f":"TEXT(\"58\",\"00\")","v":"58"},{"$f":"TEXT(\"722\",\"000\")","v":"722"},722513,"Fast Food-Burgers","Southeast","United States",2550,"2014-03-31",315,1300,1300,0.124,0.51,4.1269999999999998,null,null,13,null,null,null,"No"]
[10989,"5812","58","722",722513,"Fast Food-Burgers","South Atlantic","United States",2500,"2014-02-28",505,2200,2400,0.20200000000000001,0.88,4.3559999999999999,null,null,15,null,null,null,"No"]
[4033,"5812","58","722",722511,"Restr-Family","Florida","United States",2235,"2014-04-14",342,650,975,0.153,0.29099999999999998,1.901,1,null,0,50,null,120,"No",7]
[5394,"5812","58","722",722511,"Restr-Ethnic","Florida","United States",2190,"2014-05-05",413,492,642,0.189,0.22500000000000001,1.1910000000000001,0.2,"1 Yr @ 4%",8,89,null,65,"Y-5%",15]
[11659,"5812","58","722",722511,"Restr W/Cocktails","Texas","United States",1702,"2014-07-14",143,388,783,8.4000000000000005E-2,0.22800000000000001,2.7130000000000001,0.3,null,0,15,null,null,"No"]
[1059,"5812","58","722",722513,"Bakery-Restaurant","Colorado","United States",1588,"2014-02-28",247,500,500,0.156,0.315,2.024,0.48,null,25,100,null,150,"No",2]
[10765,"5812","58","722",722511,"Restr-Family","San Jose, CA","United States",1543,"2014-04-28",180,250,395,0.11700000000000001,0.16200000000000001,1.389,null,null,0,null,null,null,"No"]
[7403,"5812","58","722",722511,"Restr W/Cocktails","Houston, TX","United States",1527,"2014-12-05",356,700,750,0.23300000000000001,0.45800000000000002,1.966,null,null,0,359,null,null,"No","2 FT/10 PT"]
[8932,"5812","58","722",722511,"Restr-Family","New England","United States",1411,"2014-05-19",258,325,775,0.183,0.23,1.26,0.16,"20 Yrs @ 2%",11,259,null,36,"No","5 FT/3 PT"]
[3538,"5812","58","722",722511,"Restr-Italian","Florida","United States",1381,"2014-06-30",219,400,450,0.159,0.28999999999999998,1.8260000000000001,0.45,"5 Yrs @ 5%",1,80,null,null,"No",5]
[11837,"5812","58","722",722511,"Mexican Buffett","Tyler, TX","United States",1363,"2014-03-28",229,229,239,0.16800000000000001,0.16800000000000001,1,1,null,10,130,8.9999999999999993E-3,null,"No"]
[6513,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",1200,"2014-09-08",315,575,650,0.26300000000000001,0.47899999999999998,1.825,1,null,0,125,null,null,"No","1 FT/2 PT"]
[10692,"5812","58","722",722513,"Fast Food Cafe","San Francisco, CA","United States",1134,"2014-10-15",231,650,650,0.20399999999999999,0.57299999999999995,2.8140000000000001,0.3,null,0,null,0.05,null,"No"]
[4137,"5812","58","722",722511,"Restr-Family","Florida","United States",1100,"2014-07-07",150,345,384,0.13600000000000001,0.314,2.2999999999999998,1,null,15,50,null,292,"No",7]
[11035,"5812","58","722",722511,"Restr-Family","South Dakota","United States",1100,"2014-05-21",148,532,542,0.13500000000000001,0.48399999999999999,3.5950000000000002,null,"5.5 Yrs @ 5.5%",8,null,null,null,"No"]
[9321,"5812","58","722",722511,"Restr-Family","Oklahoma","United States",1078,"2014-08-04",118,341,391,0.109,0.316,2.89,1,null,9,164,null,null,"No","7 FT/2 PT"]
[3777,"5812","58","722",722511,"Restr W/Cocktails","Florida","United States",1050,"2014-09-10",97,100,115,9.1999999999999998E-2,9.5000000000000001E-2,1.0309999999999999,0.5,"4 Yrs @ 6%",10,50,null,192,"No",6]
[6688,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",1036,"2014-08-25",174,115,190,0.16800000000000001,0.111,0.66100000000000003,1,null,35,null,null,null,"No","1 FT/5 PT"]
[7525,"5812","58","722",722511,"Restr-Family","Incline Village, NV","United States",991,"2014-09-02",117,200,259,0.11799999999999999,0.20200000000000001,1.7090000000000001,0.26,null,0,null,null,null,"No","2 FT/2 PT"]
[9210,"5812","58","722",722511,"Restr-Family","Northern Nevada","United States",991,"2014-09-02",117,200,255,0.11799999999999999,0.20200000000000001,1.7090000000000001,0.26,"5 Yrs @ 6%",4,null,4.2000000000000003E-2,100,"No","6 FT/6 PT"]
[7580,"5812","58","722",722511,"Restr-Family","Iowa","United States",960,"2014-02-28",203,408,417,0.21099999999999999,0.42499999999999999,2.0099999999999998,null,null,0,175,null,231,"No","2 FT/3 PT"]
[12361,"5812","58","722",722511,"Restr-Family","Peoria, AZ","United States",932,"2014-12-03",null,295,295,null,0.317,null,1,null,0,null,null,null,"No"]
[5389,"5812","58","722",722511,"Restr-Family","Florida","United States",858,"2014-01-09",42,92,85,4.9000000000000002E-2,0.107,2.19,0.6,null,8,null,null,null,"No",15]
[4034,"5812","58","722",722511,"Restr-Barbeque","Florida","United States",850,"2014-11-30",80,100,175,9.4E-2,0.11799999999999999,1.25,0.75,"2 Yrs @ 0%",0,null,null,120,"No",7]
[3983,"5812","58","722",722513,"Fast Food Franchise","Florida","United States",840,"2014-09-30",85,120,145,0.10100000000000001,0.14299999999999999,1.4119999999999999,0.92,"1 Yr",0,null,null,null,"No",6]
[3996,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",814,"2014-08-04",58,130,145,7.0999999999999994E-2,0.16,2.2410000000000001,1,null,5,35,null,null,"Y-12.5%",6]
[10694,"5812","58","722",722515,"Franchise-Soft Serve","San Francisco, CA","United States",790,"2014-08-01",114,185,194,0.14399999999999999,0.23400000000000001,1.623,null,null,5,null,3.7999999999999999E-2,null,"No"]
[8230,"5812","58","722",722513,"Fast Food-Yogurt","Massachusetts","United States",775,"2014-06-13",193,550,550,0.249,0.71,2.85,1,null,0,125,null,null,"No","3 FT/4 PT"]
[11721,"5812","58","722",722511,"Restr-Family","Texas","United States",752,"2014-04-30",40,355,432,5.2999999999999999E-2,0.47199999999999998,8.875,null,null,18,59,0.08,null,"No"]
[3660,"5812","58","722",722511,"Restr-Family","Florida","United States",735,"2014-01-31",251,350,450,0.34100000000000003,0.47599999999999998,1.3939999999999999,0.46,"3 Yrs @ 5%",0,50,null,240,"No",6]
[7944,"5812","58","722",722511,"Restr-Japanese","Los Angeles, CA","United States",720,"2014-10-31",12,149,149,1.7000000000000001E-2,0.20699999999999999,12.417,1,null,0,null,null,258,"No","3 FT/1 PT"]
[12426,"5812","58","722",722513,"Deli W/Starbucks","Tempe, AZ","United States",720,"2014-03-28",204,400,475,0.28299999999999997,0.55600000000000005,1.9610000000000001,1,null,0,35,null,null,"No"]
[3788,"5812","58","722",722511,"Restr-Steakhouse","Florida","United States",720,"2014-02-28",240,182,195,0.33300000000000002,0.253,0.75800000000000001,0.48,"2 Mos @ 0%",5,null,null,210,"No",6]
[1061,"5812","58","722",722513,"Restr-Breakfast Only","Colorado","United States",701,"2014-03-31",86,222,222,0.123,0.317,2.581,1,null,3,35,null,150,"No",2]
[12332,"5812","58","722",722511,"Restr-Barbeque","Casa Grande, AZ","United States",700,"2014-12-16",59,30,60,8.4000000000000005E-2,4.2999999999999997E-2,0.50800000000000001,1,null,0,10,null,null,"No"]
[5313,"5812","58","722",722511,"Restr-Family","Florida","United States",700,"2014-04-24",75,95,140,0.107,0.13600000000000001,1.2669999999999999,1,null,0,50,7.0000000000000007E-2,85,"No",15]
[7408,"5812","58","722",722513,"Fast Food-Mexican","Houston, TX","United States",658,"2014-01-02",183,450,500,0.27800000000000002,0.68400000000000005,2.4590000000000001,1,null,0,293,0.12,948,"No","2 FT/11 PT"]
[4838,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",653,"2014-06-09",97,162,194,0.14899999999999999,0.248,1.67,0.77,"3 Yrs @ 5%",5,66,null,null,"No",10]
[3532,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",650,"2014-04-30",195,168,210,0.3,0.25800000000000001,0.86199999999999999,1,null,0,150,null,null,"No",5]
[11018,"5812","58","722",722511,"Restr W/Cocktails","South Dakota","United States",644,"2014-08-12",82,25,328,0.127,3.9E-2,0.30499999999999999,null,1,61,25,null,null,"No"]
[10769,"5812","58","722",722513,"Franch-Sandwiches","San Jose, CA","United States",633,"2014-03-11",113,490,550,0.17899999999999999,0.77400000000000002,4.3360000000000003,null,null,0,null,null,null,"No"]
[9425,"5812","58","722",722515,"Fast Food-Yogurt","Orange County, CA","United States",603,"2014-02-21",52,104,104,8.5999999999999993E-2,0.17199999999999999,2,null,null,0,null,null,null,"No","8 FT/1 PT"]
[7923,"5812","58","722",722511,"Restr-Family","Los Angeles, CA","United States",600,"2014-10-21",180,450,450,0.3,0.75,2.5,1,null,0,null,null,160,"No","3 FT/1 PT"]
[7921,"5812","58","722",722515,"Coffee/Sandwiches","Los Angeles, CA","United States",576,"2014-03-10",144,275,295,0.25,0.47699999999999998,1.91,1,null,0,null,null,158,"No","3 FT/1 PT"]
[5111,"5812","58","722",722511,"Restr-Family","Florida","United States",575,"2014-12-05",115,140,204,0.2,0.24299999999999999,1.2170000000000001,0.93,"10 Yrs @ 6%",5,50,null,null,"No",12]
[3779,"5812","58","722",722511,"Restr-Family","Florida","United States",575,"2014-12-31",136,161,162,0.23699999999999999,0.28000000000000003,1.1839999999999999,null,null,3,45,null,200,"No",6]
[12362,"5812","58","722",722511,"Restr-Family","Phoenix, AZ","United States",560,"2014-03-28",71,70,100,0.127,0.125,0.98599999999999999,1,null,0,50,null,null,"No"]
[6374,"5812","58","722",722511,"Restr-Family","Florida","United States",550,"2014-09-19",190,251,271,0.34499999999999997,0.45600000000000002,1.321,1,null,4,55,null,7,"No","1 FT/2 PT"]
[8030,"5812","58","722",722511,"Restr-Family","Los Angeles, CA","United States",550,"2014-07-22",0,195,195,0,0.35499999999999998,null,1,null,3,45,null,null,"No","3 FT/1 PT"]
[10997,"5812","58","722",722513,"Bakery Restaurant","South Carolina","United States",525,"2014-06-06",110,225,225,0.21,0.42899999999999999,2.0449999999999999,0.22,"5 Yrs @ 6%",2,25,6.9000000000000006E-2,null,"No"]
[3146,"5812","58","722",722511,"Restr-Italian/Pizza","Florida","United States",519,"2014-08-31",138,115,140,0.26600000000000001,0.222,0.83299999999999996,1,null,5,80,null,360,"Yes",4]
[12327,"5812","58","722",722511,"Restr W/Cocktails","Tempe, AZ","United States",515,"2014-02-14",75,100,160,0.14599999999999999,0.19400000000000001,1.333,1,null,0,160,null,null,"No"]
[3453,"5812","58","722",722511,"Restr-Family","Florida","United States",514,"2014-11-30",137,219,244,0.26700000000000002,0.42599999999999999,1.599,0.67,"3 Yrs @ 6%",6,33,null,null,"No",5]
[10668,"5812","58","722",722515,"Tea House","San Francisco, CA","United States",477,"2014-06-13",80,97,132,0.16800000000000001,0.20300000000000001,1.2130000000000001,0.8,"3 Yrs@ 5%",28,null,0.25,null,"No"]
[10748,"5812","58","722",722515,"Tea House","San Jose, CA","United States",477,"2014-06-13",80,125,160,0.16800000000000001,0.26200000000000001,1.5629999999999999,null,null,0,null,null,null,"No"]
[5547,"5812","58","722",722513,"Fast Food-Yogurt","Florida","United States",475,"2014-08-28",135,413,425,0.28399999999999997,0.86899999999999999,3.0590000000000002,null,null,0,125,null,null,"No",18]
[3446,"5812","58","722",722513,"Restr-Breakfast/Lunch","Florida","United States",470,"2014-04-30",95,139,149,0.20200000000000001,0.29599999999999999,1.4630000000000001,1,null,10,60,null,null,"No",5]
[12425,"5812","58","722",722513,"Deli W/Starbucks","Phoenix, AZ","United States",468,"2014-03-28",132,260,275,0.28199999999999997,0.55600000000000005,1.97,0.81,null,0,60,null,null,"No"]
[9291,"5812","58","722",722511,"Restr-Family","Ohio","United States",450,"2014-09-29",62,112,104,0.13800000000000001,0.249,1.806,0.1,"7 Yrs @ 6%",5,30,null,138,"No","7 FT/10 PT"]
[42,"5812","58","722",722515,"Coffee House","Aptos, CA","United States",438,"2014-07-13",62,150,200,0.14199999999999999,0.34200000000000003,2.419,null,null,0,null,null,75,"No",1]
[2654,"5812","58","722",722511,"Restr-Barbeque","Florida","United States",423,"2014-02-24",65,120,120,0.154,0.28399999999999997,1.8460000000000001,0.83,"1.5 Yrs @ 6%",0,30,null,60,"No",4]
[12375,"5812","58","722",722513,"Restr-Breakfast Only","Scottsdale, AZ","United States",421,"2014-03-04",37,37,37,8.7999999999999995E-2,8.7999999999999995E-2,1,1,null,3,40,null,null,"No"]
[12381,"5812","58","722",722511,"Restr-Sushi","Phoenix, AZ","United States",420,"2014-07-28",137,100,150,0.32600000000000001,0.23799999999999999,0.73,1,null,0,45,null,null,"No"]
[5623,"5812","58","722",722511,"Restr-Family","Florida","United States",420,"2014-06-16",82,86,91,0.19500000000000001,0.20499999999999999,1.0489999999999999,0.55000000000000004,"3 Yrs @ 6%",4,15,null,425,"No",20]
[8443,"5812","58","722",722513,"Fast Food-Pizza","Minneapolis, MN","United States",414,"2014-05-16",78,215,215,0.188,0.51900000000000002,2.7559999999999998,0.9,"1Yr @ 0%",5,25,null,null,"No","4 FT/1 PT"]
[3441,"5812","58","722",722515,"Fast Food-Yogurt","Florida","United States",401,"2014-07-31",120,205,295,0.29899999999999999,0.51100000000000001,1.708,1,null,4,135,null,null,"No",5]
[12382,"5812","58","722",722511,"Restr-Sushi","Tucson, AZ","United States",400,"2014-09-29",55,150,150,0.13800000000000001,0.375,2.7269999999999999,0.27,null,5,83,null,null,"No"]
[3182,"5812","58","722",722515,"Self Serv-Yogurt","Florida","United States",395,"2014-04-01",90,215,295,0.22800000000000001,0.54400000000000004,2.3889999999999998,null,null,2,null,null,293,"No",5]
[12373,"5812","58","722",722513,"Breakfast/Lunch","Phoenix, AZ","United States",394,"2014-01-31",120,220,220,0.30499999999999999,0.55800000000000005,1.833,0.73,null,0,75,null,null,"No"]
[12365,"5812","58","722",722511,"Restr-Family","Scottsdale, AZ","United States",384,"2014-10-02",null,155,195,null,0.40400000000000003,null,1,null,0,null,null,null,"No"]
[9372,"5812","58","722",722511,"Restr-Japanese","Orange County, CA","United States",384,"2014-08-27",36,99,99,9.4E-2,0.25800000000000001,2.75,0.5,"2 Yrs",5,null,null,null,"No","7 FT/6 PT"]
[1135,"5812","58","722",722511,"Fast Food-Sushi","Costa Mesa, CA","United States",380,"2014-03-26",45,195,195,0.11799999999999999,0.51300000000000001,4.3330000000000002,1,null,0,null,0.12,32,"No",2]
[5965,"5812","58","722",722513,"Fast Food-Smoothies","Florida","United States",375,"2014-11-10",28,125,148,7.4999999999999997E-2,0.33300000000000002,4.4640000000000004,0.62,"3 Yrs @ 0%",2,null,null,null,"No",40]
[3451,"5812","58","722",722511,"Restr-Seafood","Florida","United States",360,"2014-01-17",90,73,86,0.25,0.20300000000000001,0.81100000000000005,0.8,"2 Yrs @ 4%",2,42,null,null,"No",5]
[8037,"5812","58","722",722511,"Restr-Mexican","Los Angeles, CA","United States",360,"2014-03-11",90,87,92,0.25,0.24199999999999999,0.96699999999999997,0.39,null,3,null,null,211,"No","3 FT/10 PT"]
[7867,"5812","58","722",722511,"Restr-Mexican","Los Angeles, CA","United States",360,"2014-03-11",90,35,95,0.25,9.7000000000000003E-2,0.38900000000000001,1,null,4,null,null,null,"No","3 Ft/ 2 PT"]
[10652,"5812","58","722",722513,"Bakery Restaurant","San Francisco, CA","United States",350,"2014-07-31",31,70,130,8.8999999999999996E-2,0.2,2.258,null,null,0,null,0.13,null,"No"]
[7913,"5812","58","722",722511,"Restr-Japanese","Los Angeles, CA","United States",350,"2014-08-12",20,50,50,5.7000000000000002E-2,0.14299999999999999,2.5,1,null,0,null,null,125,"No","3 FT/1 PT"]
[11672,"5812","58","722",722515,"Fast Food-Yogurt","Texas","United States",348,"2014-12-19",75,137,170,0.216,0.39400000000000002,1.827,null,null,0,null,null,null,"No"]
[2652,"5812","58","722",722513,"Deli-Submarines","Florida","United States",345,"2014-08-31",48,64,89,0.13900000000000001,0.186,1.333,0.55000000000000004,"2 Yrs @ 4%",1,30,null,57,"No",4]
[9399,"5812","58","722",722515,"Fast Food-Ice Cream","Orange County, CA","United States",317,"2014-07-09",65,124,124,0.20499999999999999,0.39100000000000001,1.9079999999999999,1,null,4,20,0.14000000000000001,null,"No","8 FT/ 5 PT"]
[7576,"5812","58","722",722511,"Restr-Steakhouse","Iowa","United States",316,"2014-10-22",33,71,233,0.104,0.22500000000000001,2.1520000000000001,1,null,9,33,null,178,"No","2 FT/3 PT"]
[11723,"5812","58","722",722511,"Restr-Family","Texas","United States",315,"2014-03-31",18,70,99,5.7000000000000002E-2,0.222,3.8889999999999998,1,null,1,70,13,null,"No"]
[2964,"5812","58","722",722513,"Fast Food-Pizza","Florida","United States",312,"2014-06-17",68,79,85,0.218,0.253,1.1619999999999999,1,null,1,35,null,null,"No",4]
[12363,"5812","58","722",722511,"Restr-Family","Prescott, AZ","United States",304,"2014-09-12",44,90,240,0.14499999999999999,0.29599999999999999,2.0449999999999999,1,null,0,null,null,null,"No"]
[1866,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",300,"2014-12-12",60,83,90,0.2,0.27700000000000002,1.383,1,null,0,25,null,30,"No",3]
[9506,"5812","58","722",722511,"Restr W/Cocktails","Oregon","United States",295,"2014-09-02",55,110,107,0.186,0.373,2,null,null,8,null,null,null,"No","9 FT/`14 PT"]
[10327,"5812","58","722",722511,"Restr-Chinese","Riverside, CA","United States",288,"2014-09-19",24,60,125,8.3000000000000004E-2,0.20799999999999999,2.5,1,null,0,null,null,null,"No"]
[12408,"5812","58","722",722513,"Fast Food-Pizza","Gilbert, AZ","United States",288,"2014-06-09",55,55,70,0.191,0.191,1,1,null,3,30,null,null,"No"]
[10326,"5812","58","722",722511,"Fast Food-Chinese","Riverside, CA","United States",288,"2014-04-09",24,55,120,8.3000000000000004E-2,0.191,2.2919999999999998,1,null,5,null,0.1,null,"No"]
[12424,"5812","58","722",722513,"Deli W/Starbucks","Phoenix, AZ","United States",288,"2014-02-13",60,115,170,0.20799999999999999,0.39900000000000002,1.917,1,null,0,25,null,null,"No"]
[12380,"5812","58","722",722511,"Restr-Sushi","N. Dallas, TX","United States",276,"2014-12-15",36,46,46,0.13,0.16700000000000001,1.278,1,null,3,50,0.26,120,"No",4]
[8715,"5812","58","722",722513,"Fast Food-Pizza","Missouri","United States",264,"2014-06-02",60,126,135,0.22700000000000001,0.47699999999999998,2.1,0.3,"6 Mos @ 6%",4,30,8.6999999999999994E-2,null,"No","4 FT/6 PT"]
[8743,"5812","58","722",722515,"Fast Food-Ice Cream","Missouri","United States",258,"2014-05-30",-10,45,150,-3.9E-2,0.17399999999999999,null,1,null,5,null,null,297,"No","4 PT"]
[6312,"5812","58","722",722511,"Restr-Family","Florida","United States",256,"2014-06-27",44,84,99,0.17199999999999999,0.32800000000000001,1.909,1,null,2,50,null,null,"No","1 FT/1 PT"]
[12421,"5812","58","722",722513,"Deli-Sandwiches","Fountain Hills, AZ","United States",253,"2014-07-07",20,176,180,7.9000000000000001E-2,0.69599999999999995,8.8000000000000007,0.43,null,0,null,null,null,"No"]
[12415,"5812","58","722",722515,"Franchise-Yogurt Store","Phoenix, AZ","United States",250,"2014-03-10",40,125,145,0.16,0.5,3.125,1,null,3,125,null,null,"No"]
[2959,"5812","58","722",722513,"Bagel Restaurant","Florida","United States",247,"2014-05-02",73,115,115,0.29599999999999999,0.46600000000000003,1.575,1,null,1,50,null,null,"No",4]
[12430,"5812","58","722",722515,"Coffee House","Phoenix, AZ","United States",245,"2014-01-14",62,120,125,0.253,0.49,1.9350000000000001,0.8,null,2,36,null,null,"No"]
[8746,"5812","58","722",722515,"Fast Food-Ice Cream","Missouri","United States",245,"2014-05-30",22,45,150,0.09,0.184,2.0449999999999999,null,null,5,null,null,null,"No","4 PT"]
[12409,"5812","58","722",722513,"Fast Food-Pizza","Prescott, AZ","United States",241,"2014-11-04",40,75,95,0.16600000000000001,0.311,1.875,1,null,0,null,null,null,"No"]
[1152,"5812","58","722",722515,"Fast Food-Ice Cream","Dallas, TX","United States",240,"2014-06-03",105,185,215,0.438,0.77100000000000002,1.762,1,null,3,50,0.25,45,"No",2]
[12376,"5812","58","722",722513,"Breakfast/Lunch","Sun City West, AZ","United States",239,"2014-01-17",56,50,55,0.23400000000000001,0.20899999999999999,0.89300000000000002,0.4,null,0,55,null,null,"No"]
[12414,"5812","58","722",722515,"Fast Food-Yogurt","Fountain Hills, AZ","United States",235,"2014-03-03",45,93,115,0.191,0.39600000000000002,2.0670000000000002,1,null,2,115,null,null,"No"]
[7979,"5812","58","722",722513,"Fast Food-Chicken","Los Angeles, CA","United States",230,"2014-11-13",25,55,59,0.109,0.23899999999999999,2.2000000000000002,1,null,0,null,null,null,"No","3 FT/1 PT"]
[12364,"5812","58","722",722511,"Restr-Diner","San Diego, CA","United States",220,"2014-10-06",40,67,77,0.182,0.30499999999999999,1.675,0.5,"4 Yrs @ 6%",3,30,0.09,210,"No",5]
[12370,"5812","58","722",722513,"Restr-Breakfast Only","Gilbert, AZ","United States",220,"2014-12-22",66,109,109,0.3,0.495,1.6519999999999999,0.47,null,2,40,null,null,"No"]
[4645,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",208,"2014-02-14",1,33,60,5.0000000000000001E-3,0.159,33,0.66,"2 Mos @ 0%",3,null,0.21,null,"No",9]
[4612,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",208,"2014-11-26",40,150,159,0.192,0.72099999999999997,3.75,1,null,3,40,null,360,"No",9]
[729,"5812","58","722",722511,"Restr-Ethnic Food","CN-Ontario","Canada",207,"2014-02-07",51,65,80,0.246,0.314,1.2749999999999999,1,null,0,65,0.18,null,"No",1]
[2307,"5812","58","722",722513,"Deli-Office Building","Florida","United States",200,"2014-06-30",43,65,77,0.215,0.32500000000000001,1.512,0.31,null,0,20,null,null,"No",3]
[12378,"5812","58","722",722515,"Restr-Coffee Shop","Gold Canyon, AZ","United States",195,"2014-09-29",55,158,165,0.28199999999999997,0.81,2.8730000000000002,0.32,null,2,3,null,null,"No"]
[8442,"5812","58","722",722513,"Fast Food-Italian/Pizza","Minneapolis, MN","United States",190,"2014-12-01",50,50,50,0.26300000000000001,0.26300000000000001,1,1,null,0,25,0.11,null,"No","4 FT/1 PT"]
[6544,"5812","58","722",722511,"Bagel Restaurant","Florida","United States",175,"2014-05-06",84,80,159,0.48,0.45700000000000002,0.95199999999999996,1,null,1,50,0.04,147,"No","1 FT/3 PT"]
[3452,"5812","58","722",722511,"Restr-Family","Florida","United States",174,"2014-06-30",48,48,59,0.27600000000000002,0.27600000000000002,1,1,null,1,38,null,null,"No",5]
[4498,"5812","58","722",722511,"Restr-Family","Florida","United States",170,"2014-06-04",47,35,47,0.27600000000000002,0.20599999999999999,0.745,0.2,"4Yrs @ 6%",3,27,null,null,"No",8]
[9420,"5812","58","722",722515,"Coffee/Tea House","Orange County, CA","United States",168,"2014-05-30",18,85,105,0.107,0.50600000000000001,4.7220000000000004,1,null,5,null,null,null,"No","8 FT/1 PT"]
[12372,"5812","58","722",722513,"Breakfast/Lunch","Mesa AZ","United States",158,"2014-04-14",51,50,66,0.32300000000000001,0.316,0.98,null,null,1,16,null,null,"No"]
[5289,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",144,"2014-01-15",28,26,37,0.19400000000000001,0.18099999999999999,0.92900000000000005,1,null,3,16,0.17,null,"No",14]
[12394,"5812","58","722",722513,"Snack Stand","Phoenix, AZ","United States",140,"2014-03-03",40,50,55,0.28599999999999998,0.35699999999999998,1.25,1,null,1,50,null,null,"No"]
[1898,"5812","58","722",722511,"Restr-Family","Florida","United States",132,"2014-10-31",38,89,89,0.28799999999999998,0.67400000000000004,2.3420000000000001,1,null,1,8,null,180,"No",3]
[12374,"5812","58","722",722513,"Breakfast/Lunch","Scottsdale, AZ","United States",125,"2014-12-15",56,57,60,0.44800000000000001,0.45600000000000002,1.018,0.44,null,0,35,null,null,"No"]
[12013,"5812","58","722",722515,"Espresso Kiosk","Washington","United States",125,"2014-10-31",29,50,50,0.23200000000000001,0.4,1.724,1,null,2,40,0.12,null,"Yes"]
[2717,"5812","58","722",722515,"Fast Food-Yogurt","Florida","United States",120,"2014-04-30",20,48,85,0.16700000000000001,0.4,2.4,1,null,0,null,null,120,"No",4]
[9421,"5812","58","722",722511,"Deli-Sandwiches","Orange County, CA","United States",85,"2014-06-25",0,65,55,0,0.76500000000000001,null,1,null,3,null,null,null,"No","8 FT/1 PT"]
[12395,"5812","58","722",722513,"Hot Dog Stand","Tempe, AZ","United States",75,"2014-03-04",45,50,60,0.6,0.66700000000000004,1.111,1,null,2,25,null,null,"No"]
[4200,"5812","58","722",722513,"Fast Food-Ice Cream","Florida","United States",73,"2014-10-03",28,30,35,0.38400000000000001,0.41099999999999998,1.071,1,null,5,21,null,null,"No",7]
[9513,{"$f":"TEXT(\"5813\",\"0000\")","v":"5813"},"58","722",722410,"Adult Entertainment","Oregon","United States",1566,"2014-12-22",591,1025,1500,0.377,0.65500000000000003,1.734,1,null,2,385,null,155,"No","9 FT/1 PT"]
[10198,"5813","58","722",722410,"Cocktail Lounge","Redwood City, CA","United States",1134,"2014-10-15",231,650,650,0.20399999999999999,0.57299999999999995,2.8140000000000001,0.3,null,0,null,null,560,"No"]
[3873,"5813","58","722",722410,"Cocktail Lounge","Florida","United States",996,"2014-02-28",61,435,475,6.0999999999999999E-2,0.437,7.1310000000000002,1,null,0,55,null,1992,"No",6]
[6604,"5813","58","722",722410,"Brew Pub W/Food","Florida","United States",645,"2014-12-19",128,197,272,0.19800000000000001,0.30499999999999999,1.5389999999999999,0.4,null,3,50,null,null,"No","1 Ft/3 PT"]
[8019,"5813","58","722",722410,"Cocktails W/Food","Los Angeles, CA","United States",576,"2014-03-12",144,275,295,0.25,0.47699999999999998,1.91,1,null,0,null,0.09,null,"No","3 FT/1 PT"]
[12445,"5813","58","722",722410,"Sports Bar","Tucson AZ","United States",500,"2014-10-15",50,79,89,0.1,0.158,1.58,0.7,null,7,50,null,null,"No"]
[10719,"5813","58","722",722410,"Cocktail Lounge","San Jose, CA","United States",235,"2014-10-15",null,50,129,null,0.21299999999999999,null,1,null,0,null,null,null,"No"]
[12444,"5813","58","722",722410,"Cocktail Lounge","Phoenix, AZ","United States",200,"2014-04-09",null,150,175,null,0.75,null,0.1,null,0,110,null,null,"No"]

{"sheet":"Statistics","index":7,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,12],[15,1,15,12]]}
[]
[null,"Selected Transactions"]
[]
[null,null,"Count ","Min","Max","10th Percentile","25th Percentile","Median ","75th Percentile","90th Percentile","Mean ","Harmonic Mean","Coefficient of Variation"]
[null,"Sale Date",{"$f":"COUNT(Selected.SaleDate)","v":135},{"$f":"IF(C5>0,MIN(Selected.SaleDate),\"N/A\")","v":"2014-01-02"},{"$f":"IF(C5>0,MAX(Selected.SaleDate),\"N/A\")","v":"2014-12-31"}]
[null,"Annual Gross Sales",{"$f":"COUNT(Selected.AnnualGross)","v":135},{"$f":"IF(C6>0,MIN(Selected.AnnualGross),\"N/A\")","v":73},{"$f":"IF(C6>0,MAX(Selected.AnnualGross),\"N/A\")","v":2550},{"$f":"IF(C6>8,PERCENTILE(Selected.AnnualGross,0.1),\"N/A\")","v":181},{"$f":"IF(C6>2,PERCENTILE(Selected.AnnualGross,0.25),\"N/A\")","v":254.5},{"$f":"IF(C6>1,MEDIAN(Selected.AnnualGross),\"N/A\")","v":421},{"$f":"IF(C6>2,PERCENTILE(Selected.AnnualGross,0.75),\"N/A\")","v":720},{"$f":"IF(C6>8,PERCENTILE(Selected.AnnualGross,0.9),\"N/A\")","v":1134},{"$f":"IF(C6>1,AVERAGE(Selected.AnnualGross),\"N/A\")","v":586.88888888888891}]
[null,"SDE",{"$f":"COUNT(Selected.SDE)","v":131},{"$f":"IF(C7>0,MIN(Selected.SDE),\"N/A\")","v":-10},{"$f":"IF(C7>0,MAX(Selected.SDE),\"N/A\")","v":591},{"$f":"IF(C7>8,PERCENTILE(Selected.SDE,0.1),\"N/A\")","v":25},{"$f":"IF(C7>2,PERCENTILE(Selected.SDE,0.25),\"N/A\")","v":44},{"$f":"IF(C7>1,MEDIAN(Selected.SDE),\"N/A\")","v":73},{"$f":"IF(C7>2,PERCENTILE(Selected.SDE,0.75),\"N/A\")","v":135.5},{"$f":"IF(C7>8,PERCENTILE(Selected.SDE,0.9),\"N/A\")","v":229},{"$f":"IF(C7>1,AVERAGE(Selected.SDE),\"N/A\")","v":104}]
[null,"Inventory Value",{"$f":"COUNT(Selected.InventoryAmount)","v":135},{"$f":"IF(C8>0,MIN(Selected.InventoryAmount),\"N/A\")","v":0},{"$f":"IF(C8>0,MAX(Selected.InventoryAmount),\"N/A\")","v":61},{"$f":"IF(C8>8,PERCENTILE(Selected.InventoryAmount,0.1),\"N/A\")","v":0},{"$f":"IF(C8>2,PERCENTILE(Selected.InventoryAmount,0.25),\"N/A\")","v":0},{"$f":"IF(C8>1,MEDIAN(Selected.InventoryAmount),\"N/A\")","v":2},{"$f":"IF(C8>2,PERCENTILE(Selected.InventoryAmount,0.75),\"N/A\")","v":5},{"$f":"IF(C8>8,PERCENTILE(Selected.InventoryAmount,0.9),\"N/A\")","v":8.6000000000000085},{"$f":"IF(C8>1,AVERAGE(Selected.InventoryAmount),\"N/A\")","v":3.6962962962962962}]
[null,"FF&E",{"$f":"COUNT(Selected.FFE)","v":87},{"$f":"IF(C9>0,MIN(Selected.FFE),\"N/A\")","v":3},{"$f":"IF(C9>0,MAX(Selected.FFE),\"N/A\")","v":385},{"$f":"IF(C9>8,PERCENTILE(Selected.FFE,0.1),\"N/A\")","v":20.6},{"$f":"IF(C9>2,PERCENTILE(Selected.FFE,0.25),\"N/A\")","v":30},{"$f":"IF(C9>1,MEDIAN(Selected.FFE),\"N/A\")","v":50},{"$f":"IF(C9>2,PERCENTILE(Selected.FFE,0.75),\"N/A\")","v":72.5},{"$f":"IF(C9>8,PERCENTILE(Selected.FFE,0.9),\"N/A\")","v":132.00000000000003},{"$f":"IF(C9>1,AVERAGE(Selected.FFE),\"N/A\")","v":67.988505747126439}]
[null,"Sale Price (Excludes Inventory)",{"$f":"COUNT(Selected.SalePrice)","v":135},{"$f":"IF(C10>0,MIN(Selected.SalePrice),\"N/A\")","v":25},{"$f":"IF(C10>0,MAX(Selected.SalePrice),\"N/A\")","v":2200},{"$f":"IF(C10>8,PERCENTILE(Selected.SalePrice,0.1),\"N/A\")","v":50},{"$f":"IF(C10>2,PERCENTILE(Selected.SalePrice,0.25),\"N/A\")","v":70.5},{"$f":"IF(C10>1,MEDIAN(Selected.SalePrice),\"N/A\")","v":124},{"$f":"IF(C10>2,PERCENTILE(Selected.SalePrice,0.75),\"N/A\")","v":223.5},{"$f":"IF(C10>8,PERCENTILE(Selected.SalePrice,0.9),\"N/A\")","v":450},{"$f":"IF(C10>1,AVERAGE(Selected.SalePrice),\"N/A\")","v":207.86666666666667}]
[null,"SDE To Annual Gross",{"$f":"COUNT(Selected.SDEToAnnualGross)","v":131},{"$f":"IF(C11>0,MIN(Selected.SDEToAnnualGross),\"N/A\")","v":-3.9E-2},{"$f":"IF(C11>0,MAX(Selected.SDEToAnnualGross),\"N/A\")","v":0.6},{"$f":"IF(C11>8,PERCENTILE(Selected.SDEToAnnualGross,0.1),\"N/A\")","v":8.3000000000000004E-2},{"$f":"IF(C11>2,PERCENTILE(Selected.SDEToAnnualGross,0.25),\"N/A\")","v":0.11799999999999999},{"$f":"IF(C11>1,MEDIAN(Selected.SDEToAnnualGross),\"N/A\")","v":0.186},{"$f":"IF(C11>2,PERCENTILE(Selected.SDEToAnnualGross,0.75),\"N/A\")","v":0.25},{"$f":"IF(C11>8,PERCENTILE(Selected.SDEToAnnualGross,0.9),\"N/A\")","v":0.3},{"$f":"IF(C11>1,AVERAGE(Selected.SDEToAnnualGross),\"N/A\")","v":0.18933587786259545}]
[null,"Rent To Annual Gross",{"$f":"COUNT(Selected.RentToAnnualGross)","v":25},{"$f":"IF(C12>0,MIN(Selected.RentToAnnualGross),\"N/A\")","v":8.9999999999999993E-3},{"$f":"IF(C12>0,MAX(Selected.RentToAnnualGross),\"N/A\")","v":13},{"$f":"IF(C12>8,PERCENTILE(Selected.RentToAnnualGross,0.1),\"N/A\")","v":4.0800000000000003E-2},{"$f":"IF(C12>2,PERCENTILE(Selected.RentToAnnualGross,0.25),\"N/A\")","v":7.0000000000000007E-2},{"$f":"IF(C12>1,MEDIAN(Selected.RentToAnnualGross),\"N/A\")","v":0.11},{"$f":"IF(C12>2,PERCENTILE(Selected.RentToAnnualGross,0.75),\"N/A\")","v":0.17},{"$f":"IF(C12>8,PERCENTILE(Selected.RentToAnnualGross,0.9),\"N/A\")","v":0.25},{"$f":"IF(C12>1,AVERAGE(Selected.RentToAnnualGross),\"N/A\")","v":0.6329999999999999}]
[null,"Sale Price To Annual Gross",{"$f":"COUNT(Selected.SalePriceToAnnualGross)","v":135},{"$f":"IF(C13>0,MIN(Selected.SalePriceToAnnualGross),\"N/A\")","v":3.9E-2},{"$f":"IF(C13>0,MAX(Selected.SalePriceToAnnualGross),\"N/A\")","v":0.88},{"$f":"IF(C13>8,PERCENTILE(Selected.SalePriceToAnnualGross,0.1),\"N/A\")","v":0.15940000000000001},{"$f":"IF(C13>2,PERCENTILE(Selected.SalePriceToAnnualGross,0.25),\"N/A\")","v":0.20749999999999999},{"$f":"IF(C13>1,MEDIAN(Selected.SalePriceToAnnualGross),\"N/A\")","v":0.314},{"$f":"IF(C13>2,PERCENTILE(Selected.SalePriceToAnnualGross,0.75),\"N/A\")","v":0.47649999999999998},{"$f":"IF(C13>8,PERCENTILE(Selected.SalePriceToAnnualGross,0.9),\"N/A\")","v":0.66220000000000012},{"$f":"IF(C13>1,AVERAGE(Selected.SalePriceToAnnualGross),\"N/A\")","v":0.35464444444444443},{"$f":"IF(C13>1,HARMEAN(Selected.SalePriceToAnnualGross),\"N/A\")","v":0.25236710461419193},{"$f":"IF(C13>1,(STDEV((Selected.SalePriceToAnnualGross))/K13),\"N/A\")","v":0.53152984358111766}]
[null,"Sale Price To SDE",{"$f":"COUNT(Selected.SalePriceToSDE)","v":128},{"$f":"IF(C14>0,MIN(Selected.SalePriceToSDE),\"N/A\")","v":0.30499999999999999},{"$f":"IF(C14>0,MAX(Selected.SalePriceToSDE),\"N/A\")","v":33},{"$f":"IF(C14>8,PERCENTILE(Selected.SalePriceToSDE,0.1),\"N/A\")","v":0.96250000000000002},{"$f":"IF(C14>2,PERCENTILE(Selected.SalePriceToSDE,0.25),\"N/A\")","v":1.25},{"$f":"IF(C14>1,MEDIAN(Selected.SalePriceToSDE),\"N/A\")","v":1.8265},{"$f":"IF(C14>2,PERCENTILE(Selected.SalePriceToSDE,0.75),\"N/A\")","v":2.39175},{"$f":"IF(C14>8,PERCENTILE(Selected.SalePriceToSDE,0.9),\"N/A\")","v":3.6414999999999997},{"$f":"IF(C14>1,AVERAGE(Selected.SalePriceToSDE),\"N/A\")","v":2.3503749999999988},{"$f":"IF(C14>1,HARMEAN(Selected.SalePriceToSDE),\"N/A\")","v":1.5194277284020161},{"$f":"IF(C14>1,(STDEV((Selected.SalePriceToSDE))/K14),\"N/A\")","v":1.3475885186223138}]
[]
[null,"All Transactions (from \"All Trans\" sheet)"]
[]
[null,null,"Count ","Min","Max","10th Percentile","25th Percentile","Median ","75th Percentile","90th Percentile","Mean ","Harmonic Mean","Coefficient of Variation"]
[null,"Sale Date",{"$f":"COUNT(All.SaleDate)","v":135},{"$f":"IF(C19>0,MIN(All.SaleDate),\"N/A\")","v":"2014-01-02"},{"$f":"IF(C19>0,MAX(All.SaleDate),\"N/A\")","v":"2014-12-31"}]
[null,"Annual Gross Sales",{"$f":"COUNT(All.AnnualGross)","v":135},{"$f":"IF(C20>0,MIN(All.AnnualGross),\"N/A\")","v":73},{"$f":"IF(C20>0,MAX(All.AnnualGross),\"N/A\")","v":2550},{"$f":"IF(C20>8,PERCENTILE(All.AnnualGross,0.1),\"N/A\")","v":181},{"$f":"IF(C20>2,PERCENTILE(All.AnnualGross,0.25),\"N/A\")","v":254.5},{"$f":"IF(C20>1,MEDIAN(All.AnnualGross),\"N/A\")","v":421},{"$f":"IF(C20>2,PERCENTILE(All.AnnualGross,0.75),\"N/A\")","v":720},{"$f":"IF(C20>8,PERCENTILE(All.AnnualGross,0.9),\"N/A\")","v":1134},{"$f":"IF(C20>1,AVERAGE(All.AnnualGross),\"N/A\")","v":586.88888888888891}]
[null,"SDE",{"$f":"COUNT(All.SDE)","v":131},{"$f":"IF(C21>0,MIN(All.SDE),\"N/A\")","v":-10},{"$f":"IF(C21>0,MAX(All.SDE),\"N/A\")","v":591},{"$f":"IF(C21>8,PERCENTILE(All.SDE,0.1),\"N/A\")","v":25},{"$f":"IF(C21>2,PERCENTILE(All.SDE,0.25),\"N/A\")","v":44},{"$f":"IF(C21>1,MEDIAN(All.SDE),\"N/A\")","v":73},{"$f":"IF(C21>2,PERCENTILE(All.SDE,0.75),\"N/A\")","v":135.5},{"$f":"IF(C21>8,PERCENTILE(All.SDE,0.9),\"N/A\")","v":229},{"$f":"IF(C21>1,AVERAGE(All.SDE),\"N/A\")","v":104}]
[null,"Inventory Value",{"$f":"COUNT(All.InventoryAmount)","v":135},{"$f":"IF(C22>0,MIN(All.InventoryAmount),\"N/A\")","v":0},{"$f":"IF(C22>0,MAX(All.InventoryAmount),\"N/A\")","v":61},{"$f":"IF(C22>8,PERCENTILE(All.InventoryAmount,0.1),\"N/A\")","v":0},{"$f":"IF(C22>2,PERCENTILE(All.InventoryAmount,0.25),\"N/A\")","v":0},{"$f":"IF(C22>1,MEDIAN(All.InventoryAmount),\"N/A\")","v":2},{"$f":"IF(C22>2,PERCENTILE(All.InventoryAmount,0.75),\"N/A\")","v":5},{"$f":"IF(C22>8,PERCENTILE(All.InventoryAmount,0.9),\"N/A\")","v":8.6000000000000085},{"$f":"IF(C22>1,AVERAGE(All.InventoryAmount),\"N/A\")","v":3.6962962962962962}]
[null,"FF&E",{"$f":"COUNT(All.FFE)","v":87},{"$f":"IF(C23>0,MIN(All.FFE),\"N/A\")","v":3},{"$f":"IF(C23>0,MAX(All.FFE),\"N/A\")","v":385},{"$f":"IF(C23>8,PERCENTILE(All.FFE,0.1),\"N/A\")","v":20.6},{"$f":"IF(C23>2,PERCENTILE(All.FFE,0.25),\"N/A\")","v":30},{"$f":"IF(C23>1,MEDIAN(All.FFE),\"N/A\")","v":50},{"$f":"IF(C23>2,PERCENTILE(All.FFE,0.75),\"N/A\")","v":72.5},{"$f":"IF(C23>8,PERCENTILE(All.FFE,0.9),\"N/A\")","v":132.00000000000003},{"$f":"IF(C23>1,AVERAGE(All.FFE),\"N/A\")","v":67.988505747126439}]
[null,"Sale Price (Excludes Inventory)",{"$f":"COUNT(All.SalePrice)","v":135},{"$f":"IF(C24>0,MIN(All.SalePrice),\"N/A\")","v":25},{"$f":"IF(C24>0,MAX(All.SalePrice),\"N/A\")","v":2200},{"$f":"IF(C24>8,PERCENTILE(All.SalePrice,0.1),\"N/A\")","v":50},{"$f":"IF(C24>2,PERCENTILE(All.SalePrice,0.25),\"N/A\")","v":70.5},{"$f":"IF(C24>1,MEDIAN(All.SalePrice),\"N/A\")","v":124},{"$f":"IF(C24>2,PERCENTILE(All.SalePrice,0.75),\"N/A\")","v":223.5},{"$f":"IF(C24>8,PERCENTILE(All.SalePrice,0.9),\"N/A\")","v":450},{"$f":"IF(C24>1,AVERAGE(All.SalePrice),\"N/A\")","v":207.86666666666667}]
[null,"SDE To Annual Gross",{"$f":"COUNT(All.SDEToAnnualGross)","v":131},{"$f":"IF(C25>0,MIN(All.SDEToAnnualGross),\"N/A\")","v":-3.9E-2},{"$f":"IF(C25>0,MAX(All.SDEToAnnualGross),\"N/A\")","v":0.6},{"$f":"IF(C25>8,PERCENTILE(All.SDEToAnnualGross,0.1),\"N/A\")","v":8.3000000000000004E-2},{"$f":"IF(C25>2,PERCENTILE(All.SDEToAnnualGross,0.25),\"N/A\")","v":0.11799999999999999},{"$f":"IF(C25>1,MEDIAN(All.SDEToAnnualGross),\"N/A\")","v":0.186},{"$f":"IF(C25>2,PERCENTILE(All.SDEToAnnualGross,0.75),\"N/A\")","v":0.25},{"$f":"IF(C25>8,PERCENTILE(All.SDEToAnnualGross,0.9),\"N/A\")","v":0.3},{"$f":"IF(C25>1,AVERAGE(All.SDEToAnnualGross),\"N/A\")","v":0.18933587786259545}]
[null,"Rent To Annual Gross",{"$f":"COUNT(All.RentToAnnualGross)","v":25},{"$f":"IF(C26>0,MIN(All.RentToAnnualGross),\"N/A\")","v":8.9999999999999993E-3},{"$f":"IF(C26>0,MAX(All.RentToAnnualGross),\"N/A\")","v":13},{"$f":"IF(C26>8,PERCENTILE(All.RentToAnnualGross,0.1),\"N/A\")","v":4.0800000000000003E-2},{"$f":"IF(C26>2,PERCENTILE(All.RentToAnnualGross,0.25),\"N/A\")","v":7.0000000000000007E-2},{"$f":"IF(C26>1,MEDIAN(All.RentToAnnualGross),\"N/A\")","v":0.11},{"$f":"IF(C26>2,PERCENTILE(All.RentToAnnualGross,0.75),\"N/A\")","v":0.17},{"$f":"IF(C26>8,PERCENTILE(All.RentToAnnualGross,0.9),\"N/A\")","v":0.25},{"$f":"IF(C26>1,AVERAGE(All.RentToAnnualGross),\"N/A\")","v":0.6329999999999999}]
[null,"Sale Price To Annual Gross",{"$f":"COUNT(All.SalePriceToAnnualGross)","v":135},{"$f":"IF(C27>0,MIN(All.SalePriceToAnnualGross),\"N/A\")","v":3.9E-2},{"$f":"IF(C27>0,MAX(All.SalePriceToAnnualGross),\"N/A\")","v":0.88},{"$f":"IF(C27>8,PERCENTILE(All.SalePriceToAnnualGross,0.1),\"N/A\")","v":0.15940000000000001},{"$f":"IF(C27>2,PERCENTILE(All.SalePriceToAnnualGross,0.25),\"N/A\")","v":0.20749999999999999},{"$f":"IF(C27>1,MEDIAN(All.SalePriceToAnnualGross),\"N/A\")","v":0.314},{"$f":"IF(C27>2,PERCENTILE(All.SalePriceToAnnualGross,0.75),\"N/A\")","v":0.47649999999999998},{"$f":"IF(C27>8,PERCENTILE(All.SalePriceToAnnualGross,0.9),\"N/A\")","v":0.66220000000000012},{"$f":"IF(C27>1,AVERAGE(All.SalePriceToAnnualGross),\"N/A\")","v":0.35464444444444443},{"$f":"IF(C27>1,HARMEAN(All.SalePriceToAnnualGross),\"N/A\")","v":0.25236710461419193},{"$f":"IF(C27>1,(STDEV((All.SalePriceToAnnualGross))/K27),\"N/A\")","v":0.53152984358111766}]
[null,"Sale Price To SDE",{"$f":"COUNT(All.SalePriceToSDE)","v":128},{"$f":"IF(C28>0,MIN(All.SalePriceToSDE),\"N/A\")","v":0.30499999999999999},{"$f":"IF(C28>0,MAX(All.SalePriceToSDE),\"N/A\")","v":33},{"$f":"IF(C28>8,PERCENTILE(All.SalePriceToSDE,0.1),\"N/A\")","v":0.96250000000000002},{"$f":"IF(C28>2,PERCENTILE(All.SalePriceToSDE,0.25),\"N/A\")","v":1.25},{"$f":"IF(C28>1,MEDIAN(All.SalePriceToSDE),\"N/A\")","v":1.8265},{"$f":"IF(C28>2,PERCENTILE(All.SalePriceToSDE,0.75),\"N/A\")","v":2.39175},{"$f":"IF(C28>8,PERCENTILE(All.SalePriceToSDE,0.9),\"N/A\")","v":3.6414999999999997},{"$f":"IF(C28>1,AVERAGE(All.SalePriceToSDE),\"N/A\")","v":2.3503749999999988},{"$f":"IF(C28>1,HARMEAN(All.SalePriceToSDE),\"N/A\")","v":1.5194277284020161},{"$f":"IF(C28>1,(STDEV((All.SalePriceToSDE))/K28),\"N/A\")","v":1.3475885186223138}]
[]
[null,"Note: Currency fields are in thousands (example: $1 million would be displayed as $1,000)."]

{"sheet":"Export Tools","index":8,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,1,12,6],[13,1,13,6],[1,1,1,6],[2,1,2,6]]}
[]
[null,"Export Worksheets"]
[null,"Select the optional worksheets to export."]
[]
[null,null,"About",null,null,"Yes"]
[null,null,"Definitions",null,null,"Yes"]
[null,null,"All Trans",null,null,"Yes"]
[null,null,"Statistics",null,null,"Yes"]
[null,null,"Multiples Analysis",null,null,"Yes"]
[null,null,"Equity Value & Minority Int",null,null,"Yes"]
[]
[]
[null,"Export Graphs"]
[null,"Select the graphs to export."]
[]
[null,null,"Price to Annual Gross",null,null,"Yes"]
[null,null,"Price to SDE",null,null,"Yes"]

{"sheet":"Multiples Analysis","index":11,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[15,25,16,25],[15,21,16,21],[15,18,16,19],[18,18,18,19],[19,18,19,19],[18,15,18,16],[19,15,19,16],[15,15,16,16],[18,7,18,8],[15,10,16,13],[18,10,18,13],[19,7,19,8],[15,7,16,8],[13,0,13,3],[15,5,16,5],[18,1,18,3],[19,1,19,3],[15,1,16,3],[0,0,1,11],[3,1,3,5],[6,1,6,3],[5,1,5,3],[3,8,12,23],[27,0,27,3],[29,1,30,3],[29,5,30,5],[29,7,30,8],[29,10,30,13],[33,1,33,3],[33,7,33,8],[33,15,33,16],[29,15,30,16],[32,1,32,3],[32,7,32,8],[32,10,32,13],[32,15,32,16],[35,17,35,19],[29,21,30,21],[29,23,30,23],[29,18,30,19],[32,18,32,19],[33,18,33,19]]}
["BIZCOMPS® Multiples Analysis"]
[]
[]
[null,"Subject Company Information",null,null,null,null,null,null,"The Analyzer contains two methods of calculating a value using the Weighted Multiples Application section or the Contribution Multiples Application section – with one section using weights, the other using percentages.  The user can use one or the other or both in their analysis. On this sheet, the grey cells are input cells (cells that accept inputs from you).\n\nINSTRUCTIONS: Enter your subject company information in the \"Subject Company Information\" section. Leave any fields blank that you do not wish to use. Do not enter any financial information that is negative (if you do, it will not be considered). Enter dollar figures in whole numbers. Enter currency figures in thousands (example: for $1 million, you would enter $1,000). Next, select which type of valuation multiples you want to use from the “Select Statistical Measure to Use” section. In the \"Weighted Multiples Application\" section, select your desired weights (the higher the number selected, the greater the weight given). Select \"N/A\" if you do not wish to use that valuation multiple. In the \"Contribution Multiples Application\" section, select your desired percentage to allocate towards the indicated value. Select \"0%\" if you do not wish to use that value."]
[]
[null,"Annual Gross Sales ($000s)"]
[null,"SDE ($000s)"]
[]
[]
[]
[]
[]
[]
["Weighted Multiples Application"]
[]
[null,"Valuation Multiple",null,null,null,"Count of Multiples",null,"Coefficient of Variation",null,null,"Select Statistical Measure to Use",null,null,null,null,"Valuation Multiples",null,null,"Select Weights",null,null,"Value from Multiples",null,null,null,"Weights Selected"]
[]
[]
[null,"Sale Price/Annual Gross",null,null,null,{"$f":"COUNT(Selected.SalePriceToAnnualGross)","v":135},null,{"$f":"Statistics!M13","v":0.53152984358111766},null,null,"N/A",null,null,null,null,{"$f":"IF($K$19=\"10th Percentile\",Statistics!F13,IF($K$19=\"25th Percentile\",Statistics!G13,IF($K$19=\"75th Percentile\",Statistics!I13,IF($K$19=\"90th Percentile\",Statistics!J13,IF($K$19=\"Harmonic Mean\",Statistics!L13,IF($K$19=\"Median\",Statistics!H13,IF($K$19=\"Mean\",Statistics!K13,\"N/A\")))))))","v":"N/A"},null,null,"N/A",null,null,{"$f":"IF(P19=\"N/A\",\"N/A\",IF(F6<1,\"N/A\",IF(S19=\"N/A\",\"N/A\",IF(F6=\"\",\"N/A\",F6*P19))))","v":"N/A"},null,null,null,{"$f":"IF(P19=\"N/A\",\"N/A\",IF(F6<1,\"N/A\",IF(S19=\"N/A\",\"N/A\",IF(F6=\"\",\"N/A\",S19))))","v":"N/A"}]
[null,"Sale Price/SDE",null,null,null,{"$f":"COUNT(Selected.SalePriceToSDE)","v":128},null,{"$f":"Statistics!M14","v":1.3475885186223138},null,null,null,null,null,null,null,{"$f":"IF($K$19=\"10th Percentile\",Statistics!F14,IF($K$19=\"25th Percentile\",Statistics!G14,IF($K$19=\"75th Percentile\",Statistics!I14,IF($K$19=\"90th Percentile\",Statistics!J14,IF($K$19=\"Harmonic Mean\",Statistics!L14,IF($K$19=\"Median\",Statistics!H14,IF($K$19=\"Mean\",Statistics!K14,\"N/A\")))))))","v":"N/A"},null,null,"N/A",null,null,"N/A",null,null,null,"N/A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Average ($000s):",null,null,null,null,{"$f":"IF(MA.Weighted.Measure=\"N/A\",\"N/A\",IF(SUM(Z19:Z20) = 0, 0, SUMPRODUCT(V19:V20,Z19:Z20)/SUM(Z19:Z20)))","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Value ($000s):",null,null,null,{"$f":"IF(MA.Weighted.Measure=\"N/A\",\"N/A\",MAX(V19:V20))","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Value ($000s):",null,null,null,{"$f":"IF(MA.Weighted.Measure=\"N/A\",\"N/A\",MIN(V19:V20))","v":"N/A"}]
[]
["Contribution Multiples Application"]
[]
[null,"Valuation Multiple",null,null,null,"Count of Multiples",null,"Coefficient of Variation",null,null,"Select Statistical Measure to Use",null,null,null,null,"Valuation Multiples",null,null,"Value from Multiples",null,null,"Select Percentage",null,"Contribution"]
[]
[]
[null,"Sale Price/Annual Gross",null,null,null,{"$f":"COUNT(Selected.SalePriceToAnnualGross)","v":135},null,{"$f":"Statistics!M13","v":0.53152984358111766},null,null,"N/A",null,null,null,null,{"$f":"IF($K$33=\"10th Percentile\",Statistics!F13,IF($K$33=\"25th Percentile\",Statistics!G13,IF($K$33=\"75th Percentile\",Statistics!I13,IF($K$33=\"90th Percentile\",Statistics!J13,IF($K$33=\"Harmonic Mean\",Statistics!L13,IF($K$33=\"Median\",Statistics!H13,IF($K$33=\"Mean\",Statistics!K13,\"N/A\")))))))","v":"N/A"},null,null,{"$f":"IF(P33=\"N/A\",\"N/A\",IF(F6<1,\"N/A\",IF(F6=\"\",\"N/A\",F6*P33)))","v":"N/A"},null,null,0,null,{"$f":"IF(S33=\"N/A\",\"N/A\",IF(V33=0%,\"N/A\",S33*V33))","v":"N/A"}]
[null,"Sale Price/SDE",null,null,null,{"$f":"COUNT(Selected.SalePriceToSDE)","v":128},null,{"$f":"Statistics!M14","v":1.3475885186223138},null,null,null,null,null,null,null,{"$f":"IF($K$33=\"10th Percentile\",Statistics!F14,IF($K$33=\"25th Percentile\",Statistics!G14,IF($K$33=\"75th Percentile\",Statistics!I14,IF($K$33=\"90th Percentile\",Statistics!J14,IF($K$33=\"Harmonic Mean\",Statistics!L14,IF($K$33=\"Median\",Statistics!H14,IF($K$33=\"Mean\",Statistics!K14,\"N/A\")))))))","v":"N/A"},null,null,"N/A",null,null,0,null,"N/A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Percentage:",null,null,null,{"$f":"SUM(V33:V34)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Value ($000s):",null,{"$f":"IF(V36<100%,\"N/A\",IF(V36>100%,\"N/A\",SUM(X33:X34)))","v":"N/A"}]

{"sheet":"Equity Value & Minority Int","index":12,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,1,10],[14,12,14,16],[3,1,17,10],[48,12,50,22],[27,1,28,5],[31,1,32,5],[2,12,3,16],[21,1,22,7],[25,1,26,4],[0,12,1,19]]}
["Equity Value and Minority Interest Analysis",null,null,null,null,null,null,null,null,null,null,null,"Note: The sale price in BIZCOMPS does not include the value of inventory acquired. Currency fields are in thousands (example: $1 million would be displayed as $1,000)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Typical application of Asset Multiples"]
[null,"BIZCOMPS® multiples yield Market Value of Invested Capital (MVIC) values. Many appraisers, ultimately, are attempting to get to an equity value for their subject company. Doing so requires adding back some assets and subtracting some liabilities. The typical treatment of the MVIC price is outlined to the right and is based on The Comprehensive Guide to the Use and Application of the Transaction Databases, by Nancy J. Fannon and Heidi P. Walker. Further, BIZCOMPS® data is comprised of 100% private business sales, and some appraisers seek to value a minority interest. As a result, some appraisers valuing a minority interest may wish to apply a discount for lack of marketability and/or a discount for lack of control to a pro rate value resulting from the application of the BIZCOMPS® valuation multiples. This section gives you the opportunity to do that, if you wish. Also, if you need to modify any sale prices or valuation multiples (to add or remove any assets or liabilities), remember you can do so on the \"All Trans\" worksheet–changes on that worksheet will flow through the rest of this workbook.\n\nOn the right is a tool to help you in reaching a 100% equity value or a less than 100% equity value. Depending on your analysis, various fields may not be relevant to you. All grey cells are input cells You may choose to enter $0 into an input cell or if the cell is the dropdown menu, you may select \"N/A\". Enter all numeric values as a positive number. Your values from the \"Multiples Analysis\" worksheet have been brought over."]
[null,null,null,null,null,null,null,null,null,null,null,null," Subject Company Revenue or Earnings \n"]
[null,null,null,null,null,null,null,null,null,null,null,null," X Pricing Multiple (as selected by appraiser)"]
[null,null,null,null,null,null,null,null,null,null,null,null," =  Indicated Market Value of Invested Capital"]
[null,null,null,null,null,null,null,null,null,null,null,null," + Assets not included in the multiple (usually AR and cash)"]
[null,null,null,null,null,null,null,null,null,null,null,null," - Liabilities excluded from the multiple (usually all)"]
[null,null,null,null,null,null,null,null,null,null,null,null," + Real estate "]
[null,null,null,null,null,null,null,null,null,null,null,null," + Non-operating assets "]
[null,null,null,null,null,null,null,null,null,null,null,null," - Non-operating liabilities "]
[null,null,null,null,null,null,null,null,null,null,null,null," = Indicated Value of Equity "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Using Asset Sales"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Value using Weighted Average",null,null,null,{"$f":"'Multiples Analysis'!V22","v":"N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Value using Percentage Contributions",null,null,null,{"$f":"'Multiples Analysis'!X38","v":"N/A"}]
[null,"Additional Resources"]
[null,"Using Transaction Databases -",null,null,null,null,null,null,null,null,null,null,"Select MVIC Value"]
[null,"• The Comprehensive Guide to the Use and Application of the Transaction Databases"]
[null,null,null,null,null,null,null,null,null,null,null,null," + Assets not included in the multiple"]
[]
[null,"Lack of Marketability Discounts -",null,null,null,null,null,null,null,null,null,null," - Liabilities excluded from the multiple"]
[null,"• The FMV Restricted Stock Study™"]
[null,null,null,null,null,null,null,null,null,null,null,null," + Real estate"]
[null,"• Valuation Advisors Lack of Marketability Discount Study™"]
[null,null,null,null,null,null,null,null,null,null,null,null," + Non-operating assets "]
[]
[null,"Lack of Control Discounts -",null,null,null,null,null,null,null,null,null,null," - Non-operating liabilities "]
[null,"• FactSet Mergerstat®/BVR Control Premium Study™"]
[null,null,null,null,null,null,null,null,null,null,null,null," = Indicated Value of Equity",null,null,null,{"$f":"IF(Q21=\"\",\"\",(Q21+Q23-Q25+Q27+Q29-Q31))","v":""}]
[]
[null,"For combination or group pricing, please contact an Account Executive at:",null,null,null,null,null,null,null,null,null,null,"Minority interest?"]
[]
[null,"Phone: ","(503) 291-7963 ext. 2",null,null,null,null,null,null,null,null,null," = Pro Rata Equity Value",null,null,null,{"$f":"IF(Q35=\"\",\"\",IF(Q21=\"\",\"\",IF(Q35=\"N/A\",Q33,(Q33*Q35))))","v":""}]
[]
[null,"Email:","Sales@bvresources.com",null,null,null,null,null,null,null,null,null,"Lack of control discount"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Marketable Minority Value",null,null,null,{"$f":"IF(Q37=\"\",\"\",IF(Q39=\"\",\"\",IF(Q39=\"N/A\",Q37,(Q37*(1-Q39)))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lack of marketability discount"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," = Non-Marketable Minority Value",null,null,null,{"$f":"IF(Q41=\"\",\"\",IF(Q43=\"\",\"\",IF(Q43=\"N/A\",Q41,(Q41*(1-Q43)))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Appraiser Selected Final Value*"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"*The appraiser has the option of selecting a final value dependant on specific characteristics of the subject company or the nature of the appraisal. The above template is intended to be used as a guideline – while it provides things to consider, it is not all-inclusive. Ultimately, the appraiser is responsible for considering all relevant factors in determining the value of a business interest."]