WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Asset Management Tutorials » Mutual Funds Tutorials » Net Asset Value Formula

Net Asset Value Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate Net Asset Value (NAV)

Net asset value formula is mainly used by the mutual funds order to know the unit price of specific fund at the specific time and according to the formula net asset value is calculated by subtracting the total value of the liabilities from the total value of assets of the entity and the resultant is divided by the total number of the outstanding shares.

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.

NAV = (Market Value of Securities held by the fund + Cash & Equivalent Holdings – Liabilities of the funds) / Number of Outstanding Shares

Net Asset Value Formula

Example

You can download this Net Asset Value Excel Template here – Net Asset Value Excel Template

Onus Fund has the following information. You need to find the NAV of this fund –

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Market Value of Securities held by the fund – $450,000
  • Cash & Equivalent Holdings – $50,000
  • Liabilities of the funds – $200,000
  • Number of Outstanding Shares – 10,000

By using the formula of NAV, we get –

  • Net Asset Value = (Market Value of Securities Held by the mutual/close-end fund + Cash & Equivalent Holdings – Liabilities of the fund)/Number of Outstanding Shares
  • Or,  = ($450,000 + $50,000 – $200,000) / 10,000
  • Or, = $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 holdings. 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 fund. What would you look for?

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.

Market value of Securities Held by the Fund
Cash & Equivalent Holdings
Liabilities of the Fund
Number of Outstanding Shares
Net Asset Value Formula =
 

Net Asset Value Formula =
Market value of Securities Held by the Fund + Cash & Equivalent Holdings − Liabilities of the Fund
Number of Outstanding Shares
0+0−0
= 0
0

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 Shares.

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

NAV in Excel

Recommended Articles:

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 Formula
  • Value Formula in Excel
  • Top Differences – Index Funds vs Mutual Funds
  • Net Present Value Formula
6 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Net Asset Value Excel Template

Coursera IPO Financial Model & Valuation Free Download