Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Opprotunity | Oct | Nov | Dec | Jan | Feb |
---|---|---|---|---|---|
Opportunity A | 5000 | 10000 | |||
Opportunity B | 5000 | 10000 | |||
Opportunity C | 1500 | 15000 | |||
Total | 5000 | 6500 | 10000 | 25000 |
Thanks in advance for your help,
Gethyn.
Hi Gethyn,
please have a look at attached sample file.
I used a separate calendar for the Timeline, and quite straight forward if clause to calculate the fees.
Please have a look if this is applicable and appropriate to your requiremtents.
Regards,
Stefan
Hi Gethyn,
please have a look at attached sample file.
I used a separate calendar for the Timeline, and quite straight forward if clause to calculate the fees.
Please have a look if this is applicable and appropriate to your requiremtents.
Regards,
Stefan
Hi Stefan,
Thanks for your speedy answer, it lokks as though it will work the way that I need it to. I will try it later and let you know.
Thanks,
Gethyn.