Cash Flow Forecast Problem

[Gethyn]

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.

[swuehl · Accepted solution]

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

[Gethyn]

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.