{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["sensitivity_analysis","How to use this Calculator","Calculator"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":3,"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":"sensitivity_analysis","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[18,0,18,1],[0,0,0,7],[3,0,3,7],[2,0,2,7],[1,0,1,7],[17,0,17,7]]}
[]
["Use this template to show the impact of particular changes on your business plan. Sample figures are included in the version displayed below. \n"]
["Sensitivity analysis template"]
["Your business name goes here…"]
[null,null,null,1,1.1000000000000001,1.1000000000000001,0.95,0.9]
["Sales",120000,null,{"$f":"B6*D5","v":120000},{"$f":"D6*E5","v":132000},{"$f":"D6*F5","v":132000},{"$f":"+D6*G5","v":114000},{"$f":"D6*H5","v":108000}]
["Cost of sales",null,null,{"$f":"D6-D8","v":54000},{"$f":"E6-E8","v":59400},{"$f":"F6-F8","v":59400},{"$f":"G6-G8","v":51299.999999999993},{"$f":"H6-H8","v":48599.999999999993}]
["Gross margin (profit)",0.55000000000000004,null,{"$f":"D6*B8","v":66000},{"$f":"E6*B8","v":72600},{"$f":"F6*B8","v":72600},{"$f":"G6*B8","v":62700.000000000007},{"$f":"H6*B8","v":59400.000000000007}]
["Wages & Salaries",null,null,5000,6000,8000,8000,7000]
["Sales and marketing",null,null,6000,7000,8000,9000,10000]
["Administration expenses",null,null,6000,7000,9000,8000,7555]
["Operating expenses",null,null,{"$f":"SUM(D9:D11)","v":17000},{"$f":"SUM(E9:E11)","v":20000},{"$f":"SUM(F9:F11)","v":25000},{"$f":"SUM(G9:G11)","v":25000},{"$f":"SUM(H9:H11)","v":24555}]
["Depreciation",null,null,5000,6000,7000,5000,4000]
["Operating income",null,null,{"$f":"D8-D12-D13","v":44000},{"$f":"E8-E12-E13","v":46600},{"$f":"F8-F12-F13","v":40600},{"$f":"G8-G12-G13","v":32700.000000000007},{"$f":"H8-H12-H13","v":30845.000000000007}]
["Interest on loans",null,null,1000,995,855,1100,1500]
["Net Profit before tax",null,null,{"$f":"D14-D15","v":43000},{"$f":"E14-E15","v":45605},{"$f":"F14-F15","v":39745},{"$f":"G14-G15","v":31600.000000000007},{"$f":"H14-H15","v":29345.000000000007}]

