Meta Platforms logo
Meta Platforms Financial Model

Media Company Financials Example (Free Excel Download)

Meta Platforms builds technologies that help people connect, find communities, and grow businesses.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model projects Meta Platforms' future cash flows and profitability to determine its equity valuation, specifically assessing whether the massive capital expenditure required for AI infrastructure will generate sufficient long-term returns to justify the near-term free cash flow compression.

Meta Platforms builds technologies that help people connect, find communities, and grow businesses. The company operates primarily through its social media platforms (Facebook, Instagram, Messenger, WhatsApp) and is investing heavily in artificial intelligence and augmented/virtual reality hardware.

  • Business segments: Family of Apps (FoA) (approximately 98.9% of revenue) and Reality Labs (RL) (approximately 1.1% of revenue).
  • Key geographies: Global, with North America and Europe driving the highest average revenue per person.
  • Business model type: Ad-supported platform (FoA) and consumer hardware/software (RL).
  • Competitive position: Dominant global market share in social media and digital advertising, forming a duopoly with Alphabet in the digital ad market, while aggressively competing in the generative AI space.
  • Recent major events: The 2023 "Year of Efficiency" restructuring, followed by a massive pivot towards AI infrastructure in 2024 and 2025, culminating in a record $115 billion to $135 billion capital expenditure guidance for 2026 to support "Superintelligence Labs".

The downloadable Meta Platforms financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsMeta Platforms financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$117.93B$116.61B$134.90B$164.50B$200.97B
Gross profit$95.28B$91.36B$108.94B$134.34B$164.79B
Operating income$46.75B$28.94B$46.75B$69.38B$83.28B
Net income$39.37B$23.20B$39.10B$62.36B$60.46B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
17.5%
COGS % of revenue
19.5%
R&D % of revenue
24.1%
SG&A % of revenue
9.9%
D&A % of revenue
7.7%
Effective tax rate
18.3%
See 8 more
Capex % of revenue
20.3%
Net working capital % of revenue
49.3%
Other assets % of revenue
34.4%
Other liabilities % of revenue
47.9%
Annual debt paydown
5.0%
Interest rate on debt
0.5%
Dividend payout ratio
0.0%
Buybacks % of net income
65.7%

How to build a detailed financial model for Meta Platforms

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Family of Apps (FoA)

  • Segment name: Family of Apps
  • Revenue driver formula: Family Daily Active People (DAP) x Average Revenue Per Person (ARPP). Alternatively viewed as Ad Impressions x Average Price Per Ad.
  • Historical growth rate: 15% to 24% over the last two years (22% in FY2025).
  • Key growth levers and headwinds: AI-driven ad targeting improvements (Advantage+), increased engagement from Reels, and monetisation of WhatsApp. Headwinds include regulatory scrutiny in the EU and ad market cyclicality.
  • Pricing dynamics: Auction-based spot pricing for digital ads. Average price per ad increased by 9% in FY2025.
  • Revenue recognition notes: Recognised when the ad is displayed or the user clicks, depending on the contract.
  • Seasonality: Q4 is historically the strongest quarter by a significant margin due to holiday advertising spend.

Reality Labs (RL)

  • Segment name: Reality Labs
  • Revenue driver formula: Hardware Units Sold x Average Selling Price + Software/App Sales.
  • Historical growth rate: Volatile, ranging from negative growth to low single digits (approximately 3% growth in FY2025 to $2.21 billion).
  • Key growth levers and headwinds: Adoption of Ray-Ban Meta smart glasses and Quest headsets. Headwinds include consumer reluctance, high price points, and intense competition from Apple.
  • Pricing dynamics: Hardware is often sold near or below cost to drive ecosystem adoption.
  • Revenue recognition notes: Hardware revenue recognised upon delivery; software recognised over the term of the subscription or at the point of sale.
  • Seasonality: Highly concentrated in Q4 due to holiday hardware purchases.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: Cost of revenue includes data centre operations, depreciation of network infrastructure, energy costs, and hardware manufacturing costs for Reality Labs.
  • Gross margin range: 79% to 82% historically.
  • Key input costs and commodity exposures: Server components (GPUs), electricity, and fibre optic network costs.
  • How COGS scales with revenue: High operating leverage for FoA, but heavily burdened by rising depreciation from massive server deployments.

