An FP&A analyst is building a rolling forecast for a SaaS business. Which structure best fits a driver-based revenue model?
Analysis Projections
Question · Easy
A 13-period rolling forecast differs from a static annual budget primarily because it:
An FP&A team observes a $480K unfavorable revenue variance. Units sold were 4% higher than plan but the average selling price was 7% lower. The dominant driver of the variance is most likely:
Question · Medium
Finance Exam Prep Podcast
Listen on Spotify
Podcast
In variance analysis, the standard formula for price variance is:
A product mix variance is best described as the impact on profit from:
A project has an initial outlay of $1,000,000 and generates $300,000 per year for 5 years. The cost of capital is 10%. Using the annuity factor for 5 years at 10% of 3.7908, the NPV is approximately:
Which statement about IRR is correct?
When ranking two mutually exclusive capital projects, why is NPV generally preferred over IRR?
Discounted payback period differs from simple payback because it:
A company's WACC is 9%. A proposed project's IRR is 8.5% but its NPV at the firm's WACC is +$120,000. Which decision is most consistent with shareholder-value maximization?
Question · Hard
Sensitivity analysis answers which question best?
A scenario analysis differs from a sensitivity analysis primarily because scenarios:
Monte Carlo simulation in financial modeling is best used when:
Models Analytics
A tornado chart in a sensitivity analysis is read by:
When projecting the three financial statements, the most reliable starting point is usually the:
If projected DSO rises from 45 to 60 days while revenue stays flat, the immediate impact on the balance sheet is:
An analyst is modeling a make-vs-buy decision. Which cost should be excluded from the relevant cash flow analysis?
A pricing scenario lifts price by 5% but volume falls by 7%. Assuming variable cost per unit is flat, the impact on gross profit dollars is:
A break-even units calculation for a product with fixed costs of $400,000, price of $50, and variable cost of $30 per unit is:
Operating leverage is high when:
A flexible budget for performance evaluation adjusts:
An analyst projects customer-level revenue from CRM data. Which segmentation is most consistent with driver-based projections?
Working-capital investment in a project's incremental cash flow analysis is treated as:
Salvage value of equipment at the end of a project's life should be included in NPV analysis:
A best practice when building a 'what-if' analysis in Excel is to:
A reviewer notices that a model uses the same hard-coded growth rate in seven places. The most efficient remediation is to:
Which spreadsheet function is best for looking up a unit price from a product table when the lookup column might be reordered later?
A circular reference in a financial model is most acceptable when modeling:
An analyst running a linear regression of monthly sales on advertising spend reports R² = 0.85. The correct interpretation is:
When forecasting monthly revenue with strong seasonality, which approach is most appropriate?
A weighted moving average differs from a simple moving average primarily because it:
Forecast accuracy is most commonly measured with MAPE (mean absolute percentage error). MAPE has a known weakness when:
A regression of cost-of-sales on units produced shows a slope of $14.20 and an intercept of $1,200,000. The intercept is best interpreted as:
An FP&A team builds a model that integrates ERP general-ledger data with CRM pipeline data. The biggest data-quality risk to address first is:
A 'reasonableness check' on a financial forecast is best illustrated by:
An analyst's model returns a total expense $4M lower than the prior period despite no operational change. The first audit step should be:
When designing a corporate KPI for FP&A, the SMART criteria require that the KPI be:
A leading KPI for a subscription business that predicts future revenue is:
Which dashboard design principle most reduces cognitive load for executives?
Business Communication
An analyst must show how Q3 revenue moved from $200M to $230M across three drivers (volume +$20M, price +$15M, mix −$5M). The best chart is:
An executive deck communicating a major variance should follow the pyramid principle by:
Tailoring an FP&A update for the CFO vs a line-of-business GM means:
A pre-attentive visual attribute that lets the viewer spot an outlier on a dashboard without conscious search is:
When an executive asks a question for which the analyst does not have the answer, the best response is to:
A variance analysis comparing actuals to a static budget can be misleading when:
Net working capital changes affect free cash flow such that:
A projected interest coverage ratio (EBIT / interest expense) is most useful for:
Loading more…