{"sheet":"How to use this Calculator","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"The Currency Sensitivity Calculator is designed to show you how a very small change in Currency Exchange Rates can have an exponential \neffect on your bottom line. Follow the notes below to set up the calculator and use the slider bars to see the effect on your profit/loss. \nIf you would like further assistance on how to use the tool and what to do as a result, call our Dealing Team on 01 6094300. "]
[]
[null,"Setting up the calculator"]
[null,"1. Insert your business' relevant payables/receivables in the blue cells (B5,6,7 & C5,6,7)"]
[null,"2. For GBP and USD please use the actual currency amount rather than the Euro equivalent"]
[null,"3. If you do not have a payable or a receivable in a particular currency please put in a zero"]
[null,"4. Input the currency rates* you want to use in the blue cells (B10 & B11)"]
[null,"5. Once cells are populated, your EUR profit and margin for the relevant trading period are shown in cells in D9 & D11 respectively"]
[null,"*Rates can be the average rates dealt by the company in 2016, rates as of beginning of this year or the current market rate."]
[]
[null,"What is the Scenario Analysis telling me?"]
[null,"1. Input current EUR/GBP & EUR/USD exchange rates in cells H6 & H7"]
[null,"2. Use the \"slider bars\" to move the exchange rates up or down"]
[null,"3. Moving the arrow to the right the rate goes up = GBP or USD weaken versus EUR"]
[null,"4. Moving the arrow to the left the rate goes down = GBP or USD strengthen versus EUR"]
[null,"5. The impact of the exchange rate moves on both your business margin and profitability year on year are displayed in cells G9 & G11"]
[]
[null,"Bank of Ireland is regulated by the Central Bank of Ireland. This document is provided for information purposes only and Bank of Ireland is not soliciting any action based upon it. Bank of Ireland believes the information contained herein to be accurate but does not warrant its accuracy nor accepts or assumes any responsibility or liability for such information other than any responsibility it may owe to any party under the European Communities (Markets in Financial Instruments) Regulations 2007 as may be amended from time to time, and under the Financial Conduct Authority rules (as applicable), for any loss or damage caused by any act or omission taken as a result of the information contained in this document. Any investment decision made by a party shall be on the basis of its own research and judgment and not be influenced or based on any view or opinion expressed by Bank of Ireland either in this document or otherwise. This document does not address all risks and cannot be relied on for any investment contract or decision. A party should obtain independent professional advice before making any investment decision. This document reflects current opinion as at November 2017 and is based on information available to Bank of Ireland before that date."]

{"sheet":"Calculator","index":2,"n_rows":113,"n_cols":23,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,5,2,7],[1,0,2,4],[25,0,45,0],[23,1,23,22],[66,0,86,0],[64,1,64,22],[3,5,3,7]]}
[]
["Your business today",null,null,null,null,"Scenario Analysis"]
[]
[null,"Payables","Receivables","Net"]
["Euro",5000000,500000,{"$f":"C5-B5","v":-4500000},null,"Currency","Select Movement","Rate v EUR"]
["Sterling",500000,5000000,{"$f":"C6-B6","v":4500000},null,"GBP",8790,0.87]
["US Dollars",0,0,{"$f":"C7-B7","v":0},null,"USD",13020,1.3]
[null,null,null,"EUR Profit",null,"EUR Profit",null,"EUR Profit Change"]
["Euro","Exchange Rate",null,{"$f":"IFERROR(D5+D6/B10+D7/B11,\"\")","v":672413.79310344812},null,{"$f":"IFERROR(D5+D6/H6+D7/H7,\"\")","v":672413.79310344812},null,{"$f":"IFERROR(F9-D9,\"\")","v":0}]
["Sterling",0.87,null,"EUR % Profit",null,"% Profit",null,"% Profit Change"]
["US Dollars",1.3,null,{"$f":"IFERROR(D9/($C$5+$C$6/B10+$C$7/B11),\"\")","v":0.10763569457221708},null,{"$f":"IFERROR(F9/($C$5+$C$6/H6+$C$7/H7),\"\")","v":0.10763569457221708},null,{"$f":"IFERROR(F11-D11,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Currency Matrix",-0.1,-0.09,-0.08,-7.0000000000000007E-2,-0.06,-0.05,-0.04,-0.03,-0.02,-0.01,0,0.01,0.02,0.03,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1]
[null,"10% Weaker","9% Weaker","8% Weaker","7% Weaker","6% Weaker","5% Weaker","4% Weaker","3% Weaker","2% Weaker","1% Weaker","0% Stronger","1% Stronger","2% Stronger","3% Stronger","4% Stronger","5% Stronger","6% Stronger","7% Stronger","8% Stronger","9% Stronger","10% Stronger"]
["EURGBP",1.1000000000000001,1.0900000000000001,1.08,1.07,1.06,1.05,1.04,1.03,1.02,1.01,1,0.99,0.98,0.97,0.96,0.95,0.94,0.92999999999999994,0.92,0.91,0.9]
["EURUSD",1.2100000000000002,1.1990000000000003,1.1880000000000002,1.1770000000000003,1.1660000000000001,1.1550000000000002,1.1440000000000001,1.1330000000000002,1.1220000000000001,1.1110000000000002,1.1000000000000001,1.089,1.0780000000000001,1.0669999999999999,1.056,1.0449999999999999,1.034,1.0229999999999999,1.0120000000000002,1.0010000000000001,0.9900000000000001]
["Net Profit"]
[null,"EURGBP"]
[null,null,"EURUSD 10% Weaker","EURUSD 9% Weaker","EURUSD 8% Weaker","EURUSD 7% Weaker","EURUSD 6% Weaker","EURUSD 5% Weaker","EURUSD 4% Weaker","EURUSD 3% Weaker","EURUSD 2% Weaker","EURUSD 1% Weaker","EURUSD 0% Stronger","EURUSD 1% Stronger","EURUSD 2% Stronger","EURUSD 3% Stronger","EURUSD 4% Stronger","EURUSD 5% Stronger","EURUSD 6% Stronger","EURUSD 7% Stronger","EURUSD 8% Stronger","EURUSD 9% Stronger","EURUSD 10% Stronger"]
["EURUSD","EURGBP 10% Weaker",-0.27189999999999998,-0.2676,-0.26329999999999998,-0.2591,-0.25480000000000003,-0.2505,-0.24610000000000001,-0.24179999999999999,-0.2374,-0.2331,-0.22869999999999999,-0.2243,-0.21990000000000001,-0.2155,-0.21110000000000001,-0.20660000000000001,-0.20219999999999999,-0.19769999999999999,-0.19320000000000001,-0.18870000000000001,-0.1842]
[null,"EURGBP 9% Weaker",-0.2752,-0.27089999999999997,-0.2666,-0.26229999999999998,-0.25800000000000001,-0.25359999999999999,-0.24929999999999999,-0.24490000000000001,-0.24060000000000001,-0.23619999999999999,-0.23180000000000001,-0.22739999999999999,-0.223,-0.2185,-0.21410000000000001,-0.20960000000000001,-0.2051,-0.20069999999999999,-0.19620000000000001,-0.19159999999999999,-0.18709999999999999]
[null,"EURGBP 8% Weaker",-0.27850000000000003,-0.2742,-0.26989999999999997,-0.2656,-0.26119999999999999,-0.25690000000000002,-0.2525,-0.2482,-0.24379999999999999,-0.2394,-0.2349,-0.23050000000000001,-0.2261,-0.22159999999999999,-0.21709999999999999,-0.2127,-0.2082,-0.2036,-0.1991,-0.1946,-0.19]
[null,"EURGBP 7% Weaker",-0.28189999999999998,-0.27760000000000001,-0.27329999999999999,-0.26889999999999997,-0.2646,-0.26019999999999999,-0.25580000000000003,-0.25140000000000001,-0.247,-0.24260000000000001,-0.23810000000000001,-0.23369999999999999,-0.22919999999999999,-0.22470000000000001,-0.22020000000000001,-0.2157,-0.2112,-0.20669999999999999,-0.2021,-0.1976,-0.193]
[null,"EURGBP 6% Weaker",-0.28539999999999999,-0.28100000000000003,-0.2767,-0.27229999999999999,-0.26790000000000003,-0.26350000000000001,-0.2591,-0.25469999999999998,-0.25030000000000002,-0.24579999999999999,-0.2414,-0.2369,-0.2324,-0.22789999999999999,-0.22339999999999999,-0.21890000000000001,-0.21429999999999999,-0.20979999999999999,-0.20519999999999999,-0.2006,-0.19600000000000001]
[null,"EURGBP 5% Weaker",-0.28889999999999999,-0.28449999999999998,-0.2802,-0.27579999999999999,-0.27139999999999997,-0.26700000000000002,-0.26250000000000001,-0.2581,-0.25359999999999999,-0.2492,-0.2447,-0.2402,-0.23569999999999999,-0.2311,-0.2266,-0.222,-0.2175,-0.21290000000000001,-0.20830000000000001,-0.20369999999999999,-0.1991]
[null,"EURGBP 4% Weaker",-0.29249999999999998,-0.28810000000000002,-0.28370000000000001,-0.27929999999999999,-0.27489999999999998,-0.27039999999999997,-0.26600000000000001,-0.26150000000000001,-0.25700000000000001,-0.2525,-0.248,-0.24349999999999999,-0.23899999999999999,-0.2344,-0.22989999999999999,-0.2253,-0.22070000000000001,-0.21609999999999999,-0.21149999999999999,-0.20680000000000001,-0.20219999999999999]
[null,"EURGBP 3% Weaker",-0.29609999999999997,-0.29170000000000001,-0.2873,-0.28289999999999998,-0.27839999999999998,-0.27389999999999998,-0.26950000000000002,-0.26500000000000001,-0.26050000000000001,-0.25600000000000001,-0.25140000000000001,-0.24690000000000001,-0.24229999999999999,-0.23780000000000001,-0.23319999999999999,-0.2286,-0.224,-0.21929999999999999,-0.2147,-0.21,-0.2054]
[null,"EURGBP 2% Weaker",-0.29980000000000001,-0.2954,-0.29089999999999999,-0.28649999999999998,-0.28199999999999997,-0.27750000000000002,-0.27300000000000002,-0.26850000000000002,-0.26400000000000001,-0.25950000000000001,-0.25490000000000002,-0.25030000000000002,-0.24579999999999999,-0.2412,-0.23649999999999999,-0.2319,-0.2273,-0.22259999999999999,-0.218,-0.21329999999999999,-0.20860000000000001]
[null,"EURGBP 1% Weaker",-0.30359999999999998,-0.29909999999999998,-0.29459999999999997,-0.29020000000000001,-0.28570000000000001,-0.28120000000000001,-0.2767,-0.27210000000000001,-0.2676,-0.26300000000000001,-0.25840000000000002,-0.25380000000000003,-0.2492,-0.24460000000000001,-0.24,-0.23530000000000001,-0.23069999999999999,-0.22600000000000001,-0.2213,-0.21659999999999999,-0.21190000000000001]
[null,"EURGBP 0% Stronger",-0.30740000000000001,-0.3029,-0.2984,-0.29389999999999999,-0.28939999999999999,-0.28489999999999999,-0.28029999999999999,-0.27579999999999999,-0.2712,-0.2666,-0.26200000000000001,-0.25740000000000002,-0.25280000000000002,-0.24809999999999999,-0.24349999999999999,-0.23880000000000001,-0.2341,-0.22939999999999999,-0.22470000000000001,-0.21990000000000001,-0.2152]
[null,"EURGBP 1% Stronger",-0.31130000000000002,-0.30680000000000002,-0.30230000000000001,-0.29770000000000002,-0.29320000000000002,-0.28870000000000001,-0.28410000000000002,-0.27950000000000003,-0.27489999999999998,-0.27029999999999998,-0.26569999999999999,-0.26100000000000001,-0.25640000000000002,-0.25169999999999998,-0.247,-0.24229999999999999,-0.23760000000000001,-0.2329,-0.2281,-0.22339999999999999,-0.21859999999999999]
[null,"EURGBP 2% Stronger",-0.31519999999999998,-0.31069999999999998,-0.30620000000000003,-0.30159999999999998,-0.29709999999999998,-0.29249999999999998,-0.28789999999999999,-0.2833,-0.2787,-0.27400000000000002,-0.26939999999999997,-0.26469999999999999,-0.26,-0.25530000000000003,-0.25059999999999999,-0.24590000000000001,-0.2412,-0.2364,-0.2316,-0.22689999999999999,-0.222]
[null,"EURGBP 3% Stronger",-0.31929999999999997,-0.31469999999999998,-0.31019999999999998,-0.30559999999999998,-0.30099999999999999,-0.2964,-0.2918,-0.28720000000000001,-0.28249999999999997,-0.27779999999999999,-0.2732,-0.26850000000000002,-0.26379999999999998,-0.2591,-0.25430000000000003,-0.24959999999999999,-0.24479999999999999,-0.24,-0.23519999999999999,-0.23039999999999999,-0.22559999999999999]
[null,"EURGBP 4% Stronger",-0.32329999999999998,-0.31879999999999997,-0.31419999999999998,-0.30959999999999999,-0.30499999999999999,-0.3004,-0.29570000000000002,-0.29110000000000003,-0.28639999999999999,-0.28170000000000001,-0.27700000000000002,-0.27229999999999999,-0.2676,-0.26279999999999998,-0.2581,-0.25330000000000003,-0.2485,-0.2437,-0.2389,-0.23400000000000001,-0.22919999999999999]
[null,"EURGBP 5% Stronger",-0.32750000000000001,-0.32290000000000002,-0.31830000000000003,-0.31369999999999998,-0.30909999999999999,-0.3044,-0.29980000000000001,-0.29509999999999997,-0.29039999999999999,-0.28570000000000001,-0.28089999999999998,-0.2762,-0.27139999999999997,-0.26669999999999999,-0.26190000000000002,-0.2571,-0.25219999999999998,-0.24740000000000001,-0.24260000000000001,-0.23769999999999999,-0.23280000000000001]
[null,"EURGBP 6% Stronger",-0.33179999999999998,-0.32719999999999999,-0.32250000000000001,-0.31790000000000002,-0.31319999999999998,-0.3085,-0.3039,-0.29909999999999998,-0.2944,-0.28970000000000001,-0.28489999999999999,-0.2802,-0.27539999999999998,-0.27060000000000001,-0.26579999999999998,-0.26090000000000002,-0.25609999999999999,-0.25119999999999998,-0.24629999999999999,-0.2414,-0.23649999999999999]
[null,"EURGBP 7% Stronger",-0.33610000000000001,-0.33139999999999997,-0.32679999999999998,-0.3221,-0.31740000000000002,-0.31269999999999998,-0.308,-0.30330000000000001,-0.29849999999999999,-0.29380000000000001,-0.28899999999999998,-0.28420000000000001,-0.27939999999999998,-0.27460000000000001,-0.2697,-0.26490000000000002,-0.26,-0.25509999999999999,-0.25019999999999998,-0.24529999999999999,-0.24030000000000001]
[null,"EURGBP 8% Stronger",-0.34050000000000002,-0.33579999999999999,-0.33110000000000001,-0.32650000000000001,-0.32169999999999999,-0.317,-0.31230000000000002,-0.3075,-0.30270000000000002,-0.2979,-0.29310000000000003,-0.2883,-0.28349999999999997,-0.27860000000000001,-0.2737,-0.26889999999999997,-0.26400000000000001,-0.25900000000000001,-0.25409999999999999,-0.24909999999999999,-0.2442]
[null,"EURGBP 9% Stronger",-0.34499999999999997,-0.34029999999999999,-0.33560000000000001,-0.33090000000000003,-0.3261,-0.32140000000000002,-0.31659999999999999,-0.31180000000000002,-0.307,-0.30220000000000002,-0.2974,-0.29249999999999998,-0.28760000000000002,-0.2828,-0.27789999999999998,-0.27289999999999998,-0.26800000000000002,-0.2631,-0.2581,-0.25309999999999999,-0.24809999999999999]
[null,"EURGBP 10% Stronger",-0.34949999999999998,-0.3448,-0.34010000000000001,-0.33529999999999999,-0.3306,-0.32579999999999998,-0.32100000000000001,-0.31619999999999998,-0.31140000000000001,-0.30649999999999999,-0.30170000000000002,-0.29680000000000001,-0.29189999999999999,-0.28699999999999998,-0.28199999999999997,-0.27710000000000001,-0.27210000000000001,-0.26719999999999999,-0.26219999999999999,-0.2571,-0.25209999999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EURGBP"]
[null,null,"EURUSD 10% Weaker","EURUSD 9% Weaker","EURUSD 8% Weaker","EURUSD 7% Weaker","EURUSD 6% Weaker","EURUSD 5% Weaker","EURUSD 4% Weaker","EURUSD 3% Weaker","EURUSD 2% Weaker","EURUSD 1% Weaker","EURUSD 0% Stronger","EURUSD 1% Stronger","EURUSD 2% Stronger","EURUSD 3% Stronger","EURUSD 4% Stronger","EURUSD 5% Stronger","EURUSD 6% Stronger","EURUSD 7% Stronger","EURUSD 8% Stronger","EURUSD 9% Stronger","EURUSD 10% Stronger"]
["EURUSD","EURGBP 10% Weaker",-1874380.1653,-1859216.0133,-1843771.0438000001,-1828037.3832,-1812006.8611000001,-1795670.9957000001,-1779020.9790000001,-1762047.6610999999,-1744741.5330000001,-1727092.7093,-1709090.9091,-1690725.4362000001,-1671985.1577000001,-1652858.4816999999,-1633333.3333000001,-1613397.1292000001,-1593036.7505000001,-1572238.5142000001,-1550988.1422999999,-1529270.7293,-1507070.7071]
[null,"EURGBP 9% Weaker",-1899401.0160000001,-1884236.8640999999,-1868791.8944999999,-1853058.2339000001,-1837027.7117999999,-1820691.8463999999,-1804041.8296999999,-1787068.5118,-1769762.3836999999,-1752113.56,-1734111.7598000001,-1715746.2868999999,-1697006.0083999999,-1677879.3324,-1658354.1839999999,-1638417.9798999999,-1618057.6011999999,-1597259.3648999999,-1576008.993,-1554291.58,-1532091.5578000001]
[null,"EURGBP 8% Weaker",-1924885.2157999999,-1909721.0637999999,-1894276.0943,-1878542.4336999999,-1862511.9116,-1846176.0462,-1829526.0294999999,-1812552.7116,-1795246.5834999999,-1777597.7598000001,-1759595.9595999999,-1741230.4867,-1722490.2082,-1703363.5322,-1683838.3838,-1663902.1797,-1643541.801,-1622743.5647,-1601493.1928000001,-1579775.7797999999,-1557575.7575999999]
[null,"EURGBP 7% Weaker",-1950845.7557999999,-1935681.6037999999,-1920236.6343,-1904502.9737,-1888472.4515,-1872136.5862,-1855486.5695,-1838513.2516000001,-1821207.1235,-1803558.2997999999,-1785556.4996,-1767191.0267,-1748450.7482,-1729324.0722000001,-1709798.9238,-1689862.7197,-1669502.341,-1648704.1047,-1627453.7328000001,-1605736.3197999999,-1583536.2975999999]
[null,"EURGBP 6% Weaker",-1977296.1173,-1962131.9653,-1946686.9957000001,-1930953.3352000001,-1914922.8130000001,-1898586.9476000001,-1881936.9310000001,-1864963.6129999999,-1847657.4849,-1830008.6612,-1812006.8611000001,-1793641.3881999999,-1774901.1096999999,-1755774.4336999999,-1736249.2853000001,-1716313.0811999999,-1695952.7024999999,-1675154.4661000001,-1653904.0943,-1632186.6812,-1609986.659]
[null,"EURGBP 5% Weaker",-2004250.2952000001,-1989086.1432,-1973641.1736000001,-1957907.513,-1941876.9909000001,-1925541.1255000001,-1908891.1089000001,-1891917.7908999999,-1874611.6628,-1856962.8391,-1838961.0390000001,-1820595.5660999999,-1801855.2875999999,-1782728.6115999999,-1763203.4632000001,-1743267.2590999999,-1722906.8803999999,-1702108.6440000001,-1680858.2722,-1659140.8591,-1636940.8369]
[null,"EURGBP 4% Weaker",-2031722.8226000001,-2016558.6706999999,-2001113.7010999999,-1985380.0404999999,-1969349.5183999999,-1953013.6529999999,-1936363.6364,-1919390.3184,-1902084.1902999999,-1884435.3666000001,-1866433.5663999999,-1848068.0935,-1829327.8149999999,-1810201.1391,-1790675.9907,-1770739.7864999999,-1750379.4077999999,-1729581.1714999999,-1708330.7996,-1686613.3866000001,-1664413.3644000001]
[null,"EURGBP 3% Weaker",-2059728.7971999999,-2044564.6453,-2029119.6757,-2013386.0151,-1997355.493,-1981019.6276,-1964369.611,-1947396.2930000001,-1930090.1649,-1912441.3411999999,-1894439.541,-1876074.0681,-1857333.7897000001,-1838207.1137000001,-1818681.9653,-1798745.7611,-1778385.3824,-1757587.1461,-1736336.7742000001,-1714619.3611999999,-1692419.3389999999]
[null,"EURGBP 2% Weaker",-2088283.9086,-2073119.7567,-2057674.7871000001,-2041941.1265,-2025910.6044000001,-2009574.7390000001,-1992924.7223,-1975951.4044000001,-1958645.2763,-1940996.4526,-1922994.6524,-1904629.1795000001,-1885888.9010000001,-1866762.2250000001,-1847237.0766,-1827300.8725000001,-1806940.4938000001,-1786142.2575000001,-1764891.8855999999,-1743174.4726,-1720974.4504]
[null,"EURGBP 1% Weaker",-2117404.4676999999,-2102240.3158,-2086795.3462,-2071061.6856,-2055031.1635,-2038695.2981,-2022045.2815,-2005071.9635000001,-1987765.8354,-1970117.0116999999,-1952115.2115,-1933749.7386,-1915009.4601,-1895882.7842000001,-1876357.6358,-1856421.4316,-1836061.0529,-1815262.8166,-1794012.4447000001,-1772295.0316999999,-1750095.0094999999]
[null,"EURGBP 0% Stronger",-2147107.4380000001,-2131943.2861000001,-2116498.3165000002,-2100764.6559000001,-2084734.1338,-2068398.2683999999,-2051748.2516999999,-2034774.9338,-2017468.8056999999,-1999819.9820000001,-1981818.1817999999,-1963452.7089,-1944712.4304,-1925585.7545,-1906060.6061,-1886124.4018999999,-1865764.0231999999,-1844965.7868999999,-1823715.415,-1801998.0020000001,-1779797.9798000001]
[null,"EURGBP 1% Stronger",-2177410.4682999998,-2162246.3163999999,-2146801.3467999999,-2131067.6861999999,-2115037.1641000002,-2098701.2987000002,-2082051.2821,-2065077.9641,-2047771.8359999999,-2030123.0123000001,-2012121.2120999999,-1993755.7392,-1975015.4606999999,-1955888.7848,-1936363.6364,-1916427.4321999999,-1896067.0534999999,-1875268.8171999999,-1854018.4453,-1832301.0323000001,-1810101.0101000001]
[null,"EURGBP 2% Stronger",-2208331.9278000002,-2193167.7758999998,-2177722.8062999998,-2161989.1457000002,-2145958.6236,-2129622.7582,-2112972.7415,-2095999.4236000001,-2078693.2955,-2061044.4717999999,-2043042.6716,-2024677.1987000001,-2005936.9202000001,-1986810.2442000001,-1967285.0959000001,-1947348.8917,-1926988.513,-1906190.2767,-1884939.9047999999,-1863222.4918,-1841022.4696]
[null,"EURGBP 3% Stronger",-2239890.9432000001,-2224726.7911999999,-2209281.8217000002,-2193548.1611000001,-2177517.6389000001,-2161181.7736,-2144531.7568999999,-2127558.4389999998,-2110252.3108999999,-2092603.4872000001,-2074601.6869999999,-2056236.2141,-2037495.9356,-2018369.2596,-1998844.1111999999,-1978907.9071,-1958547.5284,-1937749.2921,-1916498.9202000001,-1894781.5072000001,-1872581.4850000001]
[null,"EURGBP 4% Stronger",-2272107.4380000001,-2256943.2861000001,-2241498.3165000002,-2225764.6559000001,-2209734.1338,-2193398.2683999999,-2176748.2516999999,-2159774.9338000002,-2142468.8056999999,-2124819.9819999998,-2106818.1817999999,-2088452.7089,-2069712.4304,-2050585.7545,-2031060.6061,-2011124.4018999999,-1990764.0231999999,-1969965.7868999999,-1948715.415,-1926998.0020000001,-1904797.9798000001]
[null,"EURGBP 5% Stronger",-2305002.1749,-2289838.0229000002,-2274393.0532999998,-2258659.3927000002,-2242628.8706,-2226293.0052,-2209642.9885999998,-2192669.6705999998,-2175363.5425,-2157714.7187999999,-2139712.9186999998,-2121347.4457,-2102607.1672999999,-2083480.4913000001,-2063955.3429,-2044019.1388000001,-2023658.7601000001,-2002860.5237,-1981610.1518999999,-1959892.7387999999,-1937692.7165999999]
[null,"EURGBP 6% Stronger",-2338596.7996999999,-2323432.6477999999,-2307987.6782,-2292254.0175999999,-2276223.4955000002,-2259887.6301000002,-2243237.6135,-2226264.2955,-2208958.1674000002,-2191309.3437000001,-2173307.5435000001,-2154942.0706000002,-2136201.7921000002,-2117075.1162,-2097549.9678000002,-2077613.7635999999,-2057253.3848999999,-2036455.1486,-2015204.7767,-1993487.3637000001,-1971287.3415000001]
[null,"EURGBP 7% Stronger",-2372913.8895999999,-2357749.7376999999,-2342304.7681,-2326571.1074999999,-2310540.5854000002,-2294204.7200000002,-2277554.7034,-2260581.3854,-2243275.2573000002,-2225626.4336000001,-2207624.6334000002,-2189259.1605000002,-2170518.8820000002,-2151392.2061000001,-2131867.0576999998,-2111930.8535000002,-2091570.4748,-2070772.2385,-2049521.8666000001,-2027804.4535999999,-2005604.4313999999]
[null,"EURGBP 8% Stronger",-2407977.0032000002,-2392812.8513000002,-2377367.8816999998,-2361634.2211000002,-2345603.699,-2329267.8336,-2312617.8169999998,-2295644.4989999998,-2278338.3709,-2260689.5471999999,-2242687.747,-2224322.2741,-2205581.9956,-2186455.3196999999,-2166930.1713,-2146993.9671,-2126633.5883999998,-2105835.3520999998,-2084584.9802000001,-2062867.5671999999,-2040667.5449999999]
[null,"EURGBP 9% Stronger",-2443810.7346999999,-2428646.5828,-2413201.6132,-2397467.9526,-2381437.4304999998,-2365101.5650999998,-2348451.5485,-2331478.2305000001,-2314172.1024000002,-2296523.2787000001,-2278521.4785000002,-2260156.0055999998,-2241415.7270999998,-2222289.0512000001,-2202763.9027999998,-2182827.6985999998,-2162467.3199,-2141669.0836,-2120418.7116999999,-2098701.2987000002,-2076501.2764999999]
[null,"EURGBP 10% Stronger",-2480440.7713000001,-2465276.6194000002,-2449831.6497999998,-2434097.9892000002,-2418067.4671,-2401731.6017,-2385081.5850999998,-2368108.2670999998,-2350802.139,-2333153.3152999999,-2315151.5151999998,-2296786.0422,-2278045.7637999998,-2258919.0877999999,-2239393.9394,-2219457.7352,-2199097.3565000002,-2178299.1201999998,-2157048.7483999999,-2135331.3352999999,-2113131.3130999999]
[]
[]
[]
[]
[null,null,null,null,"Levels"]
["EURGBP 10% Weaker","Strenght","Indic",null,"10% Stronger"]
["EURGBP 9% Weaker","10% Stronger",1,null,"9% Stronger"]
["EURGBP 8% Weaker","9% Stronger",2,null,"8% Stronger"]
["EURGBP 7% Weaker","8% Stronger",3,null,"7% Stronger"]
["EURGBP 6% Weaker","7% Stronger",4,null,"6% Stronger"]
["EURGBP 5% Weaker","6% Stronger",5,null,"5% Stronger"]
["EURGBP 4% Weaker","5% Stronger",6,null,"4% Stronger"]
["EURGBP 3% Weaker","4% Stronger",7,null,"3% Stronger"]
["EURGBP 2% Weaker","3% Stronger",8,null,"2% Stronger"]
["EURGBP 1% Weaker","2% Stronger",9,null,"1% Stronger"]
["EURGBP 0% Stronger","1% Stronger",10,null,"1% Weaker"]
["EURGBP 1% Stronger","1% Weaker",11,null,"2% Weaker"]
["EURGBP 2% Stronger","2% Weaker",12,null,"3% Weaker"]
["EURGBP 3% Stronger","3% Weaker",13,null,"4% Weaker"]
["EURGBP 4% Stronger","4% Weaker",14,null,"5% Weaker"]
["EURGBP 5% Stronger","5% Weaker",15,null,"6% Weaker"]
["EURGBP 6% Stronger","6% Weaker",16,null,"7% Weaker"]
["EURGBP 7% Stronger","7% Weaker",17,null,"8% Weaker"]
["EURGBP 8% Stronger","8% Weaker",18,null,"9% Weaker"]
["EURGBP 9% Stronger","9% Weaker",19,null,"10% Weaker"]
["EURGBP 10% Stronger","10% Weaker",20,null,"No Change"]