Distribution of Receipts into revenue recognition in next 6 months

[umairakram]

Good Morning,

I have the following sample data for Receipts and the requirements is to recognize revenue on straight line in 6 months starting the month of receipts. the revenue figures should be in separate columns. This data is provided monthly for 25 years.

Month Cash Inflows
Jun-15 2,165,874
Jul-15 2,165,874
Aug-15 2,165,874
Sep-15 2,165,874
Oct-15 2,165,874
Nov-15 2,165,874
Dec-15 2,165,874
Jan-16 3,718,083
Feb-16 3,718,083
Mar-16 3,718,083
Apr-16 3,718,083
May-16 3,718,083
Jun-16 3,718,083
Jul-16 3,718,083
Aug-16 3,718,083


Thanks for the help.