Remove
Key Information
Financial Modeling Bootcamp
$895 21 Hours
Learn More
Overview
Learn essential finance & accounting concepts while building a comprehensive discounted cash flow (DCF) model in Excel. This financial modeling class blends finance, accounting and Excel concepts into an intensive 3-day course. 
Prerequisite
Prior financial experience is helpful, but not required. Those without a finance or accounting background will receive a short guide prior to the course (request upon registration) to acclimate themselves to terminology. Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements. Our Financial Analyst Training Program includes beginner and intermediate Excel along with this 3-day bootcamp.
Location
185 Madison Ave, NYC or Live Online
Scheduling Options
Weekdays only
Next Start Date
May 24–26, Monday to Friday, 10–5pm
Certification
Receive a Certificate of Completion
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Discounts See our discounts policies for more details
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
Payment Plan See our payment plan FAQ for more details
Target Audience

Participants with prior knowledge of Excel looking to add fluency in financial and accounting concepts and financial modeling skills, including:

  • Those working in or seeking a position in finance, including investment banking, hedge funds, private equity, real estate, and FP&A
  • College and graduate students looking to supplement academic coursework with practical applications of financial modeling and prepare for technical interviews 
  • Those working in or seeking a position in the finance division of a non-financial company to gain skills in advanced Excel, corporate finance, accounting, and cash flow modeling
What You’ll Learn
  • Financial Concepts, Market Capitalization, & Enterprise Value
  • Financial Accounting including accrual versus cash accounting
  • Discount Cash Flow (DCF) Modeling: Assumptions, Projecting Cash Flows, Sensitivities, Auditing
  • Excel Techniques including Data Validation, CHOOSE, Data Tables, Goal Seek and more
  • Leveraged Buyouts (LBO) Modeling
  • Real Company Analysis
  • Setup the Financial Model and model projections
  • Corporate Valuation and derive a value per share
  • Analyze the Model Output

Add Class or Certificate to Compare