I85PREP
⌘ K
FPAP study materials
FPAP study resources

FPAP practice questions

One question at a time. Build your FPAP understanding.

First 50 of 190 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Role knowledge and relevant financial foundations

In a 3-statement linked model, where does net income flow on the balance sheet?

  1. Cash and cash equivalents
  2. Retained earnings within stockholders' equity Correct answer.
  3. Goodwill within long-term assets
  4. Accounts payable within current liabilities

Explanation

Net income from the income statement flows into retained earnings on the balance sheet via the equity roll-forward: ending retained earnings = beginning retained earnings + net income − dividends. This is the primary mechanical link between the income statement and balance sheet. Cash, by contrast, is reconciled through the cash flow statement.

Question 2Role knowledge and relevant financial foundations

Which schedule is typically used to forecast capital expenditures, depreciation, and ending net PP&E balances?

  1. Debt schedule
  2. Working capital schedule
  3. PP&E roll-forward schedule Correct answer.
  4. Equity schedule

Explanation

A PP&E roll-forward schedule starts with beginning net PP&E, adds capital expenditures, subtracts depreciation expense (and any disposals or impairments), and arrives at ending net PP&E. The depreciation feeds the income statement, capex feeds investing activities on the cash flow statement, and the ending balance feeds the balance sheet.

Question 3Role knowledge and relevant financial foundations

Driver-based modeling for revenue in a SaaS company would most appropriately use which formula?

  1. Prior-year revenue × growth rate
  2. Beginning ARR + new bookings − churn + expansion Correct answer.
  3. Total expenses × markup percentage
  4. EBITDA × revenue multiple

Explanation

A driver-based SaaS revenue model decomposes ARR into beginning balance, new bookings, churn (lost ARR), and expansion (upsell/cross-sell from existing customers). This bottom-up approach links revenue to operational metrics like sales pipeline, win rates, and net retention, giving FP&A the levers to explain variance and pressure-test plans.

Question 4Role knowledge and relevant financial foundations

An analyst is building a top-down revenue forecast. Which of the following best describes this approach?

  1. Start with total addressable market and apply a market share assumption Correct answer.
  2. Build revenue from individual customer contracts and renewal probabilities
  3. Forecast units sold by SKU and multiply by list price
  4. Project revenue per sales rep based on quota attainment

Explanation

A top-down forecast starts with the total addressable market (TAM) and applies assumptions about market share to derive revenue. It is useful for early-stage businesses, new product launches, or strategic planning where granular operational data is limited. Bottom-up forecasts, in contrast, build from operational drivers like contracts, units, or rep quotas.

Question 5Role knowledge and relevant financial foundations

Which Excel tool is best suited for showing how NPV changes across simultaneous variations in two assumptions (e.g., discount rate and growth rate)?

  1. Goal Seek
  2. Scenario Manager
  3. Two-variable data table Correct answer.
  4. Solver

Explanation

A two-variable data table is purpose-built to show how a single output (e.g., NPV) varies as two inputs change simultaneously across a grid. Scenario Manager handles named scenarios but does not produce a sensitivity grid. Goal Seek finds one input that makes a formula equal a target. Solver handles constrained optimization with multiple variables.

Question 6Role knowledge and relevant financial foundations

What does a positive NPV at the company's WACC indicate about a project?

  1. The project's IRR is below WACC
  2. The project is expected to create value for shareholders Correct answer.
  3. The project has a payback period under one year
  4. The project should be rejected

Explanation

A positive NPV at the company's WACC means the project is expected to generate cash flows whose present value exceeds the initial investment, after compensating capital providers for their required return. By the NPV decision rule, positive-NPV projects create shareholder value and should be accepted (subject to capital constraints).

Question 7Role knowledge and relevant financial foundations

Which capital budgeting metric assumes interim cash flows are reinvested at the project's IRR rather than at the firm's cost of capital?

  1. Net Present Value (NPV)
  2. Modified Internal Rate of Return (MIRR)
  3. Internal Rate of Return (IRR) Correct answer.
  4. Profitability Index (PI)

Explanation

