Data Analysis

First, we load the required libraries and files.

source("setup.qmd")          

Now, let’s retrieve the necessary objects for data exploration:

# Load company_data
company_data <- readRDS("company_data.RDS")
cik <- readRDS("cik.RDS")

# Split the lists in company_data
company_Metadata <- company_data$company_Metadata
company_Facts <- company_data$company_Facts
company_Concept <- company_data$company_Concept

Rebuilding the financial reports

The use of specific labels to indicate financial report items is regulated by accounting standards set forth by authoritative bodies. In the United States, the Financial Accounting Standards Board (FASB) establishes generally accepted accounting principles (GAAP), which provide guidelines for the preparation of financial statements, including the standardization of labels and concepts.

Different companies may use different reporting styles to indicate Facts in different ways. The use of different labels however affect our ability to efficiently retrieve the appropriate financial data.

The objective here is to generate standardized financial reports of Balance sheet, Income Statement, Cash Flow so that we can use the same label to perform specific calculation across all companies.

Let’s create now a dataframe including the data retrieved from company_Facts$facts$`us-gaap`.

Extracting financial data

The first step is un-nest the dataset, in particular the financial data, in company_Facts, nested in various sub-lists.

The following code can be used to un-nest the list within company_Facts and create a dataframe easy to visualize and useful for our purpose¹.

df_Facts <- Fundamentals_to_Dataframe(company_data)

# Select the columns to print out and present the output with wrapped text and formatted numbers
df_Facts %>% select(-c(description,accn)) %>% 
  head() %>% as.data.frame() %>% 
  kable("html") %>% 
  kable_styling(full_width = FALSE)

end	val	fy	fp	form	filed	frame	label	us_gaap_reference	start	cik	entityName	sic	sicDescription	tickers
2010-12-31	35.886	2011	Q2	10-Q	2011-08-01	NA	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2010-12-31	35.886	2011	Q3	10-Q	2011-11-09	NA	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2010-12-31	35.886	2011	FY	10-K	2012-03-15	CY2010Q4I	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2011-06-30	51.537	2011	Q2	10-Q	2011-08-01	CY2011Q2I	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2011-09-30	85.352	2011	Q3	10-Q	2011-11-09	CY2011Q3I	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2011-12-31	26.430	2011	FY	10-K	2012-03-15	NA	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK

Note that df_Facts$val is expressed in million.

The data in this dataframe is organized to facilitate analysis and comparison of financial information over different periods. Each row corresponds to a specific financial Concept (e.g. Accounts Payable) reported by the company, and the columns provide details about the reporting period, values, and other relevant attributes.

To recreate a financial statement from the data in df_Facts of JAKKS Pacific Inc., we need to extract the values in df_Fact$val of the various Concepts and corresponding date in df_Fact$end.

df_Fact has a long list of Concepts for multiple fiscal periods. The following code shows the large number of Concepts included in df_Fact, related to all financial reports.

# Print the size in human-readable format
cat("df_Facts includes:", format(nrow(df_Facts), units = "auto"), "records \n")

df_Facts includes: 16046 records 

From an extract of the df_Facts above, we would see repeated Concepts. Each of them is associated with a different fiscal period. The code next provides number of unique Concepts used historically JAKKS Pacific Inc. in their financial reports.

# Print the number of unique records of df_Facts
df_Facts_distinct <- df_Facts %>% select(label,description) %>% distinct()

cat("df_Facts includes:", format(nrow(df_Facts_distinct), units = "auto"), "distinct Concepts \n")

df_Facts includes: 442 distinct Concepts 

By arranging these records by date indicated in df_Fact$end we can see the the full financial reports for each period in a data frame format.

# Group the df_Fact by date in df_Fact$end
df_Facts <- df_Facts %>% arrange(desc(end))

# Show first rows of df_Facts_BS 
df_Facts %>%  select(-c(description,accn)) %>% 
  head() %>% as.data.frame() %>% 
  kable( "html") %>% 
  kable_styling(full_width = FALSE) %>% 
  column_spec(1,width = "250px")

end	val	fy	fp	form	filed	frame	label	us_gaap_reference	start	cik	entityName	sic	sicDescription	tickers
2024-03-31	31.683	2024	Q1	10-Q	2024-05-08	CY2024Q1I	Accounts Payable, Current	AccountsPayableCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2024-03-31	79.875	2024	Q1	10-Q	2024-05-08	CY2024Q1I	Accounts Receivable, after Allowance for Credit Loss, Current	AccountsReceivableNetCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2024-03-31	3.295	2024	Q1	10-Q	2024-05-08	CY2024Q1I	Accrued Income Taxes, Noncurrent	AccruedIncomeTaxesNoncurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2024-03-31	37.201	2024	Q1	10-Q	2024-05-08	CY2024Q1I	Accrued Liabilities, Current	AccruedLiabilitiesCurrent	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2024-03-31	122.694	2024	Q1	10-Q	2024-05-08	CY2024Q1I	Accumulated Depreciation, Depletion and Amortization, Property, Plant, and Equipment	AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2024-03-31	-16.192	2024	Q1	10-Q	2024-05-08	CY2024Q1I	Accumulated Other Comprehensive Income (Loss), Net of Tax	AccumulatedOtherComprehensiveIncomeLossNetOfTax	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK

The next step is to filter the relevant Concepts associated with each key financial statement: Balance Sheet (BS), Income Statement (IS) and Cash Flow (CF).

---

Note

As mentioned in the previous chapter, the df_Facts dataframe contains financial data along with corresponding reporting information, such as df_Facts$end, df_Facts$fy, df_Facts$fp, and df_Facts$form. However, there are instances where a filing (e.g., 10-K) for a specific fiscal period (fy and fp) includes a comparison with previous fiscal periods. In these cases, the financial data may actually refer to a different period, as indicated by df_Facts$end, rather than the period specified by fy and fp.

To handle this scenario, we construct a dataframe of financial data based on the end date (df_Facts$end) of the reporting period and remove the remaining attributes such as fy, fp, etc. This ensures that we focus on the actual reporting period for the financial data.

---

Balance Sheet

The following code will generate a standardized Balance Sheet (df_std_BS) based on a matching table in Excel (standardized_BS.xlsx). The standardized Balance Sheet includes Concepts that may not be present in the filings (e.g., 10-K) of all companies. If financial values (Facts) are missing, they will be estimated.

# Retrieve balance sheet of JAKKS Pacific Inc. in standardized format
df_std_BS <- BS_std(df_Facts)

# Format numeric columns to 2 decimal places
df_std_BS <- df_std_BS %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))


# Print the standardized balancesheet
df_std_BS %>% head() %>% as.data.frame() %>%
  head() %>% as.data.frame() %>%
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1,width = "250px")

end	Cash & Cash Equivalent	Marketable Securities Current	Total Accounts Receivable	Total Inventory	Prepaid Expenses	Other Current Assets	Total Current Assets	Marketable Securities Non Current	Property Plant and Equipment	Intangible Assets (excl. goodwill)	Goodwill	Other Non Current Assets	Total Non Current Assets	Total Assets	Accounts Payable	Tax Payable	Current Debts	Operating Lease Liability Current	Other Current Liabilities	Total Current Liabilities	Non Current Debts	Operating Lease Liability Non Current	Other Non Current Liabilities	Total Non Current Liabilities	Total Liabilities	Preferred Stock	Retained Earnings or Accumulated Deficit	Accumulated other comprehensive income (loss)	Minority interest	Total Stockholders Equity	Total Liabilities & Stockholders Equity	cik	entityName	sic	sicDescription	tickers
2024-03-31	35.29	NA	79.88	46.34	3.84	1.46	180.79	NA	122.15	NA	35.00	2.06	143.54	324.33	31.68	0.00	NA	8.24	73.75	113.67	NA	15.96	6.48	22.44	136.11	NA	-88.12	NA	0.50	188.23	324.33	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-12-31	72.35	NA	123.80	52.65	1.72	0.24	255.37	NA	120.40	NA	35.08	2.16	143.58	398.95	42.18	3.79	NA	7.38	95.89	149.23	NA	16.67	2.70	53.60	202.84	NA	-73.61	NA	0.71	190.12	398.95	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-09-30	96.25	NA	206.75	68.83	1.93	0.19	378.75	NA	119.14	NA	35.08	2.22	135.53	514.28	94.41	17.42	NA	6.42	137.10	255.34	NA	19.28	35.33	54.61	309.96	NA	-62.74	NA	0.71	198.72	514.28	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-06-30	32.23	NA	132.48	65.06	4.43	0.44	241.20	NA	117.47	NA	35.08	2.33	127.74	368.94	57.77	5.81	NA	9.23	102.91	175.71	NA	6.22	30.76	36.98	212.70	NA	-110.88	NA	0.72	151.01	368.94	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-03-31	38.30	NA	85.17	63.99	4.48	0.12	200.31	NA	114.10	NA	35.08	2.39	129.08	329.39	27.71	6.24	NA	10.01	78.57	122.53	NA	8.10	51.68	59.78	182.31	NA	-117.33	NA	1.00	142.22	329.39	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2022-12-31	85.49	NA	102.77	80.62	0.99	0.12	275.21	NA	113.71	NA	35.08	2.47	130.13	405.34	33.69	8.16	NA	10.75	125.22	177.82	NA	9.86	66.47	76.33	254.15	NA	-112.02	NA	1.00	146.70	405.34	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK

Income Statement

The following code will create a standardized Income Statement (df_std_IS) based on a matching table in Excel (standardized_IS.xlsx).

Here few relevant remarks regarding the standardized Income Statement:

• The financial data are presented on a quarterly basis only.

• In cases where quarterly not all Facts are available, these are estimated as the difference between the yearly value and the existing quarterly values of that year, divided equally by the number of quarters that are missing.

# Retrieve Income Statement of JAKKS Pacific Inc. in standardized format
df_std_IS <- IS_std(df_Facts)

# Format numeric columns to 2 decimal places
df_std_IS <- df_std_IS %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized income statement
df_std_IS %>% head() %>% as.data.frame() %>%
  head() %>% as.data.frame() %>%
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1,width = "250px")

end	Revenue	Cost of Revenue	Gross Profit	Research and development	Sales general and administrative costs	Other Non Operating Income (Loss) Net	Operating Income	Interest Income	Interest Expense	Other income (expense) Net	Income Before Income Tax	Provision for (benefit) Income Tax	Net Income (loss) (continous operations)	cik	entityName	sic	sicDescription	tickers
2024-03-31	90.08	69.02	21.05	NA	42.38	NA	-21.32	0.38	0.14	-0.89	-20.95	-6.73	-14.22	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-12-31	127.40	93.66	33.73	NA	49.07	NA	-15.34	0.76	0.71	-0.29	-16.52	-5.64	-10.87	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-09-30	309.74	202.76	106.98	NA	44.59	NA	62.40	0.38	1.44	0.08	60.50	12.38	48.12	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-06-30	166.93	115.74	51.20	NA	34.75	NA	16.45	0.09	1.30	7.40	7.66	1.48	6.18	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-03-31	107.48	76.05	31.44	NA	35.84	NA	-4.40	0.12	3.00	-0.82	-6.70	-1.38	-5.32	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2022-12-31	131.89	103.32	28.57	NA	44.26	NA	-15.70	0.06	2.29	-1.83	-16.22	-54.33	38.11	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK

Cash Flow

Similarly to the Income Statement, the following code will create a standardized Cash Flow Statement (df_std_CF) based on a matching table in Excel (standardized_CF.xlsx).

# Retrieve Cash Flow statement of JAKKS Pacific Inc. in standardized format
df_std_CF <- CF_std(df_Facts)

# Format numeric columns to 2 decimal places
df_std_CF <- df_std_CF %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized cash flow
df_std_CF %>% head() %>% as.data.frame() %>%
  head() %>% as.data.frame() %>%
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1,width = "250px")

