spread revenue equally over 6 or 12 months depending on which product is sold

[mikeodonn]

Hello,
A newbie here. I thought my question would be addressed but I have not been able to find it in any searches. I hope that does not mean I am approaching it wrong. Any and all help and/or ideas will be greatly appreciated. We have 5 - six month programs and five - 12 month programs we are going to sell; each have a different price. I Want to insert number of projected sales manually for each month and then have excel distribute/spread revenue evenly over six or twelve months into a separate set of cells. First payment would be received at time of sale. I have attached a basic sample to try to explain it better. Thank you
Mike