Track monthly recurring revenue

Track monthly recurring revenue

I have a CRM client using CRM Analytics. They track revenue in potentials with some custom fields that include:

1.   Project value (non recurring) [Currency]
2.   Contract term in months [Number]
3.   Monthly Recurring Revenue [Currency]
4.   Annual value (of recurring) [Formula(Currency)]   Monthly Recurring Revenue * 12)
5.   Total Contract Value [Formula (Currency)]         (Monthly Recurring Revenue * Contract term in months) + Contract term in months

Each potential also has contract start/end dates

What they want (ideally) is a chart that shows expected revenue month by month so that 3 deals in January with a recurring monthly revenue of 1k, 2k and 7k show 10k for January etc

I realise this doesn't product the required rows in ZReports to produce what I need...

Can anyone suggest the best approach to producing a chart that shows expected revenue per month  (assuming project revenue is due at contract start date)?

Thanks
Mark