Scribd Logo
Upload

Welcome to Scribd!

  • 103 views

    Cash Flow Sample (Planned / Actual) : Data Date: 1-Dec-12

    Uploaded by

    freann
    The document is a cash flow sample that compares planned and actual monthly cash flows over a 24 month period from September 2011 to August 2013. It shows that actual cumulative cash flows tracked closely with planned cash flows for the first 12 months but then actual cash flows stopped being recorded after October 2012, while planned cash flows continued to be projected out for the full 24 months. The sample provides details on planned and actual monthly and cumulative cash flows over time.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Cash Flow Sample (Planned / Actual) : Data Date: 1-Dec-12

    Uploaded by

    freann
    103 views4 pages
    The document is a cash flow sample that compares planned and actual monthly cash flows over a 24 month period from September 2011 to August 2013. It shows that actual cumulative cash flows tracked closely with planned cash flows for the first 12 months but then actual cash flows stopped being recorded after October 2012, while planned cash flows continued to be projected out for the full 24 months. The sample provides details on planned and actual monthly and cumulative cash flows over time.

    Original Description:

    cash flow

    Original Title

    Cash Flow Sample

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a cash flow sample that compares planned and actual monthly cash flows over a 24 month period from September 2011 to August 2013. It shows that actual cumulative cash flows tracked closely with planned cash flows for the first 12 months but then actual cash flows stopped being recorded after October 2012, while planned cash flows continued to be projected out for the full 24 months. The sample provides details on planned and actual monthly and cumulative cash flows over time.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    103 views4 pages

    Cash Flow Sample (Planned / Actual) : Data Date: 1-Dec-12

    Uploaded by

    freann
    The document is a cash flow sample that compares planned and actual monthly cash flows over a 24 month period from September 2011 to August 2013. It shows that actual cumulative cash flows tracked closely with planned cash flows for the first 12 months but then actual cash flows stopped being recorded after October 2012, while planned cash flows continued to be projected out for the full 24 months. The sample provides details on planned and actual monthly and cumulative cash flows over time.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 4
    At a glance
    Powered by AI
    The data shows planned and actual cash flow and percentages for a project over multiple months. It provides insights into the project's financial performance over its duration.

    The data represents the planned and actual (earned) monthly cash flow and cumulative percentages for a project from September 2011 to August 2013. The planned cash flow was the initial forecast, while the earned value is the actual amount achieved each month.

    The planned cash flow increased each month as expected based on the forecast. However, the actual earned value was lower than planned for most months in the early part of the project. Over time, the earned value improved and came closer to matching the planned amounts, though differences still remained in some later months.

    Cash Flow Sample ( Planned / Actual )

    Data Date: 1-Dec-12


    6,550,122

    6,485,269

    6,421,059

    4,981,255

    4,528,414

    4,116,740

    3,742,491

    4,116,740

    3,402,264

    3,092,968

    3,402,264

    3,374,146

    2,811,789

    2,556,172

    2,345,111

    2,814,134

    2,151,478

    2,581,774

    1,608,582

    2,010,727

    1,546,713

    1,933,392

    1,501,664

    1,472,219

    1,840,274

    30,000,000

    1,822,053

    40,000,000

    1,877,079

    2,632,652

    50,000,000

    3,067,406

    60,000,000

    3,742,491

    70,000,000

    4,528,414

    80,000,000

    5,230,318

    90,000,000

    5,766,425

    Cumulative Earned Value

    5,491,834

    Cumulative Planned Cash Flow

    6,357,484

    6,054,747

    Monthly Planned Value

    100,000,000

    Monthly Earned Value

    20,000,000

    10,000,000
    0

    0
    Description

    Sep/11

    Oct/11

    Nov/11

    Dec/11

    Jan/12

    Feb/12

    Mar/12

    Apr/12

    May/12

    Jun/12

    Jul/12

    Aug/12

    Sep/12

    Oct/12

    Nov/12

    Dec/12

    Jan/13

    Feb/13

    Mar/13

    Apr/13

    May/13

    Jun/13

    Jul/13

    Aug/13

    Planned Cash Flow


    /Week

    1,822,053

    1,840,274

    1,877,079

    1,933,392

    2,010,727

    2,151,478

    2,345,111

    2,556,172

    2,811,789

    3,092,968

    3,402,264

    3,742,491

    4,116,740

    4,528,414

    4,981,255

    5,230,318

    5,491,834

    5,766,425

    6,054,747

    6,357,484

    6,421,059

    6,485,269

    6,550,122

    Planned
    Week %

    1.99%

    2.01%

    2.05%

    2.11%

    2.20%

    2.35%

    2.56%

    2.79%

    3.07%

    3.38%

    3.72%

    4.09%

    4.50%

    4.95%

    5.44%

    5.71%

    6.00%

    6.30%

    6.61%

    6.94%

    7.01%

    7.08%

    7.15%

    0.00%

    Cumulative Planned
    Cash Flow

    1,822,053

    3,662,327

    5,539,407

    7,472,799

    9,483,526

    11,635,005

    13,980,116

    16,536,287

    19,348,076

    22,441,044

    25,843,308

    29,585,799

    33,702,538

    38,230,952

    43,212,207

    48,442,525

    53,934,359

    59,700,784

    65,755,531

    72,113,015

    78,534,074

    85,019,344

    91,569,466

    91,569,466

    Planned Cumulative
    %

    1.99%

    2.01%

    2.05%

    2.11%

    2.20%

    2.35%

    2.56%

    2.79%

    3.07%

    3.38%

    3.72%

    4.09%

    4.50%

    4.95%

    5.44%

    5.71%

    6.00%

    6.30%

    6.61%

    6.94%

    7.01%

    7.08%

    7.15%

    0.00%

    Earned Value
    /Week

    2,632,652

    1,472,219

    1,501,664

    1,546,713

    1,608,582

    2,581,774

    2,814,134

    3,067,406

    3,374,146

    3,402,264

    3,742,491

    4,116,740

    4,528,414

    Actual
    Weekly%

    2.88%

    1.61%

    1.64%

    1.69%

    1.76%

    2.82%

    3.07%

    3.35%

    3.68%

    3.72%

    4.09%

    4.50%

    4.95%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    Cumulative Earned
    Value

    2,632,652

    4,104,871

    5,606,534

    7,153,248

    8,761,830

    11,343,604

    14,157,738

    17,225,143

    20,599,290

    24,001,554

    27,744,045

    31,860,784

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    36,389,198

    Planned Cumulative
    %

    2.88%

    1.61%

    1.64%

    1.69%

    1.76%

    2.82%

    3.07%

    3.35%

    3.68%

    3.72%

    4.09%

    4.50%

    4.95%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    0.00%

    Page 1 of 4

    Date
    Earned Value
    Cum. Earned Value
    Planned Value
    Cum Planned Value

    Sep-11

    Oct-11

    Nov-11

    Dec-11

    Jan-12

    Feb-12

    2,632,651.52 1,472,219.16 1,501,663.55 1,546,713.45 1,608,581.99 2,581,774.10


    2,632,651.52 4,104,870.68 5,606,534.23 7,153,247.68 8,761,829.67 11,343,603.77
    1,822,053.42 1,840,273.95 1,877,079.43 1,933,391.82 2,010,727.49 2,151,478.41
    1,822,053.42 3,662,327.37 5,539,406.81 7,472,798.62 9,483,526.11 11,635,004.53

    Mar-12

    Apr-12

    May-12

    Jun-12

    Jul-12

    Aug-12

    Sep-12

    Oct-12

    Nov-12

    2,814,133.76 3,067,405.80 3,374,146.38 3,402,264.27 3,742,490.70 4,116,739.77 4,528,413.74


    14,157,737.53 17,225,143.34 20,599,289.72 24,001,553.99 27,744,044.69 31,860,784.46 36,389,198.20 36,389,198.20 36,389,198.20
    2,345,111.47 2,556,171.50 2,811,788.65 3,092,967.52 3,402,264.27 3,742,490.70 4,116,739.77 4,528,413.74 4,981,255.12
    13,980,116.00 16,536,287.50 19,348,076.15 22,441,043.67 25,843,307.94 29,585,798.64 33,702,538.40 38,230,952.15 43,212,207.27

    Dec-12

    Jan-13

    Feb-13

    Mar-13

    Apr-13

    May-13

    Jun-13

    Jul-13

    Aug-13

    36,389,198.20 36,389,198.20 36,389,198.20 36,389,198.20 36,389,198.20 36,389,198.20 36,389,198.20 36,389,198.20 36,389,198.20


    5,230,317.87 5,491,833.77 5,766,425.46 6,054,746.73 6,357,484.06 6,421,058.91 6,485,269.49 6,550,122.19
    48,442,525.14 53,934,358.91 59,700,784.36 65,755,531.09 72,113,015.16 78,534,074.06 85,019,343.56 91,569,465.75 91,569,465.75

    You might also like