Operating Expenses

  • R&D: Massive spend (approximately 25% to 30% of revenue), heavily focused on AI models (Llama), algorithms, and Reality Labs hardware. Meta does not capitalise significant software development costs compared to peers, expensing most R&D immediately.
  • SG&A: Marketing and sales (approximately 10% to 12% of revenue) and General & Administrative (approximately 7% to 9% of revenue, including significant legal and regulatory fines).
  • Depreciation & Amortisation: Growing rapidly due to data centre build-outs.
  • Stock-Based Compensation: High, typically running at 6% to 8% of revenue to retain top AI and engineering talent.
  • Restructuring / one-time charges: Significant severance and facility consolidation charges occurred in 2023 but have since normalised.

Margin Profile

  • Gross margin: 80% to 82%.
  • EBITDA margin: 50% to 55%.
  • Operating margin: 35% to 43% (41% in FY2025).
  • Net margin: 25% to 30%.
  • Margin trend: Operating margins expanded in 2024 and 2025 due to efficiency measures but face compression risk in 2026 due to guided expense growth ($162 billion to $169 billion) and massive depreciation from AI investments.
  • Segment-level margins: FoA operates at a highly profitable margin (over 50%), while Reality Labs operates at a massive loss (operating loss of $19.19 billion in FY2025).

Balance Sheet Structure

  • Total assets: Approximately $250 billion to $300 billion.
  • Key asset categories: Cash and marketable securities, Property and Equipment (data centres, servers), and Operating lease right-of-use assets.
  • Goodwill & intangibles as % of total assets: Relatively low (under 10%) as Meta relies more on organic R&D than transformational M&A.
  • Working capital profile:
  • Days Sales Outstanding (DSO): 30 to 40 days.
  • Days Inventory Outstanding (DIO): Minimal (only relevant for RL hardware).
  • Days Payable Outstanding (DPO): 40 to 50 days.
  • Net working capital as % of revenue: Generally negative or neutral, providing a slight funding advantage.
  • PP&E: The fastest-growing line item, consisting of servers, network equipment, and data centres. Useful life assumptions for servers were recently extended, which temporarily benefited depreciation schedules.
  • Right-of-use assets / operating leases: Material, representing data centre and office space leases.

Capital Expenditure & Investment

  • Capex as % of revenue: Historically 15% to 20%, but surging to an estimated 55% to 65% in 2026 based on guidance.
  • Maintenance capex vs. growth capex: Heavily skewed towards growth capex (AI supercomputers, GPU clusters).
  • Major capex programmes underway: Meta Superintelligence Labs infrastructure and massive data centre expansion. FY2025 capex was $72.22 billion, with FY2026 guidance at $115 billion to $135 billion.
  • Capitalised software: Minimal compared to hardware capex.
  • M&A pattern: Historically transformational (Instagram, WhatsApp) but currently restricted by antitrust regulators, leading to a focus on organic growth and bolt-on tech acquisitions.

Debt & Capital Structure

  • Total debt: Approximately $58.7 billion in long-term debt as of FY2025.
  • Net debt: Deeply negative (net cash position), with cash and marketable securities at $81.59 billion.
  • Debt/EBITDA ratio: Near zero on a net basis; gross leverage is under 1.0x.
  • Credit rating: AA- or equivalent.
  • Key debt instruments: Senior unsecured notes issued in recent years to optimise the capital structure.
  • Maturity profile: Well-laddered over 10 to 40 years.
  • Interest rate profile: Primarily fixed-rate bonds.
  • Share repurchase programme: Highly active, with $26.26 billion repurchased in FY2025.
  • Dividend policy: Initiated in 2024. FY2025 total dividend payments were $5.32 billion (approximately $2.00 per share annually), representing a low payout ratio but a growing commitment to capital return.

