Cash Flow Projection Probabilty

[sajohnson05]

I have a years worth of Cash Flow projections for Capital projects that are based on the start and end dates of construction. Each month i have been tracking the actual's compared to what the projections were and creating a chart based on the projections and actual's.

now i am being tasked with making a cone of probability graph that shows what the probability will be that are cash flow will hit the projections. I am not sure the best was of going about this. The red text is actuals


[TABLE="width: 1380"]
<colgroup><col><col span="12"></colgroup><tbody>[TR]
[TD][/TD]
[TD]January-19[/TD]
[TD]February-19[/TD]
[TD]March-19[/TD]
[TD]April-19[/TD]
[TD]May-19[/TD]
[TD]June-19[/TD]
[TD]July-19[/TD]
[TD]August-19[/TD]
[TD]September-19[/TD]
[TD]October-19[/TD]
[TD]November-19[/TD]
[TD]December-19[/TD]
[/TR]
[TR]
[TD="align: right"]January-19[/TD]
[TD="align: right"]$53,173,907.20[/TD]
[TD="align: right"]$43,173,865.29[/TD]
[TD="align: right"]$37,473,948.26[/TD]
[TD="align: right"]$33,560,144.15[/TD]
[TD="align: right"]$30,627,301.99[/TD]
[TD="align: right"]$27,501,167.03[/TD]
[TD="align: right"]$24,510,429.58[/TD]
[TD="align: right"]$22,036,142.43[/TD]
[TD="align: right"]$17,649,879.34[/TD]
[TD="align: right"]$12,785,792.13[/TD]
[TD="align: right"]$10,489,488.15[/TD]
[TD="align: right"]$9,254,908.42[/TD]
[/TR]
[TR]
[TD="align: right"]February-19[/TD]
[TD]$14,717,317.39[/TD]
[TD="align: right"]$52,243,237.55[/TD]
[TD="align: right"]$46,097,481.22[/TD]
[TD="align: right"]$41,857,580.17[/TD]
[TD="align: right"]$38,250,349.19[/TD]
[TD="align: right"]$34,073,213.94[/TD]
[TD="align: right"]$29,601,158.31[/TD]
[TD="align: right"]$26,203,082.08[/TD]
[TD="align: right"]$21,794,051.22[/TD]
[TD="align: right"]$15,532,430.24[/TD]
[TD="align: right"]$12,696,239.62[/TD]
[TD="align: right"]$11,020,124.98[/TD]
[/TR]
[TR]
[TD="align: right"]March-19[/TD]
[TD]$14,717,317.39[/TD]
[TD]$16,656,636.62[/TD]
[TD="align: right"]$55,278,863.97[/TD]
[TD="align: right"]$44,541,256.50[/TD]
[TD="align: right"]$39,695,962.52[/TD]
[TD="align: right"]$34,276,746.10[/TD]
[TD="align: right"]$29,427,799.18[/TD]
[TD="align: right"]$26,253,839.18[/TD]
[TD="align: right"]$21,808,320.14[/TD]
[TD="align: right"]$15,302,222.65[/TD]
[TD="align: right"]$12,434,402.40[/TD]
[TD="align: right"]$10,641,925.24[/TD]
[/TR]
[TR]
[TD="align: right"]April-19[/TD]
[TD]$14,717,317.39[/TD]
[TD]$16,656,636.62[/TD]
[TD]$18,196,769.24[/TD]
[TD]$61,094,241.63[/TD]
[TD]$47,223,688.53[/TD]
[TD]$41,034,090.06[/TD]
[TD]$34,130,251.81[/TD]
[TD]$29,526,955.39[/TD]
[TD]$24,397,718.88[/TD]
[TD]$16,713,636.87[/TD]
[TD]$13,595,973.03[/TD]
[TD]$11,630,136.76[/TD]
[/TR]
[TR]
[TD="align: right"]May-19[/TD]
[TD]$14,717,317.39[/TD]
[TD]$16,656,636.62[/TD]
[TD]$18,196,769.24[/TD]
[TD]$18,367,079.65[/TD]
[TD]$47,005,834.36[/TD]
[TD]$43,231,565.40[/TD]
[TD]$36,733,389.88[/TD]
[TD]$33,630,000.16[/TD]
[TD]$32,887,388.17[/TD]
[TD]$25,294,249.97[/TD]
[TD]$23,117,855.06[/TD]
[TD]$19,921,447.60[/TD]
[/TR]
[TR]
[TD="align: right"]June-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]July-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]August-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]September-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]October-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]November-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]December-19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[sajohnson05]

Can anyone help with this?