If I take advantage of the mid-year adjustments function, how would I undo those adjustments? They would also need to go away when copying the sheet for a new year with new starting balances.
I noticed the cell where the adjustment numbers is placed in the Initial Balances sheet is locked. So deleting the value isn't an option. I instead did my own calculation of present value based on a mid-year value and rate of return entered as the assumption and came up with very similar, if not exact (I didn't check), numbers that I could then simply subtract from the initial balances. It looked like on the Analysis projection it came up with the same result so I guess that might be a workaround to undoing a mid-year change. An undo button and stored initial values hidden away in the sheet somewhere would be a suggestion.