I happened to invest in a property with family many years ago and, for spreadsheet purposes, just left my equity constant. I didn't really know how to value my share on a month-to-month or year-to-year basis.
Well now we are selling, and it will increase my NW substantially enough to make the charts look funny. But it's not like I just had really good investment returns this month, it was a slower rise over many months. Those who don't keep charts can probably just move on to the next topic and really, this doesn't matter too much in the grand scheme of things.
Anyways, I'm thinking I'll just adjust my NW numbers for previous months according to the CAGR of the investment (assuming an exponential growth from original equity to current equity).
What do you think?