# Cash Flow Projection Probabilty

#### sajohnson05

##### New Member
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-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>

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### sajohnson05

##### New Member
Can anyone help with this?

1,106,264
Messages
5,510,204
Members
408,779
Latest member
Lermiapolar

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...