Cash Flow Projection Probabilty

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


January-19February-19March-19April-19May-19June-19July-19August-19September-19October-19November-19December-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>
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,102,468
Messages
5,487,067
Members
407,575
Latest member
Stephen66

This Week's Hot Topics

Top