Choose Your Level
Pick the difficulty that matches where you are. You can come back and try a harder level later.
Build a Simple Revenue Model
Forecast 12 months of revenue for a subscription business using drivers.
Three-Statement Model Linkage
Explain and diagram how the three financial statements connect.
DCF Valuation of a Small Business
Value a fictional SA business using a discounted cash flow model.
Financial Modeling & DCF Company Valuation
Financial modeling translates business strategies into dynamic financial projections. Investment analysts and corporate finance professionals demonstrate expertise by constructing 3-statement integrated models, calculating WACC, running DCF valuations, and building sensitivity tables.
1. Integrated 3-Statement & DCF Valuation Model
Dynamic 3-statement financial model (.xlsx) featuring historical data, 5-year projections, and Discounted Cash Flow valuation.
2. Weighted Average Cost of Capital (WACC) Calculation Sheet
Cost of Capital model calculating Cost of Equity (CAPM), Cost of Debt, and target capital structure weightings.
3. Sensitivity & Scenario Analysis Matrix
2-way Excel data tables analyzing valuation changes based on discount rates and terminal growth rate assumptions.
Frequently Asked Questions (Financial Modelling & Valuation)
How do you calculate Free Cash Flow to Firm (FCFF)?
FCFF = EBIT * (1 - Tax Rate) + Depreciation & Amortization - Capital Expenditures - Change in Net Working Capital.
What is the Gordon Growth Model for Terminal Value?
Terminal Value = (Final Year FCFF * (1 + g)) / (WACC - g), where g is the perpetual long-term growth rate.
How do you calculate WACC?
WACC = (E/V * Cost of Equity) + (D/V * Cost of Debt * (1 - Corporate Tax Rate)).
Explore Finance & Accounting Career Paths
Build proof of work across other topics or view full career roadmaps mapping technical skills to hiring expectations.