The standard IRR implicitly assumes interim cash flows are reinvested at the IRR itself, which is often unrealistic. MIRR was developed precisely to address this by assuming reinvestment at the firm's cost of capital (or another specified reinvestment rate), producing a more conservative and economically realistic return measure.

Question 8Role knowledge and relevant financial foundations

A capital project has an initial investment of $100,000 and annual cash flows of $30,000 for 5 years. What is the simple (non-discounted) payback period?

  1. 2.5 years
  2. 3.33 years Correct answer.
  3. 4 years
  4. 5 years

Explanation

Simple payback = initial investment ÷ annual cash flow when cash flows are even: $100,000 ÷ $30,000 = 3.33 years. After 3 years the project has recovered $90,000, and it needs $10,000 more from year 4's $30,000 - i.e., 1/3 of year 4 - so payback occurs at 3 + 0.33 = 3.33 years.

Question 9Role knowledge and relevant financial foundations

The Profitability Index (PI) of a project is calculated as 1.25. What does this mean?

  1. The project returns $1.25 of present value for every $1 invested Correct answer.
  2. The project's IRR is 25%
  3. The project pays back in 1.25 years
  4. The project should be rejected because PI > 1

Explanation

PI = PV of future cash flows ÷ initial investment. A PI of 1.25 means each $1 invested generates $1.25 in present value, i.e., $0.25 of value creation per $1 invested. Projects with PI > 1 are equivalent to NPV > 0 and should be accepted; PI is especially useful for ranking projects under capital rationing.

Question 10Role knowledge and relevant financial foundations

Which Excel feature would you use to find the input value that produces a specific target output in a single cell?

  1. Data table
  2. Goal Seek Correct answer.
  3. PivotTable
  4. Scenario Manager

Explanation

Goal Seek (Data → What-If Analysis → Goal Seek) iteratively solves for the input value of one cell that produces a target output in another cell. For example, finding the price that achieves a target gross margin or the discount rate that makes NPV equal zero (i.e., the IRR).

Question 11Role knowledge and relevant financial foundations

Which technique uses repeated random sampling of input distributions to estimate a probability distribution of model outcomes (e.g., NPV)?

  1. Sensitivity analysis
  2. Scenario analysis
  3. Monte Carlo simulation Correct answer.
  4. Goal Seek

Explanation

Monte Carlo simulation runs thousands of iterations, sampling each uncertain input from a defined probability distribution (normal, triangular, uniform, etc.) and recalculating the model output. The result is a distribution of outcomes that reveals not just the expected value but the probability of downside scenarios. Sensitivity analysis varies one input at a time; scenario analysis runs a few discrete cases.

Question 12Role knowledge and relevant financial foundations

An expense driver model for sales compensation is best represented by:

  1. A flat percentage of revenue
  2. Headcount × average fully loaded compensation per rep Correct answer.
  3. Last year's expense plus inflation
  4. Industry benchmark percentage of EBITDA

Explanation

A driver-based sales compensation model multiplies headcount by fully loaded comp per rep (base + commission + benefits + payroll taxes). This connects the expense to operational decisions (hiring plans, comp plans) and lets FP&A pressure-test affordability against productivity (revenue per rep, quota attainment). Flat percentages of revenue or prior year + inflation are simpler but less explanatory.

Question 13Role knowledge and relevant financial foundations

In a 3-statement model, where does interest expense from a debt schedule flow?

  1. Operating section of the cash flow statement only
  2. Income statement (above EBT) and indirectly through to retained earnings and cash Correct answer.
  3. Balance sheet only as accrued interest
  4. Investing section of the cash flow statement

Explanation

Interest expense from the debt schedule flows to the income statement as a non-operating expense, reducing pre-tax income (EBT). The resulting reduction in net income flows to retained earnings on the balance sheet, and the cash payment of interest is captured in the operating section of the cash flow statement (under U.S. GAAP) via the indirect method's net income starting point.

Question 14Role knowledge and relevant financial foundations

A sales pipeline coverage ratio of 3x means:

  1. The team has 3 times the pipeline value of the quarterly quota Correct answer.
  2. The team has closed 3 times its quota
  3. Pipeline conversion rate is 33%
  4. Sales reps generate 3 times their salary in revenue

