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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,101,889
Messages
5,483,522
Members
407,397
Latest member
HerbA

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top