{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data Source","BS 2014","BS 2015","BS 2016","Exercise -->","1.1","P&L","BS","FA Roll Forward PPE","Financial Liabilities","Equity Schedule","Cash Flow"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Data Source","index":0,"n_rows":438,"n_cols":4,"rows_kept":438,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Date","Financials","Amount"]
[null,"1.1.2014","Revenue - Supermarkets",72]
[null,"1.1.2014","Cogs - Supermarkets",47]
[null,"1.1.2014","Revenue - Discounters",37]
[null,"1.1.2014","Cogs - Discounters",20]
[null,"1.1.2014","Revenue - Grocery",36]
[null,"1.1.2014","Cogs - Grocery",17]
[null,"1.1.2014","Revenue - Retail",57]
[null,"1.1.2014","Cogs - Retail",32]
[null,"1.1.2014","Operating expenses",95.399999999999991]
[null,"1.1.2014","D&A",2]
[null,"1.1.2014","Interest expenses",5]
[null,"1.1.2014","Taxes",17.29]
[null,"2.1.2014","Revenue - Supermarkets",75]
[null,"2.1.2014","Cogs - Supermarkets",55]
[null,"2.1.2014","Revenue - Discounters",26]
[null,"2.1.2014","Cogs - Discounters",18]
[null,"2.1.2014","Revenue - Grocery",42]
[null,"2.1.2014","Cogs - Grocery",18]
[null,"2.1.2014","Revenue - Retail",54]
[null,"2.1.2014","Cogs - Retail",33]
[null,"2.1.2014","Operating expenses",96.3]
[null,"2.1.2014","D&A",2]
[null,"2.1.2014","Interest expenses",5]
[null,"2.1.2014","Taxes",17]
[null,"3.1.2014","Revenue - Supermarkets",69]
[null,"3.1.2014","Cogs - Supermarkets",58]
[null,"3.1.2014","Revenue - Discounters",32]
[null,"3.1.2014","Cogs - Discounters",12]
[null,"3.1.2014","Revenue - Grocery",41]
[null,"3.1.2014","Cogs - Grocery",11]
[null,"3.1.2014","Revenue - Retail",64]
[null,"3.1.2014","Cogs - Retail",35]
[null,"3.1.2014","Operating expenses",96.6]
[null,"3.1.2014","D&A",3]
[null,"3.1.2014","Interest expenses",5]
[null,"3.1.2014","Taxes",17.850000000000001]
[null,"4.1.2014","Revenue - Supermarkets",68]
[null,"4.1.2014","Cogs - Supermarkets",50]
[null,"4.1.2014","Revenue - Discounters",29]
[null,"4.1.2014","Cogs - Discounters",19]
[null,"4.1.2014","Revenue - Grocery",38]
[null,"4.1.2014","Cogs - Grocery",15]
[null,"4.1.2014","Revenue - Retail",60]
[null,"4.1.2014","Cogs - Retail",32]
[null,"4.1.2014","Operating expenses",99.52]
[null,"4.1.2014","D&A",2]
[null,"4.1.2014","Interest expenses",5]
[null,"4.1.2014","Taxes",16.89]
[null,"5.1.2014","Revenue - Supermarkets",68]
[null,"5.1.2014","Cogs - Supermarkets",54]
[null,"5.1.2014","Revenue - Discounters",32]
[null,"5.1.2014","Cogs - Discounters",19]
[null,"5.1.2014","Revenue - Grocery",50]
[null,"5.1.2014","Cogs - Grocery",14]
[null,"5.1.2014","Revenue - Retail",64]
[null,"5.1.2014","Cogs - Retail",30]
[null,"5.1.2014","Operating expenses",105.92]
[null,"5.1.2014","D&A",3]
[null,"5.1.2014","Interest expenses",5]
[null,"5.1.2014","Taxes",18.579999999999998]
[null,"6.1.2014","Revenue - Supermarkets",56]
[null,"6.1.2014","Cogs - Supermarkets",49]
[null,"6.1.2014","Revenue - Discounters",31]
[null,"6.1.2014","Cogs - Discounters",14]
[null,"6.1.2014","Revenue - Grocery",36]
[null,"6.1.2014","Cogs - Grocery",15]
[null,"6.1.2014","Revenue - Retail",57]
[null,"6.1.2014","Cogs - Retail",33]
[null,"6.1.2014","Operating expenses",93.12]
[null,"6.1.2014","D&A",3]
[null,"6.1.2014","Interest expenses",4]
[null,"6.1.2014","Taxes",15.59]
[null,"7.1.2014","Revenue - Supermarkets",66]
[null,"7.1.2014","Cogs - Supermarkets",55]
[null,"7.1.2014","Revenue - Discounters",38]
[null,"7.1.2014","Cogs - Discounters",17]
[null,"7.1.2014","Revenue - Grocery",43]
[null,"7.1.2014","Cogs - Grocery",17]
[null,"7.1.2014","Revenue - Retail",68]
[null,"7.1.2014","Cogs - Retail",33]
[null,"7.1.2014","Operating expenses",114.58000000000001]
[null,"7.1.2014","D&A",3]
[null,"7.1.2014","Interest expenses",4]
[null,"7.1.2014","Taxes",18.61]
[null,"8.1.2014","Revenue - Supermarkets",57]
[null,"8.1.2014","Cogs - Supermarkets",52]
[null,"8.1.2014","Revenue - Discounters",35]
[null,"8.1.2014","Cogs - Discounters",19]
[null,"8.1.2014","Revenue - Grocery",38]
[null,"8.1.2014","Cogs - Grocery",16]
[null,"8.1.2014","Revenue - Retail",57]
[null,"8.1.2014","Cogs - Retail",33]
[null,"8.1.2014","Operating expenses",104.38000000000001]
[null,"8.1.2014","D&A",3]
[null,"8.1.2014","Interest expenses",5]
[null,"8.1.2014","Taxes",16.13]
[null,"9.1.2014","Revenue - Supermarkets",60]
[null,"9.1.2014","Cogs - Supermarkets",57]
[null,"9.1.2014","Revenue - Discounters",28]
[null,"9.1.2014","Cogs - Discounters",11]
[null,"9.1.2014","Revenue - Grocery",44]
[null,"9.1.2014","Cogs - Grocery",12]
[null,"9.1.2014","Revenue - Retail",67]
[null,"9.1.2014","Cogs - Retail",31]
[null,"9.1.2014","Operating expenses",108.5]
[null,"9.1.2014","D&A",2]
[null,"9.1.2014","Interest expenses",4]
[null,"9.1.2014","Taxes",17.419999999999998]
[null,"10.1.2014","Revenue - Supermarkets",59]
[null,"10.1.2014","Cogs - Supermarkets",57]
[null,"10.1.2014","Revenue - Discounters",40]
[null,"10.1.2014","Cogs - Discounters",11]
[null,"10.1.2014","Revenue - Grocery",35]
[null,"10.1.2014","Cogs - Grocery",15]
[null,"10.1.2014","Revenue - Retail",61]
[null,"10.1.2014","Cogs - Retail",35]
[null,"10.1.2014","Operating expenses",97.03]
[null,"10.1.2014","D&A",3]
[null,"10.1.2014","Interest expenses",4]
[null,"10.1.2014","Taxes",16.77]
[null,"11.1.2014","Revenue - Supermarkets",69]
[null,"11.1.2014","Cogs - Supermarkets",45]
[null,"11.1.2014","Revenue - Discounters",25]
[null,"11.1.2014","Cogs - Discounters",17]
[null,"11.1.2014","Revenue - Grocery",45]
[null,"11.1.2014","Cogs - Grocery",10]
[null,"11.1.2014","Revenue - Retail",63]
[null,"11.1.2014","Cogs - Retail",31]
[null,"11.1.2014","Operating expenses",97.600000000000009]
[null,"11.1.2014","D&A",2]
[null,"11.1.2014","Interest expenses",5]
[null,"11.1.2014","Taxes",17.62]
[null,"12.1.2014","Revenue - Supermarkets",74]
[null,"12.1.2014","Cogs - Supermarkets",55]
[null,"12.1.2014","Revenue - Discounters",31]
[null,"12.1.2014","Cogs - Discounters",19]
[null,"12.1.2014","Revenue - Grocery",42]
[null,"12.1.2014","Cogs - Grocery",19]
[null,"12.1.2014","Revenue - Retail",59]
[null,"12.1.2014","Cogs - Retail",34]
[null,"12.1.2014","Operating expenses",103.23]
[null,"12.1.2014","D&A",3]
[null,"12.1.2014","Interest expenses",5]
[null,"12.1.2014","Taxes",17.77]
[null,"1.1.2015","Revenue - Supermarkets",56]
[null,"1.1.2015","Cogs - Supermarkets",49]
[null,"1.1.2015","Revenue - Discounters",38]
[null,"1.1.2015","Cogs - Discounters",13]
[null,"1.1.2015","Revenue - Grocery",49]
[null,"1.1.2015","Cogs - Grocery",13]
[null,"1.1.2015","Revenue - Retail",67]
[null,"1.1.2015","Cogs - Retail",30]
[null,"1.1.2015","Operating expenses",107.10000000000001]
[null,"1.1.2015","D&A",4]
[null,"1.1.2015","Interest expenses",6]
[null,"1.1.2015","Taxes",18.25]
[null,"2.1.2015","Revenue - Supermarkets",73]
[null,"2.1.2015","Cogs - Supermarkets",60]
[null,"2.1.2015","Revenue - Discounters",40]
[null,"2.1.2015","Cogs - Discounters",15]
[null,"2.1.2015","Revenue - Grocery",41]
[null,"2.1.2015","Cogs - Grocery",12]
[null,"2.1.2015","Revenue - Retail",59]
[null,"2.1.2015","Cogs - Retail",35]
[null,"2.1.2015","Operating expenses",107.2]
[null,"2.1.2015","D&A",3]
[null,"2.1.2015","Interest expenses",5]
[null,"2.1.2015","Taxes",18.23]
[null,"3.1.2015","Revenue - Supermarkets",55]
[null,"3.1.2015","Cogs - Supermarkets",49]
[null,"3.1.2015","Revenue - Discounters",37]
[null,"3.1.2015","Cogs - Discounters",20]
[null,"3.1.2015","Revenue - Grocery",46]
[null,"3.1.2015","Cogs - Grocery",18]
[null,"3.1.2015","Revenue - Retail",56]
[null,"3.1.2015","Cogs - Retail",35]
[null,"3.1.2015","Operating expenses",104.28]
[null,"3.1.2015","D&A",4]
[null,"3.1.2015","Interest expenses",6]
[null,"3.1.2015","Taxes",16.73]
[null,"4.1.2015","Revenue - Supermarkets",56]
[null,"4.1.2015","Cogs - Supermarkets",47]
[null,"4.1.2015","Revenue - Discounters",38]
[null,"4.1.2015","Cogs - Discounters",13]
[null,"4.1.2015","Revenue - Grocery",41]
[null,"4.1.2015","Cogs - Grocery",18]
[null,"4.1.2015","Revenue - Retail",57]
[null,"4.1.2015","Cogs - Retail",32]
[null,"4.1.2015","Operating expenses",105.69999999999999]
[null,"4.1.2015","D&A",3]
[null,"4.1.2015","Interest expenses",5]
[null,"4.1.2015","Taxes",16.53]
[null,"5.1.2015","Revenue - Supermarkets",62]
[null,"5.1.2015","Cogs - Supermarkets",46]
[null,"5.1.2015","Revenue - Discounters",37]
[null,"5.1.2015","Cogs - Discounters",18]
[null,"5.1.2015","Revenue - Grocery",35]
[null,"5.1.2015","Cogs - Grocery",17]
[null,"5.1.2015","Revenue - Retail",57]
[null,"5.1.2015","Cogs - Retail",32]
[null,"5.1.2015","Operating expenses",109.44]
[null,"5.1.2015","D&A",3]
[null,"5.1.2015","Interest expenses",5]
[null,"5.1.2015","Taxes",16.400000000000002]
[null,"6.1.2015","Revenue - Supermarkets",70]
[null,"6.1.2015","Cogs - Supermarkets",56]
[null,"6.1.2015","Revenue - Discounters",33]
[null,"6.1.2015","Cogs - Discounters",16]
[null,"6.1.2015","Revenue - Grocery",49]
[null,"6.1.2015","Cogs - Grocery",17]
[null,"6.1.2015","Revenue - Retail",64]
[null,"6.1.2015","Cogs - Retail",33]
[null,"6.1.2015","Operating expenses",104.78]
[null,"6.1.2015","D&A",4]
[null,"6.1.2015","Interest expenses",6]
[null,"6.1.2015","Taxes",18.72]
[null,"7.1.2015","Revenue - Supermarkets",68]
[null,"7.1.2015","Cogs - Supermarkets",52]
[null,"7.1.2015","Revenue - Discounters",33]
[null,"7.1.2015","Cogs - Discounters",16]
[null,"7.1.2015","Revenue - Grocery",40]
[null,"7.1.2015","Cogs - Grocery",15]
[null,"7.1.2015","Revenue - Retail",55]
[null,"7.1.2015","Cogs - Retail",31]
[null,"7.1.2015","Operating expenses",99.2]
[null,"7.1.2015","D&A",4]
[null,"7.1.2015","Interest expenses",5]
[null,"7.1.2015","Taxes",16.850000000000001]
[null,"8.1.2015","Revenue - Supermarkets",69]
[null,"8.1.2015","Cogs - Supermarkets",48]
[null,"8.1.2015","Revenue - Discounters",39]
[null,"8.1.2015","Cogs - Discounters",20]
[null,"8.1.2015","Revenue - Grocery",50]
[null,"8.1.2015","Cogs - Grocery",15]
[null,"8.1.2015","Revenue - Retail",64]
[null,"8.1.2015","Cogs - Retail",32]
[null,"8.1.2015","Operating expenses",104.47]
[null,"8.1.2015","D&A",4]
[null,"8.1.2015","Interest expenses",5]
[null,"8.1.2015","Taxes",19.149999999999999]
[null,"9.1.2015","Revenue - Supermarkets",57]
[null,"9.1.2015","Cogs - Supermarkets",53]
[null,"9.1.2015","Revenue - Discounters",28]
[null,"9.1.2015","Cogs - Discounters",17]
[null,"9.1.2015","Revenue - Grocery",42]
[null,"9.1.2015","Cogs - Grocery",14]
[null,"9.1.2015","Revenue - Retail",57]
[null,"9.1.2015","Cogs - Retail",32]
[null,"9.1.2015","Operating expenses",96]
[null,"9.1.2015","D&A",4]
[null,"9.1.2015","Interest expenses",5]
[null,"9.1.2015","Taxes",16]
[null,"10.1.2015","Revenue - Supermarkets",72]
[null,"10.1.2015","Cogs - Supermarkets",58]
[null,"10.1.2015","Revenue - Discounters",39]
[null,"10.1.2015","Cogs - Discounters",13]
[null,"10.1.2015","Revenue - Grocery",39]
[null,"10.1.2015","Cogs - Grocery",14]
[null,"10.1.2015","Revenue - Retail",56]
[null,"10.1.2015","Cogs - Retail",32]
[null,"10.1.2015","Operating expenses",106.59]
[null,"10.1.2015","D&A",4]
[null,"10.1.2015","Interest expenses",6]
[null,"10.1.2015","Taxes",17.600000000000001]
[null,"11.1.2015","Revenue - Supermarkets",64]
[null,"11.1.2015","Cogs - Supermarkets",55]
[null,"11.1.2015","Revenue - Discounters",28]
[null,"11.1.2015","Cogs - Discounters",16]
[null,"11.1.2015","Revenue - Grocery",40]
[null,"11.1.2015","Cogs - Grocery",11]
[null,"11.1.2015","Revenue - Retail",63]
[null,"11.1.2015","Cogs - Retail",34]
[null,"11.1.2015","Operating expenses",99.52]
[null,"11.1.2015","D&A",4]
[null,"11.1.2015","Interest expenses",5]
[null,"11.1.2015","Taxes",16.98]
[null,"12.1.2015","Revenue - Supermarkets",69]
[null,"12.1.2015","Cogs - Supermarkets",48]
[null,"12.1.2015","Revenue - Discounters",36]
[null,"12.1.2015","Cogs - Discounters",19]
[null,"12.1.2015","Revenue - Grocery",50]
[null,"12.1.2015","Cogs - Grocery",13]
[null,"12.1.2015","Revenue - Retail",60]
[null,"12.1.2015","Cogs - Retail",31]
[null,"12.1.2015","Operating expenses",101.06]
[null,"12.1.2015","D&A",3]
[null,"12.1.2015","Interest expenses",6]
[null,"12.1.2015","Taxes",18.54]
[null,"1.1.2016","Revenue - Supermarkets",57]
[null,"1.1.2016","Cogs - Supermarkets",47]
[null,"1.1.2016","Revenue - Discounters",35]
[null,"1.1.2016","Cogs - Discounters",17]
[null,"1.1.2016","Revenue - Grocery",41]
[null,"1.1.2016","Cogs - Grocery",11]
[null,"1.1.2016","Revenue - Retail",61]
[null,"1.1.2016","Cogs - Retail",35]
[null,"1.1.2016","Operating expenses",88.16]
[null,"1.1.2016","D&A",3]
[null,"1.1.2016","Interest expenses",3]
[null,"1.1.2016","Taxes",16.8]
[null,"2.1.2016","Revenue - Supermarkets",72]
[null,"2.1.2016","Cogs - Supermarkets",57]
[null,"2.1.2016","Revenue - Discounters",29]
[null,"2.1.2016","Cogs - Discounters",16]
[null,"2.1.2016","Revenue - Grocery",49]
[null,"2.1.2016","Cogs - Grocery",19]
[null,"2.1.2016","Revenue - Retail",57]
[null,"2.1.2016","Cogs - Retail",35]
[null,"2.1.2016","Operating expenses",96.86]
[null,"2.1.2016","D&A",4]
[null,"2.1.2016","Interest expenses",4]
[null,"2.1.2016","Taxes",17.899999999999999]
[null,"3.1.2016","Revenue - Supermarkets",61]
[null,"3.1.2016","Cogs - Supermarkets",52]
[null,"3.1.2016","Revenue - Discounters",27]
[null,"3.1.2016","Cogs - Discounters",13]
[null,"3.1.2016","Revenue - Grocery",38]
[null,"3.1.2016","Cogs - Grocery",17]
[null,"3.1.2016","Revenue - Retail",63]
[null,"3.1.2016","Cogs - Retail",31]
[null,"3.1.2016","Operating expenses",87.58]
[null,"3.1.2016","D&A",4]
[null,"3.1.2016","Interest expenses",4]
[null,"3.1.2016","Taxes",16.490000000000002]
[null,"4.1.2016","Revenue - Supermarkets",62]
[null,"4.1.2016","Cogs - Supermarkets",48]
[null,"4.1.2016","Revenue - Discounters",25]
[null,"4.1.2016","Cogs - Discounters",20]
[null,"4.1.2016","Revenue - Grocery",47]
[null,"4.1.2016","Cogs - Grocery",11]
[null,"4.1.2016","Revenue - Retail",56]
[null,"4.1.2016","Cogs - Retail",30]
[null,"4.1.2016","Operating expenses",80.73]
[null,"4.1.2016","D&A",3]
[null,"4.1.2016","Interest expenses",4]
[null,"4.1.2016","Taxes",16.54]
[null,"5.1.2016","Revenue - Supermarkets",59]
[null,"5.1.2016","Cogs - Supermarkets",58]
[null,"5.1.2016","Revenue - Discounters",32]
[null,"5.1.2016","Cogs - Discounters",13]
[null,"5.1.2016","Revenue - Grocery",41]
[null,"5.1.2016","Cogs - Grocery",13]
[null,"5.1.2016","Revenue - Retail",54]
[null,"5.1.2016","Cogs - Retail",35]
[null,"5.1.2016","Operating expenses",88.449999999999989]
[null,"5.1.2016","D&A",4]
[null,"5.1.2016","Interest expenses",5]
[null,"5.1.2016","Taxes",16.05]
[null,"6.1.2016","Revenue - Supermarkets",67]
[null,"6.1.2016","Cogs - Supermarkets",56]
[null,"6.1.2016","Revenue - Discounters",31]
[null,"6.1.2016","Cogs - Discounters",18]
[null,"6.1.2016","Revenue - Grocery",47]
[null,"6.1.2016","Cogs - Grocery",17]
[null,"6.1.2016","Revenue - Retail",66]
[null,"6.1.2016","Cogs - Retail",30]
[null,"6.1.2016","Operating expenses",102.92]
[null,"6.1.2016","D&A",3]
[null,"6.1.2016","Interest expenses",4]
[null,"6.1.2016","Taxes",18.360000000000003]
[null,"7.1.2016","Revenue - Supermarkets",70]
[null,"7.1.2016","Cogs - Supermarkets",52]
[null,"7.1.2016","Revenue - Discounters",37]
[null,"7.1.2016","Cogs - Discounters",10]
[null,"7.1.2016","Revenue - Grocery",35]
[null,"7.1.2016","Cogs - Grocery",18]
[null,"7.1.2016","Revenue - Retail",59]
[null,"7.1.2016","Cogs - Retail",35]
[null,"7.1.2016","Operating expenses",104.28]
[null,"7.1.2016","D&A",3]
[null,"7.1.2016","Interest expenses",5]
[null,"7.1.2016","Taxes",17.240000000000002]
[null,"8.1.2016","Revenue - Supermarkets",75]
[null,"8.1.2016","Cogs - Supermarkets",47]
[null,"8.1.2016","Revenue - Discounters",27]
[null,"8.1.2016","Cogs - Discounters",19]
[null,"8.1.2016","Revenue - Grocery",45]
[null,"8.1.2016","Cogs - Grocery",11]
[null,"8.1.2016","Revenue - Retail",59]
[null,"8.1.2016","Cogs - Retail",30]
[null,"8.1.2016","Operating expenses",78.25]
[null,"8.1.2016","D&A",4]
[null,"8.1.2016","Interest expenses",5]
[null,"8.1.2016","Taxes",17.840000000000003]
[null,"9.1.2016","Revenue - Supermarkets",65]
[null,"9.1.2016","Cogs - Supermarkets",47]
[null,"9.1.2016","Revenue - Discounters",38]
[null,"9.1.2016","Cogs - Discounters",13]
[null,"9.1.2016","Revenue - Grocery",39]
[null,"9.1.2016","Cogs - Grocery",11]
[null,"9.1.2016","Revenue - Retail",58]
[null,"9.1.2016","Cogs - Retail",32]
[null,"9.1.2016","Operating expenses",78.78]
[null,"9.1.2016","D&A",3]
[null,"9.1.2016","Interest expenses",4]
[null,"9.1.2016","Taxes",17.170000000000002]
[null,"10.1.2016","Revenue - Supermarkets",72]
[null,"10.1.2016","Cogs - Supermarkets",51]
[null,"10.1.2016","Revenue - Discounters",34]
[null,"10.1.2016","Cogs - Discounters",16]
[null,"10.1.2016","Revenue - Grocery",39]
[null,"10.1.2016","Cogs - Grocery",10]
[null,"10.1.2016","Revenue - Retail",64]
[null,"10.1.2016","Cogs - Retail",35]
[null,"10.1.2016","Operating expenses",83.460000000000008]
[null,"10.1.2016","D&A",3]
[null,"10.1.2016","Interest expenses",5]
[null,"10.1.2016","Taxes",18.05]
[null,"11.1.2016","Revenue - Supermarkets",64]
[null,"11.1.2016","Cogs - Supermarkets",52]
[null,"11.1.2016","Revenue - Discounters",37]
[null,"11.1.2016","Cogs - Discounters",15]
[null,"11.1.2016","Revenue - Grocery",50]
[null,"11.1.2016","Cogs - Grocery",14]
[null,"11.1.2016","Revenue - Retail",58]
[null,"11.1.2016","Cogs - Retail",33]
[null,"11.1.2016","Operating expenses",87.210000000000008]
[null,"11.1.2016","D&A",3]
[null,"11.1.2016","Interest expenses",5]
[null,"11.1.2016","Taxes",18.010000000000002]
[null,"12.1.2016","Revenue - Supermarkets",66]
[null,"12.1.2016","Cogs - Supermarkets",56]
[null,"12.1.2016","Revenue - Discounters",38]
[null,"12.1.2016","Cogs - Discounters",13]
[null,"12.1.2016","Revenue - Grocery",41]
[null,"12.1.2016","Cogs - Grocery",18]
[null,"12.1.2016","Revenue - Retail",65]
[null,"12.1.2016","Cogs - Retail",30]
[null,"12.1.2016","Operating expenses",91.56]
[null,"12.1.2016","D&A",4]
[null,"12.1.2016","Interest expenses",4]
[null,"12.1.2016","Taxes",18.130000000000003]
[null,"12.1.2014","Other revenue",524]
[null,"12.1.2015","Other revenue",550]
[null,"12.1.2016","Other revenue",628]

{"sheet":"BS 2014","index":1,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["$ in mln",null,"2014-12-31"]
["Receivables - Discounters",null,44.609000000000002]
["Receivables - Other",null,33.097000000000001]
["Receivables - Grocery",null,31.658000000000001]
["Receivables - Retail",null,20.146000000000004]
["Receivables - Supermarkets",null,14.39]
["Trade Receivables",null,143.9]
[]
["Inventory - Discounters",null,29.749999999999996]
["Inventory - Supermarkets",null,18.7]
["Inventory - Grocery",null,16.149999999999999]
["Inventory - Retail",null,11.05]
["Inventory - Other",null,9.35]
["Inventory",null,84.999999999999986]
[]
["PP&E - Machinery",null,346.47500000000002]
["PP&E - Other",null,139.52500000000001]
["PP&E - IT",null,125.575]
["PP&E - Vehicles",null,20.925000000000001]
["PP&E",null,632.5]
[]
["Cash - Bank Accounts",null,16.12]
["Cash - T-bills",null,6.2]
["Cash - Cash at hand",null,2.4800000000000004]
["Cash",null,24.8]
[]
["Other assets",null,45.9]
["Other assets",null,45.9]
[]
["Assets",null,932.09999999999991]
[]
["Trade Payables - Discounters",null,17]
["Trade Payables - Other",null,17]
["Trade Payables - Supermarkets",null,14.96]
["Trade Payables - Grocery",null,10.199999999999999]
["Trade Payables - Retail",null,8.84]
["Trade Payables",null,68]
[]
["Provisions - Taxes",null,22.424999999999997]
["Provisions - Legal",null,6.8250000000000002]
["Provisions - Other",null,3.25]
["Provisions",null,32.5]
[]
["Financial Liabilities vs. Banks",null,615.79999999999995]
["Financial Liabilities",null,615.79999999999995]
[]
["Other liabilities",null,48.3]
["Other liabilities",null,48.3]
[]
["Retained Earnings",null,132.32500000000002]
["Minority interest",null,18.425000000000001]
["Share Capital",null,16.75]
["Equity",null,167.50000000000003]
[]
["Liabilities & Equity",null,932.1]

{"sheet":"BS 2015","index":2,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["$ in mln","Code I","2015-12-31"]
["Receivables - Discounters","R",40.248000000000005]
["Receivables - Grocery","R",34.056000000000004]
["Receivables - Other","R",29.412000000000003]
["Receivables - Retail","R",27.864000000000001]
["Receivables - Supermarkets","R",23.220000000000002]
["Trade Receivables",null,154.80000000000001]
[]
["Inventory - Discounters","I",24.840000000000003]
["Inventory - Supermarkets","I",20.239999999999998]
["Inventory - Grocery","I",17.48]
["Inventory - Other","I",17.48]
["Inventory - Retail","I",11.96]
["Inventory","I",92.000000000000014]
[]
["PP&E - Machinery","P",346.47500000000002]
["PP&E - Other","P",139.52500000000001]
["PP&E - IT","P",125.575]
["PP&E - Vehicles","P",20.925000000000001]
["PP&E","P",632.5]
[]
["Cash - Bank Accounts","C",13.298]
["Cash - T-bills","C",5.45]
["Cash - Cash at hand","C",3.0520000000000005]
["Cash",null,21.8]
[]
["Other assets","O",46.9]
["Other assets",null,46.9]
[]
["Assets",null,947.99999999999989]
[]
["Trade Payables - Discounters","T",19.981000000000002]
["Trade Payables - Retail","T",15.847000000000001]
["Trade Payables - Other","T",14.469000000000001]
["Trade Payables - Grocery","T",10.335000000000001]
["Trade Payables - Supermarkets","T",8.2680000000000007]
["Trade Payables",null,68.900000000000006]
[]
["Provisions - Taxes","P",17.506999999999998]
["Provisions - Legal","P",6.601]
["Provisions - Other","P",4.5919999999999996]
["Provisions",null,28.699999999999996]
[]
["Financial Liabilities vs. Banks","F",610.4]
["Financial Liabilities",null,610.4]
[]
["Other liabilities","O",43.3]
["Other liabilities",null,43.3]
[]
["Retained Earnings","E",161.52499999999998]
["Minority interest","E",18.425000000000001]
["Share Capital","E",16.75]
["Equity",null,196.7]
[]
["Liabilities & Equity",null,948]

{"sheet":"BS 2016","index":3,"n_rows":55,"n_cols":4,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["$ in mln","Code I","Code II","2016-12-31"]
["Receivables - Discounters","R","A",44.018000000000008]
["Receivables - Grocery","R","A",40.631999999999998]
["Receivables - Other","R","A",32.167000000000002]
["Receivables - Retail","R","A",27.088000000000001]
["Receivables - Supermarkets","R","A",25.395]
["Trade Receivables",null,null,169.3]
[]
["Inventory - Discounters","I","A",26.4]
["Inventory - Supermarkets","I","A",25.3]
["Inventory - Grocery","I","A",20.9]
["Inventory - Other","I","A",20.9]
["Inventory - Retail","I","A",16.5]
["Inventory","I",null,110]
[]
["PP&E - Machinery","P","A",350.51]
["PP&E - Other","P","A",146.71]
["PP&E - IT","P","A",133.73500000000001]
["PP&E - Vehicles","P","A",28.545000000000002]
["PP&E",null,null,659.5]
[]
["Cash - Bank Accounts","C","A",125.39999999999999]
["Cash - T-bills","C","A",59.400000000000006]
["Cash - Cash at hand","C","A",35.200000000000003]
["Cash",null,null,220]
[]
["Other assets","O","A",68]
["Other assets",null,null,68]
[]
["Assets",null,null,1226.8]
[]
["Trade Payables - Discounters","T","L",19.981000000000002]
["Trade Payables - Retail","T","L",15.847000000000001]
["Trade Payables - Other","T","L",14.469000000000001]
["Trade Payables - Grocery","T","L",10.335000000000001]
["Trade Payables - Supermarkets","T","L",8.2680000000000007]
["Trade Payables",null,null,68.900000000000006]
[]
["Provisions - Taxes","P","L",17.506999999999998]
["Provisions - Legal","P","L",6.601]
["Provisions - Other","P","L",4.5919999999999996]
["Provisions",null,null,28.699999999999996]
[]
["Financial Liabilities vs. Banks","F","L",605]
["Financial Liabilities",null,null,605]
[]
["Other liabilities","O","L",38.9]
["Other liabilities",null,null,38.9]
[]
["Retained Earnings","E","E",450.125]
["Minority interest","E","E",18.425000000000001]
["Share Capital","E","E",16.75]
["Equity",null,null,485.3]
[]
["Liabilities & Equity",null,null,1226.8000000000002]

{"sheet":"Exercise -->","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercise -->"]

{"sheet":"1.1","index":5,"n_rows":438,"n_cols":6,"rows_kept":438,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Date","Year","Financials","Amount","Mapping"]
[null,"2014-01-01",{"$f":"YEAR(B4)","v":2014},"Revenue - Supermarkets",72,"Revenue"]
[null,"2014-01-01",{"$f":"YEAR(B5)","v":2014},"Cogs - Supermarkets",47,"Cogs"]
[null,"2014-01-01",2014,"Revenue - Discounters",37,"Revenue"]
[null,"2014-01-01",2014,"Cogs - Discounters",20,"Cogs"]
[null,"2014-01-01",2014,"Revenue - Grocery",36,"Revenue"]
[null,"2014-01-01",2014,"Cogs - Grocery",17,"Cogs"]
[null,"2014-01-01",2014,"Revenue - Retail",57,"Revenue"]
[null,"2014-01-01",2014,"Cogs - Retail",32,"Cogs"]
[null,"2014-01-01",2014,"Operating expenses",95.399999999999991,"Operating expenses"]
[null,"2014-01-01",2014,"D&A",2,"D&A"]
[null,"2014-01-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-01-01",2014,"Taxes",17.29,"Taxes"]
[null,"2014-02-01",2014,"Revenue - Supermarkets",75,"Revenue"]
[null,"2014-02-01",2014,"Cogs - Supermarkets",55,"Cogs"]
[null,"2014-02-01",2014,"Revenue - Discounters",26,"Revenue"]
[null,"2014-02-01",2014,"Cogs - Discounters",18,"Cogs"]
[null,"2014-02-01",2014,"Revenue - Grocery",42,"Revenue"]
[null,"2014-02-01",2014,"Cogs - Grocery",18,"Cogs"]
[null,"2014-02-01",2014,"Revenue - Retail",54,"Revenue"]
[null,"2014-02-01",2014,"Cogs - Retail",33,"Cogs"]
[null,"2014-02-01",2014,"Operating expenses",96.3,"Operating expenses"]
[null,"2014-02-01",2014,"D&A",2,"D&A"]
[null,"2014-02-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-02-01",2014,"Taxes",17,"Taxes"]
[null,"2014-03-01",2014,"Revenue - Supermarkets",69,"Revenue"]
[null,"2014-03-01",2014,"Cogs - Supermarkets",58,"Cogs"]
[null,"2014-03-01",2014,"Revenue - Discounters",32,"Revenue"]
[null,"2014-03-01",2014,"Cogs - Discounters",12,"Cogs"]
[null,"2014-03-01",2014,"Revenue - Grocery",41,"Revenue"]
[null,"2014-03-01",2014,"Cogs - Grocery",11,"Cogs"]
[null,"2014-03-01",2014,"Revenue - Retail",64,"Revenue"]
[null,"2014-03-01",2014,"Cogs - Retail",35,"Cogs"]
[null,"2014-03-01",2014,"Operating expenses",96.6,"Operating expenses"]
[null,"2014-03-01",2014,"D&A",3,"D&A"]
[null,"2014-03-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-03-01",2014,"Taxes",17.850000000000001,"Taxes"]
[null,"2014-04-01",2014,"Revenue - Supermarkets",68,"Revenue"]
[null,"2014-04-01",2014,"Cogs - Supermarkets",50,"Cogs"]
[null,"2014-04-01",2014,"Revenue - Discounters",29,"Revenue"]
[null,"2014-04-01",2014,"Cogs - Discounters",19,"Cogs"]
[null,"2014-04-01",2014,"Revenue - Grocery",38,"Revenue"]
[null,"2014-04-01",2014,"Cogs - Grocery",15,"Cogs"]
[null,"2014-04-01",2014,"Revenue - Retail",60,"Revenue"]
[null,"2014-04-01",2014,"Cogs - Retail",32,"Cogs"]
[null,"2014-04-01",2014,"Operating expenses",99.52,"Operating expenses"]
[null,"2014-04-01",2014,"D&A",2,"D&A"]
[null,"2014-04-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-04-01",2014,"Taxes",16.89,"Taxes"]
[null,"2014-05-01",2014,"Revenue - Supermarkets",68,"Revenue"]
[null,"2014-05-01",2014,"Cogs - Supermarkets",54,"Cogs"]
[null,"2014-05-01",2014,"Revenue - Discounters",32,"Revenue"]
[null,"2014-05-01",2014,"Cogs - Discounters",19,"Cogs"]
[null,"2014-05-01",2014,"Revenue - Grocery",50,"Revenue"]
[null,"2014-05-01",2014,"Cogs - Grocery",14,"Cogs"]
[null,"2014-05-01",2014,"Revenue - Retail",64,"Revenue"]
[null,"2014-05-01",2014,"Cogs - Retail",30,"Cogs"]
[null,"2014-05-01",2014,"Operating expenses",105.92,"Operating expenses"]
[null,"2014-05-01",2014,"D&A",3,"D&A"]
[null,"2014-05-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-05-01",2014,"Taxes",18.579999999999998,"Taxes"]
[null,"2014-06-01",2014,"Revenue - Supermarkets",56,"Revenue"]
[null,"2014-06-01",2014,"Cogs - Supermarkets",49,"Cogs"]
[null,"2014-06-01",2014,"Revenue - Discounters",31,"Revenue"]
[null,"2014-06-01",2014,"Cogs - Discounters",14,"Cogs"]
[null,"2014-06-01",2014,"Revenue - Grocery",36,"Revenue"]
[null,"2014-06-01",{"$f":"YEAR(B69)","v":2014},"Cogs - Grocery",15,"Cogs"]
[null,"2014-06-01",2014,"Revenue - Retail",57,"Revenue"]
[null,"2014-06-01",2014,"Cogs - Retail",33,"Cogs"]
[null,"2014-06-01",2014,"Operating expenses",93.12,"Operating expenses"]
[null,"2014-06-01",2014,"D&A",3,"D&A"]
[null,"2014-06-01",2014,"Interest expenses",4,"Interest"]
[null,"2014-06-01",2014,"Taxes",15.59,"Taxes"]
[null,"2014-07-01",2014,"Revenue - Supermarkets",66,"Revenue"]
[null,"2014-07-01",2014,"Cogs - Supermarkets",55,"Cogs"]
[null,"2014-07-01",2014,"Revenue - Discounters",38,"Revenue"]
[null,"2014-07-01",2014,"Cogs - Discounters",17,"Cogs"]
[null,"2014-07-01",2014,"Revenue - Grocery",43,"Revenue"]
[null,"2014-07-01",2014,"Cogs - Grocery",17,"Cogs"]
[null,"2014-07-01",2014,"Revenue - Retail",68,"Revenue"]
[null,"2014-07-01",2014,"Cogs - Retail",33,"Cogs"]
[null,"2014-07-01",2014,"Operating expenses",114.58000000000001,"Operating expenses"]
[null,"2014-07-01",2014,"D&A",3,"D&A"]
[null,"2014-07-01",2014,"Interest expenses",4,"Interest"]
[null,"2014-07-01",2014,"Taxes",18.61,"Taxes"]
[null,"2014-08-01",2014,"Revenue - Supermarkets",57,"Revenue"]
[null,"2014-08-01",2014,"Cogs - Supermarkets",52,"Cogs"]
[null,"2014-08-01",2014,"Revenue - Discounters",35,"Revenue"]
[null,"2014-08-01",2014,"Cogs - Discounters",19,"Cogs"]
[null,"2014-08-01",2014,"Revenue - Grocery",38,"Revenue"]
[null,"2014-08-01",2014,"Cogs - Grocery",16,"Cogs"]
[null,"2014-08-01",2014,"Revenue - Retail",57,"Revenue"]
[null,"2014-08-01",2014,"Cogs - Retail",33,"Cogs"]
[null,"2014-08-01",2014,"Operating expenses",104.38000000000001,"Operating expenses"]
[null,"2014-08-01",2014,"D&A",3,"D&A"]
[null,"2014-08-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-08-01",2014,"Taxes",16.13,"Taxes"]
[null,"2014-09-01",2014,"Revenue - Supermarkets",60,"Revenue"]
[null,"2014-09-01",2014,"Cogs - Supermarkets",57,"Cogs"]
[null,"2014-09-01",2014,"Revenue - Discounters",28,"Revenue"]
[null,"2014-09-01",2014,"Cogs - Discounters",11,"Cogs"]
[null,"2014-09-01",2014,"Revenue - Grocery",44,"Revenue"]
[null,"2014-09-01",2014,"Cogs - Grocery",12,"Cogs"]
[null,"2014-09-01",2014,"Revenue - Retail",67,"Revenue"]
[null,"2014-09-01",2014,"Cogs - Retail",31,"Cogs"]
[null,"2014-09-01",2014,"Operating expenses",108.5,"Operating expenses"]
[null,"2014-09-01",2014,"D&A",2,"D&A"]
[null,"2014-09-01",2014,"Interest expenses",4,"Interest"]
[null,"2014-09-01",2014,"Taxes",17.419999999999998,"Taxes"]
[null,"2014-10-01",2014,"Revenue - Supermarkets",59,"Revenue"]
[null,"2014-10-01",2014,"Cogs - Supermarkets",57,"Cogs"]
[null,"2014-10-01",2014,"Revenue - Discounters",40,"Revenue"]
[null,"2014-10-01",2014,"Cogs - Discounters",11,"Cogs"]
[null,"2014-10-01",2014,"Revenue - Grocery",35,"Revenue"]
[null,"2014-10-01",2014,"Cogs - Grocery",15,"Cogs"]
[null,"2014-10-01",2014,"Revenue - Retail",61,"Revenue"]
[null,"2014-10-01",2014,"Cogs - Retail",35,"Cogs"]
[null,"2014-10-01",2014,"Operating expenses",97.03,"Operating expenses"]
[null,"2014-10-01",2014,"D&A",3,"D&A"]
[null,"2014-10-01",2014,"Interest expenses",4,"Interest"]
[null,"2014-10-01",2014,"Taxes",16.77,"Taxes"]
[null,"2014-11-01",2014,"Revenue - Supermarkets",69,"Revenue"]
[null,"2014-11-01",2014,"Cogs - Supermarkets",45,"Cogs"]
[null,"2014-11-01",2014,"Revenue - Discounters",25,"Revenue"]
[null,"2014-11-01",2014,"Cogs - Discounters",17,"Cogs"]
[null,"2014-11-01",2014,"Revenue - Grocery",45,"Revenue"]
[null,"2014-11-01",2014,"Cogs - Grocery",10,"Cogs"]
[null,"2014-11-01",2014,"Revenue - Retail",63,"Revenue"]
[null,"2014-11-01",2014,"Cogs - Retail",31,"Cogs"]
[null,"2014-11-01",2014,"Operating expenses",97.600000000000009,"Operating expenses"]
[null,"2014-11-01",{"$f":"YEAR(B133)","v":2014},"D&A",2,"D&A"]
[null,"2014-11-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-11-01",2014,"Taxes",17.62,"Taxes"]
[null,"2014-12-01",2014,"Revenue - Supermarkets",74,"Revenue"]
[null,"2014-12-01",2014,"Cogs - Supermarkets",55,"Cogs"]
[null,"2014-12-01",2014,"Revenue - Discounters",31,"Revenue"]
[null,"2014-12-01",2014,"Cogs - Discounters",19,"Cogs"]
[null,"2014-12-01",2014,"Revenue - Grocery",42,"Revenue"]
[null,"2014-12-01",2014,"Cogs - Grocery",19,"Cogs"]
[null,"2014-12-01",2014,"Revenue - Retail",59,"Revenue"]
[null,"2014-12-01",2014,"Cogs - Retail",34,"Cogs"]
[null,"2014-12-01",2014,"Operating expenses",103.23,"Operating expenses"]
[null,"2014-12-01",2014,"D&A",3,"D&A"]
[null,"2014-12-01",2014,"Interest expenses",5,"Interest"]
[null,"2014-12-01",2014,"Taxes",17.77,"Taxes"]
[null,"2015-01-01",2015,"Revenue - Supermarkets",56,"Revenue"]
[null,"2015-01-01",2015,"Cogs - Supermarkets",49,"Cogs"]
[null,"2015-01-01",2015,"Revenue - Discounters",38,"Revenue"]
[null,"2015-01-01",2015,"Cogs - Discounters",13,"Cogs"]
[null,"2015-01-01",2015,"Revenue - Grocery",49,"Revenue"]
[null,"2015-01-01",2015,"Cogs - Grocery",13,"Cogs"]
[null,"2015-01-01",2015,"Revenue - Retail",67,"Revenue"]
[null,"2015-01-01",2015,"Cogs - Retail",30,"Cogs"]
[null,"2015-01-01",2015,"Operating expenses",107.10000000000001,"Operating expenses"]
[null,"2015-01-01",2015,"D&A",4,"D&A"]
[null,"2015-01-01",2015,"Interest expenses",6,"Interest"]
[null,"2015-01-01",2015,"Taxes",18.25,"Taxes"]
[null,"2015-02-01",2015,"Revenue - Supermarkets",73,"Revenue"]
[null,"2015-02-01",2015,"Cogs - Supermarkets",60,"Cogs"]
[null,"2015-02-01",2015,"Revenue - Discounters",40,"Revenue"]
[null,"2015-02-01",2015,"Cogs - Discounters",15,"Cogs"]
[null,"2015-02-01",2015,"Revenue - Grocery",41,"Revenue"]
[null,"2015-02-01",2015,"Cogs - Grocery",12,"Cogs"]
[null,"2015-02-01",2015,"Revenue - Retail",59,"Revenue"]
[null,"2015-02-01",2015,"Cogs - Retail",35,"Cogs"]
[null,"2015-02-01",2015,"Operating expenses",107.2,"Operating expenses"]
[null,"2015-02-01",2015,"D&A",3,"D&A"]
[null,"2015-02-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-02-01",2015,"Taxes",18.23,"Taxes"]
[null,"2015-03-01",2015,"Revenue - Supermarkets",55,"Revenue"]
[null,"2015-03-01",2015,"Cogs - Supermarkets",49,"Cogs"]
[null,"2015-03-01",2015,"Revenue - Discounters",37,"Revenue"]
[null,"2015-03-01",2015,"Cogs - Discounters",20,"Cogs"]
[null,"2015-03-01",2015,"Revenue - Grocery",46,"Revenue"]
[null,"2015-03-01",2015,"Cogs - Grocery",18,"Cogs"]
[null,"2015-03-01",2015,"Revenue - Retail",56,"Revenue"]
[null,"2015-03-01",2015,"Cogs - Retail",35,"Cogs"]
[null,"2015-03-01",2015,"Operating expenses",104.28,"Operating expenses"]
[null,"2015-03-01",2015,"D&A",4,"D&A"]
[null,"2015-03-01",2015,"Interest expenses",6,"Interest"]
[null,"2015-03-01",2015,"Taxes",16.73,"Taxes"]
[null,"2015-04-01",2015,"Revenue - Supermarkets",56,"Revenue"]
[null,"2015-04-01",2015,"Cogs - Supermarkets",47,"Cogs"]
[null,"2015-04-01",2015,"Revenue - Discounters",38,"Revenue"]
[null,"2015-04-01",2015,"Cogs - Discounters",13,"Cogs"]
[null,"2015-04-01",2015,"Revenue - Grocery",41,"Revenue"]
[null,"2015-04-01",2015,"Cogs - Grocery",18,"Cogs"]
[null,"2015-04-01",2015,"Revenue - Retail",57,"Revenue"]
[null,"2015-04-01",2015,"Cogs - Retail",32,"Cogs"]
[null,"2015-04-01",2015,"Operating expenses",105.69999999999999,"Operating expenses"]
[null,"2015-04-01",2015,"D&A",3,"D&A"]
[null,"2015-04-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-04-01",2015,"Taxes",16.53,"Taxes"]
[null,"2015-05-01",2015,"Revenue - Supermarkets",62,"Revenue"]
[null,"2015-05-01",{"$f":"YEAR(B197)","v":2015},"Cogs - Supermarkets",46,"Cogs"]
[null,"2015-05-01",2015,"Revenue - Discounters",37,"Revenue"]
[null,"2015-05-01",2015,"Cogs - Discounters",18,"Cogs"]
[null,"2015-05-01",2015,"Revenue - Grocery",35,"Revenue"]
[null,"2015-05-01",2015,"Cogs - Grocery",17,"Cogs"]
[null,"2015-05-01",2015,"Revenue - Retail",57,"Revenue"]
[null,"2015-05-01",2015,"Cogs - Retail",32,"Cogs"]
[null,"2015-05-01",2015,"Operating expenses",109.44,"Operating expenses"]
[null,"2015-05-01",2015,"D&A",3,"D&A"]
[null,"2015-05-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-05-01",2015,"Taxes",16.400000000000002,"Taxes"]
[null,"2015-06-01",2015,"Revenue - Supermarkets",70,"Revenue"]
[null,"2015-06-01",2015,"Cogs - Supermarkets",56,"Cogs"]
[null,"2015-06-01",2015,"Revenue - Discounters",33,"Revenue"]
[null,"2015-06-01",2015,"Cogs - Discounters",16,"Cogs"]
[null,"2015-06-01",2015,"Revenue - Grocery",49,"Revenue"]
[null,"2015-06-01",2015,"Cogs - Grocery",17,"Cogs"]
[null,"2015-06-01",2015,"Revenue - Retail",64,"Revenue"]
[null,"2015-06-01",2015,"Cogs - Retail",33,"Cogs"]
[null,"2015-06-01",2015,"Operating expenses",104.78,"Operating expenses"]
[null,"2015-06-01",2015,"D&A",4,"D&A"]
[null,"2015-06-01",2015,"Interest expenses",6,"Interest"]
[null,"2015-06-01",2015,"Taxes",18.72,"Taxes"]
[null,"2015-07-01",2015,"Revenue - Supermarkets",68,"Revenue"]
[null,"2015-07-01",2015,"Cogs - Supermarkets",52,"Cogs"]
[null,"2015-07-01",2015,"Revenue - Discounters",33,"Revenue"]
[null,"2015-07-01",2015,"Cogs - Discounters",16,"Cogs"]
[null,"2015-07-01",2015,"Revenue - Grocery",40,"Revenue"]
[null,"2015-07-01",2015,"Cogs - Grocery",15,"Cogs"]
[null,"2015-07-01",2015,"Revenue - Retail",55,"Revenue"]
[null,"2015-07-01",2015,"Cogs - Retail",31,"Cogs"]
[null,"2015-07-01",2015,"Operating expenses",99.2,"Operating expenses"]
[null,"2015-07-01",2015,"D&A",4,"D&A"]
[null,"2015-07-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-07-01",2015,"Taxes",16.850000000000001,"Taxes"]
[null,"2015-08-01",2015,"Revenue - Supermarkets",69,"Revenue"]
[null,"2015-08-01",2015,"Cogs - Supermarkets",48,"Cogs"]
[null,"2015-08-01",2015,"Revenue - Discounters",39,"Revenue"]
[null,"2015-08-01",2015,"Cogs - Discounters",20,"Cogs"]
[null,"2015-08-01",2015,"Revenue - Grocery",50,"Revenue"]
[null,"2015-08-01",2015,"Cogs - Grocery",15,"Cogs"]
[null,"2015-08-01",2015,"Revenue - Retail",64,"Revenue"]
[null,"2015-08-01",2015,"Cogs - Retail",32,"Cogs"]
[null,"2015-08-01",2015,"Operating expenses",104.47,"Operating expenses"]
[null,"2015-08-01",2015,"D&A",4,"D&A"]
[null,"2015-08-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-08-01",2015,"Taxes",19.149999999999999,"Taxes"]
[null,"2015-09-01",2015,"Revenue - Supermarkets",57,"Revenue"]
[null,"2015-09-01",2015,"Cogs - Supermarkets",53,"Cogs"]
[null,"2015-09-01",2015,"Revenue - Discounters",28,"Revenue"]
[null,"2015-09-01",2015,"Cogs - Discounters",17,"Cogs"]
[null,"2015-09-01",2015,"Revenue - Grocery",42,"Revenue"]
[null,"2015-09-01",2015,"Cogs - Grocery",14,"Cogs"]
[null,"2015-09-01",2015,"Revenue - Retail",57,"Revenue"]
[null,"2015-09-01",2015,"Cogs - Retail",32,"Cogs"]
[null,"2015-09-01",2015,"Operating expenses",96,"Operating expenses"]
[null,"2015-09-01",2015,"D&A",4,"D&A"]
[null,"2015-09-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-09-01",2015,"Taxes",16,"Taxes"]
[null,"2015-10-01",2015,"Revenue - Supermarkets",72,"Revenue"]
[null,"2015-10-01",2015,"Cogs - Supermarkets",58,"Cogs"]
[null,"2015-10-01",2015,"Revenue - Discounters",39,"Revenue"]
[null,"2015-10-01",2015,"Cogs - Discounters",13,"Cogs"]
[null,"2015-10-01",2015,"Revenue - Grocery",39,"Revenue"]
[null,"2015-10-01",{"$f":"YEAR(B261)","v":2015},"Cogs - Grocery",14,"Cogs"]
[null,"2015-10-01",2015,"Revenue - Retail",56,"Revenue"]
[null,"2015-10-01",2015,"Cogs - Retail",32,"Cogs"]
[null,"2015-10-01",2015,"Operating expenses",106.59,"Operating expenses"]
[null,"2015-10-01",2015,"D&A",4,"D&A"]
[null,"2015-10-01",2015,"Interest expenses",6,"Interest"]
[null,"2015-10-01",2015,"Taxes",17.600000000000001,"Taxes"]
[null,"2015-11-01",2015,"Revenue - Supermarkets",64,"Revenue"]
[null,"2015-11-01",2015,"Cogs - Supermarkets",55,"Cogs"]
[null,"2015-11-01",2015,"Revenue - Discounters",28,"Revenue"]
[null,"2015-11-01",2015,"Cogs - Discounters",16,"Cogs"]
[null,"2015-11-01",2015,"Revenue - Grocery",40,"Revenue"]
[null,"2015-11-01",2015,"Cogs - Grocery",11,"Cogs"]
[null,"2015-11-01",2015,"Revenue - Retail",63,"Revenue"]
[null,"2015-11-01",2015,"Cogs - Retail",34,"Cogs"]
[null,"2015-11-01",2015,"Operating expenses",99.52,"Operating expenses"]
[null,"2015-11-01",2015,"D&A",4,"D&A"]
[null,"2015-11-01",2015,"Interest expenses",5,"Interest"]
[null,"2015-11-01",2015,"Taxes",16.98,"Taxes"]
[null,"2015-12-01",2015,"Revenue - Supermarkets",69,"Revenue"]
[null,"2015-12-01",2015,"Cogs - Supermarkets",48,"Cogs"]
[null,"2015-12-01",2015,"Revenue - Discounters",36,"Revenue"]
[null,"2015-12-01",2015,"Cogs - Discounters",19,"Cogs"]
[null,"2015-12-01",2015,"Revenue - Grocery",50,"Revenue"]
[null,"2015-12-01",2015,"Cogs - Grocery",13,"Cogs"]
[null,"2015-12-01",2015,"Revenue - Retail",60,"Revenue"]
[null,"2015-12-01",2015,"Cogs - Retail",31,"Cogs"]
[null,"2015-12-01",2015,"Operating expenses",101.06,"Operating expenses"]
[null,"2015-12-01",2015,"D&A",3,"D&A"]
[null,"2015-12-01",2015,"Interest expenses",6,"Interest"]
[null,"2015-12-01",2015,"Taxes",18.54,"Taxes"]
[null,"2016-01-01",2016,"Revenue - Supermarkets",57,"Revenue"]
[null,"2016-01-01",2016,"Cogs - Supermarkets",47,"Cogs"]
[null,"2016-01-01",2016,"Revenue - Discounters",35,"Revenue"]
[null,"2016-01-01",2016,"Cogs - Discounters",17,"Cogs"]
[null,"2016-01-01",2016,"Revenue - Grocery",41,"Revenue"]
[null,"2016-01-01",2016,"Cogs - Grocery",11,"Cogs"]
[null,"2016-01-01",2016,"Revenue - Retail",61,"Revenue"]
[null,"2016-01-01",2016,"Cogs - Retail",35,"Cogs"]
[null,"2016-01-01",2016,"Operating expenses",88.16,"Operating expenses"]
[null,"2016-01-01",2016,"D&A",3,"D&A"]
[null,"2016-01-01",2016,"Interest expenses",3,"Interest"]
[null,"2016-01-01",2016,"Taxes",16.8,"Taxes"]
[null,"2016-02-01",2016,"Revenue - Supermarkets",72,"Revenue"]
[null,"2016-02-01",2016,"Cogs - Supermarkets",57,"Cogs"]
[null,"2016-02-01",2016,"Revenue - Discounters",29,"Revenue"]
[null,"2016-02-01",2016,"Cogs - Discounters",16,"Cogs"]
[null,"2016-02-01",2016,"Revenue - Grocery",49,"Revenue"]
[null,"2016-02-01",2016,"Cogs - Grocery",19,"Cogs"]
[null,"2016-02-01",2016,"Revenue - Retail",57,"Revenue"]
[null,"2016-02-01",2016,"Cogs - Retail",35,"Cogs"]
[null,"2016-02-01",2016,"Operating expenses",96.86,"Operating expenses"]
[null,"2016-02-01",2016,"D&A",4,"D&A"]
[null,"2016-02-01",2016,"Interest expenses",4,"Interest"]
[null,"2016-02-01",2016,"Taxes",17.899999999999999,"Taxes"]
[null,"2016-03-01",2016,"Revenue - Supermarkets",61,"Revenue"]
[null,"2016-03-01",2016,"Cogs - Supermarkets",52,"Cogs"]
[null,"2016-03-01",2016,"Revenue - Discounters",27,"Revenue"]
[null,"2016-03-01",2016,"Cogs - Discounters",13,"Cogs"]
[null,"2016-03-01",2016,"Revenue - Grocery",38,"Revenue"]
[null,"2016-03-01",2016,"Cogs - Grocery",17,"Cogs"]
[null,"2016-03-01",2016,"Revenue - Retail",63,"Revenue"]
[null,"2016-03-01",2016,"Cogs - Retail",31,"Cogs"]
[null,"2016-03-01",2016,"Operating expenses",87.58,"Operating expenses"]
[null,"2016-03-01",{"$f":"YEAR(B325)","v":2016},"D&A",4,"D&A"]
[null,"2016-03-01",2016,"Interest expenses",4,"Interest"]
[null,"2016-03-01",2016,"Taxes",16.490000000000002,"Taxes"]
[null,"2016-04-01",2016,"Revenue - Supermarkets",62,"Revenue"]
[null,"2016-04-01",2016,"Cogs - Supermarkets",48,"Cogs"]
[null,"2016-04-01",2016,"Revenue - Discounters",25,"Revenue"]
[null,"2016-04-01",2016,"Cogs - Discounters",20,"Cogs"]
[null,"2016-04-01",2016,"Revenue - Grocery",47,"Revenue"]
[null,"2016-04-01",2016,"Cogs - Grocery",11,"Cogs"]
[null,"2016-04-01",2016,"Revenue - Retail",56,"Revenue"]
[null,"2016-04-01",2016,"Cogs - Retail",30,"Cogs"]
[null,"2016-04-01",2016,"Operating expenses",80.73,"Operating expenses"]
[null,"2016-04-01",2016,"D&A",3,"D&A"]
[null,"2016-04-01",2016,"Interest expenses",4,"Interest"]
[null,"2016-04-01",2016,"Taxes",16.54,"Taxes"]
[null,"2016-05-01",2016,"Revenue - Supermarkets",59,"Revenue"]
[null,"2016-05-01",2016,"Cogs - Supermarkets",58,"Cogs"]
[null,"2016-05-01",2016,"Revenue - Discounters",32,"Revenue"]
[null,"2016-05-01",2016,"Cogs - Discounters",13,"Cogs"]
[null,"2016-05-01",2016,"Revenue - Grocery",41,"Revenue"]
[null,"2016-05-01",2016,"Cogs - Grocery",13,"Cogs"]
[null,"2016-05-01",2016,"Revenue - Retail",54,"Revenue"]
[null,"2016-05-01",2016,"Cogs - Retail",35,"Cogs"]
[null,"2016-05-01",2016,"Operating expenses",88.449999999999989,"Operating expenses"]
[null,"2016-05-01",2016,"D&A",4,"D&A"]
[null,"2016-05-01",2016,"Interest expenses",5,"Interest"]
[null,"2016-05-01",2016,"Taxes",16.05,"Taxes"]
[null,"2016-06-01",2016,"Revenue - Supermarkets",67,"Revenue"]
[null,"2016-06-01",2016,"Cogs - Supermarkets",56,"Cogs"]
[null,"2016-06-01",2016,"Revenue - Discounters",31,"Revenue"]
[null,"2016-06-01",2016,"Cogs - Discounters",18,"Cogs"]
[null,"2016-06-01",2016,"Revenue - Grocery",47,"Revenue"]
[null,"2016-06-01",2016,"Cogs - Grocery",17,"Cogs"]
[null,"2016-06-01",2016,"Revenue - Retail",66,"Revenue"]
[null,"2016-06-01",2016,"Cogs - Retail",30,"Cogs"]
[null,"2016-06-01",2016,"Operating expenses",102.92,"Operating expenses"]
[null,"2016-06-01",2016,"D&A",3,"D&A"]
[null,"2016-06-01",2016,"Interest expenses",4,"Interest"]
[null,"2016-06-01",2016,"Taxes",18.360000000000003,"Taxes"]
[null,"2016-07-01",2016,"Revenue - Supermarkets",70,"Revenue"]
[null,"2016-07-01",2016,"Cogs - Supermarkets",52,"Cogs"]
[null,"2016-07-01",2016,"Revenue - Discounters",37,"Revenue"]
[null,"2016-07-01",2016,"Cogs - Discounters",10,"Cogs"]
[null,"2016-07-01",2016,"Revenue - Grocery",35,"Revenue"]
[null,"2016-07-01",2016,"Cogs - Grocery",18,"Cogs"]
[null,"2016-07-01",2016,"Revenue - Retail",59,"Revenue"]
[null,"2016-07-01",2016,"Cogs - Retail",35,"Cogs"]
[null,"2016-07-01",2016,"Operating expenses",104.28,"Operating expenses"]
[null,"2016-07-01",2016,"D&A",3,"D&A"]
[null,"2016-07-01",2016,"Interest expenses",5,"Interest"]
[null,"2016-07-01",2016,"Taxes",17.240000000000002,"Taxes"]
[null,"2016-08-01",2016,"Revenue - Supermarkets",75,"Revenue"]
[null,"2016-08-01",2016,"Cogs - Supermarkets",47,"Cogs"]
[null,"2016-08-01",2016,"Revenue - Discounters",27,"Revenue"]
[null,"2016-08-01",2016,"Cogs - Discounters",19,"Cogs"]
[null,"2016-08-01",2016,"Revenue - Grocery",45,"Revenue"]
[null,"2016-08-01",2016,"Cogs - Grocery",11,"Cogs"]
[null,"2016-08-01",2016,"Revenue - Retail",59,"Revenue"]
[null,"2016-08-01",2016,"Cogs - Retail",30,"Cogs"]
[null,"2016-08-01",2016,"Operating expenses",78.25,"Operating expenses"]
[null,"2016-08-01",2016,"D&A",4,"D&A"]
[null,"2016-08-01",2016,"Interest expenses",5,"Interest"]
[null,"2016-08-01",2016,"Taxes",17.840000000000003,"Taxes"]
[null,"2016-09-01",2016,"Revenue - Supermarkets",65,"Revenue"]
[null,"2016-09-01",{"$f":"YEAR(B389)","v":2016},"Cogs - Supermarkets",47,"Cogs"]
[null,"2016-09-01",2016,"Revenue - Discounters",38,"Revenue"]
[null,"2016-09-01",2016,"Cogs - Discounters",13,"Cogs"]
[null,"2016-09-01",2016,"Revenue - Grocery",39,"Revenue"]
[null,"2016-09-01",2016,"Cogs - Grocery",11,"Cogs"]
[null,"2016-09-01",2016,"Revenue - Retail",58,"Revenue"]
[null,"2016-09-01",2016,"Cogs - Retail",32,"Cogs"]
[null,"2016-09-01",2016,"Operating expenses",78.78,"Operating expenses"]
[null,"2016-09-01",2016,"D&A",3,"D&A"]
[null,"2016-09-01",2016,"Interest expenses",4,"Interest"]
[null,"2016-09-01",2016,"Taxes",17.170000000000002,"Taxes"]
[null,"2016-10-01",2016,"Revenue - Supermarkets",72,"Revenue"]
[null,"2016-10-01",2016,"Cogs - Supermarkets",51,"Cogs"]
[null,"2016-10-01",2016,"Revenue - Discounters",34,"Revenue"]
[null,"2016-10-01",2016,"Cogs - Discounters",16,"Cogs"]
[null,"2016-10-01",2016,"Revenue - Grocery",39,"Revenue"]
[null,"2016-10-01",2016,"Cogs - Grocery",10,"Cogs"]
[null,"2016-10-01",2016,"Revenue - Retail",64,"Revenue"]
[null,"2016-10-01",2016,"Cogs - Retail",35,"Cogs"]
[null,"2016-10-01",2016,"Operating expenses",83.460000000000008,"Operating expenses"]
[null,"2016-10-01",2016,"D&A",3,"D&A"]
[null,"2016-10-01",2016,"Interest expenses",5,"Interest"]
[null,"2016-10-01",2016,"Taxes",18.05,"Taxes"]
[null,"2016-11-01",2016,"Revenue - Supermarkets",64,"Revenue"]
[null,"2016-11-01",2016,"Cogs - Supermarkets",52,"Cogs"]
[null,"2016-11-01",2016,"Revenue - Discounters",37,"Revenue"]
[null,"2016-11-01",2016,"Cogs - Discounters",15,"Cogs"]
[null,"2016-11-01",2016,"Revenue - Grocery",50,"Revenue"]
[null,"2016-11-01",2016,"Cogs - Grocery",14,"Cogs"]
[null,"2016-11-01",2016,"Revenue - Retail",58,"Revenue"]
[null,"2016-11-01",2016,"Cogs - Retail",33,"Cogs"]
[null,"2016-11-01",2016,"Operating expenses",87.210000000000008,"Operating expenses"]
[null,"2016-11-01",2016,"D&A",3,"D&A"]
[null,"2016-11-01",2016,"Interest expenses",5,"Interest"]
[null,"2016-11-01",2016,"Taxes",18.010000000000002,"Taxes"]
[null,"2016-12-01",2016,"Revenue - Supermarkets",66,"Revenue"]
[null,"2016-12-01",2016,"Cogs - Supermarkets",56,"Cogs"]
[null,"2016-12-01",2016,"Revenue - Discounters",38,"Revenue"]
[null,"2016-12-01",2016,"Cogs - Discounters",13,"Cogs"]
[null,"2016-12-01",2016,"Revenue - Grocery",41,"Revenue"]
[null,"2016-12-01",2016,"Cogs - Grocery",18,"Cogs"]
[null,"2016-12-01",2016,"Revenue - Retail",65,"Revenue"]
[null,"2016-12-01",2016,"Cogs - Retail",30,"Cogs"]
[null,"2016-12-01",2016,"Operating expenses",91.56,"Operating expenses"]
[null,"2016-12-01",2016,"D&A",4,"D&A"]
[null,"2016-12-01",2016,"Interest expenses",4,"Interest"]
[null,"2016-12-01",2016,"Taxes",18.130000000000003,"Taxes"]
[null,"2014-12-01",2014,"Other revenue",524,"Revenue"]
[null,"2015-12-01",2015,"Other revenue",550,"Revenue"]
[null,"2016-12-01",2016,"Other revenue",628,"Revenue"]

{"sheet":"P&L","index":6,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"P&L"]
[]
[null,"Scenario:","Base Case"]
[null,null,null,null,null,null,null,null,null,"Forecast"]
[null,"$  in MM",2014,2015,2016,null,"Var %\n14-15","Var %\n15-16",null,{"$f":"E5+1","v":2017},{"$f":"J5+1","v":2018},{"$f":"K5+1","v":2019},2020,2021]
[null,"Revenue",{"$f":"SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!C$5,'1.1'!$F:$F,'P&L'!$B6)","v":2922},{"$f":"SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!D$5,'1.1'!$F:$F,'P&L'!$B6)","v":2984},{"$f":"SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!E$5,'1.1'!$F:$F,'P&L'!$B6)","v":3040},null,{"$f":"D6/C6-1","v":2.1218343600273748E-2},{"$f":"E6/D6-1","v":1.8766756032171594E-2},null,{"$f":"E6*(1+J20)","v":3100.8},{"$f":"J6*(1+K20)","v":3162.8160000000003},{"$f":"K6*(1+L20)","v":3226.0723200000002},3290.5937664000003,3356.4056417280003]
[null,"Cogs",{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!C$5,'1.1'!$F:$F,'P&L'!$B7)","v":-1401},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!D$5,'1.1'!$F:$F,'P&L'!$B7)","v":-1383},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!E$5,'1.1'!$F:$F,'P&L'!$B7)","v":-1367},null,{"$f":"D7/C7-1","v":-1.2847965738758016E-2},{"$f":"E7/D7-1","v":-1.156905278380338E-2},null,{"$f":"J6*J26","v":-1439.4006847195997},{"$f":"K6*K26","v":-1468.1886984139917},-1497.5524723822714,-1527.503521829917,-1558.0535922665154]
[null,"Gross Profit",{"$f":"SUM(C6:C7)","v":1521},{"$f":"SUM(D6:D7)","v":1601},1673,null,5.2596975673898649E-2,4.4971892567145622E-2,null,{"$f":"SUM(J6:J7)","v":1661.3993152804005},{"$f":"SUM(K6:K7)","v":1694.6273015860086},{"$f":"SUM(L6:L7)","v":1728.5198476177288},{"$f":"SUM(M6:M7)","v":1763.0902445700833},{"$f":"SUM(N6:N7)","v":1798.352049461485}]
[null,"Operating Expenses",{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!C$5,'1.1'!$F:$F,'P&L'!$B9)","v":-1212.1799999999998},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!D$5,'1.1'!$F:$F,'P&L'!$B9)","v":-1245.3399999999999},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!E$5,'1.1'!$F:$F,'P&L'!$B9)","v":-1068.24},null,2.7355673249847445E-2,-0.14221015947452098,null,{"$f":"J6*J32","v":-1223.3481586206517},{"$f":"K6*K32","v":-1247.8151217930647},-1272.771424228926,-1298.2268527135045,{"$f":"N6*N32","v":-1324.1913897677748}]
[null,"EBITDA",{"$f":"SUM(C8:C9)","v":308.82000000000016},{"$f":"SUM(D8:D9)","v":355.66000000000008},604.76,null,0.15167411437083045,0.70038801102176196,null,{"$f":"SUM(J8:J9)","v":438.05115665974881},{"$f":"SUM(K8:K9)","v":446.81217979294388},{"$f":"SUM(L8:L9)","v":455.74842338880285},{"$f":"SUM(M8:M9)","v":464.8633918565788},{"$f":"SUM(N8:N9)","v":474.16065969371016}]
[null,"D&A",{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!C$5,'1.1'!$F:$F,'P&L'!$B11)","v":-31},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!D$5,'1.1'!$F:$F,'P&L'!$B11)","v":-44},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!E$5,'1.1'!$F:$F,'P&L'!$B11)","v":-41},null,0.41935483870967749,-6.8181818181818232E-2,null,{"$f":"'FA Roll Forward PPE'!F6","v":-44.314229249011859},{"$f":"'FA Roll Forward PPE'!G6","v":-45.260066553140966},{"$f":"'FA Roll Forward PPE'!H6","v":-46.22609168905781},{"$f":"'FA Roll Forward PPE'!I6","v":-47.212735543290663},{"$f":"'FA Roll Forward PPE'!J6","v":-48.22043819915536}]
[null,"EBIT",{"$f":"SUM(C10:C11)","v":277.82000000000016},{"$f":"SUM(D10:D11)","v":311.66000000000008},563.76,null,0.12180548556619364,0.80889430789963379,null,{"$f":"SUM(J10:J11)","v":393.73692741073694},{"$f":"SUM(K10:K11)","v":401.55211323980291},{"$f":"SUM(L10:L11)","v":409.52233169974505},{"$f":"SUM(M10:M11)","v":417.65065631328815},{"$f":"SUM(N10:N11)","v":425.94022149455481}]
[null,"Interest",{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!C$5,'1.1'!$F:$F,'P&L'!$B13)","v":-56},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!D$5,'1.1'!$F:$F,'P&L'!$B13)","v":-65},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!E$5,'1.1'!$F:$F,'P&L'!$B13)","v":-52},null,0.16071428571428581,-0.19999999999999996,null,{"$f":"'Financial Liabilities'!C17","v":-54.449999999999996},{"$f":"'Financial Liabilities'!D17","v":-50.866096104453099},{"$f":"'Financial Liabilities'!E17","v":-46.959640858306997},{"$f":"'Financial Liabilities'!F17","v":-42.701604640007737},{"$f":"'Financial Liabilities'!G17","v":-38.060345162061552}]
[null,"EBT",{"$f":"SUM(C12:C13)","v":221.82000000000016},{"$f":"SUM(D12:D13)","v":246.66000000000008},511.76,null,0.11198268866648586,1.0747587772642495,null,{"$f":"SUM(J12:J13)","v":339.28692741073695},{"$f":"SUM(K12:K13)","v":350.6860171353498},{"$f":"SUM(L12:L13)","v":362.56269084143804},{"$f":"SUM(M12:M13)","v":374.94905167328039},{"$f":"SUM(N12:N13)","v":387.87987633249327}]
[null,"Taxes",{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!C$5,'1.1'!$F:$F,'P&L'!$B15)","v":-207.52},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!D$5,'1.1'!$F:$F,'P&L'!$B15)","v":-209.98},{"$f":"-SUMIFS('1.1'!$E:$E,'1.1'!$C:$C,'P&L'!E$5,'1.1'!$F:$F,'P&L'!$B15)","v":-208.57999999999998},null,1.1854279105628196E-2,-6.6673016477759584E-3,null,{"$f":"J14*$J37","v":-118.75042459375793},{"$f":"K14*$J37","v":-122.74010599737242},-126.89694179450331,-131.23216808564814,-135.75795671637263]
[null,"Net Income",{"$f":"SUM(C14:C15)","v":14.300000000000153},36.680000000000092,303.18,null,1.5650349650349438,7.2655398037077212,null,{"$f":"SUM(J14:J15)","v":220.53650281697901},{"$f":"SUM(K14:K15)","v":227.94591113797736},{"$f":"SUM(L14:L15)","v":235.66574904693474},{"$f":"SUM(M14:M15)","v":243.71688358763225},{"$f":"SUM(N14:N15)","v":252.12191961612064}]
[]
[null,"Scenarios:"]
[null,"Revenue % Growth"]
[null,"Selected Case",null,null,null,null,null,null,null,{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),J21,J22,J23)","v":0.02},{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),K21,K22,K23)","v":0.02},0.02,0.02,0.02]
[null,"Best Case",null,null,null,null,null,null,null,{"$f":"J22+0.01","v":0.03},{"$f":"K22+0.01","v":0.03},0.03,0.03,0.03]
[null,"Base Case",null,null,null,null,null,null,null,0.02,0.02,0.02,0.02,0.02]
[null,"Worst Case",null,null,null,null,null,null,null,{"$f":"J22-0.01","v":0.01},{"$f":"K22-0.01","v":0.01},0.01,0.01,0.01]
[]
[null,"COGS as % of Revenues"]
[null,"Selected Case",null,null,null,null,null,null,null,{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),J27,J28,J29)","v":-0.46420300719801327},{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),K27,K28,K29)","v":-0.46420300719801327},{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),L27,L28,L29)","v":-0.46420300719801327},{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),M27,M28,M29)","v":-0.46420300719801327},{"$f":"CHOOSE(MATCH($C$3,$B$21:$B$23,0),N27,N28,N29)","v":-0.46420300719801327}]
[null,"Best Case",{"$f":"C$7/C$6","v":-0.47946611909650921},{"$f":"D$7/D$6","v":-0.46347184986595175},-0.44967105263157897,null,null,null,null,{"$f":"J28+1%","v":-0.45420300719801326},{"$f":"K28+1%","v":-0.45420300719801326},{"$f":"L28+1%","v":-0.45420300719801326},-0.45420300719801326,-0.45420300719801326]
[null,"Base Case",{"$f":"C$7/C$6","v":-0.47946611909650921},-0.46347184986595175,-0.44967105263157897,null,null,null,null,{"$f":"AVERAGE($C$28:$E$28)","v":-0.46420300719801327},{"$f":"AVERAGE($C$28:$E$28)","v":-0.46420300719801327},{"$f":"AVERAGE($C$28:$E$28)","v":-0.46420300719801327},-0.46420300719801327,-0.46420300719801327]
[null,"Worst Case",-0.47946611909650921,-0.46347184986595175,-0.44967105263157897,null,null,null,null,{"$f":"J28-1%","v":-0.47420300719801328},{"$f":"K28-1%","v":-0.47420300719801328},{"$f":"L28-1%","v":-0.47420300719801328},-0.47420300719801328,-0.47420300719801328]
[]
[null,"Opex as % of Revenues"]
[null,"Selected Case",null,null,null,null,null,null,null,{"$f":"OFFSET(J32,MATCH($C$3,$B$21:$B$23,0),0)","v":-0.39452662494216062},{"$f":"OFFSET(K32,MATCH($C$3,$B$21:$B$23,0),0)","v":-0.39452662494216062},-0.39452662494216062,-0.39452662494216062,-0.39452662494216062]
[null,"Best Case",{"$f":"C$9/C$6","v":-0.41484599589322374},-0.4173391420911528,-0.35139473684210526,null,null,null,null,-0.35,-0.35,-0.35,-0.35,-0.35]
[null,"Base Case",-0.41484599589322374,-0.4173391420911528,-0.35139473684210526,null,null,null,null,{"$f":"AVERAGE($C$34:$E$34)","v":-0.39452662494216062},{"$f":"AVERAGE($C$34:$E$34)","v":-0.39452662494216062},-0.39452662494216062,-0.39452662494216062,-0.39452662494216062]
[null,"Worst Case",-0.41484599589322374,-0.4173391420911528,-0.35139473684210526,null,null,null,null,-0.41,-0.41,-0.41,-0.41,-0.41]
[]
[null,"Taxes %",null,null,null,null,null,null,null,-0.35,-0.35,-0.35,-0.35,-0.35]

