When we come into contact with financial products such as funds, we will hear the concept of maximum withdrawal rate. It represents the worst possible situation of this product and has great reference value for risk calculation, so how should we calculate the maximum withdrawal rate?

How to calculate the maximum withdrawal rate;

A: The formula for calculating the maximum withdrawal rate is as follows:

Maximum value (1- policy value today/highest value of virtual account before today)

1, if we can't calculate, we can actually do it with the help of excel.

2. First of all, we need to have a set of dates and product evaluation corresponding to the dates.

3. Then we use the "min" function to calculate the net value of the lowest point of the product, and the formula is: (B2-MIN(B2:$B$93))/B2.

4. Then use the pull-down function of excel to get the daily net withdrawal rate.

5. Finally, using the "max" function, we can get the maximum withdrawal rate during this period, and the formula is "max (c: c) * 100".