Maximum Consecutive Drawndown formula

Hey guys,

Couldn't find anything similar to my problem on the forum search.
I have a list of monthly percentage returns in column A.
I need a way to calculate the maximum drawdown that has occurred.
Here's an example:

7.40%
(11.00%)
12.20%
(1.60%)
10.70%
5.40%
1.00%
(12.30%)
0.10%
(14.20%)
(21.40%)
(5.70%)
(9.60%)
4.00%
(2.30%)
9.40%
8.40%
17.10%
(7.90%)
6.80%
(0.20%)
9.50%
(0.30%)
0.80%
3.00%
(5.90%)
3.70%
2.30%
(2.00%)
(10.90%)
(4.90%)
10.00%
(4.60%)
10.80%

The maximum drawdown would be the figures bolded summed up into one number (or multiplied to each other rather, but you get the point).
I need the maximum consecutive drawdown. In my example, the bolded figures sum to approximately 50%. If for example one of the monthly figures later on alone was -60%, I would need the formula to pick up that number.
Any simple way to do this without VBA?
Thanks guys and I'd be happy to provide more clarification if required!

I keyed some sample data into a spreadsheet and put together a solution. Please check out the attached file and see if it helps.

Hey Chuck,
Thanks for your solution, that is exactly what I'm looking for!
However, once I try inputting my data set, it doesn't seem to work. Would you be able to throw in the data set in my initial post and upload the file to see what I may be doing incorrectly?
Thanks again!

Works for me. Maybe a format thing? All I changed in the attached file (with your data) is the format to show the percentages with two decimals.

Fantastic.
Thank you so much!
Just efficiency sake, is there any way to do this without a helper column?
Thanks!

I couldn't get it to work without the helper column. In the end, I decided the helper was needed, but there are folks on the forum better at this than I and maybe they can suggest something.

Thanks for your help.
Could you also modify so instead of summing the consecutive negative numbers, instead what you're doing is adding 1 to each number and then multiplying them to each other, and at the end subtracting one? As this is the correct way to get the most accurate maximum drawdown figure. Especially if consecutive drawdowns come for longer periods of time.

I.e. (1+(-14%)*(1+(-21%)*(1+(-6%)*(1+(-10%)-1
I.e. the actual drawdown in my example just listed above would be: -32.06%

Thank you.