Explanation

Pipeline coverage = pipeline value ÷ quota for the period. A 3x coverage ratio means the team has $3 of weighted (or unweighted) pipeline for every $1 of quota. Many B2B sales orgs target 3x-5x coverage to account for typical close rates of 20-33%; lower coverage signals risk of missing the number.

Question 15Role knowledge and relevant financial foundations

Cohort retention analysis is most useful for forecasting revenue in which type of business?

  1. Project-based consulting firm
  2. Subscription or recurring-revenue business Correct answer.
  3. Heavy industrial equipment manufacturer
  4. Commodity trading firm

Explanation

Cohort retention groups customers by acquisition period (e.g., month or quarter signed up) and tracks how each cohort retains over time. This is essential for subscription businesses where revenue depends on long-term retention; the curves let FP&A model future revenue from existing cohorts plus new acquisition. It is less applicable to one-off transactions or commodity sales.

Question 16Role knowledge and relevant financial foundations

When linking a debt schedule to the income statement, what is the most accurate way to compute interest expense for a revolver with fluctuating balances?

  1. Apply interest rate to the ending balance for the period
  2. Apply interest rate to the beginning balance for the period
  3. Apply interest rate to the average of beginning and ending balances Correct answer.
  4. Apply interest rate to the maximum balance during the period

Explanation

Using the average balance (begin + end ÷ 2) is the standard convention for interest on a fluctuating revolver because it approximates the time-weighted balance over the period. Using only beginning or ending balance can over- or understate interest depending on borrowing patterns. Note that this creates a circular reference (interest → NI → cash → revolver balance → interest) that requires iterative calculation in Excel.

Question 17Role knowledge and relevant financial foundations

A 'real option' in capital budgeting refers to:

  1. An exchange-traded option on commodity prices
  2. Management's flexibility to expand, defer, or abandon a project as new information arrives Correct answer.
  3. A guaranteed minimum return promised by the project sponsor
  4. An equity-linked compensation plan for project managers

Explanation

Real options recognize that managers have valuable flexibility - they can expand a project if it is going well, defer investment until uncertainty resolves, or abandon and salvage if outcomes are poor. Standard NPV ignores this flexibility. Real-options analysis (often via decision trees or Black-Scholes-style frameworks) values that flexibility, often justifying projects that look unattractive on a static-NPV basis.

Question 18Role knowledge and relevant financial foundations

Which of the following is NOT a typical output of a working capital schedule?

  1. Forecast accounts receivable based on DSO
  2. Forecast inventory based on DIO
  3. Forecast accounts payable based on DPO
  4. Forecast goodwill from prior acquisitions Correct answer.

Explanation

Goodwill is the residual of acquisition price over fair value of net assets acquired and is only recorded when an acquisition occurs; it is not driven by working capital assumptions. The working capital schedule projects current operating assets and liabilities - AR (DSO × revenue/365), inventory (DIO × COGS/365), and AP (DPO × COGS/365) - that swing with operating activity.

Question 19Role knowledge and relevant financial foundations

An analyst notices that NPV is highly sensitive to terminal value assumptions. What is the best diagnostic technique?

  1. Run a one-variable data table varying the terminal growth rate Correct answer.
  2. Replace the DCF with comparable company multiples
  3. Increase the discount rate to make terminal value smaller
  4. Lengthen the explicit forecast period to 50 years

Explanation

A one-variable data table varying the terminal growth rate (or exit multiple) explicitly shows how much NPV changes across plausible terminal-value assumptions, making the sensitivity transparent. Best practice is to disclose the sensitivity in the model output. Replacing the DCF, arbitrarily raising the discount rate, or extending the forecast period to 50 years are bandaid fixes that don't address the underlying uncertainty.

Question 20Role knowledge and relevant financial foundations

A retail company's cost-per-unit driver model would best forecast COGS by:

  1. Forecasting units sold and multiplying by unit cost adjusted for inflation Correct answer.
  2. Applying last year's gross margin percentage to projected revenue
  3. Using a flat percentage of total operating expenses
  4. Forecasting headcount and multiplying by average salary

