Connect with us

MARKETING

How To Calculate CAGR in Excel

Published

on

How To Calculate CAGR in Excel


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.

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



Source link

MARKETING

Drive Conversions and Generate Engagement With Instacart Promotions

Published

on

Drive Conversions and Generate Engagement With Instacart Promotions

Through deals and coupons, Instacart has saved consumers more than $700 million in 2022. As we dive into 2023, the leading grocery technology company in North America has big plans to help consumers save even more while also helping CPGs generate sales. Instacart recently announced an advertising solution that helps both sellers and consumers called Instacart Promotions. This exciting feature is designed to help drive conversions, boost sales, and generate overall engagement on the app.

Interested in this feature and how it can help your business on Instacart? Read on as we dive into everything you need to know about this ad solution including benefits, how to get started, and more.

 

What are Instacart Promotions?

 

Instacart Promotions is an advertising feature that’s now available to all brand partners, including emerging brands, within their open beta program. Promotions give CPGs the opportunity to offer new deal structures, promotions, and incentives with Instacart Ad campaigns. With this feature in place, consumers will have access to more promotions, coupons, and deals that are tailored to them within the Instacart Marketplace.

“With the launch of our new Instacart Promotions, all of our brand partners now have the ability to set up coupons and promotions that can drive meaningful business results while also passing on more savings opportunities to consumers. We’re proud to continue expanding our portfolio with additional self-service capabilities, ad formats that drive results, and measurement that brands need to understand the true impact of their campaigns on Instacart.”

 

– Ali Miller, VP of Ads Product at Instacart

 

Source: Instacart

 

How Do Instacart Promotions Work?

 

Promotions, now available in Ads Manager, gives consumers the ability to discover more promotions and savings opportunities within the Instacart app. These promotions now show up directly on product item cards before checkout for easy accessibility. Promotions allow advertisers to customize their campaigns to sync with their goals and objectives whether that be driving sales, building baskets, or boosting trials.

Instacart shared a recent example of a brand successfully utilizing Promotions… 

Athletic Brewing, General Mills, Sola Company, and Wells Enterprises (maker of Halo Top) are strengthening campaign performance by pairing Instacart Promotions with ad formats such as Sponsored Product and Display. Instacart Promotions include two new flexible and customizable structures: Coupons (“buy X units, save $Y”) and Stock Up & Save (“Spend $X, Save $Y”). 

According to Instacart, in the coming months, the company “will work to further enhance the new offering with new deal structures such as Free Gifts and Buy One, Get One (“BOGO”). The new deal structures will help brand partners run “Free Sample” programs that can win new customers and serve personalized discounts for different customer segments, such as “new to brand” and “new to category.”  

 

Example of Instacart Promotions

Source: Instacart

 

Instacart Promotions Benefits

 

Deliver Value and Savings to Consumers

 

With Instacart Promotions, you have the opportunity to deliver value and savings that will have consumers coming back for more. With this savings feature, your brand can stand out among the competition and offer a variety of deals to shoppers ie: “Buy X units, Save $Y”.

 

Hot tip: Ensure you are selecting products for your promotion that are well-stocked and widely available.  

 

Tailor Your Campaigns to Specific Objectives

 

With a variety of savings options available, your brand can structure deals to fit specific business goals and objectives. 

 

Hot tip: If you’re looking to drive visibility and awareness, try pairing promotions with Sponsored Product campaigns. 

 

Access Real-Time Performance Insights 

 

The Promotions beta program is live and can be accessed within Instacart Ads Manager. Within Ads Manager, advertisers can access real-time insights to maximize performance and adjust campaigns as needed.

 

Hot tip: Make sure your budget matches your discount and objectives.

 

“As an advertiser, Instacart’s unique offering to self-manage promotions is so exciting! Historically, making adjustments to offer values and other promotion parameters was a more manual process, but now we’ll be able to easily make optimizations in real-time based on redemption performance.”

Emily Choate

Emily Choate, Senior Specialist, Marketplace Search at Tinuiti

 

Interested in Instacart Promotions?

 

With Instacart Promotions, you have the opportunity to reach new customers, build bigger baskets, and drive sales. Interested in testing out the beta program or looking to get started with advertising on the app? Drop us a line – we’d love to help elevate your CPG brand on Instacart.

 

Source link

Continue Reading

MARKETING

(Re)Introducing your favorite Optimizely products!

Published

on

(Re)Introducing your favorite Optimizely products!



It’s important to us that you, our valued customers and partners, can identify with the tools you use daily.  

In that pursuit, Optimizely set out to simplify the way we talk about our product suite. That starts, first and foremost, with the words we use to refer to the technology.  

So, we’ve taken a hard look at everything in our portfolio, and are thrilled to introduce new names we believe are more practical, more consistent, and better representative of the technology we all know and love.  

