Apple Ads FP&A Dashboard — FY27 Plan

Driver-based plan using live App Store data (5,805 apps, pulled 2026-11-11). Financial inputs are illustrative. Same logic as Apple_Ads_FPA_Model.xlsx.

Monthly ad revenue ($mm)

Current settings vs Base-case budget. Dec peak = holiday seasonality.

Quarterly P&L ($mm)

Revenue and operating income by fiscal quarter.

FY27 revenue by category ($mm)

Click a bar to see its Q1 variance.

P&L table ($mm)

Q1 revenue bridge ($mm)

Budget → volume (advertisers) → rate (spend/adv) → actual.

Variance by category ($mm)

Sorted; positive = favorable.

Variance detail

Click a column header to sort. Actuals are illustrative demo values.

3-year NPV by storefront ($mm)

Incremental sales investment, discounted at the scenario rate.

Price index: gross vs tax-adjusted (US = 100)

Same paid app, USD-converted. VAT/GST inflates UK/EU/APAC sticker prices.

Investment case detail

FY27 revenue ($mm): advertiser growth × spend growth

Ringed cell = current settings. Hover any cell for the value.
Demand drivers from the App Store data. Engagement share (ratings volume of top free + grossing apps) sizes each category's advertiser pool; willingness-to-pay index (median paid price ÷ average) scales spend per advertiser. Full pricing analysis: report.html.

Category drivers

Bubble size = FY27 revenue under current settings.

Driver table