GMV Forecasting Calculator - Professional Planning Tool

???? GMV Forecasting Calculator

Professional Planning Tool for B2B SaaS | Data-Driven Predictions

???? Upload Historical Data

Drop Excel file here or click to upload

Supports .xlsx and .xls files

???? Processing your historical data...

✅ Data processed successfully! All parameters calculated from your file.
???? Key insights: Currency converted, cancellations excluded, hotel/flight segmented

???? Historical Analytics Overview

⚙️ Advanced Parameters (Optional Adjustments)

???? Smart Defaults: All parameters below are automatically calculated from your data and market intelligence. You can adjust them if you have specific insights or want to test different scenarios.

Select Target Month for Forecasting

Select the month you want to forecast

???? CFO-Level Methodology & Data Sources

Historical Data Analysis

Churn rate calculated from actual client behavior patterns, excluding cancelled operations. New client forecasts based on 3-month rolling averages. Currency conversion applied automatically (USD→TRY using recorded exchange rates).

Cohort Segmentation

Automatic separation of new vs existing clients based on first successful transaction dates. Different activity multipliers applied to account for onboarding period and established usage patterns. Cancelled transactions excluded from activity calculations.

Hotel vs Flight Segmentation

Services automatically categorized into hotel bookings (International/Domestic Hotel Booking) vs other services (flights, custom). Hotel share tracked separately for market insights and seasonal adjustments.

Currency & Risk Management

Multi-currency support with automatic USD→TRY conversion using recorded exchange rates. Cancelled operations tracked separately to assess cancellation risk and refund impacts on cash flow.

Seasonal Intelligence

Turkey B2B travel seasonality factors: Jan-Feb low (0.85-0.90), Mar-May peak (1.05-1.15), Jun-Aug holiday impact (0.85-1.05), Sep-Nov business high (1.10-1.15), Dec year-end (0.90). Hotel vs flight seasonality considered.

Scenario Modeling

Conservative: 80% new client acquisition, 92% retention. Most Likely: baseline parameters. Optimistic: 125% new acquisition, 103% retention. All scenarios exclude cancelled operations and include currency-adjusted figures.

CFO Strategic Recommendations:

This enhanced forecasting model combines your actual business performance with market intelligence for realistic planning. Key improvements: Cancelled operations excluded from GMV calculations, USD transactions automatically converted to TRY, hotel vs flight segmentation for targeted strategies. Use Conservative scenario for budget planning, Most Likely for operational targets, and Optimistic for growth investment decisions. Monitor hotel booking share (currently ~26%) for seasonal trends and market positioning. Review and recalibrate monthly as new data becomes available.