{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Template","Kohls"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Company Name:",{"$error":"#VALUE!"},null,null,null,"SEC.gov | Company Search Page"]
["Valuation Date:","2020-12-29"]
["Valuation Period:","2020-09-25"]
[]
["Current Price:",{"$f":"_FV(B1,\"Price\")","v":54.14}]
["Market Cap:",{"$f":"_FV(B1,\"Market cap\",TRUE)","v":232749100000}]
["Shares Outstanding:",{"$f":"_FV(B1,\"Shares outstanding\",TRUE)","v":4297435000}]
["Diluted Shares OS:",4311000000]
[]
["Cash",18732000000]
["Accounts Receivable",3827000000]
["Inventory",3264000000]
["Total Liabilities",{"$f":"97184000000-20316000000","v":76868000000}]
["Net Income",{"$f":"6920/9*12*1000000","v":9226666666.6666679}]
[]
[]
[]
["Ratios"]
["P/E",{"$f":"+B6/B14","v":25.225697254335255}]
[]
["Net-Net Valuation"]
["Cash",{"$f":"+B10","v":18732000000}]
["+ AR (75%)",{"$f":"+B11*0.75","v":2870250000}]
["+ Inventory (50%)",{"$f":"+B12*0.5","v":1632000000}]
["- Total Liabilities",{"$f":"-B13","v":-76868000000}]
["Net-Net Value",{"$f":"SUM(B22:B25)","v":-53633750000}]

{"sheet":"Kohls","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Company Name:",{"$error":"#VALUE!"},null,null,null,"SEC.gov | Company Search Page"]
["Valuation Date:","2020-12-29"]
["Valuation Period:","2020-10-31"]
[]
["Current Price:",{"$f":"_FV(B1,\"Price\")","v":39.71}]
["Market Cap:",{"$f":"_FV(B1,\"Market cap\",TRUE)","v":6326591000}]
["Shares Outstanding:",{"$f":"_FV(B1,\"Shares outstanding\",TRUE)","v":157652400}]
["Diluted Shares OS:",4311000000]
[]
["Cash",1939000000]
["Accounts Receivable",0]
["Inventory",3607000000]
["Total Liabilities",{"$f":"15444000000-4838000000","v":10606000000}]
["Net Income",{"$f":"6920/9*12*1000000","v":9226666666.6666679}]
[]
[]
[]
["Ratios"]
["P/E",{"$f":"+B6/B14","v":0.685685440751445}]
[]
["Net-Net Valuation"]
["Cash",{"$f":"+B10","v":1939000000}]
["+ AR (75%)",{"$f":"+B11*0.75","v":0}]
["+ Inventory (50%)",{"$f":"+B12*0.5","v":1803500000}]
["- Total Liabilities",{"$f":"-B13","v":-10606000000}]
["Net-Net Value",{"$f":"SUM(B22:B25)","v":-6863500000}]