end	(Operating Activities) Cash Flow Depreciation, Depletion, Ammortization	(Operating Activities) Change in Accounts Receivable	(Operating Activities) Change in Inventory	(Operating Activities) Change in Prepaid expenses and other assets	(Operating Activities) Change in Accounts Payable	(Operating Activities) Change in Accounts Taxes Payable	(Operating Activities) Change in Reserve for Sales Return and allowances	(Operating Activities) Deferred Income Tax	(Operating Activities) Stock-based Compensation	(Operating Activities) Cash Flow from Operating Activities	(Investing Activities) Purchase of Property, Plant and Equipment	(Investing Activities) Proceeds from Asset Sales	(Investing Activities) Purchase of Businesses	(Investing Activities) Purchase of Marketable Securities and Investment	(Investing Activities) Proceeds from sale or maturity of Marketable Securities and Investment	(Investing Activities) Proceeds from maturities of Marketable Securities and Investment	(Investing Activities) Cash Flow from Investing Activities	(Financing Activities) Proceeds from Issuance of Stock	(Financing Activities) Payment for Repurchase of Stock	(Financing Activities) Proceeds from Issuance of Debt	(Financing Activities) Payment of Debt	(Financing Activities) Cash for Dividends	(Financing Activities) Cash Flow from Financing Activities	Effect of Exchange Rate on Cash & Cash Equivalent	Change in Cash, Cash Equivalents	cik	entityName	sic	sicDescription	tickers
2024-03-31	1.60	-42.80	-6.31	11.20	-14.13	-3.73	NA	NA	2.58	NA	2.23	0.00	NA	NA	NA	NA	-3.63	NA	NA	NA	NA	NA	-20.00	-0.56	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-12-31	2.44	-83.21	-16.18	-0.37	-67.04	-13.39	NA	-2.58	2.06	NA	3.19	0.04	NA	NA	NA	NA	-3.23	NA	NA	NA	NA	NA	-0.58	1.18	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-09-30	2.73	75.07	3.77	-4.54	46.79	11.64	NA	NA	1.99	NA	0.80	0.00	NA	NA	NA	NA	-0.78	NA	NA	NA	NA	NA	-1.28	-0.79	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-06-30	2.49	47.12	1.07	-1.60	38.54	-0.40	NA	NA	1.86	NA	1.43	-0.02	NA	NA	NA	NA	-1.42	NA	NA	NA	NA	NA	-30.50	1.13	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2023-03-31	1.29	-17.22	-16.63	6.52	-6.78	-1.91	NA	NA	2.09	NA	3.49	0.02	NA	NA	NA	NA	-3.47	NA	NA	NA	NA	NA	-39.93	0.33	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK
2022-12-31	2.31	-102.21	-28.55	-4.76	-60.82	-3.06	NA	-57.86	1.65	NA	2.30	0.00	NA	NA	NA	NA	-2.30	NA	NA	NA	NA	NA	-0.76	1.11	NA	0001009829	JAKKS Pacific, Inc.	3944	Games, Toys & Children's Vehicles (No Dolls & Bicycles)	JAKK

Quarterly format

Finally, we can transpose the dataframes of the financial statements to improve the readability.

Balance Sheet

library(kableExtra)

# Transpose the Balanche Sheet statement in standardized format
df_std_BS_t <- transpose_df_standardized(df_std_BS, "standardized_BS")

# Format numeric columns to 2 decimal places
df_std_BS_t <- df_std_BS_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Balance Sheet in standardized format
df_std_BS_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item ($ in Million)	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2012-01-03	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31	2008-12-31
Cash & Cash Equivalent	35.29	72.35	96.25	32.23	38.30	85.49	76.60	62.28	39.23	45.33	26.70	38.34	84.06	92.69	79.82	52.69	44.03	66.29	75.89	37.05	47.41	58.20	57.14	62.99	46.78	64.98	48.81	67.60	68.03	86.06	48.16	96.63	118.91	102.53	81.21	110.27	105.10	71.53	88.62	162.71	113.36	117.07	51.52	69.72	165.36	189.32	140.76	221.65	254.56	257.26	257.26	232.24	246.85	274.47	278.35	218.59	248.75	254.84	169.52
Marketable Securities Current	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.22	0.21	NA	0.21	0.21	0.21	NA	0.21	NA	NA	NA	NA
Total Accounts Receivable	79.88	123.80	206.75	132.48	85.17	102.77	204.86	164.02	103.73	147.39	209.19	107.90	79.66	102.25	166.79	69.00	64.76	117.94	200.79	85.12	67.79	122.28	205.41	100.28	93.93	142.46	224.10	110.48	98.49	173.60	272.26	132.89	85.47	163.39	292.86	117.15	104.32	234.52	304.34	109.34	65.37	101.22	257.96	94.92	64.98	105.46	242.64	121.60	58.40	NA	103.64	239.68	109.33	NA	122.48	NA	NA	NA	NA
Total Inventory	46.34	52.65	68.83	65.06	63.99	80.62	109.17	123.67	85.31	83.95	89.80	60.58	36.65	38.64	54.58	57.68	48.23	54.26	65.30	53.52	44.69	53.88	64.45	62.16	54.00	58.43	80.14	81.22	67.47	75.44	75.06	71.47	53.47	60.54	81.40	91.89	79.47	78.83	88.78	65.15	42.20	46.78	59.12	56.67	52.05	59.69	73.23	60.80	45.00	NA	47.02	55.84	55.26	NA	43.23	NA	NA	NA	NA
Prepaid Expenses	3.84	1.72	1.93	4.43	4.48	0.99	5.01	7.33	6.78	4.15	4.18	5.33	5.05	2.49	NA	NA	NA	3.61	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Other Current Assets	1.46	0.24	0.19	0.44	0.12	0.12	0.12	0.12	0.12	0.19	0.25	0.00	0.12	0.00	22.12	28.45	18.80	0.00	18.50	28.52	28.03	15.78	26.49	24.68	20.81	16.80	18.26	30.12	33.58	18.28	51.20	51.54	56.92	55.91	58.05	63.44	57.53	52.51	57.65	62.64	61.20	55.63	54.72	58.64	62.98	51.37	84.73	91.80	93.13	0.00	89.36	67.50	76.86	0.00	67.90	0.00	0.00	0.00	0.00
Total Current Assets	180.79	255.37	378.75	241.20	200.31	275.21	401.75	364.49	245.67	287.56	338.06	239.31	223.85	250.83	323.32	207.82	175.82	260.38	360.47	204.21	187.91	250.14	353.49	250.11	215.52	282.67	371.32	289.42	267.57	353.38	446.68	352.52	314.78	382.37	513.52	382.96	346.64	437.59	539.60	400.06	282.34	320.93	423.54	280.16	345.60	406.06	541.56	496.06	451.30	0.00	497.48	595.47	488.50	0.00	512.16	0.00	0.00	0.00	0.00
Marketable Securities Non Current	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Property Plant and Equipment	122.15	120.40	119.14	117.47	114.10	113.71	113.14	110.03	105.43	103.10	102.10	99.99	96.26	95.37	95.81	94.34	103.49	103.33	109.77	108.25	104.42	108.32	115.82	113.91	116.92	115.38	111.70	109.89	104.67	103.13	99.90	95.48	89.01	86.31	95.43	19.32	13.11	87.36	10.55	14.28	10.84	11.10	12.09	14.96	16.24	15.83	15.13	18.79	17.55	NA	16.19	17.58	20.66	NA	16.95	NA	NA	NA	NA
Intangible Assets (excl. goodwill)	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	42.75	45.31	53.53	54.96	57.48	59.72	61.93	65.58	63.56	63.82	66.24	67.33	69.50	70.98	70.29	23.77	21.29	NA	26.15	16.36	20.23	NA	23.44	NA	NA	NA	NA
Goodwill	35.00	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.08	35.20	35.27	35.59	35.38	35.34	43.48	43.27	43.21	43.46	43.63	44.02	44.20	44.34	44.57	44.21	44.49	44.78	45.09	44.94	44.88	44.74	48.50	48.49	48.84	50.77	24.73	24.73	NA	24.02	6.99	6.99	NA	6.99	NA	NA	NA	NA
Other Non Current Assets	2.06	2.16	2.22	2.33	2.39	2.47	2.52	2.73	2.92	2.99	3.08	3.57	2.09	3.22	6.92	10.06	17.69	18.93	18.98	17.26	17.27	19.10	18.94	18.97	18.50	6.58	2.11	2.49	2.31	2.16	2.42	2.66	2.83	3.12	9.78	9.49	9.85	10.39	10.97	11.74	7.48	6.18	6.34	3.07	4.13	4.58	4.94	3.90	3.47	0.00	3.67	8.24	15.51	0.00	12.64	0.00	0.00	0.00	0.00
Total Non Current Assets	143.54	143.58	135.53	127.74	129.08	130.13	75.37	79.15	70.10	69.49	71.05	75.82	74.56	78.54	84.27	92.60	101.09	104.84	4.75	124.53	124.06	92.70	94.10	98.77	98.38	87.68	81.94	108.96	108.78	110.92	113.44	117.37	115.80	117.25	126.03	127.74	123.69	124.19	126.15	134.06	128.43	128.91	133.56	141.92	148.26	148.77	197.02	119.86	119.84	0.00	117.75	112.14	126.39	0.00	121.24	0.00	0.00	0.00	0.00
Total Assets	324.33	398.95	514.28	368.94	329.39	405.34	477.11	443.64	315.77	357.05	409.11	315.13	298.40	329.37	407.59	300.42	276.91	365.22	365.22	328.74	311.98	342.84	447.59	348.88	313.89	370.35	453.26	398.38	376.34	464.30	560.12	469.89	430.57	499.62	639.56	510.70	470.34	561.78	665.76	534.12	410.78	449.84	557.09	422.09	493.86	554.82	738.59	615.92	571.14	NA	615.23	707.61	614.89	NA	633.41	NA	NA	NA	NA
Accounts Payable	31.68	42.18	94.41	57.77	27.71	33.69	77.13	86.66	36.44	50.24	105.27	68.81	31.31	30.35	95.53	53.10	22.78	61.20	136.18	64.39	27.91	57.57	142.61	68.12	39.07	49.92	98.39	67.00	30.14	51.74	102.58	73.72	28.13	34.99	94.63	59.22	24.24	56.11	115.62	60.55	21.34	25.27	89.78	56.03	30.40	37.79	105.91	64.34	20.06	NA	26.43	85.35	51.54	NA	35.89	NA	NA	NA	NA
Tax Payable	0.00	3.79	17.42	5.81	6.24	8.16	14.08	2.33	1.21	1.00	0.64	0.70	0.17	0.48	1.62	0.50	0.35	2.49	NA	NA	NA	0.00	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Current Debts	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	1.77	1.91	1.91	6.90	1.89	NA	27.21	NA	NA	NA	21.20	21.20	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	38.91	38.63	NA	38.10	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Operating Lease Liability Current	8.24	7.38	6.42	9.23	10.01	10.75	10.52	10.24	11.01	10.48	10.41	10.48	10.11	9.93	9.66	9.63	9.59	9.45	9.37	9.18	8.82	0.00	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Other Current Liabilities	73.75	95.89	137.10	102.91	78.57	125.22	163.71	148.54	87.96	111.35	107.79	113.45	74.45	97.51	110.65	57.50	53.80	77.88	98.37	58.13	75.99	59.32	98.17	97.02	73.61	64.64	69.73	31.45	39.19	65.07	96.53	62.33	59.70	92.41	147.32	91.72	88.20	135.24	134.67	102.43	140.59	121.22	138.51	107.10	156.86	181.68	178.12	78.19	76.53	0.00	96.40	108.75	64.12	0.00	89.02	0.00	0.00	0.00	0.00
Total Current Liabilities	113.67	149.23	255.34	175.71	122.53	177.82	265.44	247.78	136.62	173.07	224.10	193.44	116.04	138.27	217.46	122.51	88.43	152.92	250.81	133.59	112.72	144.10	240.79	165.14	112.68	135.76	189.32	98.45	69.33	116.81	199.10	136.05	87.83	127.40	241.95	150.94	112.44	191.35	289.20	201.61	161.93	184.60	228.29	163.13	187.26	219.48	284.03	142.53	96.59	NA	122.83	194.11	115.66	NA	124.91	NA	NA	NA	NA
Non Current Debts	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	174.16	169.40	174.96	170.81	160.66	NA	139.79	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	215.00	215.00	215.00	215.00	215.00	215.00	NA	100.00	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Operating Lease Liability Non Current	15.96	16.67	19.28	6.22	8.10	9.86	12.55	15.41	7.40	8.04	9.95	12.28	14.47	16.88	18.39	20.74	23.12	25.63	27.86	29.83	29.63	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Other Non Current Liabilities	6.48	2.70	35.33	30.76	51.68	66.47	88.66	98.62	115.13	114.96	17.08	16.98	15.44	8.06	5.87	3.33	3.32	5.41	5.04	0.14	0.13	4.41	4.36	4.35	4.43	4.54	4.62	4.74	4.91	5.00	5.21	5.17	5.30	5.16	4.23	3.90	0.91	1.87	7.25	7.38	7.43	7.02	13.18	18.37	18.45	18.34	27.33	1.83	1.86	0.00	1.63	1.57	1.58	0.00	1.62	0.00	0.00	0.00	0.00
Total Non Current Liabilities	22.44	53.60	54.61	36.98	59.78	76.33	101.22	114.02	122.53	123.00	121.26	125.33	185.94	176.42	176.82	199.96	197.53	207.79	206.61	193.52	175.06	147.09	151.20	143.45	141.25	140.08	140.08	160.95	173.74	212.29	217.73	217.32	217.50	218.81	227.41	227.09	222.29	225.35	231.92	232.05	116.35	116.56	164.45	129.45	128.84	128.13	125.49	99.93	99.28	0.00	98.81	97.79	96.90	0.00	96.09	0.00	0.00	0.00	0.00
Total Liabilities	136.11	202.84	309.96	212.70	182.31	254.15	366.66	361.80	259.14	296.07	345.35	318.77	301.99	314.69	394.28	322.47	285.96	360.72	457.42	327.11	287.78	291.19	391.99	308.59	253.93	275.84	329.40	259.40	243.07	329.10	416.84	353.37	305.33	346.21	469.36	378.03	334.73	416.70	521.12	433.66	278.28	301.16	392.74	292.58	316.10	347.60	409.52	242.46	195.87	NA	221.64	291.90	212.56	NA	221.00	NA	NA	NA	NA
Preferred Stock	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Retained Earnings or Accumulated Deficit	-88.12	-73.61	-62.74	-110.88	-117.33	-112.02	-149.99	-180.68	-207.24	-203.43	-200.26	-236.59	-221.51	-197.42	-186.08	-218.46	-195.19	-183.15	-162.86	-179.30	-156.76	-127.60	-124.35	-140.04	-121.48	-85.23	-54.82	-37.21	-20.46	-2.15	5.44	-25.18	-20.81	-3.39	5.94	-39.91	-34.23	-26.64	-29.44	-73.51	-64.46	-48.15	-32.09	-68.68	-20.27	8.84	130.46	102.20	104.59	NA	123.17	145.78	113.55	NA	119.88	NA	NA	NA	NA
Accumulated other comprehensive income (loss)	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Minority interest	0.50	0.71	0.71	0.72	1.00	1.00	0.86	0.88	1.23	1.33	1.31	1.27	1.25	1.21	1.18	1.13	1.12	1.08	0.97	1.00	0.94	0.91	1.01	0.99	1.02	0.97	1.04	1.00	0.94	0.91	0.58	0.66	0.44	0.41	0.46	0.44	0.49	0.49	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Total Stockholders Equity	188.23	190.12	198.72	151.01	142.22	146.70	106.33	78.07	53.21	57.90	61.02	-6.04	-5.65	12.94	11.90	-23.15	-9.84	4.02	22.04	1.63	24.19	51.65	55.60	40.30	59.96	94.51	123.86	138.98	133.27	135.20	143.28	116.52	125.24	153.41	170.20	132.68	135.61	145.08	144.63	100.45	132.50	148.68	164.35	129.51	177.75	207.22	329.06	373.46	375.28	0.00	393.59	415.72	402.33	0.00	412.41	0.00	0.00	0.00	0.00
Total Liabilities & Stockholders Equity	324.33	398.95	514.28	368.94	329.39	405.34	477.11	443.64	315.77	357.05	409.11	315.13	298.40	329.37	407.59	300.42	276.91	365.22	479.64	328.74	311.98	342.84	447.59	348.88	313.89	370.35	453.26	398.38	376.34	464.30	560.12	469.89	430.57	499.62	639.56	510.70	470.34	561.78	665.76	534.12	410.78	449.84	557.09	422.09	493.86	554.82	738.59	615.92	571.14	NA	615.23	707.61	614.89	NA	633.41	NA	NA	NA	NA

