InterviewStack.io LogoInterviewStack.io

Revenue Forecasting and Modeling Questions

Skills and practices for building, maintaining, and improving revenue and expense forecast models. Covers forecasting approaches such as pipeline based forecasts, historical trending, management guidance, market analysis, and statistical models, as well as scenario analysis for upside base and downside cases. Includes expense modeling, estimating timelines to revenue realization, modeling conversion and adoption assumptions, tracking and reducing forecast variance, measuring and improving forecast accuracy, and scaling forecasting processes across products, sales channels, and geographies. Candidates may be asked to describe model structure, key input drivers, data sources, validation and reconciliation techniques, and how they adapt models for new products or changing business conditions.

EasyTechnical
63 practiced
In ANSI SQL, given a table 'deals' with columns: deal_id, rep_id, amount, stage, probability (0-1), and expected_close_date, write a query that returns weighted pipeline per sales rep for the current month and the company-wide weighted pipeline total. State any assumptions about null probabilities and future close dates you make.
MediumTechnical
68 practiced
A major price increase is announced mid-quarter for a core product. Explain how you would update both short-term and long-term revenue forecasts. Specify which assumptions you would change (close probability, churn, deal size, velocity), how to estimate the trade-off between lift and churn, and how to present alternative scenarios to leadership.
MediumTechnical
74 practiced
In SQL (ANSI), given a 'subscriptions' table with columns customer_id, start_date, end_date (nullable), and monthly_recurring_revenue, write a query to produce monthly cohort revenue and cohort retention rates for the last 12 months. Explain how you treat NULL end_date values and partial-month billing.
MediumTechnical
68 practiced
Explain how to integrate lead scoring signals from marketing automation into the forecasting process to improve early-stage conversion estimates. Identify useful signals (engagement, intent, firmographics), validation techniques, and how to operationalize score thresholds into forecast categories or probability adjustments.
HardTechnical
59 practiced
Explain how ASC 606 (or similar revenue recognition standards) impacts forecasting for multi-year contracts and bundled services. Describe how you would model bookings versus recognized revenue, including allocation to performance obligations, deferred revenue schedules, and the impact on projected churn and renewal timing.

Unlock Full Question Bank

Get access to hundreds of Revenue Forecasting and Modeling interview questions and detailed answers.

Sign in to Continue

Join thousands of developers preparing for their dream job.