Create a variable financial model (preferably in excel). Model will help evaluate ROI for individual revenue producers and will calculate risk of ruin for individuals as well as company.
Significant statistical analysis function must be part of the spreadsheet tool that will be created. Example: each month producers will have 200-300 attempts to produce new revenue. We need a way to calculate the risk of loss to get that new revenue as well as clearly calculating the ROI.
We also need a way to calculate potential profitability of prospective producers. We can supply data that tracks how productive they have been in the past- and how many attempts to produce revenue they have today- but we need a way to predict how productive they will be going forward.
When finished- the spreadsheet will allow tracking of individual producers total income, risk adjusted income, roi and future expected income; graph their results; as well as summarizing results for all producers. Total producers is not expected to exceed 20.
Đã trao cho:
13 freelancer đang chào giá trung bình $482 cho công việc này
Hello. I am an MBA in finance and CFA. I have two years of industry experience in financial modelling and research. I have worked on very comprehensive models.
Hello! I can do this and will start immediately. I have large experience in programming for MT4, Neuro Trade and neuro Solution, Trade Station and doing analysys in Excel.
Hi, I've ample knowledge of Finance, Budgeting, Forecasting, Financial modeling and Financial Analysis. Please Check my Private Message. Regards, Naveed Iqbal.