Balance Sheet Xero Limited

Equities

XRO

NZXROE0001S2

Software

Market Closed - Australian S.E. Other stock markets 12:10:21 2024-12-02 am EST			5-day change	1st Jan Change
174.55 ^AUD	+0.40%		+0.94%	+55.43%

Nov. 15	Xero Poised for More Upside After 'Strong' Fiscal H1 Results, Jarden Research Says	MT
Nov. 15	Jarden Research Adjusts Xero's Price Target to AU$177 from AU$151, Keeps at Overweight	MT

14afd70e5b76a.DIUvVB3YT9A24bddyIH-l1orEjmh9pYJWh6JevcNRgc.W-N2P1XsO6kDkPlv8crNujwdVHGWxdJdI1zYDrxeEkxd8XAxW-wAt3Wb4g

Published financial data: XERO LIMITED

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: March	2020	2021	2022	2023	2024
Revenues	696M	828M	1.05B	1.33B	1.63B
Other Revenues, Total	22.01M	20.68M	47.2M	73.61M	83.01M
Total Revenues	718M	849M	1.1B	1.4B	1.71B
Cost of Goods Sold, Total	107M	119M	139M	178M	203M
Gross Profit	612M	730M	957M	1.22B	1.51B
Selling General & Admin Expenses, Total	402M	414M	547M	640M	726M
R&D Expenses	178M	250M	372M	490M	526M
Other Operating Expenses	-2.85M	4.38M	7.79M	-	-
Other Operating Expenses, Total	577M	668M	927M	1.13B	1.25B
Operating Income	34.41M	61.69M	30.3M	91.98M	259M
Interest Expense, Total	-34.31M	-33.62M	-36.1M	-42.8M	-44.51M
Interest And Investment Income	13.43M	5.16M	4.08M	29.12M	67.48M
Net Interest Expenses	-20.88M	-28.46M	-32.02M	-13.68M	22.97M
Currency Exchange Gains (Loss)	-	-	-	-	-
Other Non Operating Income (Expenses)	-1.96M	-9.99M	-2.47M	-4.54M	8.4M
EBT, Excl. Unusual Items	11.56M	23.23M	-4.2M	73.77M	290M
Restructuring Charges	-	-	-	-34.69M	-3.01M
Merger & Related Restructuring Charges	-	-	-2.5M	-	-
Impairment of Goodwill	-	-	-20.38M	-94.9M	-
Asset Writedown	-1.43M	-	-4.31M	-27.78M	-24.48M
Other Unusual Items	-300K	-67.17M	33.76M	7.93M	-685K
EBT, Incl. Unusual Items	9.84M	-43.94M	2.36M	-75.68M	262M
Income Tax Expense	6.5M	-63.71M	11.48M	37.86M	87.27M
Earnings From Continuing Operations	3.34M	19.77M	-9.11M	-114M	175M
Net Income to Company	3.34M	19.77M	-9.11M	-114M	175M
Net Income - (IS)	3.34M	19.77M	-9.11M	-114M	175M
Preferred Dividend and Other Adjustments	44K	-	-	-	-
Net Income to Common Incl Extra Items	3.29M	19.77M	-9.11M	-114M	175M
Net Income to Common Excl. Extra Items	3.29M	19.77M	-9.11M	-114M	175M
Per Share Items
Net EPS - Basic	0.02	0.14	-0.06	-0.76	1.15
Basic EPS - Continuing Operations	0.02	0.14	-0.06	-0.76	1.15
Basic Weighted Average Shares Outstanding	141M	144M	148M	150M	151M
Net EPS - Diluted	0.02	-2.66	-0.06	-0.76	1.14
Diluted EPS - Continuing Operations	0.02	-2.66	-0.06	-0.76	1.14
Diluted Weighted Average Shares Outstanding	143M	150M	150M	150M	153M
Normalized Basic EPS	0.05	0.1	-0.02	0.31	1.2
Normalized Diluted EPS	0.05	0.1	-0.02	0.31	1.19
American Depositary Receipts Ratio (ADR)	0.2	0.2	0.2	0.2	0.2
Supplemental Items
EBITDA	46.47M	73.61M	44.22M	106M	272M
EBITA	36.05M	63.79M	33.23M	95.04M	262M
EBIT	34.41M	61.69M	30.3M	91.98M	259M
EBITDAR	52.24M	79.68M	53.5M	115M	281M
Total Revenues (As Reported)	718M	849M	1.1B	1.4B	1.71B
Effective Tax Rate - (Ratio)	66.09	145.01	485.7	-50.02	33.32
Total Current Taxes	9.2M	9.41M	10.09M	35.46M	26.06M
Total Deferred Taxes	-2.54M	-16.33M	20.74M	2.4M	61.21M
Normalized Net Income	7.23M	14.52M	-2.63M	46.1M	181M
Interest on Long-Term Debt	34.31M	33.62M	41.22M	42.8M	44.51M
Supplemental Operating Expense Items
Marketing Expenses	113M	92.59M	145M	167M	240M
Selling and Marketing Expenses	313M	308M	406M	472M	541M
General and Administrative Expenses	88.98M	106M	142M	168M	185M
Research And Development Expense From Footnotes	194M	266M	389M	530M	578M
Net Rental Expense, Total	5.77M	6.07M	9.28M	9.4M	9.04M
Imputed Operating Lease Interest Expense	3.38M	2.26M	2.72M	2.97M	2.72M
Imputed Operating Lease Depreciation	2.39M	3.82M	6.56M	6.42M	6.32M
Stock-Based Comp., Other (Total)	34.34M	42.73M	61.06M	80.86M	95.82M
Total Stock-Based Compensation	34.34M	42.73M	61.06M	80.86M	95.82M

