APP Financial Modeling & Forecasting 3 — Questions and Answers
Question 1: A procurement team is evaluating a supplier's financial stability. Which ratio most directly indicates a supplier's short-term liquidity risk?
- Gross profit margin
- Current ratio (Correct answer)
- Price-to-earnings ratio
- Return on equity
Correct answer: Current ratio
The current ratio (current assets ÷ current liabilities) directly measures a supplier's ability to meet short-term obligations with available liquid assets.
Question 2: When forecasting commodity prices for a procurement budget, a mean reversion model assumes that:
- Prices will follow the same trend indefinitely
- Prices will eventually return toward their long-run historical average (Correct answer)
- Price volatility increases over time
- Future prices equal current spot prices
Correct answer: Prices will eventually return toward their long-run historical average
Mean reversion models assume commodity prices fluctuate around a long-term equilibrium and will 'revert' toward that mean after extreme deviations.
Question 3: In a procurement cost model, 'should-cost' analysis is used to:
- Record actual invoiced amounts from suppliers
- Estimate what a product or service ought to cost based on its components (Correct answer)
- Forecast future exchange rate impacts on imported goods
- Calculate the NPV of a long-term supply contract
Correct answer: Estimate what a product or service ought to cost based on its components
Should-cost analysis builds a cost estimate from materials, labor, overhead, and profit to establish a target price and strengthen negotiation positions.
Question 4: Which of the following best describes 'sensitivity analysis' in the context of a procurement financial model?
- Analyzing how changes in one input variable affect the model's output (Correct answer)
- Reviewing a supplier's emotional response to price negotiations
- Calculating the standard deviation of historical spend data
- Comparing actual costs to budgeted costs after the period ends
Correct answer: Analyzing how changes in one input variable affect the model's output
Sensitivity analysis systematically varies one input at a time to measure its impact on the output, identifying which assumptions most affect the forecast.
Question 5: Days Payable Outstanding (DPO) is calculated as:
- (Accounts Payable ÷ COGS) × 365 (Correct answer)
- (COGS ÷ Accounts Payable) × 365
- (Accounts Receivable ÷ Revenue) × 365
- (Inventory ÷ COGS) × 365
Correct answer: (Accounts Payable ÷ COGS) × 365
DPO = (Accounts Payable ÷ COGS) × 365, measuring the average number of days a company takes to pay its suppliers.
Question 6: A procurement manager is assessing total cost of ownership (TCO). Which cost category is most likely to be underestimated if only the purchase price is considered?
- Invoice price
- Transaction processing and administration costs (Correct answer)
- Quantity discounts received
- Standard catalog pricing
Correct answer: Transaction processing and administration costs
TCO includes acquisition price plus hidden costs such as ordering, receiving, inspection, defects, and disposal, which are often invisible in the purchase price alone.
Question 7: In working capital modeling for procurement, extending supplier payment terms from 30 to 60 days primarily affects which financial metric?
- Gross profit margin
- Days Payable Outstanding (DPO) (Correct answer)
- Inventory turnover
- Operating leverage
Correct answer: Days Payable Outstanding (DPO)
Extending payment terms directly increases DPO, freeing up cash by delaying outflows to suppliers and improving short-term working capital.
A procurement team is evaluating a supplier's financial stability.
Which ratio most directly indicates a supplier's short-term liquidity risk?