Explanation

A driver-based COGS model forecasts units sold (volume) and multiplies by unit cost (with inflation, FX, or commodity adjustments). This connects COGS to operational decisions and lets FP&A explain margin moves by volume vs. cost-per-unit changes. Applying a flat margin or expense percentage hides the underlying drivers and weakens variance analysis.

Question 21Role knowledge and relevant financial foundations

Which budgeting methodology requires every expense to be justified from a zero base each year, regardless of the prior year's spend?

  1. Incremental budgeting
  2. Zero-based budgeting (ZBB) Correct answer.
  3. Activity-based budgeting (ABB)
  4. Beyond budgeting

Explanation

Zero-based budgeting (ZBB) requires every line item to be built up from zero and justified anew each cycle, rather than starting from prior-year spend and adjusting. Popularized by 3G Capital in the 2010s, ZBB is intended to root out legacy waste but is resource-intensive and can be disruptive if applied annually to the entire P&L without nuance.

Question 22Role knowledge and relevant financial foundations

Which of the following best describes a rolling forecast?

  1. A budget locked at the start of the fiscal year and never updated
  2. A continuously updated forecast that always extends a fixed number of periods (e.g., 12-18 months) into the future Correct answer.
  3. A bottom-up build of every cost center for the calendar year
  4. A 5-year strategic plan refreshed annually

Explanation

A rolling forecast refreshes the forward-looking view on a regular cadence (typically monthly or quarterly) and always extends the same number of periods ahead - for example, a 12- or 18-month rolling horizon. As one period closes, a new period is added at the far end. This avoids the 'forecast horizon shrinks toward year-end' problem of static annual budgets and supports more agile decision-making.

Question 23Role knowledge and relevant financial foundations

The acronym AOP in FP&A stands for:

  1. Annual Operating Plan Correct answer.
  2. Asset Optimization Program
  3. Allocated Overhead Pool
  4. Adjusted Operating Profit

Explanation

AOP stands for Annual Operating Plan - the detailed, bottom-up budget for the upcoming fiscal year. It typically includes targets for revenue, expenses, headcount, capex, and key KPIs by business unit and is the baseline against which variance is reported. The AOP is usually approved by the board and feeds the long-range plan (LRP).

Question 24Role knowledge and relevant financial foundations

The Long-Range Plan (LRP) typically covers what time horizon?

  1. 1 quarter
  2. 1 year
  3. 3-5 years Correct answer.
  4. 10+ years

Explanation

The LRP (sometimes called the Strategic Plan or 5-Year Plan) typically covers 3-5 years and translates strategy into financial targets for revenue, margin, capex, and key initiatives. It is refreshed annually and provides the strategic context for each year's AOP. Horizons longer than 5 years are too uncertain; shorter than 3 years collapses into operational planning.

Question 25Role knowledge and relevant financial foundations

Activity-based budgeting (ABB) differs from traditional budgeting because it:

  1. Allocates budgets to departments based on headcount only
  2. Allocates budgets based on the cost drivers of business activities required to achieve operational goals Correct answer.
  3. Eliminates the need for variance analysis
  4. Uses only top-down targets from the CEO

Explanation

ABB starts with the activities required to deliver products and services, identifies the cost drivers of those activities, and then derives the budget from expected activity volumes. For example, if call center cost is driven by call volume, ABB forecasts calls and applies a cost-per-call rate. This produces more accurate budgets when activity is the main cost driver, but it requires high-quality activity data.

Question 26Role knowledge and relevant financial foundations

Beyond Budgeting (BB), as developed by Bjarte Bogsnes and the Beyond Budgeting Roundtable, advocates for:

  1. Replacing annual fixed budgets with rolling forecasts, relative performance targets, and decentralized decision-making Correct answer.
  2. Adding more layers of budget approvals to improve control
  3. Building a single-version five-year budget locked at the start of the period
  4. Eliminating all forecasting because the future cannot be predicted

Explanation

