{"id":5532,"date":"2022-04-01T08:09:26","date_gmt":"2022-04-01T11:09:26","guid":{"rendered":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/"},"modified":"2022-04-01T08:09:26","modified_gmt":"2022-04-01T11:09:26","slug":"how-to-calculate-cagr-in-excel","status":"publish","type":"post","link":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/","title":{"rendered":"How To Calculate CAGR in Excel"},"content":{"rendered":"

Compound Annual Growth Rate, CAGR, is your rate of return for an investment over a specific period.<\/p>\n

Calculating CAGR by hand is a rather involved process, so below we\u2019ll go over how you can quickly calculate CAGR in Excel.<\/p>\n

<\/a><\/p>\n

CAGR Excel Formula<\/h2>\n

The formula for calculating CAGR in Excel is:<\/p>\n

=(End Value\/Beginning Value) ^ (1\/Number of Years) – 1<\/p>\n

The equation uses three different values:<\/p>\n

End value,<\/strong> which is the amount of money you\u2019ll have after the period has passed.
\n Beginning value<\/strong>, which is the amount of money you began with.
\n Number of years<\/strong>, which is the total number of years that have passed. <\/p>\n

Below we\u2019ll go over an example of how to calculate CAGR for a five years time frame in Excel using the sample data set shown below:<\/p>\n<\/p>\n

1.<\/span>\u00a0Identify the numbers you\u2019ll use in your equation. Using the sample data set above,<\/p>\n

The end value is 2143 (in cell B6).
\n The beginning value is 1000 (in cell B2).
\n The number of years is 5 (in cell A6). <\/p>\n

2.\u00a0<\/span>Input your values into the formula.\u00a0<\/span><\/p>\n

Excel offers many shortcuts, so you can simply input the cell numbers that contain each of your values into the equation. Using the sample data set above, the equation would be<\/p>\n

=(B6\/B2) ^ (1\/A6) – 1<\/p>\n

This is what it looks like in my Excel sheet:<\/p>\n<\/p>\n

Note that the equation changes color to correspond with the cells you\u2019re using, so you can look back and check that your inputs are correct before running the equation.<\/p>\n<\/p>\n

You can also enter actual values into the formula instead of cell numbers. The equation would then look like this:<\/p>\n

=(2143\/1000) ^ (1\/5) – 1<\/p>\n

3.<\/span> Once you\u2019ve entered your values, click enter and run the equation. Your result will appear in the cell containing the equation, as shown in the image below.<\/p>\n<\/p>\n

CAGR Formula in Excel as a Percentage<\/h3>\n

Your default result will be shown as a decimal. To view it as a percentage, right-click on the cell your result is in, select Format Cells<\/em>\u00a0and then Percentage<\/em>\u00a0in the dialogue box.<\/p>\n

Your result will be converted to a percentage, as shown in the image below.<\/p>\n<\/p>\n

Now let\u2019s go over a shortcut for calculating CAGR in Excel using the Rate function.<\/p>\n

How To Calculate CAGR Using RATE Function<\/h2>\n

The RATE function helps you calculate the interest rate on an investment over a period of time.The formula for calculating CAGR is:\u00a0<\/p>\n

=RATE(nper,, pv, fv)<\/span><\/p>\n

nper<\/strong>\u00a0is the total number of periods in the time frame you\u2019re measuring for. Since you\u2019re calculating annual growth rate, this would be 12.
\n pv<\/strong>\u00a0is the present value of your investment (must always be represented as a negative)
\n fv<\/strong>\u00a0is future value. <\/p>\n

Note that the standard RATE equation includes more variables, but you only need the above three to calculate your CAGR.<\/p>\n

Let\u2019s run an equation using the sample table below where nperi is 12, pv is 100, and fv is 500.<\/p>\n<\/p>\n

1.<\/span> In your sheet, select the cell that you want to contain your CAGR. I selected cell B5.<\/p>\n

2.<\/span> Enter the RATE formula and input your numbers. Note that you always<\/em>\u00a0need to express your present value as a negative, or you\u2019ll receive an error message.<\/p>\n

This is what my formula looks like.<\/p>\n

Note that you can also simply enter the cell numbers that your values are in. With my sample table the formula would look like this:<\/p>\n

=RATE(A2,,-B2,C2)<\/p>\n

3.<\/span> Click enter and run your equation. Using the sample data, my CAGR is 14%.<\/p>\n

Now you know how to quickly and easily calculate your CAGR in Excel, no hand calculations required.<\/p>\n<\/p>\n

<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Compound Annual Growth Rate, CAGR, is your rate of return for an investment over a specific period. Calculating CAGR by hand is a rather involved process, so below we\u2019ll go over how you can quickly calculate CAGR in Excel. CAGR Excel Formula The formula for calculating CAGR in Excel is: =(End Value\/Beginning Value) ^ (1\/Number […]<\/p>\n","protected":false},"author":0,"featured_media":5533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5532","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-noticias-marketing"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"yoast_head":"\nHow To Calculate CAGR in Excel - Contabilidade Caxias<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Calculate CAGR in Excel - Contabilidade Caxias\" \/>\n<meta property=\"og:description\" content=\"Compound Annual Growth Rate, CAGR, is your rate of return for an investment over a specific period. Calculating CAGR by hand is a rather involved process, so below we\u2019ll go over how you can quickly calculate CAGR in Excel. CAGR Excel Formula The formula for calculating CAGR in Excel is: =(End Value\/Beginning Value) ^ (1\/Number […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Contabilidade Caxias\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-01T11:09:26+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"How To Calculate CAGR in Excel\",\"datePublished\":\"2022-04-01T11:09:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/\"},\"wordCount\":602,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png\",\"articleSection\":[\"Marketing\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/\",\"name\":\"How To Calculate CAGR in Excel - Contabilidade Caxias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png\",\"datePublished\":\"2022-04-01T11:09:26+00:00\",\"author\":{\"@id\":\"\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png\",\"contentUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png\",\"width\":477,\"height\":59},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/01\\\/how-to-calculate-cagr-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Calculate CAGR in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/#website\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/\",\"name\":\"Contabilidade Caxias\",\"description\":\"Site especializado em Contabilidade para Caxias.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Calculate CAGR in Excel - Contabilidade Caxias","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/","og_locale":"pt_BR","og_type":"article","og_title":"How To Calculate CAGR in Excel - Contabilidade Caxias","og_description":"Compound Annual Growth Rate, CAGR, is your rate of return for an investment over a specific period. Calculating CAGR by hand is a rather involved process, so below we\u2019ll go over how you can quickly calculate CAGR in Excel. CAGR Excel Formula The formula for calculating CAGR in Excel is: =(End Value\/Beginning Value) ^ (1\/Number […]","og_url":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/","og_site_name":"Contabilidade Caxias","article_published_time":"2022-04-01T11:09:26+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#article","isPartOf":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/"},"author":{"name":"","@id":""},"headline":"How To Calculate CAGR in Excel","datePublished":"2022-04-01T11:09:26+00:00","mainEntityOfPage":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/"},"wordCount":602,"commentCount":0,"image":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png","articleSection":["Marketing"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/","url":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/","name":"How To Calculate CAGR in Excel - Contabilidade Caxias","isPartOf":{"@id":"https:\/\/contabilidadecaxias.com.br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png","datePublished":"2022-04-01T11:09:26+00:00","author":{"@id":""},"breadcrumb":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#primaryimage","url":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png","contentUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/9ff7a4fe-5293-496c-acca-566bc6e73f42-kn8NNY.png","width":477,"height":59},{"@type":"BreadcrumbList","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/01\/how-to-calculate-cagr-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/contabilidadecaxias.com.br\/"},{"@type":"ListItem","position":2,"name":"How To Calculate CAGR in Excel"}]},{"@type":"WebSite","@id":"https:\/\/contabilidadecaxias.com.br\/#website","url":"https:\/\/contabilidadecaxias.com.br\/","name":"Contabilidade Caxias","description":"Site especializado em Contabilidade para Caxias.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contabilidadecaxias.com.br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"}]}},"_links":{"self":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=5532"}],"version-history":[{"count":0,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts\/5532\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/media\/5533"}],"wp:attachment":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=5532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=5532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=5532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}