You may have seen some of these names initially at Opticon 2022 as well as on our website. In the spirit of transparency, the team here at Optimizely wanted to make sure you had full visibility into the complete list of new names, as well as understand the context (and rationale) behind the changes. 

So, without further ado… 

Which names changed?  

Some, but not all. For your ongoing reference, below is a complete list of Optimizely products, with previous terminology you may be familiar with in the first column, and (if applicable) the new name in the second column.  

Used to be… 

Is now (or is still)… 

Meaning… 

DXP 

Optimizely Digital Experience Platform 

A fully-composable solution designed to support the orchestration, monetization, and experimentation of any type of digital experience — all from a single, open and extensible platform. 

Content Cloud 

Optimizely Content Management System 

A best-in-class system for building dynamic websites and helping digital teams deliver rich, secure and personalized experiences. 

Welcome 

Optimizely Content Marketing Platform 

An industry-leading and user-friendly platform helping marketing teams plan campaigns, collaborate on tasks, and author content. 

DAM 

Optimizely Digital Asset Management 

A modern storage tool helping teams of any size manage, track, and repurpose marketing and brand assets (with support for all file types). 

Content Recs 

Optimizely Content Recommendations 

AI-powered and real-time recommendations to serve the unique interests of each visitor and personalize every experience. 

B2B Commerce 

Optimizely Configured Commerce 

A templatized and easy-to-deploy platform designed to help manufacturers and distributors drive efficiency, increase revenue and create easy buying experiences that retain customers. 

Commerce Cloud 

Optimizely Customized Commerce 

A complete platform for digital commerce and content management to build dynamic experiences that accelerate revenue and keep customers coming back for more. 

PIM 

Optimizely Product Information Management 

A dedicated tool to help you set up your product inventory and manage catalogs of any size or scale. 

Product Recs 

Optimizely Product Recommendations 

Machine-learning algorithms optimized for commerce to deliver personalized product recommendations in real-time. 

Web 

Optimizely Web Experimentation 

An industry-leading experimentation tool allowing you to run A/B and multi-variant tests on any channel or device with an internet connection. 

Full Stack 

Optimizely Feature Experimentation 

A comprehensive experimentation platform allowing you to manage features, deploy safer tests, and roll out new releases – all in one place. 

Personalization 

Optimizely Personalization 

An add-on to core experimentation products, allowing teams to create/segment audiences based on past behavior and deliver more relevant experiences. 

Program Management 

Optimizely Program Management 

An add-on to core experimentation products, allowing teams to manage the end-to-end lifecycle of an experiment. 

ODP 

Optimizely Data Platform 

A centralized hub to harmonize data across your digital experience tools, providing one-click integrations, AI-assisted guidance for campaigns, and unified customer profiles. 

 

So, why the change?  

 It boils down to three guiding principles:  

  1. Uniformity: Create a naming convention that can be applied across the board, for all products, to drive consistency 
  2. Simplicity: Use terms that are both practical and concise, ensuring the names are something that everyone can understand and identify with  
  3. Completeness: Develop a framework that showcases the full and complimentary nature of all the products and solutions within the Optimizely suite 

 As the Optimizely portfolio comes together as a complete, unified platform, it’s important that our names reflect this, as well as support our 3 key solutions (i.e. orchestrate amazing content experiences, monetize every digital experience, and experiment across all touchpoints).  

Other questions? We’ve got you covered. 

Q: Why have you made these product name changes? 

    • We wanted to simplify how we talk about our portfolio. The renaming applies a naming convention that is both practical and concise.  

 

Q: Do the new product name changes affect the products I own? 

    • No, there is no impact to product functionality or capabilities.  

 

Q: Do the new product name changes affect who is my Customer Success Manager or Account Manager?  

    • No, there are no changes to your Customer Success Manager or Account Manager. 

 

Q: Do the new product name changes affect the ownership of the company?  

    • No, ownership of the company has not changed. We have only made changes to the Product Names. 

 

Q: Have any contact details changed that I need to be aware of?  

    • Only contact details for former Welcome customers has changed. These are the new contact details you should be aware of: Optimizely, Inc.| 119 5th Ave | 7th Floor | New York, NY 10003 USA. Phone: +1 603 594 0249 | www.optimizely.com 

 

Q: Where can I send any follow up questions I might have?  

    • If you have any questions about the Product Names, please contact your Customer Success Manager or Account Manager.  


Source link

Continue Reading

MARKETING

Email Marketing Trends 2023: Predictions by the Industry Stalwarts

Published

on

Email Marketing Trends 2023: Predictions by the Industry Stalwarts


Every year, we see new trends entering the world of email marketing.

Source link

Continue Reading

Trending