From June 1 to July 2, my net worth increased an average of $36.96 per day, or $1,145.62 overall, to -$49,226.60. This is a 2.33% increase, and results in a projected zero net worth on 9/9/2014.
Thanks, extra paycheck, hope to see you again in December! That’s the same zero date as back in May, which also had the same daily change rate. Interesting. So I’m playing catch-up, I just need to keep playing. Visual pleasure below… with a spiffy new graph!
Popularity: 26%
graphs make me horny. LOL
It’s funny you mention that, because I almost called it a visual orgasm.
How do you calculate your even net worth date?
The formula in the Even Net Worth column is =A16+(ABS(B16)/(D16/(A16-$A$2)))
That is…
=todayDate+(absoluteValue(netWorth)/(overallChange/(todayDate-beginDate)))
Or, in English, I take the absolute value of my net worth (since it’s negative – if it were positive and I was shooting for a wealth goal instead, I wouldn’t need to do that), divide that by the result of the division of my overall change by the difference in dates from when I started to now, and add today’s date. I think I said that right. End result is figuring the overall average daily increase, dividing that by my net worth to figure the number of days it’ll take to get to zero, and add that number of days to today’s date.
I’m like Will Hunting (a la Good Will Hunting, der) when it comes to figuring crazy ass spreadsheet formulae. I’ve come up with ones 1000x more complex than that that appeared to be correct.
If you like, I can email you that sheet so you can fiddle with it yourself.
I would like that! I also enjoy data and graphs.