Cash Flow Characteristics

  • Operating cash flow conversion: Very strong, typically 1.5x to 1.8x of Net Income (OCF was $115.8 billion in FY2025).
  • Free cash flow margin: Historically 20% to 25%, but expected to compress significantly in 2026 due to the $115 billion+ capex guidance. FY2025 FCF was $43.59 billion.
  • Major non-cash items: Depreciation and amortisation (growing rapidly) and stock-based compensation.
  • Working capital cash flow impact: Minor positive contributor due to efficient receivables collection.
  • Capex intensity: Currently the defining characteristic of the company, transitioning from an asset-light software model to an asset-heavy infrastructure model.
  • Cash tax rate vs. GAAP effective tax rate: Effective tax rate is typically 11% to 16% (guided 13% to 16% for 2026), benefiting from R&D tax credits and foreign earnings structures.

Sheet Structure

  1. Assumptions: Hardcoded inputs for macroeconomic drivers, segment growth, ARPP, capex guidance, and margin targets.
  2. Revenue & KPIs: Detailed build for Family of Apps (DAP, ARPP, Ad Impressions, Price per Ad) and Reality Labs (Hardware units, ASP).
  3. Income Statement: Consolidated P&L mirroring the 10-K, with clear breakouts for Cost of Revenue, R&D, Sales & Marketing, and General & Administrative.
  4. Segment Financials: Revenue and Operating Income broken out strictly by Family of Apps and Reality Labs, reconciling to consolidated operating income.
  5. Balance Sheet: Standard asset and liability line items, highlighting Cash, Marketable Securities, PP&E, and Long-Term Debt.
  6. Cash Flow Statement: Operating, Investing, and Financing cash flows, explicitly showing the massive PP&E additions and share repurchases.
  7. PP&E & Depreciation Schedule: Critical sheet tracking the massive server and data centre investments, applying appropriate useful lives to forecast the surging depreciation expense.
  8. Debt Schedule: Tracking senior notes, interest expense, and interest income on the massive cash balance.
  9. Working Capital: Schedules for Accounts Receivable, Prepaid Expenses, Accounts Payable, and Accrued Liabilities.
  10. Valuation (DCF): Unlevered free cash flow build, WACC calculation, and terminal value, specifically addressing the long-term ROI of the AI capex cycle.

Key Financial Relationships

  1. Family of Apps Revenue = Family Daily Active People (DAP) x Average Revenue Per Person (ARPP).
  2. Ad Revenue Growth = Ad Impression Growth Rate + Average Price Per Ad Growth Rate.
  3. Reality Labs Revenue = Hardware Revenue + Software/Other Revenue.
  4. Total Revenue = Family of Apps Revenue + Reality Labs Revenue.
  5. Cost of Revenue = Total Revenue x Cost of Revenue Margin (adjusted for rising depreciation).
  6. Total Operating Expenses = Cost of Revenue + R&D + Sales & Marketing + General & Administrative.
  7. Segment Operating Income (FoA) = FoA Revenue - Allocated FoA Operating Expenses.
  8. Segment Operating Loss (RL) = RL Revenue - Allocated RL Operating Expenses (historically a $15 billion to $20 billion loss).
  9. Consolidated Operating Income = FoA Operating Income + RL Operating Loss.
  10. Depreciation Expense = Beginning PP&E x Blended Depreciation Rate (increasing due to server mix).
  11. Interest Income = Average Cash & Marketable Securities Balance x Yield on Cash.
  12. Free Cash Flow = Cash Flow from Operations - Capital Expenditures (including principal payments on finance leases).
  13. Ending Share Count = Beginning Share Count - (Share Repurchase Amount / Average Share Price) + Shares Issued for SBC.

Cross-Sheet Dependencies

  • The Assumptions sheet feeds all operating drivers in the Revenue & KPIs and Segment Financials sheets.
  • Revenue & KPIs feeds the top line of the Income Statement and Segment Financials.
  • The PP&E & Depreciation Schedule is the most critical dependency; it takes CapEx from Assumptions, calculates depreciation, and feeds both the Income Statement (operating expenses) and the Cash Flow Statement (non-cash add-backs).
  • The Cash Flow Statement determines the ending cash balance, which feeds the Balance Sheet and the Debt Schedule (to calculate interest income).
  • The Valuation (DCF) sheet pulls NOPAT from the Income Statement, CapEx and D&A from the Cash Flow Statement, and net cash from the Balance Sheet. A circularity risk exists between interest income, net income, cash balances, and share repurchases.

