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

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

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
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...
Top