Investment Banking Intern Accelerator
Stand out in a competitive field with our free Investment Banking Intern Accelerator online course. Get the perfect preparation to secure your investment banking internship.
Rapidly develop fundamental skills across financial math, accounting, modeling, valuation and Excel efficiency. Master investment banking interviews with our interactive simulator and mock Superday interviews.
9
Hour to Complete
15
Topic
36
Practical exercise
Investment Banking Intern Accelerator includes
- Intro to Excel and Interface
- The Ribbon
- Shortcut Basics – Accelerator Keys
- Setting Up – Excel Options
- Cell Navigation, Editing, Selecting and Copying
- Font
- Cell Borders and Fill
- Colours
- Alignment
- Numbers – Percent, Currency, Date, Etc
- Styles
- Cell size
- Standard Formatting
- Often Used
- Intro to Formulas
- Avoid Hardcodes in Formulas
- Intro to Functions and Syntax – SUM Function
- COUNT Function
- MIN Function
- MAX Function
- AVERAGE Function
-
IF Function
-
SUMPRODUCT Function
- Intro to Naming Cells
- Creating Names Using the Mouse
- Creating and Editing Names Using Name Manager
- Future values
- Yields
- Annuities
- Perpetuities
- Making entries and ensuring the balance sheet balances
- Preparing a balance sheet
- Preparing an income statement from the entries to retained earnings
- Preparing a cash flow statement from the entries to the cash account
- A review of the different categorizations on the income statement, balance sheet, and the cash flow statement
- Key settings
- Formatting and layout standards
- Building a simple income statement and balance sheet model, on one sheet, then across sheets
- Balancing the balance sheet using the cash flow statement
- Preparing the model for handover
- Key formatting and putting the output into a pitch book
- Calculating equity value
- Calculating enterprise value
- Non-core items, debt equivalent items, and non-controlling interests
- Calculating simple multiples
- Illustrating the impact of leverage
- Understand how growth rates, returns and multiples interrelate
- Introduction
- What does an Investment Banker do
- The role of an Investment Banker
- Preparing for the Recruitment Process
- The Recruitment Process
- Preparing for the interview
- How to make a great first impression
- Interview Questions – Your Story
- Interview Questions – Your Fit
- How to answer ‘Your Fit’ questions
- Interview Questions – Your Knowledge
- Interview Questions – Brainteaser
- Interview Questions – Technical Questions
- Interview Questions – More Technical Questions
- How to follow up after an interview
- Interview structure
- Competency questions
- Technical questions
- Behavioral questions
- Technical questions
- Problem-solving questions
- Behavioral questions
- Technical questions
- Problem-solving questions
- Behavioral questions
- Technical questions
- Problem-solving questions
Investment Banking Intern Accelerator
| skills-certificate
Excel Efficiency Essentials
3
Hours
11
Practical exercises
Start learning Excel like the top investment bankers. Become comfortable with the interface basics before learning the functions that can maximize your efficiency. Work smarter and faster with essential shortcuts. Understand formatting techniques, basic formulas and more.
Menu and Shortcuts and Basics
21 video minutes
0 excel exercises
Video minutes 21
Excel Exercises 0
Basic Formatting
27 video minutes
1 excel exercises
Video minutes 27
Excel Exercises 1
Basic Formulas and Calculations
18 video minutes
3 excel exercises
Video minutes 18
Excel Exercises 3
Basic Functions
28 video minutes
4 excel exercises
Video minutes 28
Excel Exercises 4
Naming Cells and Referencing
9 video minutes
3 excel exercises
Video minutes 9
Excel Exercises 3
Financial Math Fundamentals
3
Practical exercises
Develop a core understanding of how financial math is used in banking. Learn how to calculate the present and future values of financial assets, identify key financial concepts like interest rates, annuities, and perpetuities, and explain their real-world applications.
Financial Math Fundamentals
30 video minutes
3 excel exercises
Video minutes 30
Excel Exercises 3
Financial Accounting Review
1
Hour
3
Practical exercises
Taken from Accounting Essentials, this free taster course reviews the fundamentals of the 3 key financial statements, including their composition and how to interpret them accurately.
Financial Accounting Review
34 video minutes
3 excel exercises
Video minutes 34
Excel Exercises 3
Introduction to Modeling
1.5
Hours
12
Practical exercises
Our free financial modeling course covers key settings, formatting standards, building models on one sheet and across sheets, balancing the balance sheet using the cash flow statement, and preparing the model for handover. By the end, you’ll be able to forecast three statement models given a simple set of assumptions and using keyboard shortcuts.
Introduction to Modeling
45 video minutes
12 excel exercises
Video minutes 45
Excel Exercises 12
Equity to Enterprise Value Bridge
2
Hours
7
Practical exercises
The enterprise value to equity value bridge is an important tool when valuing a company or asset efficiently and accurately. Start mastering it now.
Equity to Enterprise Value Bridge
33 video minutes
7 excel exercises
Video minutes 33
Excel Exercises 7
Investment Banking Interview Skills
1
Hour
Learn what to expect in the interview process, how to tackle tough questions and more. Plus, this course features example videos of successful answers.
Investment Banking Interview Skills
36 video minutes
0 excel exercises
Video minutes 36
Excel Exercises 0
Interview Simulator
20 video minutes
0 excel exercises
Video minutes 20
Excel Exercises 0
Investment Banking Superday Interviews
1
Hour
By the end of this course, you will have a solid foundation to confidently face your investment banking Superday, equipped with the knowledge and skills to impress your interviewers and secure your desired role.
Superday Mock Interview with Billy
17 video minutes
0 excel exercises
Video minutes 17
Excel Exercises 0
Superday Mock Interview with Knoton
16 video minutes
0 excel exercises
Video minutes 16
Excel Exercises 0
Superday Mock Interview with Daniele
17 video minutes
0 excel exercises
Video minutes 17
Excel Exercises 0
Learn from our expert instructors
Learn more about our full faculty
Wall Street Recognized Certification
Established on Wall Street, Financial Edge has taught at the biggest bulge-bracket firms since 2016, and now we offer that very same training online for you. It’s no secret that banking is fiercely competitive, which is why our Wall Street recognized certification is designed to let your employers know you have the skills to succeed.
What Our Students Say
Get Investment Banking Intern Accelerator Skills Certificate
Free Plan
Get access to all our free learning materials, from videos to workouts.
- All free course content including practical exercises and quizzes
Boost Plan
Includes full access to all certified courses.
- 266+ hours of instructor-led learning
- Search across 480+ playlists, 4000+ videos and Q&As
- Role-focused pathways
- Expert instructor support
Pro Plan
Full Felix access including all learning content and data features.
- Everything in the Boost plan
- Streamlined company data
- Current and historic filings for over 7000 companies
- Market and industry data
- Ready-to-use sector and transaction models
Frequently Asked Questions
What tech do I need?
Is it right for me?
Are Financial Edge's courses credible?
Will the Investment Banking Intern Accelerator help me get a job?
How long do I have to complete the Investment Banking Intern Accelerator ?
Are there any hidden costs?
What support will I get along the way?
What is the difference between a Felix subscription and buying a single course?
