BRIANWOOLF.COM
RETAIL STRATEGY CENTER INC.
 
 

Marketing Numbers 101

Two useful numbers for marketers and how to calculate them...

By Brian Woolf
February 1, 2015

The primary purpose of marketing is to identify and meet customers' needs. The outcome is, ideally, an increase in sales and profits. Marketing dreams and financial reality need, therefore, to communicate. A smart marketer is able to converse with the CEO and CFO in their language, numbers. As growth is seldom far from their minds, here are two growth measurements that may help. They are worthy additions to your Marketer's Toolbox.

Rule of 72
Two common growth questions are:


In the time others take to open a calculator, you can use the Rule of 72 to have the (approximate) answer to either question. Here's how:

1) When you have the growth rate and you want to know the number of years needed to double sales -
Divide 72 by the growth rate, eg, if you expect the annual growth to be 10% per year, the answer is (approximately) 7.2 years. [Calculation: 72 / 10 = 7.2 years]

2) When you have the number of years and you want to know the growth rate needed to double sales -
Divide 72 by the number of years, eg, if you want to know what annual % growth rate you'll need to double sales in 6 years, the answer is (approximately) 12% [Calculation: 72 / 6 = 12%]

Note: see Appendix to see annual calculations*.

Average (Annual) Compound Growth Rate (acgr)
Let's assume your company has just bought another and you have been given responsibility for one of its divisions. Your CEO wants to know its most recent 4-year trajectory (ie, its average annual compound growth rate of sales) to provide a base to improve on in the next few years.

Calculating the past 4 years acgr is done with a simple formula that you enter into one cell of an Excel spreadsheet. First, gather a few pieces of data:


The formula is:
=(((Latest Sales /Base Sales) ^ (1/ # Years)) -1)

Inserting the five numbers you gathered, the formula would be:
=(((144,000/100,000)^(1/4))-1)

Once entered, the acgr would immediately appear as 9.5%.

What this means is that, on average, sales grew 9.5% per year between the base year of 2010, and 2014, four years later. It does not mean than sales grew 9.5% every year; one year may have grown 16%, another 3%. It means that the average annual growth rate from the base year to the latest year was 9.5%. [Note: when selecting your formula cell, it helps to express results as percentages (%).]

The equation looks formidable, but actually it's simple to set up and use. Test the above calculation yourself. You'll find it useful. For example, you can take any 5- or 10-year period and calculate, say, the acgr of your stores, sales, profits, and share price. The first three numbers usually explains the fourth.

Remember, one hard number pricks many a balloon of opinion.

* Appendix. Annual Numbers Illustrating the Rule of 72 example:

Copyright © 2015 Brian Woolf

About the author...

The techniques and metrics Brian Woolf has developed have become guiding principles for those operating some of the world's most successful programs. He is the President of the Retail Strategy Center, and has consulted, and spoken at conferences, in the US, Europe, Japan, and Australasia.

Prior to his total commitment to loyalty marketing, his corporate roles included Deputy Managing Director of Progressive Enterprises, a major New Zealand retailer; and Chief Financial Officer of Food Lion, a leading US food retailer. He has an M.Com. (Economics) from the University of Auckland, New Zealand, and an MBA from the Harvard Business School.

 
Copyright © 2017 Brian Woolf