ONLINE DELIVERY VIA EMAIL - Complete Investment Banking Training (e-Certificate Course) - Investment Banking Overview, Investment Banking core skills, Investment Banking Merger Model

Prdocut Description
First part of the course deals with the Investment Banking Overview. Everyone interested in Finance Industry will find this information very useful. Students preparing for their investment banking interviews will find this module extremely helpful for their preparation. This module is a stepping stone towards investment banking industry.

The next part of the course deals in Investment Banking core skills - Excel, financial Modeling, DCF Valuation and Report Writing where we will be discussing in details the following modules:

1> Microsoft Excel required to handle complex Investment Banking Financial Modeling

2> Financial Analysis for Investment Banking Professionals

3> Financial Modeling with Practical case studies and examples

4> DCF Valuations, Relative Valuations and Investment Banking Comps

5> Report Writing

Then, the next part of the course walks you through the steps in building an Investment Banking merger model, what to consider, assumptions made and challenges in the process. In this session we cover The Basic of Merger Models, Assumptions and Where to Get Info, How to Build a Model, Debt and Tax Effects, Calculating EPS, Accretion vs. Dilution. During this lecture on Investment Banking M&A modeling, participants build a fully integrated merger model which combines financial statement forecasts for the acquirer and the target. Practical consolidation issues are addressed. The deal analysis focuses on the financing structure, pricing, earnings and credit impact and value creation. By the completion of this course, the participants will have knowledge on The advantages of a full-blown merger model, Preparing key deal data, Calculating goodwill, Dealing with refinancing of target's debt, Consolidating the financial statements of acquirer and target, Earnings accretion / dilution and relative P/E analysis, Contribution analysis, Net present value of synergies versus control premium.

After Merger Modeling, we will start Private Equity and Investment Banking. The comprehensively designed module unpacks Private Equity and Management/leveraged buyouts. This module helps the participants understand the work of a Private Equity Firm and set their own work in context.

After Private Equity Modeling, we look at the LBO Modeling as required by Investment Bankers. This training module provides the opportunity for delegates to practice and improve their ability to model LBOs using Excel. On this course delegates imagine working with a business that is contemplating taking on extra debt as part of an LBO.

The LBO Modeling Program bridges the gap between academics and the real world to equip students with the practical financial skill set that they will need in private equity and leveraged finance. Students learn LBO modeling in Excel from scratch using intuitive, step-by-step instruction and model templates the way it is actually performed in private equity. The program utilizes a case study format, as students follow their tutorial guide alongside the Excel model templates, and are directed to the appropriate external documents in order to build complex LBO model the way they would on the job.

This is not just an Investment Banking course, this is an experience, on the job training experience. It has been prepared by highly qualified professionals, Investment Bankers, Equity Analysts from top notch Financial firms and Institutions across the globe. They shared their skills and experience, And we collated them to come up with a program. It is a matter of pride to us to make this job oriented hands on training available to anyone, anytime and anywhere. We are committed to deliver a world class professional Investment Banking training and learning services that continues improving knowledge efficiency. This is NOT typical academic course, this is a high impact job oriented, hands-on practical training programs. The Finance Industry looks for such skill sets in their prospective employees. This Investment Banking program has been designed by the Industry experts keeping in mind the need of the Industry. This program has enviable record of being used as the primary training program for on-board analysts across top investment banks and financial institutions

Course Curriculum

Section1:Investment Banking Overview

• Lecture1:Investment Banking - Introduction
• Lecture2:Investment Banks v/s Retail & Commercial Banks
• Lecture3:Investment Banking & Research
• Lecture4:AMC, Buy side and Sell side of an Investment Bank
• Lecture5:Sales & Trading and Equity Research
• Lecture6:Raising Capital & IPO
• Lecture7:Underwriting and Market Maker
• Lecture8:M&A Advisory and Pitch-Book
• Lecture9:Reorganizations and Restructuring
• Lecture10:Structure of an Investment Bank
• Lecture11:Investment Banking Overview Summary

  Section2:Excel Skills Required for Investment Bankers

