Financial Model

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.