Hi
I would be grateful for help with this problem.
I am a broker in the energy industry. After completing a contract I will receive payments in monthly or quarterly instalments in arrears throughout the duration of the contract (1-3 years). I am keen to create a forecasting template that shows amounts due in on a month by month basis dependent upon the start date of the contract and the rules governing payments, plus the total payment due over the full term. The template would show months and years along the columns and contracts listed on each row. I would then gain a snapshot of what is coming in each month across all contracts by totalling each monthly value.
Many thanks
Bookmarks