Канал: wallst.training

it's holding you back

it's holding you back

I can't take it anymore!

I can't take it anymore!

keeping it real with you

keeping it real with you

when you help them land a job

when you help them land a job

Ditch the mouse in Excel

Ditch the mouse in Excel

WST Macros Add-In for Excel - Key Features

WST Macros Add-In for Excel - Key Features

Excel - Gray Background Tutorial (Windows 8 or 10)

Excel - Gray Background Tutorial (Windows 8 or 10)

Excel - Gray Background Tutorial

Excel - Gray Background Tutorial

WST Excel Add-in Instructions - PC

WST Excel Add-in Instructions - PC

WST Macros: MAC OS Add-In Instructions

WST Macros: MAC OS Add-In Instructions

Financial Accounting Bootcamp

Financial Accounting Bootcamp

WST: 3.7 Finance 101 - IRR Explained

WST: 3.7 Finance 101 - IRR Explained

WST: Overview of Financial Mkts - Sales & Trading Explained

WST: Overview of Financial Mkts - Sales & Trading Explained

WST: Share Repurchase Part 1

WST: Share Repurchase Part 1

WST: Overview of Financial Mkts - Structured Products & ABS

WST: Overview of Financial Mkts - Structured Products & ABS

WST: Overview of Financial Mkts - Investment Bank Hierarchy

WST: Overview of Financial Mkts - Investment Bank Hierarchy

WST: Overview of Financial Mkts - Equity Research

WST: Overview of Financial Mkts - Equity Research

WST: Overview of Financial Mkts - Alternatives & Hedge Funds

WST: Overview of Financial Mkts - Alternatives & Hedge Funds

WST: Overview of Financial Mkts -Alternatives Private Equity

WST: Overview of Financial Mkts -Alternatives Private Equity

WST: Overview of Financial Mkts - Asset Management Explained

WST: Overview of Financial Mkts - Asset Management Explained

WST: Overview of Financial Mkts - Buy-Side vs Sell-Side

WST: Overview of Financial Mkts - Buy-Side vs Sell-Side

WST: 19.12 Advanced Excel - Excel 2003 Create Macro Part 2

WST: 19.12 Advanced Excel - Excel 2003 Create Macro Part 2

WST: Circular Reference Part 1

WST: Circular Reference Part 1

WST: Circular Reference Part 2

WST: Circular Reference Part 2

WST: 19.11 Advanced Excel - Excel 2003 Create Macro Part 1

WST: 19.11 Advanced Excel - Excel 2003 Create Macro Part 1

WST: 19.10 Advanced Excel - Drop Box Alternatives Logic

WST: 19.10 Advanced Excel - Drop Box Alternatives Logic

WST: 17.3 Complex LBO Modeling - Sources & Uses Balancer

WST: 17.3 Complex LBO Modeling - Sources & Uses Balancer

WST: 19.9 Advanced Excel - Separate Names Combine Functions

WST: 19.9 Advanced Excel - Separate Names Combine Functions

WST: 19.2 Advanced Excel - Basic Regression

WST: 19.2 Advanced Excel - Basic Regression

WST: 19.6 Advanced Excel - Power of Arrays

WST: 19.6 Advanced Excel - Power of Arrays

WST: 19.3 Advanced Excel - Data Tables Sensitivity Tables

WST: 19.3 Advanced Excel - Data Tables Sensitivity Tables

WST: 19.5 Advanced Excel - Pivot Table Logic

WST: 19.5 Advanced Excel - Pivot Table Logic

WST: 18.5 Super Advanced M&A - Building Debt Sweep

WST: 18.5 Super Advanced M&A - Building Debt Sweep

WST: 19.4 Advanced Excel - Vlookup Logic

WST: 19.4 Advanced Excel - Vlookup Logic

WST: 19.7 Advanced Excel - Row Shading Conditional Format

WST: 19.7 Advanced Excel - Row Shading Conditional Format

WST: 19.8 Advanced Excel - Tranpose

WST: 19.8 Advanced Excel - Tranpose

