You are right @ShareCat to be concerned if a cloud-based SaaS business like Xero had a net debt to equity ratio (gearing) of over 100%. Luckily, as we have established, Xero does not. They have net cash. That's a good place to be for a company that does not have much in the way of tangible assets (an asset-light business).
However, as I said at the top of my previous post above (in this thread), some companies CAN sustain those sort of debt levels. Transurban (TCL) had gearing of 212.8% at 30-Jun-2020 and Sydney Airport (SYD) had gearing of 782.9% at 31-Dec-2020. APA Group (APA), who own and operate a network of gas pipelines and other associated assets, had gearing of 304.5% at 30-Jun-2020. These companies all own a huge amount of infrastucture (toll roads, an airport, gas transmission pipelines, etc.) that all produce a lot of income and will continue to do so for many years to come, and those income-producing assets underpin the long-term debt, and the debt is locked in over long periods at low rates of interest. The debt was used to purchase the assets which provides the income to pay off the debt over time. It's similar to an investment property that has tennants in it paying rent which pays off the mortgage on the property. If John Smith owned 10 or 20 investment properties instead of 1, it doesn't mean that he is at a much higher risk of going broke due to the massive amount of money he owes on all of those properties, because the tennants are providing the income to John to enable him to meet all of those debt repayments, with some change. The market is happy to overlook high debt levels with such companies, for those reasons.
Those figures come from Commsec, and we have already established that Commsec's data provider is not entirely infallible - seeing as they got XRO's gearing number for FY2020 so wrong. However, these numbers for SYD, TCL & APA all seem to be in the ballpark, as the following website shows - for SYD: https://au.investing.com/equities/sydney-airport-holdings-ratios
If you click on that link and then scroll down, you'll see the Total Debt to Equity Ratio given first for SYD (768.55%) and then for their industry (388.85%). From that, we can see that the average total debt to equity for companies in the Transport sector is 388.85% according to investing.com. And by using this webpage we can see APA has a Total Debt to Equity Ratio of 307.17% according to investing.com and the average Total Debt to Equity Ratio of companies in their sector, the Natural Gas Utilities Sector, is 220.25%.
Other sites I've checked have similar numbers. Even Telstra (TLS) has high debt levels, with Net Gearing of 123% according to Commsec and a Total Debt to Equity Ratio of 127.32% according to investing.com.
If the company is big enough and has enough income-producing assets, the market is actually quite comfortable generally with high debt levels. In fact, such companies are often said to have a "lazy balance sheet" if they have NOT geared up and bought assets with borrowed money. The argument is that if they CAN borrow the money, and if they can use it to buy assets that will generate reliable and consistent profits well in excess of the interest payable on the debt, then it makes sense to do it. Again, the same argument is often used to justify individuals buying additional investment properties. The asset produces income that covers the debt repayments, including the interest, and you end up with assets that pay for themselves over time.
So, it's horses for courses. Xero is not such a company. They do NOT own billions of dollars of tangible assets, like SYD, TCL, APA and TLS do, and the market would understandably be far less tolerant of high debt levels with a cloud-based software services provider like Xero.
So all that is to say that it is best not to just set a number (X%) and say that any company with an ND/E ratio greater than X% is a bad risk and should be avoided, because it really does depend on the company and the sector in which they operate, and most importantly what they have used that debt to purchase, and whether those assets are going to produce reliable and dependable income for them for decades, or not.