All companies
AT&T logo
CommunicationsT

AT&T (T) Financial Forecast Calculator

Interactive 5-year forecast and DCF for AT&T. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from AT&T’s most recent SEC filings.

Revenue FY30
$75.00B
from $122.43B
FCF FY30
$30.17B
Margin 40.2%
Enterprise value
$514.60B
4.2× LTM revenue
Equity value
$394.77B
Net debt $119.83B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
-9.3%
-10.0%baseline -9.3%40.0%
Gross margin
78.9%
5.0%baseline 78.9%90.0%
Capex % of revenue
12.7%
0.0%baseline 12.7%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the AT&T forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

What is AT&T's primary business focus?+

AT&T Inc. is a premier telecommunications company providing wireless and wireline connectivity services to consumers and businesses globally. The company has transitioned into a pure-play connectivity provider following the divestitures of its media and pay-TV assets.

What are AT&T's main revenue segments?+

AT&T's primary revenue segments include Mobility, which accounts for approximately 73% of segment revenue, Business Wireline, and Consumer Wireline. A smaller portion comes from its Latin America operations, mainly Mexico.

What is AT&T's capital expenditure strategy?+

AT&T's capital expenditure, typically 16% to 18% of revenue, is largely focused on growth and upgrades. Major programs include expanding the fiber network to 40 million locations by 2026 and deploying Open RAN technology.

What is the purpose of the AT&T financial model?+

The AT&T financial model projects the company's free cash flow generation and deleveraging trajectory. Its purpose is to determine equity valuation and assess the long-term sustainability of its dividend payout for an equity research or credit analyst.

Can I download an Excel financial model for AT&T?+

Yes, a downloadable Excel financial model is available for AT&T. This general corporate model forecasts the company's financials from FY2026 through FY2030.

What are some key assumptions in AT&T's financial model?+

Key assumptions in AT&T's financial model include a revenue growth rate of approximately -9.3% and COGS as 21.1% of revenue. The model also assumes a tax rate of 21% and capital expenditure at 12.7% of revenue.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview