Question: how to calculate percentage gain or loss in excel?
Answer: Label cell A1 "Original Value," cell A2 "Final Value" and cell A3 "Percent Change."
Enter the original value in cell B1 and the final value in cell B2. ... 
Enter the formula "(B2-B1)/B1*100" and Excel will display the gain or loss expressed as a percentage.