Formula to Calculate Net Asset Value (NAV)

Source: hdfcfund.com

If you have ever invested in mutual funds, you will repeatedly hear one term. It is NAV. The full form of NAV is Net Asset Value. It is the difference between the assets and the liabilities.

Let’s have a look at the formula of net asset value.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Net Asset Value Formula (wallstreetmojo.com)

Example

  • Market Value of Securities held by the fund – $450,000Cash & Equivalent Holdings – $50,000Liabilities of the funds – $200,000Number of Outstanding Shares – 10,000

  • Net Asset Value = (Market Value of Securities Held by the mutual/close-end fund + Cash & Equivalent Holdings – Liabilities of the fund)/Number of Outstanding SharesOr,  = ($450,000 + $50,000 – $200,000) / 10,000Or, = $300,000 / 10,000 = $30 per share.

Interpretation

  • In the net asset value formula, we first need to find the market value of the shares.To find out the market value of the shares held by the fund, we need to apply formula –The market value of the shares = Market price per share * Number of outstanding shares.If the market price per share is $10 per share and the number of outstanding shares is 1000, then the market value of the shares would be = ($10 * 1000) = $10,000.

  • The second component of the formula is cash and equivalent holdingsCash And Equivalent HoldingsCash and Cash Equivalents are assets that are short-term and highly liquid investments that can be readily converted into cash and have a low risk of price fluctuation.  Cash and paper money, US Treasury bills, undeposited receipts, and Money Market funds are its examples. They are normally found as a line item on the top of the balance sheet asset. read more. We will add this item because it is an asset.The third component of the formula is the liabilities of the fund.To find out the actual value of a fund, we need to look at the difference between the total assets and the total liabilities.Finally, we need to divide the difference by the number of outstanding shares to get NAV per share.

Use and Relevance

Let’s say that you would like to invest in a mutual fundMutual FundA mutual fund is a professionally managed investment product in which a pool of money from a group of investors is invested across assets such as equities, bonds, etcread more. What would you look for?

  • To find out the market value of the shares held by the fund, we need to apply formula –The market value of the shares = Market price per share * Number of outstanding shares.If the market price per share is $10 per share and the number of outstanding shares is 1000, then the market value of the shares would be = ($10 * 1000) = $10,000.

Many financial analysts argue that it is wiser to look at NAV rather than looking at the individual market price of the share. Here’s why.

  • They think that when you look at NAV of funds, you get the misconception that NAV dictates the future benefit of the fund. This, according to them, is utterly false.That’s why these financial analysts mention that you should look for the quality of funds and not the NAV. Yes, NAV is important, but as an investor, you shouldn’t put too much faith in the higher or lower NAV because that doesn’t make any difference in how much return the portfolio under the fund would generate.Suppose you want to take advantage of higher returns, select industries that have been growing much faster than the other industries. Let’s say if you choose to invest in the IT industry instead of other industries, you will be able to generate much higher returns on your investments.

Net Asset Value Calculator

You can use the following NAV Calculator.

Net Asset Value Calculation in Excel (with excel template)

Let us now do the same example above in Excel.

This is very simple. You need to provide the Four inputs of Market Value of Securities held by the fund, Cash & Equivalent Holdings, Liabilities of the fund’s Number of Outstanding SharesNumber Of Outstanding SharesOutstanding shares are the stocks available with the company’s shareholders at a given point of time after excluding the shares that the entity had repurchased. It is shown as a part of the owner’s equity in the liability side of the company’s balance sheet.read more.

You can easily calculate the net asset value in the template provided.

This has been a guide to Net Asset Value Formula. Here we learn how to calculate net asset value using its formula along with practical examples, a calculator, and a downloadable excel template. You may also have a look at these articles below to learn more about Financial Analysis.

  • Net Asset FormulaNet Asset FormulaThe net asset formula evaluates the company’s total assets surplus or deficit over its total liabilities. It determines the company’s net worth or value which is an indicator of its financial health.read moreValue Formula in ExcelValue Formula In ExcelIn Excel, the value function returns the value of a text representing a number. So, if we have a text with the value $5, we can use the value formula to get 5 as a result, so this function gives us the numerical value represented by a text.read moreTop Differences – Index Funds vs Mutual FundsTop Differences - Index Funds Vs Mutual FundsBoth index funds and mutual funds are used to diversify the portfolio. In contrast, index funds are closed-ended funds that generally track the index without deviating their holding. In contrast, mutual funds are open-ended funds that are managed actively, which differs from their benchmark by investing in various stocks.read moreNet Present Value Formula