BIWS Advanced modeling course

Складчина: BIWS Advanced modeling course

Данный курс предназначен для желающих пройти этапы отбора в следующие компании:
-Большая четвёрка (или просто Big 4) четыре крупнейшие в мире компании, предоставляющие аудиторские и консалтинговые услуги. Представлены во многих крупных городах России

• Deloitte
• PricewaterhouseCoopers
• Ernst & Young
• KPMG

-Большая тройка (или Big 3) крупнейшие консалтинговые компании

• Boston Consulting Group
• McKinsey
• Bain

-Инвестиционные банки

• Citigroup
• JP Morgan
• Morgan Stanley
• Goldman Sachs
• ВТБ Капитал
• Sberbank CIB

Работа в такой организации для выпускника российского ВУЗа, будь то ТОП московский (ВШЭ, РЭШ, МФТИ, МГУ) или средний региональный, лучшая возможность реализовать свой потенциал как профессионала , получать хорошее вознаграждение за свою работу (часто в долларах и евро) и так называемые lucrative opportunities на выходе, что означает что такому специалисту, решившему оставить свою компанию, работодатели из индустрии предложат куда более серьезное вознаграждение и позицию (работа в иностранной компании - отличный способ набить себе цену в короткий срок на рынке труда)

"It allows you to master advanced financial modeling skills, without rocket-science math and without hundreds of hours of boring academic study, by completing:

• A detailed operating model with revenue and expense projections by business segment
• A full valuation using 9 different methodologies
• An advanced merger model that combines all 3 statements
• An advanced LBO model with support for 7 tranches of debt

here's what's in it for you:

• Dominate Your Interviews. You'll learn concepts here that go beyond what you do on the job every day - master those, and normal interview questions will be a joke. Whether you're preparing for interviews in investment banking, private equity, hedge funds, or anything else, you're covered.

• Prepare for IB and PE Case Studies. Everything is based on case studies of real deals - primarily Microsoft's proposed $44B acquisition of Yahoo! - and we include several additional case studies on the $3B TPG / J Crew deal, the $5B ConAgra / Ralcorp bid, and Intel's $8B acquisition of McAfee. You'll know exactly what interviewers are looking for in case studies, and how to set up your models and answer questions successfully.

• Learn by Watching with Video-Based Training. There's no substitute for watching a pro go through everything in Excel, so that's exactly what you get here. But sometimes you also want it in writing, so you'll also get quick reference guide PDFs for topics like Stock vs. Asset vs. 338(h)(10) deals and key formulas in transactional models.

• Test Your Knowledge with Practice Exercises. You'll get "Before" and "After" Excel files for each lesson - follow along with the lesson, and then check your answers afterward.

• Track Your Progress and Take Notes. You can check off each lesson as you move through the material, and take notes on everything - you can come back whenever you want, to refresh yourself on whatever you want.

Here's what's included in the Advanced Financial Modeling course:

• 100 training videos total (36 hours of footage).
• Lessons cover advanced operating models, valuations based on SEC filings and equity research, complex merger models, advanced LBO models, and pitch books and deal commentary.
• Operating Model lessons teach you how to create a detailed 3-statement model, including revenue and expenses by segment, Noncontrolling Interests and Equity Investments, PP&E schedules, deferred taxes, and quarterly projections.
• Valuation lessons cover how to spread comps, adjust for non-recurring charges, calendarize financials, how to value NOLs and equity investments, and how to complete a DCF analysis with mid-year discounts and stub periods; you'll also learn future share price analysis, sum-of-the-parts valuation, and liquidation valuation.
• Advanced Merger Model coverage teaches you how to combine all 3 statements, create multiple scenarios, build an advanced purchase price allocation schedule that supports stock vs. asset vs. 338(h)(10) deals, calculate revenue and expense synergies by business segment, and factor in book vs. cash taxes and Section 382 NOLs.
• Advanced LBO Model lessons show you how to modify an operating model to make it into an LBO model, and how to build in support for 7 debt tranches, multiple capital structure scenarios, and an advanced debt schedule with customizable repayment terms.
• You'll also get a sample pitch book and PowerPoint tips as well as commentary on the deal itself.

Цена 347 долларов
Курс - одновременно самодостаточен и является логичным продолжением BIWS Fundamentals