Sign Convention

  • Revenue and asset balances are positive.
  • Expenses (COGS, R&D, SG&A) are entered as positive numbers in their respective schedules but subtracted in the Income Statement to calculate profit.
  • Capital expenditures are positive in the PP&E schedule but represented as negative outflows in the Cash Flow Statement.
  • Reality Labs Operating Loss should be displayed as a negative number when aggregating total operating income.
  • Dividends and share repurchases are negative outflows in the Cash Flow Statement.

Things Most Likely to Go Wrong

  1. Underestimating CapEx: Meta has guided for $115 billion to $135 billion in 2026 CapEx. Failing to model this massive step-up will completely invalidate the free cash flow forecast.
  2. Miscalculating Depreciation: The massive CapEx surge will create a delayed but massive wave of depreciation expense. The model must accurately flow CapEx into PP&E and calculate the resulting depreciation hit to operating margins.
  3. Ignoring Reality Labs Losses: RL loses nearly $20 billion annually. Assuming this segment breaks even in the near term will artificially inflate consolidated margins.
  4. SBC Treatment: Meta issues significant stock-based compensation. Excluding this from free cash flow or failing to account for the resulting share dilution will distort valuation per share.
  5. Interest Income Impact: With over $80 billion in cash, interest income is a material contributor to pre-tax income. The model must dynamically calculate this based on cash balances.
  6. Tax Rate Volatility: Meta's effective tax rate fluctuates based on R&D credits and international tax laws. Use the guided 13% to 16% range rather than the statutory US rate.
  7. Currency Fluctuations: Meta generates the majority of its revenue outside the US. The model should ideally forecast on a constant-currency basis or explicitly flag FX headwinds/tailwinds.
  8. Circularity in Share Buybacks: Repurchasing shares reduces cash, which reduces interest income, which reduces net income, which reduces cash available for buybacks. A circuit breaker or manual toggle is required.

Validation Checks

  1. Total Revenue must exactly equal Family of Apps Revenue plus Reality Labs Revenue.
  2. Consolidated Operating Income must equal FoA Operating Income plus RL Operating Loss.
  3. CapEx for 2026 must fall within the $115 billion to $135 billion guidance range.
  4. Total Expenses for 2026 must fall within the $162 billion to $169 billion guidance range.
  5. Operating Margin should compress slightly in 2026 compared to 2025 due to the guided expense growth.
  6. The Balance Sheet must balance: Total Assets = Total Liabilities + Shareholders' Equity for all forecast periods.
  7. Effective Tax Rate must remain between 13% and 16% as per management guidance.
  8. Free Cash Flow must equal Cash Flow from Operations minus Capital Expenditures.

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
FoA Revenue Growth (2026)15.0%Deceleration from 2025's 22% growth, reflecting scale and ad market normalisation.
RL Revenue Growth (2026)5.0%Modest growth driven by smart glasses and new headset iterations.
Total Expenses (2026)165.5$ BillionsMidpoint of management's $162B to $169B guidance.
Reality Labs Operating Loss-19.5$ BillionsManagement indicated RL losses will remain similar to 2025 levels.
Capital Expenditures (2026)125.0$ BillionsMidpoint of management's $115B to $135B guidance for AI infrastructure.
Effective Tax Rate14.5%Midpoint of management's 13% to 16% guidance for 2026.
Share Repurchases25.0$ BillionsConsistent with 2025 levels, supported by the strong balance sheet.
Dividend Per Share2.00$Annualised based on recent quarterly declarations.
Yield on Cash4.5%Assumed interest rate on the $80B+ cash and marketable securities balance.
WACC9.5%Standard discount rate for a mega-cap tech company with high beta and low debt.
Terminal Growth Rate3.0%Long-term GDP plus slight premium for digital advertising dominance.

