This is the last article in our four-part series on how to measure profitability.
Parts one, two, and three can be found here:
How to Measure Profitability, Part 1 - An explanation of profitability.
How to Measure Profitability, Part 2 - defining profitability ratios
(coming soon) How to Measure Profitability, Part 3 - comparing the profitability of two similar companies.
Our overzealous financial analysis team 
decided to analyze Borders’ profitability after reviewing Borders’ liquidity levels while writing our How to Measure Liquidity article series. Here is the results!
We didn’t intend to hassle Borders. Our long-winded analysis, negative results, and gloomy outlook painted a perfect picture of a company pushed by the competition to the point they could not hold on any longer.
We reviewed Borders’ profitability just as we did in our Measure Profitability series, looking at a standard set of financial ratios selected for their ability to provide insight into company profitability. We tried to go back a few years (2006-2009) to give a longer perspective of Borders’ performance, plus detailing each 2010 quarter for a more detailed view of how things developed. We go through each ratio below, showing our ratio results in a table, accompanying graph, then giving our interpretation.
Let’s begin.
We started by first looking at Borders’ financial statements, pulling the following values out as we will be using these for the various ratios:
| Border Group, Inc2006-2010 | 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|---|
| Net Sales | 3532.3 | 3555.1 | 3133.6 | 2679.9 | 542.4 | 526.1 | 1517.0 | 2252.8 |
| Cost of Goods Sold | 2615.7 | 2668.3 | 2414.8 | 2115.7 | 439.2 | 428.8 | 1255.4 | 1900.9 |
| Gross Profit | 953.7 | 929.1 | 750.7 | 595.3 | 108.0 | 101.6 | 275.3 | 374.0 |
| Operating Profit (Loss) | 5.2 | 4.1 | (158.8) | (99.0) | (33.5) | (37.7) | (143.7) | (296.4) |
| Net Earnings (Loss) | (151.3) | (157.4) | (186.7) | (109.4) | (64.1) | (46.7) | (185.2) | (299.0) |
| Income Tax | 2.8 | (19.1) | 28.0 | (31.3) | 0.7 | 0.4 | 1.6 | 1.3 |
| Total Stockholders Equity | 642.0 | 476.9 | 262.6 | 158.3 | 94.1 | 33.4 | (40.8) | (153.7) |
| Total Assets | 2613.4 | 2302.7 | 1609.0 | 1425.2 | 1370.5 | 1270.5 | 1356.6 | 964.7 |
| Cash Flow from Operations | (13.0) | (18.5) | (184.7) | (110.2) | (64.5) | (116.6) | (191.0) | (300.3) |
As you can see above, there is plenty of red. Operating profit, net earnings, and cash flow were all negative and gross profits were steadily declining.
Gross Profit Margin
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| 0.27 | 0.26 | 0.24 | 0.22 | 0.20 | 0.19 | 0.18 | 0.17 |
The Gross Profit Margin ratio shows a steady decline in profitability, dropping by nearly half in the time span we measured. Borders was clearly having trouble generating profits from its retail bookstores sales. At least the gross profit margin is still positive, right? Unfortunately, the next chart uncovers the mess…
Operating Profit Margin
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| 0.00 | 0.00 | (0.05) | (0.04) | (0.06) | (0.07) | (0.09) | (0.13) |
In terms of the Operating Profit Margin ratio, Borders had zero operating profits early on, and swiftly plummeted into a steep operating loss. Looking back in the Consolidated Statements of Operations, we find Borders’ operating profit is crushed under the weight of their Sales, General, and Administration expenses. Borders’ efficiency in running their business was steadily declining and with a negative operating profit margin, they likely had to use their cash reserves to make up the difference.
Pretax Margin
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| (0.04) | (0.05) | (0.05) | (0.05) | (0.12) | (0.09) | (0.12) | (0.13) |
Borders was not profitable before paying their taxes, and they certainly were not profitable after taxes. The Pretax Margin ratio was negative during the entire period. The only positive result of negative profits is Borders’ taxes were much lower than if they had posted a positive operating profit margin.
Net Profit Margin
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| (0.04) | (0.04) | (0.06) | (0.04) | (0.12) | (0.09) | (0.12) | (0.13) |
Borders did not have many other expenses other than taxes, so their net earnings was relatively the same as their earnings from operations, resulting in the Net Profit Margin ratio results shown above following the pretax margin ratio very closely. After all bills and expenses have been paid, Borders is obviously not making any profits.
Cash Flow Margin
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| 0.00 | (0.01) | (0.06) | (0.04) | (0.12) | (0.22) | (0.13) | (0.13) |
As the Cash Flow Margin ratio measures how well a company is generating cash from its operations, it is clear Borders is not. Further, as the years passed, their losses continued to deepen, putting them in a more precarious financial position as time passed. Looking at the numbers we used to calculate the cash flow margin, we see that as their net sales decreased, their cash flow from operations also decreased, but at an accelerated rate. As Borders was experiencing less sales, they still had to pay for all the retail stores and the costs associated with their business, resulting in less cash available.
Cash Return on Assets
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| 0.00 | (0.01) | (0.11) | (0.08) | (0.05) | (0.09) | (0.14) | (0.31) |
We get a hint they have problems converting their daily operations into cash from the cash flow margin above, but the results of the Cash Return on Assets ratio show better evidence that Borders’ investments in their assets are not providing a return on their money. Looking back at the financial statements, we see their merchandise inventory and retail and warehouse property are significant but simply not providing a return.
Gross Profit to Net Sales
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| 0.26 | 0.25 | 0.23 | 0.21 | 0.19 | 0.18 | 0.17 | 0.16 |
The Gross Profit to Net Sales ratio also shows problems with Borders’ ability to create profit from sales. Steadily decreasing over Borders’ last four years, this ratio shows its inability to sell its products increasingly efficiently, which is what businesses need to accomplish to stay competitive.
Return on Equity (ROE)
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| (0.24) | (0.33) | (0.71) | (0.69) | (0.68) | (1.40) | 4.54 | 1.95 |
How well has Borders made use of its available stockholder’s equity? The Return on Equity ratio results show that investments into the company made with equity have not realized any profit, and have in fact been negative.
There is an unusual spike in the third quarter of 2010, where the return on equity goes sharply positive. However looking back at our original financial statement data, both net earnings and total stockholders equity are negative values. Since we are simply dividing one by the other, a negative number divided by another negative number is positive. This does not mean Borders’ return on equity instantly became positive. Several papers have been written on this special case when financial ratios fail to represent a firm’s performance. Research Economist Susanne Trimbath explains this problem:
“…Negative return on equity is meaningless as a measure of firm performance. Financial statements and analysts’ reports usually note the ratio resulting from negative equity as “not meaningful” and do not report a figure.”
“…although a negative return on equity is meaningless as an absolute measure of firm performance, one might consider that it could at least be used as a measure of relative firm performance. Unfortunately, this is not actually the case1…”
What do we do in this situation? Can we even make sense of the return on equity values? To start, Borders’ total stockholders equity is a negative value. Since their liabilities exceed their assets, Borders is essentially broke. At this point you would hope they could possibly dig themselves out with their earnings, but this too is negative. By late 2010, Borders owed more to creditors than they owned in assets and for each dollar they made from sales, they were losing more than one dollar, shown in the net profit margin ratio results we already calculated above. At this point, Borders is stuck. With no earnings and owing more than they own, the threat of a bankrupt Borders in 2010 was real.
Return on Total Assets (ROI)
| 2006 | 2007 | 2008 | 2009 | 2010 Q1 | 2010 Q2 | 2010 Q3 | 2010 |
|---|---|---|---|---|---|---|---|
| (0.06) | (0.07) | (0.12) | (0.08) | (0.05) | (0.04) | (0.14) | (0.31) |
The Return on Total Assets ratio shows Borders has not been able to utilize investments in their assets. The key cause of this plummeting ratio is the decline in net earnings while their asset levels remained high.
Final Summary
With dropping profitability, negative earnings, and owing more money to creditors than they have assets, it looks like bankruptcy and subsequent liquidation was inevitable for Borders. As we set out to analyze the profitability of Borders, this turned into a discovery of how unprofitable Borders had become in the years leading to its bankruptcy.
Stepping away from the numbers and researching the book sales industry as a whole, you will find a great shift in demands from consumers. With the rise of e-books, and books available on devices from competing book sellers (notably Amazon’s Kindle© and Barnes and Noble’s Nook©), competitors of Borders were able to sell books without having to keep the same level of assets a typical book seller needs. Less physical books mean less inventory, warehouses, staff to manage it all. This translates into reduced cost of goods sold, less administrative cost, and improved the overall efficiency of booksellers running their operations. Borders had achieved the ability for customers to purchase and download books digitally in 2010, but was likely too late to turn things around.
(coming soon) Back to How to Measure Profitability, Part 3
References
U.S. Securities and Exchange Commission (SEC) website, retrieved on 01/28/2012:
http://www.sec.gov/Archives/edgar/data/940510/000094051010000035/q310q2010bgp.htm
http://www.sec.gov/Archives/edgar/data/940510/000094051010000021/form10qq2july312010.htm
http://www.sec.gov/Archives/edgar/data/940510/000094051010000013/q1201010q.htm
http://www.sec.gov/Archives/edgar/data/940510/000114036111058756/0001140361-11-058756-index.htm
http://www.sec.gov/Archives/edgar/data/940510/000114036111024036/form10k.htm
http://www.sec.gov/Archives/edgar/data/940510/000095012310031298/k48798e10vk.htm
http://www.sec.gov/Archives/edgar/data/940510/000095015209003378/k47480e10vk.htm
http://www.sec.gov/Archives/edgar/data/940510/000095012408001864/k23630e10vk.htm
1. Trimbath, Susanne; “Lemmings to the Sea: The Inappropriate Use of Financial Ratios in Econometric Models”, page 3. http://www.milkeninstitute.org/pdf/lemmings_wp2001_01.pdf


