{"sheet":"BS","index":7,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,5,2,9]]}
[null,"Balance Sheet"]
[]
[null,null,null,null,null,"Forecast"]
[null,"$ in MM","2014-12-31","2015-12-31","2016-12-31","2017-12-31","2018-12-31","2019-12-31","2020-12-31","2021-12-31"]
[null,"Trade Receivables",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B5,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":143.9},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B5,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":154.80000000000001},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B5,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":169.3},{"$f":"F19*'P&L'!J6/360","v":162.08352519575084},{"$f":"G19*'P&L'!K6/360","v":165.32519569966584},{"$f":"H19*'P&L'!L6/360","v":168.63169961365915},{"$f":"I19*'P&L'!M6/360","v":172.00433360593235},{"$f":"J19*'P&L'!N6/360","v":175.44442027805098}]
[null,"Inventory",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B6,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":84.999999999999986},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B6,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":92.000000000000014},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B6,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":110},{"$f":"-F21*'P&L'!J$7/360","v":99.635882194775547},{"$f":"-G21*'P&L'!K$7/360","v":101.62859983867106},{"$f":"-H21*'P&L'!L$7/360","v":103.66117183544449},{"$f":"-I21*'P&L'!M$7/360","v":105.73439527215339},{"$f":"-J21*'P&L'!N$7/360","v":107.84908317759647}]
[null,"PP&E",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B7,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":632.5},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B7,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":632.5},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B7,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":659.5},{"$f":"'FA Roll Forward PPE'!F8","v":673.57628458498027},{"$f":"'FA Roll Forward PPE'!G8","v":687.95301160774272},{"$f":"'FA Roll Forward PPE'!H8","v":702.6365936736787},{"$f":"'FA Roll Forward PPE'!I8","v":717.63358025801801},{"$f":"'FA Roll Forward PPE'!J8","v":732.95066062716148},"FA Rollforward"]
[null,"Cash",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B8,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":24.8},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B8,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":21.8},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B8,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":220},{"$f":"E8+'Cash Flow'!C19","v":337.28732014032749},{"$f":"F8+'Cash Flow'!D19","v":412.2603386584409},{"$f":"G8+'Cash Flow'!E19","v":487.57169477558114},{"$f":"H8+'Cash Flow'!F19","v":563.06043092626862},{"$f":"I8+'Cash Flow'!G19","v":638.54733827804716},"Cash Flow "]
[null,"Other assets",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B9,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":45.9},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B9,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":46.9},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B9,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":68},{"$f":"F22*'P&L'!J$6","v":55.601476457602764},{"$f":"G22*'P&L'!K$6","v":56.713505986754825},{"$f":"H22*'P&L'!L$6","v":57.847776106489917},{"$f":"I22*'P&L'!M$6","v":59.004731628619716},{"$f":"J22*'P&L'!N$6","v":60.184826261192114}]
[null,"Assets",{"$f":"SUM(C5:C9)","v":932.09999999999991},{"$f":"SUM(D5:D9)","v":947.99999999999989},1226.8,{"$f":"SUM(F5:F9)","v":1328.184488573437},{"$f":"SUM(G5:G9)","v":1423.8806517912756},{"$f":"SUM(H5:H9)","v":1520.3489360048534},{"$f":"SUM(I5:I9)","v":1617.4374716909922},{"$f":"SUM(J5:J9)","v":1714.9763286220482}]
[]
[null,"Trade Payables",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B12,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":68},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B12,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":68.900000000000006},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B12,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":68.900000000000006},{"$f":"-F20*'P&L'!J$7/360","v":71.374282557921575},{"$f":"-G20*'P&L'!K$7/360","v":72.801768209080009},{"$f":"-H20*'P&L'!L$7/360","v":74.257803573261597},{"$f":"-I20*'P&L'!M$7/360","v":75.742959644726838},{"$f":"-J20*'P&L'!N$7/360","v":77.257818837621386}]
[null,"Provisions",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B13,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":32.5},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B13,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":28.699999999999996},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B13,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":28.699999999999996},{"$f":"$E$13","v":28.699999999999996},{"$f":"$E$13","v":28.699999999999996},28.699999999999996,28.699999999999996,28.699999999999996,"flat provisions"]
[null,"Financial Liabilities",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B14,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":615.79999999999995},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B14,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":610.4},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B14,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":605},{"$f":"'Financial Liabilities'!F8","v":565.17884560503455},{"$f":"'Financial Liabilities'!G8","v":521.77378731452222},{"$f":"'Financial Liabilities'!H8","v":474.4622737778638},{"$f":"'Financial Liabilities'!I8","v":422.89272402290612},{"$f":"'Financial Liabilities'!J8","v":366.68191479000222},"Financial Liabilities"]
[null,"Other liabilities",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B15,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":48.3},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B15,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":43.3},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B15,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":38.9},{"$f":"F23*'P&L'!J$6","v":45.309458720293307},{"$f":"G23*'P&L'!K$6","v":46.215647894699174},{"$f":"H23*'P&L'!L$6","v":47.139960852593163},{"$f":"I23*'P&L'!M$6","v":48.082760069645026},{"$f":"J23*'P&L'!N$6","v":49.044415271037927}]
[null,"Equity",{"$f":"OFFSET('BS 2014'!$A$1,MATCH(BS!B16,'BS 2014'!$A:$A,0)-1,MATCH(BS!C$4,'BS 2014'!$1:$1,0)-1)","v":167.50000000000003},{"$f":"INDEX('BS 2015'!$1:$1048576,MATCH(BS!$B16,'BS 2015'!$A:$A,0),MATCH(BS!D$4,'BS 2015'!$1:$1,0))","v":196.7},{"$f":"INDEX('BS 2016'!$1:$1048576,MATCH(BS!$B16,'BS 2016'!$A:$A,0),MATCH(BS!E$4,'BS 2016'!$1:$1,0))","v":485.3},{"$f":"'Equity Schedule'!F9","v":617.62190169018731},{"$f":"'Equity Schedule'!G9","v":754.38944837297379},{"$f":"'Equity Schedule'!H9","v":895.78889780113457},{"$f":"'Equity Schedule'!I9","v":1042.0190279537139},{"$f":"'Equity Schedule'!J9","v":1193.2921797233864},"Equity Schedule"]
[null,"Liabilities and Equity",{"$f":"SUM(C12:C16)","v":932.09999999999991},{"$f":"SUM(D12:D16)","v":948},1226.8,{"$f":"SUM(F12:F16)","v":1328.1844885734367},{"$f":"SUM(G12:G16)","v":1423.8806517912751},{"$f":"SUM(H12:H16)","v":1520.3489360048532},{"$f":"SUM(I12:I16)","v":1617.437471690992},{"$f":"SUM(J12:J16)","v":1714.976328622048}]
[]
[null,"DSO",{"$f":"(C5/'P&L'!C6)*360","v":17.728952772073921},{"$f":"(D5/'P&L'!D6)*360","v":18.675603217158177},{"$f":"(E5/'P&L'!E6)*360","v":20.048684210526318},{"$f":"AVERAGE($C19:$E19)","v":18.817746733252804},{"$f":"AVERAGE($C19:$E19)","v":18.817746733252804},18.817746733252804,18.817746733252804,18.817746733252804]
[null,"DPO",{"$f":"-(C12/'P&L'!C$7)*360","v":17.473233404710921},{"$f":"-(D12/'P&L'!D$7)*360","v":17.934924078091107},{"$f":"-(E12/'P&L'!E$7)*360","v":18.144842721287493},{"$f":"AVERAGE($C20:$E20)","v":17.851000068029837},17.851000068029837,17.851000068029837,17.851000068029837,17.851000068029837]
[null,"DIO",{"$f":"-(C6/'P&L'!C$7)*360","v":21.841541755888645},{"$f":"-(D6/'P&L'!D$7)*360","v":23.94793926247289},{"$f":"-(E6/'P&L'!E$7)*360","v":28.96854425749817},24.919341758619904,24.919341758619904,24.919341758619904,24.919341758619904,24.919341758619904]
[null,"Other Assets %",{"$f":"C9/'P&L'!C$6","v":1.5708418891170431E-2},{"$f":"D9/'P&L'!D$6","v":1.5717158176943698E-2},{"$f":"E9/'P&L'!E$6","v":2.2368421052631579E-2},1.7931332706915236E-2,1.7931332706915236E-2,1.7931332706915236E-2,1.7931332706915236E-2,1.7931332706915236E-2]
[null,"Other Liabilities %",{"$f":"C15/'P&L'!C$6","v":1.6529774127310062E-2},{"$f":"D15/'P&L'!D$6","v":1.4510723860589811E-2},{"$f":"E15/'P&L'!E$6","v":1.2796052631578948E-2},1.4612183539826273E-2,1.4612183539826273E-2,1.4612183539826273E-2,1.4612183539826273E-2,1.4612183539826273E-2]
[]
[]
[]
[null,"Check",{"$f":"C10-C17","v":0},{"$f":"D10-D17","v":0},{"$f":"E10-E17","v":0},{"$f":"F10-F17","v":0},0,0,0,0]