Income Statement

# Transpose the Income Statement  in standardized format
df_std_IS_t <- transpose_df_standardized(df_std_IS, "standardized_IS")

# Format numeric columns to 2 decimal places
df_std_IS_t <- df_std_IS_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_IS_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item ($ in Million)	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-09-03	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
Revenue	90.08	127.40	309.74	166.93	107.48	131.89	323.00	220.42	120.88	187.96	236.96	112.35	83.84	128.97	242.29	78.76	66.56	149.66	280.13	95.18	70.83	141.95	236.70	105.78	93.00	136.63	262.41	119.56	94.50	167.03	207.86	161.81	140.98	95.81	186.44	337.03	131.11	114.20	202.51	349.36	124.17	82.51	80.44	310.89	106.23	78.07	80.19	314.49	145.36	73.40	95.95	332.42	131.93	72.32	197.99	348.68	100.30	200.93
Cost of Revenue	69.02	93.66	202.76	115.74	76.05	103.32	231.09	159.53	90.96	137.92	162.03	80.46	57.75	86.24	167.67	61.99	50.21	106.11	199.27	77.44	56.49	91.84	172.37	77.84	70.04	114.36	200.63	85.85	64.48	114.92	207.86	111.68	96.18	64.63	113.83	232.70	91.82	78.82	174.32	254.62	86.35	58.95	98.96	219.50	103.99	54.69	102.74	217.78	98.47	49.84	122.12	226.75	86.84	48.05	132.46	237.72	66.07	150.19
Gross Profit	21.05	33.73	106.98	51.20	31.44	28.57	91.91	60.89	29.92	50.04	74.92	31.90	26.09	37.44	74.62	16.77	16.35	39.84	80.86	17.75	14.34	38.93	64.33	27.94	22.96	38.92	61.78	33.72	30.02	52.10	NA	50.13	44.80	31.18	57.14	104.33	39.29	35.38	58.95	94.74	37.82	23.56	38.94	91.39	2.24	23.38	49.48	96.71	46.89	23.57	48.50	105.67	45.09	24.27	65.53	110.96	34.23	50.73
Research and development	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Sales general and administrative costs	42.38	49.07	44.59	34.75	35.84	44.26	38.17	36.93	30.65	47.12	38.18	30.08	28.82	40.90	36.96	24.66	32.34	-14.14	44.59	33.87	35.27	42.59	44.18	39.75	58.62	55.66	55.99	47.83	45.74	54.50	60.52	NA	45.90	45.00	56.47	59.70	42.30	39.58	72.44	50.92	42.64	38.48	54.82	51.74	46.53	47.22	61.98	59.42	46.79	42.98	54.95	55.60	43.09	39.06	54.56	59.38	40.41	56.76
Other Non Operating Income (Loss) Net	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	14.62	NA	NA	-6.96	NA	0.00	0.00	-21.32	NA	0.00	0.00	NA	0.00	0.00	0.00	-9.19	0.00	0.00	0.00	NA	0.00	0.00	0.00	NA	0.00	0.00	NA
Operating Income	-21.32	-15.34	62.40	16.45	-4.40	-15.70	53.74	23.66	-0.73	2.93	36.74	1.82	-2.72	3.23	37.51	-9.75	-15.99	-4.45	35.66	-18.65	-24.04	-8.04	20.04	-12.14	-35.66	-16.04	-7.75	-14.11	-15.72	-2.39	NA	35.51	-1.10	-13.82	7.63	44.63	-3.01	-4.20	7.83	43.81	-4.82	-14.92	-11.13	39.65	-44.29	-23.84	-3.31	37.30	0.11	-19.41	0.32	50.07	2.00	-14.79	10.97	51.58	-6.18	-113.11
Interest Income	0.38	0.76	0.38	0.09	0.12	0.06	0.06	0.01	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.01	0.02	0.02	0.02	0.03	0.02	0.02	0.01	0.01	0.01	0.01	0.01	0.00	0.00	0.01	NA	0.02	0.02	0.01	0.02	0.02	0.02	0.02	0.03	0.03	0.03	0.03	0.09	0.13	0.07	0.06	0.10	0.31	0.20	0.08	0.10	0.12	0.10	0.08	0.10	0.08	0.08
Interest Expense	0.14	0.71	1.44	1.30	3.00	2.29	4.35	2.34	2.20	2.20	2.66	4.37	4.88	4.91	5.57	5.54	5.55	5.38	4.62	2.92	3.02	3.01	3.10	2.20	1.94	2.33	2.03	2.54	2.93	3.51	3.02	NA	3.22	3.23	3.21	3.11	3.11	2.97	3.30	3.97	2.98	2.21	2.74	2.30	2.06	2.85	3.14	2.02	2.04	2.04	2.07	2.06	2.02	2.04	0.98	1.55	2.10	1.98
Other income (expense) Net	-0.89	-0.29	0.08	7.40	-0.82	-1.83	7.09	-6.22	0.55	3.94	-2.59	12.61	16.36	1.67	-0.22	7.70	-9.82	3.52	13.60	0.31	2.29	-1.21	-0.72	2.15	0.92	1.97	6.87	-0.28	-0.03	-0.06	-34.64	35.51	-0.90	-0.11	-2.24	41.51	-6.13	-7.19	4.51	39.81	-7.83	-17.16	-13.90	37.26	-46.48	-26.77	-6.51	35.18	-2.24	-21.64	-1.83	47.90	-0.15	-16.93	9.91	49.93	-8.36	-115.17
Income Before Income Tax	-20.95	-16.52	60.50	7.66	-6.70	-16.22	42.25	27.54	-3.49	-3.21	36.67	-15.16	-23.96	-3.35	32.16	-23.00	-11.72	-13.37	17.43	-21.90	-29.37	-9.87	17.65	-16.50	-38.53	-20.36	-16.65	-16.37	-18.63	-5.84	31.61	NA	-3.44	-16.95	6.65	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Provision for (benefit) Income Tax	-6.73	-5.64	12.38	1.48	-1.38	-54.33	11.57	1.33	0.42	-0.06	0.30	-0.10	0.09	0.45	-0.27	0.27	0.28	0.55	1.02	0.59	-0.24	1.24	1.95	2.09	-2.34	0.72	0.92	-0.33	0.30	1.91	1.08	NA	0.70	0.43	0.31	1.38	1.31	0.43	1.18	1.74	1.28	-0.48	2.18	0.28	-0.14	0.30	85.29	5.98	0.07	-5.19	-17.97	13.26	1.85	-6.14	1.15	9.77	-4.11	-22.67
Net Income (loss) (continous operations)	-14.22	-10.87	48.12	6.18	-5.32	38.11	30.68	26.21	-3.91	-3.15	36.38	-15.06	-24.05	-3.54	32.43	-23.27	-12.00	-13.84	16.41	-22.48	-29.13	-10.61	15.70	-18.59	-36.19	-30.49	-17.57	-16.69	-18.28	-7.75	30.53	NA	-4.14	-17.38	-9.39	45.86	-5.73	-7.58	2.80	44.07	-12.68	NA	-13.48	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA

Cash Flow Statement

# Transpose the Cash Flow Statement of JAKKS Pacific Inc. in standardized format
df_std_CF_t <- transpose_df_standardized(df_std_CF, "standardized_CF")

