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