Beyond Budgeting argues that the annual fixed budget is a flawed control mechanism that drives gaming, sandbagging, and short-termism. It proposes replacing the annual budget with rolling forecasts, relative performance targets (vs peers or market benchmarks), and decentralized decision authority. Statoil/Equinor, Handelsbanken, and others are well-known adopters.

Question 27Role knowledge and relevant financial foundations

An FP&A team performs a quarterly reforecast. The primary purpose is to:

  1. Replace the AOP and reset all targets
  2. Update the year-end landing view based on actuals year-to-date plus an updated outlook for the remaining quarters Correct answer.
  3. Allocate additional bonus budget
  4. Build the next year's plan

Explanation

A reforecast updates the expected year-end outcome by combining actuals already booked with a refreshed forecast for the remaining periods. The original AOP typically stays on the scoreboard for accountability, but the reforecast gives the leadership team a current best-estimate of where the year will land - enabling course-correction on hiring, spend, and investment.

Question 28Role knowledge and relevant financial foundations

A company's marketing director argues for adding $500K to the budget because customer acquisition has slowed. Under incremental budgeting, the most likely starting point would be:

  1. Last year's marketing spend Correct answer.
  2. A zero baseline with full justification of every dollar
  3. A target percentage of revenue
  4. An activity-based build by campaign

Explanation

Incremental budgeting begins with the prior period's actual or budget and adjusts up or down. It is fast and politically easier than ZBB but tends to lock in legacy spend and inefficiencies. Under incremental, the marketing director's request would be evaluated as an addition to last year's baseline, not a fresh justification of the entire spend.

Question 29Role knowledge and relevant financial foundations

Top-down budgeting is most appropriate when:

  1. The CEO wants every cost center to build its own plan from operational drivers
  2. Senior leadership has set strategic targets that must be allocated down to business units Correct answer.
  3. The company has eliminated all centralized planning
  4. The company uses activity-based costing exclusively

Explanation

Top-down budgeting starts with strategic targets (revenue growth, margin, capex envelope) set by senior leadership and cascades them to business units. It is fast and ensures alignment with strategy but can demoralize teams if targets feel unrealistic. Bottom-up budgeting, the inverse, builds from cost-center submissions and rolls up - slower but typically more accurate and more 'owned' by operational leaders.

Question 30Role knowledge and relevant financial foundations

A driver-based budget for a call center would most likely include which of the following primary drivers?

  1. Office square footage
  2. Forecasted call volume × average handle time × cost per agent-hour Correct answer.
  3. Marketing spend × conversion rate
  4. Inventory turns

Explanation

A call center is a clear driver-based context: cost is driven by labor required to handle calls. The Erlang-style formula is forecasted call volume × average handle time = required agent-hours; multiplied by cost per agent-hour (loaded with benefits) = labor cost. Add tech, real estate, and overhead allocations on top. This decomposition makes variance explainable and enables capacity planning.

Question 31Role knowledge and relevant financial foundations

An FP&A team is debating whether to keep an annual budget or move to a 12-month rolling forecast. Which factor most favors the rolling forecast?

  1. The company operates in a stable, mature industry with predictable demand
  2. Senior leaders want a single locked target to drive accountability
  3. The business faces high volatility and frequent strategic shifts that erode the budget's relevance within months Correct answer.
  4. The audit committee requires a fixed budget for SOX controls

Explanation

Rolling forecasts shine in volatile environments where the static annual budget becomes stale within months - leadership benefits from a continuously refreshed 12-18 month outlook. Stable industries, locked-target accountability, and audit/SOX requirements often favor a more traditional annual budget. Many companies run both: locked AOP for accountability + rolling forecast for decision support.

Question 32Role knowledge and relevant financial foundations

Which budgeting approach is most aligned with continuous improvement and lean operations?

  1. Incremental budgeting
  2. Activity-based budgeting (ABB) Correct answer.
  3. Negotiated budgeting
  4. Mandated budgeting

Explanation

Activity-based budgeting forces explicit identification of activities, their cost drivers, and the unit cost of each activity. This visibility supports lean operations because waste shows up as activities with low value relative to cost. Incremental budgeting can hide waste; mandated and negotiated approaches focus on number-setting rather than activity efficiency.

