Financial Modeling in Excel is unfortunately unavailable

Thankfully we have 29 other Finance Classes for you to choose from. Check our top choices below or see all classes for more options.

Financial Modeling in Excel

at NYIM Training - Murray Hill

(732)
Course Details
Price:
$1,495
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Murray Hill, Manhattan
185 Madison Ave 11th Fl
At 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Save to WishList

35 people saved this class

Book a private group event
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 6

What you'll learn in this finance training:

Financial Modeling Course NYC

Learn financial modeling at NYIM's intensive, 2-day Financial Modeling Bootcamp. You'll learn accounting, finance, Excel tips & tricks, and build a comprehensive DCF model on a real public company. 

"Took the two day Financial Modeling Bootcamp. Extremely informative and useful. Smaller class size allows for one on one help and enables you to really understand the material you are working through. Additionally you build out a model on an actual company during the course, allowing you to preform the same kind of analysis you would use in a real office setting, as opposed to looking at generic accounting problems. Office itself is very nice, and the professors are extremely well informed. 10/10 would recommend to anyone looking to develop, sharpen, or reestablish their financial modeling skills."

Robert F.

Course Benefits

  • Build Intuition & Analytical Skills
  • Top Finance Instructor
  • Learn Excel Tricks
  • 100% Practical with Real-World Examples

Course Outline


  • Finance Principles: Review essential finance concepts, such as Net Present Value (NPV), Internal Rate of Return (IRR), and how to calculate them in Excel.

  • Market Capitalization: Learn how to calculate market cap for real companies, and which share count to use (basic versus diluted, and treasury stock method).

  • Enterprise Value: What is enterprise value and why do we use it? What should and shouldn't be included and why?

  • Financial Accounting: Learn accounting principles including accrual versus cash accounting. Analyze the core financial statements, including the income statement, balance sheet and statement of cash flow. Review financial ratios and working capital and discuss how these items impact modeling and valuation.

  • Discount Cash Flow Modeling: Learn the "skeleton" of DCF modeling, how to project cash flow and a terminal value, and derive a share price from the model.

  • Excel Techniques: Learn various Excel techniques, including Data Validation, CHOOSE, Data Tables, Goal Seek and more.

  • Leveraged Buyouts: Review LBOs essentials, the players, and typical transaction structures. Create a simple LBO model to illustrate how these deals work and how private equity firms analyzes them.

  • Real Company Analysis: At home, review a presentation and financial statements for a public restaurant company. Understand the company's business model, growth drivers, profitability metrics, and other factors that impact valuation.

  • Setup the Financial Model: Input historical financials, capital structure and other company information to start setting up your financial model.

  • Model Projections: Analyze the company's revenue and expenses via financial statements and management commentary. Adjust for one-time items. Understand what is causing revenue increases/decreaes and margin expansion/contraction. What will happen going forward?

  • Corporate Valuation: Calculate the WACC for the discount rate. Use the WACC and terminal growth rate to determine the Terminal Value (Gordon Growth Model).

  • Derive a value per share: Using the projections and discounted cash flows, derive an equity value per share. Review the model for reasonableness and sensitize the main assumptions.

  • Analyze the Model Output: Should we invest in the stock? What more information do we need? Where is our model deficient? Where do we will confident? How do these projections compare to management's and the analyst community?

Still have questions? Ask the community.

Refund Policy
  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

Map

Google Map

NYIM Training

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 14950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (1)

Get quick answers from CourseHorse and past students.

Question from Anonymous
Is NYIM accredited by American Council of Education?
Answer from Georgia C. CourseHorse StaffCourseHorse Staff
Hi there, unfortunately, no.
Answer
Cancel

Reviews of Classes at NYIM Training (723)

(723 Reviews)
Financial Modeling in Excel
Reviewed by Jose Gonzalez on 5/6/2014
I'm really happy with this class, I think it was well structured in terms of the assigned tasks and I was properly assisted by the teacher in each of the opportunities I demanded. This is a very useful course. Thanks
Financial Modeling in Excel
Reviewed by Patrice H. on 4/9/2015
Financial Modeling in Excel
Reviewed by Hailey I. on 2/17/2015
Financial Modeling in Excel
Reviewed by Anna D. on 2/17/2015
Financial Modeling in Excel
Reviewed by Anonymous on 1/8/2015
loading...

School: NYIM Training

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.  

The company is known for its practical and hands-on approach to its...

Read more about NYIM Training

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

29 Top Choices

Financial Statement Analysis / Accounting

at Training The Street - Murray Hill 275 Madison Ave 12th Fl, Ste 1201, New York, New York 10016

