Hey Nick -
Is the requirement to have the monthly split natively in Workfront? We're doing something somewhat similar, but we capture the core data in Workfront - then the analysis is done with excel and/or tableau.
In the example above, are you sure you want it to be Yr 1, Yr 2, etc instead of ...