Please note that a link alone does not constitute an endorsement by Which?. If you go ahead and buy a product using our link, we will receive a commission to help fund our not-for-profit mission and our campaigns work as a champion for the UK consumer. In some cases, however, we have included links to regulated brands or providers with whom we have a commercial relationship and, if you choose to, you can buy a product from our commercial partners. We do not make, nor do we seek to make, any recommendations or personalised advice on financial products or services that are regulated by the FCA, as we’re not regulated or authorised by the FCA to advise you in this way. Optimise Media is registered in England and Wales to Exchange Street Buildings, 35-37 Exchange Street, Norwich, England, NR2 1DP and company number 04455319.

LifeSearch Partners Ltd is registered in England and Wales to 3000a Parkway, Whiteley, Hampshire, PO15 7FX, company number 03412386.ģ.Optimise Media Limited (FRN 313408), for the introduction of HSBC Group, who are authorised and regulated by the Financial Conduct Authority to provide credit brokering activity. LifeSearch Partners Limited (FRN 656479), for the introduction of Pure Protection Contracts, who are authorised and regulated by the FCA to provide advice and arrange Pure Protection Contracts. Ltd is authorised and regulated by the Financial Conduct Authority (FCA) to provide advice and arrange non-investment motor, home, travel and pet insurance products (FRN310635) and is registered in England and Wales to Greyfriars House, Greyfriars Road, Cardiff, South Wales, CF10 3AL, company number 03857130. Use the MIN function to find the lowest value in.

Use the MATCH function to find the row number of the peak value. Use the MAX function to find the peak value in the portfolio column. Ltd for the introduction of non-investment motor, home, travel and pet insurance products (FRN 610689). The following steps outline how to calculate maximum drawdown in Excel: Create a new worksheet and enter the dates and portfolio values in two separate columns. Which? Limited is registered in England and Wales to 2 Marylebone Road, London NW1 4DF, company number 00677665 and is an Introducer Appointed Representative of the following:ġ. The Which? Money Weekly newsletter is packed full of the latest news and advice to help you make the most of your finances, both in retirement and elsewhere. Optimistic - That's assuming that once you retire, your cash investment grows at an average of 1.00% a year, fixed interest at 5.50% a year and equities at 8.00% a year.

Middling - That's assuming that once you retire, your cash investment grows at an average of 0.50% a year, fixed interest at 4.75% a year and equities at 7.25% a year. Pessimistic - That's assuming that once you retire, your cash investment grows at an average of 0.00% a year, fixed interest at 4.00% a year and equities at 6.50% a year. The investment growth assumption is set at 'middling' but you can alter the level of growth as per these assumptions: Adventurous - 5% cash/25% fixed interest/70% stocks and shares.Moderate - 10% cash/40% fixed interest/50% stocks and shares.Cautious - 30% cash/50% fixed interest/20% stocks and shares.

Max drawdown chart