This course is designed to prepare financial professionals for the challenges of valuing a company or building a financial model by providing the building blocks that are employed in these methodologies. Oriented around interpreting financial results, these seminars weave classroom lecture, in-class exercises and critical thinking developed through...

Wednesday Oct 23rd, 9am - 5:30pm

  (3 sessions)
$3,750

3 sessions

Core Comprehensive: Financial Modeling & Corp Valuation

at Training The Street - Murray Hill 275 Madison Ave 12th Fl, Ste 1201, New York, New York 10016

5 Day Core Comprehensive: Financial Modeling and Corporate Valuation Financial Modeling and Corporate Valuation course explores the modeling and valuation techniques commonly used by Wall Street firms. The proven curriculum provides practical application of the standards and methods that a practitioner needs to be a top performer. Led by our team...

Monday Oct 28th, 9am - 5pm

  (5 sessions)
$6,250

5 sessions

Angels Investing 101

at Class Rebel - Midtown 115 W 45th St 7th Fl, New York, New York 10036

How to invest directly into early stage companies you really believe in. The goals of Angels 101 The goal of Angels 101 is that you become so versed and so comfortable with the language and mechanics of angel investing, that you can confidently approach any early stage founder whose company you really believe in, and secure yourself an investment...

Monday Oct 21st, 6pm - 9pm

  (4 sessions)
$249

4 sessions

Principles of Real Estate Finance I

at Baruch College - CAPS - Murray Hill 10010

In this fundamental course in Real Estate Finance, learners will acquire an understanding of this specialty.  Covered will be topics including valuation, investments, analysis, and decision-making. Students will be provided with a general understanding of how finance fits in with the larger picture of the economics of Real Estate. Note: Classroom...

Saturday Nov 2nd, 9am - 5:45pm

  (3 sessions)
$509

3 sessions

The Four Most Important Numbers For Your Money

at Brooklyn Brainery - Prospect Heights 190 Underhill Ave, Brooklyn, New York 11238

We count calories and check our body mass to reduce our weight and get healthy, measure our success as students in terms of SAT scores and GPAs, and keep track of our favorite sports teams by number of wins and other metrics. Getting a handle on your finances can be as easy as understanding benchmarks and numbers as well. It boils down to four...

Saturday Nov 2nd, 9:30am - 11am

Essentials of Valuation and Financial Modeling

at Training The Street - Murray Hill 275 Madison Ave 12th Fl, Ste 1201, New York, New York 10016

Developed with the working professional in mind, this 8 session course covers Financial Statement Analysis, Valuation, Financial Modeling, and Specialized Modeling. Essentials Outline: Sessions 1&2 – Financial Statement Analysis and Core Valuation Methodologies Financial Statement Analysis Analyzing a company’s income statement, balance...

Tuesday Oct 22nd, 6:30pm - 10pm

  (8 sessions)
$3,800

8 sessions

Savvy Social Security for Boomers

at Bronxville Adult School - Bronxville 177 Pondfield Rd, Bronxville, New York 10708

Whether you're one, five or more years from retirement...single, divorced, or a couple...Social Security represents a key element of your financial plan. Understanding when and how to take your benefits will impact the maximum benefit you are entitled to, and affect your total retirement income strategy.  This class reviews the best options...

Wednesday Oct 23rd, 7pm - 9pm

D - Series 7 Top Off : Live Traditional

at Greico Financial Training Institute - Financial District 14 Wall St 20th FL, New York, New York 10005

The Greico In-Class Experience is unique in that it is engineered to appeal to all learning styles (Audio, Visual, and Tactile) especially for the newer generations who need higher levels of stimulation and the older generations who need the curriculum presented in the context of a story. All our courses and programs are created for maximum retention...

Thursday Dec 5th, 10:30am - 6pm

  (5 sessions)
$299.99

5 sessions

Financial Analysis & Valuation for Decision Making™

at Columbia Business School - Morningside Heights 3022 Broadway Uris Hall, New York, New York 10027

Creating value is the central task for any executive. To generate value, managers need to be able to assess the financial impact of their decisions, which in turn requires an understanding of financial analysis techniques and valuation methods. Financial Analysis and Valuation for Strategic Decision Making will help you evaluate the financial...

Monday Dec 16th, 8:30am - 5:30pm

  (3 sessions)
$6,350

3 sessions

​Fundraising 101

at Class Rebel - Midtown 115 W 45th St 7th Fl, New York, New York 10036

This course covers both the art & the science of raising money for a startup, led by someone who’s done it. After raising money and deploying capital from her first $32 million funds, Campfire Capital, instructor Brooke Harley realized that Ivy League students were being specifically groomed and taught to raise money for their ideas. But she...

Saturday Oct 26th, 10am - 4pm

  (2 sessions)
