This boot camp is an intensive training program where trainees learn financial and valuation modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.
This boot camp is a 4-hour instructor-led virtual “Power Session” where trainees learn advanced Excel functionality using an intuitive, step-by-step approach. This seminar is designed for Excel users who would like to power-charge their productivity in Excel by learning lesser-known but highly-effective functionality.
FP&A professionals require a cross-functional understanding of accounting, finance, corporate strategy, and industry dynamics. This virtual workshop fills the common knowledge gaps we see in corporate finance professionals, including modeling, data visualization, storytelling, and variance analysis in the FP&A context, along with Capex, budgeting, forecasting, and setting up a framework for effective KPI reporting. CFA Society Boston members use promo code cfaboston to receive 20% off this course.
This boot camp is an intensive instructor-led training program where trainees learn 13-Week Cash Flow Modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation.
Designed for investment banking, PE and real estate investment professionals, you will learn how professionals underwrite and analyze multi-family properties in order to evaluate investment opportunities and drive valuation. This course does not assume a prior background in Real Estate. However, this course is taught at a fast pace and those who enroll should have an introductory knowledge of accounting and proficiency in Excel.
This instructor-led virtual “Power Session” is an intensive virtual training program where we will discuss how to trade the way its done on the job before putting those skills to the test in a trading simulation.
The unique regulatory framework and business model of financial institutions pose specific challenges in the areas of analysis, forecasting and valuation. In this 2-day course, participants will focus exclusively on banks. On Day 1, you will understand the operating model of banks and regulatory and capital implication, and learn how to analyze the financial statements of a bank and begin building a complete bank forecast model. On Day 2, you will complete the forecast model, then create a Dividend Discount Model (DDM) for bank valuation. The course will conclude with a discussion of specific considerations around bank M&A. This intensive course is designed to equip professionals engaged in the analysis and valuation of banks, with the hands-on skill set needed on the job and is taught by an experienced FIG investment banker.
Investment bankers and consultants use PowerPoint differently than most. A single IB or consulting slide may contain more analysis and strategy than an entire sales presentation, and the fast pace under deadline means slides must be setup with an easy-to-work-with flexibility. Our PowerPoint Speed Training Boot Camp teaches finance professionals, consultants and ANYONE who uses PowerPoint the strategies and techniques they need to build better decks with lightning-fast efficiency.
Led by former private equity professionals, this course takes a deep dive into the Private Equity deal process and the day-to-day responsibilities of a PE professional. Designed for incoming and prospective PE associates as well as investment bankers and lenders working with PE clients, this boot camp is an insider’s walkthrough of the key phases of the PE 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.
Led by experienced sell-side professionals, this boot camp is an introduction on how equity research professionals use financial models to provide research & insights in order to drive investment decisions. Specifically, trainees will learn how ER professionals use earnings releases and quarterly model updates, how they formulate investment theses, adjustments made to normalize financial metrics to arrive at adjusted EBITDA, and modeling best practices.
This boot camp is an intensive instructor-led training program where trainees learn about legal and tax structures in M&A with a specific focus on the differences and contrasting motivations between asset sales and stock sales. We begin with a quick review of purchase price allocation before walking through the different transaction structures and the significant tax and accounting implications of each. We will examine the benefits and considerations of each deal structure to the buyer and seller and analyze how a negotiation can optimize their outcomes. We conclude with a look at the deal structure’s impact on financial models.
Used widely at investment banks and universities, this seminar walks trainees step-by-step through the DCF valuation methodology, a core investment banking skill required by any Wall Street analyst. At the end of this advanced training session, attendees will understand how to forecast unlevered cash flow items, calculate terminal value and construct scenario analysis. This session is ideal for both MBAs and liberal arts students with little to no finance background.
This boot camp is an intensive instructor-led training program where trainees learn the secrets of Automation and Efficiency in Excel VBA using an intuitive, step-by-step approach. Participants will write subroutines and user-defined functions in VBA in a fun and energetic setting. We will build templates that can quickly turn large obscure data files into clean, elegant reports. We will learn iteration methods to dramatically increase productivity. Participants will also create user interfaces and build data entry forms to interact with Excel users. No prior programming knowledge is needed.
This boot camp is an intensive training program where we introduce trainees to financial restructuring, including major terms, concepts, common restructuring techniques and how restructuring professionals build three-statement bankruptcy models.
The unique regulatory framework, accounting and business model of insurance companies create challenges in the areas of financial statement analysis, forecasting and valuation. This intensive 2-day course is designed to equip professionals engaged in the analysis of insurance firms with the practical financial skill set they need on the job. We will analyze the financial statements of both P&C and life insurers and then build a forecast and valuation model for a real-life P&C insurance company.
This boot camp is an intensive instructor-led training program where trainees learn midstream oil and gas industry financial and valuation modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.
CFA Society Boston members use promo code cfaboston to receive 20% off any of the following self-study courses.
Interested in learning more?...Contact us now.