• Lecture12:Excel Basics for Financial Modeling
• Lecture13:XYZ Company Basic Excel Case Study
• Lecture14:Excel Case Study
• Lecture15:Data Entry in Excel
• Lecture16:Populating the Case Study in Excel
• Lecture17:Calculations Addition Subtract Multiply Division
• Lecture18:Formulas SUM MAX MIN AVERAGE
• Lecture19:Formatting Number Formats
• Lecture20:Formatting Table Formats
• Lecture21:Updating a Calculation
• Lecture22:Percentages and Absolute References
• Lecture23:IF Function
• Lecture24:COUNT IF Function
• Lecture25:SUM IF Function
• Lecture26:Freeze and Split
• Lecture27:Logical functions AND OR IF
• Lecture28:Arithmetic functions MAX MIN ABS etc
• Lecture29:COUNT COUNTIF COUNTA COUNTBLANK
• Lecture30:Cell Information ISERROR ISBLANK etc
• Lecture31:PROPER UPPER LOWER LEFT RIGHT MID
• Lecture32:FIND CLEAN REPT CONCATENATE
• Lecture33:Array Function Introduction
• Lecture34:Array Function Row and Columns
• Lecture35:Array Function TRANSPOSE
• Lecture36:Array Function FREQUENCY
• Lecture37:Paste Special
• Lecture38:Grouping Tabs
• Lecture39:Hyperlinks
• Lecture40:Data Validation
• Lecture41:Protecting Worksheet And Workbook
• Lecture42:Group Boxes And Options Button
• Lecture43:Check Boxes
• Lecture44:List Boxes And Combo Boxes
• Lecture45:Scroll Bar And Spinners
• Lecture46:Auditing Toolbar
• Lecture47:Watch Window
• Lecture48:Naming A Cell And A Range
• Lecture49:Naming Dynamic Ranges
• Lecture50:One Dimensional Data Tables
• Lecture51:Two Dimensional Data Tables
• Lecture52:Solver
• Lecture53:Goal Seek
• Lecture54:Excel 2010 Sparklines
• Lecture55:Range Charts Type 1 Part A
• Lecture56:Range Charts Type 1 Part B
• Lecture57:Range Charts Area Type 2 Part A
• Lecture58:Range Charts Area Type 2 Part B
• Lecture59:Funding Graph
• Lecture60:Two Axis Graphs

  Section3:Financial Analysis Techniques for Investment Bankers

• Lecture61:Horizontal And Vertical Analysis
• Lecture62:Income Statement - Horizontal And Vertical Analysis - Example
• Lecture63:Balance Sheet - Vertical Analysis - Example
• Lecture64:Introduction To Ratio Analysis
• Lecture65:Activity Ratios
• Lecture66:Activity Ratios - Receivables Turnover
• Lecture67:Activity Ratios - Inventory And Payables Turnover
• Lecture68:Activity Ratios - Cash Conversion Cycle Discussion
• Lecture69:Activity Ratios - Working Capital And Fixed Asset Turnover
• Lecture70:Liquidity Ratios
• Lecture71:Solvency Ratios
• Lecture72:Profitability Ratios
• Lecture73:Comprehensive Example - Activity Ratio - Cash Conversion
• Lecture74:Comprehensive Example - Activity Ratio - Working Capital And Fixed Asset Turnove
• Lecture75:Comprehensive Example - Liquidity Ratios
• Lecture76:Comprehensive Example - Solvency Ratios
• Lecture77:Comprehensive Example - Profitability Ratios
• Lecture78:Roe
• Lecture79:Roe Example
• Lecture80:Dividends Payout Ratio

  Section4:Financial Modeling Training and Techniques for Investment Bankers