# Format numeric columns to 2 decimal places
df_std_CF_t <- df_std_CF_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Cash Flow Statement in standardized format
df_std_CF_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item ($ in Million)	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-06-09	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
(Operating Activities) Cash Flow Depreciation, Depletion, Ammortization	1.60	2.44	2.73	2.49	1.29	2.31	4.63	3.13	2.41	1.99	4.90	3.38	2.40	-0.38	4.53	5.16	3.76	-4.78	14.00	8.48	6.47	6.18	13.13	8.66	6.19	5.18	16.60	11.47	8.76	12.09	16.41	9.31	8.07	9.28	14.76	7.61	6.08	5.67	17.26	8.65	NA	6.35	12.21	18.63	8.79	6.39	5.28	25.21	10.19	5.47	10.93	10.80	5.93	3.88	12.15	12.02	5.40	8.99
(Operating Activities) Change in Accounts Receivable	-42.80	-83.21	75.07	47.12	-17.22	-102.21	40.99	60.54	-43.70	-62.31	101.90	27.53	-23.37	-64.71	99.16	4.89	-53.41	-82.58	116.52	17.17	-54.58	-85.08	104.19	5.03	-34.74	-80.86	121.75	14.88	-75.11	-98.66	139.36	47.42	-77.92	-129.47	175.71	12.83	-130.20	-69.82	195.00	43.98	NA	-35.86	-156.74	163.05	29.93	-40.47	-137.18	117.97	63.19	-45.23	-145.02	130.35	51.90	-65.04	-164.89	184.51	-13.54	-4.41
(Operating Activities) Change in Inventory	-6.31	-16.18	3.77	1.07	-16.63	-28.55	-14.49	38.36	1.35	-5.84	29.22	23.93	-1.99	-15.94	-3.10	9.45	-6.03	-11.04	11.78	8.84	-9.20	-10.57	2.29	8.16	-4.43	-21.71	-1.08	13.75	-7.97	0.37	3.60	18.00	-7.07	-20.86	-10.48	12.41	0.65	-9.95	23.63	22.94	NA	-4.58	-12.34	2.44	4.62	-7.64	-13.54	10.43	15.80	-2.02	-9.59	0.58	10.10	1.93	-17.23	13.07	6.46	-12.71
(Operating Activities) Change in Prepaid expenses and other assets	11.20	-0.37	-4.54	-1.60	6.52	-4.76	-3.53	-3.00	6.54	-1.50	-20.15	9.13	5.20	-8.49	-9.37	2.10	-4.24	3.46	-9.35	0.49	11.59	-10.77	1.93	3.91	15.93	2.72	-12.23	-3.26	15.60	-33.60	-0.42	-4.87	0.87	1.22	-4.64	5.90	5.03	-4.55	-4.98	2.09	NA	4.92	4.02	-3.92	-5.35	11.61	-8.21	-5.86	-1.45	3.72	-1.00	-14.11	5.95	6.23	4.77	-8.95	0.82	0.14
(Operating Activities) Change in Accounts Payable	-14.13	-67.04	46.79	38.54	-6.78	-60.82	-23.80	75.87	-14.72	-38.79	25.38	35.60	-8.73	-48.27	42.74	29.21	-38.45	-74.49	72.58	35.22	-28.44	-84.49	75.51	28.43	-9.93	-47.90	32.20	34.58	-19.26	-51.27	29.50	41.09	-8.76	-59.51	35.36	34.99	-31.88	-59.96	55.07	39.21	NA	-3.94	-64.89	34.13	25.63	-7.39	-68.12	40.71	44.28	-4.70	-69.71	33.81	29.51	-10.31	-87.45	65.91	8.14	-4.95
(Operating Activities) Change in Accounts Taxes Payable	-3.73	-13.39	11.64	-0.40	-1.91	-3.06	11.60	1.13	0.20	0.37	-0.07	-0.20	-0.31	-1.14	0.58	0.17	-2.24	2.59	-0.01	0.01	0.00	0.46	0.00	-0.33	0.07	0.07	-0.01	-0.52	NA	-22.87	0.86	0.31	0.67	-3.73	-0.51	1.02	0.20	-1.88	2.27	1.89	NA	0.64	2.13	-1.46	-0.17	5.26	-2.30	7.24	0.12	5.14	-19.55	12.55	1.71	1.02	-10.21	4.07	0.25	1.23
(Operating Activities) Change in Reserve for Sales Return and allowances	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Operating Activities) Deferred Income Tax	NA	-2.58	NA	NA	NA	-57.86	0.00	NA	NA	-0.07	0.00	NA	NA	0.03	NA	NA	NA	-0.98	0.00	NA	NA	0.21	0.00	NA	NA	-1.25	0.00	NA	NA	-0.23	-0.03	0.10	-0.09	-0.25	NA	0.00	NA	1.04	NA	NA	NA	-1.22	-0.03	NA	NA	NA	82.40	0.35	-0.11	-0.24	-7.74	7.42	0.00	-0.31	15.48	-19.52	-3.06	-22.17
(Operating Activities) Stock-based Compensation	2.58	2.06	1.99	1.86	2.09	1.65	1.15	1.16	0.87	0.71	0.46	0.38	0.38	0.80	0.50	0.71	0.25	1.00	0.86	0.40	0.62	0.69	0.76	0.31	0.67	0.86	0.79	0.71	0.75	0.37	0.17	0.46	0.62	0.11	0.51	0.44	0.50	0.48	0.36	0.36	NA	0.28	0.52	0.17	0.18	0.21	-0.07	0.38	0.47	0.34	0.05	0.43	0.27	0.85	0.78	1.53	1.04	1.09
(Operating Activities) Cash Flow from Operating Activities	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-11.39	17.60	-19.44	3.31	9.93	37.38	-39.37	-14.67	33.38	56.93	-41.38	11.46	38.79	26.16	-72.55	-21.58	NA	-11.05	-5.61	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Property, Plant and Equipment	2.23	3.19	0.80	1.43	3.49	2.30	2.81	3.46	1.82	1.85	2.65	2.25	1.47	2.10	1.84	2.75	1.58	1.79	2.42	2.75	2.46	2.22	3.04	3.94	2.57	4.46	2.85	3.24	4.37	3.53	5.13	2.29	3.82	3.49	3.17	8.10	3.08	1.81	1.82	5.70	NA	1.20	2.16	2.06	3.93	1.98	1.25	4.23	4.36	3.22	0.83	2.99	5.41	3.22	1.99	3.04	3.29	4.08
(Investing Activities) Proceeds from Asset Sales	0.00	0.04	0.00	-0.02	0.02	0.00	0.00	0.05	0.00	0.00	0.00	0.01	0.06	-0.17	-0.01	0.12	0.00	-0.01	0.01	0.00	0.06	-0.01	0.08	0.03	0.00	0.05	0.00	0.02	0.00	-0.01	NA	NA	0.00	-0.07	0.00	0.01	NA	0.00	0.00	-0.03	NA	0.01	-0.86	0.00	-1.10	NA	-0.04	0.00	0.00	-0.02	-0.45	0.00	-0.04	0.03	-0.11	0.00	0.02	-0.83
(Investing Activities) Purchase of Businesses	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Marketable Securities and Investment	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	0.00	0.00	NA	0.00	0.00	0.00	NA	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
(Investing Activities) Proceeds from sale or maturity of Marketable Securities and Investment	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	0.07	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Proceeds from maturities of Marketable Securities and Investment	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Cash Flow from Investing Activities	-3.63	-3.23	-0.78	-1.42	-3.47	-2.30	-2.81	-3.46	-1.82	-1.85	-2.65	-2.24	-1.45	-2.07	-1.85	-2.68	-1.58	-1.79	-2.41	-2.75	-2.46	-2.20	-2.93	-3.94	-2.57	-4.34	-2.85	-3.79	NA	-3.77	NA	NA	NA	NA	NA	NA	NA	-5.58	NA	NA	NA	-0.86	-2.35	-3.19	-1.28	-3.94	-9.97	-51.57	-4.96	-6.24	-19.64	-2.81	-5.35	-8.50	-3.78	0.31	-4.86	-7.62
(Financing Activities) Proceeds from Issuance of Stock	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	NA	NA	NA	0.00	NA	NA	NA	0.00	0.00	9.66	NA	0.00	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment for Repurchase of Stock	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	NA	NA	NA	0.00	NA	NA	NA	0.00	1.56	2.10	9.84	6.20	2.33	NA	NA	0.00	8.00	24.00	24	NA	NA	NA	NA	NA	0.00	26.67	NA	NA	0.00	19.31	0.00	5.05	5.64	1.52	NA	NA
(Financing Activities) Proceeds from Issuance of Debt	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment of Debt	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash for Dividends	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	0.00	1.54	1.55	2.16	2.19	2.60	2.59	2.59	0.86	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash Flow from Financing Activities	-20.00	-0.58	-1.28	-30.50	-39.93	-0.76	-18.76	-10.62	-0.89	-0.25	-0.09	-32.29	-0.16	-15.07	0.00	4.30	-0.17	-5.00	7.17	-0.19	-7.75	7.69	-13.18	18.55	-10.17	5.87	4.00	-15.41	-24.06	2.03	-1.56	-2.79	-12.62	-31.21	18.01	-0.17	-0.01	-23.90	-0.01	76.16	NA	16.82	-0.07	69.64	-96.34	-14.35	15.07	-29.26	-2.59	-2.60	-2.17	-22.04	0.13	-4.98	-5.78	-4.61	-10.19	4.26
Effect of Exchange Rate on Cash & Cash Equivalent	-0.56	1.18	-0.79	1.13	0.33	1.11	-2.83	-2.15	-0.66	-0.34	-0.48	0.38	-0.06	2.40	1.13	0.08	-1.63	1.47	-0.90	0.43	NA	-0.62	NA	NA	NA	0.92	NA	NA	NA	-1.54	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Change in Cash, Cash Equivalents	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-6.02	NA	NA	NA	-11.01	NA	NA	NA	NA	-19.04	6.11	NA	NA	-18.50	46.76	-41.22	-32.22	16.39	21.02	-29.06	5.17	33.57	-17.48	-74.10	49.36	NA	-3.72	65.62	-18.20	-95.64	-23.96	48.57	-80.89	-32.91	-2.70	25.01	-14.60	-27.62	-3.88	59.75	-30.16	-3.04	21.33

Trailing Month (TM) format

Finally, we will calculate the multiple trailing month value of the Income Statement and Cash Flow. These are easily comparable with the filing on SEC website.

Twelve Trailing Month (12 month)

Income Statement

# Calculation Trailing month
df_std_IS_12TM <- calculate_trailing_months(df_std_IS,12)

# Define the order of columns of the transposed dataframe
order_df <- colnames(df_std_IS_12TM) %>% as.data.frame()

# Transpose the Income Statement into standardized format
df_std_IS_12TM_t <- transpose_df(df_std_IS_12TM, order_df)