Question 33Role knowledge and relevant financial foundations

In the FP&A planning calendar, which sequence is most typical?

  1. AOP → LRP → Monthly forecast → Quarterly reforecast
  2. LRP → AOP → Monthly forecast → Quarterly reforecast Correct answer.
  3. Monthly forecast → AOP → LRP → Quarterly reforecast
  4. Quarterly reforecast → Monthly forecast → AOP → LRP

Explanation

Strategic planning flows from longer-term to shorter-term: LRP (3-5 years) sets strategic guardrails → AOP (12 months) builds the detailed plan for next year → monthly forecasts and quarterly reforecasts update the in-year landing view. This top-of-funnel-to-execution sequence ensures the AOP is grounded in strategy and that ongoing forecasts are anchored to the AOP target.

Question 34Role knowledge and relevant financial foundations

Which budgeting approach is most likely to drive 'use it or lose it' year-end spending behavior?

  1. Zero-based budgeting
  2. Beyond budgeting
  3. Incremental budgeting Correct answer.
  4. Rolling forecast

Explanation

Incremental budgeting starts with last year's number, so departments learn that any underspend in Q4 risks being cut from next year's baseline. This famously drives the 'use it or lose it' behavior at year-end. ZBB resets every year so there is no baseline to protect; beyond budgeting and rolling forecasts decouple performance from a fixed annual envelope.

Question 35Role knowledge and relevant financial foundations

A flexible budget differs from a static budget primarily in that it:

  1. Cannot be used for variance analysis
  2. Adjusts budgeted variable costs and revenues based on actual activity volume Correct answer.
  3. Eliminates fixed costs entirely
  4. Is updated monthly with actuals

Explanation

A flexible budget recalculates the expected revenue and variable costs at the actual volume of activity achieved. This isolates volume effects and lets variance analysis distinguish 'volume variance' (volume vs plan) from 'flex budget variance' (price/efficiency at the achieved volume). A static budget compares actuals to the originally planned volume, mixing volume and price/efficiency effects.

Question 36Role knowledge and relevant financial foundations

For a high-growth SaaS company with rapid product launches and frequent pricing changes, which forecasting approach is generally most appropriate?

  1. Incremental budgeting based on prior year
  2. A driver-based rolling forecast updated monthly with cohort and pipeline data Correct answer.
  3. A locked annual top-down target with no in-year updates
  4. Activity-based budgeting using last year's call volumes

Explanation

High-growth SaaS environments change too fast for incremental or locked annual approaches. A driver-based rolling forecast updated monthly - built on the SaaS metric stack (ARR roll-forward, NRR/GRR, pipeline coverage, CAC payback) - gives leadership the speed and explanatory power they need to course-correct as launches and pricing changes hit.

Question 37Role knowledge and relevant financial foundations

When introducing zero-based budgeting in a large organization, a common pitfall is:

  1. Generating too much detailed activity insight
  2. Underestimating the time and resource cost of building every line from scratch annually Correct answer.
  3. Reducing transparency into spending decisions
  4. Eliminating the need for variance analysis

Explanation

ZBB is resource-intensive - building every cost from zero requires deep activity analysis, cross-functional time, and disciplined process. Many initial ZBB rollouts underestimate this and burn out the finance team or business partners. Best-practice modern adopters apply ZBB selectively (e.g., one major spend category per year on a multi-year rotation) rather than applying it across the whole P&L every year.

Question 38Role knowledge and relevant financial foundations

A 'stretch' budget target set above realistic expectations is best paired with which performance management practice?

  1. Tying 100% of bonus payouts to hitting the stretch target exactly
  2. Communicating clearly that the stretch is an aspirational goal, not the commit, and using a separate commit number for accountability Correct answer.
  3. Refusing to share the budget with operating teams
  4. Removing all reforecasts during the year

Explanation

Stretch targets motivate performance only if teams understand they are aspirational. Best practice is to publish two numbers: the commit (the realistic plan used for accountability and bonus thresholds) and the stretch (the aspirational upside used for ambition). Tying 100% of bonus to a stretch target drives gaming, sandbagging, and demoralization when teams perceive the target as unattainable.