Fiscal Period: March	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	108M	658M	404M	231M	499M
Short Term Investments	428M	453M	532M	887M	1.03B
Total Cash And Short Term Investments	536M	1.11B	936M	1.12B	1.53B
Accounts Receivable, Total	29.73M	33.2M	50M	54.93M	68.28M
Other Receivables	2.53M	1.83M	11.26M	14.59M	49.34M
Notes Receivable	-	-	-	-	-
Total Receivables	32.26M	35.03M	61.26M	69.52M	118M
Prepaid Expenses	22.62M	42.93M	43.7M	44.48M	70.2M
Other Current Assets, Total	128M	15.68M	30.73M	32.42M	29.76M
Total Current Assets	719M	1.2B	1.07B	1.26B	1.75B
Gross Property Plant And Equipment	130M	164M	221M	223M	222M
Accumulated Depreciation	-43.73M	-54.46M	-62.9M	-85.29M	-96.66M
Net Property Plant And Equipment	86.64M	109M	158M	138M	125M
Long-term Investments	-	-	-	-	-
Goodwill	78.77M	126M	420M	331M	336M
Other Intangibles, Total	263M	358M	539M	632M	648M
Deferred Tax Assets Long-Term	3.75M	103M	97.07M	92M	31.71M
Other Long-Term Assets, Total	2.54M	123M	56.85M	33.42M	62.87M
Total Assets	1.15B	2.02B	2.34B	2.49B	2.95B
Liabilities
Accounts Payable, Total	10.62M	13.39M	15.3M	17.82M	9.86M
Accrued Expenses, Total	78.04M	109M	123M	130M	179M
Short-term Borrowings	-	-	-	-	-
Current Portion of Long-Term Debt	-	2.6M	-	-	-
Current Portion of Leases	11.76M	10.58M	14.29M	17.26M	19.37M
Current Income Taxes Payable	2.68M	1.05M	936K	3.61M	2.76M
Unearned Revenue Current, Total	9.61M	13.11M	25.97M	27.96M	41.19M
Other Current Liabilities	3.43M	18.7M	17.11M	58.33M	11.84M
Total Current Liabilities	116M	169M	196M	255M	264M
Long-Term Debt	425M	854M	885M	1.02B	1.11B
Long-Term Leases	60.87M	83.95M	122M	106M	96.97M
Deferred Tax Liability Non Current	1.11M	6.3M	13.38M	12.86M	13.11M
Other Non Current Liabilities	129M	165M	92.78M	42.37M	76.53M
Total Liabilities	731M	1.28B	1.31B	1.44B	1.56B
Common Stock, Total	687M	1.3B	1.58B	1.7B	1.85B
Retained Earnings	-341M	-321M	-330M	-443M	-269M
Treasury Stock	-9.8M	-1.89M	-	-	-
Comprehensive Income and Other	85.36M	-227M	-213M	-206M	-186M
Total Common Equity	422M	746M	1.03B	1.05B	1.39B
Total Equity	422M	746M	1.03B	1.05B	1.39B
Total Liabilities And Equity	1.15B	2.02B	2.34B	2.49B	2.95B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	142M	148M	149M	151M	152M
ECS Total Common Shares Outstanding	142M	147M	149M	151M	152M
Book Value / Share	2.98	5.08	6.92	6.98	9.15
Tangible Book Value	80.12M	262M	74.57M	90.87M	409M
Tangible Book Value Per Share	0.57	1.78	0.5	0.6	2.68
Total Debt	497M	951M	1.02B	1.14B	1.22B
Net Debt	-38.87M	-159M	85M	26.03M	-306M
Debt Equivalent Oper. Leases	46.14M	48.58M	74.26M	75.16M	72.29M
Account Code - Inventory Valuation	3	3	3	3	3
Machinery, Total	26.98M	24.32M	26M	25.81M	24.17M
Full Time Employees	3.06K	3.64K	4.78K	5.08K	4.32K
Accumulated Allowance for Doubtful Accounts (Supple)	633K	402K	1.29M	954K	1.28M

