Key Information
Financial Modeling Bootcamp
Intro to Financial Accounting
Advanced Excel & Financial Modeling Intensive
$895 21 Hours
$325 6 Hours
$1495 24 Hours
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. 
Learn how to analyze financial statements and reports. Master financial accounting fundamentals such as accrual accounting, the three main financial statements, and the metrics and ratios analysts use.
In this one-week program, you'll learn core and advanced Excel, financial accounting, corporate finance, and financial modeling. 
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.
Open to Beginners
Prior knowledge of beginner Excel concepts, including basic formulas, functions, formatting, and charts is required. Tuition to this course includes free entry into our Excel Fundamentals course. See course dates and email us after you register for the program to enroll in Excel Fundamentals for free.
Location
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Scheduling Options
View schedule at training-nyc.com
View schedule at training-nyc.com
Not currently scheduled
Next Start Date
View schedule at training-nyc.com
View schedule at training-nyc.com
Not currently scheduled
Certification
Receive a Certificate of Completion
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
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
  • Shorter courses such as this are already affordably priced and are not eligible for discounts.
  • Take 10% off this course if you’ve previously taken any 12+ hour course.
  • Take $100 off this course if you’re an individual paying for yourself (not reimbursed by a company).
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
Anyone
Anyone
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
  • Financial accounting fundamentals, including cash versus accrual accounting and GAAP
  • Income statement line items and financial metrics
  • Balance sheet: Assets = Liabilities + Shareholder's Equity
  • Cash Flow Statement: Cash flows from operations, investing, and financing
  • How the financial statements tie together
  • 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