I want to do a cash flow forecast, but with a variable where I can simulate renewal rates. I have a data set that has the start and end dates of a contract, contract length (if the end date is missing), and total value. I'd like to create a dashboard that looks not only at the anticipated revenue going forward (can be a simple calculation of total value / number of months to find the value of the contract by month) but also simulates what the revenue forecast would be assuming a specified renewal rate. This would simulate what would happen if an expired contract was to renew and be added to the cash flow forecast going forward. Is there a simple, yet elegant solution for dealing with this?
Please attach sample data as twbx format.