I really like the expected revenue based on probability. I think it's a realistic way to see the revenue pipeline based on what stage a potential is at.
i would, however, like to also create an "expected profit" based on probability too.
example, i have a $100K potential with a 10% profit margin that is 50%. The estimated revenue would be $50K thus the expected profit would now be $5K. It would be a great way to quickly see a realistic free cash flow for the forecast report.
Any ideas on how to create this? Thanks in advance.