Do you remember Blackberry, Metro-Goldwyn-Mayer (MGM), Toys ‘R’ Us, Atari, and Karmelkorn?
Some will recognize these names—companies that were once very famous and lasted for years.
What happened to them? Why did they stop? Why couldn’t they keep going?
If you want to avoid the same fate, this report is for you.
It analyzes financial performance, stock trends, and employee data across many companies to identify patterns of survival and closure.
By understanding the traits of both successful and failed companies, I provide actionable insights and strategies to help you avoid failure and thrive in a competitive market.
## 'data.frame': 733 obs. of 20 variables:
## $ Company_ID : int 1 1 1 1 1 1 1 1 1 1 ...
## $ Company_Name : chr "Rite Aid" "Rite Aid" "Rite Aid" "Rite Aid" ...
## $ Foundation_Year : int 1962 1962 1962 1962 1962 1962 1962 1962 1962 1962 ...
## $ Closing_Year : int 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 ...
## $ Dynamic_Duration : int 61 61 61 61 61 61 61 61 61 61 ...
## $ Industries : chr "Retail Stores" "Retail Stores" "Retail Stores" "Retail Stores" ...
## $ Status : chr "Defunct" "Defunct" "Defunct" "Defunct" ...
## $ Current_Status : chr "Re_Opened" "Re_Opened" "Re_Opened" "Re_Opened" ...
## $ Notes : chr "Bankruptcy protection 2023" "Bankruptcy protection 2023" "Bankruptcy protection 2023" "Bankruptcy protection 2023" ...
## $ Years : int 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 ...
## $ Employee_Number : int 47000 53000 50000 48000 51000 59000 87000 88000 89000 89000 ...
## $ Revenue : num 24092 24568 24043 21928 21640 ...
## $ Net_Income : num -750 -538 -91 -452 -422 ...
## $ Assets : num 7527 8529 9335 9452 7591 ...
## $ long_Term_Debt : num 2938 2748 3080 3097 3479 ...
## $ Total_Liabilities: num 8169 8430 8720 8778 6405 ...
## $ Holders_Equity : num -642 99 615 675 1187 ...
## $ Avg_Stock_Price : num 2.14 6.74 16.98 13.24 9.5 ...
## $ Avg_TTM_Net_EPS : num -20.2 -13.54 -1.98 -7.57 -9.52 ...
## $ Avg_PE_Ratio : num -0.11 -0.5 -8.58 -1.75 -1 ...
## Company_ID Company_Name Foundation_Year Closing_Year
## Min. : 1.00 Length:733 Min. :1858 Min. : 0.0
## 1st Qu.:17.00 Class :character 1st Qu.:1911 1st Qu.: 0.0
## Median :39.00 Mode :character Median :1962 Median : 0.0
## Mean :36.01 Mean :1950 Mean : 483.8
## 3rd Qu.:53.00 3rd Qu.:1984 3rd Qu.: 0.0
## Max. :69.00 Max. :2015 Max. :2024.0
## Dynamic_Duration Industries Status Current_Status
## Min. : 4.0 Length:733 Length:733 Length:733
## 1st Qu.: 39.0 Class :character Class :character Class :character
## Median : 61.0 Mode :character Mode :character Mode :character
## Mean : 72.4
## 3rd Qu.:112.0
## Max. :167.0
## Notes Years Employee_Number Revenue
## Length:733 Min. :1995 Min. : 0 Min. : 0
## Class :character 1st Qu.:2012 1st Qu.: 170 1st Qu.: 1320
## Mode :character Median :2017 Median : 24400 Median : 14953
## Mean :2016 Mean : 129964 Mean : 1868226
## 3rd Qu.:2021 3rd Qu.: 157900 3rd Qu.: 87470
## Max. :2025 Max. :2300000 Max. :302000000
## Net_Income Assets long_Term_Debt Total_Liabilities
## Min. : -23800 Min. : 0 Min. : 0 Min. : 0
## 1st Qu.: 0 1st Qu.: 2329 1st Qu.: 96 1st Qu.: 1371
## Median : 336 Median : 16402 Median : 3365 Median : 11610
## Mean : 254746 Mean : 3215790 Mean : 335885 Mean : 1059887
## 3rd Qu.: 4572 3rd Qu.: 136295 3rd Qu.: 19012 3rd Qu.: 103470
## Max. :54730018 Max. :515000000 Max. :44522000 Max. :122000000
## Holders_Equity Avg_Stock_Price Avg_TTM_Net_EPS Avg_PE_Ratio
## Min. : -552000 Min. : 0.00 Min. :-547.000 Min. :-239.33
## 1st Qu.: 411 1st Qu.: 0.00 1st Qu.: 0.000 1st Qu.: 0.00
## Median : 4657 Median : 15.51 Median : 0.450 Median : 6.70
## Mean : 2109194 Mean : 47.67 Mean : -0.251 Mean : 13.51
## 3rd Qu.: 33230 3rd Qu.: 46.12 3rd Qu.: 2.990 3rd Qu.: 14.96
## Max. :392000000 Max. :1007.67 Max. : 39.600 Max. : 758.00
Company_ID | Company_Name | Foundation_Year | Closing_Year | Dynamic_Duration | Industries | Status | Current_Status | Notes | Years | Employee_Number | Revenue | Net_Income | Assets | long_Term_Debt | Total_Liabilities | Holders_Equity | Avg_Stock_Price | Avg_TTM_Net_EPS | Avg_PE_Ratio |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Rite Aid | 1962 | 2023 | 61 | Retail Stores | Defunct | Re_Opened | Bankruptcy protection 2023 | 2023 | 47000 | 24092 | -750 | 7527 | 2938 | 8169 | -642 | 2.14 | -20.20 | -0.11 |
1 | Rite Aid | 1962 | 2023 | 61 | Retail Stores | Defunct | Re_Opened | Bankruptcy protection 2023 | 2022 | 53000 | 24568 | -538 | 8529 | 2748 | 8430 | 99 | 6.74 | -13.54 | -0.50 |
1 | Rite Aid | 1962 | 2023 | 61 | Retail Stores | Defunct | Re_Opened | Bankruptcy protection 2023 | 2021 | 50000 | 24043 | -91 | 9335 | 3080 | 8720 | 615 | 16.98 | -1.98 | -8.58 |
1 | Rite Aid | 1962 | 2023 | 61 | Retail Stores | Defunct | Re_Opened | Bankruptcy protection 2023 | 2020 | 48000 | 21928 | -452 | 9452 | 3097 | 8778 | 675 | 13.24 | -7.57 | -1.75 |
1 | Rite Aid | 1962 | 2023 | 61 | Retail Stores | Defunct | Re_Opened | Bankruptcy protection 2023 | 2019 | 51000 | 21640 | -422 | 7591 | 3479 | 6405 | 1187 | 9.50 | -9.52 | -1.00 |
1 | Rite Aid | 1962 | 2023 | 61 | Retail Stores | Defunct | Re_Opened | Bankruptcy protection 2023 | 2018 | 59000 | 21529 | 943 | 8989 | 3371 | 7388 | 1601 | 30.25 | 16.65 | 1.82 |
Insight:
This visualizations shows various distributions of companies by their
status—whether they are still operational or have closed.
The lifespan of companies shows a significant difference between those that survived and those that didn’t. Defunct companies tend to have shorter lifespans. Lifespan is an important measure of company health. Let’s compare the lifespans of active and defunct companies using the Status dataset.
Actionable Takeaway:
If your company is in the closure group, it is essential to analyze the
contributing factors and take immediate action to turn the trend
around.
Insight:
This boxplot compares the lifespans of companies based on their
status.
Actionable Takeaway:
A company’s ability to extend its lifespan depends on factors like
financial management, adaptability, and market positioning. If your
company is near the lower end of the lifespan spectrum, it is crucial to
reassess its strategies, focusing on long-term sustainability rather
than short-term gains.
Employee count is another factor that can help determine company success. A significant drop in employee numbers is often seen in companies that are in decline. Companies that are growing or stable tend to have a steady increase in their employee base. Let’s look at how the number of employees varies based on company status.
## NULL
## int [1:733] 47000 53000 50000 48000 51000 59000 87000 88000 89000 89000 ...
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0 170 24400 129964 157900 2300000
## [1] 0
Revenue is a key indicator of a company’s financial performance. Companies that have closed often show erratic or decreasing revenue trends, while active companies tend to have more stable or growing revenues. Let’s explore how revenue varies across companies based on their status (active vs. defunct).
Insight:
This line chart and histogram visualize the revenue trends of companies
over time, categorized by their status. Healthy companies show
consistent or growing revenue over the years, while companies that close
often experience sharp declines or erratic fluctuations in revenue.
Actionable Takeaway:
If your revenue is showing a decline or significant fluctuation, it is a
red flag. To avoid closure, consider analyzing the reasons behind these
revenue drops—such as market shifts, cost inefficiencies, or
competition—and make adjustments like cost-cutting, diversifying product
lines, or improving marketing efforts.
##
## Call:
## lm(formula = Revenue ~ Years, data = companiesSurvival)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4454418 -3239525 -1924449 -517776 298452750
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -607883933 261749510 -2.322 0.0205 *
## Years 302389 129807 2.330 0.0201 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 21250000 on 731 degrees of freedom
## Multiple R-squared: 0.007369, Adjusted R-squared: 0.006011
## F-statistic: 5.427 on 1 and 731 DF, p-value: 0.0201
## Years predicted_revenue
## 1 2025 4454418
## 2 2026 4756807
## 3 2027 5059197
## 4 2028 5361586
Let’s build a predictive model using the data to identify which companies are more likely to continue, and which ones might be closed.
## Confusion Matrix and Statistics
##
## Reference
## Prediction Active Defunct
## Active 117 0
## Defunct 0 15
##
## Accuracy : 1
## 95% CI : (0.9724, 1)
## No Information Rate : 0.8864
## P-Value [Acc > NIR] : 1.216e-07
##
## Kappa : 1
##
## Mcnemar's Test P-Value : NA
##
## Sensitivity : 1.0000
## Specificity : 1.0000
## Pos Pred Value : 1.0000
## Neg Pred Value : 1.0000
## Prevalence : 0.8864
## Detection Rate : 0.8864
## Detection Prevalence : 0.8864
## Balanced Accuracy : 1.0000
##
## 'Positive' Class : Active
##
If your company has been flagged by the prediction model as “Defunct” or at risk, this is not just a data point—it’s a wake-up call.
Your financial indicators, operational trends, and employee patterns mirror those of companies that have already failed.
Unless immediate and strategic actions are taken, your company may face irreversible closure.
This report has highlighted the exact warning signs—declining revenue, shrinking employee numbers, rising liabilities, and reduced investor confidence.
You are not out of time yet—but you’re close:
Take this prediction seriously:
Reassess your business model.
Cut non-essential costs.
Innovate your offerings.
Rebuild trust with investors and employees.
The next move you make could decide your company’s fate. Delay is the most dangerous option.
Stock Trends: Companies with increasing stock prices tend to have better financial performance and longevity. On the other hand, companies with fluctuating or decreasing stock prices may face challenges. We will analyze the stock data to visualize how different companies’ stock prices have evolved over time.
Insight:
This scatter plot shows the relationship between the Price-to-Earnings
(PE) ratio and the average stock price. Companies that are financially
healthy often have a higher PE ratio, indicating that investors have
more confidence in their future earnings potential.
Actionable Takeaway:
A low PE ratio can indicate that your company is undervalued or
struggling. To boost the PE ratio, consider improving profitability by
increasing revenue, reducing costs, or communicating your company’s
growth potential more effectively to investors.
Important Note:
As the chart shows, the overall average revenue among companies is 5
million, reflecting the good performance of the companies that survived
compared to those that closed.
Apple successfully navigated financial and market crises by embracing new technologies such as touchscreen interfaces and app ecosystems. These innovations drastically improved product appeal, operational efficiency, and customer engagement.
In contrast, BlackBerry failed to adapt to changing consumer demands and technological trends, holding on to outdated features like physical keyboards and enterprise-focused software. As a result, Apple thrived, while BlackBerry’s market share collapsed.
Insight: Technology and customer preferences evolve quickly; companies must stay agile to meet these changes.
Some industries are more vulnerable to closures due to rapid technological changes, shifts in consumer behavior, and economic disruptions. These industries often experience a higher number of business failures due to their inability to adapt to external changes.
Retail Industry:
Technology Industry:
Hospitality and Travel:
Manufacturing Industry:
Some industries show higher rates of company closures due to inherent challenges such as market saturation, regulatory pressure, and limited differentiation among companies. For example:
Construction and Real Estate:
Restaurants and Food Services:
Transportation and Logistics:
In conclusion, analyzing financial performance, customer needs, technological trends, and operational efficiency provides valuable insights into a company’s potential for survival or closure. Proactive monitoring of these factors, combined with a willingness to adapt and innovate, can significantly increase a company’s chances of thriving in a competitive and ever-changing marketplace. By making strategic decisions based on these insights, business owners can avoid closure and secure long-term success.