{"sheet":"FA Roll Forward PPE","index":8,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,5,2,9]]}
[null,"Fixed Asset Roll Forward"]
[]
[null,null,null,null,null,"Forecast"]
[null,"$ in MM","2014-12-31","2015-12-31","2016-12-31","2017-12-31","2018-12-31","2019-12-31","2020-12-31","2021-12-31"]
[null,"Beginning PP&E",null,{"$f":"BS!C7","v":632.5},{"$f":"BS!D7","v":632.5},{"$f":"E8","v":659.5},{"$f":"F8","v":673.57628458498027},687.95301160774272,702.6365936736787,717.63358025801801]
[null,"D&A",null,{"$f":"'P&L'!D11","v":-44},{"$f":"'P&L'!E11","v":-41},{"$f":"F$5*F10","v":-44.314229249011859},{"$f":"G$5*G10","v":-45.260066553140966},-46.22609168905781,-47.212735543290663,-48.22043819915536]
[null,"Capex",null,{"$f":"D8-D6-D5","v":44},{"$f":"E8-E6-E5","v":68},{"$f":"F$5*F11","v":58.390513833992095},59.63679357590339,60.909673754993825,62.209722127630052,63.537518568298829]
[null,"Ending PP&E",{"$f":"SUM(C5:C7)","v":0},{"$f":"BS!D7","v":632.5},{"$f":"BS!E7","v":659.5},{"$f":"SUM(F5:F7)","v":673.57628458498027},687.95301160774272,702.6365936736787,717.63358025801801,732.95066062716148]
[]
[null,"D&A as % of Beg PP&E",null,{"$f":"D6/D$5","v":-6.9565217391304349E-2},{"$f":"E6/E$5","v":-6.4822134387351779E-2},{"$f":"AVERAGE($D10:$E10)","v":-6.7193675889328064E-2},{"$f":"AVERAGE($D10:$E10)","v":-6.7193675889328064E-2},-6.7193675889328064E-2,-6.7193675889328064E-2,-6.7193675889328064E-2]
[null,"Capex as % of Beg PP&E",null,{"$f":"D7/D$5","v":6.9565217391304349E-2},{"$f":"E7/E$5","v":0.10750988142292491},{"$f":"AVERAGE($D11:$E11)","v":8.8537549407114627E-2},8.8537549407114627E-2,8.8537549407114627E-2,8.8537549407114627E-2,8.8537549407114627E-2]