Question 39Role knowledge and relevant financial foundations

Which of the following best describes the purpose of a driver-based budget?

  1. Eliminate the need for forecasting
  2. Connect financial outcomes to the operational drivers that produce them, enabling faster updates and clearer variance explanations Correct answer.
  3. Allocate budget by headcount only
  4. Hide assumptions in formulas to simplify reporting

Explanation

Driver-based budgets explicitly model how operational metrics (volume, price, headcount, productivity) produce financial outcomes. The benefits are speed (changing one assumption recalculates the plan), explainability (variance traces back to specific drivers), and shared ownership (operators understand and own the assumptions). It does not eliminate forecasting - it makes forecasting more disciplined.

Question 40Role knowledge and relevant financial foundations

A common best practice for a 12-18 month rolling forecast is to:

  1. Lock the next-quarter view and treat the rest as fixed
  2. Use higher granularity (e.g., monthly, account-level) for near-term periods and lower granularity (quarterly, P&L-level) for the back-end of the horizon Correct answer.
  3. Update only annually to reduce workload
  4. Forecast only revenue and ignore expenses

Explanation

Rolling forecasts gain speed by using higher granularity for near-term periods (where decisions are made) and lower granularity for the far end (where uncertainty is high). For example: monthly account-level forecast for the next 6 months, then quarterly P&L-level forecast for months 7-18. This avoids spurious precision and keeps the forecast manageable.

Question 41Role knowledge and relevant financial foundations

Actual revenue is $1,050K vs Budget of $1,000K. Volume sold was 10% above plan and price was 4% below plan. The favorable revenue variance is primarily explained by:

  1. Price effect overwhelming volume effect
  2. Volume effect more than offsetting an unfavorable price effect Correct answer.
  3. Mix shift to higher-margin products
  4. FX tailwind

Explanation

A +10% volume effect at constant price would lift revenue from $1,000K to $1,100K. A −4% price effect on the new volume reduces it by roughly $44K to about $1,056K. The favorable variance is therefore driven by volume more than offsetting an unfavorable price effect - the classic outcome when a company discounts to chase volume. Mix and FX effects could also play a role, but the question fixed those out by giving only volume and price.

Question 42Role knowledge and relevant financial foundations

Which of the following is the correct order of comparison in a typical FP&A variance report?

  1. Actual vs Budget; Actual vs Forecast; Actual vs Prior Year Correct answer.
  2. Budget vs Forecast vs Prior Year only
  3. Forecast vs Budget only
  4. Actual vs Budget only

Explanation

A complete variance report typically shows multiple lenses: Actual vs Budget (vs original plan, accountability lens), Actual vs Forecast (vs latest reforecast, current operating reality), and Actual vs Prior Year (year-over-year growth). Each comparison answers a different question, and good reports separate them rather than collapsing them into a single 'variance' column.

Question 43Role knowledge and relevant financial foundations

In contribution margin variance analysis, the 'sales mix variance' captures:

  1. The effect of selling more total units than planned
  2. The effect of changing the proportion of higher- vs lower-margin products in the actual sales mix Correct answer.
  3. The change in product cost per unit
  4. The change in selling price per unit

Explanation

Sales mix variance measures the effect on contribution margin of selling a different mix of products than planned - even at the same total volume. If actuals shift toward higher-margin SKUs vs the plan, mix is favorable; toward lower-margin SKUs, unfavorable. Volume variance captures total units; price variance captures average selling price. Mix isolates the composition effect.

Question 44Role knowledge and relevant financial foundations

A static budget variance is calculated as:

  1. Actual results minus the original budget at the originally planned activity level Correct answer.
  2. Actual results minus the flexible budget at the actual activity level
  3. Flexible budget minus the original budget
  4. Actual results minus the prior year actuals

Explanation

The static budget variance compares actual results to the original budget at the originally planned activity level. It is the headline 'vs Budget' number on most management reports. To decompose it, FP&A then calculates the flexible budget variance (Actual vs Flex Budget at actual volume) and the volume variance (Flex Budget vs Static Budget) - together they sum to the static budget variance.