# Format numeric columns to 2 decimal places
df_std_IS_12TM_t <- df_std_IS_12TM_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_IS_12TM_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-09-03	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
Revenue_12m	694.15	711.55	716.04	729.30	782.79	796.19	852.26	766.22	658.15	621.11	562.12	567.45	533.86	516.58	537.27	575.11	591.53	595.80	588.09	544.66	555.26	577.43	572.11	597.82	611.60	613.10	643.50	588.95	631.20	677.68	606.46	585.04	760.26	750.39	768.78	784.85	797.18	790.24	758.55	636.48	598.01	580.07	575.63	575.38	578.98	618.11	613.44	629.20	647.13	633.70	632.62	734.66	750.92	719.29	847.90	NA	NA	NA
Cost of Revenue_12m	481.18	488.21	497.87	526.20	569.99	584.90	619.50	550.44	471.37	438.16	386.48	392.12	373.65	366.11	385.98	417.58	433.03	439.31	425.04	398.14	398.54	412.09	434.61	462.87	470.88	465.32	465.88	473.11	498.94	530.64	480.35	386.32	507.34	502.98	517.17	577.66	599.58	594.11	574.24	498.88	463.76	481.40	477.14	480.92	479.20	473.68	468.83	488.21	497.18	485.55	483.76	494.10	505.07	484.30	586.44	NA	NA	NA
Gross Profit_12m	212.96	223.35	218.19	203.12	212.81	211.29	232.76	215.77	186.78	182.95	170.35	170.05	154.92	145.18	147.58	153.82	154.80	152.79	151.88	135.35	145.54	154.16	154.15	151.60	157.38	164.44	177.62	NA	NA	NA	NA	183.25	237.45	231.94	236.14	237.95	228.36	226.89	215.07	195.06	191.71	156.13	155.95	166.49	171.81	216.46	216.65	215.67	224.63	222.83	223.53	240.56	245.85	234.99	261.45	NA	NA	NA
Research and development_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Sales general and administrative costs_12m	170.79	164.25	159.44	153.02	155.20	150.01	152.87	152.88	146.03	144.20	137.98	136.76	131.34	134.86	79.82	87.45	96.66	99.59	156.32	155.91	161.79	185.14	198.21	210.02	218.10	205.22	204.06	208.59	NA	NA	NA	NA	207.07	203.47	198.05	214.02	205.24	205.58	204.48	186.86	187.68	191.57	200.31	207.47	215.15	215.41	211.17	204.14	200.32	196.62	192.70	192.31	196.09	193.41	211.11	NA	NA	NA
Other Non Operating Income (Loss) Net_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-9.19	-9.19	-9.19	-9.19	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Operating Income_12m	42.19	59.11	58.75	50.09	57.30	60.97	79.60	62.60	40.76	38.77	39.07	39.84	28.27	15.00	7.32	5.47	-3.43	-11.48	-15.07	-30.69	-24.18	-35.80	-43.80	-71.59	-73.56	-53.62	-39.97	NA	NA	NA	NA	28.22	37.34	35.43	45.05	45.25	44.43	42.62	31.90	12.94	8.78	-30.69	-39.61	-31.79	-34.14	10.26	14.69	18.32	31.09	32.98	37.60	48.25	49.76	41.58	-56.74	NA	NA	NA
Interest Income_12m	1.61	1.35	0.65	0.33	0.25	0.13	0.07	0.01	0.00	0.00	0.00	0.00	0.00	0.01	0.03	0.05	0.07	0.09	0.09	0.09	0.08	0.06	0.05	0.04	0.04	0.03	0.02	0.02	NA	NA	NA	NA	0.07	0.07	0.07	0.08	0.09	0.10	0.11	0.12	0.18	0.28	0.32	0.35	0.36	0.54	0.67	0.69	0.69	0.50	0.40	0.40	0.40	0.36	0.34	NA	NA	NA
Interest Expense_12m	3.59	6.45	8.03	10.94	11.98	11.18	11.09	9.40	11.43	14.11	16.82	19.73	20.90	21.57	22.04	21.09	18.47	15.94	13.57	12.05	11.33	10.25	9.57	8.50	8.84	9.83	11.01	12.00	NA	NA	NA	NA	12.77	12.66	12.40	12.49	13.35	13.22	12.46	11.90	10.23	9.31	9.95	10.35	10.07	10.05	9.24	8.17	8.21	8.19	8.19	7.10	6.59	6.67	6.61	NA	NA	NA
Other income (expense) Net_12m	6.30	6.37	4.83	11.84	-1.78	-0.41	5.36	-4.32	14.51	30.32	28.05	30.42	25.51	-0.67	1.18	15.00	7.61	19.72	14.99	0.67	2.51	1.14	4.32	11.91	9.48	8.53	6.50	-35.01	0.78	-0.09	-0.14	32.26	38.26	33.03	25.95	32.70	31.00	29.30	19.33	0.92	-1.63	-40.28	-49.89	-42.50	-44.58	-0.34	4.79	9.47	22.19	24.28	28.99	40.73	42.76	34.55	-63.69	NA	NA	NA
Income Before Income Tax_12m	30.69	44.94	45.24	26.99	46.87	50.08	63.09	57.51	14.81	-5.66	-5.80	-10.31	-18.15	-5.91	-15.93	-30.66	-29.56	-47.21	-43.71	-43.49	-38.09	-47.25	-57.74	-92.04	-91.91	-72.01	-57.49	-9.23	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Provision for (benefit) Income Tax_12m	1.49	6.84	-41.85	-42.66	-42.81	-41.01	13.26	1.99	0.56	0.23	0.74	0.17	0.54	0.73	0.83	2.12	2.44	1.92	2.61	3.54	5.04	2.94	2.42	1.39	-1.03	1.61	2.80	2.96	NA	NA	NA	NA	2.82	3.43	3.43	4.30	4.66	4.63	3.72	4.72	3.26	1.84	2.62	85.73	91.43	91.64	86.15	-17.11	-9.83	-8.05	-9.00	10.12	6.63	0.67	-15.86	NA	NA	NA
Net Income (loss) (continous operations)_12m	29.21	38.11	87.09	69.65	89.68	91.09	49.83	55.53	14.26	-5.88	-6.27	-10.22	-18.43	-6.38	-16.68	-32.70	-31.91	-49.04	-45.81	-46.52	-42.63	-49.69	-69.57	-102.84	-100.94	-83.03	-60.29	-12.19	NA	NA	NA	NA	14.95	13.36	23.16	35.35	33.56	26.61	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA

Cash Flow Statement

# Calculation Trailing month
df_std_CF_12TM <- calculate_trailing_months(df_std_CF,12)

# Define the order of columns of the transposed dataframe
order_df <- colnames(df_std_CF_12TM) %>% as.data.frame()

# Transpose the Income Statement into standardized format
df_std_CF_12TM_t <- transpose_df(df_std_CF_12TM, order_df)

# Format numeric columns to 2 decimal places
df_std_CF_12TM_t <- df_std_CF_12TM_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_CF_12TM_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-06-09	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
(Operating Activities) Cash Flow Depreciation, Depletion, Ammortization_12m	9.26	8.95	8.82	10.72	11.36	12.48	12.16	12.43	12.68	12.67	10.30	9.93	11.71	13.07	8.67	18.14	21.46	24.17	35.13	34.26	34.44	34.16	33.16	36.63	39.44	42.01	48.92	48.73	46.57	45.88	43.07	41.42	39.72	37.73	34.12	36.62	37.66	NA	NA	NA	NA	45.98	46.02	39.09	45.67	47.07	46.15	51.80	37.39	33.13	31.54	32.76	33.98	33.45	38.56	NA	NA	NA
(Operating Activities) Change in Accounts Receivable_12m	-3.82	21.76	2.76	-31.32	-17.90	-44.38	-4.48	56.43	23.42	43.75	41.35	38.61	15.97	-14.07	-31.94	-14.58	-2.30	-3.47	-5.97	-18.30	-30.44	-10.60	-6.38	11.18	21.03	-19.34	-37.14	-19.53	13.01	10.20	-20.61	15.74	-18.85	-71.13	-11.48	7.81	38.96	NA	NA	NA	NA	0.38	-4.23	15.33	-29.75	3.51	-1.25	-9.09	3.29	-8.00	-27.81	-47.68	6.48	-58.96	1.67	NA	NA	NA
(Operating Activities) Change in Inventory_12m	-17.65	-27.97	-40.34	-58.60	-21.31	-3.33	19.38	63.09	48.66	45.32	35.22	2.90	-11.58	-15.62	-10.72	4.16	3.55	0.38	0.85	-8.64	-9.32	-4.55	-15.69	-19.06	-13.47	-17.01	5.07	9.75	14.00	14.90	-6.33	-20.41	-26.00	-18.28	-7.37	26.74	37.27	NA	NA	NA	NA	-9.86	-12.92	-14.12	-6.13	5.05	10.67	14.62	4.77	-0.93	3.02	-4.62	7.87	4.23	-10.41	NA	NA	NA
(Operating Activities) Change in Prepaid expenses and other assets_12m	4.69	0.01	-4.38	-3.37	-4.77	-4.75	-1.49	-18.11	-5.98	-7.32	-14.31	-3.53	-10.56	-20.00	-8.05	-8.03	-9.64	6.19	-8.04	3.24	6.66	11.00	24.49	10.33	3.16	2.83	-33.49	-21.68	-23.29	-38.02	-3.20	-7.42	3.35	7.51	1.74	1.40	-2.41	NA	NA	NA	NA	-0.33	6.36	-5.87	-7.81	-3.91	-11.80	-4.59	-12.84	-5.44	-2.93	2.84	8.00	2.87	-3.22	NA	NA	NA
(Operating Activities) Change in Accounts Payable_12m	4.16	11.51	17.73	-52.86	-15.53	-23.47	-1.44	47.74	7.47	13.46	3.98	21.34	14.95	-14.77	-40.99	-11.15	-5.14	4.87	-5.13	-2.20	-8.99	9.52	46.11	2.80	8.95	-0.38	-3.75	-6.45	0.06	10.56	2.32	8.18	2.08	-21.04	-21.49	-1.78	2.44	NA	NA	NA	NA	-9.07	-12.52	-15.75	-9.17	9.48	12.17	10.58	3.68	-11.09	-16.70	-34.44	-2.34	-23.71	-18.35	NA	NA	NA
(Operating Activities) Change in Accounts Taxes Payable_12m	-5.88	-4.06	6.27	6.23	7.76	9.87	13.30	1.63	0.30	-0.21	-1.72	-1.07	-0.70	-2.63	1.10	0.51	0.35	2.59	0.46	0.47	0.13	0.20	-0.19	-0.20	-0.39	NA	NA	NA	NA	-21.03	-1.89	-3.26	-2.55	-3.02	-1.17	1.61	2.48	NA	NA	NA	NA	1.14	5.76	1.33	10.03	10.32	10.20	-7.05	-1.74	-0.15	-4.27	5.07	-3.41	-4.87	-4.66	NA	NA	NA
(Operating Activities) Change in Reserve for Sales Return and allowances_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Operating Activities) Deferred Income Tax_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-0.25	-0.27	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	82.40	-7.74	-0.67	-0.56	-0.63	22.59	-4.35	-7.41	-29.27	NA	NA	NA
(Operating Activities) Stock-based Compensation_12m	8.49	8.00	7.59	6.75	6.05	4.83	3.89	3.20	2.42	1.93	2.02	2.06	2.39	2.26	2.46	2.82	2.51	2.88	2.57	2.47	2.38	2.43	2.60	2.63	3.03	3.11	2.62	2.00	1.75	1.62	1.36	1.70	1.68	1.56	1.93	1.78	1.70	NA	NA	NA	NA	1.15	1.08	0.49	0.70	0.99	1.12	1.24	1.29	1.09	1.60	2.33	3.43	4.20	4.44	NA	NA	NA
(Operating Activities) Cash Flow from Operating Activities_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-9.92	11.40	31.18	11.25	-6.73	16.72	36.27	34.26	60.39	65.80	35.03	3.86	-29.18	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Property, Plant and Equipment_12m	7.65	8.91	8.02	10.03	12.06	10.39	9.94	9.78	8.57	8.22	8.47	7.66	8.16	8.27	7.96	8.54	8.54	9.42	9.85	10.47	11.66	11.77	14.01	13.82	13.12	14.92	13.99	16.27	15.32	14.77	14.73	12.77	18.58	17.84	16.16	14.81	12.41	NA	NA	NA	NA	9.35	10.13	9.22	11.39	11.82	13.06	12.64	11.40	12.45	12.45	13.61	13.66	11.54	12.40	NA	NA	NA
(Investing Activities) Proceeds from Asset Sales_12m	0.02	0.04	0.00	0.00	0.07	0.05	0.05	0.05	0.01	0.07	-0.10	-0.11	0.00	-0.06	0.10	0.12	0.00	0.06	0.06	0.13	0.16	0.10	0.16	0.08	0.07	0.07	0.01	NA	NA	NA	NA	NA	-0.06	NA	NA	NA	NA	NA	NA	NA	NA	-1.95	NA	NA	NA	NA	-0.06	-0.47	-0.47	-0.51	-0.46	-0.12	-0.12	-0.06	-0.92	NA	NA	NA
(Investing Activities) Purchase of Businesses_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Marketable Securities and Investment_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	0.00	0.00	0.00	0.00	NA	NA	NA
(Investing Activities) Proceeds from sale or maturity of Marketable Securities and Investment_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Proceeds from maturities of Marketable Securities and Investment_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Cash Flow from Investing Activities_12m	-9.06	-8.90	-7.97	-10.00	-12.04	-10.39	-9.94	-9.78	-8.56	-8.19	-8.41	-7.61	-8.05	-8.18	-7.90	-8.46	-8.53	-9.41	-9.82	-10.34	-11.53	-11.64	-13.78	-13.70	-13.55	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-7.68	-10.76	-18.38	-66.76	-70.44	-72.74	-82.41	-33.65	-34.04	-36.30	-20.44	-17.32	-16.83	-15.95	NA	NA	NA
(Financing Activities) Proceeds from Issuance of Stock_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment for Repurchase of Stock_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	13.50	19.70	20.47	NA	NA	NA	NA	NA	56	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	24.36	30.00	12.21	NA	NA	NA	NA	NA
(Financing Activities) Proceeds from Issuance of Debt_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment of Debt_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash for Dividends_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	3.09	5.25	7.44	8.50	9.54	9.97	8.64	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash Flow from Financing Activities_12m	-52.36	-72.29	-72.47	-89.95	-70.07	-31.03	-30.52	-11.85	-33.52	-32.79	-47.61	-47.52	-10.93	-10.94	-0.87	6.30	1.81	-5.77	6.92	-13.43	5.31	2.89	1.07	18.25	-15.71	-29.60	-33.44	-39.00	-26.38	-14.94	-48.18	-28.61	-25.99	-13.38	-6.07	-24.09	52.24	NA	NA	NA	NA	-9.95	-41.12	-25.98	-124.88	-31.13	-19.38	-36.62	-29.40	-26.68	-29.06	-32.67	-15.24	-25.56	-16.32	NA	NA	NA
Effect of Exchange Rate on Cash & Cash Equivalent_12m	0.96	1.85	1.78	-0.26	-3.54	-4.53	-5.98	-3.63	-1.10	-0.50	2.24	3.85	3.55	1.98	1.05	-0.98	-0.63	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Change in Cash, Cash Equivalents_12m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-45.18	-10.29	-36.03	-23.87	13.52	30.70	-7.80	-52.84	-8.65	NA	NA	NA	NA	-51.94	-72.18	-89.23	-151.92	-89.19	-67.93	-91.49	-25.20	-19.91	-21.09	13.65	-1.91	22.67	47.88	NA	NA	NA

