Skip to content

Trending News

Exclusive
8 hours agoChimera Investment (CIM) Q2 2022 Earnings Call Transcript 8 hours agoBoost your ecommerce strategy with these 10 affiliate marketing tips 8 hours agoSenate GOP Blocks Insulin Price Cap For Private Insurance As Democrats Aim To Pass Economic Bill 9 hours ago4 Content Marketing Frameworks To Add Structure to Your Strategy 10 hours agoERP System: The Basics of ERP
Tuesday, Aug 9, 2022
hollywoodstarshoney hollywoodstarshoney

Long Life Business

Aug 9 2022

Chimera Investment (CIM) Q2 2022 Earnings Call Transcript

Nov 1 2018

Clothes

Nov 1 2018

Systemwide Enterprise & Finance

Nov 1 2018

Detailing House Improvement Initiatives At #bayberryhouse

Nov 1 2018

Vive Healthy Sport And Nutrition

Jan 1 2019

Enterprise

Primary Menu
  • Business Management
  • Business Analysis
  • Business Banking
  • News Business
  • Insurance
  • About Us
    • Contact Us
    • Advertise Here
    • Privacy Policy
    • Sitemap
  • Home
  • How To Calculate CAGR in Excel

How To Calculate CAGR in Excel

Posted On : April 3, 2022 Published By : Patricia A. Eldridge
How To Calculate CAGR in Excel

Table of Contents

  • CAGR Excel Formula
    • CAGR Formula in Excel as a Percentage
  • How To Calculate CAGR Using RATE Function

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’ll go over how you can quickly calculate CAGR in Excel.

Related Posts:

  • 199A Deduction Errors Cost Small Businesses Big Refunds

Download 10 Excel Templates for Marketers [Free Kit]

CAGR Excel Formula

The formula for calculating CAGR in Excel is:

=(End Value/Beginning Value) ^ (1/Number of Years) – 1

The equation uses three different values:

  • End value, which is the amount of money you’ll have after the period has passed.
  • Beginning value, which is the amount of money you began with.
  • Number of years, which is the total number of years that have passed.

Below we’ll go over an example of how to calculate CAGR for a five years time frame in Excel using the sample data set shown below:

sample data

1. Identify the numbers you’ll use in your equation. Using the sample data set above,

  • The end value is 2143 (in cell B6).
  • The beginning value is 1000 (in cell B2).
  • The number of years is 5 (in cell A6).

2. Input your values into the formula. 

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

=(B6/B2) ^ (1/A6) – 1

This is what it looks like in my Excel sheet:

calculate cagr in excel step 2: input your cell numbers into the equation

Note that the equation changes color to correspond with the cells you’re using, so you can look back and check that your inputs are correct before running the equation.

cagr formula in excel using cell numbers

You can also enter actual values into the formula instead of cell numbers. The equation would then look like this:

=(2143/1000) ^ (1/5) – 1

3. Once you’ve 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.

cagr equation calculation final result in excel

CAGR Formula in Excel as a Percentage

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 and then Percentage in the dialogue box.

Your result will be converted to a percentage, as shown in the image below.

cagr forumla in excel expressed as a percentage

Now let’s go over a shortcut for calculating CAGR in Excel using the Rate function.

How To Calculate CAGR Using RATE Function

The RATE function helps you calculate the interest rate on an investment over a period of time.The formula for calculating CAGR is: 

=RATE(nper,, pv, fv)

  • nper is the total number of periods in the time frame you’re measuring for. Since you’re calculating annual growth rate, this would be 12.
  • pv is the present value of your investment (must always be represented as a negative)
  • fv is future value.

Note that the standard RATE equation includes more variables, but you only need the above three to calculate your CAGR.

Let’s run an equation using the sample table below where nperi is 12, pv is 100, and fv is 500.

calculate CAGR using RATE formula in excel

1. In your sheet, select the cell that you want to contain your CAGR. I selected cell B5.

2. Enter the RATE formula and input your numbers. Note that you always need to express your present value as a negative, or you’ll receive an error message.

This is what my formula looks like.

sample cagr equation in excel using rate formulaNote that you can also simply enter the cell numbers that your values are in. With my sample table the formula would look like this:

=RATE(A2,,-B2,C2)

3. Click enter and run your equation. Using the sample data, my CAGR is 14%.

Now you know how to quickly and easily calculate your CAGR in Excel, no hand calculations required.

excel marketing templates

Posted in: InvestmentTagged : Amazon Business Credit Card,American Airlines Business Class,Att Business Login,Austin Business Journal,Best Bank For Small Business,Best Business Bank Accounts,Best Business Schools In Us,Best Business To Start,British Airways Business Class,Business Attire Men,Business Card Ideas,Business Casual Shoes For Women,Business Continuity Planning,Business Entity Search,Business Letter Template,Business Management Degree,Business Manager Facebook,Business Plan Outline,Business School Rankings,Colorado Business Search,Delaware Business Entity Search,Drop Shipping Business,Family Business Bet,Fox Business Live,Georgia Sos Business Search,Google Business Account,Harvest Small Business Finance,How To Build Business Credit,Is Saturday A Business Day,Is Sears Still In Business,Microsoft 365 Business,My Business Google,Name Generator Business,None Of Your Business,Ny Sos Business Search,Open A Business Bank Account,Pa Business Search,Plus Size Business Casual,Pnc Business Banking,Sos Business Search Ca,Sunbiz Business Search,Taking Care Of Business,The Business Of Being Born,Turbotax Home And Business 2020,Tx Sos Business Search,Venmo For Business,Verizon Business Plans,Virtual Address For Business,What Are Business Days,Women Business Casual

Post navigation

Why Buying Property in These Vacation Destinations Could Be a Great Investment
Ten31 Partners With Seetee For Powerhouse Bitcoin Infrastructure Investment Initiative

Categories

  • Business Analysis
  • Business Banking
  • Business Management
  • Insurance
  • Investment
  • News Business

Archives

  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • March 2020
  • January 2019
  • November 2018

Recent Posts

  • Chimera Investment (CIM) Q2 2022 Earnings Call Transcript
  • Boost your ecommerce strategy with these 10 affiliate marketing tips
  • Senate GOP Blocks Insulin Price Cap For Private Insurance As Democrats Aim To Pass Economic Bill
  • 4 Content Marketing Frameworks To Add Structure to Your Strategy
  • ERP System: The Basics of ERP

Visit Now

Wedding Photography

BL

TL

Intellifluence Trusted Blogger

promo toyota malang

water damage restoration las vegas

hollywoodstarshoney.com All rights reserved
Theme: Royal Magazine by ThemeinWP
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT