Forum Discussion
Solved
Distribute Projected Revenue Annually
I have sales data of open opportunities from our CRM system. I am trying to take the amount from each deal and project out the annual revenue billings for each record. The tables below show an exampl...
Do you have a formula for determining what % of contract value is to be shown in a particular year? How is that determined?
The amount to be shown in a particular year is based on the duration. So a duration of 24 months would divide the total amount by 24 to determine the monthly amount and then multiply the monthly amount by 12 to determine the annual amount. The trick is when the duration is more than 1 year but not full years. for ex. if the duration is 18months than the amount charged at the start of year 1 is the monthly amount *12 while the amount charged at the start of year 2 is the monthly amount *6.