Values over time

For a the above sales pipeline, I am trying to take the value of a lead and create a forecast of the revenue over time, based on it's value, start date and duration. I have done this in Excel a...