Financial & Valuation Modeling
Certification Program
Premium Package
Financial & Valuation Modeling
Certification Program
- 7 Courses
- 45h 60m
- 102,599 Students
Get the exact same program top investment banks and financial institutions use to train their professionals. Learn 3-Statement Modeling, DCF, Trading and Transaction Comps, M&A and LBO.

Learn the Core Financial & Valuation Modeling Skill Set
- For students and professionals pursuing a career in investment banking, private equity, corporate finance or equity research.
- Build financial models in Excel from scratch using real case studies and best practices.
- Learn financial statement modeling, DCF, Comps, M&A and LBO modeling.
- The exact same training program used by leading financial institutions.
What's Included
Financial Statement Modeling
82 Lessons 10h 29m
In this course, you will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements using step-by-step instruction on selecting, locating, and developing appropriate projection drivers. At completion, you will have developed a complete and comprehensive three-statement model us ...
In this course, you will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements using step-by-step instruction on selecting, ...
In this course, you will develop a 3-statement model completely from scratch, inputting historical d ...
DCF Modeling
66 Lessons 6h 16m
Building on the knowledge gained from the financial statement modeling course, you will be introduced to valuation analysis in general, and the DCF model in particular. We will continue to use Apple as the case study, and teach you how to value the company step-by-step. Along the way, you will learn how to estimate the weighted average cost of capi ...
Building on the knowledge gained from the financial statement modeling course, you will be introduced to valuation analysis in general, and the DCF model in particular. We will continue to use Apple a ...
Building on the knowledge gained from the financial statement modeling course, you will be introduce ...
M&A Modeling
38 Lessons 5h 54m
In this course, you will learn how investment banking and corporate finance professionals model mergers and acquisitions. We’ll start with a review of the current M&A landscape, and key M&A concepts like accretion / dilution, pricing structures (exchange ratios/collars/”walk-away” rights), acquisition accounting, and the step-by-step alloca ...
In this course, you will learn how investment banking and corporate finance professionals model mergers and acquisitions. We’ll start with a review of the current M&A landscape, and key M&A co ...
In this course, you will learn how investment banking and corporate finance professionals model merg ...
Trading Comps Modeling
55 Lessons 6h 47m
"Comps" analysis is the quickest, most widely used valuation methodology, and fundamental part of the core valuation skill set of investment bankers and finance professionals. In this course, trainees learn how to select and "scrub" comparables, pick the right multiples and build dynamic comps models in Excel from scratch, using real case studies, ...
"Comps" analysis is the quickest, most widely used valuation methodology, and fundamental part of the core valuation skill set of investment bankers and finance professionals. In this course, trainees ...
"Comps" analysis is the quickest, most widely used valuation methodology, and fundamental part of th ...
Transaction Comps Modeling
52 Lessons 5h 12m
Transaction comps analysis arrives at a company's value not by building a discounted cash flow or looking at the trading values of peers, but by looking at the purchase prices of recently acquired comparable companies. In this step-by-step course, you’ll learn how to select comparable acquisitions and find important disclosures in filings. Next, yo ...
Transaction comps analysis arrives at a company's value not by building a discounted cash flow or looking at the trading values of peers, but by looking at the purchase prices of recently acquired com ...
Transaction comps analysis arrives at a company's value not by building a discounted cash flow or lo ...
LBO Modeling
88 Lessons 9h 46m
Leveraged buyout (LBO) modeling is used widely by investment banks and private equity firms and is often part of a finance interview. In this course, you will learn how to build a real, complex LBO model from scratch. You will start by learning about basic LBO concepts, typical deal structures, and current industry dynamics. You will then begin th ...
Leveraged buyout (LBO) modeling is used widely by investment banks and private equity firms and is often part of a finance interview. In this course, you will learn how to build a real, complex LBO mo ...
Leveraged buyout (LBO) modeling is used widely by investment banks and private equity firms and is o ...
Bonus Building Buyers Lists
21 Lessons 1h 36m
In this deep dive into what it takes to build buyers lists for target companies, you'll get an overview of the M&A deal process, learn to understand different types of buyers and analyze the typical motivations and important elements of both strategic and financial buyers. We'll take you through a step-by-step guide on how to use the PitchBook financial data provider to identif ...
In this deep dive into what it takes to build buyers lists for target companies, you'll get an overview of the M&A deal process, learn to understand different types of buyers ...
In this deep dive into what it takes to build buyers lists for target companies, you' ...
Bonus 39 Mini-Courses
Included in enrollment are 39 mini-courses led by WSP's team of instructor/practitioners. These 1-to 2-hour courses cover a variety of topics from basic (Excel, Accounting, Powerpoint) to more advanced and industry specific.
Included in enrollment are 39 mini-courses led by WSP's team of practitioners.
Adjusted EBITDA
While EBITDA is a popular measure of profitability, companies increasingly use "adjusted EBITDA" to present profit and show higher EBITDA by excluding significant line items, most notably stock based compensation. We begin by explaining why EBITDA has become more popular than straight cash flow or GAAP profits. We'll build upon this to judge the appropriateness of the most common adjustments that companies now make to EBITDA. We'll use real company filings to examine the most common adjustments today's companies make to EBITDA to show: When using EBITDA is preferable to net income or cash flows, and when it isn't; The rationale for adding back stock based compensation, and how this can lead to overvaluation; The appropriate and inappropriate use of other common adjustments to EBITDA.
Buy-side Stock Analysis
How do buy-side investors make investment decisions? How do they know where to begin? How do they pick a company to analyze? Ultimately, how do they analyze that company and arrive at an investment thesis? Here, we take the first step toward understanding and analyzing a stock from the perspective of a buy-side investor.We begin with a look at the due diligence and financial analysis process investors use to examine investment opportunities and progress to examine the variables buyside investors consider in real life when making the final decision on whether to “pull the trigger.”
Common Mistakes in Calculating Diluted Shares Outstanding
Convertible Debt. Convertible Preferred Shares. Warrants. Stock Options. Restricted Stock. In the context of valuation, it's always difficult to accurately quantify all potential claims against the common equity pot. This teach-in will provide a solid foundation for all grey areas in calculating diluted shares outstanding, both from stand-alone and M&A valuation perspectives. We will show you: how to calculate dilution from the exercise of stock options and/or warrants using the Treasury Stock Method; best practices in treating convertible securities and the respective implications on valuation; how to best deal with restricted stock given the context (standalone valuation vs. M&A context).
Debt Capital Markets: How to Survive Day 1
Designed for incoming and prospective DCM/Capital Markets analysts and interns with no prior DCM experience, this course will provide an insider's prospective of what you''ll be doing on the job. We'll focus on industry knowledge not taught in school and demystify industry jargon. We start with the basics: what DCM actually does, what a DCM desk looks like and how to use the turret; We'll show you how to make a great first impression from Day 1 and walk you through the DCM pitchbook and the DCM transaction roles and responsibilities you need to know.
Debt Capital Markets Primer
Corporate finance bankers interact regularly with their product partners in debt capital markets, yet many have a limited understanding of the key drivers behind DCM business. This webinar begins by introducing you to the key DCM business lines, including Loan Syndication, Debt Origination, Liability Management and Risk Management. Next, it examines the ways DCM bankers interact with corporate clients and concludes by explaining how the bank makes money (with just the right amount of bond math).
Deconstructing Intercompany Investments
There are some line items on a company’s financial statements that consistently pose challenges for analysts and associates. Here, we focus on the line items on the income statement, balance sheet and cash flow statement that arise when companies make investments in other companies. Using real-life examples, we answer the following questions: What are “non-controlling interests,” “equity investments” and “available for sale” securities? How do non-controlling (minority) interests and other investments flow through a 3 statement model? How are deferred taxes accounted for in such investments? How should models be adjusted when investments are made at higher than book value?
Deconstructing a Bank's Financial Statements
The unique business model of banks means that the financial statements and core drivers often pose unique challenges in analysis, forecasting and valuation. In this Webinar, we will take the first step toward understanding and analyzing bank financials. It will cover: A bank's major financial statements and how they differ from those of other industries; the key linkages between the financial statements; how a bank's business model and regulatory considerations are reflected in the statements; and how to quickly analyze bank financials.
Deconstructing a Maritime Company's Financial Statements
Maritime companies have a unique business model which leads to financial statements, forecasting and valuation techniques that are a little different from those of a "typical company." In this webinar, we will take you through a quick analysis of maritime financials and answer the following: What a non-maritime company's major financial statements look like and how they differ from those of other industries; What key linkages exist between the financial statements; How a maritime company's business model and regulatory considerations impact financial reporting.
Demystifying the Buy Side: Long/Short Investing
While the terms “hedge fund” and “long/short” are tossed around frequently, there's little clarity on how these strategies work in practice. Led by Mike Kimpel, Wall Street Prep instructor and adjunct Professor at Columbia Business School's popular Value Investing Program, this teach-in will walk you through the most common "value investing" strategies deployed at "long/short" hedge funds. We will examine real-world case studies to answer the following: What does a long/short investing strategy aim to achieve? What are the typical types of fund strategies? What does long investing look like in practice? What does short investing look like in practice?
Demystifying Commercial Real Estate Modeling
Designed for IB, PE and real estate investment professionals, this course will show you how to construct a commercial real estate model in Excel in order to evaluate investment opportunities. We will cover: How to navigate Argus and how to link it into an Excel model; Basic lease structures and how each type differs; How to understand key revenue, operating expense and cash flow drivers of a commercial real estate model; Calculating unlevered and levered returns for a commercial property; Deal financing and source & uses of funds.
Demystifying FX Options
Designed for incoming and prospective financial market professionals and investment bankers, this course will use real examples to demonstrate the various use cases for Foreign Exchange (FX) Options. We'll start with an overview of FX options trading conventions and decode some trader jargon before answering: Who trades FX options and why? How do you price an option? What causes the value of an FX option to go up or down? What are some different FX option strategies and why would one use them? At course conclusion, you'll have a strong grasp of how corporates, banks, and investors use FX options to hedge against, or make money from, moves in the underlying FX market.
Demystifying the Healthcare Sector
Designed for prospective or incoming healthcare IB/PE analysts & associates as well as anybody interested in learning about the healthcare sector, this course will introduce you to industry sub-sectors and explore the key financial and operating metrics, drivers, industry jargon, valuation methodologies, trends and regulatory concerns of each.
Demystifying Hostile Takeovers
This course uses transactions such as Monsanto/Syngenta, Sanofi/Medivation and Anthem/Cigna to explain the most common defense mechanisms, tools and strategies companies use to defend against hostile takeovers. Specifically, we answer the following questions: What are the considerations for a tender offer and how does it differ from a proxy contest? What are preventive defense mechanisms such “poison pills” and “staggered boards” and how do they protect a company? What strategies can companies invoke when facing an activist hedge fund? Are companies under any obligation to accept a hostile bid if it is higher than other bids?
Demystifying the Private Equity Deal Process
Designed for incoming and prospective PE associates as well as investment bankers and lenders working with PE clients, this mini-course is a step-by-step walkthrough of the key phases of the private equity deal process. We bring you through the major PE deal checkpoints (Pre-Deal,First Round Bid/IOI,Diligence Deep Dive/LOI, Post-LOI, Closing) and describe how junior professionals can add value to the deal team.
Demystifying Restructuring Investment Banking for Incoming Analysts and Associates
This course is designed for incoming restructuring bankers and current bankers looking to further their restructuring or distressed debt knowledge. It provides an in-depth overview of restructuring and identify the skills you'll need in the early days of your restructuring IB career. We begin by introducing the restructuring process as well as common pitchbook and financial analyses in restructuring IB. From there, we take more in-depth look at the analyses and modeling-related techniques utilized by analysts and associates early in their restructuring banking careers. This course assumes little to no prior knowledge of restructuring.
Demystifying The Role of an FP&A Professional
Ever wonder how companies actually make the earnings forecasts that they communicate to Wall Street? Enter the FP&A professional — one of the most technically rigorous corporate finance career paths. FP&A professionals work closely with the CFO, Director of Finance and other stakeholders to provide them with the information they need to make strategic and operational decisions. Here, we'll take a look at the role an FP&A professional by discussing: Why FP&A is critical in today's competitive business environment; How FP&A differs from traditional finance and accounting roles; The skills a qualified FP&A professional should possess.
Excel Basics (Mac)
Proficiency in Excel is a fundamental part of the finance job description. And while the Windows version of Excel reigns supreme on the job, in our MBA and undergrad classes we still get the question all the time: “What about Excel on a Mac?” In this course, we introduce Mac users to the basics of Excel. We will cover topics such as: The Mac Excel Layout and Ribbon; Editing and Working with Numbers and Operators; Formatting and Navigation (Worksheets, Workbook, Rows & Columns); Working with Rows & Columns; Time-Saving Tools (Anchoring Cells, Formula Auditing, Interpreting Errors, Find and Replace); Introduction to Functions (SUM, Average, IF and nested IF). The only way to learn Excel is by doing, so you’ll be completing Excel exercises every step of the way.
Excel Basics (Windows)
For finance professionals, proficiency in Excel is a fundamental part of the job description. Whether you currently work in Excel at a beginner or intermediate level, this course will take you to the next level and turn you into an advanced "power" user. We'll start with the basics before we quickly introduce you to lesser known time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use on the job. The only way to learn Excel is by doing, so you'll be completing Excel exercises alongside the instructor at every step of the way.
From Excel User to Excel Master: Demystifying VBA
You know by now that Excel proficiency is a must for any successful finance professional, but it's those who venture into Excel's advanced functionality that will become standout analysts. This webinar will teach you how to: Unlock the Developer Ribbon in order to use VBA; Manipulate cells and sheets, whether they're hidden or not; Record, modify and write macros from scratch; Set up special commands when a button is pressed, a cell is selected, or a cell's value is changed; Run through your code, line by line, to debug.
IB Soft Skills: Tools for Becoming an Amazing Junior Banker
You’re heading to a friend’s wedding and you’re about to board your plane when you get a call from your office saying you’ve been staffed and need to come back ASAP. What do you do? Becoming a successful banker is not just about modeling and technical skills. In this course, we talk about the specific tactics and strategies you can employ on day 1 that have nothing to do with modeling. Specifically, you’ll gain tools to handle common challenges and situations. Conducted by Matan Feldman, Founder and CEO of Wall Street Prep, this course will give you actionable tools for differentiating yourself as a junior bankers from day 1.
Insurance Company Financial Statements
The unique business model of insurance companies is reflected in their financial reporting, and leads to a differentiated approach towards analysis, forecasting and valuation. In this webinar, we will take the first step towards understanding and analyzing such financials to answer the following: What a non-life insurer’s major financial statements look like and how they differ from those of other industries; What key linkages exist between the financial statements; How an insurer’s business model and regulatory considerations impact financial reporting; How a quick analysis of insurance financials is done.
An Introduction to Project Finance
As the demand for energy and infrastructure projects increases, understanding project finance mechanics is becoming an increasingly valuable skill set for investment bankers as well as corporate and project finance professionals. This webinar will introduce you to key project finance topics including: The drivers for project finance/the "who" and "why;" Sources of project finance; How the typical project finance deal structure differs from that in corporate finance.
Oil & Gas Financial Statements
This webinar is designed to help participants understand the structure and layout of the O&G financial reports. We start by looking at different O&G accounting methods and their impact on financial statements. We then touch on the differences between 1P, 2P, and 3P reserves before spending the rest of the time analyzing and interpreting O&G financial statements, footnotes, and disclosures, and on performing O&G ratio analysis.
PowerPoint Shortcuts for Investment Bankers
One of the first things investment banking analysts hear when they get to their desks is the importance of mastering shortcuts in Excel. But there’s another Microsoft program junior bankers spend even more time in that gets a fraction of the attention: PowerPoint. In this course, you’ll gain skills that will reduce the amount of time it takes you to create and update pitchbook slides by 60%. We'll focus on 4 key time-saving techniques: hold shortcuts, hybrid shortcuts; ribbon guide shortcuts and QAT guide shortcuts.
A Practitioner's Guide to Private Company Analysis
Designed for incoming and prospective investment bankers, private equity associates and lenders, this course will show you how professionals analyze private companies in order to evaluate investment opportunities, drive valuation, inform a sell-side and/or buy-side process and generally assess overall financial health. Part one will cover private company analysis in early stages of the investment process, and will answer: Historically and today, how healthy is the company? What does the company's financial future look like? What challenges exist when working with a private company? What's different when analyzing a private vs public company?
Private Equity Real Estate Waterfalls
Part 1 of this 2-part course will show you how professionals structure and calculate waterfalls — the method in which distributions are split between sponsor and investor. It will will cover the basics of private equity real estate waterfalls, including: The rationale behind why waterfalls exist; Whole fund carry vs deal-by-deal carry; Multiple hurdle rates and a Catch-up; Common calculation mistakes to avoid; A dynamic waterfall model illustrating the distribution of cash flows.
Skills for Negotiating Transactions
Junior bankers who aspire for advancement often struggle with the challenge of stepping out of their technically oriented analyst/associate role and into a more customer- and relationship-oriented role of a senior banker. "Moving from Junior to Senior Banker: Skills for Negotiating Transactions" covers: Power and leverage in a negotiation; When should you make the opening bid; How to counter hardball tactics; How to deal with liars or unethical negotiators; How to break the zero sum model and create value for your clients; The importance of framing; How the nature of the relationship drives the negotiating style.
Understanding Asset v Stock Sales
There's probably no area of M&A more challenging than understanding the differences between deals structured as stock sales or asset sales/338 elections. We begin with an explanation of how the decision to structure a deal as either a stock sale or an asset sale/338 election creates significant tax and accounting implications for both buyer and seller. Next we examine the buyer/seller benefits and drawbacks of each deal structure before showing how a negotiation can resolve buyer/seller benefits and drawbacks. We'll conclude with a look at the deal structure's impact on financial models.
Understanding Corporate Financial Restructuring
This course is meant to introduce newbies to a high level overview of financial restructuring and set the stage for further more advanced analysis. The first few lessons demonstrate using simple examples how companies find themselves in distress. The next several lessons illustrate how financial restructuring can be used to cure the distress. The last several lessons dive deeper into priorities, valuation of firms under distress, and considerations for distressed debt investors.
Understanding Divestitures
While mergers and acquisitions capture headlines, global spin-off transactions quietly reached a record high of over $250 billion last year. So why would a company want to spin off or divest a subsidiary? And how exactly is it done? With a specific look at eBay's 2015 spin-off of PayPal, here we will examine the value proposition of spin-offs and other popular divestiture mechanisms to answer the following: When does a divestiture make strategic sense? How exactly does a company carry out the separation? How do divestitures impact financial statements? What are the tax consequences of divestitures?
Understanding E&P Hedging Techniques and How to Model Them
Commodity prices are volatile. For companies in the business of producing or selling commodities, revenue and cash flow forecasts rely heavily on the price at which they can sell their commodities in the future. So heavily, in fact, that firms aggressively use hedging strategies to protect against changes in commodity prices. In this course designed for Oil and Gas investment banking, private equity, and research professionals, we'll demystify how oil and gas producers use hedges and how to adjust financial models to correctly reflect them.
Understanding MLPs
The rapid growth as an asset class of publicly traded partnerships known as Master Limited Partnerships (MLPs) was a financial success story of the last decade. However, given the current commodity price environment, the premise of the MLP model has come under review. This course begins with an overview of the MLP asset class including a look at its many sub-sectors and risks. It progresses with a look at MLP valuation, including modeling the accretion/dilution of an acquisition or project and understanding the tax implications of investing in MLPs.
Understanding Purchase Price Allocation
M&A accounting and purchase price allocation in particular are challenging concepts for practitioners to understand and correctly implement into models. In this webinar, we'll take the first step towards understanding the general PPA process and procedures to answer the following: What is purchase price allocation and how is it performed? What is the PPA impact on financial statements? What are the key differences between PPA requirements for public companies vs. privately-held businesses? How do we handle complexities around various purchase considerations?
Live Event "Meet Your Instructor" Kickoff Class
While the Premium Package is self-paced, enrollment includes optional attendance to a 30-minute Zoom session where trainees will meet the program instructor, who will give a brief program orientation and answer questions in a live Q&A.
While the Premium Package is self-paced, enrollment includes optional attendance to a 30-minute "Meet Your Instructor" Zoom session.
1-Month Access to PitchBook
Use the PitchBook platform to see comprehensive private and public market data in action as you work your way through the Premium Package. Explore PitchBook's robust set of tools for understanding valuations such as M&A comps, venture valuation comps, public comps, and fund data.
Use the PitchBook platform to see comprehensive private and public market data in action as you work your way through the Premium Package.
Wall Street Prep’s Premium Package is used at top financial institutions and business schools.

