Financial Modeling Valuation | Wall Street Training !exclusive!

Financial Modeling & Valuation training offered by Wall Street Training & Advisory (WST)

Pro Tip: After building the model, tear it down. Change the revenue growth from 5% to -2%. See if your output breaks. If it does, fix it. Financial Modeling Valuation Wall Street Training

You cannot learn to swim by reading about water, and you cannot learn valuation by memorizing textbooks. You must sit down, open Excel, and build. Financial Modeling & Valuation training offered by Wall

EV/EBITDA: Most common for mature companies as it ignores capital structure.
EV/Revenue: Used for high-growth, unprofitable companies.
P/E Ratio: Focuses strictly on equity value.

To build a comprehensive financial model and valuation, several key components must be considered: EV/EBITDA: Most common for mature companies as it

Week 1 (10 Hours): Core Accounting & Three-Statement Model. Build the historical statements for a retail giant (Target or Walmart). Stop when the Balance Sheet balances.
Week 2 (10 Hours): DCF Construction. Build the UFCF. Calculate WACC using the AVERAGE function for Beta and Risk-Free Rate.
Week 3 (10 Hours): Trading Comps. Build a synergy matrix. Learn to pull the EBITDA of 10 competitors and compute the median multiple.
Week 4 (10 Hours): The LBO. Build a simple LBO model with 3 debt tranches. Learn to use GOAL SEEK and XIRR to find the return.

: mastering DCF (intrinsic), Relative Valuation (trading/deal comps), and "art vs. science" subjective adjustments. Advanced Enhancements

What is Valuation?