Fiscal Period: March	2020	2021	2022	2023	2024
Net Income	3.34M	19.77M	-9.11M	-114M	175M
Depreciation & Amortization - CF	23.04M	24.93M	27.85M	30.1M	31.18M
Amortization of Goodwill and Intangible Assets - (CF)	1.64M	2.1M	2.94M	3.05M	2.82M
Depreciation & Amortization, Total	24.67M	27.03M	30.79M	33.15M	33.99M
Amortization of Deferred Charges, Total - (CF)	97.41M	124M	175M	221M	261M
(Gain) Loss From Sale Of Asset	-	-	-	-	-
Asset Writedown & Restructuring Costs	1.43M	-	24.7M	123M	24.48M
Stock-Based Compensation (CF)	34.34M	42.73M	61.06M	80.86M	95.82M
Provision and Write-off of Bad Debts	1.97M	1.33M	2.43M	4.36M	5.54M
Other Operating Activities, Total	-4.97M	22.02M	-43.71M	-5.89M	15.2M
Change In Accounts Receivable	-5.83M	-34.05M	-16.1M	2.82M	-51.27M
Change In Accounts Payable	6.4M	-23.88M	11.88M	-3.95M	26.8M
Change in Unearned Revenues	1.92M	3.51M	3.96M	1.16M	11.96M
Change In Income Taxes	721K	-2.57M	-7.36M	7.36M	-28.88M
Change In Deferred Taxes	-	-	-	-	60.5M
Change in Other Net Operating Assets	5.24M	38.46M	3.14M	40.76M	-37.54M
Cash from Operations	167M	219M	236M	390M	592M
Capital Expenditure	-13.87M	-10.56M	-19.03M	-6.75M	-6.59M
Sale of Property, Plant, and Equipment	-	-	-	-	-
Cash Acquisitions	-	-36.28M	-185M	-15.88M	-8.66M
Divestitures	-	-	-	-	9.55M
Sale (Purchase) of Intangible assets	-125M	-151M	-222M	-279M	-242M
Other Investing Activities, Total	-674K	-230K	-3.9M	-3.18M	5.64M
Cash from Investing	-140M	-198M	-430M	-305M	-242M
Short Term Debt Issued, Total	-	814K	4.28M	-	-
Long-Term Debt Issued, Total	504K	976M	-	2.15M	-
Total Debt Issued	504K	977M	4.28M	2.15M	-
Short Term Debt Repaid, Total	-	-	-2.43M	-	-
Long-Term Debt Repaid, Total	-13.42M	-427M	-19.05M	-21.44M	-17.91M
Total Debt Repaid	-13.42M	-427M	-21.49M	-21.44M	-17.91M
Issuance of Common Stock	12.43M	31.88M	35.98M	31.71M	39.61M
Other Financing Activities, Total	-51.19M	-37.35M	-80.3M	-316M	-115M
Cash from Financing	-51.67M	544M	-61.52M	-303M	-93.26M
Foreign Exchange Rate Adjustments	11.06M	-15.31M	1.54M	43.97M	11.68M
Net Change in Cash	-13.5M	550M	-254M	-174M	268M
Supplemental Items
Cash Interest Paid	19.46M	19.09M	8.72M	9.27M	8.49M
Cash Income Tax Paid (Refund)	8.39M	11.48M	20.24M	11.3M	46.55M
Levered Free Cash Flow	-25.69M	190M	6.69M	124M	211M
Unlevered Free Cash Flow	-21.27M	189M	-5.54M	116M	203M
Change In Net Working Capital	43.32M	-140M	15.5M	-44.88M	64.25M
Net Debt Issued / Repaid	-12.91M	550M	-17.21M	-19.29M	-17.91M

