I am trying (for fun, not work) to calculate the investment percentage gain or loss on a pension fund. Two funds, actually.
Fund 1 - no investments in the year, so closing balance minus opening balance, divided by opening balance, works just fine.
Fund 2 - there is an opening and closing balance, and regular monthly payments in the year.
Is there an excel function that can calculate the percentage gain over the year.