Financial Modeling Valuation Wall Street Training [new]
Financial Modeling & Valuation training offered by Wall Street Training & Advisory (WST)
- Download a 10-K: Pick Apple or Microsoft. Build a five-year forecast. Do not use a template.
- Learn the shortcuts: If you touch your mouse during a model audit, you are slow. Learn
Alt shortcuts and Ctrl + [ for tracing precedents.
- Stress test your model: Break a cell on purpose. Does the whole thing blow up? A robust model has error checks (e.g., Balance Sheet must balance to $0).
Apply Multiples: Determine a range (e.g., 6.0x – 8.0x EBITDA) and apply it to the target company’s EBITDA to derive Enterprise Value.The Importance of Financial Modeling
- Don’t be a "Sheet Monkey": Understand the business drivers before building formulas.
- Garbage In, Garbage Out (GIGO): The best model with bad assumptions is worthless. 80% of your time should be on assumptions and sanity checks.
- Auditability Over Complexity: If another analyst cannot follow your logic within 5 minutes, the model is useless. No hardcoding numbers; use cell references and flags.
- Why? On a live deal, no template exists. You must structure the timeline, color-code inputs (blue) vs. formulas (black), and decide where to place headers.
- A good program will have you build: The IS, BS, and CFS from scratch in the first 2 hours.
Yes, bulge bracket banks have two-week training programs. Yes, Breaking Into Wall Street (BIWS) and Wall Street Prep are excellent. But the actual "training" happens when you build your first model from a blank Excel sheet—not a template. Financial Modeling Valuation Wall Street Training