Project Earned Value Analysis Template 

Reminder : PMToolbox has ZERO tolerance to copyright violation and agrees to follow strictly PMI's Professional Responsibility. PMtoolbox makes no guarantee, representation or warrantees of the quality of this document for any professional use. Visitors use any materials they download at their discretion and risk.


6 Responses to “Project Earned Value Analysis Template”

  1. Susan on October 15th, 2008 2:11 pm

    In looking at the Project Earned Value Template, how/where are the MONTHLY EARNED VALUE (EV) and CUMULATIVE EARNED VALUE (EV) attained? I thought that in order to get the EV, you must take the PV to date x % completed. But there are comments inserted in this template that says, “This would have to be manually added in and stored in the row because this is a changing document.” for the Monthly Earned Value (EV) and for the Cumulative Earned Value (EV), the comment inserted is “This row does not auto calculate. It must be manually synced up with the Total in Column R every reporting period.” What do these two comments mean? I saw that there is an EV column, which I understand based on the formula to attain EV, but where do these two figures come from for the Monthly and Cumulative? Please assist. Thank you in advance!

  2. sumeet on October 24th, 2008 1:19 pm

    i want to know more about earned value analysis

  3. gopal on June 14th, 2009 7:36 am

    I need to have a sample template on Earned Value Analysis

  4. Manar Bennani on December 3rd, 2009 10:42 pm

    Very Usefull

  5. Fawzia Salahuddin on January 25th, 2011 5:49 am

    If though I have been using and teaching these concepts, seeing it in an excel sheet like this brought reality to these concepts. This sheet has made it easier for me to use them in my work projects.Thank you.

  6. David Ticknor on April 21st, 2011 5:48 am


    Be careful, EV is actual work completed and the value of that work (BCWP). Planned Value is the amount of work anticipated or scheduled (BCWS). Estimating the % complete is or can be very subjective. One needs to establish firm standards prior to the beginning of a given project for which measurements are established. Sometimes we assign 50% of the cost when tasks begin, then allocating 50% upon completion.

Got something to say?

Project Management Resources | Project Management Templates | Project Management Books | Project Management Software is your one stop source for project management, project management software,project management books, project management templates, project management news, project management glossary,project management tools...