Stock/Crypto Fund Manager Portfolio and Distribution Tracker

This tool was designed to keep track of stock or crypto positions, profits, and dividends/staking rewards. It is not built for day trading and ideally for positions that last for at least 1 month. 

This template can be used for a multi-fund organization or a single individual that just wants a nice tracker. On the multi-member side of things, this will track deposits, withdrawals, share percentage, distributions, IRR lifetime, and a lot of other things that a fund manager needs to monitor over time.

There are configurations for management fees (fund operator share before distributions) and a preferred equity option / preferred return for the investor pool. The performance of all trading activity will be tracked and the result applied to all members according to their equity share.

This can be expanded with a little work and would handle up to 200 members with some customization. Also, the total assets that can be tracked is very easy to expand (currently set at 50).

The investor share is driven off of an IRR hurdle waterfall and assumes all profits are distributed. The aggregate deposit amount of all members will drive when various hurdles are reached. Deposits can happen at different times as well as withdrawals. There are 3 hurdles to give flexibility to how cash is shared per investor pool total IRR.

If an investor wants to re-invest, then the user would just input a new deposit for them and the IRR / cash flow would updated accordingly for that individual.

Unique and elegant logic was used to make sure profit taking uses correct cost logic. Instructions are shown to make sure data entry happens accurately.

The total holdings of the fund (value and units of each asset) are tracked based on trade data entry.

The value of total fund holdings over time is based on month-end reporting based on price inputs of each asset. The total units owned of each asset as of month end will auto-calculate based on the trade data entry.

Everything runs off database style entries that can be filtered, summed, and used to calculate fund performance over time by member and in total.

This works for long-only positions and multi or single member structures. It is also included in the joint venture bundle template package: https://www.eloquens.com/tool/MQJ8h73v/finance/joint-ventures/joint-venture-template-bundle

Each individual member will have their own IRR (monthly and annual basis) and cumulative distribution report tab (driven off a dropdown selector). Visualizations update accordingly that show total fund holdings over time and individual member activity on a monthly basis.