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



6 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