Data Sources & Benchmarks

  • SEC EDGAR: Meta Platforms Inc. Form 10-K and 8-K filings (investor.atmeta.com).
  • Key peers for benchmarking: Alphabet (GOOGL) for digital advertising and AI CapEx; Apple (AAPL) for consumer hardware and wearables; Amazon (AMZN) and Microsoft (MSFT) for data centre infrastructure spend.
  • Industry data sources: eMarketer for global digital ad spend market share; IDC for virtual reality and augmented reality headset shipment data.
  • Consensus estimates: Bloomberg or FactSet for forward revenue and EPS estimates.

Sources

Frequently asked

What is Meta Platforms' primary business model?+

Meta Platforms builds technologies that help people connect, find communities, and grow businesses. The company operates primarily through its ad-supported social media platforms, known as the Family of Apps (FoA), and is also investing heavily in artificial intelligence and augmented/virtual reality hardware through Reality Labs (RL).

How does Meta Platforms generate its revenue?+

Meta Platforms primarily generates revenue from its Family of Apps segment, which is an ad-supported platform and accounts for approximately 98.9% of its total revenue. A smaller portion comes from its Reality Labs segment, which includes consumer hardware and software sales.

Why is Meta Platforms' capital expenditure expected to increase significantly?+

Meta Platforms is undertaking a massive pivot towards AI infrastructure, which requires substantial capital expenditure. The company has guided for FY2026 capital expenditures between $115 billion and $135 billion to support initiatives like Meta Superintelligence Labs and extensive data center expansion.

What are the key financial assumptions in Meta Platforms' financial model forecast?+

Key assumptions in the financial model include a projected revenue growth rate of approximately 17.5% and COGS as a percentage of revenue around 19.5%. Research and Development (R&D) is also a significant assumption, estimated at about 24.1% of revenue.

What is the main purpose of the Meta Platforms financial model?+

The model's primary purpose is to project Meta Platforms' future cash flows and profitability to determine its equity valuation. It specifically assesses whether the massive capital expenditure required for AI infrastructure will generate sufficient long-term returns to justify the near-term free cash flow compression.

Can I download an Excel financial model for Meta Platforms?+

Yes, a downloadable Excel financial model for Meta Platforms is available. This model provides a forecast horizon from FY2026 through FY2030, allowing for detailed analysis of the company's future financial performance.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Media Company Financial Models

Browse another company in the same sector.

APP.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
AppLovin logo

AppLovin

AppLovin operates a leading software-based platform that provides end-to-end advertising and AI solutions to help businesses reach, monetise, and grow their global audiences.

DIS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Walt Disney logo

Walt Disney

The Walt Disney Company is a diversified global entertainment conglomerate that produces premium content, operates direct-to-consumer streaming services, broadcasts live sports, and operates world-renowned theme parks and cruise lines.

EA.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Electronic Arts logo

Electronic Arts

Electronic Arts (EA) is a global leader in digital interactive entertainment, developing and delivering games, content, and online services for consoles, personal computers, and mobile devices.

FOX.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Fox logo

Fox

Fox Corporation is a leading news, sports, and entertainment broadcasting company in the United States.

GOOGL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Alphabet logo

Alphabet

Alphabet is a global technology holding company known for its core Google internet products including Search, YouTube, Android, and Chrome, generating revenue primarily through digital advertising while scaling cloud computing and AI infrastructure.

HAS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Hasbro logo

Hasbro

Hasbro is a global play and entertainment company that designs, manufactures, and licenses toys, tabletop games, and digital gaming experiences.

LYV.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Live Nation Entertainment logo

Live Nation Entertainment

Live Nation Entertainment (LYV) is the world's largest live entertainment company, operating a vertically integrated model that spans concert promotion, venue operation, ticketing, and brand sponsorship.

NFLX.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Netflix logo

Netflix

Netflix operates a global streaming entertainment service offering television series, films, and games across various genres and languages, funded primarily through subscription fees and advertising.

Explore more Tech & Software financial model templates.

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