• Lecture81:Excel Templates - Download them First
• Lecture82:What Is Financial Modeling
• Lecture83:Snapshot Of Financial Model
• Lecture84:Looking At The Assumptions
• Lecture85:Formatting A Financial Model
• Lecture86:Calculating The Historical Ratios
• Lecture87:Projecting Income Statement - Costs
• Lecture88:Projecting Income Statement - Revenues
• Lecture89:Projecting Working Capital - Calculating The Turnover Ratios
• Lecture90:Forecasting The Working Capital
• Lecture91:Working Capital Flow Diagram
• Lecture92:Depreciation Schedule - Base Equation & Projecting Capital Expenditure
• Lecture93:Projecting Depreciation - Part 1
• Lecture94:Projecting Depreciation - Part 2
• Lecture95:Depreciation Schedule Flow Diagram
• Lecture96:Amortization Schedule - Base Equation & Projecting Intangibles
• Lecture97:Projecting Amortization
• Lecture98:Amortization Schedule Flow Diagram
• Lecture99:Other Long Term Schedule - Projecting Other Long Term Items
• Lecture100:Other Long Term Schedule Flow Diagram
• Lecture101:Shareholders Equity Schedule - Base Equation & Shareholders Equity I
• Lecture102:Base Equation & Shareholders Equity Ii
• Lecture103:Projecting Share-Repurchase/Buy Back And Effect Of Stock Options
• Lecture104:Shareholders Equity Schedule Flow Diagram
• Lecture105:Projecting Outstanding Shares
• Lecture106:Completing The Cash Flow Statements
• Lecture107:Setting Up The Debt Schedule - Projecting Debt - Short Term And Long
• Lecture108:Concept Of Cash Sweep Revolver & Ending
• Lecture109:Debt Schedule Flow Diagram
• Lecture110:Important - Understanding The Circular Reference In Detail

  Section5:Financial Modeling Training - CASE STUDY - Company Asian Paints

• Lecture111:Excel Template - Download them First
• Lecture112:Preparing The Infrastructure Of Asian Paints
• Lecture113:Populating Fy2010 Income Statement
• Lecture114:Populating Eps And Unit Conversions
• Lecture115:Populating Fy2010 Balance Sheet
• Lecture116:Populating Fy2010 Balance Sheet - Contd
• Lecture117:Fy 2010 Bs Change Of Units & Error Rectification
• Lecture118:Populating Fy 2010 Cash Flow
• Lecture119:Populating Fy 2010 Cash Flow - Contd
• Lecture120:Income Statement - Ratio Analysis
• Lecture121:Bs - Calculation Of Solvency Ratios
• Lecture122:Bs - Working Capital - Receivables & Inventory Turnover
• Lecture123:Bs - Working Capital - Payables Turnover
• Lecture124:Bs - Cash Conversion Cycle
• Lecture125:Is / Bs - Calculation Of Operating Efficiencies
• Lecture126:Is / Bs - Dupont Analysis
• Lecture127:Is / Bs - Financial Risk Ratios
• Lecture128:Is Projections - Sales & Material Costs
• Lecture129:Is Projections - Employee Cost
• Lecture130:Is Projections - Pat
• Lecture131:Is Projections - Ebitda & Pbt
• Lecture132:Minority Interest Calculation
• Lecture133:Dividends Forecasts
• Lecture134:Completing The Income Statement Projections
• Lecture135:Bs Projections - Shareholders Equity
• Lecture136:Bs Projections - Minority Interest
• Lecture137:Bs Projections Deferred Tax Liability And Goodwill
• Lecture138:Bs Projections - Working Capital Projections
• Lecture139:Bs Projections - Working Capital Projections - Contd
• Lecture140:Provision For Dividends
• Lecture141:Depreciation Schedule
• Lecture142:Forecasting Debt
• Lecture143:Cash Flow Projections - Operating Activities
• Lecture144:Cash Flow Projections - Financing Activities
• Lecture145:Cash Flow Projections - Financing Activities And Reconciliation

  Section6:VALUATION Training for Investment Bankers

