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...