{"sheet":"Financial Liabilities","index":9,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,5,2,9]]}
[null,"Financial Liabilities"]
[]
[null,null,null,null,null,"Forecast"]
[null,"$ in MM","2014-12-31","2015-12-31","2016-12-31","2017-12-31","2018-12-31","2019-12-31","2020-12-31","2021-12-31"]
[null,"Beginning Debt",null,{"$f":"C8","v":615.79999999999995},{"$f":"D8","v":610.4},{"$f":"E8","v":605},565.17884560503455,521.77378731452222,474.4622737778638,422.89272402290612]
[null,"New Debt",null,0,0,0,0,0,0,0]
[null,"Principal Repayments",null,{"$f":"D8-D5","v":-5.3999999999999773},{"$f":"E8-E5","v":-5.3999999999999773},{"$f":"C18","v":-39.82115439496544},{"$f":"D18","v":-43.405058290512336},-47.311513536658445,-51.569549754957698,-56.210809232903898]
[null,"Ending Debt",{"$f":"BS!C14","v":615.79999999999995},{"$f":"BS!D14","v":610.4},{"$f":"BS!E14","v":605},{"$f":"F5+F7","v":565.17884560503455},{"$f":"G5+G7","v":521.77378731452222},474.4622737778638,422.89272402290612,366.68191479000222]
[]
[null,"Debt to be repaid (in years)",10]
[null,"I/R",0.09]
[null,"Annual Payment",{"$f":"PMT(C11,C10,E8)","v":-94.271154394965436}]
[]
[]
["Period",null,1,2,3,4,5,6,7,8,9,10]
[null,"Payment",{"$f":"$C$12","v":-94.271154394965436},{"$f":"$C$12","v":-94.271154394965436},-94.271154394965436,-94.271154394965436,-94.271154394965436,-94.271154394965436,-94.271154394965436,-94.271154394965436,-94.271154394965436,-94.271154394965436]
[null,"Interest Expense",{"$f":"IPMT($C$11,C$15,$C$10,$E$8,0)","v":-54.449999999999996},{"$f":"IPMT($C$11,D$15,$C$10,$E$8,0)","v":-50.866096104453099},-46.959640858306997,-42.701604640007737,-38.060345162061552,-33.001372331100185,-27.487091945352311,-21.476526324887132,-14.925009798580085,-7.783856784905403]
[null,"Debt Repayment",{"$f":"PPMT($C$11,C$15,$C$10,$E$8,0)","v":-39.82115439496544},{"$f":"PPMT($C$11,D$15,$C$10,$E$8,0)","v":-43.405058290512336},-47.311513536658445,-51.569549754957698,-56.210809232903898,-61.269782063865243,-66.784062449613117,-72.794628070078289,-79.346144596385344,-86.487297610060025]
[null,"Residual Debt",{"$f":"E8+C18","v":565.17884560503455},{"$f":"C19+D18","v":521.77378731452222},{"$f":"D19+E18","v":474.4622737778638},422.89272402290612,366.68191479000222,305.41213272613697,238.62807027652386,165.83344220644557,86.487297610060224,1.9895196601282805E-13]