• Lecture146:VALUATION Training for Investment Bankers PDF file
• Lecture147:VALUATION Training for Investment Bankers excel file
• Lecture148:DDM - Dividend Discount Model Ddm Example 1
• Lecture149:DDM - Dividend Discount Model Ddm Example 2
• Lecture150:DDM - Dividend Discount Model Ddm Example 3
• Lecture151:DDM - Dividend Discount Model Ddm Example 4
• Lecture152:DDM - Dividend Discount Model Ddm Example 5
• Lecture153:DCF - Introduction To Dcf
• Lecture154:DCF - FCFF - Forecasting Income Statement Ebitda
• Lecture155:DCF - FCFF - Understanding The Working Capital
• Lecture156:DCF - FCFF - Completing The Working Capital Calculations
• Lecture157:DCF - FCFF - Linking The Free Cash Flow To Firm Fcff
• Lecture158:DCF - FCFF - Discounting The Explicit Period Cash Flows
• Lecture159:DCF - FCFF - Calculation Of Terminal Values
• Lecture160:DCF - FCFF - Dcf Valuation Summary
• Lecture161:DCF - FCFF - Dcf Sensitivity Analysis
• Lecture162:DCF - Options Treasury Stock Method
• Lecture163:DCF - Options Explained Part 2
• Lecture164:DCF - Calculation Of Inthemoney Convertibles
• Lecture165:DCF - Calculation Of Inthemoney Stock Options
• Lecture166:DCF - Calculation Of Debt Equity Ratio
• Lecture167:DCF - Cost Of Debt Calculations
• Lecture168:DCF - Cost Of Equity Calculation
• Lecture169:DCF - Enterprise Value Calculation Completing The Missing Links

  Section7:RELATIVE VALUATION Training for Investment Bankers

• Lecture170:Introduction To Relative Valuation
• Lecture171:Relative Valuations - Enterprise Value And Equity Value
• Lecture172:Relative Valuations - Comparable Comp Sheet
• Lecture173:Understanding Pe Ratio
• Lecture174:Forward And Trailing Pe
• Lecture175:Advantages And Limitations Of Pe
• Lecture176:Understanding P/Bv Ratio
• Lecture177:Why P/Bv Is Used In Banks?
• Lecture178:P/Bv And Roe - Used For Energy Sector
• Lecture179:Understanding Pcf Ratio
• Lecture180:Why P/Cf Used In Oil & Gas‚ Gold & Real Estate?

  Section8:Financial Modeling and Valuation of IDEA Cellular

• Lecture181:Idea Cellular Financial Model
• Lecture182:Industry Overview
• Lecture183:Key Market Players and their profile
• Lecture184:Company profile
• Lecture185:Populating the Historicals
• Lecture186:Horizontal and Vertical Analysis
• Lecture187:Ratio analysis
• Lecture188:Revenue Build up
• Lecture189:Cost Sheet
• Lecture190:Depreciation Schedule- Capital expenditures
• Lecture191:Calculation of Depreciation
• Lecture192:Linkages from Depreciation schedule
• Lecture193:Amortization schedule
• Lecture194:Working capital Management
• Lecture195:Shareholders Equity Schedule
• Lecture196:Debt Schedule
• Lecture197:Linkages from Debt schedule
• Lecture198:Completing the financial statements
• Lecture199:EPS calculations and Formatting
• Lecture200:Summarizing the Model
• Lecture201:Introduction to DCF and FCFF Calculation
• Lecture202:WACC Calculations
• Lecture203:Calculating the target price
• Lecture204:Sensitivity Analysis
• Lecture205:Calculating the PE
• Lecture206:Calculating EV by EBITDA
• Lecture207:Recommendation Report

  Section9:Financial Modeling of Mahindra & Mahindra

• Lecture208:Mahindra & Mahindra
• Lecture209:Industry Overview
• Lecture210:Company overview
• Lecture211:Populating the historical values- Overview
• Lecture212:Populating the historical values-Data from Annual Report
• Lecture213:Horizontal analysis
• Lecture214:Vertical analysis
• Lecture215:Ratio analysis
• Lecture216:Revenue projections
• Lecture217:Cost sheet projections
• Lecture218:Working capital management schedule
• Lecture219:Working Capital projections
• Lecture220:Capex and base equation
• Lecture221:Depreciation schedule- PPE
• Lecture222:Depreciation schedule- Calculating Depreciation
• Lecture223:Depreciation schedule- Summing up
• Lecture224:Amortization schedule
• Lecture225:Linking the income statement
• Lecture226:Linking the balance sheet
• Lecture227:Linking the cash flow statement
• Lecture228:Shareholders equity schedule
• Lecture229:Debt schedule- Cash available for payment
• Lecture230:Debt schedule- Interest earning & income
• Lecture231:Completing the missing links
• Lecture232:Introduction to DCF valuation
• Lecture233:FCFF & cost of equity

  Section10:REPORT WRITING Techniques for Investment Bankers

