We have a sales pipeline board that we’re using to track our leads and open opportunities. In this board, we track the estimated deal value, the project start date, and the project end date. We’re a consulting firm, so we sell projects that last a certain number of months.
So, for example, a line in our board might be for a single project worth $100,000 that’s projected to last from April 1 to December 31.
My question is: Is there a formula I can use to calculate projected revenue per quarter from a deal? While the total deal value is $100,000, we will bill for time over the course of the project length. For a project that lasts 9 months, we’d be pulling in $11,111.11 per month, or $33,333.33 per quarter. How could I use a formula to do this?