Wednesday, April 5, 2017

NAV Calculator for your portfolio

Have you ever wondered how to compare your portfolio return against nifty on daily basis.

We often come across comparison where fund houses luring investors with their return comparing against Nifty or other benchmark index.

such comparison on one hand give an insight on how well one portfolio is doing against benchmark and on the other hand give an opportunity to challenge your limit to push for higher return.

I have created one such tool on EXCEL which you can use to create your own NAV Calculator.

Let me explain how to use the same.........

Date:         Put the date on which values are being recorded
Nifty:        Put nifty level as of the corresponding date

MCap:       Market Capitalization
Column with name ending MCap is current value of your portfolio. One need to record on regular interval. It is not mandatory to record the details on daily basis but it is recommended for better result.

Cap:         Capital Employed
Column with name ending Cap is total investment. Not current value.

DIV:        Dividend received

Two set has been provided for two different portfolio if you want to use.

After putting all the values one need to draw the chart, you can drag the selection to capture current value and you are done.

Note: Will explain in new post, how it has been calculated. Also, this tracker is may not fulfilling all the criteria of Index management.

Link



26 comments:

  1. • Capital First-Warburg Pincus sells 25 percent in Capital First, GIC Singapore ups stake to 14 percent'.
    • PVR realty firm Elan to invest Rs 550 crore and tie up with PVR.
    • Reliance Infrastructure’s subsidiary files Section 9 petition in the Delhi High Court for urgent payment of Arbitration Award
    CapitalStars

    ReplyDelete
  2. Jackson has a couple of particular styles of guitars. As formerly referred to, a Randy Rhoads character was written in team-work with Rhoads as longines dolce vita replica well as had an absurd physique. Other models embody a Warrior, a Kelly( identical to a Gibson Explorer, though a small some-more slim), a King V, as well as a Kelly Star.

    The electric automobile has eventually been delivered to a open, as well as a formula have been overwhelmingly certain to illustrate distant. There is a lot upon a list appropriate appropriate away as EVs have been alien to a marketplace. For example, will EVs be some-more environmentally tolerable than variety? Will they be some-more economically applicable for drivers? These have been questions that still breakwater t perceived answers, though you design advisers will be means to acquisition a answers in a entrance years. In a concurrently, Tinley Park Chevrolet dealers have been saying outrageous seductiveness in their brand new swath of Volts, a electric automobile staid to shift a approach drivers demeanour during a automobile attention perpetually. As well as a allowances of pushing movado se extreme replica a Volt will be heavily scored equally to a taking flight cost of gas; with all of a misunderstanding in a center easterly, America is you do a most appropriate to soothe itself of a faith upon oil as well as about-face to some-more tolerable forms of appetite -- a pierce that might disintegrate a little oil magnates though will have an overwhelmingly certain stroke upon a internal manage to buy. Lansing, IL used automobile drivers might suffer their cars appropriate appropriate away, though a destiny binds improved things for a pushing attention, most of that you ll see actuality in a subsequent multiform months.

    replica watches
    replica longines
    watches longines
    longines evidenza replica
    longines spirit replica
    longines heritage replica
    longines dolce vita replica
    longines conquest replica
    longines la grande classique replica
    longines elegant replica
    longines flagship replica
    longines lyre replica
    longines saint imierref replica

    ReplyDelete
  3. ONGC, Vedanta, BPCL, Tata Steel, Hindalco are among the gainers, whereas Infosys, Cipla, Asian Paints, Sun Pharma and Zee Entertainment are losing sheen on NSE.capitalstars

    ReplyDelete
  4. Sun Pharma rallied nearly 4 percent, followed by Dr Reddy's Labs, Lupin, Reliance Industries, Tata Motors, GAIL and Aurobindo Pharm.
    Equity Tips

    ReplyDelete
  5. These calculators may include multifunction buttons for a smaller, full featured tool. They are able to calculate root values, with separate buttons for square, cube, and any root. They also have trigonometric, logarithmic and exponential function keys.guarantor loans

    ReplyDelete
  6. By investing in mutual funds, you could diversify your portfolio across a large number of securities so as to minimise risk.

    Best Advisory Company

    ReplyDelete
  7. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. Looking forward for more posts from You!

    Forex Tips

    ReplyDelete
  8. It such a cute photos and so nice. babies are imitated each other which is so adorable.

    Conference System on Hire in Delhi
    DSLR Camera on Rent

    ReplyDelete
  9. Its quite different blog from others. This is so interesting and nice lines.

    Projector on hire in delhi
    Laptop on rent in delhi

    ReplyDelete
  10. I'm planar by your table make up the superior production.
    laminator

    ReplyDelete
  11. Hindalco, Nalco slip 9% as US softens stance on aluminium producer Rusal
    Market Risk Solutions

    ReplyDelete
  12. ICICI Bank stock rallies 6.5% post Q4FY18 numbers
    intraday Stock Tips

    ReplyDelete
  13. If you have no destination , you''ll never get there.
    financial advisory company

    ReplyDelete
  14. helpful blog.
    Not all storms come to disrupt your life, some come to clear your path.
    financial advisory company

    ReplyDelete
  15. Well explained about Nifti and related terminology. Need more articles like this.

    ReplyDelete
  16. Slot Machine Gaming at SlotsMate | Dr. Dr.MCD
    Find out what Slot Machine Gaming at SlotsMate 진주 출장샵 is all about and why you 서울특별 출장마사지 should play. The 천안 출장샵 game is played with a fixed number 충청북도 출장마사지 of symbols 강릉 출장샵 and you can find

    ReplyDelete
  17. try this web-site blog find out check here Check Out Your URL from this source

    ReplyDelete