Cash Flow Projection Probabilty
Results 1 to 2 of 2

Thread: Cash Flow Projection Probabilty
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2013
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Cash Flow Projection Probabilty

    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

  2. #2
    New Member
    Join Date
    Aug 2013
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Cash Flow Projection Probabilty

    Can anyone help with this?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •