What You'll Learn
Financial Statement Modeling
Financial Statement Modeling is the foundation of all subsequent valuation modeling modules. Trainees learn how to build full, dynamic financial statement projection models in Excel from scratch, using real case studies, industry best practices, and sensitivity analyses. Simple, intuitive, step-by-step instructions reinforce theoretical intuition while teaching the mechanics of the model building process.View AgendaCourse Agenda
- Learn to integrate assumptions and drivers into financial models
- Master Excel techniques and shortcuts for financial modeling
- Learn formatting and structural best practices
Projecting Financial Statements
- Build a fully dynamic and integrated three statement model
- Use equity research, management guidance and industry forecasting conventions to forecast the income statement, balance sheet and cash flow statement
- Normalize historical results to exclude non-recurring items and reconcile GAAP to Non-GAAP presentations of financials
- Build supporting balance sheet schedules using a consistent roll-forward approach: Working Capital, Deferred Taxes, PP&E /
- Depreciation, Intangible Assets, Retained Earnings , and Debt & Interest
- Learn best practices for check models for errors, accuracy and integrity
- Check and fix circular reference and iteration problems (#REF)
- Insert circularity toggles and learn other tools for formula auditing
- Customize Excel for effective modeling using macro shortcuts
- Balancing the model and inserting automated crosschecks
Presentation and Scenarios
- Perform sensitivity analysis using data tables
- Perform scenario analysis using data validation
- Integrating drop down menus and other “bells & whistles”
Build a complete, working discounted cash flow (DCF) model in Excel from scratch, using a real case study, industry best practices, and sensitivity analyses. DCF analysis is both academically respected and widely used on Wall Street as a primary method of valuation. Many finance interview questions specifically test a candidate’s understanding of both the academics and mechanics behind the DCF.View AgendaCourse Agenda
DCF modeling overview
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. You will learn step-by-step DCF modeling, using the free cash flows already projected in the financial statement modeling case study.
Along the way, you will learn how to estimate the weighted average cost of capital (WACC) in the real world, and build several commonly used approaches to calculating terminal value. Finally, we will use data tables to analyze a broad range of scenarios given different assumptions.
Modeling free cash flows (FCF)
- Unlevered vs. levered FCF
- Capitalizing inappropriately classified expenses
- Handling working capital items, deferred taxes and long-term accruals
- Handling stub periods and midyear adjustments
- Integrating synergy assumptions into the DCF model
- Common pitfalls – enterprise vs. equity value, unlevered vs. levered FCF
Discounting the cash flows
- Deriving the cost of debt
- Derive the cost of equity using CAPM
- Estimating the weighted average cost of capital (WACC)
- Delevering and relvering beta
- Determining the optimal WACC
- Avoiding inconsistency between the FCF and discount rate
Estimating terminal value
- Perpetuity approach
- EBITDA multiple approach
- Common pitfalls
From enterprise value to equity value per share
- Calculating net debt and treatment of debt equivalents such as preferred stock, convertible securities , capital leases , and minority interest
- Calculating options and convertible securities using both the standard and treasury stock methods
- Using data tables to analyze a broad range of scenarios given different assumptions
Trading Comps Modeling
“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, industry best practices, and sensitivity analyses.View AgendaCourse Agenda
Trading comparables overview
“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, industry best practices, and sensitivity analyses.
- Learn to select appropriate comparable companies by evaluating operational, financial, size, and other similarities
- Set evaluation benchmarks & select comparable companies
- Gather appropriate financial history and projections
- Normalizing operating results and calculating LTM operating results to reflect nonrecurring charges and stock option expenses
- Standardize various expense classifications including FIFO to LIFO inventory accounting
- Calculate shares outstanding using the treasury stock method
- Input financial data & calculate and interpret financial and market ratios
- Presenting trading comps by structuring output schedule
- Selecting key valuation multiples using the VLOOKUP function and generating multiple tables
Transaction Comps Modeling
Transaction comps (aka deal or transaction comps) is a variant of comparables valuation. Value of the firm is derived by assessing the value of comparable companies recently acquired. In this step-by-step, real case study course, you’ll learn how to select comparable acquisitions, find important disclosures in filings, spread the data and build a complete transaction comps model in Excel.View AgendaCourse Agenda
Transaction comparables overview
Transaction comps (aka deal or transaction comps) is a variant of comparables valuation. Value of the firm is derived by assessing the value of comparable companies recently acquired. In this step-by-step, real case study course, you’ll learn how to select comparable acquisitions, find important disclosures in filings, spread the data and build a complete transaction comps model in Excel.
- You will learn to screen for comparable transactions using SIC and NAICS codes, source SEC filings and press releases
- Learn the pitfalls of relying exclusively on data services like CIQ, Factset, SNL, etc for deal data
- Once a comparable transaction universe is sleected, you will learn to find and gather appropriate financial details
- Scrubbing data is critical for comparability; you will learn best practices for standardizing information and selecting the most relevant multiples and calculating purchase premiums
- Best practices for incorporating synergy assumptions and appropriately calculating unaffected pre-deal share prices
- Build a full dynamic transaction comps output page
Accretion Dilution (M&A) Modeling
How do professionals at investment banks, private equity firms and other financial institutions analyze the impact of mergers & acquisitions? In this course, you’ll learn how to build a real M&A (accretion/dilution) model in Excel from scratch. In addition, you will build a contribution, synergy and exchange ratio analysis, and learn key M&A accounting concepts.View AgendaCourse Agenda
M&A Modeling Overview
Build an Accretion/Dilution (M&A) Model to reflect the pro forma impact of various Merger & Acquisition scenarios. Using a real case study, you will model out the acquisition of one company by another company, correctly incorporating pro forma balance sheet and income statement adjustments.
Key topics covered include a quick test of accretion / dilution in all-stock deals, pricing structures (exchange ratios/collars/”walk-away” rights), purchase accounting, and the step-by-step allocation of purchase price.
- Introduction to the M&A landscape
- Typical buy side and sell side processes and deal timelines
- A review of common deal structures
- Understanding acquisition accounting & purchase price allocation
- Understanding deferred taxes created and lost in M&A
- Dealing with convertible securities and options in M&A
- Performing a back-of-the-envelope accretion-dilution analysis
Accretion/Dilution and M&A modeling
- Building a complete accretion dilution model
- Forecasting pro forma financial statements, and learning to make correct adjusting entries for goodwill and fair market value write ups, advisory fees and financing fees and debt refinancing
- Calculating pre-tax synergies to break-even
- Sensitivity analysis using data tables to determine accretion/dilution to target shareholders in various stock/cash scenarios
- Error-check a merger model
- Sales, EBITDA, and ownership contribution analysis
Advanced topics in M&A
- Understand the asset vs. stock purchase decision
- Address situations in which amortization may be tax-deductible
- A discussion of 338(h)(10) election and wholly owned subsidiary acquisitions
- Legal considerations in M&A
LBO models are used widely by investment banks and private equity firms to assess investor returns as well as to value a business in the event of a buyout. You will build a real leveraged buyout (LBO) model from scratch, using real case studies, industry best practices, and sensitivity analyses.View AgendaCourse Agenda
LBO modeling overview
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 the step-by-step modeling, covering the most common and challenging issues that emerge when modeling buyouts. The course concludes with a sensitivity and scenario analysis, as well as how to build output tables that are key to any professional-grade LBO analysis.
Introduction to LBOs and recaps
- Understanding concepts: Working through an LBO on a cocktail napkin
- What is the current financing and valuation environment?
- What are key industry benchmarks?
- LBO capital structure: TLs, Bonds, Mezz, Preferred, Bridge Loans and Equity
LBO model development
- Setting up the initial valuation and general assumptions
- Calculating diluted shares
- Building the Sources & Uses schedule
- Build a heavy duty, yet flexible, sources & uses of funds schedule
- Make adjustments in one place – watch it flow error-free throughout entire model
- Line-by-line build-up and forecasting of the income statement and working capital schedules
- Modeling LBO debt
- Term loan A/B/C– Modeling mandatory amortization as well as cash sweeps
- Revolver – Automatic cash sweep, minimum cash balance, and maximum borrowing capacity
- Pricing matrix driven off LIBOR spot rates + spread
- Senior and Sub Notes – Modeling PIK vs Cash interest
- Preferred stock – Allowing for equity kickers
- LBO returns and exit analysis for all providers of capital:
- Sponsor equity and management rollover
- Lenders and preferreds
- LBO modeling best practices
- Circularity breaker and error trapping – no more DIV#0 and REF#!
- Building key sensitivities into model outputs
By the end, you will have mastered financial and valuation modeling and developed the core investment banking skill set that will give you a competitive edge in interviews and on the job.
The Premium Package is designed for students and professionals pursuing careers in investment banking, private equity, corporate finance and equity research. You will follow along with the instructor step by step and build real financial models in Excel from scratch using actual case studies, current methodologies and best practices. It will give you an in-depth understanding of financial statement modeling, DCF, Comps, M&A and LBO modeling. This program pulls no punches — it is the exact same comprehensive training program top investment banks and financial institutions use to prepare analysts and associates for the desk. By the end, you will have mastered financial and valuation modeling and developed the core investment banking skill set that will give you a competitive edge in interviews and on the job.
Wall Street Prep’s Premium Package is used at top financial institutions and business schools.
Financial Statement Model: Depreciation Waterfall
DCF: Unlevered Free Cash Flows
M&A: Modeling Pro Forma Adjustments
LBO: Reviewing Our LBO ModelWSP Course Manual
Financial Statement Modeling Course Manual Course NotesWSP Course Manual
Leveraged Buyout Modeling Course Notes
Financial Statement Modeling TemplateXLS
Accretion Dilution Modeling TemplateXLS
LBO Modeling TemplateXLS
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.
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 $199/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.
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.
Macabacus Excel Plugin
Free access to Macabacus, all-in-one suite of time-saving tools designed for people who build financial models in Excel. Use keyboard shortcuts for common number formats, to cycle rapidly through different font and color schemes and to navigate a formula’s inputs across worksheets and workbooks. Easily understand long formulas with the powerful ‘Precedents’ and ‘Dependents’ Tool, and much more. This 6-month free access is for the full version of Macabacus that also includes essential tools for Powerpoint and Word!
Exam and Certification
Premium Package enrollment includes a Financial and Valuation Modeling Certification Exam. You are eligible to take the exam for 24 months from the date of enrollment. Those who complete the exam and score above 70% will receive a Certification in Financial and Valuation Modeling. The exam is challenging and covers the most difficult concepts covered in the program. Learn More: Does Wall Street Prep’s Certification Matter?
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.
Customer ReviewsMay 27, 2018 From:
I just finished my junior year and secured a job in IB for this summer. I was not an absolute novice to the course material, but there are advanced topics in finance that can be a little esoteric and my main goal was to get a grasp on some of the accounting topics and considerations in M&A.
I am a few videos away from finishing the M&A modeling, and I love it. I finally understood why every IB interviewer asked about what happens when depreciation is increased!
Hopefully I will be able to apply much, if not all, that I have learned so far to my internship this summer.May 23, 2018 From:
I am still working with some of the coursework but I’m generally quite impressed with the thoroughness and ease of understanding. In terms of comprehensiveness my research found WSP is the most advanced, and I’ve been very happy with the curriculum.May 23, 2018 From:
I have about 8 years of experience in both financial analysis and risk analysis and my CFO recommended Wall Street Prep when I wanted to refresh/renew some financial teachings since the work world is much different than a classroom.
I am very pleased with the self-taught process and ability to jump between lessons. A great resource!May 16, 2018 From:
I’m about to begin my MBA at MIT Sloan and I’m using the Premium Package to get a hands-on understanding of Financial, DCF, and LBO Modeling before the recruiting season starts.
The deciding factor in buying this course over others is that it is actually used in financial institutions.
I believe (and certainly hope) this course will help me prepare to answer interview questions for IB recruiting, and allow me to be ready to start working since day 1.May 08, 2018 From:
My main goal was to get a better all around understanding of modeling, particularly in LBO modeling before I move into PE. I’m currently a 2nd year analyst at a top bank.
I chose this program it because a number of well-known investment banks used it as part of their analyst training. I have really enjoyed the course so far and look forward to finishing it, as I believe it will help me make the transition to PE.May 05, 2018 From:
to email@example.comMy main goal was to acquire additional modeling skills. I am a Senior Director, Finance so I don’t have too many hands-on opportunities to build models. I’ve sent my team members to attend some of your public courses and they all expressed very high opinions. I really like the completeness of the course materials.Apr 30, 2018 From:
I am a Brazilian senior consultant in management and financial operations and Valuation is part of my work offering. As PE is becoming popular in Brazil, I wanted to get more familiarized with LBO modeling. Your program is quite good and fulfilled my expectations!Apr 23, 2018 From:
My goal is to transition into investment finance and I need to acquire/validate 2 of the foundational skills that would serve in this new career: modeling and valuation.
I am 110% satisfied by the content and by what I’ve seen so far. I like the approach of “just jump in” and develop the financial statement models. I value the self-paced schedule as I need this flexibility within my professional life.The course has also helped me precisely delineate what I want to do in terms of career.
I know now that I want to focus on small to medium companies, in the renewable energy sector and either agro industry or light manufacturing. Thank you for a great service/package!Apr 23, 2018 From:
I spent two years as an associate in the real estate IBD at Goldman Sachs, and I’m now looking at more generalist PE shops. As such, I wanted a refresher on LBO models and valuation for other types of companies.
The WSP package had everything I wanted — LBO, transaction comps, three-statement modeling. While $499 isn’t cheap, I thought it seemed worth it compared to some real estate courses I have seen that run around $800 without the same amount of information.
I found the Premium Package to be very helpful. I really liked (1) that it was broken down into small segments so I could review only the parts that I needed to and (2) that you can run the videos at 1.5x speed, as otherwise it’s too slow and I would have gotten frustrated. It has really boosted my confidence!Apr 22, 2018 From:
I just graduated from Purdue University and I’m trying to get my feet under me as a financial analyst for a couple years before sliding over into a boutique PE firm.
I’m very pleased with the overall course! My friend has a similar program through “breaking into wallstreet,” but I chose the Premium Package because WSP brand carries more weight with PE firms.Apr 18, 2018 From:
I bought the Premium Package to compliment my expertise as an excel consultant for Thomson Reuters – specifically for the purposes of building custom excel solutions.
Your material is well put together and digestible. I really like the 5-15 minute videos — they are long enough to cover advanced modeling concepts but short enough to let me focus on other tasks throughout my work day.Apr 16, 2018 From:
I’m currently an analyst with one year of experience, transitioning jobs in a new city. I bought the Premium Package to hone and refresh my knowledge of the fundamentals of financial modeling to assist me in my interview process as well as future job performance.
I’m very pleased with the amount of detail and practical examples covered in the course. I can more confidently explain in simple terms both the key drivers and takeaways from financial models. I also have become somewhat a subject matter expert among my peers 🙂Apr 11, 2018 From:
This course has helped me to build the confidence that I’m on a level playing field as those from target schools.
I enrolled in the Premium Package because I was taught financial statement analysis by a CFA who did a great job of explaining the concepts, but not so much the models.
If I would have known what I know now from this course about building models, I would have gotten so much more out of that class!Apr 08, 2018 From:
I am an undergrad currently finishing my second year and preparing for difficult IB internship interviews, so I wanted a better understanding of the valuation methods used in the industry.
The program, unlike my school, actually teaches me useful information that I will use in a career path I am interested in pursuing.
The lessons in the Premium Package are very easy to follow, straight to the point, and I would recommend it to others in my shoes trying to get into industry.Apr 08, 2018 From: Lokapati B.
I have just begun using the Premium Package and have completed the Excel basics and begun DCF analysis.
I am an MBA student graduating May 2018 and looking to transition into a finance career from Information Technology.
I’m looking to gain additional knowledge and a certification to aid my job search and enhance my skill sets and I am positive that these courses will be of great help for me.Apr 06, 2018 From:
I am a college sophomore and I enrolled to get better in financial modeling, case competitions and stock pitches.
I’m currently going through the Premium Package and I’m already feeling more confident during cases. The video demos are definitely helpful for anything done on Excel.Apr 06, 2018 From:
My main goal for this course was to refine my modeling skills. I am in my second year doing Business Valuation for a big four firm.
I was pulled away to work on a project that did not entail modeling so I wanted to take this course to “get back in the game.”
I chose WSP base on recommendations from friends and colleagues. Everyone I talked to spoke very highly of this course. It did not disappoint!
This course was all I was looking for, and more. It was very detailed and made me feel like I hadn’t skipped a beat.
It made me feel much more comfortable going back to working with financial models every day.Apr 05, 2018 From:
I’m going to apply for financial analyst roles in the buy side/sell side industry and I wanted to acquire more confidence in those areas of expertise. I also wanted a recognized certificate to be able to signal recruiters my knowledge.
The course is great so far! It gave me a sound and solid framework around the topics I had previously studied and provided valuable insights and depth into specific areas of financial modeling and valuation. Also I find the lifetime access very important.Apr 01, 2018 From:
I have been an analyst on the buy side for 7 years and may be transitioning to a new role where I will need to do more modeling from scratch, so I wanted a refresher on best practices and efficient model building.
Your videos are very easy to follow and the ability to download files to use offline is really helpful.Mar 30, 2018 From:
I enrolled to learn modeling skills taught by people with industry experience rather than the academics at my school (I’m in 4th year). I want to be able to include a model with my application package to make me a more compelling candidate.
The course was really helpful — I liked the download feature so I could watch them on the train into work. Having the models is good so I can modify them for equities I’m interested in.
I can already handle the technical component a bit better in interviews/meeting for coffees.Mar 27, 2018 From:
I was transitioning from consulting to private equity and wanted to brush up on financial modeling before starting. This course is incredibly practical and well-paced!Feb 10, 2018 From:
I am very impressed with the content, the smooth transition from topic to topic and with the overall quality of the course.
I can confidently say that I learned a lot of new topics and tips that accelerated my comprehension of various finance topics. I am confidant that the course will exceed my expectations based on the material that I’ve covered so far.Dec 24, 2017 From:
I was looking to get more familiar with the wide range of modeling tasks I was given in my first-year investment banking job that I started in June 2017 — everything from simple three-statement models to much more complex LBOs, and to prepare myself for the upcoming private equity recruiting season in which building LBOs from scratch is a critical component of the interview.
WSP courses seemed to be the most succinctly organized yet also the most comprehensive. Other courses I looked at were either too lengthy or too circuitous in their topic material.
I haven’t completed the entire course yet (mostly focused on LBO modeling component), but what I’ve covered so far has been both thorough and properly paced. I look forward to engaging with the rest of the modules.
I’ve had several PE interviews thus far and have done well on the modeling tests, and at work itself the modeling tasks have become much less imposing as I’ve firmed up my technical foundations through this program.Oct 17, 2017 From:
I’m at a long-short fund, and training is difficult to come by given resources available in-house, so I joined WSP. Very good program! It made me more comfortable modeling and allowed me to move more into equities.Oct 12, 2017 From:
I’m a senior analyst in a corporate advisory firm in Melbourne. I chose WSP because it appeared to be the most highly regarded among the big financial institutions and came highly recommended by past users.
I like the fact the Corality/Mazars uses WSP for delivery of online content, as our firm engages Corality to for quite a lot of our in-house training, so I am hoping there will be some shared methodologies between the two providers.
I enjoyed the mode of delivery and style of instruction. I like the video tutorials and the website design is intuitive and easy to navigate.Oct 11, 2017 From:
WSP has the best presentation. In fact, several other providers tried to show their value by comparing to this program, which tells me it’s the standard. It was also a good value; lots of material and broad coverage for a modest price.Oct 10, 2017 From:
to firstname.lastname@example.orgMy goal in buying the program was to secure a full-time investment banking position, which I have succeeded in doing. Extremely helpful!Oct 09, 2017 From:
I bought the Premium Package to get a good introduction to M&A and LBO modeling. So far it’s been really great. I have a better understanding of the processes in M&A and the theory in valuation and LBO. The fact that I can go back and re watch the videos if I need a brush up is really great!Oct 07, 2017 From: Greg Lieber
I am a small business owner/entrepreneur who enrolled in the Premium Package while I was looking into an acquisition of a company. I wanted to brush up valuation and have some templates to expedite the modeling process, and your courses definitely helped me in analyzing and modeling my deal.Oct 06, 2017 From:
I am 18 months into my first job as an analyst with a healthcare-focused PE fund. All of the training I have received was from my superiors and is sufficient for what I do, but I wanted to further round out my skills.
These courses have bolstered my skills and will help me better tackle unique issues that we find with the different deals that we look at. I think having done the course will also be helpful in future job interviews so employers can “check the box” that I have more formalized modeling training.Oct 05, 2017 From:
Great program! After I took the courses, my company purchased the Premium Package for four other individuals.Oct 04, 2017 From:
to email@example.comI enrolled in the Premium Package because I was getting curious about later stage investments and M&A and I found out my company had previously purchased training from WSP. That was the differentiating “seal of approval” between you and other providers. I loved the program — is well thought out, thorough, and easy to follow!Oct 02, 2017 From:
The lessons are very clear presented in an appealing way. The price is well worth the density and quality of courses and learning materials. When modeling, the biggest issue I faced is that I tend to be locked into one approach — your courses have solved this be letting me step back and take in a whole new perspective on modeling. And all the Excel tips are also extremely valuable!Sep 21, 2017 From:
I’m a senior in college with little to no financial modeling experience. I chose Wall Street Prep because I did not want to wait for an in-person certification course. I really liked the presentation of the materials and the fact that I could get certified online.
I wanted to get certified in time for the technical questions for interviews at banks, and not all of the other online courses offered that. I like the layout, interface, free webinars, and I think the lectures are very informative. It is exactly what I was hoping for in an online modeling course.Jul 17, 2017 From:
The material is very well organized and certainly keeps my attention and interest. I like that it presented casually as if I was listing to a teacher in a classroom or if I had someone explaining it to me personally. All topics are presented very thoroughly, and I am looking forward to getting to the heart of valuation.Jul 06, 2017 From:
I am really enjoying the course! The coursework provides in-depth explanations of the inputs and outputs and how to utilize the information to make decisions.Jun 23, 2017 From:
I found that WSP was significantly better in terms of recognition by professionals and has a user-friendly interface. The nearest competitors do not even come close regarding the organization of course materials. This program is helpful in developing skills that are really useful within work, investment clubs, competitions, etc. I also find that it provides a solid foundation from which I can mention material in networking and approach professors to research about.Jun 14, 2017 From:
I do not think any course does as good as a job as WSP in regards to getting students quickly up to speed. The videos are shorter in length and get right to the point. Additionally, they manage to somehow cover every topic/issue I can think of in that time frame. I feel that it has made me desk ready for when I start full-time. I feel confident that I have a strong grasp on all concepts and pleased that I have a reference to fall back upon should I need to look something up.Jun 14, 2017 From:
I enjoy how the modules are broken into clips and are fragmented into exercises. It makes it easy to fit into my schedule and easy to refer back to parts that I would like to spend more time emphasizing. The question forum and is very interactive. I do believe that this course will set me up for a smoother transition from student to practitioner.Jun 13, 2017 From:
The materials that are being covered in the premium package together with all the extra added videos exceeded my expectations. I also found that using real company examples proved to be very helpful.May 22, 2017 From:
I’ve taken several other courses and, by far, this is the best course I’ve taken. It’s not even close. The self pace videos give me a chance to practice and review areas that I either didn’t catch, or didn’t understand fully in a live session. I feel that the program definitely gives me the confidence to go into an interview with my head held up high.May 17, 2017 From:
The course made me feel much more comfortable navigating Excel, financial statements and financial models. I appreciated that in going through the models, no stone was left un-turned, ensuring that as I went through the course, every aspect of the model made sense.Feb 16, 2017 From:
My main goal was to learn financial modeling in detail. Unlike some one day courses that don’t allow you to go back and really understand what is going on, the online videos and course materials were excellent for really understanding the details of how a model works. I now feel confident undertaking models for anyone that asks.Dec 21, 2016 From:
I am currently a senior in college pursing a summer analyst or full-time investment banking role. My main goal for buying the Premium Package was to gain technical knowledge so that I can stand out from the top competition. The instructor is very clear and explains the concepts in a way that is easy to follow and understand.Dec 19, 2016 From: Michael Fritschner
I had very little real world experience modeling in Excel, but knowing that I will be using Excel on a daily basis this summer, I wanted to increase my knowledge of the software. This course has set me up for success during my corporate finance internship by deepening my understanding of finance, excel and how investment bankers communicate and think. With this knowledge, I have no doubt I will be able to achieve my professional goals.Nov 30, 2016 From:
I have been working in the finance industry for four years. I want to move into investment banking or a valuation role for investment banking and that was my main goal for taking the premium training program. The material is structured in logical sequence in such a way that one concept leads nicely to the other and keeps things interesting. I love the Excel shortcuts and tricks that are taught along the way as well.Oct 10, 2016 From:
My goal was to become more competitive, specifically to set myself apart from candidates applying to the same roles I was. I am currently in the first year of my MBA, the Premium Package helped me learn accounting and finance quickly and easily.
The course pace is perfect, starting off with “simple” modelling best practices before getting deep into the mud.Oct 06, 2016 From:
I have a lot more confidence now in interviewing for jobs that require financial modelling skills. It will certainly help me move up the ranks together with the existing finance skills I possess.Sep 19, 2016 From:
I first purchased the Premium Package due to the breadth of use of the program across respected firms in the finance industry. Not having an investment banking analyst background, this program was the perfect way to bridge the gap in technical skills I missed out on while working in corporate finance, especially because I knew my IB peers had received their training from Wall Street Prep.
I was able to use the Premium Package as a data point in multiple interviews to show why I was capable of switching from a corporate finance group to a portfolio management group within the same company. The interviewers were impressed with my initiative to grow my technical skill set, particular relating to the LBO knowledge within the Premium Package.Sep 15, 2016 From:
I purchased the Premium Package to gain a deeper knowledge of advanced financial modeling and to learn how to build comprehensive models for valuations. I loved the step-by-step approach and the way the lessons were segmented. I now have a much deeper understanding of finance as a whole.Sep 10, 2016 From:
The Premium Package lessons are clear, well-structured and I love the step by step progression. I found it very easy to understand.
Thanks to this training, I’m able to build my own models and perform better in my job. I also consider these skills necessary to make my way to a global IB or PE group.Aug 30, 2016 From:
WSP stood out to me because of its reputation, professionalism and the material covered. The Premium Package is a great educational tool in all senses. It breaks apart from traditional education by giving hands-on, practical and well-taught material. After working through the program, I feel my knowledge and skill-base has drastically improved.Aug 29, 2016 From:
I purchased the Premium Package to gain greater exposure and understanding of the modeling process. The material is broken down into manageable segments with supporting documents corresponding to each lesson. It was very easy to work through the material at my own pace. The skills I have gained will allow me to take on a broader range of projects as well as further develop my financial skills.Aug 26, 2016 From:
I purchased the Premium Package to help prepare for the technical aspects of upcoming interviews. I really liked the short lectures, breaking it up into 10 to 20 minute blocks helped me to stay focused. I also liked how it constantly tracks how far you’ve gone through the course, that really helped me to feel like I was making progress.Aug 25, 2016 From:
I purchased the Premium Package to get actual experience with modeling. I chose WSP after seeing how many companies have utilized WSP’s courses to help train their employees.
I liked that you can go at your own pace, starting with the basics and working your way up. I can now say that I have modeling skills and can articulate key modeling concepts.Aug 22, 2016 From:
The Premium Package has helped me develop an advanced skill set on excel, sharpen my skills on FSM and expand into other more complicated models.
Having the videos at your own pace is great, it allows you to work at your own rate and fit the work into your schedule.Aug 15, 2016 From:
I valued the flexibility of the online program as well as ability to control the pace. My MBA was very good about teaching the theoretical, but this course has been very helpful in teaching what is practical.Aug 01, 2016 From:
The combination of theory and case studies was very good and helped me understand the content quite fast.
The tutorial videos are very useful during the learning experience. Working through the Premium Package has made be more confident in regards to upcoming interviews.Jul 29, 2016 From:
I was searching for a self-paced course, with unlimited access to materials, with a concise and effective teaching method. I found that the materials were on point with a good mix of teaching and self-practice. Excellent support with any questions I had along the way.Jul 27, 2016 From:
My main goal when buying the program was to develop the knowledge that I had acquired at McGill further, and learn how to perform valuation in a more professional way. I know that what I am learning right now through the Premium Package will be covered in my future interviews, and being comfortable with the various accounting and valuation concepts taught in the premium package is definitely required if you are looking for an internship or full-time position in investment banking.Apr 25, 2016 From:
I am a senior in college preparing to start a full time job in investment banking. I bought the program to learn more about the practical side of finance and improve my modeling skills through an avenue that would give me the opportunity to practice modeling. The Premium Package is clear, orderly and allowed me to work at my own pace.Apr 25, 2016 From:
The premium package is a great real life application compared to the CFA which is more academia based. I really enjoyed the fact that the advanced concepts were broken down into short videos.Apr 20, 2016 From:
The Premium Package is a very professional course, and WSP is a much more recognized brand than anything else out there. The courses start off simple and move on to more intensive topics, and the certification at the end is a nice add on.Apr 18, 2016 From:
I recently completed the 3rd level of the CFA program and was looking for a course that would blend financial theory with real world practice.
With leading banks using WSP as a part of their internal training, I was confident it would be a valuable, highly respected program. I am pleased with the blend of slides and hands-on spreadsheet modeling. The instructor is excellent at keeping the material compelling.Apr 18, 2016 From:
After being in the workforce for 2.5 years, I am working on a career change to Investment banking or Corporate Finance. The video/excel combo that the Premium Package offers is great, it’s the perfect way to structure the courses. I’ve been extremely pleased with the program and find myself more knowledgeable about how to asses economic value/profit and create financial models.Apr 18, 2016 From:
I couldn’t be happier with the Premium Package, I’ve learned so much and the support was fantastic. The structure is logical and extremely well taught. My goal was to learn how to model like the professionals and to help me break into the investment side of the industry from a research background.Apr 11, 2016 From:
I am a corporate finance analyst at a Big Four firm and wanted to be able to face models with complex targets and to know specific topics such as deferred tax assets and liabilities, dilution of shares, LBOs, etc. I chose WSP because of the brand recognition and quality of videos. I found the course to be perfectly structuredApr 07, 2016 From:
I graduated with a degree in engineering but wanted to transition into finance. I found the pre-prepared spreadsheets were great to work with and all the supplementary material in general was very well organized, allowing me to easily follow the lessons and learn financial modeling.Mar 17, 2016 From:
The most effective part of the course in my opinion was how the different modules were structured. I appreciated how each individual video covered by and large only one topic and rarely lasted longer than 15 minutes. This made the topics appear much more digestible. I was ultimately able to get an internship in P.E. These videos helped give me the confidence I needed to get through my interviews.Mar 15, 2016 From:
The material is communicated very concisely, there is no fluff or useless information, and I found that to be very helpful. Additionally, the presentation of the material is done in a very logical, step-by-step structure. I interviewed for an analyst position and the technical skills I learned from the WSP premium package proved invaluable during the interview. My interviewers were impressed, and I largely attribute that to studying the WSP premium package videos.Feb 19, 2016 From:
The Premium Package allowed me to gain a better understanding of Excel modeling, M&A processes, investment banking, and the numerous topics covered in the webinars. It was a great experience because I am more of a hands-on learner as opposed to a classroom settings. I loved having the PDF files along with Excel templates to walk through the program at my own speed. I now consider myself an Excel guru and I absolutely love it!Feb 19, 2016 From:
My main goal when I bought the Premium Package was to get a deeper understanding of the investment banking industry. This program allowed me to apply the finance and accounting basics I learned in college to real world and on the job scenarios. The premium package helped me increase my understanding of how basic finance and accounting principles are used on the job. It also helped increase my knowledge about the interview process, which was important for me in this stage of my career.Feb 17, 2016 From:
The course is giving me a lot of insight into how to look at financial statements from an investment perspective and into the activities IBs do on the job.Since I come from a non-target school without a degree focused on finance, I believe I needed a deeper-than-average knowledge of financial modeling for an entry role.Feb 15, 2016 From:
I liked the ability to be able to download/stream the step by step videos on the road, as I travel around various countries each week. The courses were structured seamlessly. The workflow that dipped into accounting theory and presentations was very well done, as it set the context before jumping into the meat of the model. I would recommend the Premium Package to anyone.Dec 18, 2015 From:
I first went through a few free courses you offer, as well as some free courses offered through other providers. WSP courses are just easier to understand, don’t come across in a monotonous voice, and are completely video based, not just text-based.
The course structure is great, the breakdown of topics and the quick run-through on what’s happening before actually modeling helped solidify the material and drive in the factors happening behind the scenes. Having modeling experience is a definite plus and always looks good on a resume!Dec 14, 2015 From:
I’m currently a junior at Northwestern and my main goal when I bought the Premium Package was to prepare for investment banking interviews and internships and to have an advantage over other interns.
I chose WSP based off recommendations from professionals in the industry and talking to other students who interned at investment banks. I really like the online instruction complemented by the PDF and the exercises —it is like a regular classroom setting and I really like that. So far, I feel much more prepared for interviews and feel capable of working out a couple models on my own.Load More Reviews All Reviews Loaded!X
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.