WST: 18.2 Super Advanced M&A - Merger Modeling Overview Pt2

WST: 18.2 Super Advanced M&A - Merger Modeling Overview Pt2

WST: 19.1 Advanced Excel - Switches Alternatives

WST: 19.1 Advanced Excel - Switches Alternatives

WST: 18.1 Super Advanced M&A - Merger Modeling Overview Pt1

WST: 18.1 Super Advanced M&A - Merger Modeling Overview Pt1

WST: 18.4 Super Advanced M&A - Sources & Uses Logic

WST: 18.4 Super Advanced M&A - Sources & Uses Logic

WST: 18.3 Super Advanced M&A - Merger Modeling Overview Pt3

WST: 18.3 Super Advanced M&A - Merger Modeling Overview Pt3

WST: 18.6 Super Advanced M&A - Enhancing the Debt Sweep

WST: 18.6 Super Advanced M&A - Enhancing the Debt Sweep

WST: 17.1 Complex LBO Modeling - Refinancing Scenarios Part1

WST: 17.1 Complex LBO Modeling - Refinancing Scenarios Part1

WST: 17.2 Complex LBO Modeling - Refinancing Scenarios Part2

WST: 17.2 Complex LBO Modeling - Refinancing Scenarios Part2

WST: 17.6 Complex LBO Modeling - New Term Loan Construction

WST: 17.6 Complex LBO Modeling - New Term Loan Construction

WST: 16.1 LBO Modeling - IRR Calculation & Analysis

WST: 16.1 LBO Modeling - IRR Calculation & Analysis

WST: 17.7 Complex LBO Modeling - Sensitivity Still Balances

WST: 17.7 Complex LBO Modeling - Sensitivity Still Balances

WST: 17.4 Complex LBO Modeling - BS Pro Forma Debt Adj

WST: 17.4 Complex LBO Modeling - BS Pro Forma Debt Adj

WST: 17.8 Complex LBO Modeling - Credit Ratio Sensitivity

WST: 17.8 Complex LBO Modeling - Credit Ratio Sensitivity

WST: 17.5 Complex LBO Modeling - Cash Flow Adjustments

WST: 17.5 Complex LBO Modeling - Cash Flow Adjustments

WST: 15.6 LBO Modeling - Recap vs Purchase Accting Applied

WST: 15.6 LBO Modeling - Recap vs Purchase Accting Applied

WST: 15.5 LBO Modeling - Recap vs Purchase Accounting

WST: 15.5 LBO Modeling - Recap vs Purchase Accounting

WST: 15.4 LBO Modeling - Sources & Uses and Rollver Equity

WST: 15.4 LBO Modeling - Sources & Uses and Rollver Equity

WST: 15.3 LBO Modeling - Deal Expenses Accounting Treatment

WST: 15.3 LBO Modeling - Deal Expenses Accounting Treatment

WST: 15.1 LBO Modeling - Leveraged Buyout Overview

WST: 15.1 LBO Modeling - Leveraged Buyout Overview

WST: 15.2 LBO Modeling - Ideal LBO Candidate

WST: 15.2 LBO Modeling - Ideal LBO Candidate

WST: 14.1 Merger Modeling Basics - Accretion Dilution

WST: 14.1 Merger Modeling Basics - Accretion Dilution

WST: 9.7 Adv FM Core Model - Integrating & Balancing Model

WST: 9.7 Adv FM Core Model - Integrating & Balancing Model

WST: 13.4 M&A Deal Structuring - Stock vs Cash Breakeven

WST: 13.4 M&A Deal Structuring - Stock vs Cash Breakeven

WST: 10.2 Adv FM Enhancements - Project Depreciation Expense

WST: 10.2 Adv FM Enhancements - Project Depreciation Expense

WST: 14.4 Merger Modeling Basics - Merger Deal Structure

WST: 14.4 Merger Modeling Basics - Merger Deal Structure

WST: 14.2 Merger Modeling Basics - Ability to Pay Merger

WST: 14.2 Merger Modeling Basics - Ability to Pay Merger