$249

2 sessions

Principles of Real Estate Finance II

at Baruch College - CAPS - Murray Hill 10010

This course will build upon the knowledge acquired in Finance I to enhance students’ practical job related finance skills.  Students will gain the knowledge needed to understand income analysis, operating statements, pro forma analysis, capitalization rates, discount rates, return on investment, net operating income, debt and equity markets...

Monday Oct 28th, 6pm - 8:50pm

  (8 sessions)
$509

8 sessions

Finance and Accounting for the Nonfinancial Executive™

at Columbia Business School - Morningside Heights 3022 Broadway Uris Hall, New York, New York 10027

In five days of hands-on, interactive sessions, Finance and Accounting for the Non-financial Executive provides you with a unique opportunity to deepen your expertise of finance and accounting for better management and decision-making capabilities. The program features sessions on the role of accounting, key concepts of managerial and financial...

Monday Dec 9th, 8:30am - 5:30pm

  (5 sessions)
$9,550

5 sessions

Personal Investments

at Baruch College - CAPS - Murray Hill 10010

This introductory course is for individuals who would like to enhance their knowledge and experience to make better investment decisions. You will learn how to read financial pages and analyze the risks and rewards of investing. Note: Classroom location listings are also posted outside the CAPS office and the lobby of the 17 Lexington Avenue building....

Saturday Nov 9th, 9:30am - 3:30pm

  (5 sessions)
$665

5 sessions

A - Series 24 : Platinum Package

at Greico Financial Training Institute - Financial District 14 Wall St 20th FL, New York, New York 10005

The Series 24 exam—the General Securities Principal Qualification Examination (GP)—assesses the competency of an entry-level general securities principal candidate to perform his or her job as a general securities principal. The exam measures the degree to which each candidate possesses the knowledge needed to perform the critical functions of...

Thursday Nov 7th, 10:30am - 6pm

  (2 sessions)
$599

2 sessions

A - Series 9/10 : Platinum Package

at Greico Financial Training Institute - Financial District 14 Wall St 20th FL, New York, New York 10005

Product Description Class 32+ hours (Live or Online)  Textbook (900 pg.) with Print Exams and Finals (2,000+ Q's) Greico Online Question Bank (2,000+ Q's) Quick Guide Diagnostic Exam Set Instructor Help Line All training courses at Greico Financial Training have been Greico Engineered to appeal to all learning styles (Audio, Visual,...

Thursday Nov 7th, 10:30am - 6pm

  (4 sessions)
$799

4 sessions

D - Series 24 : Live

at Greico Financial Training Institute - Financial District 14 Wall St 20th FL, New York, New York 10005

The Series 24 exam—the General Securities Principal Qualification Examination (GP)—assesses the competency of an entry-level general securities principal candidate to perform his or her job as a general securities principal. The exam measures the degree to which each candidate possesses the knowledge needed to perform the critical functions of...

Thursday Nov 7th, 10:30am - 6pm

  (2 sessions)
$399

2 sessions

International Trade:Embarking on the Global Marketplace

at Baruch College - CAPS - Murray Hill 10010

This course reviews the environmental factors affecting trade, the elements of an international contract, dispute resolution, rates of exchange, pricing terms, negotiation terms and communications, transportation, financing procedures, documentation, insurance, information resources, government regulations and international trade organizations. ...

Thursday Nov 7th, 6:15pm - 8:45pm

  (10 sessions)
$739

10 sessions

Meditation: Bliss

at Three Jewels - East Village 5 E 3rd St, New York, New York 10003

Learn how to generate bliss! We will be cultivating joy through guided visualization practices. Price listed is the suggested donation price.

Saturday Oct 19th, 6:30pm - 7pm

Advanced Topics: Intercorporate Investments

at Training The Street - Murray Hill 275 Madison Ave 12th Fl, Ste 1201, New York, New York 10016

Full course title: Advanced Topics: Intercorporate Investments, Complexities with Modeling Debt, Divestitures & Acquisition Structure Alternatives In  response  to  requests  for  more  intermediate  and  advanced  level  training, we have  taken  our  most  popular  advanced ...

Thursday Nov 14th, 9am - 5pm

D - Series 27/28 : Live

at Greico Financial Training Institute - Financial District 14 Wall St 20th FL, New York, New York 10005

The Series 27 exam—the Financial and Operations Principal Qualification Examination (FN)—assesses the competency of an entry-level financial and operations principal (FINOP) candidate to perform his or her job as a FINOP.  The exam measures the degree to which each candidate possesses the knowledge and understanding of the financial responsibilities,...

Thursday Nov 14th, 10:30am - 6pm

  (2 sessions)
$739

2 sessions