• Lecture234:REPORT WRITING Techniques for Investment Bankers PDF
• Lecture235:Peer Analysis (Without Solutions)
• Lecture236:Introduction
• Lecture237:What Is Equity Research Report - Types & Clients
• Lecture238:What Is Equity Research Report- Types Example
• Lecture239:Anatomy Of Equity Research Report
• Lecture240:Comparing Equity Research Report
• Lecture241:Do'S & Don'Ts Of Research Report Writing
• Lecture242:Report Writing Case Studies
• Lecture243:Useful Financial Websites
• Lecture244:Indian Media Sector Report- Summary & Investment
• Lecture245:Indian Media Sector Report- Company background
• Lecture246:Indian Media Sector Report- Company Background Pointers
• Lecture247:Peer Analysis- Sun Pharma
• Lecture248:Peer Analysis- Net worth , Promoter's holding
• Lecture249:Peer Analysis- Issued capital, Other holdings
• Lecture250:Peer Analysis- Net block, Capital
• Lecture251:Peer Analysis- Net Working Capital & Sales
• Lecture252:Peer Analysis- Reserves
• Lecture253:Peer Analysis- Share application money
• Lecture254:Exhibit Reliance Petroleum Research Report
• Lecture255:Equity Research Conclusion

  Section11:Mergers & Acquisitions Modeling for Investment Bankers

• Lecture256:Merger Model of Comcast Corp and Time Warner Inc. with solution
• Lecture257:Industry Overview of Broadcasting and Cable TV Industry
• Lecture258:Market Players in Broadcasting and Cable TV Industry
• Lecture259:Profile of Comcast Corp.
• Lecture260:SWOT analysis of Comcast Corp.
• Lecture261:Profile of Time Warner Inc
• Lecture262:SWOT Analysis of Time Warner Inc.
• Lecture263:Modeling of Time Warner Inc. and Comcast Corp.
• Lecture264:Analogy of buying a house
• Lecture265:Tradeoff between the financing means
• Lecture266:Understanding the merger fact sheet
• Lecture267:Capital structure of the merger deal
• Lecture268:Transaction Assumptions
• Lecture269:Populating the forecasted figures of Income statement
• Lecture270:Importance of Proforma Income Statement
• Lecture271:Combining the Income statement
• Lecture272:Calculating the new EPS
• Lecture273:Calculating accretion and dilution
• Lecture274:Revenue Synergies
• Lecture275:Revenue synergies, COGS and Cost synergies
• Lecture276:Synergy assumptions
• Lecture277:Synergy calculations
• Lecture278:Populating the forecasted figures of Balance sheet
• Lecture279:Combining the Balance sheets
• Lecture280:Calculating the total allocable purchase premium
• Lecture281:Tangible asset write up
• Lecture282:Intangible asset write up
• Lecture283:New deferred tax liability and Goodwill creation
• Lecture284:Adjusting the BS
• Lecture285:Adjusting the IS
• Lecture286:Sensitivity Analysis
• Lecture287:Calculating the free cash flows
• Lecture288:Summarizing the model

  Section12:Private Equity Modeling