WST: 14.3 Merger Modeling Basics - Simple Merger Model

WST: 14.3 Merger Modeling Basics - Simple Merger Model

WST: 13.3 M&A Deal Structuring - 338(h)(10) Elections

WST: 13.3 M&A Deal Structuring - 338(h)(10) Elections

WST: 13.2 M&A Deal Structuring - Stock vs Asset Merger Model

WST: 13.2 M&A Deal Structuring - Stock vs Asset Merger Model

WST: 10.1 Adv FM Enhancements - Segment Buildup Explanation

WST: 10.1 Adv FM Enhancements - Segment Buildup Explanation

WST: 11.1 Complex Trading Comps - LIFO FIFO Adjustment

WST: 11.1 Complex Trading Comps - LIFO FIFO Adjustment

WST: 13.1 M&A Deal Structuring - M&A Process & Timetable

WST: 13.1 M&A Deal Structuring - M&A Process & Timetable

WST: 9.4 Adv FM Core Model - Cash Flow Dividends Projection

WST: 9.4 Adv FM Core Model - Cash Flow Dividends Projection

WST: 10.3 Adv FM Enhancements - Credit Ratio Automation

WST: 10.3 Adv FM Enhancements - Credit Ratio Automation

WST: 9.5 Adv FM Core Model - Cash Flow Share Repurchase

WST: 9.5 Adv FM Core Model - Cash Flow Share Repurchase

WST: 9.6 Adv FM Core Model - Debt Sweep Starting Point

WST: 9.6 Adv FM Core Model - Debt Sweep Starting Point

WST: 9.2 Adv FM Core Model - Balance Sheet Logic & Drivers

WST: 9.2 Adv FM Core Model - Balance Sheet Logic & Drivers

WST: 9.3 Adv FM Core Model - Balance Sheet Projection

WST: 9.3 Adv FM Core Model - Balance Sheet Projection

WST: 9.1 Adv FM Core Model - Income Statement Projection

WST: 9.1 Adv FM Core Model - Income Statement Projection

WST: 7.1 Basic Financial Modeling - EPS Shares Outstanding

WST: 7.1 Basic Financial Modeling - EPS Shares Outstanding

WST: 7.2 Basic Financial Modeling - Valuation Model & DCF

WST: 7.2 Basic Financial Modeling - Valuation Model & DCF

WST: 6.1 Company Overview - Capital Structure Inputs

WST: 6.1 Company Overview - Capital Structure Inputs

WST: 7.3 Basic Financial Modeling - DCF Perpetuity Growth

WST: 7.3 Basic Financial Modeling - DCF Perpetuity Growth

WST: 8.1 Trading Comps - LTM Different Fiscal Year End Part1

WST: 8.1 Trading Comps - LTM Different Fiscal Year End Part1

WST: 8.2 Trading Comps - LTM Different Fiscal Year End Part2

WST: 8.2 Trading Comps - LTM Different Fiscal Year End Part2

WST: 7.4 Basic Financial Modeling - Implied Perpetual Growth

WST: 7.4 Basic Financial Modeling - Implied Perpetual Growth

WST: 4.6 Investment Banking Training - Valuation Football Field

WST: 4.6 Investment Banking Training - Valuation Football Field

WST: 4.3 Investment Banking Training - Valuation Multiples

WST: 4.3 Investment Banking Training - Valuation Multiples

WST: 3.2 Finance 101 - CAPM Simplified

WST: 3.2 Finance 101 - CAPM Simplified

WST: 4.2 Investment Banking Training - Valuation TEV & Exclusion of Leases

WST: 4.2 Investment Banking Training - Valuation TEV & Exclusion of Leases

WST: 4.5 Investment Banking Training - Valuation Proxy for PE Ratios

WST: 4.5 Investment Banking Training - Valuation Proxy for PE Ratios

WST: 4.4 Investment Banking Training - Valuation Up and Down Capital Structure

WST: 4.4 Investment Banking Training - Valuation Up and Down Capital Structure

