How To Find Excess Return In Excel. Use the cells in the second and third columns in the equation. Start_num is equal to or less than zero.
To do this, we need to close this out with a special keystroke combination by holding down ctrl and shift, then hitting enter. As the result, you will get multiple lines in excel cell. Excess return is identified by subtracting the return of one investment from the total return percentage achieved in another investment.