21.11.2022, 16:18
![[Bild: yveo78ofq7kau9ecmb7fnxbcva.jpg]](https://abload.de/img/yveo78ofq7kau9ecmb7fnxbcva.jpg)
The Complete Investment Banking Interview Course
Published 9/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 10.09 GB | Duration: 14h 3m
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
![[Bild: thecompleteinvestment0uikl.jpg]](https://abload.de/img/thecompleteinvestment0uikl.jpg)
Download from RapidGator
Download from DDownload
