Wall Street Prep Courses

Financial and Valuation Modeling

Standard Pricing

$1,599until July 1

CFANY Member Pricing

$1,280until July 1
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.
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.
Laptop, Notepad, and Calculator.
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.
 

CPE logoWall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

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.
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 ModelingDCF ModelingComps ModelingM&A ModelingLBO Modeling. Pricing: $1,599 before July 1. $1,699 after July 1.

Click Boot Camp Date to Register

CFANY Member Pricing: $1,280

6/20 – 6/22

CFANY Member Pricing: $1,360

7/11 – 7/13

7/25 – 727

8/8 – 8/10

8/22 – 8/24

9/26- 9/28

10/17 – 10/19

11/14 – 11/16

12/5 -12/7

Select a date and click to register. CFA Society New York members receive 20% off standard boot camp pricing. Not a member? Apply the discount code “WSP” at checkout for savings.
  • Learn Financial Statement Modeling, DCF, M&A and Excel Modeling Best Practices

  • Bridge the gap between academics and the real world

  • Receive focused, hands-on training by experienced investment bankers

  • Enrollment includes comprehensive training manuals and model templates

Schedule & Registration

Click Boot Camp Date to Register

CFANY Member Pricing: $1,280

6/20 – 6/22

CFANY Member Pricing: $1,360

7/11 – 7/13

7/25 – 727

8/8 – 8/10

8/22 – 8/24

9/26- 9/28

10/17 – 10/19

11/14 – 11/16

12/5 -12/7

2018-06-06T18:29:45+00:00
Few spots remain for Ben Graham V Annual Conference - the value investing event of the year - this Wednesday!
Learn More
close-image

Get Involved - Stay Connected!

Get access to upcoming CFANY events, exclusive content, unique opportunities and more, delivered straight to your inbox!
SUBSCRIBE
close-link
Subscribe