Discover Classes. Earn Rewards.

Financial Modeling Bootcamp

at NYC Career Centers - Midtown

Master the art of financial modeling, corporate finance, and accounting principles with this intensive course. Build a comprehensive Discounted Cash Flow (DCF) model and gain advanced Excel skills to create accurate financial models quickly. Prepare for investment banking and financial analyst interviews with a financial model to showcase your skills.

Course Details
Price $995
Start Date

Fri, Jan 05, 10:00am - Jan 09, 5:00pm Eastern Time ( 3 sessions )
Next start dates ( 3)

20 seats left Need more seats? See group options for 8+

Location Interactive Online Classroom
Important
Class Level Advanced
Age Requirements 18 and older
Average Class Size 7
Purchase Options
Book Now

No Booking Fees. Lowest Price Guaranteed. Earn Rewards.

Give as a Gift Save to WishList

1 person wishlisted

Start Dates (4)

Interactive Online Classroom
TBD
$995
Book
Show all 3 sessions
  • Fri, Jan 05 at 10:00am - 5:00pm
  • Mon, Jan 08 at 10:00am - 5:00pm
  • Tue, Jan 09 at 10:00am - 5:00pm
Interactive Online Classroom
TBD
$995
Book
Show all 3 sessions
  • Wed, Mar 20 at 10:00am - 5:00pm
  • Thu, Mar 21 at 10:00am - 5:00pm
  • Fri, Mar 22 at 10:00am - 5:00pm
Interactive Online Classroom
TBD
$995
Book
Show all 3 sessions
  • Tue, May 21 at 10:00am - 5:00pm
  • Wed, May 22 at 10:00am - 5:00pm
  • Thu, May 23 at 10:00am - 5:00pm
Interactive Online Classroom
TBD
$995
Book
Show all 3 sessions
  • Mon, Aug 19 at 10:00am - 5:00pm
  • Tue, Aug 20 at 10:00am - 5:00pm
  • Wed, Aug 21 at 10:00am - 5:00pm
Save to WishList Purchase a Gift Card

Class Description

Description

What you'll learn in this financial modeling training:

Build a financial model and learn corporate finance and accounting principles. By the end of this course, you'll have a comprehensive Discounted Cash Flow (DCF) model to add to your portfolio. You'll have a fundamental knowledge of corporate finance and accounting concepts. Finally, your advanced Microsoft Excel skills will aid you in building financial models quickly and accurately.

Master Financial Modeling 

Build a comprehensive DCF (Discounted Cash Flow) model and master essential finance and accounting concepts. First, you'll dive into advanced Excel functions for finance like VLOOKUP and IF statements. You'll then review corporate finance and accounting concepts before building a valuation model on a public company.

The Financial Modeling Bootcamp covers common topics asked in investment banking and financial analyst interviews. After this course, you'll have a financial model to present as part of your portfolio during the interview process. This course prepares you with all the essential skills you need to succeed as a professional that specializes in building financial models.

  • Master Advanced Excel - Learn essential Excel functions for finance including cash flow projection tools, and shortcuts for building financial models in Excel
  • Learn Corporate Finance and Accounting - Learn the basics of enterprise value, corporate valuation, and reviewing financial statements
  • Create a DCF (Discounted Cash Flow) Financial Model - Review financial information, derive a share value, and create a financial model to evaluate an investment

Free Retake & Course Materials

In addition to receiving comprehensive financial training and a financial model to show off after the course, you receive the following benefits:

  • Free retake - take the course again for free within six months of your enrollment
  • Free access to computers and software - no need to bring a computer or purchase software for the course
  • Custom workbook - Keep your course workbook, complete with detailed instructions and practice exercises to reference and practice what you've learned after the course

This course has a prerequisite

  • Students without corporate finance or accounting knowledge should request access to and review our free online preparatory materials after registering for the course.
  • Excel proficiency equivalent to Intermediate Excel for Business is required, including VLOOKUP, Pivot Tables, and IF statements.

Course Overview

  • Advanced Excel for Finance: Financial functions, advanced formulas, Data Tables, & Excel tricks
  • Corporate Finance: Market Cap, Enterprise Value, Stocks & Bonds, NPV, IRR
  • Financial Accounting: Financial statements, financial ratios, and working capital
  • Company Analysis: Analyze companies through financial statements, presentations, & recent news
  • Discount Cash Flow Modeling: Project and discount future cash flows
  • Corporate Valuation: Corporate valuation principles to value companies
  • Financial Analyst Best Practices: Tips and tricks financial analysts need to know
  • Investment Banking Interviews: Review concepts typically asked in investment banking interviews

Full Course Syllabus

Day I: Advanced Excel for Financial Modeling

  • Advanced techniques to Expedite Workflow
  • Advanced Analytical Tools & Sensitivity Analysis
  • Database Functions for Finance
  • Functions for Financial Modeling

Day II: Intro to Corporate Finance, Accounting, & Modeling

  • Intro to Corporate Finance
  • Enterprise value
  • Financial Accounting & Statement Analysis
  • Integrated Financial Modeling
  • Intro to DCF Modeling
  • Sensitivity Analysis
  • Intro to LBO Modeling

Day III: In-depth Financial Modeling & Valuation

  • Company Analysis
  • Financial projections
  • Terminal Value
  • Discounting Cash Flows
  • Corporate Valuation
  • Final Analysis & Reasonability Testing

Learn more about Financial Modeling Bootcamp at NYC Career Centers


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYC Career Centers (676)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: NYC Career Centers

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Ready to take this class?
BOOK NOW

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Choose from thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...