{"sheet":"Equity Schedule","index":10,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,5,2,9]]}
[null,"Equity Schedule"]
[]
[null,null,null,null,null,"Forecast"]
[null,"$ in MM","2014-12-31","2015-12-31","2016-12-31","2017-12-31","2018-12-31","2019-12-31","2020-12-31","2021-12-31"]
[null,"Beginning Equity",null,null,null,{"$f":"E9","v":485.3},{"$f":"F9","v":617.62190169018731},754.38944837297379,895.78889780113457,1042.0190279537139]
[null,"Increase of Capital",null,null,null,0,0,0,0,0]
[null,"Net Income (Loss)",null,null,null,{"$f":"'P&L'!J16","v":220.53650281697901},{"$f":"'P&L'!K16","v":227.94591113797736},{"$f":"'P&L'!L16","v":235.66574904693474},{"$f":"'P&L'!M16","v":243.71688358763225},{"$f":"'P&L'!N16","v":252.12191961612064}]
[null,"Dividends",null,null,null,{"$f":"IF(F7>0,-F7*F11,\"0\")","v":-88.214601126791607},{"$f":"IF(G7>0,-G7*G11,\"0\")","v":-91.178364455190945},-94.2662996187739,-97.486753435052904,-100.84876784644825]
[null,"Ending Equity",{"$f":"SUM(C5:C8)","v":0},null,{"$f":"BS!E16","v":485.3},{"$f":"SUM(F5:F8)","v":617.62190169018731},{"$f":"SUM(G5:G8)","v":754.38944837297379},895.78889780113457,1042.0190279537139,1193.2921797233864]
[]
[null,"Dividends as % of NI",null,null,null,0.4,0.4,0.4,0.4,0.4]

