CFP Financial Modeling & Forecasting 2 — Questions and Answers
Question 1: In a three-statement financial model, which statement serves as the primary driver that links the income statement to the balance sheet?
- Cash flow statement (Correct answer)
- Statement of retained earnings
- Statement of stockholders' equity
- Notes to financial statements
Correct answer: Cash flow statement
The cash flow statement bridges the income statement and balance sheet by reconciling net income to cash movements and updating ending cash on the balance sheet.
Question 2: A fintech startup projects 40% YoY revenue growth for three years, then 10% terminal growth. Which modeling technique best captures this transition?
- Straight-line extrapolation
- Two-stage DCF model (Correct answer)
- Comparable company analysis
- Payback period analysis
Correct answer: Two-stage DCF model
A two-stage DCF separates high-growth phases from stable terminal growth, making it ideal for high-growth fintech companies transitioning to maturity.
Question 3: When building a revenue forecast for a SaaS fintech platform, which metric is most critical to model first?
- EBITDA margin
- Monthly Recurring Revenue (MRR) and churn rate (Correct answer)
- Gross margin percentage
- Capital expenditure schedule
Correct answer: Monthly Recurring Revenue (MRR) and churn rate
MRR combined with churn rate drives all downstream revenue projections for subscription-based SaaS fintech businesses.
Question 4: A sensitivity analysis table in Excel shows NPV values across different WACC and growth rate combinations. What type of analysis is this?
- Monte Carlo simulation
- Scenario analysis
- Data table sensitivity analysis (Correct answer)
- Breakeven analysis
Correct answer: Data table sensitivity analysis
A two-variable data table in Excel is the standard tool for sensitivity analysis, showing NPV outcomes across a matrix of input combinations.
Question 5: In modeling loan loss provisions for a fintech lender, which approach aligns with CECL (Current Expected Credit Loss) accounting?
- Incurred loss model based on historical charge-offs
- Lifetime expected loss model using forward-looking data (Correct answer)
- Simple percentage of outstanding balances
- Loss provisioning only upon default event
Correct answer: Lifetime expected loss model using forward-looking data
CECL requires recognition of lifetime expected credit losses using forward-looking information, replacing the incurred loss model.
Question 6: Which forecasting method assigns exponentially decreasing weights to older historical data points?
- Simple moving average
- Linear regression
- Exponential smoothing (Correct answer)
- Seasonal decomposition
Correct answer: Exponential smoothing
Exponential smoothing weights recent observations more heavily than older data, making it effective for time series with trends.
Question 7: A fintech model shows Days Sales Outstanding (DSO) increasing from 30 to 45 days. What is the most likely balance sheet impact?
- Accounts payable increases
- Accounts receivable increases (Correct answer)
- Inventory levels rise
- Long-term debt increases
Correct answer: Accounts receivable increases
Higher DSO means customers are taking longer to pay, which directly increases the accounts receivable balance on the balance sheet.
CFP Financial Modeling & Forecasting 2
In a three-statement financial model, which statement serves as the primary driver that links the income statement to the balance sheet?