The Complete Investment Banking Interview Course

Real Interview cases with solutions, practice material and focussed learning content.

What you'll learn
Crack investment banking technical rounds
Create DCF Valuation models
Crack excel screening rounds for finance interviews
Learn to tackle HR Questions in finance interviews
Practice real world interview cases
Build P&L statements from a raw data extraction
Become a proficient user able to work with Excel functions, pivot tables, visualizations, and advanced features
Requirements
No background required for this course
Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, or Microsoft Excel 2020
Description
***Updated in August 2022***Are you looking to prepare for investment banking interviews?Are you an MBA preparing for your first job interview?Are you a graduate looking to prepare for internships?Do you have less time to prepare for the interview?If your answer to any of the above questions is "Yes", then this is just the course for you!Your instructor in this course is an Ex fund manager, Equity research analyst and CFA charter holder Extensive experience with fund management in alternative investmentsLead Trainer at – Mentor Me CareersVast 11 Years of Experience in Fund Management, Product Management & Entrepreneurship.Trained 3000 students in premier institutionsRenowned Visiting Faculty in top tier 1 MBA collegesEx-Partner- Ennovate Research Investment and Capital, Hedge FundComprehensive Investment Banking Interview GuideBecome comfortable with excel to solve real-world problemsLearn how to tackle valuation models in interview casesLearn how to create research templatesLearn how to answer ratio analysis questionsLearn how to create financial statements from scratchLearn how to forecast revenuesWe offer:Well-designed focussed content on interview preparationExtensive question bank for practiceRegular course updatesForum doubt-solving answers quicklyReal interview casesAbout the Course:Learn to build financial models with 5 Modules comprising excel, financial statement analysis(income statement, balance sheet, cash flow statements), Quantitative Methods, Equity Valuation, Project finance, and Capital budgeting in Live classes or self-paced based on your preference.An unconditional 30-day money-back guaranteeNo experience requiredUnlimited lifetime accessFree support for doubt solving Learn with investment bankers with 10 years exp.

Overview

Section 1: Excel For Interviews

Lecture 1 What this course covers?

Lecture 2 Excel Logical Operators

Lecture 3 Using the Logical Operators- Part 1

Lecture 4 Using the logical Operators - Part 2

Lecture 5 Pivot Table for Data Analysis

Lecture 6 Vlook Up Introduction

Lecture 7 Vlook Up & Index Match Part 1

Lecture 8 Vlook Up & Index Match Part 2

Lecture 9 How to Create a Financial Analysis Tempalte

Section 2: Excel Interview Cases with Solutions

Lecture 10 Case 1 Overview

Lecture 11 Case 1 Solution

Lecture 12 Case 2 Overview

Lecture 13 Case 2 Solution

Lecture 14 Case 3 Overview

Lecture 15 Case 3 Solution

Section 3: Financial Statement Analysis Crash Course

Lecture 16 Introduction to Financial Statement Analysis

Lecture 17 Finance Statements at A Glance

Lecture 18 Financial Statement Linkages Overview

Lecture 19 Creating Financial Statements Case Part 1

Lecture 20 Creating Financial Statements Part 2

Lecture 21 Creating Financial Statements Case Part 3

Lecture 22 Introduction To Ratio Analysis

Lecture 23 Profit Ratios

Lecture 24 Activity Ratios

Lecture 25 Insights - Profit & Activity Ratios

Lecture 26 Return Ratios

Lecture 27 Solvency Ratios- Part 1

Lecture 28 Solvency Ratios Part 2

Lecture 29 Insights Return & Solvency Ratios

Lecture 30 Liquidity & Valuation Ratios

Lecture 31 Insights Liquidity & Valuation Ratios

Lecture 32 Dupont Analysis

Lecture 33 Insights Dupont Ratio

Lecture 34 FIFO Full form & Its notorious sister LIFO in Business

Lecture 35 DSO(Days of Sales ) in Ratio Analysis- How to use?

Section 4: Financial Statement Analysis Interview Preperation

Lecture 36 Balance Sheet Tallying Error- Find and Fix mistakes

Lecture 37 Balance Sheet Tallying Error- Find and Fix mistakes Solution

Lecture 38 Forecasting Financial Statements using limited data

Lecture 39 Forecasting Financial Statements using limited data Solution

Section 5: Discounted Cash Flow & Relative Valuation Crash Course

Lecture 40 Introduction to valuation concept

Lecture 41 Important Nuances of Valuation

Lecture 42 Deep Dive into Valuation Methods

Lecture 43 Cost of capital

Lecture 44 Other Sources of Capital

Lecture 45 Calculating Beta of a stock Practically

Lecture 46 Capital Asset Pricing Model

Lecture 47 Calculating Levered & Unlevered Beta

Section 6: DCF Valuation Interview Cases with Solutions

Lecture 48 DCF Valuation & Model Errors Case Overview

Lecture 49 DCF Valuation & Model Errors Case Solution

Lecture 50 DCF Valuation with Revenue Projection Case Overview

Lecture 51 DCF Valuation with Revenue Projection Case Solution

Section 7: Interview 101

Lecture 52 How to create the perfect Resume

Lecture 53 Offer Letter Tips- Do's & Don'ts

Lecture 54 Real Estate Valuation Nuances

Lecture 55 Financial Modeling Salaries in India

Section 8: Company Specific Screening Cases

Section 9: Additional DCF Valuation Model Lectures

Lecture 56 IT Sector Overview

Lecture 57 Persistent Company Overview

Lecture 58 Reserarch Template

Lecture 59 Historical Data Entry

Lecture 60 Quarterly Data Entry

Lecture 61 Revenue Forecasting Approaches

Lecture 62 Revenue Driver Segment Forecasting Approach-1

Lecture 63 Revenue Driver Segment Forecasting Approach-2

Lecture 64 Revenue Drivers- Billing Method -Part 1

Lecture 65 Revenue Drivers- Billing Method -Part 2

Lecture 66 Cost Drivers and it's forecasting

Lecture 67 Asset Schedule

Lecture 68 Statements Linking and finalisation

Lecture 69 Discounted Cash Flow

Lecture 70 Relative Valuation

Candidates applying for investment banking, financial planning & analysis , Equity research, Credit research Jobs,MBA Graduates, CFA level 1 students, Chartered accountants, ACCA candidates