Course Samples

Financial Statement Modeling: 30,000ft View of Our Model

Financial Statement Modeling: Revenue Build

Financial Statement Modeling: Depreciation Waterfall Introdu...

DCF: Modeling the Mid-Year Convention

M&A: Modeling Pro Forma Adjustments

LBO: Reviewing Our LBO Model

Financial Statement Modeling Template

Accretion Dilution Modeling Template

LBO Modeling Template

Get the Financial & Valuation Modeling Certification
Trainees are eligible to take the WSP Financial & Valuation Modeling Certification Exam for 24 months from the date of enrollment. Those who complete the exam and score above 70% will receive the certification. The exam is a challenging 2-hour online examination covering the most difficult concepts covered in the Premium Package.
Premium Package Highlights
Intuitive, Self-Paced and Comprehensive
Wall Street Prep's Premium Package is intuitive and self-paced. You should expect to spend approximately 70-90 hours to complete it. Using a combination of videos, Excel model templates and financial reports, this course teaches students and professionals how to build, analyze, and interpret financial models in a step-by-step fashion at their own pace. 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 (SEC filings, research reports, etc.) in order to build comprehensive models the way they would on the job.
Real World "On the Job" Investment Banking Training
The Premium Package bridges the gap between academics and the real world to equip students with the practical financial skill set that they will need on the job. Our program will give you the confidence you need to ace your interviews and to get ahead in your IB career.
Support Center
Upon enrollment, students gain free and unlimited access to Wall Street Prep's Online Support Center, where they receive answers to questions, free downloads, and important updates from a support staff comprised entirely of experienced former investment bankers.
Private Online Tutoring (Additional Fee Applies)
Want a little extra attention? Live video-chat tutoring is available with experienced investment bankers for a fee of $800/hour. In addition, your tutoring sessions enable you and your tutor to share models, a virtual blackboard and any other files via an integrated web and phone platform that enhances the learning experience.
Resume Inclusion
In light of the challenges facing prospective job candidates, Wall Street Prep recently launched a free, voluntary opt-in service to all its alumni and new students. Upon enrolling in the Premium Package, you will be given the option to upload your resume and cover letter to WSP.

