The Valuation Training Program
Learn financial modeling and how to value a company!
The Valuation Training Program will give you the skills and knowledge to build financial models in Excel to value a company.
The Valuation Training Program
Overview
For Investment Banking, Corporate Finance, Private Equity, Equity Research, Hedge Funds, Asset Management, Sales & Trading, Corporate Law
The Valuation Training Program will give you the skills and knowledge to build financial models in Excel to value a company. The Training Program takes you step-by-step through the process of building a Comparable Company Analysis, Precedent Transactions Analysis, Discounted Cash Flow (DCF) Analysis, Leveraged Buy-Out Analysis and a M&A Accretion Dilution Analysis. Each Training Program includes completed Excel financial models and supporting documents which are available as downloads or on a CD-ROM. The financial models and supporting documents allow you to build your own financial models just as you would at a Wall Street job. It contains over 540 pages of invaluable training material
Our goal is to teach you valuation as if you were working at a Wall Street firm. We want you to learn everything and gain as much experience as you would gain if you worked on Wall Street. With this type of experience, you will be better prepared to successfully go through any interview process and receive job offers.
Key Topics (View All Topics-see below)
Learn how to value a real public company by building various valuation models from scratch
Learn the financial foundations of valuation and the underpinnings of each model
Step-by-step process to build a Discounted Cash Flow (DCF) Analysis Valuation Model
Step-by-step process to build a Comparable Company Analysis Valuation Model
Step-by-step process to build a Precedent Transactions Model
Step-by-step process to build a Leveraged Buy-out (LBO) Analysis
Step-by-step process to build a M & A Accretion/Dilution Analysis
All Topics:
% of 52 week high 10K 10Q 8K Accounts receivable Accretive Transaction Accrual Basis Acquirer Adjusting for Stock Splits Announcement Date Asset Write Up Assumed Perpetual Rate of Growth Balance Sheet Base Case Best Case Beta Book Value of Convertible Debt Book Value of Debt Book Value of Equity Break up Valuation Breakeven Point Calculating Compound Annual Growth Rate (CAGR) Calculating Last Twelve Months (LTM) Calculating Terminal Value Capital Asset Pricing Model (CAPM) Capital Expenditures (Capex) Capital Expenditures/Depreciation and Amortization Capital Expenditures/Sales Capital Lease Obligations Cash and equivalents Cash Basis Cash Flow Statement Cash Flows Combination Ratio Company Press Release Comparable Company Analysis Comps Consensus Estimates Consideration (%Stock/Cash) Controlling Stake Conversion Price Convertible Debt Convertible Preferred Stock Correlation between Financial Statements Cost of Debt Cost of Equity Cost of Financing Cost Synergies Credit Re-rating Currency and Exchange Rates Current Partial Period Debt and Interest Schedule Debt Capacity Debt Flows Debt holders Debt Service Credit Ratio Defense Depreciation and Amortization Depreciation and Amortization Margin Dilutive Transaction Discounted Cash Flow Analysis Divestitures Dividend Payout Ratio Dividend Policy EBIT Margin EBITDA Growth Rate Enterprise Value Enterprise Value/EBIT Enterprise Value/EBITDA Enterprise Value/Sales Equity Beta Equity Flows Equity holders Equity Research Equity Return Equity Value Equity Value Multiples Equity Value per Share Equity Value/After-Tax Cash Flow Equity Value/Book Value of Equity Equity Value/Net Income EV/Mineral Production EV/R&D EV/Retail Sales Space Exchange Ratio Exercise Price Exit Multiple Method Exit Value Fairness Opinions Fiscal Year End (FYE) Fixed Ratio Floating Ratio Fully Diluted Shares Outstanding Future Value of Terminal Multiple Future Value of Terminal Value Goodwill Goodwill created Growth in Perpetuity Method Historical Multiples HLOOKUP Function Identifying right set of "Comps" Identifying right set of "Precedents" IF(ISERROR) Function Implied Premium Income Statement Interest Cover JV Negotiations Key Drivers LBO Structure Leveraged Buyout Analysis (LBO) Levered cash flow Long Term Debt Long Term EPS Growth Long Term Sales Growth Longer Term Projected Rate of Growth in EBIT M&A Accretion Dilution Analysis Market Risk Premium Market Value Market Volatility Merger Proforma Balance Sheet Merger Proforma Income Statement Merger Proxy Mergers & Acquisitions Mezzanine Debt Mid-period convention Minority Interest Net Asset Value Net Debt Net Income Net Operating Profit adjusted for Taxes (NOPAT) Net Working Capital Newco Notes Offer Price per Share Offer Value Oldco Operating Cash Flows Operating Profit (EBIT) Opportunity Cost of Cash Optimal Capital Structure Optimal Form of Consideration Options Exercised Options Outstanding Other Liabilities Overview of Valuation Methodologies Past Partial Period Perpetuity Growth Rate Potential Multiple Enhancement Precedent Transactions Analysis Pre-LBO Structure Premium consideration Price Volatility Private Placements Property and Equipment, net Public Equity Offerings PV of Future Cash Flows Registration Statements Relative Ownership Analysis Relative Valuation Restructuring Costs Revenue Synergies Risk Free Rate Scarcity Value SEC Filings Senior Debt Sensitivity Tables Shares Outstanding Short Term Debt SIC codes Sources and Uses Split Adjustment Stakeholders Takeover Speculation Target Target Share Price 1 Day prior to Announcemnt Tax Adjustments Tax Rates Tender Offer Documents Top line growth Total Liabilities and Shareholders' Equity Total Shareholders' Equity Total Sources Total Uses Total Value of Options Total Value of Warrants Transaction Adjustments Transaction cots Transaction Description and Rationale Transaction Fees Transaction Value/LTM EBIT Transaction Value/LTM EBITDA Transaction Value/LTM Net Income Transaction Value/LTM Sales Treasury Stock Method Undiluted Equity Value Unlevered free cash flow Unusual and Non-Recurring Items Valuation Summary Value Creation Analysis Value Creation Potential Value Destruction Potential VLOOKUP Function Weak Case Weighted Average Cost of Capital (WACC)
Overview
For Investment Banking, Corporate Finance, Private Equity, Equity Research, Hedge Funds, Asset Management, Sales & Trading, Corporate Law
The Valuation Training Program will give you the skills and knowledge to build financial models in Excel to value a company. The Training Program takes you step-by-step through the process of building a Comparable Company Analysis, Precedent Transactions Analysis, Discounted Cash Flow (DCF) Analysis, Leveraged Buy-Out Analysis and a M&A Accretion Dilution Analysis. Each Training Program includes completed Excel financial models and supporting documents which are available as downloads or on a CD-ROM. The financial models and supporting documents allow you to build your own financial models just as you would at a Wall Street job. It contains over 540 pages of invaluable training material
Our goal is to teach you valuation as if you were working at a Wall Street firm. We want you to learn everything and gain as much experience as you would gain if you worked on Wall Street. With this type of experience, you will be better prepared to successfully go through any interview process and receive job offers.
Key Topics (View All Topics-see below)
Learn how to value a real public company by building various valuation models from scratch
Learn the financial foundations of valuation and the underpinnings of each model
Step-by-step process to build a Discounted Cash Flow (DCF) Analysis Valuation Model
Step-by-step process to build a Comparable Company Analysis Valuation Model
Step-by-step process to build a Precedent Transactions Model
Step-by-step process to build a Leveraged Buy-out (LBO) Analysis
Step-by-step process to build a M & A Accretion/Dilution Analysis
All Topics:
% of 52 week high 10K 10Q 8K Accounts receivable Accretive Transaction Accrual Basis Acquirer Adjusting for Stock Splits Announcement Date Asset Write Up Assumed Perpetual Rate of Growth Balance Sheet Base Case Best Case Beta Book Value of Convertible Debt Book Value of Debt Book Value of Equity Break up Valuation Breakeven Point Calculating Compound Annual Growth Rate (CAGR) Calculating Last Twelve Months (LTM) Calculating Terminal Value Capital Asset Pricing Model (CAPM) Capital Expenditures (Capex) Capital Expenditures/Depreciation and Amortization Capital Expenditures/Sales Capital Lease Obligations Cash and equivalents Cash Basis Cash Flow Statement Cash Flows Combination Ratio Company Press Release Comparable Company Analysis Comps Consensus Estimates Consideration (%Stock/Cash) Controlling Stake Conversion Price Convertible Debt Convertible Preferred Stock Correlation between Financial Statements Cost of Debt Cost of Equity Cost of Financing Cost Synergies Credit Re-rating Currency and Exchange Rates Current Partial Period Debt and Interest Schedule Debt Capacity Debt Flows Debt holders Debt Service Credit Ratio Defense Depreciation and Amortization Depreciation and Amortization Margin Dilutive Transaction Discounted Cash Flow Analysis Divestitures Dividend Payout Ratio Dividend Policy EBIT Margin EBITDA Growth Rate Enterprise Value Enterprise Value/EBIT Enterprise Value/EBITDA Enterprise Value/Sales Equity Beta Equity Flows Equity holders Equity Research Equity Return Equity Value Equity Value Multiples Equity Value per Share Equity Value/After-Tax Cash Flow Equity Value/Book Value of Equity Equity Value/Net Income EV/Mineral Production EV/R&D EV/Retail Sales Space Exchange Ratio Exercise Price Exit Multiple Method Exit Value Fairness Opinions Fiscal Year End (FYE) Fixed Ratio Floating Ratio Fully Diluted Shares Outstanding Future Value of Terminal Multiple Future Value of Terminal Value Goodwill Goodwill created Growth in Perpetuity Method Historical Multiples HLOOKUP Function Identifying right set of "Comps" Identifying right set of "Precedents" IF(ISERROR) Function Implied Premium Income Statement Interest Cover JV Negotiations Key Drivers LBO Structure Leveraged Buyout Analysis (LBO) Levered cash flow Long Term Debt Long Term EPS Growth Long Term Sales Growth Longer Term Projected Rate of Growth in EBIT M&A Accretion Dilution Analysis Market Risk Premium Market Value Market Volatility Merger Proforma Balance Sheet Merger Proforma Income Statement Merger Proxy Mergers & Acquisitions Mezzanine Debt Mid-period convention Minority Interest Net Asset Value Net Debt Net Income Net Operating Profit adjusted for Taxes (NOPAT) Net Working Capital Newco Notes Offer Price per Share Offer Value Oldco Operating Cash Flows Operating Profit (EBIT) Opportunity Cost of Cash Optimal Capital Structure Optimal Form of Consideration Options Exercised Options Outstanding Other Liabilities Overview of Valuation Methodologies Past Partial Period Perpetuity Growth Rate Potential Multiple Enhancement Precedent Transactions Analysis Pre-LBO Structure Premium consideration Price Volatility Private Placements Property and Equipment, net Public Equity Offerings PV of Future Cash Flows Registration Statements Relative Ownership Analysis Relative Valuation Restructuring Costs Revenue Synergies Risk Free Rate Scarcity Value SEC Filings Senior Debt Sensitivity Tables Shares Outstanding Short Term Debt SIC codes Sources and Uses Split Adjustment Stakeholders Takeover Speculation Target Target Share Price 1 Day prior to Announcemnt Tax Adjustments Tax Rates Tender Offer Documents Top line growth Total Liabilities and Shareholders' Equity Total Shareholders' Equity Total Sources Total Uses Total Value of Options Total Value of Warrants Transaction Adjustments Transaction cots Transaction Description and Rationale Transaction Fees Transaction Value/LTM EBIT Transaction Value/LTM EBITDA Transaction Value/LTM Net Income Transaction Value/LTM Sales Treasury Stock Method Undiluted Equity Value Unlevered free cash flow Unusual and Non-Recurring Items Valuation Summary Value Creation Analysis Value Creation Potential Value Destruction Potential VLOOKUP Function Weak Case Weighted Average Cost of Capital (WACC)