

How to calculate your networth in Excel 

How
to calculate your networth in Excel using simple formulas based on the
total of your assets and liabilities. But why calculate your networth?
You can list your liabilities and assets in the columns as shown. The difference between what you own (assets) and what you owe (liabilities) gives you your networth as on the date shown. We have used simple formulas like 'sum' and functions like conditional formatting to calculate the networth and also highlight whether the networth is positive or negative. The networth is formatted as 'blue' if positive and 'red' if negative. As time passes and depending on your working, your networth may grow or fall. Sometimes actions beyond your control may change you networth. 