Nine Trailing Month (9 month)

Income Statement

# Calculation Trailing month
df_std_IS_9TM <- calculate_trailing_months(df_std_IS,9)

# Define the order of columns of the transposed dataframe
order_df <- colnames(df_std_IS_9TM) %>% as.data.frame()

# Transpose the Income Statement into standardized format
df_std_IS_9TM_t <- transpose_df(df_std_IS_9TM, order_df)

# Format numeric columns to 2 decimal places
df_std_IS_9TM_t <- df_std_IS_9TM_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_IS_9TM_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-09-03	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
Revenue_9m	527.22	604.07	584.15	406.30	562.37	675.31	664.30	529.26	545.80	537.27	433.15	325.16	455.10	450.02	387.61	294.98	496.35	524.97	446.14	307.96	449.48	484.43	435.48	335.41	492.04	518.60	476.47	381.09	469.39	536.70	510.65	398.60	423.23	619.28	654.58	582.34	447.82	666.07	676.04	556.04	287.12	473.84	497.56	495.19	264.49	472.75	540.04	533.25	314.71	501.77	560.30	536.67	402.24	618.99	646.97	649.91	NA	NA
Cost of Revenue_9m	365.44	412.16	394.55	295.11	410.46	493.94	481.58	388.41	390.91	380.41	300.24	224.45	311.66	315.90	279.87	218.31	355.59	382.82	333.20	225.77	320.70	342.05	320.25	262.24	385.03	400.84	350.96	265.25	387.26	434.46	415.72	272.49	274.64	411.16	438.35	403.34	344.96	507.76	515.29	399.92	244.26	377.41	422.45	378.18	261.42	375.21	418.99	366.09	270.43	398.71	435.71	361.64	267.35	418.23	436.25	453.98	NA	NA
Gross Profit_9m	161.76	191.91	189.62	111.21	151.92	181.37	182.72	140.85	154.88	156.86	132.91	95.43	138.15	128.83	107.74	72.96	137.05	138.45	112.95	71.02	117.60	131.20	115.23	89.82	123.66	134.42	125.52	115.84	NA	NA	NA	126.11	133.12	192.65	200.76	179.00	133.62	189.07	191.51	156.12	100.32	153.89	132.57	117.01	75.10	169.57	193.08	167.17	118.96	177.74	199.26	175.03	134.89	200.76	210.72	195.92	NA	NA
Research and development_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Sales general and administrative costs_9m	136.04	128.41	115.18	114.85	118.27	119.36	105.75	114.70	115.95	115.38	97.08	99.80	106.68	102.52	93.96	42.86	62.79	64.32	113.73	111.73	122.04	126.52	142.55	154.03	170.27	159.48	149.56	148.07	160.76	NA	NA	NA	147.37	161.17	158.47	141.58	154.32	162.94	166.00	132.04	135.94	145.04	153.09	145.49	155.73	168.62	168.19	149.19	144.72	153.53	153.64	137.75	136.71	153.00	154.35	156.55	NA	NA
Other Non Operating Income (Loss) Net_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-21.32	NA	NA	NA	NA	NA	NA	0.00	-9.19	-9.19	-9.19	0.00	NA	NA	NA	0.00	NA	NA	NA	NA	NA	NA
Operating Income_9m	25.74	63.51	74.45	-3.65	33.64	61.70	76.67	25.86	38.94	41.49	35.84	2.33	38.02	30.99	11.77	-30.19	15.22	12.56	-7.03	-50.73	-12.04	-0.14	-27.76	-63.84	-59.45	-37.90	-37.58	-32.22	NA	NA	NA	20.59	-7.29	38.44	49.25	37.42	0.62	47.44	46.82	24.07	-30.87	13.60	-15.77	-28.48	-71.44	10.15	34.10	18.00	-18.98	30.98	52.39	37.28	-1.82	47.76	56.37	-67.71	NA	NA
Interest Income_9m	1.52	1.23	0.59	0.27	0.24	0.13	0.07	0.01	0.00	0.00	0.00	0.00	0.00	0.00	0.01	0.03	0.05	0.06	0.07	0.07	0.07	0.05	0.04	0.03	0.03	0.03	0.02	0.01	0.01	NA	NA	NA	0.05	0.05	0.05	0.06	0.06	0.07	0.08	0.09	0.09	0.15	0.25	0.29	0.26	0.23	0.47	0.61	0.59	0.38	0.30	0.32	0.30	0.28	0.26	0.26	NA	NA
Interest Expense_9m	2.29	3.45	5.74	6.59	9.64	8.98	8.89	6.74	7.06	9.23	11.91	14.16	15.36	16.02	16.66	16.47	15.55	12.92	10.56	8.95	9.13	8.31	7.24	6.47	6.30	6.90	7.50	8.98	9.46	NA	NA	NA	9.66	9.55	9.43	9.19	9.38	10.24	10.25	9.16	7.93	7.25	7.10	7.21	8.05	8.01	7.20	6.10	6.15	6.17	6.15	6.12	5.04	4.57	4.63	5.63	NA	NA
Other income (expense) Net_9m	-1.10	7.19	6.66	4.75	4.44	-0.96	1.42	-1.73	1.90	13.96	26.38	30.64	17.81	9.15	-2.34	1.40	7.30	17.43	16.20	1.39	0.36	0.22	2.35	5.04	9.76	8.56	6.56	-0.37	-34.73	0.81	-0.03	34.50	-3.25	39.16	33.14	28.19	-8.81	37.13	36.49	14.82	-38.89	6.20	-23.12	-35.99	-79.76	1.90	26.43	11.30	-25.71	24.43	45.92	30.82	-7.17	42.91	51.48	-73.60	NA	NA
Income Before Income Tax_9m	23.03	51.64	61.46	-15.26	19.33	53.57	66.30	20.84	29.97	18.30	-2.45	-42.47	4.85	5.81	-2.56	-48.09	-7.66	-17.84	-33.84	-61.14	-21.59	-8.72	-37.38	-75.39	-75.54	-53.38	-51.65	-40.84	7.14	NA	NA	NA	-13.74	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Provision for (benefit) Income Tax_9m	0.01	8.22	12.48	-54.23	-44.14	-41.43	13.32	1.69	0.66	0.14	0.29	0.44	0.27	0.45	0.28	1.10	1.85	2.16	1.37	1.59	2.95	5.28	1.70	0.47	-0.70	1.31	0.89	1.88	3.29	NA	NA	NA	1.44	2.12	3.00	3.12	2.92	3.35	4.20	2.54	2.98	1.98	2.32	0.44	85.45	91.57	91.34	0.86	-23.09	-9.90	-2.86	8.97	-3.14	4.78	6.81	-17.01	NA	NA
Net Income (loss) (continous operations)_9m	23.03	43.43	48.98	38.97	63.47	95.00	52.98	19.15	29.32	18.17	-2.73	-42.65	4.84	5.62	-2.84	-49.11	-9.43	-19.91	-35.20	-62.22	-24.04	-13.50	-39.08	-85.27	-84.25	-64.75	-52.54	-42.72	4.50	NA	NA	NA	-30.91	19.09	30.74	32.55	-10.51	39.29	34.19	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA

Cash Flow Statement

# Calculation Trailing month
df_std_CF_9TM <- calculate_trailing_months(df_std_CF,9)

# Define the order of columns of the transposed dataframe
order_df <- colnames(df_std_CF_9TM) %>% as.data.frame()

# Transpose the Income Statement into standardized format
df_std_CF_9TM_t <- transpose_df(df_std_CF_9TM, order_df)