Question 45Role knowledge and relevant financial foundations

Which of the following KPIs is most relevant for monitoring SaaS revenue retention?

  1. Average Order Value (AOV)
  2. Net Revenue Retention (NRR) and Gross Revenue Retention (GRR) Correct answer.
  3. RevPAR (Revenue per Available Room)
  4. Occupancy rate

Explanation

NRR measures revenue retained from existing customers including upsells and cross-sells minus churn and downsell. GRR measures retention before any expansion (so it caps at 100%). Together they tell you both stickiness (GRR) and the strength of the expansion motion (NRR > 100% means existing customers grow faster than they churn). Best-in-class SaaS targets NRR > 120% and GRR > 90%.

Question 46Role knowledge and relevant financial foundations

RevPAR is most commonly used as a KPI in which industry?

  1. SaaS
  2. Hospitality (hotels) Correct answer.
  3. Retail
  4. Manufacturing

Explanation

RevPAR (Revenue per Available Room) is a standard hospitality KPI that combines occupancy rate and average daily rate (ADR): RevPAR = ADR × Occupancy = Total Room Revenue ÷ Available Room-Nights. It captures both volume (occupancy) and price (ADR) in a single metric, which is why it's the headline operating KPI for hotels.

Question 47Role knowledge and relevant financial foundations

An FP&A analyst is preparing a board pack. Which of the following is the LEAST appropriate inclusion?

  1. Top-line P&L vs Budget and PY with key drivers explained
  2. Cash position and runway
  3. Granular general-ledger transaction listings for every cost center Correct answer.
  4. Strategic KPI scorecard (revenue growth, margin, cash, headcount)

Explanation

Board packs should be at the strategic level - P&L vs Budget/PY, cash and runway, KPI scorecard, and forward-looking risks and opportunities. Granular GL transaction listings belong in operational reviews or audit packs, not board materials. The board's role is governance and strategy, not transaction-level review.

Question 48Role knowledge and relevant financial foundations

When breaking down revenue variance into price-volume-mix using the 'price-then-volume' convention:

  1. Price variance = (Actual Price − Budget Price) × Budget Volume; Volume variance = (Actual Volume − Budget Volume) × Actual Price
  2. Price variance = (Actual Price − Budget Price) × Actual Volume; Volume variance = (Actual Volume − Budget Volume) × Budget Price Correct answer.
  3. Price and volume variances are always equal
  4. Mix variance is calculated before price

Explanation

The most common decomposition is: Price variance = (Actual Price − Budget Price) × Actual Volume, and Volume variance = (Actual Volume − Budget Volume) × Budget Price. The two variances plus the joint effect together sum to the total revenue variance. The order matters because the joint effect is typically allocated to one side (most commonly assigned to price by convention).

Question 49Role knowledge and relevant financial foundations

EBITDA is computed as:

  1. Net income plus interest, taxes, depreciation, and amortization Correct answer.
  2. Operating cash flow plus capex
  3. Revenue minus COGS
  4. Net income minus dividends

Explanation

EBITDA = Net Income + Interest + Taxes + Depreciation + Amortization. It removes the effects of capital structure (interest), tax jurisdiction, and non-cash accounting (D&A) to approximate operating cash earnings. Equivalently, EBITDA = Operating Income (EBIT) + D&A. EBITDA is widely used in lender covenants, M&A multiples, and operational performance reporting, but it is not a substitute for true cash flow.

Question 50Role knowledge and relevant financial foundations

Which KPI pair is most relevant for an e-commerce retail business?

  1. RevPAR and ADR
  2. ARR and NRR
  3. AOV (Average Order Value) and ATV (Average Transaction Value) Correct answer.
  4. Capacity utilization and OEE

Explanation

AOV (Average Order Value) and ATV (Average Transaction Value) measure how much customers spend per order/transaction and are core retail KPIs alongside conversion rate, traffic, and gross margin. Hotels use RevPAR/ADR; SaaS uses ARR/NRR; manufacturing uses utilization and OEE.