{"id":936,"date":"2026-11-11T11:34:53","date_gmt":"2026-11-11T11:34:53","guid":{"rendered":"https:\/\/avexai.io\/blog\/?p=936"},"modified":"2026-11-11T11:34:54","modified_gmt":"2026-11-11T11:34:54","slug":"cagr-explained","status":"publish","type":"post","link":"https:\/\/avexai.io\/blog\/cagr-explained\/","title":{"rendered":"CAGR Explained: Meaning, Formula and a Worked Example"},"content":{"rendered":"\n<div class=\"avex-quick-answer\">\n  <div class=\"qa-label\">Quick answer<\/div>\n  <p><strong>CAGR meaning, in one line: CAGR is the steady yearly rate at which a value would have to grow to get from its start value to its end value over a period. It smooths uneven years into one rate. The figure assumes that nothing is added or withdrawn between the start date and the end date, which is the limit to keep in mind when you use it on your own accounts.<\/strong><\/p><\/div>\n\n<div class=\"avex-key-takeaways\">\n  <h3>Key Takeaways<\/h3>\n  <ul>\n<li><strong>What it is:<\/strong> the one constant yearly rate that takes a value from its start to its end over a period.<\/li>\n<li><strong>The formula:<\/strong> CAGR = (end value \u00f7 start value) ^ (1 \u00f7 years) \u2212 1.<\/li>\n<li><strong>Why it differs from a simple average:<\/strong> it includes compounding, so +50% and \u221250% do not average to zero.<\/li>\n<li><strong>When it stops being enough:<\/strong> as soon as money is paid in or taken out along the way.<\/li>\n<\/ul><\/div>\n\n<h2>What is CAGR?<\/h2>\n<p><strong>CAGR definition: the constant yearly rate at which an investment would have grown to get from its start value to its end value, with the ups and downs in between smoothed away.<\/strong> What does CAGR stand for? Compound annual growth rate: &#8220;compound&#8221; because each year&#8217;s growth builds on the last, &#8220;annual&#8221; because the result is expressed per year.<\/p>\n<p>The point of smoothing is comparison. Two investments with different patterns of good and bad years can be put on the same footing by asking what single yearly rate would have produced each result. CAGR answers that question and nothing else: it does not account for deposits or withdrawals made after the start.<\/p>\n\n<h2>The CAGR formula<\/h2>\n<p><strong>The CAGR formula takes three numbers and returns a yearly percentage:<\/strong><\/p>\n<div class=\"avex-formula\"><code>CAGR = (end value \u00f7 start value) ^ (1 \u00f7 number of years) \u2212 1<\/code><\/div>\n<p>The start value is what the investment was worth at the beginning of the period. The end value is what it was worth at the end. The number of years is the length of the period between the two dates, and it does not have to be a whole number: a holding kept for eighteen months uses 1.5. The result is a yearly percentage, whether the period was shorter or longer than a year, and it can be worked out for the full holding period or for any stretch inside it.<\/p>\n\n\n\n<h2>How to calculate CAGR: a worked example<\/h2>\n<p><strong>How to calculate CAGR in four steps: take the start value, take the end value, count the years, and apply the formula.<\/strong> The first example below shows the steps; the second shows why a simple average of yearly returns gives a different, misleading number.<\/p>\n<div class=\"avex-pro-tip\">\n  <strong class=\"label\">Example 1 \u2014 the CAGR calculation (illustrative example, not real data)<\/strong>\n  <p>Start value: \u00a310,000. End value after two years: \u00a312,100 (the fund is worth \u00a311,000 after year one and \u00a312,100 after year two). Number of years: 2. Formula: (\u00a312,100 \u00f7 \u00a310,000) ^ (1 \u00f7 2) \u2212 1 = 1.21 ^ 0.5 \u2212 1 = 1.10 \u2212 1 = 10% a year. You can check it by hand: 1.10 \u00d7 1.10 = 1.21, so 10% compounded for two years takes \u00a310,000 to \u00a312,100.<\/p>\n  <p>The numbers are chosen to make the arithmetic easy. They are not a typical or expected return.<\/p><\/div>\n<div class=\"avex-pro-tip\">\n  <strong class=\"label\">Example 2 \u2014 simple average vs CAGR (illustrative example, not real data)<\/strong>\n  <p>Start value: \u00a310,000. Year one: +50%, so \u00a315,000. Year two: \u221250%, so \u00a37,500. The simple average of the two yearly returns is (50% + \u221250%) \u00f7 2 = 0%. The CAGR is (\u00a37,500 \u00f7 \u00a310,000) ^ (1 \u00f7 2) \u2212 1 = 0.75 ^ 0.5 \u2212 1 = 0.866 \u2212 1 = approximately \u221213.4% a year.<\/p>\n  <p>The numbers are chosen to make the arithmetic easy. They are not a typical or expected return.<\/p><\/div>\n<p>The simple average adds up yearly returns and divides, as if each year started from the same base. It does not: the second year&#8217;s \u221250% applies to a larger amount than the first year&#8217;s +50% was earned on. CAGR includes that compounding, which is why it describes what happened to the \u00a310,000 and the average does not.<\/p>\n\n<h2>CAGR in Excel and Google Sheets<\/h2>\n<p><strong>The CAGR formula in Excel and Google Sheets can be written two ways, and both give the same result as the formula above.<\/strong><\/p>\n<div class=\"avex-formula\"><code>=RRI(number of years, start value, end value)<\/code><\/div>\n<p>RRI takes three arguments in this order: the number of periods (the years), the present value (the start value) and the future value (the end value). With the figures from Example 1: <code>=RRI(2, 10000, 12100)<\/code> returns 0.10, or 10%.<\/p>\n<div class=\"avex-formula\"><code>=(end value \/ start value) ^ (1 \/ number of years) \u2212 1<\/code><\/div>\n<p>The second way is the formula typed out with the power operator; <code>=POWER(end value \/ start value, 1 \/ number of years) \u2212 1<\/code> is the same calculation with the POWER function. Either way, the spreadsheet and the hand calculation agree.<\/p>\n\n\n\n<h2>When CAGR is enough, and when money moves in and out<\/h2>\n<p><strong>CAGR is enough when one amount is invested at the start and nothing is added or withdrawn until the end.<\/strong> That is the assumption built into the formula: a single start value that grows, on its own, to a single end value.<\/p>\n<p>If money is paid in or taken out along the way, the formula no longer describes what the investor&#8217;s own money did, because part of the change in value is the deposits themselves. A different measure is needed then, one that counts the date and the amount of every deposit and withdrawal and gives a yearly rate for the whole set. The comparison of the two approaches, and the question of which return to track, is covered in the pillar article of this series. <!-- link added later (18 nov): <a href=\"https:\/\/avexai.io\/blog\/xirr-vs-twrr\/\">which return to track<\/a> --> When money moves in and out, you can <a href=\"https:\/\/avexai.io\/tools\/xirr-calculator\">work it out with dates<\/a> instead.<\/p>\n\n<h2>What CAGR does not tell you<\/h2>\n<p><strong>Three limits of the number.<\/strong> First, it hides the path: a 10% CAGR says nothing about the rises and falls between the start and the end, only about the two endpoints. Second, it depends on the dates chosen: move the start or the end by a year and the rate changes, because the endpoints change. Third, it says nothing about the future: CAGR describes a period that has already happened and is not a forecast of the next one.<\/p>\n\n<h2>Calculate CAGR for your own numbers<\/h2>\n<p>Enter a start value, an end value and the number of years, and the CAGR calculator returns the yearly rate for those figures. <a href=\"https:\/\/avexai.io\/blog\/cagr-calculator\/\">Try your own numbers<\/a>, or run it the other way round to see what yearly rate a target value would require.<\/p>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1794396674163\"><strong class=\"schema-faq-question\">What is a good CAGR?<\/strong> <p class=\"schema-faq-answer\">There is no single figure. What counts as a good CAGR depends on the period measured, the asset and the risk taken to earn it: different assets carry different risk, which shows up in their rates. No single number is good or bad on its own.<br><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1794396698307\"><strong class=\"schema-faq-question\">Can CAGR be negative?<\/strong> <p class=\"schema-faq-answer\">Yes. When the end value is below the start value, the formula returns a negative rate: the steady yearly rate of decline that would take the start value to the end value. Example 2 above shows a CAGR of about \u221213.4% a year.<br><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1794396715938\"><strong class=\"schema-faq-question\">Does CAGR include dividends?<\/strong> <p class=\"schema-faq-answer\">Only if they are in the end value. CAGR worked out on a share price alone ignores dividends; CAGR worked out on the total value of a holding with dividends reinvested includes them. Check which value the figure was built from before comparing two holdings.<br><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1794396737791\"><strong class=\"schema-faq-question\">How many years do I need for CAGR?<\/strong> <p class=\"schema-faq-answer\">There is no minimum. The formula works for periods shorter than a year (the number of years is then a fraction) and for periods of many years, over the full holding period or any part of it. Shorter periods produce rates that are more sensitive to the dates chosen.<\/p> <\/div> <\/div>\n\n\n\n<div class=\"avex-sources\">\n  <h3>Sources &amp; references<\/h3><ol>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/rri-function-6f5822d8-7ef1-4233-944c-79e8172930f4\">Microsoft Support \u2014 RRI function<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/power-function-d3f2908b-56f4-4c3f-895a-07fb519c362a\">Microsoft Support \u2014 POWER function<\/a><\/li>\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/9368238\">Google Docs Editors Help \u2014 RRI function (Google Sheets)<\/a><\/li>\n<\/ol>\n  <p style=\"font-size:13px;color:#777;margin-top:12px\">Last verified: 11 November 2026. Examples use invented round numbers and are not real data.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>CAGR is the steady yearly rate that takes a value from start to end. The formula, a worked example you can check by hand, the Excel version, and when CAGR stops being the right number.<\/p>\n","protected":false},"author":4,"featured_media":938,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_angie_page":false,"page_builder":"","footnotes":"","_wp_rev_ctl_limit":""},"categories":[50],"tags":[59],"class_list":["post-936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portfolio-analytics","tag-portfolio-returns"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CAGR Explained: Meaning, Formula and a Worked Example | Avex<\/title>\n<meta name=\"description\" content=\"What CAGR means, the formula, and how to calculate it by hand and in Excel, with a worked example. Plus when CAGR stops being enough.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/avexai.io\/blog\/cagr-explained\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CAGR Explained: Meaning, Formula and a Worked Example | Avex\" \/>\n<meta property=\"og:description\" content=\"What CAGR means, the formula, and how to calculate it by hand and in Excel, with a worked example. Plus when CAGR stops being enough.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/avexai.io\/blog\/cagr-explained\/\" \/>\n<meta property=\"og:site_name\" content=\"AvexAI Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-11T11:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-11T11:34:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/11\/cagr-explained.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1129\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jordan Doyle\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jordan Doyle\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/\"},\"author\":{\"name\":\"Jordan Doyle\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#\\\/schema\\\/person\\\/8237ff24bd17a5a704e5b4b08001ecf7\"},\"headline\":\"CAGR Explained: Meaning, Formula and a Worked Example\",\"datePublished\":\"2026-11-11T11:34:53+00:00\",\"dateModified\":\"2026-11-11T11:34:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/\"},\"wordCount\":1198,\"publisher\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/cagr-explained.webp\",\"keywords\":[\"portfolio-returns\"],\"articleSection\":[\"Portfolio Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/\",\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/\",\"name\":\"CAGR Explained: Meaning, Formula and a Worked Example | Avex\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/cagr-explained.webp\",\"datePublished\":\"2026-11-11T11:34:53+00:00\",\"dateModified\":\"2026-11-11T11:34:54+00:00\",\"description\":\"What CAGR means, the formula, and how to calculate it by hand and in Excel, with a worked example. Plus when CAGR stops being enough.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396674163\"},{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396698307\"},{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396715938\"},{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396737791\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#primaryimage\",\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/cagr-explained.webp\",\"contentUrl\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/cagr-explained.webp\",\"width\":1129,\"height\":630,\"caption\":\"A smooth growth curve drawn beside an uneven one, illustrating what CAGR smooths out\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/avexai.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/avexai.io\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CAGR Explained: Meaning, Formula and a Worked Example\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/\",\"name\":\"AvexAI Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/avexai.io\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#organization\",\"name\":\"AvexAI Blog\",\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-avex-logo-vertical.webp\",\"contentUrl\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-avex-logo-vertical.webp\",\"width\":500,\"height\":142,\"caption\":\"AvexAI Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/#\\\/schema\\\/person\\\/8237ff24bd17a5a704e5b4b08001ecf7\",\"name\":\"Jordan Doyle\",\"pronouns\":\"he\\\/him\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cropped-Profile-Pic-96x96.webp\",\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cropped-Profile-Pic-96x96.webp\",\"contentUrl\":\"https:\\\/\\\/avexai.io\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/cropped-Profile-Pic-96x96.webp\",\"caption\":\"Jordan Doyle\"},\"description\":\"Jordan is a finance professional with experience in investment research and financial analysis. He earned his Bachelor of Business Administration (BBA) in finance from James Madison University and his Master of Science (MS) in finance from George Mason University. Jordan has also passed all three levels of the CFA\u00ae Program. He previously worked at the CFA Institute, where he co-authored Smart Beta, Direct Indexing, and Index-Based Investment Strategies. His research focused on the drivers of active management in US and European markets and on frameworks for new index-based investment strategies. As Editorial Contributor at Avex AI, Jordan writes on portfolio analytics, broker reviews, and self-directed wealth management. Connect on LinkedIn \u2192\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/jordan-doyle-92024b160\\\/\"],\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/author\\\/jordan-doyle\\\/\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396674163\",\"position\":1,\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396674163\",\"name\":\"What is a good CAGR?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"There is no single figure. What counts as a good CAGR depends on the period measured, the asset and the risk taken to earn it: different assets carry different risk, which shows up in their rates. No single number is good or bad on its own.<br>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396698307\",\"position\":2,\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396698307\",\"name\":\"Can CAGR be negative?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Yes. When the end value is below the start value, the formula returns a negative rate: the steady yearly rate of decline that would take the start value to the end value. Example 2 above shows a CAGR of about \u221213.4% a year.<br>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396715938\",\"position\":3,\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396715938\",\"name\":\"Does CAGR include dividends?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"Only if they are in the end value. CAGR worked out on a share price alone ignores dividends; CAGR worked out on the total value of a holding with dividends reinvested includes them. Check which value the figure was built from before comparing two holdings.<br>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396737791\",\"position\":4,\"url\":\"https:\\\/\\\/avexai.io\\\/blog\\\/cagr-explained\\\/#faq-question-1794396737791\",\"name\":\"How many years do I need for CAGR?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"There is no minimum. The formula works for periods shorter than a year (the number of years is then a fraction) and for periods of many years, over the full holding period or any part of it. Shorter periods produce rates that are more sensitive to the dates chosen.\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CAGR Explained: Meaning, Formula and a Worked Example | Avex","description":"What CAGR means, the formula, and how to calculate it by hand and in Excel, with a worked example. Plus when CAGR stops being enough.","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:\/\/avexai.io\/blog\/cagr-explained\/","og_locale":"en_US","og_type":"article","og_title":"CAGR Explained: Meaning, Formula and a Worked Example | Avex","og_description":"What CAGR means, the formula, and how to calculate it by hand and in Excel, with a worked example. Plus when CAGR stops being enough.","og_url":"https:\/\/avexai.io\/blog\/cagr-explained\/","og_site_name":"AvexAI Blog","article_published_time":"2026-11-11T11:34:53+00:00","article_modified_time":"2026-11-11T11:34:54+00:00","og_image":[{"width":1129,"height":630,"url":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/11\/cagr-explained.webp","type":"image\/webp"}],"author":"Jordan Doyle","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jordan Doyle","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#article","isPartOf":{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/"},"author":{"name":"Jordan Doyle","@id":"https:\/\/avexai.io\/blog\/#\/schema\/person\/8237ff24bd17a5a704e5b4b08001ecf7"},"headline":"CAGR Explained: Meaning, Formula and a Worked Example","datePublished":"2026-11-11T11:34:53+00:00","dateModified":"2026-11-11T11:34:54+00:00","mainEntityOfPage":{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/"},"wordCount":1198,"publisher":{"@id":"https:\/\/avexai.io\/blog\/#organization"},"image":{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#primaryimage"},"thumbnailUrl":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/11\/cagr-explained.webp","keywords":["portfolio-returns"],"articleSection":["Portfolio Analytics"],"inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/","url":"https:\/\/avexai.io\/blog\/cagr-explained\/","name":"CAGR Explained: Meaning, Formula and a Worked Example | Avex","isPartOf":{"@id":"https:\/\/avexai.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#primaryimage"},"image":{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#primaryimage"},"thumbnailUrl":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/11\/cagr-explained.webp","datePublished":"2026-11-11T11:34:53+00:00","dateModified":"2026-11-11T11:34:54+00:00","description":"What CAGR means, the formula, and how to calculate it by hand and in Excel, with a worked example. Plus when CAGR stops being enough.","breadcrumb":{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396674163"},{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396698307"},{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396715938"},{"@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396737791"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/avexai.io\/blog\/cagr-explained\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#primaryimage","url":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/11\/cagr-explained.webp","contentUrl":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/11\/cagr-explained.webp","width":1129,"height":630,"caption":"A smooth growth curve drawn beside an uneven one, illustrating what CAGR smooths out"},{"@type":"BreadcrumbList","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/avexai.io\/"},{"@type":"ListItem","position":2,"name":"Blog","item":"https:\/\/avexai.io\/blog\/"},{"@type":"ListItem","position":3,"name":"CAGR Explained: Meaning, Formula and a Worked Example"}]},{"@type":"WebSite","@id":"https:\/\/avexai.io\/blog\/#website","url":"https:\/\/avexai.io\/blog\/","name":"AvexAI Blog","description":"","publisher":{"@id":"https:\/\/avexai.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/avexai.io\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/avexai.io\/blog\/#organization","name":"AvexAI Blog","url":"https:\/\/avexai.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/avexai.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/04\/cropped-avex-logo-vertical.webp","contentUrl":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/04\/cropped-avex-logo-vertical.webp","width":500,"height":142,"caption":"AvexAI Blog"},"image":{"@id":"https:\/\/avexai.io\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/avexai.io\/blog\/#\/schema\/person\/8237ff24bd17a5a704e5b4b08001ecf7","name":"Jordan Doyle","pronouns":"he\/him","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/06\/cropped-Profile-Pic-96x96.webp","url":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/06\/cropped-Profile-Pic-96x96.webp","contentUrl":"https:\/\/avexai.io\/blog\/wp-content\/uploads\/2026\/06\/cropped-Profile-Pic-96x96.webp","caption":"Jordan Doyle"},"description":"Jordan is a finance professional with experience in investment research and financial analysis. He earned his Bachelor of Business Administration (BBA) in finance from James Madison University and his Master of Science (MS) in finance from George Mason University. Jordan has also passed all three levels of the CFA\u00ae Program. He previously worked at the CFA Institute, where he co-authored Smart Beta, Direct Indexing, and Index-Based Investment Strategies. His research focused on the drivers of active management in US and European markets and on frameworks for new index-based investment strategies. As Editorial Contributor at Avex AI, Jordan writes on portfolio analytics, broker reviews, and self-directed wealth management. Connect on LinkedIn \u2192","sameAs":["https:\/\/www.linkedin.com\/in\/jordan-doyle-92024b160\/"],"url":"https:\/\/avexai.io\/blog\/author\/jordan-doyle\/"},{"@type":"Question","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396674163","position":1,"url":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396674163","name":"What is a good CAGR?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"There is no single figure. What counts as a good CAGR depends on the period measured, the asset and the risk taken to earn it: different assets carry different risk, which shows up in their rates. No single number is good or bad on its own.<br>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396698307","position":2,"url":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396698307","name":"Can CAGR be negative?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Yes. When the end value is below the start value, the formula returns a negative rate: the steady yearly rate of decline that would take the start value to the end value. Example 2 above shows a CAGR of about \u221213.4% a year.<br>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396715938","position":3,"url":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396715938","name":"Does CAGR include dividends?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"Only if they are in the end value. CAGR worked out on a share price alone ignores dividends; CAGR worked out on the total value of a holding with dividends reinvested includes them. Check which value the figure was built from before comparing two holdings.<br>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396737791","position":4,"url":"https:\/\/avexai.io\/blog\/cagr-explained\/#faq-question-1794396737791","name":"How many years do I need for CAGR?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"There is no minimum. The formula works for periods shorter than a year (the number of years is then a fraction) and for periods of many years, over the full holding period or any part of it. Shorter periods produce rates that are more sensitive to the dates chosen.","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/posts\/936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/comments?post=936"}],"version-history":[{"count":2,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/posts\/936\/revisions"}],"predecessor-version":[{"id":940,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/posts\/936\/revisions\/940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/media\/938"}],"wp:attachment":[{"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/media?parent=936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/categories?post=936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/avexai.io\/blog\/wp-json\/wp\/v2\/tags?post=936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}