Distribute value to ranked records

[cep32]

I have a list of road sections along with the year they were each constructed and their area. They all need to be renewed in 2018 but as we can't afford to do this we need to spread it over 5 years. The sections that get renewed in each of the 5 years then need to have that particular year given to them as the new construction year. I hope the image below helps. Sorry it isn't a table but I can't find any instructions on how to use tables in the forum.

Capture.JPG

Ideally the oldest surfaces should be done first and the newest last. Another difficulty is that the area per year to be assigned won't match the area of discrete road sections. It doesn't matter if the area renewed each year varies to match the individual section areas as long as the total over the five years remains the same. I am trying to get one of the outputs shown below.

Capture.JPG

I hope that is clear enough.

Thanks,
Chris