Financial & Valuation Modeling Boot Camp

AUG
26
Wednesday, Thursday, Friday (26-28)
9:00 AM - 5:00 PM
 
Location: Online Workshop
 
Instructor: Silab Mohanty - Senior Instructor 
 
Time: 9:00AM - 5:00PM
 
Dress: Not Applicable
 
 
Add to Calendar 08/26/2020 09:00 AM 08/28/2019 5:00 pM America/Los_Angeles Financial & Valuation Modeling Boot Camp CFA Society Los Angeles is pleased to offer, in partnership with Wall Street Prep, one of Wall Street Prep's most popular courses to equip busy professionals and students with the financial skills they need on the job. Webinar CFALA info@cfala.org false MM/DD/YYYY

CFA Society Los Angeles is pleased to offer, in partnership with Wall Street Prep, one of Wall Street Prep's most popular courses to equip busy professionals and students with the financial skills they need on the job.

Boot Camp Overview

This boot camp is an intensive instructor-led 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.

Financial Statement Modeling

You will develop a 3-statement model completely from scratch, inputting historical data and assumptions to project out financial statements by selecting, locating, and developing appropriate projection drivers.

DCF Modeling

Participants learn how to value the company step-by-step, including how to estimate the weighted average cost of capital (WACC) in the real world, how to implement commonly used approaches to calculating terminal value, and how to use data tables to analyze a broad range of scenarios given different assumptions.

M&A Modeling

Participants will build a merger model in Excel to reflect the pro forma impact of various acquisition scenarios. 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.

Pre-Seminar Excel online training

This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Online continuing education courses

Enrollment includes lifetime access to the following online course(s): Financial Statement Modeling, DCF Modeling, Comps Modeling, M&A Modeling, LBO Modeling.

What’s Included?

Comprehensive training materials (manuals and online exercises), Detailed reusable modifiable Excel model templates, Unlimited e-mail support for content-related questions for 12 months post-seminar.

What You Need

Computer, Notepad, and Calculator.

Prerequisites

This seminar presumes knowledge of financial accounting (at least 1 semester or equivalent). Participants without this background must enroll in and complete the Accounting Crash Course prior to attending the seminar.

Silab Mohanty | Silab Mohanty held several prominent investment banking positions in New York, including as an Associate at JP Morgan, Vice President at Credit Suisse, and Director and Executive Director at UBS. During his investment banking career, he has worked on numerous M&A, financing, capital markets, leveraged buyout, restructuring, and cross-border deals. Silab holds two Masters Degrees in Finance and graduated at the top of his class from both Thunderbird School of Global Management and Xavier Institute of Management (India). Back to Top ^^

Registration Fees (Full Program)
$1,099 (Member) | $1,299 (Non-Member)

Registration Fees (Days 1 & 2)
$999 (Member) | $1,199 (Non-Member)

Email info@cfala.org for additional member discounts.
Cancellations
Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.

 

YouTube Facebook Twitter Instagram LinkedIn