2 Replies Latest reply: Aug 16, 2011 7:31 AM by Gethyn Owen RSS

    Cash Flow Forecast Problem

    Gethyn Owen

      Hello,

       

       

      I have a problem creating a formula to produce a cash flow forecast.

       

       

      The fields I have are:

       

      Opportunity

      Estimated Close Date

      Billing Frequency

      PS Fees

      Annual License Fee

       

      I need to create a table, as shown below:

       

      Which applies 50% of PS Fees, 1 month after Estimated Close Date.

      Then the remainig 50% of PS Fees + 2 x Annual License Fee, 3 months after Estimated Close Date.

       

       

      OpprotunityOctNov
      DecJanFeb
      Opportunity A5000
      10000

      Opportunity B
      5000
      10000
      Opportunity C
      1500
      15000
      Total500065001000025000

       

      Thanks in advance for your help,

       

      Gethyn.