Skip to content

Student page · Grades 9–12

Capstone: a debt and cash profile of ___

You will make a debt and cash profile of one company: what it owes, what it holds, why it borrowed, what its interest costs and when its debt comes due. Every number needs its filing and its date.

For learning only. Cityfort is not a registered investment adviser or broker-dealer and does not recommend buying or selling any security. Prices shown are dated and may be out of date.

What to do

  1. Choose one company from the cards below.
  2. Fill in the research log on your worksheet from the card.
  3. Find one more fact in the company's 10-K or 10-Q (links on each card), for example a part the card leaves blank.
  4. Make a one-page profile, a poster or a 3-slide talk, using the template.

The rules

  • Every number has its date or fiscal year next to it.
  • Every fact names its source: the card, or the filing with its section.
  • Describe. Do not call the company safe, risky, strong or weak, and say nothing about its shares.
  • No ranking words such as "best" or "worst."

Card: Apple (fiscal year ends late September)

  • Sep 26, 2026: debt $80,111 million; cash and marketable securities $136,935 million; net cash $56.8 billion.
  • Borrowing: $7.5 billion of notes issued Nov 9, 2026; the offering lists general corporate purposes, which may include share repurchases, dividends, working capital, capital expenditures, acquisitions and repaying debt.
  • Interest coverage: not shown; Apple's FY2026 10-K does not show interest expense separately.
  • Equity: $112,093 million, above zero.
  • Find in the filing: what comes due in the next year (the debt note).
  • Apple's Form 10-K for fiscal 2026 on sec.gov

Card: Alphabet (fiscal year ends Dec 31)

  • Sep 30, 2026: debt $126,118 million; cash and marketable securities $265,098 million; net cash $139.0 billion. $90.4 billion of the cash figure was shares in other companies.
  • Borrowing: debt rose from $48.5 billion on Dec 31, 2025 to $126.1 billion on Sep 30, 2026.
  • Equity: $677,549 million, above zero.
  • Find in the filing: interest expense and what comes due in the next year.
  • Alphabet's Form 10-Q for the third quarter of 2026 on sec.gov

Card: AT&T (fiscal year ends Dec 31)

  • Sep 30, 2026: debt $159,627 million; cash $10,767 million; net debt $148,860 million, about 3.7 years of operating cash flow (Cityfort calculation).
  • Borrowing: in the first nine months of 2026 it paid $22,650 million for EchoStar spectrum and $5,756 million for Lumen's fiber business.
  • Due soon: $9,483 million within one year; a $12,000 million credit line was undrawn.
  • Equity: $122,754 million, above zero, including $15,979 million of outside partners' interests.
  • AT&T's Form 10-Q for the third quarter of 2026 on sec.gov

Card: Boeing (fiscal year ends Dec 31)

  • Sep 30, 2026: debt $45,920 million; cash and short-term investments $20,714 million; net debt $25,206 million. Debt was $54,098 million on Dec 31, 2025.
  • Interest coverage: left blank on its page. FY2025 operating earnings were 1.54 times interest of $2,771 million, but only with $9,672 million of gains on selling businesses.
  • Equity: $6,547 million on Sep 30, 2026, after a deficit at every year end from 2021 to 2024.
  • Liquidity: undrawn credit lines of $10.0 billion.
  • Boeing's Form 10-Q for the third quarter of 2026 on sec.gov

Card: Oracle (fiscal year ends May 31)

  • Aug 31, 2026: notes and other borrowings $125.3 billion; cash and marketable securities $37.1 billion; net debt $88.3 billion.
  • Borrowing: capital spending $55,663 million in FY2026, against cash from operations of $31,977 million.
  • Due: $7.2 billion in FY2027 and $10.1 billion in FY2028, with $90.3 billion due after FY2031 (as of May 31, 2026).
  • Equity: $67.2 billion on Aug 31, 2026, up from $43.1 billion on May 31, 2026, mainly from $19.9 billion of new stock.
  • Oracle's Form 10-K for fiscal 2026 on sec.gov

Card: Delta (fiscal year ends Dec 31)

  • Sep 30, 2026: debt and finance leases $12,851 million; cash $3,787 million; net debt $9,064 million.
  • Interest coverage: about 8.6 times in FY2025 (operating income $5,822 million ÷ net interest $679 million).
  • Due soon: $2,981 million of current maturities on Sep 30, 2026; liquidity $6.9 billion.
  • Equity: $22,513 million, above zero.
  • Delta's Form 10-Q for the third quarter of 2026 on sec.gov

