Financial Analyst question bank
100 questions. Filter by level and skill, track what you've solved, and see how many people get each one right.
- The accounting equation
- Calculating the current ratio
- Gross margin percentage
- Why depreciation is added back
- Snapshot or period statement
- Reading a revenue variance
- Break-even volume
- Simple payback period
- When revenue is recognised
- Calculating the quick ratio
- Net profit margin
- Finding operating profit (EBIT)
- From EBIT to EBITDA
- Net working capital amount
- Where a machine purchase appears
- Repaying a bank loan
- Reading a cost variance
- Year-on-year growth
- Compound annual growth rate
- Spotting a variable cost
- Present value of one payment
- Future value with compounding
- Return on equity
- Inventory turnover
- Classifying trade payables
- Totals by region and month
- Locking a cell reference
- When to use Goal Seek
- Capex or opex
- Margin of safety
- Basic earnings per share
- Price to earnings ratio
- Interest coverage ratio
- Effective tax rate
- Retained earnings roll-forward
- Days sales outstanding
- Cash conversion cycle
- Operating cash flow, indirect method
- NPV of a single future inflow
- Debt to equity ratio
- XLOOKUP default behaviour
- Sales needed for a target profit
- Days payable outstanding
- Days inventory outstanding
- Total asset turnover
- DuPont analysis of ROE
- Unlevered free cash flow
- Free cash flow to equity
- Flexing the budget for volume
- Splitting price and volume
- Present value of an annuity
- NPV with two inflows
- Discounted payback period
- Two-way lookup in a grid
- Using an Excel data table
- What a 12-month rolling forecast covers
- Zero-based budgeting
- Profit up, cash down
- Deferred revenue on annual billing
- From MRR to ARR
- Net revenue retention
- CAC payback period
- Cash runway
- Net debt to EBITDA
- Cost of equity with CAPM
- Treating sunk costs
- Markup versus margin
- Working capital needed for growth
- Calculating WACC
- Terminal value with perpetual growth
- From enterprise value to share price
- Valuing with a peer EV/EBITDA multiple
- IRR of a two-year investment
- Operating leverage and EBIT
- LTV to CAC for a SaaS business
- Debt service coverage ratio
- How much value is in the terminal
- Relevering an unlevered beta
- Discounting the terminal value
- Growth implied by an exit multiple
- Mid-year convention discount factor
- Diluted shares with the treasury stock method
- Equity bridge with minority interest
- When IRR gives more than one answer
- Probability-weighted scenarios
- Reading a tornado chart
- Fixed costs rise, break-even moves
- Headroom under a leverage covenant
- Applying the Rule of 40
- Contribution per delivery order
- Earnings quality warning sign
- Choosing EV/EBITDA over P/E
- Handling an interest circularity
- IRR with irregular dates
- Real and nominal discount rates
- Lease accounting and EBITDA
- Splitting the first EMI
- Is the acquisition premium worth it
- Growth with negative working capital
- Valuing a share with the dividend discount model