# Format numeric columns to 2 decimal places
df_std_CF_9TM_t <- df_std_CF_9TM_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_CF_9TM_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-06-09	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
(Operating Activities) Cash Flow Depreciation, Depletion, Ammortization_9m	6.77	7.66	6.51	6.09	8.23	10.07	10.17	7.53	9.30	10.27	10.68	5.40	6.55	9.31	13.45	4.14	12.98	17.70	28.95	21.13	25.78	27.97	27.98	20.03	27.97	33.25	36.83	32.32	37.26	37.81	33.79	26.66	32.11	31.65	28.45	19.36	29.01	31.58	NA	NA	NA	37.19	39.63	33.81	20.46	36.88	40.68	40.87	26.59	27.20	27.66	20.61	21.96	28.05	29.57	26.41	NA	NA
(Operating Activities) Change in Accounts Receivable_9m	-50.94	38.98	104.97	-72.31	-78.44	-0.68	57.83	-45.47	-4.11	67.12	106.06	-60.55	11.08	39.34	50.64	-131.10	-19.47	51.11	79.11	-122.49	-35.47	24.14	74.48	-110.57	6.15	55.77	61.52	-158.89	-34.41	88.12	108.86	-159.97	-31.68	59.07	58.34	-187.19	-5.02	169.16	NA	NA	NA	-29.55	36.24	152.51	-147.72	-59.68	43.98	135.93	-127.06	-59.90	37.23	117.21	-178.03	-45.42	6.08	166.56	NA	NA
(Operating Activities) Change in Inventory_9m	-18.72	-11.34	-11.79	-44.11	-59.67	-4.68	25.22	33.87	24.73	47.31	51.16	6.00	-21.03	-9.59	0.32	-7.62	-5.29	9.58	11.42	-10.93	-17.48	-0.12	6.02	-17.98	-27.22	-9.04	4.70	6.15	-4.00	21.97	14.53	-9.93	-38.41	-18.93	2.58	3.11	14.33	36.62	NA	NA	NA	-14.48	-5.28	-0.58	-16.56	-10.75	12.69	24.21	4.19	-11.03	1.09	12.61	-5.20	-2.23	2.30	6.82	NA	NA
(Operating Activities) Change in Prepaid expenses and other assets_9m	6.29	-6.51	0.38	0.16	-1.77	-11.29	0.01	2.04	-15.11	-12.52	-5.82	5.84	-12.66	-15.76	-11.51	1.32	-10.13	-5.40	2.73	1.31	2.75	-4.93	21.77	22.56	6.42	-12.77	0.11	-21.26	-18.42	-38.89	-4.42	-2.78	-2.55	2.48	6.29	6.38	-4.50	-7.44	NA	NA	NA	5.02	-5.25	2.34	-1.95	-2.46	-15.52	-3.59	1.27	-11.39	-9.16	-1.93	16.95	2.05	-3.36	-7.99	NA	NA
(Operating Activities) Change in Accounts Payable_9m	-34.38	18.29	78.55	-29.06	-91.40	-8.75	37.35	22.36	-28.13	22.19	52.25	-21.40	-14.26	23.68	33.50	-83.73	-40.36	33.31	79.36	-77.71	-37.42	19.45	94.01	-29.40	-25.63	18.88	47.52	-35.95	-41.03	19.32	61.83	-27.18	-32.91	10.84	38.47	-56.85	-36.77	34.32	NA	NA	NA	-34.70	-5.13	52.37	-49.88	-34.80	16.87	80.29	-30.13	-40.60	-6.39	53.01	-68.25	-31.85	-13.40	69.10	NA	NA
(Operating Activities) Change in Accounts Taxes Payable_9m	-5.48	-2.15	9.33	-5.37	6.63	9.67	12.93	1.70	0.50	0.10	-0.58	-1.65	-0.87	-0.39	-1.49	0.52	0.34	2.59	0.00	0.47	0.46	0.13	-0.26	-0.19	0.13	-0.46	NA	NA	NA	-21.70	1.84	-2.75	-3.57	-3.22	0.71	-0.66	0.59	2.28	NA	NA	NA	1.31	0.50	3.63	2.79	10.20	5.06	12.50	-14.29	-1.86	-5.29	15.28	-7.48	-5.12	-5.89	5.55	NA	NA
(Operating Activities) Change in Reserve for Sales Return and allowances_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Operating Activities) Deferred Income Tax_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-0.16	-0.02	-0.24	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	82.64	0.00	-8.09	-0.56	-0.32	7.11	15.17	-4.35	-7.10	-44.75	NA	NA
(Operating Activities) Stock-based Compensation_9m	6.63	5.91	5.94	5.60	4.89	3.96	3.18	2.74	2.04	1.55	1.22	1.56	1.68	2.01	1.46	1.96	2.11	2.26	1.88	1.71	2.07	1.76	1.74	1.84	2.32	2.36	2.25	1.83	1.29	1.00	1.25	1.19	1.24	1.06	1.45	1.42	1.34	1.20	NA	NA	NA	0.97	0.87	0.56	0.32	0.52	0.78	1.19	0.86	0.82	0.75	1.55	1.90	3.16	3.35	3.66	NA	NA
(Operating Activities) Cash Flow from Operating Activities_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-13.23	1.47	-6.20	50.62	7.94	-16.66	-20.66	75.64	48.93	27.01	8.87	76.41	-7.60	-67.97	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Property, Plant and Equipment_9m	6.22	5.42	5.72	7.22	8.60	8.57	8.09	7.13	6.32	6.75	6.37	5.82	5.41	6.69	6.17	6.12	5.79	6.96	7.63	7.43	7.72	9.20	9.55	10.97	9.88	10.55	10.46	11.14	13.03	10.95	11.24	9.60	10.48	14.76	14.35	12.99	6.71	9.33	NA	NA	NA	5.42	8.15	7.97	7.16	7.46	9.84	11.81	8.41	7.04	9.23	11.62	10.62	8.25	8.32	10.41	NA	NA
(Investing Activities) Proceeds from Asset Sales_9m	0.04	0.02	0.00	0.00	0.02	0.05	0.05	0.05	0.00	0.01	0.07	-0.10	-0.12	-0.06	0.11	0.11	0.00	0.00	0.07	0.05	0.13	0.10	0.11	0.08	0.05	0.07	0.02	0.01	NA	NA	NA	NA	-0.07	-0.06	NA	NA	NA	-0.03	NA	NA	NA	-0.85	-1.96	NA	NA	NA	-0.04	-0.02	-0.47	-0.47	-0.49	-0.01	-0.12	-0.08	-0.09	-0.81	NA	NA
(Investing Activities) Purchase of Businesses_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Marketable Securities and Investment_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	NA	NA	NA	0.00	NA	NA	NA	0.00	0.00	0.00	0.00	0.00	0.00	NA	NA
(Investing Activities) Proceeds from sale or maturity of Marketable Securities and Investment_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Proceeds from maturities of Marketable Securities and Investment_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Cash Flow from Investing Activities_9m	-7.64	-5.43	-5.67	-7.19	-8.58	-8.57	-8.09	-7.13	-6.32	-6.74	-6.34	-5.76	-5.37	-6.60	-6.11	-6.05	-5.78	-6.95	-7.62	-7.41	-7.59	-9.07	-9.44	-10.85	-9.76	-10.98	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-6.40	-6.82	-8.41	-15.19	-65.48	-66.50	-62.77	-30.84	-28.69	-27.80	-16.66	-17.63	-11.97	-8.33	-12.17	NA	NA
(Financing Activities) Proceeds from Issuance of Stock_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	9.66	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment for Repurchase of Stock_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	3.66	13.50	18.14	18.37	NA	NA	NA	NA	32.00	56	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	19.31	24.36	10.69	12.21	NA	NA	NA	NA
(Financing Activities) Proceeds from Issuance of Debt_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment of Debt_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash for Dividends_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	1.54	3.09	5.25	5.90	6.95	7.38	7.78	6.04	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash Flow from Financing Activities_9m	-21.86	-32.36	-71.71	-71.19	-59.45	-30.14	-30.27	-11.76	-1.23	-32.63	-32.54	-47.52	-15.23	-10.77	4.13	-0.87	2.00	1.98	-0.77	-0.25	-13.24	13.06	-4.80	14.25	-0.30	-5.54	-35.47	-37.44	-23.59	-2.32	-16.97	-46.62	-25.82	-13.37	17.83	-24.08	-23.92	52.25	NA	NA	NA	86.39	-26.77	-41.05	-95.62	-28.54	-16.78	-34.45	-7.36	-26.81	-24.08	-26.89	-10.63	-15.37	-20.58	-10.54	NA	NA
Effect of Exchange Rate on Cash & Cash Equivalent_9m	-0.17	1.52	0.67	2.57	-1.39	-3.87	-5.64	-3.15	-1.48	-0.44	-0.16	2.72	3.47	3.61	-0.42	-0.08	-1.06	1.00	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Change in Cash, Cash Equivalents_9m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-12.96	-26.68	-57.05	5.19	8.35	-2.87	9.68	21.26	-58.01	-42.22	NA	NA	NA	43.70	-48.22	-137.80	-71.03	-56.28	-65.23	-116.50	-10.60	7.71	-17.21	-46.10	28.25	25.71	26.55	-11.87	NA	NA

Six Trailing Month (6 month)

Income Statement

# Calculation Trailing month
df_std_IS_6TM <- calculate_trailing_months(df_std_IS,6)

# Define the order of columns of the transposed dataframe
order_df <- colnames(df_std_IS_6TM) %>% as.data.frame()

# Transpose the Income Statement into standardized format
df_std_IS_6TM_t <- transpose_df(df_std_IS_6TM, order_df)


# Format numeric columns to 2 decimal places
df_std_IS_6TM_t <- df_std_IS_6TM_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_IS_6TM_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-09-03	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
Revenue_6m	217.48	437.14	476.67	274.41	239.37	454.89	543.42	341.30	308.84	424.92	349.31	196.19	212.81	371.26	321.05	145.32	216.22	429.79	375.31	166.01	212.78	378.65	342.48	198.78	229.63	399.04	381.97	214.06	261.53	374.89	369.67	302.79	236.79	282.25	523.47	468.14	245.31	316.71	551.87	473.53	206.68	162.95	391.33	417.12	184.30	158.26	394.68	459.85	218.76	169.35	428.37	464.35	204.25	270.31	546.67	448.98	301.23	NA
Cost of Revenue_6m	162.68	296.42	318.50	191.79	179.37	334.41	390.62	250.49	228.88	299.95	242.49	138.21	143.99	253.91	229.66	112.20	156.32	305.38	276.71	133.93	148.33	264.21	250.21	147.88	184.40	314.99	286.48	150.33	179.40	322.78	319.54	207.86	160.81	178.46	346.53	324.52	170.64	253.14	428.94	340.97	145.30	157.91	318.46	323.49	158.68	157.43	320.52	316.25	148.31	171.96	348.87	313.59	134.89	180.51	370.18	303.79	216.26	NA
Gross Profit_6m	54.78	140.71	158.18	82.64	60.01	120.48	152.80	90.81	79.96	124.96	106.82	57.99	63.53	112.06	91.39	33.12	56.19	120.70	98.61	32.09	53.27	103.26	92.27	50.90	61.88	100.70	95.50	63.74	82.12	NA	NA	94.93	75.98	88.32	161.47	143.62	74.67	94.33	153.69	132.56	61.38	62.50	130.33	93.63	25.62	72.86	146.19	143.60	70.46	72.07	154.17	150.76	69.36	89.80	176.49	145.19	84.96	NA
Research and development_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Sales general and administrative costs_6m	91.45	93.66	79.34	70.59	80.10	82.43	75.10	67.58	77.77	85.30	68.26	58.90	69.72	77.86	61.62	57.00	18.20	30.45	78.46	69.14	77.86	86.77	83.93	98.37	114.28	111.65	103.82	93.57	100.24	115.02	NA	NA	90.90	101.47	116.17	102.00	81.88	112.02	123.36	93.56	81.12	93.30	106.56	98.27	93.75	109.20	121.40	106.21	89.77	97.93	110.55	98.69	82.15	93.62	113.94	99.79	97.17	NA
Other Non Operating Income (Loss) Net_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	-21.32	NA	NA	0.00	NA	NA	0.00	0.00	-9.19	-9.19	0.00	0.00	NA	NA	0.00	0.00	NA	NA	0.00	NA	NA
Operating Income_6m	-36.66	47.06	78.85	12.05	-20.10	38.04	77.40	22.93	2.20	39.67	38.56	-0.90	0.51	40.74	27.76	-25.74	-20.44	31.21	17.01	-42.69	-32.08	12.00	7.90	-47.80	-51.70	-23.79	-21.86	-29.83	-18.11	NA	NA	34.41	-14.92	-6.19	52.26	41.62	-7.21	3.63	51.64	38.99	-19.74	-26.05	28.52	-4.64	-68.13	-27.15	33.99	37.41	-19.30	-19.09	50.39	52.07	-12.79	-3.82	62.55	45.40	-119.29	NA
Interest Income_6m	1.14	1.14	0.47	0.21	0.18	0.12	0.07	0.01	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.01	0.03	0.04	0.04	0.05	0.05	0.04	0.03	0.02	0.02	0.02	0.02	0.01	0.00	0.01	NA	NA	0.04	0.03	0.03	0.04	0.04	0.04	0.05	0.06	0.06	0.06	0.12	0.22	0.20	0.13	0.16	0.41	0.51	0.28	0.18	0.22	0.22	0.18	0.18	0.18	0.16	NA
Interest Expense_6m	0.85	2.15	2.74	4.30	5.29	6.64	6.69	4.54	4.40	4.86	7.03	9.25	9.79	10.48	11.11	11.09	10.93	10.00	7.54	5.94	6.03	6.11	5.30	4.14	4.27	4.36	4.57	5.47	6.44	6.53	NA	NA	6.45	6.44	6.32	6.22	6.08	6.27	7.27	6.95	5.19	4.95	5.04	4.36	4.91	5.99	5.16	4.06	4.08	4.11	4.13	4.08	4.06	3.02	2.53	3.65	4.08	NA
Other income (expense) Net_6m	-1.18	-0.21	7.48	6.58	-2.65	5.26	0.87	-5.67	4.49	1.35	10.02	28.97	18.03	1.45	7.48	-2.12	-6.30	17.12	13.91	2.60	1.08	-1.93	1.43	3.07	2.89	8.84	6.59	-0.31	-0.09	-34.70	0.87	34.61	-1.01	-2.35	39.27	35.38	-13.32	-2.68	44.32	31.98	-24.99	-31.06	23.36	-9.22	-73.25	-33.28	28.67	32.94	-23.88	-23.47	46.07	47.75	-17.08	-7.02	59.84	41.57	-123.53	NA
Income Before Income Tax_6m	-37.47	43.98	68.16	0.96	-22.92	26.03	69.79	24.05	-6.70	33.46	21.51	-39.12	-27.31	28.81	9.16	-34.72	-25.09	4.06	-4.47	-51.27	-39.24	7.78	1.15	-55.03	-58.89	-37.01	-33.02	-35.00	-24.47	25.77	NA	NA	-20.39	-10.30	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Provision for (benefit) Income Tax_6m	-12.37	6.74	13.86	0.10	-55.71	-42.76	12.90	1.75	0.36	0.24	0.20	-0.01	0.54	0.18	0.00	0.55	0.83	1.57	1.61	0.35	1.00	3.19	4.04	-0.25	-1.62	1.64	0.59	-0.03	2.21	2.99	NA	NA	1.13	0.74	1.69	2.69	1.74	1.61	2.92	3.02	0.80	1.70	2.46	0.14	0.16	85.59	91.27	6.05	-5.12	-23.16	-4.71	15.11	-4.29	-4.99	10.92	5.66	-26.78	NA
Net Income (loss) (continous operations)_6m	-25.09	37.25	54.30	0.86	32.79	68.79	56.89	22.30	-7.06	33.23	21.32	-39.11	-27.59	28.89	9.16	-35.27	-25.84	2.57	-6.07	-51.61	-39.74	5.09	-2.89	-54.78	-66.68	-48.06	-34.26	-34.97	-26.03	22.78	NA	NA	-21.52	-26.77	36.47	40.13	-13.31	-4.78	46.87	31.39	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA

Cash Flow Statement

# Calculation Trailing month
df_std_CF_6TM <- calculate_trailing_months(df_std_CF,6)

# Define the order of columns of the transposed dataframe
order_df <- colnames(df_std_CF_6TM) %>% as.data.frame()

# Transpose the Income Statement into standardized format
df_std_CF_6TM_t <- transpose_df(df_std_CF_6TM, order_df)

# Format numeric columns to 2 decimal places
df_std_CF_6TM_t <- df_std_CF_6TM_t %>%
  mutate(across(where(is.numeric), ~ round(.x,2) ))

# Print the standardized Income Statement in standardized format
df_std_CF_6TM_t %>% 
  kable( "html") %>%
  kable_styling(full_width = FALSE) %>%
  column_spec(1, width = "30em", extra_css = "white-space: nowrap;")

Financial Item	2024-03-31	2023-12-31	2023-09-30	2023-06-30	2023-03-31	2022-12-31	2022-09-30	2022-06-30	2022-03-31	2021-12-31	2021-09-30	2021-06-30	2021-03-31	2020-12-31	2020-09-30	2020-06-30	2020-03-31	2019-12-31	2019-09-30	2019-06-30	2019-03-31	2018-12-31	2018-09-30	2018-06-30	2018-03-31	2017-12-31	2017-09-30	2017-06-30	2017-03-31	2016-12-31	2016-09-30	2016-06-30	2016-03-31	2015-12-31	2015-09-30	2015-06-30	2015-03-31	2014-12-31	2014-09-30	2014-06-30	2014-06-09	2014-03-31	2013-12-31	2013-09-30	2013-06-30	2013-03-31	2012-12-31	2012-09-30	2012-06-30	2012-03-31	2011-12-31	2011-09-30	2011-06-30	2011-03-31	2010-12-31	2010-09-30	2010-06-30	2009-12-31
(Operating Activities) Cash Flow Depreciation, Depletion, Ammortization_6m	4.04	5.17	5.22	3.78	3.60	6.94	7.76	5.54	4.40	6.89	8.28	5.78	2.02	4.15	9.69	8.92	-1.02	9.22	22.48	14.95	12.65	19.31	21.79	14.85	11.37	21.78	28.07	20.23	20.85	28.50	25.72	17.38	17.35	24.04	22.37	13.69	11.75	22.93	25.91	NA	NA	18.56	30.84	27.42	15.18	11.67	30.49	35.40	15.66	16.40	21.73	16.73	9.81	16.03	24.17	17.42	14.39	NA
(Operating Activities) Change in Accounts Receivable_6m	-126.01	-8.14	122.19	29.90	-119.43	-61.22	101.53	16.84	-106.01	39.59	129.43	4.16	-88.08	34.45	104.05	-48.52	-135.99	33.94	133.69	-37.41	-139.66	19.11	109.22	-29.71	-115.60	40.89	136.63	-60.23	-173.77	40.70	186.78	-30.50	-207.39	46.24	188.54	-117.37	-200.02	125.18	238.98	NA	NA	-192.60	6.31	192.98	-10.54	-177.65	-19.21	181.16	17.96	-190.25	-14.67	182.25	-13.14	-229.93	19.62	170.97	-17.95	NA
(Operating Activities) Change in Inventory_6m	-22.49	-12.41	4.84	-15.56	-45.18	-43.04	23.87	39.71	-4.49	23.38	53.15	21.94	-17.93	-19.04	6.35	3.42	-17.07	0.74	20.62	-0.36	-19.77	-8.28	10.45	3.73	-26.14	-22.79	12.67	5.78	-7.60	3.97	21.60	10.93	-27.93	-31.34	1.93	13.06	-9.30	13.68	46.57	NA	NA	-16.92	-9.90	7.06	-3.02	-21.18	-3.11	26.23	13.78	-11.61	-9.01	10.68	12.03	-15.30	-4.16	19.53	-6.25	NA
(Operating Activities) Change in Prepaid expenses and other assets_6m	10.83	-4.91	-6.14	4.92	1.76	-8.29	-6.53	3.54	5.04	-21.65	-11.02	14.33	-3.29	-17.86	-7.27	-2.14	-0.78	-5.89	-8.86	12.08	0.82	-8.84	5.84	19.84	18.65	-9.51	-15.49	12.34	-18.00	-34.02	-5.29	-4.00	2.09	-3.42	1.26	10.93	0.48	-9.53	-2.89	NA	NA	8.94	0.10	-9.27	6.26	3.40	-14.07	-7.31	2.27	2.72	-15.11	-8.16	12.18	11.00	-4.18	-8.13	0.96	NA
(Operating Activities) Change in Accounts Payable_6m	-81.17	-20.25	85.33	31.76	-67.60	-84.62	52.07	61.15	-53.51	-13.41	60.98	26.87	-57.00	-5.53	71.95	-9.24	-112.94	-1.91	107.80	6.78	-112.93	-8.98	103.94	18.50	-57.83	-15.70	66.78	15.32	-70.53	-21.77	70.59	32.33	-68.27	-24.15	70.35	3.11	-91.84	-4.89	94.28	NA	NA	-68.83	-30.76	59.76	18.24	-75.51	-27.41	84.99	39.58	-74.41	-35.90	63.32	19.20	-97.76	-21.54	74.05	3.19	NA
(Operating Activities) Change in Accounts Taxes Payable_6m	-17.12	-1.75	11.24	-2.31	-4.97	8.54	12.73	1.33	0.57	0.30	-0.27	-0.51	-1.45	-0.56	0.75	-2.07	0.35	2.58	0.00	0.01	0.46	0.46	-0.33	-0.26	0.14	0.06	-0.53	NA	NA	-22.01	1.17	0.98	-3.06	-4.24	0.51	1.22	-1.68	0.39	4.16	NA	NA	2.77	0.67	-1.63	5.09	2.96	4.94	7.36	5.26	-14.41	-7.00	14.26	2.73	-9.19	-6.14	4.32	1.48	NA
(Operating Activities) Change in Reserve for Sales Return and allowances_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Operating Activities) Deferred Income Tax_6m	NA	NA	NA	NA	NA	-57.86	NA	NA	NA	-0.07	NA	NA	NA	NA	NA	NA	NA	-0.98	NA	NA	NA	0.21	NA	NA	NA	-1.25	NA	NA	NA	-0.26	0.07	0.01	-0.34	NA	NA	NA	NA	NA	NA	NA	NA	-1.25	NA	NA	NA	NA	82.75	0.24	-0.35	-7.98	-0.32	7.42	-0.31	15.17	-4.04	-22.58	-25.23	NA
(Operating Activities) Stock-based Compensation_6m	4.64	4.05	3.85	3.95	3.74	2.80	2.31	2.03	1.58	1.17	0.84	0.76	1.18	1.30	1.21	0.96	1.25	1.86	1.26	1.02	1.31	1.45	1.07	0.98	1.53	1.65	1.50	1.46	1.12	0.54	0.63	1.08	0.73	0.62	0.95	0.94	0.98	0.84	0.72	NA	NA	0.80	0.69	0.35	0.39	0.14	0.31	0.85	0.81	0.39	0.48	0.70	1.12	1.63	2.31	2.57	2.13	NA
(Operating Activities) Cash Flow from Operating Activities_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	6.21	-1.84	-16.13	13.24	47.31	-1.99	-54.04	18.71	90.31	15.55	-29.92	50.25	64.95	-46.39	-94.13	NA	NA	-16.66	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Property, Plant and Equipment_6m	5.42	3.99	2.23	4.92	5.79	5.11	6.27	5.28	3.67	4.50	4.90	3.72	3.57	3.94	4.59	4.33	3.37	4.21	5.17	5.21	4.68	5.26	6.98	6.51	7.03	7.31	6.09	7.61	7.90	8.66	7.42	6.11	7.31	6.66	11.27	11.18	4.89	3.63	7.52	NA	NA	3.36	4.22	5.99	5.91	3.23	5.48	8.59	7.58	4.05	3.82	8.40	8.63	5.21	5.03	6.33	7.37	NA
(Investing Activities) Proceeds from Asset Sales_6m	0.04	0.04	-0.02	0.00	0.02	0.00	0.05	0.05	0.00	0.00	0.01	0.07	-0.11	-0.18	0.11	0.12	-0.01	0.00	0.01	0.06	0.05	0.07	0.11	0.03	0.05	0.05	0.02	0.02	-0.01	NA	NA	NA	-0.07	-0.07	0.01	NA	NA	0.00	-0.03	NA	NA	-0.85	-0.86	-1.10	NA	NA	-0.04	0.00	-0.02	-0.47	-0.45	-0.04	-0.01	-0.08	-0.11	0.02	-0.81	NA
(Investing Activities) Purchase of Businesses_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Purchase of Marketable Securities and Investment_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	0.00	NA	NA	0.00	0.00	NA	NA	0.00	0.00	0.00	0.00	0.00	0.00	0.00	NA
(Investing Activities) Proceeds from sale or maturity of Marketable Securities and Investment_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.07	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Proceeds from maturities of Marketable Securities and Investment_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Investing Activities) Cash Flow from Investing Activities_6m	-6.86	-4.01	-2.20	-4.89	-5.77	-5.11	-6.27	-5.28	-3.67	-4.50	-4.89	-3.69	-3.52	-3.92	-4.53	-4.26	-3.37	-4.20	-5.16	-5.21	-4.66	-5.13	-6.87	-6.51	-6.91	-7.19	-6.64	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-3.21	-5.54	-4.47	-5.22	-13.91	-61.54	-56.53	-11.20	-25.88	-22.45	-8.16	-13.85	-12.28	-3.47	-4.55	-12.48	NA
(Financing Activities) Proceeds from Issuance of Stock_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	9.66	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment for Repurchase of Stock_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	1.56	3.66	11.94	16.04	8.53	NA	NA	NA	8.00	32.00	48	NA	NA	NA	NA	NA	NA	26.67	NA	NA	NA	19.31	19.31	5.05	10.69	7.16	NA	NA	NA
(Financing Activities) Proceeds from Issuance of Debt_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Payment of Debt_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash for Dividends_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	0.00	1.54	3.09	3.71	4.35	4.79	5.19	5.18	3.45	NA	NA	NA	NA	NA	NA	NA
(Financing Activities) Cash Flow from Financing Activities_6m	-20.58	-1.86	-31.78	-70.43	-40.69	-19.52	-29.38	-11.51	-1.14	-0.34	-32.38	-32.45	-15.23	-15.07	4.30	4.13	-5.17	2.17	6.98	-7.94	-0.06	-5.49	5.37	8.38	-4.30	9.87	-11.41	-39.47	-22.03	0.47	-4.35	-15.41	-43.83	-13.20	17.84	-0.18	-23.91	-23.91	76.15	NA	NA	16.75	69.57	-26.70	-110.69	0.72	-14.19	-31.85	-5.19	-4.77	-24.21	-21.91	-4.85	-10.76	-10.39	-14.80	-5.93	NA
Effect of Exchange Rate on Cash & Cash Equivalent_6m	0.62	0.39	0.34	1.46	1.44	-1.72	-4.98	-2.81	-1.00	-0.82	-0.10	0.32	2.34	3.53	1.21	-1.55	-0.16	0.57	-0.47	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
Change in Cash, Cash Equivalents_6m	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	-12.93	NA	NA	NA	28.26	5.54	-73.44	-15.83	37.41	-8.04	-23.89	38.74	16.09	-91.58	-24.74	NA	NA	61.90	47.42	-113.84	-119.60	24.61	-32.32	-113.80	-35.61	22.31	10.41	-42.22	-31.50	55.87	29.59	-33.20	18.29	NA

Footnotes

1. For visualization purpose we have omitted from the printed table below the variables (columns) df_Facts$description and df_Facts$accn.