Free Net Worth Spreadsheet

2 Comment(s)

1. On Sep 8, 2006, Flexo said:

   You can hide the Division by Zero errors with a basic conditional formula, which would improve the initial look of the sheet.

2. On Oct 1, 2008, Kevin said:

   Thanks for this. It’s a good starting point so I don’t have to make mine from scratch. The formatting is pretty!

   One gripe, though:

   The way you calculated percentage change is very odd. Your formula is 100%-(old value/new value), which gives the percentage change relative to the new value instead of relative to the the old value. A more natural formula would be (new value/old value) - 100%.

   Your formula calls a change from $100 to $200 a “50% change”, while most people understand it to be a 100% increase.

1 Trackback(s)

1. Are you tracking your net worth? | Enginero.com on Apr 30, 2008