{"sheet":"Cash Flow","index":11,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Cash Flow"]
[]
[null,null,null,null,"Forecast"]
[null,"$ in MM",2017,2018,2019,2020,2021]
[null,"EBITDA",{"$f":"'P&L'!J10","v":438.05115665974881},{"$f":"'P&L'!K10","v":446.81217979294388},{"$f":"'P&L'!L10","v":455.74842338880285},{"$f":"'P&L'!M10","v":464.8633918565788},{"$f":"'P&L'!N10","v":474.16065969371016}]
[null,"Interest Expenses",{"$f":"'P&L'!J13","v":-54.449999999999996},{"$f":"'P&L'!K13","v":-50.866096104453099},{"$f":"'P&L'!L13","v":-46.959640858306997},{"$f":"'P&L'!M13","v":-42.701604640007737},{"$f":"'P&L'!N13","v":-38.060345162061552}]
[null,"Taxes",{"$f":"'P&L'!J15","v":-118.75042459375793},{"$f":"'P&L'!K15","v":-122.74010599737242},{"$f":"'P&L'!L15","v":-126.89694179450331},{"$f":"'P&L'!M15","v":-131.23216808564814},{"$f":"'P&L'!N15","v":-135.75795671637263}]
[null,"Change in Trade Receivables",{"$f":"-(BS!F5-BS!E5)","v":7.2164748042491738},{"$f":"-(BS!G5-BS!F5)","v":-3.2416705039150031},{"$f":"-(BS!H5-BS!G5)","v":-3.3065039139933106},{"$f":"-(BS!I5-BS!H5)","v":-3.3726339922731938},{"$f":"-(BS!J5-BS!I5)","v":-3.4400866721186389}]
[null,"Change in Inventory",{"$f":"-(BS!F6-BS!E6)","v":10.364117805224453},{"$f":"-(BS!G6-BS!F6)","v":-1.9927176438955172},{"$f":"-(BS!H6-BS!G6)","v":-2.0325719967734273},{"$f":"-(BS!I6-BS!H6)","v":-2.0732234367089006},{"$f":"-(BS!J6-BS!I6)","v":-2.1146879054430769}]
[null,"Change in Trade Payables",{"$f":"BS!F12-BS!E12","v":2.474282557921569},{"$f":"BS!G12-BS!F12","v":1.4274856511584346},{"$f":"BS!H12-BS!G12","v":1.456035364181588},{"$f":"BS!I12-BS!H12","v":1.4851560714652408},{"$f":"BS!J12-BS!I12","v":1.5148591928945478}]
[null,"Change in Other Assets",{"$f":"-(BS!F9-BS!E9)","v":12.398523542397236},{"$f":"-(BS!G9-BS!F9)","v":-1.1120295291520605},{"$f":"-(BS!H9-BS!G9)","v":-1.134270119735092},{"$f":"-(BS!I9-BS!H9)","v":-1.1569555221297989},{"$f":"-(BS!J9-BS!I9)","v":-1.1800946325723984}]
[null,"Change in Other Liabilities",{"$f":"BS!F15-BS!E15","v":6.4094587202933084},{"$f":"BS!G15-BS!F15","v":0.90618917440586699},{"$f":"BS!H15-BS!G15","v":0.9243129578939886},{"$f":"BS!I15-BS!H15","v":0.94279921705186354},{"$f":"BS!J15-BS!I15","v":0.96165520139290095}]
[null,"Capex",{"$f":"-'FA Roll Forward PPE'!F7","v":-58.390513833992095},{"$f":"-'FA Roll Forward PPE'!G7","v":-59.63679357590339},{"$f":"-'FA Roll Forward PPE'!H7","v":-60.909673754993825},{"$f":"-'FA Roll Forward PPE'!I7","v":-62.209722127630052},{"$f":"-'FA Roll Forward PPE'!J7","v":-63.537518568298829}]
[null,"Operation Cash Flow",{"$f":"SUM(C5:C13)","v":245.32307566208453},{"$f":"SUM(D5:D13)","v":209.55644126381671},216.88916927257253,224.54503934069803,232.54648443113052]
[null,"Dividends",{"$f":"'Equity Schedule'!F8","v":-88.214601126791607},{"$f":"'Equity Schedule'!G8","v":-91.178364455190945},{"$f":"'Equity Schedule'!H8","v":-94.2662996187739},{"$f":"'Equity Schedule'!I8","v":-97.486753435052904},{"$f":"'Equity Schedule'!J8","v":-100.84876784644825}]
[null,"Change in Financial Liabilities",{"$f":"'Financial Liabilities'!F8-'Financial Liabilities'!E8","v":-39.821154394965447},{"$f":"'Financial Liabilities'!G8-'Financial Liabilities'!F8","v":-43.405058290512329},{"$f":"'Financial Liabilities'!H8-'Financial Liabilities'!G8","v":-47.311513536658424},{"$f":"'Financial Liabilities'!I8-'Financial Liabilities'!H8","v":-51.569549754957677},{"$f":"'Financial Liabilities'!J8-'Financial Liabilities'!I8","v":-56.210809232903898}]
[null,"Change in Provisions",{"$f":"BS!F13-BS!E13","v":0},{"$f":"BS!G13-BS!F13","v":0},{"$f":"BS!H13-BS!G13","v":0},{"$f":"BS!I13-BS!H13","v":0},{"$f":"BS!J13-BS!I13","v":0}]
[null,"Change in Equity",{"$f":"'Equity Schedule'!F9-'Equity Schedule'!E9-'Equity Schedule'!F7-'Equity Schedule'!F8","v":0},{"$f":"'Equity Schedule'!G9-'Equity Schedule'!F9-'Equity Schedule'!G7-'Equity Schedule'!G8","v":0},{"$f":"'Equity Schedule'!H9-'Equity Schedule'!G9-'Equity Schedule'!H7-'Equity Schedule'!H8","v":0},{"$f":"'Equity Schedule'!I9-'Equity Schedule'!H9-'Equity Schedule'!I7-'Equity Schedule'!I8","v":0},{"$f":"'Equity Schedule'!J9-'Equity Schedule'!I9-'Equity Schedule'!J7-'Equity Schedule'!J8","v":1.1368683772161603E-13}]
[null,"Net Cash Flow",{"$f":"SUM(C14:C18)","v":117.28732014032749},{"$f":"SUM(D14:D18)","v":74.973018518113435},75.311356117140207,75.488736150687444,75.486907351778484]