Sign up free Log In

The Causal Analysis: A Great Way to Tell the Financial Story

featured image

Entrepreneurs are often expected to present the current financial status of their enterprise to investors, bankers and employees.  In board meetings, the entrepreneur needs to explain their current plan but, more importantly, to identify and explain why actual results differ from the original plan and to revise the annual plan going forward. Often, the entrepreneur and the financial team will present a detailed set of financial statements with way too much detail. This causes the discussion to focus on minutiae and not on the strategy and the big picture.

One “tried and tested” method used in business to present financial information is through the use of a ‘causal analysis’ summary.  A causal analysis presents the causes of changes in financial results at a summary level from plans or prior periods.  It provides enough detail to highlight the issues but presents the result in a way that can keep focus on the strategic issues.  This article shows how to develop and present a causal analysis, using an example from a larger company, with the objective of highlighting the benefits of presenting financial results in a way to not lose focus on the strategic issues at hand.

Identifying the drivers of change

A “causal analysis” is a process of presenting variance analysis by identifying, at a summary level, the key items driving change in business operations.  In many circumstances, companies present the standard columns of financial numbers comparing year-to-year, plan vs. actual, or plan vs. plan.  In a related column and/or on separate slides will be the specific variance (i.e., one period change from another) in terms of dollars or %.  Finally, verbal or written highlights are presented to explain the material changes in categories.

A “causal” takes a different approach. It attempts to quantify (within a tabular format) the major drivers of variance attempting to separate out unusual or extraordinary events within operations and their related financial impact.  By doing so, management can easily isolate extraneous events and show a clearer picture of ongoing operations.  The following example will illustrate the concept.

Babcock Laboratories (fictional) is a major pharmaceutical company that has experienced significant growth in the past 10 years, from just over $1 billion in 2001 sales to $5.3 billion in 2017.  Corresponding with the growth in sales has been strong increase in operating earnings, from $150 million in 2001 to $1.2 billion in 2017, respectively.  However, in 2018, Babcock experienced a downturn in both sales and operating earnings resulting from several external factors.  Table 1 provides the standard breakdown of changes in Profit/Loss between 2018 and 2017. {Note:  Column C shows Favorable/(Unfavorable) variances.  An increase (decrease) in Sales and Profits is Favorable (Unfavorable) while an increase (decrease) to expenses is Unfavorable (Favorable)}.

Table 1:  Babcock Operating Results – 2018 and 2017 (In $Billions)

 

 

(A)

 

 

 

2018

(B)

 

 

 

2017

(B) – (A) = (C)

 

$ Change

Fav/(Unfav)

( C ) / (A)

 

 

% Change vs. 2017 Var

Sales

$5.0

$5.3

(0.3)

(5.7%)

Cost of Goods Sold

1.8

1.6

(0.2)

(12.5%)

Gross Profit

3.2

3.7

(0.5)

(13.5%)

 

 

 

 

 

Marketing Expenses

1.0

0.9

(0.1)

(11.1%)

Research and Development Expenses

0.5

0.4

(0.1)

(25.0%)

General and Administrative Expenses

1.1

1.2

0.1

+8.3%

Total Operating Expenses

2.6

2.5

(0.1)

(4.0%)

 

 

 

 

 

Earnings

$0.6

$1.2

($0.6)

(50.0%)

 

Initial analysis of the table suggests a decline of almost 6% in sales and 1/3 in operating earnings.  Management, in anticipation of questions from the investor community, suggested the deteriorating condition was primarily due to:

  • Babcock’s major antibiotic came off patent in June 2018 causing a sales decline of $200 million.  Babcock didn’t lose any share but as a result had to match generic competition by reducing prices by 50%.  Babcock management believed that the sales decline from price reductions “fell through” to the bottom line, causing a corresponding $200 million decrease in operating earnings (i.e., no impact on Cost of Goods or Operating Expenses). 
  • Continued (illegal?) importation of product from Canada was estimated to have a negative impact on sales to the tune of $400 million in 2018.  Volumes appeared steady as the drugs imported were still Babcock, but management estimated that the loss in pricing power was the total cause in the sales decline.

Prior to adapting the causal analysis format, Babcock management added separate tables and narration to account for the aforementioned factors.  Instead, the causal will be able to identify each factor, the related impact on sales and earnings, and provide an estimate of ongoing operations without the impact of the extraneous items. 

Preparing the Causal

