Financial Modeling & Forecasting Flashcards

Which forecasting method is most appropriate when procurement data shows a strong seasonal pattern combined with an upward trend?

Answer: Holt-Winters triple exponential smoothing

Holt-Winters triple exponential smoothing accounts for level, trend, and seasonality simultaneously, making it ideal when all three components are present.

A procurement analyst uses Monte Carlo simulation in a cost forecast. The primary advantage of this approach is:

Answer: It generates a probability distribution of possible outcomes by running thousands of scenarios

Monte Carlo simulation randomly samples from input distributions thousands of times to build a probability distribution of possible outputs, capturing the full range of uncertainty.

When building a supplier price escalation model for a multi-year contract, which index is most commonly used as a benchmark for manufactured goods cost changes?

Answer: Producer Price Index (PPI)

The Producer Price Index tracks price changes from the seller's perspective for goods at various production stages, making it the standard benchmark for manufactured input cost escalation clauses.

In a lease-versus-buy financial model for equipment procurement, the appropriate discount rate to use when evaluating the lease option is typically:

Answer: The after-tax cost of debt, since lease payments are debt-like obligations

Lease payments are contractual, debt-like obligations, so discounting them at the after-tax cost of debt aligns the risk profile of the cash flows with the discount rate.

A purchasing department forecasts $10M in annual spend with a 5% price reduction target. If actual prices drop by only 3%, which metric best quantifies the shortfall?

Answer: Purchase price variance (PPV) of $200,000 unfavorable

Purchase price variance measures the difference between standard (budgeted) price and actual price multiplied by quantity; missing the 5% target by 2% on $10M equals $200,000 unfavorable PPV.

Which financial model structure best supports a 'build-or-buy' decision for a component currently sourced externally?

Answer: Discounted cash flow (DCF) comparing NPV of make option versus buy option

A DCF model comparing the net present value of make versus buy captures all relevant cash flows over time (capital investment, operating costs, opportunity costs) and accounts for the time value of money.

In procurement financial modeling, 'price elasticity of demand' is most relevant when assessing:

Answer: How purchase volumes are likely to change if internal transfer prices shift

Price elasticity of demand measures how sensitive the quantity demanded is to a price change, relevant in procurement when modeling how internal customers will respond to changes in charge-back or transfer prices.