Key Information
Intro to Financial Accounting
Advanced Excel & Financial Modeling Intensive
Financial Modeling Bootcamp
$325 6 Hours
$1,495 24 Hours
$895 21 Hours
Overview
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. 
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
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.
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
185 Madison Ave, NYC or Live Online
185 Madison Ave, NYC or Live Online
Schedule
Next start date: October 21, Thursday, 10–5pm
Other scheduling options Weekdays only
View full schedule
Not currently scheduled
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
  • 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).
  • 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
12-Month FinancingSee our Climb Credit FAQ for more details
Target Audience
Anyone
Anyone

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 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
  • 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