Calculating NAV (Net Asset Value) Excel or Other Software?

[norxam]

In order for someone to answer this they most likely need to know all the details of NAV calculations.

It?s not the simple calculation of total assets / total shares. It being able to remove fees on a daily basis and then being able to calculate expense for each investor based on their % ownership of the fund and the number of days invested at the end of the quarter.

The hardest part for me is being able to calculate the investors share based on the number if days they were invested when they did not all start on the same day.

If this can not be calculated in excel maybe someone can recommend software that is either free or low cost.

I think software might be the best way to go, I just need something affordable and something I can purchase online (due to time constraints).

Thx,
Norxam

 

[Geniere]

Excel is pretty much unlimited as to calculations it can perform, as well as competitive spreadsheets. If it cannot do a specific type of calculation, it is possible to create a macro program to do it. In Excel, a macro program is written in a language similar to Visual Basic.

If you can express your requirements in a formula, I can try to provide a macro or a method to implement it.

Lastly, be careful of any macro that you may receive. It is very possible it may have imbedded code which can be executed to do whatever the author wants it to do, like erase all your files and folders. Only accept code as a text file, so you may review it before it is run as a macro.