Ravi Sir's Cards › Excel
Net Worth Tracker in Excel (card 2 of 2)
Revision card 2 for Net Worth Tracker in Excel: Debt ratio: =C20/C13 gives 29.2%; Liquid assets: =SUMIF(B5:B12,"Cash",C5:C12)+SUMIF(B5:B12,"Investment",C5:C12) gives ₹13,85,000. Includes an example data table.
Read card text
What this card says
2 for Net Worth Tracker in Excel: Debt ratio: =C20/C13 gives 29.2%
Liquid assets: =SUMIF(B5:B12,"Cash",C5:C12)+SUMIF(B5:B12,"Investment",C5:C12) gives ₹13,85,000. Includes an
Example
data table
Learn this in the lesson: Net Worth Tracker in Excel: Assets, Liabilities and Monthly Net Worth (with a Chart)