Fiscal Period: March	2020	2021	2022	2023	2024
Profitability
Return on Assets	2.02	2.43	0.87	2.38	5.94
Return on Total Capital	2.51	2.95	1.01	2.7	6.72
Return On Equity %	0.86	3.38	-1.02	-10.88	14.27
Return on Common Equity	0.85	3.38	-1.02	-10.88	14.27
Margin Analysis
Gross Profit Margin %	85.16	85.99	87.29	87.29	88.18
SG&A Margin	55.95	48.81	49.9	45.71	42.38
EBITDA Margin %	6.47	8.67	4.03	7.55	15.89
EBITA Margin %	5.02	7.52	3.03	6.79	15.26
EBIT Margin %	4.79	7.27	2.76	6.57	15.1
Income From Continuing Operations Margin %	0.46	2.33	-0.83	-8.11	10.19
Net Income Margin %	0.46	2.33	-0.83	-8.11	10.19
Net Avail. For Common Margin %	0.46	2.33	-0.83	-8.11	10.19
Normalized Net Income Margin	1.01	1.71	-0.24	3.29	10.58
Levered Free Cash Flow Margin	-3.58	22.41	0.61	8.89	12.34
Unlevered Free Cash Flow Margin	-2.96	22.32	-0.5	8.26	11.82
Asset Turnover
Asset Turnover	0.68	0.53	0.5	0.58	0.63
Fixed Assets Turnover	8.06	8.66	8.2	9.45	13.02
Receivables Turnover (Average Receivables)	23.91	26.32	25.23	25.28	26.47
Short Term Liquidity
Current Ratio	6.19	7.13	5.45	4.95	6.62
Quick Ratio	4.89	6.79	5.08	4.65	6.24
Operating Cash Flow to Current Liabilities	1.43	1.3	1.2	1.53	2.24
Days Sales Outstanding (Average Receivables)	15.31	13.87	14.47	14.44	13.83
Average Days Payable Outstanding	28	36.84	37.55	33.96	25.02
Long Term Solvency
Total Debt/Equity	117.72	127.52	98.76	108.47	87.88
Total Debt / Total Capital	54.07	56.05	49.69	52.03	46.77
LT Debt/Equity	114.94	125.75	97.37	106.84	86.49
Long-Term Debt / Total Capital	52.79	55.27	48.99	51.25	46.03
Total Liabilities / Total Assets	63.39	63.15	55.88	57.68	52.8
EBIT / Interest Expense	1	1.83	0.84	2.15	5.81
EBITDA / Interest Expense	1.72	2.64	1.69	2.92	6.58
(EBITDA - Capex) / Interest Expense	1.32	2.32	1.16	2.77	6.43
Total Debt / EBITDA	8.42	10.72	16.71	9.14	4.18
Net Debt / EBITDA	-0.66	-1.8	1.39	0.21	-1.04
Total Debt / (EBITDA - Capex)	11	12.17	24.28	9.66	4.28
Net Debt / (EBITDA - Capex)	-0.86	-2.04	2.02	0.22	-1.07
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	29.92	18.18	29.22	27.63	22.42
Gross Profit, 1 Yr. Growth %	32.42	19.33	31.17	27.63	23.68
EBITDA, 1 Yr. Growth %	153.75	59.44	-43.02	113.52	157.64
EBITA, 1 Yr. Growth %	223.83	78.46	-50.98	146.71	175.2
EBIT, 1 Yr. Growth %	246.62	80.85	-53.88	158.52	181.27
Earnings From Cont. Operations, 1 Yr. Growth %	-112.29	492.75	-146.09	1.15K	-253.82
Net Income, 1 Yr. Growth %	-112.29	492.75	-146.09	1.15K	-253.82
Normalized Net Income, 1 Yr. Growth %	-355.16	106.26	-115.44	-1.2K	293.25
Diluted EPS Before Extra, 1 Yr. Growth %	-110.26	-13.41K	-97.69	1.13K	-250
Accounts Receivable, 1 Yr. Growth %	4.26	11.66	50.62	9.85	24.31
Net Property, Plant and Equip., 1 Yr. Growth %	-5.3	26.22	44.77	-12.77	-9.32
Total Assets, 1 Yr. Growth %	18.9	75.44	15.78	6.27	18.52
Tangible Book Value, 1 Yr. Growth %