• Lecture289:Private Equity Modeling PDF File
• Lecture290:Private Equity Modeling Excel File
• Lecture291:What is Private Equity?
• Lecture292:Private Equity Fund
• Lecture293:Fees in Private Equity
• Lecture294:Returns in Private Equity
• Lecture295:Deal Structuring- Pre & Post Money
• Lecture296:Deal Structuring- Preferred shares
• Lecture297:Deal Structuring- Participating Preferred shares
• Lecture298:Deal Structuring- Multiple Liquidation Preference
• Lecture299:Deal Structuring- Other Structures
• Lecture300:Private Equity strategies
• Lecture301:Private Equity investments
• Lecture302:Role of banks in Private Equity
• Lecture303:Value of private equity investments
• Lecture304:Private equity structuring
• Lecture305:Financial Engineering
• Lecture306:Buy shares or assets
• Lecture307:Private Placement Memorandum
• Lecture308:Fund Structure- Flow of Money
• Lecture309:Fund Structure and organization
• Lecture310:PE often use a fund structure
• Lecture311:Investment Process- Approach the Private Equity Firm
• Lecture312:Investment Process- Approach the Private Equity Firm Continue
• Lecture313:Investment Process- Inquiries and Negotiations
• Lecture314:Investment Process- Due Diligence
• Lecture315:Investment Process- Final Negotiation and Completion
• Lecture316:Investment Process- Exit routes
• Lecture317:Fund Managers Perspective- Points to consider
• Lecture318:Fund Managers Perspective- Bid-Ask spread
• Lecture319:Relevance of term sheet
• Lecture320:Process to bridge Bid-ask gap
• Lecture321:Post investment performance
• Lecture322:Introduction to Financial Modelling
• Lecture323:Revenue Build up sheet
• Lecture324:Cost Sheet- Direct Costs
• Lecture325:Cost Sheet- Indirect Costs
• Lecture326:Working capital schedule- Historical ratios
• Lecture327:Working capital schedule- Projecting
• Lecture328:Depreciation schedule- Capital expenditures
• Lecture329:Depreciation schedule- Forecast depreciation
• Lecture330:Depreciation schedule- Linkages
• Lecture331:Amortization schedule
• Lecture332:Completing the Income statement
• Lecture333:Shareholders equity schedule
• Lecture334:Completing the Balance sheet and Cash flow
• Lecture335:Debt schedule- Calculate the cash available for debt
• Lecture336:Debt schedule- Linkages
• Lecture337:Calculation of FCFF and Beta
• Lecture338:Calculation of WACC
• Lecture339:Calculating the Equity Value
• Lecture340:Preparing the Cap table
• Lecture341:IRR analysis
• Lecture342:Comparable company analysis
• Lecture343:Term sheet- Capital structure
• Lecture344:Term sheet- Conditions and Covenants
• Lecture345:Term sheet- Drag and tag along rights
• Lecture346:Term sheet- Other terms and provisions

  Section13:LBO Modeling

• Lecture347:LBO Modeling Excel File
• Lecture348:Industry Overview of Retail Sector
• Lecture349:Company overview of American Eagles Outfitters
• Lecture350:LBO Analysis
• Lecture351:Financing Buying the house
• Lecture352:Transaction Assumptions
• Lecture353:Debt assumptions- Types
• Lecture354:Debt assumptions- Calculations
• Lecture355:Sources & Uses
• Lecture356:Populating the historical values
• Lecture357:Populating Revenue Build-up values
• Lecture358:Finding Revenue per square feet
• Lecture359:Completing the Revenue build up
• Lecture360:Cost sheet calculations
• Lecture361:Working capital management
• Lecture362:Ratios and Assumptions- Current Assets
• Lecture363:Ratios and Assumptions- Current Liabilities
• Lecture364:Capex base equation
• Lecture365:Calculating depreciation- PPE
• Lecture366:Calculating depreciation- Projections
• Lecture367:Amortization schedule
• Lecture368:Linking the Income statement
• Lecture369:Linking the balance sheet
• Lecture370:Linking the cash flow statement
• Lecture371:Shareholders equity schedule
• Lecture372:Cash available for Debt repayment
• Lecture373:Calculations involved in finding the bank debt.
• Lecture374:Debt schedule- High Yield Debt
• Lecture375:Debt schedule- Revolver
• Lecture376:Completing the missing links
• Lecture377:Calculating Investor returns
• Lecture378:Calculating IRR
• Lecture379:Sensitivity analysis- Exit Multiple
• Lecture380:Sensitivity analysis- Debt
• Lecture381:LBO Modeling Conclusion

  Benefits

• eduCBA e-campus
• Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
• Online Video Training Material
Presentation Slides
• ail)

  USP of the product

• * 24 x 7 online access
• * Learn from tutorials curated by expert industry professionals and trainers
• * Certificate of Completion
• * Practical application oriented skills

  How to use? (Steps to use Study Material)

• Step 1 - eduCBA sends the redemption coupon along with the registration link.
• Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email id
• Step 4 - Login using your email id and password and start learning

   

  To get more information, you may want to watch the video below

  ---

  Learn Everything, Anywhere, Anytime
  India's Largest Online Education Marketplace

The images represent actual product though color of the image and product may slightly differ.