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

{"sheet":"Disclaimer","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Short / Leveraged ETP/ETF Simulator"]

{"sheet":"Compounding Simulator","index":1,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,0,6,13],[11,0,11,13],[0,0,0,15],[37,2,37,13]]}
["Short / Leveraged ETP Simulator"]
[]
[null,null,null,null,null,null,null,"Leverage Factor ",3]
[]
[]
[null,null,"Start","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8","Day 9","Day 10","Day 11"]
["            Index"]
["Value at start of day",null,null,{"$f":"C10","v":100},{"$f":"D10","v":102},{"$f":"E10","v":104.04},{"$f":"F10","v":106.1208},{"$f":"G10","v":108.243216},{"$f":"H10","v":110.40808032000001},112.61624192640001,114.868566764928,117.16593810022657,119.5092568622311,121.89944199947573]
["Daily return",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
["Value at end of day",null,100,{"$f":"D8*(1+D9)","v":102},{"$f":"E8*(1+E9)","v":104.04},{"$f":"F8*(1+F9)","v":106.1208},{"$f":"G8*(1+G9)","v":108.243216},{"$f":"H8*(1+H9)","v":110.40808032000001},{"$f":"I8*(1+I9)","v":112.61624192640001},114.868566764928,117.16593810022657,119.5092568622311,{"$f":"M8*(1+M9)","v":121.89944199947573},{"$f":"N8*(1+N9)","v":124.33743083946524}]
["Cumulative return","Index",0,{"$f":"(D10/$D$8)-1","v":2.0000000000000018E-2},{"$f":"(E10/$D$8)-1","v":4.0399999999999991E-2},6.1207999999999929E-2,8.2432159999999977E-2,0.10408080320000002,0.12616241926400007,0.14868566764928004,0.17165938100226574,0.19509256862231106,0.21899441999475733,0.24337430839465246]
[{"$f":"\"        \"&IF(($I$3>1),\"Leveraged ETP\",IF(($I$3<0),\"Short ETP\"))","v":"        Leveraged ETP"}]
["Price at start of day",null,null,{"$f":"C15","v":100},{"$f":"D15","v":106},{"$f":"E15","v":112.36},{"$f":"F15","v":119.1016},{"$f":"G15","v":126.247696},{"$f":"H15","v":133.82255776000002},141.85191122560002,150.36302589913603,159.38480745308419,168.94789590026926,179.08476965428542]
["Daily return",null,null,{"$f":"MAX(-1,D9*$I$3)","v":0.06},{"$f":"MAX(-1,E9*$I$3)","v":0.06},0.06,0.06,0.06,0.06,0.06,0.06,0.06,{"$f":"MAX(-1,M9*$I$3)","v":0.06},{"$f":"MAX(-1,N9*$I$3)","v":0.06}]
["Price at end of day",null,100,{"$f":"D13*(1+D14)","v":106},{"$f":"E13*(1+E14)","v":112.36},{"$f":"F13*(1+F14)","v":119.1016},{"$f":"G13*(1+G14)","v":126.247696},{"$f":"H13*(1+H14)","v":133.82255776000002},{"$f":"I13*(1+I14)","v":141.85191122560002},150.36302589913603,159.38480745308419,168.94789590026926,179.08476965428542,189.82985583354255]
["Cumulative return",{"$f":"IF(($I$3>1),\"Leveraged ETP\",IF(($I$3<0),\"Short ETP\"))","v":"Leveraged ETP"},0,{"$f":"(D15/$D$13)-1","v":6.0000000000000053E-2},{"$f":"(E15/$D$13)-1","v":0.12359999999999993},{"$f":"(F15/$D$13)-1","v":0.19101600000000007},{"$f":"(G15/$D$13)-1","v":0.26247696000000009},{"$f":"(H15/$D$13)-1","v":0.33822557760000027},{"$f":"(I15/$D$13)-1","v":0.41851911225600014},0.50363025899136038,0.59384807453084187,0.68947895900269263,0.79084769654285414,0.89829855833542549]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please contact Boost ETP LLP at +44 20 3515 0050 if you have any questions"]

{"sheet":"Background Data","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["ETP returns","ETP Leverage factors"]
[0.1,5,null,null,"Return to capital loss",null,{"$f":"-100%/'Compounding Simulator'!$I$3","v":-0.33333333333333331}]
[0.05,4,null,null,"Return before restrike threshold",null,0.1666]
[0.03,3,null,null,"Therefore, ETP return must be between",null,{"$f":"IF('Compounding Simulator'!$I$3>0,MAX(G2:G3),MIN(G2:G3))","v":0.1666},"and",{"$f":"-G4","v":-0.1666}]
[0.02,2,null,null,"Or, in order:",null,{"$f":"MIN(G4,I4)","v":-0.1666},"and ",{"$f":"MAX(G4,I4)","v":0.1666}]
[0.01,-1]
[0,-2]
[-0.01,-3]
[-0.02,-4]
[-0.03,-5]
[-0.05]
[-0.1]