![\"Earned](\"https:\/\/sitemate.com\/wp-content\/uploads\/2019\/06\/Earned-value-formula-sheet.png\" "\\"Earned")
\n\tGetting your earned value calculations<\/a> right and tracking earned value accurately gives project managers and companies more insights into performance as the project progress, and more power to effect the project on a cost and schedule basis.<\/p>\n The reason for seeking out and using an earned value formula sheet is to understand and use all of the critical earned value formulas.<\/a><\/p>\n Calculating the different components of earned value requires a number of different formulas, which are used to paint a full and comprehensive picture of project health.<\/p>\n Almost all projects can benefit from most of the formulas on this earned value formula sheet, while others will just reference a few.<\/p>\n\t Planned value (PV):<\/p>\n PV = % of project completed (planned) x Budget at completion (BAC)<\/strong><\/p>\n Earned value (EV):<\/p>\n EV = % of project completed (actual) x Budget at completion (BAC)<\/strong><\/p>\n Actual cost (AC):<\/p>\n AC = The actual costs of the project to date<\/strong><\/p>\n Schedule variance (SV):<\/p>\n SV = Earned value – Planned value<\/strong><\/p>\n Cost variance (CV):<\/p>\n CV = Earned value – Actual cost<\/strong><\/p>\n Schedule performance index (SPI):<\/p>\n SPI = Earned value \/ Planned value<\/strong><\/p>\n Cost performance index (CPI):<\/a><\/p>\n CPI = Earned value \/ Actual cost<\/strong><\/p>\n Budget at completion (BAC):<\/p>\n BAC = The total planned budget for the project (or phase of works)<\/strong><\/p>\n Estimate at completion (EAC):<\/p>\n There are a few different ways to approach and calculate EAC, which you can read about here<\/a>.<\/b><\/p>\n Variance at completion (VAC):<\/p>\n VAC = BAC – EAC<\/strong><\/p>\n Estimate to complete (ETC):<\/p>\n ETC = EAC – AC or new estimate<\/b><\/p>\n To complete performance index (TCPI):<\/a><\/p>\n TCPI = (BAC – EV) \/ (BAC – AC) or (BAC – EV) \/ (EAC – AC)<\/strong><\/p>\n If you would like more detail about these formulas, as well as some examples of how they are used to actually calculate EV, click here<\/a>.<\/p>\n\t How often you need to reference an earned value formula sheet will depend on how you calculate and use earned value.<\/p>\n For some companies, their earned value formulas are embedded into the excel sheets they use to calculate earned value, for other companies, their earned value calculations are automated and derived straight from dedicated software systems.<\/p>\n If you calculate earned value manually, then you will likely need to reference this or another earned value formula sheet on a regular basis.<\/p>\n\t People in 100+ countries<\/strong> use this software to better track and calculate earned value.<\/p>\n\t\t\t\n\t\t\t\t\t\t\tSee how\n\t\t\t\t\t<\/a>\n\t\t\t\t Earned value formula sheet What do you need on the your earned value formula sheet? Earned value management is an important component of managing any project, especially for projects in industries like construction and oil and gas, where projects stem for long periods of time and have hundreds of interdependent pieces, and internal and external…<\/p>","protected":false},"author":2,"featured_media":12624,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":"","rank_math_title":"Earned value formula sheet (Copy, use or download here)","rank_math_description":"This earned value formula sheet contains all of the earned value formulas you need to properly measure project performance. Use the formula sheet here.","rank_math_canonical_url":"","rank_math_focus_keyword":"earned value formula sheet"},"categories":[13,12],"tags":[],"industry":[],"product":[],"region":[],"system":[],"content_type":[],"class_list":["post-12622","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance","category-production"],"acf":[],"custom_permalink":"resources\/articles\/finance\/earned-value-formula-sheet","_links":{"self":[{"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/posts\/12622","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/comments?post=12622"}],"version-history":[{"count":0,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/posts\/12622\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/media\/12624"}],"wp:attachment":[{"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/media?parent=12622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/categories?post=12622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/tags?post=12622"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/industry?post=12622"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/product?post=12622"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/region?post=12622"},{"taxonomy":"system","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/system?post=12622"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/sitemate.com\/nz\/wp-json\/wp\/v2\/content_type?post=12622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}The earned value formula sheet<\/h2>\n
How and when to use an earned value formula sheet<\/h2>\n
![\"Sitemate](\"https:\/\/sitemate.com\/wp-content\/uploads\/2018\/11\/World-map-users.png\" "\\"Sitemate")
\n\tSee how you can easily streamline your systems and processes with Sitemate today<\/h2>\n\t\t\t\n\t\t\t\t\t\t\tLearn more \u2192\n\t\t\t\t\t<\/a>\n\t\t\t\n\t\t\t\t\t\t\tWatch a demo\n\t\t\t\t\t<\/a>\n\t
![](\"https:\/\/sitemate.com\/wp-content\/uploads\/2020\/11\/20-11-11-User-pair-37-1-1.svg\")
","protected":false},"excerpt":{"rendered":"