DCF Model Test (20 mins)
Excel-based DCF modeling assessment for candidates building core valuation skills.
Background: This test focuses on bottom-up DCF fundamentals: calculating WACC from unlevered beta, projecting discounted cash flows, and deriving NPV and equity value. It develops the technical precision and execution speed expected in professional investment roles.
Time Limit: 20 minutes
Usage: Downloadable file. Test may be completed multiple times
What's Included:
Excel modelling template with input sheets
Automated validation and grading
Worked solution model showing correct approach
Key Skills:
DCF valuation
WACC calculation
Returns calculation
Users:
Investment banking analysts
Equity research analysts
Candidates preparing for technical interviews
DCF modelling test including WACC calculation.
