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.
What to do
- Choose one company from the cards below.
- Fill in the research log on your worksheet from the card.
- 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.
- 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
- Did your company have net debt or net cash, and on what date?
- What does its filing say it borrowed for?
- 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.