Luna1 Market Pulse

AFTER HOURSOpens Thursday in 14h 30m
i

Market data may be delayed and is provided for informational and educational purposes. Luna1 does not guarantee its accuracy or completeness.

SPYS&P 500 ETF—Change unavailableUNAVAILABLE
RUTRussell 2000—Change unavailableUNAVAILABLE
US10YU.S. 10-Year Treasury—Change unavailableUNAVAILABLE
GOLDGold—Change unavailableUNAVAILABLE
NVDANVIDIA—Change unavailableUNAVAILABLE
AAPLLong-Term Compounders—Change unavailableUNAVAILABLE
COSTLong-Term Compounders—Change unavailableUNAVAILABLE
AMZNLong-Term Compounders—Change unavailableUNAVAILABLE
Data via Financial Modeling Prep
Global Finance · Planning & performance

Global FP&A

Northstar Technologies. Four regions, four currencies, one consolidated operating story.

FICTIONAL CASE STUDY · Northstar Technologies is not a real company. All regional inputs and exchange rates were authored for this case. Q2 2026 compared with Q2 2025; no employer information.
Consolidated revenue$239.46m6.0% reported growth
Budget variance-4.94mActual less budget · USD
FX-neutral growth9.8%Prior-period FX held constant
Regional revenue · actual vs budgetUSD m · shared scale, zero baseline
United States actual112.00
United States budget110.00
Germany actual56.70
Germany budget58.30
Mexico actual36.96
Mexico budget39.00
Japan actual33.80
Japan budget37.10
Revenue variance bridgeUSD m · shared scale, zero baseline
Operations3.72
FX translation-8.66
Net variance-4.94
Budget 244.40 + operations 3.72 + FX (-8.66) = actual 239.46 USD m.

The regional operating picture

Operating profit by regionUSD m · shared scale, zero baseline
United States28.00
Germany13.65
Mexico8.64
Japan6.17
Capital expenditure by regionUSD m · shared scale, zero baseline
United States10.00
Germany6.30
Mexico3.03
Japan2.73
Calculated results · USD m except percentages, percentage points (pp), and people. Positive cost/headcount variances mean above budget.
RegionLocal growthUSD growthOp. marginMargin Δ ppOpEx ΔHeadcount ΔCapEx Δ
United States12.0%12.0%25.0%-0.452.0081.00
Germany8.0%3.1%24.1%-0.45-0.9550.80
Mexico12.0%2.7%23.4%0.29-1.68100.02
Japan4.0%-3.4%18.3%-2.49-1.78-2-0.07

Management commentary

United States · USD

12.0% local growth

Revenue grew 12.0% in local currency and 12.0% after USD translation. Reported revenue was 2.00m above budget. FX contributed 0.00m to that variance.

Operating expense was 2.00m above budget. Investigate staffing, pricing, and mix before attributing causes.

Germany · EUR

8.0% local growth

Revenue grew 8.0% in local currency and 3.1% after USD translation. Reported revenue was 1.60m below budget. FX contributed -2.70m to that variance.

Operating expense was 0.95m below budget. Investigate staffing, pricing, and mix before attributing causes.

Mexico · MXN

12.0% local growth

Revenue grew 12.0% in local currency and 2.7% after USD translation. Reported revenue was 2.04m below budget. FX contributed -3.36m to that variance.

Operating expense was 1.68m below budget. Investigate staffing, pricing, and mix before attributing causes.

Japan · JPY

4.0% local growth

Revenue grew 4.0% in local currency and -3.4% after USD translation. Reported revenue was 3.30m below budget. FX contributed -2.60m to that variance.

Operating expense was 1.78m below budget. Investigate staffing, pricing, and mix before attributing causes.

Commentary is generated from the deterministic model. The model does not infer business causes from variances alone.

Build the next-quarter scenario

Apply a common local revenue growth assumption to Q2 actuals, then move foreign-currency translation rates. This simplified revenue forecast excludes seasonality and does not forecast expenses or profit.

Q3 scenario revenue$251.43mEstimated Impact · not guidance
Q2 starting revenue$239.46m
Sequential change5.0%
Regional forecast · Q3 scenarioUSD m · shared scale, zero baseline
United States117.60
Germany59.54
Mexico38.81
Japan35.49

Inspect the source inputs

Local revenue, expense, and CapEx amounts are retained. Multiply each by its period-average USD-per-local-unit rate to consolidate.

All inputs fictional · Q2 2026 · Local millions; FX = USD per local unit · Same period for all regions.
Region / currencyPrior rev.Budget rev.Actual rev.Budget OpExActual OpExPrior FXBudget FXActual FXBudget HCActual HCBudget CapExActual CapEx
United States / USD1001101128284111400408910
Germany / EUR50535440411.11.11.0520020556
Mexico / MXN6006506725005150.060.060.0553003105055
Japan / JPY500053005200420042500.0070.0070.0065180178400420
Model formulas and limitations

Budget variance = actual local revenue × actual FX − budget local revenue × budget FX. Operations = (actual − budget local revenue) × budget FX. FX = actual local revenue × (actual FX − budget FX). Constant-currency growth uses prior-year FX for both years.

Operating profit = revenue − operating expenses. Margin variance = actual margin − budget margin. No intercompany eliminations, tax, debt, depreciation schedules, or confidential data. Quarterly average rates are assumptions, not market quotes.

Source: Luna1 authored fictional case · As of 2026-06-30 · Updated 2026-09-26 · Millions of local currency; headcount in people · Reporting currency USD.