Excel
Analysis
Finance
Investment Fund Projected Performance
As apart of an exclusive trading group I built a simple excel sheet that allows an investor to enter a few parameters to give a reasonably accurate projection of the funds performance and individual returns. The trading group pools investor capital together and is traded autonomously based on algorithmic logic designed by the groups owners. Based on the multiple variables that impact the investment fund I built an excel sheet that's able to calculate a more realistic compounding growth, instead of the standard compounding interest formula.
The trading group charges a 15% "performance fee" on any net gains at the start of each calendar month. The formula I made to calculate each trading day incorporates this by separating returns by the month and charging the fee on the net returns. The trading bot also doesn't trade everyday, but only when it's parameters have been triggered. As a result I implemented the "Projected # of Trading Days" and allows the user to input the moving average of each months total trading days. The return rate is an overall average of how well the trading bot does, and based on historical data collected of this particular trading group the mean was 0.37% each trading day.
This excel sheet was made for myself and also distributed to other members of the group to help everyone involved to get a more realistic projection of their capital and the trading bot. I feel deep satisfaction by helping communities with anything my skills may be of help. I made this as a result of many people questioning if there was a way to better calculate their returns based on the specific variables in the trading bot, which is where I got the inspiration to end up making this speadsheet.
Want Access To The File?
Click the button below to access the available files for download. NOTE: You will need a password to access, please contact me if you require one.