WST: 4.7 Investment Banking Training - Valuation Control Premiums Paid

WST: 4.7 Investment Banking Training - Valuation Control Premiums Paid

WST: 4.1 Investment Banking Training - Basic Valuation Methodologies

WST: 4.1 Investment Banking Training - Basic Valuation Methodologies

WST: 3.4 Finance 101 - WACC Defined and Calculated

WST: 3.4 Finance 101 - WACC Defined and Calculated

WST: 3.1 Finance 101 - CAGR Explained and Applied

WST: 3.1 Finance 101 - CAGR Explained and Applied

WST: 3.6 Finance 101 - WACC Applied

WST: 3.6 Finance 101 - WACC Applied

WST: 3.5 Finance 101 - Cost of Debt Analyzed

WST: 3.5 Finance 101 - Cost of Debt Analyzed

WST: 2.2 10K Footnotes - FX Impact on Revenue

WST: 2.2 10K Footnotes - FX Impact on Revenue

WST: 3.3 Finance 101 - SML and Identifying Excess Returns

WST: 3.3 Finance 101 - SML and Identifying Excess Returns

WST: 2.1 10K Footnotes - Enron Aftermath VIE FIN 46

WST: 2.1 10K Footnotes - Enron Aftermath VIE FIN 46

WST: 1.6 Accounting - Ratios - ROE

WST: 1.6 Accounting - Ratios - ROE

WST: 1.7 Accounting - Ratios - Days Outstanding

WST: 1.7 Accounting - Ratios - Days Outstanding

WST: 1.3 Accounting - EBIT & EBITDA Explanation

WST: 1.3 Accounting - EBIT & EBITDA Explanation

WST: 1.2 Accounting - Accrual Concept & Matching Principle

WST: 1.2 Accounting - Accrual Concept & Matching Principle

WST: 1.4 Accounting - Financial Statements Integration

WST: 1.4 Accounting - Financial Statements Integration

WST: 1.5 Accounting - Non-Recurring Items

WST: 1.5 Accounting - Non-Recurring Items

WST: Share Repurchase Part 2

WST: Share Repurchase Part 2

WST: 1.1 Accounting - Financial Statements Overview

WST: 1.1 Accounting - Financial Statements Overview

Wall St. Training: Excel Iterations

Wall St. Training: Excel Iterations

Wall St. Training: 19.0 Advanced Excel for Data Analysis

Wall St. Training: 19.0 Advanced Excel for Data Analysis

Wall St. Training Self Study - Instructor Hamilton Lin

Wall St. Training Self Study - Instructor Hamilton Lin

Introduction to Wall St. Training Self-Study Platform

Introduction to Wall St. Training Self-Study Platform

Wall St. Training Self-Study Platform: Rules & Nuances

Wall St. Training Self-Study Platform: Rules & Nuances

WST Self-Study Platform: Side by Side Excel & Video Learning

WST Self-Study Platform: Side by Side Excel & Video Learning

WST Self-Study Platform: Exercise & Explanations

WST Self-Study Platform: Exercise & Explanations

WST Self-Study Platform: Interactive Drawing & Instructions

WST Self-Study Platform: Interactive Drawing & Instructions

Wall St. Training: Treasury Dilutive Options Part 2

Wall St. Training: Treasury Dilutive Options Part 2

Wall St. Training: Depreciation and Working Capital

Wall St. Training: Depreciation and Working Capital

Wall St. Training: Treasury Dilutive Options Part 1

Wall St. Training: Treasury Dilutive Options Part 1

WST: 18.7 Super-Advanced M&A - Purchase Price Allocation

WST: 18.7 Super-Advanced M&A - Purchase Price Allocation

9.8 Adv FM Core Model - Finalizing & Balancing the Model

9.8 Adv FM Core Model - Finalizing & Balancing the Model

WST: Corporate Valuation - TEV & Minority Interest

WST: Corporate Valuation - TEV & Minority Interest

Overview of Financial Markets - Investment Banking Explained

Overview of Financial Markets - Investment Banking Explained