Card: American Airlines (fiscal year ends Dec 31)

  • Sep 30, 2026: debt and finance leases $29,635 million; cash and short-term investments $8,287 million; net debt $21,348 million.
  • Interest coverage: about 0.9 times in FY2025 (operating income $1,467 million ÷ net interest $1,716 million).
  • Due: $4,455 million of principal in 2027 and $7,324 million in 2028, by its FY2025 10-K; liquidity $11.8 billion on Sep 30, 2026.
  • Equity: a deficit of $4,224 million on Sep 30, 2026.
  • American Airlines' Form 10-K for 2025 on sec.gov

Card: McDonald's (fiscal year ends Dec 31)

  • Jun 30, 2026: debt $39,863 million; cash $822 million; net debt $39,041 million.
  • Interest coverage: about 7.8 times in FY2025 (Cityfort calculation).
  • Due: $3.2 billion in 2027; 97% of debt at fixed rates at Dec 31, 2025; a $4.0 billion credit line unused, running to June 2028.
  • Equity: a deficit of $1.0 billion on Jun 30, 2026. Treasury stock bought back at cost ($79.3 billion at Dec 31, 2025) exceeds retained earnings ($70.3 billion).
  • McDonald's Form 10-K for 2025 on sec.gov

Card: Starbucks (fiscal year ends late September)

  • Sep 27, 2026: debt $13,276.9 million, including $1.5 billion due within a year; cash and short-term investments $3,864.2 million; net debt $9.4 billion, down from $12.6 billion a year earlier.
  • Repaying: in May 2026 Starbucks bought back about $1.3 billion of its notes through tender offers, using China deal proceeds.
  • Interest coverage: about 6.9 times in FY2026 (Cityfort calculation).
  • Equity: a deficit of $7.7 billion on Sep 27, 2026; total liabilities have exceeded total assets every year since at least FY2021.
  • Starbucks's fiscal 2026 earnings release on sec.gov
  • Starbucks's Form 10-K for fiscal 2025 on sec.gov

Card: Home Depot (fiscal year ends late January or early February)

  • Aug 2, 2026: debt $52,896 million; cash $2,085 million; net debt $50,811 million.
  • Borrowing: total debt was $44.1 billion on Jan 28, 2024, before the SRS deal, and $55.8 billion on Feb 1, 2026. It repaid $2.8 billion of notes in the first half of FY2026.
  • Interest coverage: left blank on its page; EBITDA (a different measure) was 10.4 times interest expense in FY2025 (Cityfort calculation).
  • Equity: $16.6 billion on Aug 2, 2026, up from negative $1.7 billion on Jan 30, 2022; it has risen since buybacks paused in March 2024.
  • Home Depot's Form 10-Q for the second quarter of fiscal 2026 on sec.gov

Questions

  1. Did your company have net debt or net cash, and on what date?
  2. What does its filing say it borrowed for?
  3. Was its equity above or below zero, and why?

Word bank

Net debt:
Debt minus cash. Below zero, it is net cash.
Interest coverage:
Operating income ÷ interest expense for one year.
Maturity:
The date a loan or bond must be repaid.
Liquidity:
Cash and short-term investments plus unused credit lines.
Shareholders' equity:
Assets minus liabilities on one date.

Sentence starters

  • On ____ (date), ____ had $____ of debt and $____ of cash, so its net ____ was $____.
  • Its filing says it borrowed to ____.
  • In FY____, its operating income covered interest about ____ times.

Data from Apple's FY2026 Form 10-K, filed Nov 3, 2026; Alphabet's Q3 FY2026 Form 10-Q, filed Oct 29, 2026; AT&T's Q3 FY2026 Form 10-Q, filed Oct 21, 2026; Boeing's Q3 FY2026 Form 10-Q, filed Oct 27, 2026; Boeing's FY2025 Form 10-K, filed Jan 30, 2026; Oracle's FY2026 Form 10-K, filed Jun 22, 2026; Oracle's Q1 FY2027 Form 10-Q, filed Sep 11, 2026; Delta's FY2025 Form 10-K, filed Feb 11, 2026; Delta's Q3 FY2026 Form 10-Q, filed Oct 9, 2026; American Airlines's FY2025 Form 10-K, filed Feb 18, 2026; American Airlines's Q3 FY2026 Form 10-Q, filed Oct 22, 2026; McDonald's FY2025 Form 10-K, filed Feb 24, 2026; McDonald's Q2 FY2026 Form 10-Q, filed Aug 7, 2026; Starbucks's FY2026 earnings release (Form 8-K), filed Oct 29, 2026; Home Depot's FY2025 Form 10-K, filed Mar 18, 2026; and Home Depot's Q2 FY2026 Form 10-Q, filed Aug 25, 2026. Checked Nov 15, 2026.