How to calculate cumulative return in MS Excel?
Posted on 2011-02-27
I want to calculate the cumulative return of a series of monthly fund returns over a monthly, quarterly and annual basis. Example:
Could someone please put these values into an excel spreadsheet for me and enter the appropiate formula to calculate this? Just to be clear, it is NOT simply the arithmetic sum of those numbers, it is the cumulative value I am seeking.