Net Worth Calculator for India
Know what you own, what you owe and what is left.
Use this free Excel Net Worth Calculator to organize your household assets and liabilities in one place.
Free Excel template · Built for Indian families · No sign-up required
The workbook helps you calculate:
-
Total assets
-
Total liabilities
-
Total net worth
-
Investible net worth
-
Asset mix
-
Liability mix
-
Net worth by family member
-
Net worth changes over time
What Is Net Worth?
Net worth is the value of everything you own minus everything you owe.
In simple terms:
Net Worth = Total Assets − Total Liabilities
Your net worth statement, also called a personal balance sheet, helps you see whether your financial position is improving over time.
Assets are items of financial value that you own. Liabilities are amounts that you owe to banks, financial institutions or other parties.
A positive net worth means that the value of your assets is greater than your liabilities. A negative net worth means that your liabilities currently exceed your assets.
The direction of change is often more useful than the number on one isolated date. Reviewing your net worth periodically helps you see whether your assets are growing, liabilities are reducing and financial resilience is improving.
What Should You Include in a Net Worth Calculator?
A useful net worth calculator should include both assets and liabilities.
Common assets include:
-
Bank balances
-
Fixed deposits
-
Mutual funds
-
Shares
-
Bonds
-
EPF, PPF and NPS
-
PMS or other investment portfolios
-
Real estate
-
Gold
-
Business interests, where relevant
Common liabilities include:
-
Home loans
-
Personal loans
-
Vehicle loans
-
Credit card dues
-
Loans against property
-
Family or business borrowings
What Should You Include as Assets?
Include assets that have a reasonably identifiable financial value.
Common examples include:
-
Bank and savings account balances
-
Fixed deposits
-
Mutual funds
-
Direct equity investments
-
Bonds and other debt investments
-
Public Provident Fund
-
Employees’ Provident Fund
-
National Pension System holdings
-
Gold and other precious metals
-
Residential and commercial property
-
Business ownership or partnership interests
-
Cash value of eligible insurance products
-
Other investments or valuable financial assets
Use current values where they are readily available. For property, business interests or illiquid assets, use a reasonable and supportable estimate rather than an aspirational selling price.
What Should You Include as Liabilities?
Include outstanding amounts that you are responsible for repaying.
Common examples include:
-
Home loans
-
Loans against property
-
Vehicle loans
-
Education loans
-
Personal loans
-
Credit-card balances
-
Loans against investments
-
Business loans for which you are personally responsible
-
Other borrowings or unpaid financial obligations
Use the current outstanding principal rather than the original loan amount.
Total Net Worth Versus Investible Net Worth
Total net worth includes all assets after subtracting liabilities.
Investible net worth focuses on financial assets that can realistically be invested, rebalanced or used for goals. Your primary residence may be part of total net worth, but it may not be available for investment unless you plan to sell, downsize or borrow against it.
Both numbers are useful, but they answer different questions.
Total net worth may include your home, personal-use property, jewellery, vehicles, business interests and financial investments.
Investible net worth generally focuses on financial assets that can be allocated or reallocated towards goals, retirement and other investment objectives. It normally excludes personal-use assets such as the home you live in and vehicles used by the family.
A household can have a high total net worth but relatively low investible wealth if most of its value is concentrated in property or a family business.
Tracking both numbers gives a clearer picture of financial flexibility.
Net Worth Calculation Example
Assume a family owns:
-
Home worth ₹2.00 crore
-
Mutual funds worth ₹60 lakh
-
Provident fund and retirement assets worth ₹25 lakh
-
Bank deposits worth ₹15 lakh
Total assets are ₹3.00 crore.
The family also has:
-
Outstanding home loan of ₹55 lakh
-
Vehicle loan of ₹5 lakh
Total liabilities are ₹60 lakh.
Net worth = ₹3.00 crore − ₹60 lakh = ₹2.40 crore
If the home is treated as a personal-use asset, the family’s investible financial assets would be considerably lower than its total net worth. Both figures are useful, but they should not be confused.
How to Interpret Your Net Worth
Positive and increasing
Your assets are greater than your liabilities and the gap is growing. Review whether that growth is coming from regular savings, investment returns, property values or debt repayment.
Positive but stagnant
Your financial position is stable, but assets may not be growing sufficiently relative to inflation, income or future goals.
Negative but improving
A negative net worth is not automatically a permanent problem. Early-career households with education or home loans may initially have a negative figure. What matters is whether debt is declining and assets are being built consistently.
Falling net worth
A falling figure may indicate rising debt, use of investments for current expenses, investment losses, declining asset values or incomplete financial planning. Identify the cause before deciding what action is appropriate.
How Often Should You Calculate Net Worth?
Review your net worth at least once a year and after major financial changes such as:
-
Buying or selling property
-
Taking or repaying a large loan
-
Receiving an inheritance or business payout
-
Making a major investment
-
Changing jobs or retiring
-
Starting or closing a business
-
Adding or removing a family member from ownership records
-
Changing nominee or ownership details
-
Restructuring household investments
Use the same valuation approach each time so that comparisons remain meaningful.
Common Net Worth Calculation Mistakes
-
Using original purchase price instead of current asset value
-
Forgetting outstanding credit-card balances
-
Counting the full value of jointly owned assets without noting ownership
-
Ignoring loans against investments or property
-
Treating expected inheritance as a current asset
-
Using unrealistic values for private businesses or property
-
Counting the same investment in more than one place
-
Confusing total net worth with investible net worth
-
Ignoring tax or exit costs where they are material
-
Forgetting EPF, PPF, NPS or retirement balances
-
Ignoring business loans personally guaranteed by the family
-
Not updating the workbook after large transactions
What to Do After Calculating Your Net Worth?
Your net worth is one part of your broader financial position.
Next, consider:
-
Whether monthly cash flow is positive
-
Whether you have an adequate emergency reserve
-
Whether insurance protection is sufficient
-
Whether assets are allocated to important goals
-
Whether debt levels are manageable
-
Whether retirement funding is on track
-
Whether important records are organized for your family
-
Whether investment risk matches your risk profile
-
Whether too much net worth is concentrated in one asset
Explore All Free Financial Tools →
Frequently Asked Questions
What is net worth?
Net worth is the value of what you own minus what you owe. It is calculated as total assets minus total liabilities.
Should I include my home in net worth?
Yes, your home can be included in total net worth using a reasonable current value. It is useful to show it separately because a personal residence is generally not as readily available for goals as financial investments.
What is investible net worth?
Investible net worth focuses on financial assets that may be available for goals, retirement or portfolio allocation. It usually excludes personal-use assets such as the home you live in and vehicles used by the family.
Should jewellery and vehicles be included?
They may be included in total net worth if they have material resale value. Use conservative resale estimates rather than original purchase prices.
Is EPF part of net worth?
Yes. Your current Employees’ Provident Fund balance is a financial asset and can be included.
Is life-insurance cover an asset?
The death benefit of a term-insurance policy is not a current asset. Some insurance products may have a current surrender or cash value, but this should be based on actual policy information from the insurer.
Is positive net worth enough?
No. A household can have positive net worth but still have weak cashflow, inadequate insurance, concentrated assets, high debt or underfunded goals.
How often should I update my net worth?
At least once a year, and after major events such as buying property, repaying debt, selling assets, receiving inheritance, changing jobs or restructuring household investments.
Methodology and important Information
The Net Worth Calculator is provided for educational and organizational purposes.
The workbook calculates net worth using values entered by the user. It does not verify asset values, liabilities, ownership, tax costs, liquidity or legal title.
Actual sale, redemption or settlement values may differ from estimated values.
The workbook does not recommend a security, mutual fund, PMS, AIF, insurance product, tax action or legal action.
Investments in securities markets are subject to market risks. Read all relevant documents carefully before investing.
Workbook last reviewed: June 2026.