Modeling tests
Timed, built in the sheet, checked cell by cell. Pass mark 80.
- 0
- of 6 passed
- Link the three statementsProOne year, three statements, a balance sheet that balances.25 minNot taken
- Returns sensitivity tableProIRR by entry and exit multiple, one formula, mixed references.20 minNot taken
- DCF to share priceProUnlevered free cash flow, terminal value, equity per share.35 minNot taken
- Earnings build to EPSProSegments to revenue, margins to EPS, a buyback in the share count.30 minNot taken
- FX forward and carryProA forward from two rates, then a carry trade and its breakeven.25 minNot taken
- Portfolio return and riskProThree assets, one correlation matrix, Sharpe and active bets.25 minNot taken