Prerequisites
The program assumes a basic introductory knowledge of accounting (e.g. interaction of balance sheet, cash flow, and income statement) and proficiency in Excel. Students with no prior background in Accounting should enroll in the Accounting Crash Course. Students with limited experience using Excel should enroll in the Excel Crash Course.
Trainee Spotlight
We use your Premium Package program to train incoming analysts and we couldn’t be happier with the results. The learning experience of having videos synchronized with step-by-step manuals is preferable even to a live class. We looked at a number of options in the space and found WSP to have the most complete offering.
Wall Street Prep picks up where MBA programs leave off. While MBA programs focus on theory and strategy, WSP focuses on tactics and how-to. WSP and an MBA work very well together. I highly recommend to students that they augment their classroom studies with a Wall Street Prep course.
I'm a sophomore finance student at the University of London. I have only good things to say about the course! The pace is perfect and the model templates help a ton in facilitating and accentuating the lessons. Being a college student, I dare even say this course is better than the lecturers at my school.
Learner Feedback

Earn CPE Credits with WSP Online Courses

The Wall Street Prep Quicklesson Series
7 Free Financial Modeling Lessons
Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.

with Code MOJO
Wall Street Prep is the exclusive e-learning partner of Wall Street Mojo! Mojo visitors will get 15% off all Wall Street Prep Courses with code MOJO (apply in cart). Wall Street Prep is the world's #1 financial e-learning course provider. We train the world's leading investment banks, universities and financial institutions.
