Friday, April 3, 2020
A Q&A on Using Calcbench Data for Corporate Reporting

Wednesday, April 1, 2020
Coronavirus and Lines of Credit

Monday, March 30, 2020
Some Recent Coronavirus Disclosures

Thursday, March 26, 2020
GILTI Tax Data: Yeah, We Got That

Monday, March 23, 2020
Exec Comp: Another Interesting Trend

Thursday, March 19, 2020
Trends in Executive Comp, 2010-2018

Wednesday, March 18, 2020
Another Look at Strength of Balance Sheets

Wednesday, March 11, 2020
Studying Debt Levels

Wednesday, March 4, 2020
A Q&A on Using Calcbench Data for Academic Research

Monday, March 2, 2020
Calcbench Talkin’ Shop!

Thursday, February 27, 2020
A Broader Look at Coronavirus Risk

Thursday, February 20, 2020
Yum Brands and Coronovirus Damage

Wednesday, February 12, 2020
Another Calcbench Use Case: Benchmarking DPO Changes

Tuesday, February 11, 2020
Updated Calcbench Excel Add-In

Monday, February 10, 2020
Hot Take on Cooling PPE Outlays

Monday, February 3, 2020
A Brief History of Juul Impairment Charges

Thursday, January 30, 2020
Research Note: Impairment of Leased Assets

Tuesday, January 28, 2020
Tracking Coronavirus Risk, Disclosures

Thursday, January 23, 2020
How to Find a Material Weakness

Sunday, January 19, 2020
Calcbench Tip: Email Alerts

Archive  |  Search:
Studying Debt Levels
Wednesday, March 11, 2020

Coronavirus has put Wall Street through a tornado of volatility this week. That’s going to drive up the importance of astute financial analysis, as people examine the balance sheets and cash-flows of airlines, hotels, travel businesses, and other firms affected by the virus.

Calcbench has many ways to study those things. Today we want to focus on one item crucial to that analysis: debt.

After all, for the hardest-hit companies, liquidity could become an issue within the next quarter or two. Stockpiles of cash can be great, but if a firm only has lots of cash because it did a bond issue a few years ago and those payments are coming due — that’s less great. It’s about what bills are coming due soon, and where you can access cash to meet those obligations.

We decided to poke around annual filings of the airline industry to get a sense of things.

You can find a company’s disclosures about debt by going to our Interactive Disclosures page, pulling up their most recent filing (for most airlines right now, that’s their Form 10-K for 2019), and selecting the “Debt” option from our pull-down menu of disclosures on the left side of the page.

We started with JetBlue $JBLU. The company reported $1.99 billion in long-term debt and finance lease obligations for 2019, up 46 percent from $1.36 billion the year prior. Most of that debt is long-term notes due anywhere from 2023 to 2036, with interest rates from 2.8 to 4.9 percent. See Figure 1, below.

JetBlue also reports the amount of long-term debt maturing in each of the next five years, plus all future debt thereafter. See Figure 2, below.

You might be thinking, “Wait — those annual debt maturities add up to $2.334 billion, not the $1.99 billion you just mentioned. What gives?” That’s because the annual breakdown includes $344 million in current debt. Subtract that amount from $2.334 billion and you land at $1.99 billion.

Those points of data are a good start, but you might also want to see how these line items compare to JetBlue’s peers. You can do that by using the Multi-Company page to compare JetBlue to its peers for those specific line items.

We held our cursor over the $2.352 billion to see the exact XBRL tag JetBlue used for this item: LongTermDebtAndCapitalLeaseObligations. Then we copied that tag to search for it in the Multi-Company page.

Figure 3, below, shows the results for eight airlines.

From there you can start to do some quick analysis, perhaps exporting to models in Excel you already have. But for example, we can see that long-term debt is a significantly larger portion of American Airlines’ $AAL liabilities (35.7 percent of total liabilities, versus 28 percent for JetBlue), while American’s assets are actually less than liabilities. At least for JetBlue, assets equal 167 percent of liabilities.

Meanwhile, we can also see that Southwest’s $LUV long-term debt is only 11.5 percent of total liabilities, and assets equal 161 percent of liabilities.

So with a few keystrokes, you can quickly start to find critical data about long-term debt totals and maturity dates; and how those numbers for one company compare to those of its peers.

We’ll be doing much more on ways to analyze the strength of balance sheet and operations as the economic uncertainty continues. Suffice to say that if the data is getting reported somehow, Calcbench has it, along with the database tools to find it.

FREE Calcbench Premium
Two Week Trial

Research Financial & Accounting Data Like Never Before. More features and try our Excel add-in. Sign up now to try the Premium Suite.