Column 1 in Table 2 below follows the format of a summarized Income Statement with each row representing one of the major profit/loss categories.  Columns 2 and 7 represent changes in revenues and expenses for both 2001 and 2002, respectively.  The columns in the middle of the table (3 – 7), attempt to explain the major causes for the variance between the two years.  The causal example for Babcock Labs summarizes management’s representation of the two major events discussed earlier. 

Table 2:  Babcock Laboratories – Causal Analysis for Variance between 2017 and 2018 (in $Billions)

 

(1)

(2)

 

2017

(3)

Impact of Off-Patent

(4)

Canada

Import Effect

(5)

Ongoing

Operations

(6)

Total Variance

(7)

 

2018

Revenues

$5.3

(0.2)

(0.4)

0.3

(0.3)

$5.0

Cost of Goods Sold

1.6

--

--

(0.2)

(0.2)

1.8

Gross Profit

3.7

(0.2)

(0.4)

0.1

(0.5)

3.2

 

 

 

 

 

 

 

Marketing Expenses

0.9

--

--

(0.1)

(0.1)

1.0

R&D Expenses

0.4

--

--

(0.1)

(0.1)

0.5

S, G& A Expenses

1.2

--

--

0.1

0.1

1.1

Total Operating Expenses

2.5

--

--

(0.1)

(0.1)

2.6

 

 

 

 

 

 

 

Operating Earnings

$1.2

(0.2)

(0.4)

(0.0)

($0.6)

$0.6

After taking out the impact on operations of the off-patent drug and the impact of drugs imported from Canada, the results presented in column 5, “Ongoing Operations” suggest a less “bad” scenario as revenues increased combined with a variety of favorable and unfavorable variances.  Column 6 is the summary of the variances (columns 3+4+5) that correspond with the total variance in Table 1 for years 2017 vs. 2018.

Benefits of a Causal Analysis

Using a causal analysis provides management with a tool to present a summary financial analysis that isolates the impact of “special” items from that of ongoing operations.  It simplifies information for external users such as investors and analysts.  More importantly, the causal isolates the ongoing operations that are more directly influenced by managers and employees. 

In the simplified example above, only two issues were separated.  In reality, it’s not unusual to separate five or more items to highlight their affect on the financial results.  Some of them might include:

  • Major events such as earthquakes or strikes in other countries.
  • New product launches where management and investors may want to see the impact of new sales, any cannibalization of other products, incremental marketing or other expenses.
  • Exchange rate fluctuations if international sales exist.
  • Operating results from “high” inflation countries.
  • The change in results caused by major price increases.
  • Major restructuring savings and expenses.

Finally, it should be noted that causal analysis can be used in a variety of situations:  Actual vs. Actual; Plan vs. Actual; Plan vs. Revised Plan; Plan vs. Plan in later years; Department or Company level Actual/Budget; etc..  In its simplest form, a causal analysis can be used in any situation where two numbers are being compared to one another and one is attempting to explain the difference in the numbers. 

While the benefits are apparent, be aware that the causal analysis possesses the same limitations of any financial reporting tool.  First, if the numbers are not accurate, neither will the causal.  Second, judgment is used by management to select what factors should be isolated.  Those events that are separated from ongoing operations may in fact be a part of operations and should not be kept separate.  Upper management and external users must continue to ask penetrating questions to identify such possibilities.  Finally, management must still understand the numbers when presenting the information. They should be able to easily see the impact under differing scenarios where items are separated from (or included in) ongoing operations.

Conclusion

In summary, the causal analysis is a simple and effective tool used to identify in greater detail the changes in major profit/loss categories.  Causal analysis reports can serve as a way to communicate the changes without a significant amount of narrative attached to the standard variance presentation.  Causals are great for presenting to investors in a pitch deck, to existing investors or board members during periodic meetings where the financial results are discussed, and to employees of any enterprise outlining the performance of their own company without getting bogged down into meaningless details.

 


Phil Greenwood
Phil Greenwood
Senior Lecturer - Entrepreneurship and Strategy / Management Human Resources / University of Wisconsin - Madison
View Profile

Publication Endorsement Editors


Cite this Article

DOI: 10.32617/452-5eb5548a30490
Greenwood, P. (2020, May 8). The causal analysis: a great way to tell the financial story. Entrepreneur & Innovation Exchange. Retrieved April 20, 2024, from https://eiexchange.com/content/the-causal-analysis-a-great-way-to-tell-the-financial-story
Greenwood, Phil. "The Causal Analysis: A Great Way to Tell the Financial Story" Entrepreneur & Innovation Exchange. 8 May. 2020. Web 20 Apr. 2024 <https://eiexchange.com/content/the-causal-analysis-a-great-way-to-tell-the-financial-story>.