Description
Course Introduction: Equity Capital Markets Mastery: IPO Modeling and Analysis
Welcome to "Mastering Equity Capital Markets and IPO Modeling," a comprehensive course designed to provide you with in-depth knowledge and practical skills in navigating the intricate world of equity markets and Initial Public Offerings (IPOs). Whether you're a finance enthusiast, a budding analyst, or a professional looking to enhance your financial modeling skills, this course offers a tailored journey into the dynamics of raising capital and taking companies public.
What you'll learn
- Equity Capital Markets Fundamentals: Introduction to Equity Capital Markets, Understanding IPOs, Venture Capital and Financing New Ideas
- Advantages and Disadvantages of IPO: Advantages and disadvantages of going public, IPO process and book-building
- IPO Process: Registration and offer pricing, Planning and underwriting agreements, IPO models and metrics
- Rights Issue: Understanding rights issue, Working with right issue cases
Course Curriculum
Introduction
Available in
days
days
after you enroll
Venture Capital
Available in
days
days
after you enroll
Advantages of IPO and Disadvantage of IPO
Available in
days
days
after you enroll
Process of IPO
Available in
days
days
after you enroll
Registration
Available in
days
days
after you enroll
- Understanding Registration (5:39)
- Concept of Marketing (7:41)
- Offer Pricing (11:12)
- Planning an IPO (5:06)
- More On Pricing (8:33)
- IPO Underpriced (4:58)
- After Marketing (7:09)
- Other Divestiture Methods (8:07)
- Methods of Going Public (9:21)
- Underwriting Agreement (3:31)
- Best Effort Agreement (7:22)
- IPO in the UK (6:09)
- Dutch Auction (9:25)
- IPO Underpricing (4:27)
- Implied Bidding Patterns (9:41)
- QIP and FPO (5:37)
- FPO Secondary Offering (8:38)
Issue
Available in
days
days
after you enroll
IPO Model
Available in
days
days
after you enroll
PE Multiple Method
Available in
days
days
after you enroll
- Forward PE Multiple (9:02)
- IPO Transaction Assumption (4:23)
- Building Up Data (11:02)
- Implied Offering Price (8:02)
- Capital and its Trading (8:35)
- Primary and Secondary Issued (11:15)
- Overallottment (7:31)
- Net IPO to Issuer (4:51)
- Net Proceeds (9:24)
- Equity Value Pricing (6:58)
- IPO Offering Price (8:13)
- Primary Shares Issued (4:30)
- Post Money Equity Value (7:17)
- Total Offering Size (6:02)
- Calculating Valuation Multiple (7:00)
- Non Controlling Interest (6:10)
- Calculating EV by EBITDA (6:52)
- Evaluating IPO Case Study (6:34)
CCD Case Study
Available in
days
days
after you enroll
- Assumptions Based on Growth (7:01)
- Dividing Revenue (6:46)
- Group Companies (6:06)
- Methodology Terms (6:29)
- DCF Valuation (5:44)
- Calculating Market Share (8:33)
- Revenue Per Outlet (6:14)
- General and Administrative Expenses (9:43)
- Market Share of Brands (6:43)
- Geographical Spread of Brands (7:05)
- Notes on Assumptions (10:13)
- Pareto Analysis (5:57)
- Calculating Raw Material Cost (6:07)
- Percentage of Fee Revenue (8:27)
- Use of IPO Funds (5:42)
- Current Liabilities (10:03)
- Summary on Income Forcasting (6:54)
- Other Operating Income (5:58)
- Expense and Material Cost (6:19)
- Selling and Administrative Expenses (6:51)
- Evaluating on Working Capital (6:20)
- P and L and Balance Sheet (7:08)
- Application of Funds (12:09)
- Sources of Funds (6:04)
- Existing Loans and Repayments (8:35)
- Loan Schedule (9:42)
- Calculating Depriciation (10:17)
- Acculated Depriciation (7:44)
- Total and Gross Block (7:07)
- BS and P and L Data (8:44)
- Equity and Liabilities (6:28)
- Goodwill on Consolidation (9:44)
- PBT for MAT (7:53)
- Effective Tax Rates (8:13)
- Utilization Tax Credit (5:09)
- Actual Tax Paid (11:36)
- Deferred Tax Asset (9:43)
- Deferred Tax Asset Liability (10:14)
- Cash Flow Statement (3:33)
- Cash Flow from Financing (9:00)
- Cash Flow from Operations (9:08)
- Cash and Cash Equivalent (9:54)
- Formula and DCF Technique (3:52)
- Evaluating Depriciation (10:49)
- Discounting Factor (10:23)
- Formula Definitions (9:07)
- Repayment of Terms Loans (7:52)
- Calculating EBIT (7:52)
- Calculating Outside Liabilities (6:18)
- Current Ratio Excluding Cash (6:54)
- EV-EBITDA Valuation (5:07)
- Long Term Debt (7:16)
- Calulating Average WACC (5:18)
- Calulating Average EBTDA (8:11)
- PE Multiple Method (5:26)
Conclusion
Available in
days
days
after you enroll
Who this course is for:
- Finance Professionals: Analysts, managers, and executives in finance roles.
- Investment Banking Aspirants: Individuals aiming for careers in investment banking.
- Entrepreneurs and Venture Capitalists: Business owners seeking insights into fundraising and IPOs. Venture capitalists interested in valuation techniques.
-
Students and Graduates: Finance students and recent graduates.