Financial Modeling Professional Certificate

New York Institute of Finance

ITEM FIMD0209

06 May 2024 - 10 May 2024

09:00 AM - 04:30 PM

$3,899.00

12 Aug 2024 - 16 Aug 2024

09:00 AM - 04:30 PM

$3,899.00

28 Oct 2024 - 01 Nov 2024

09:00 AM - 04:30 PM

$3,899.00

group

In person

update

5

language

English

school

Introductory

06 May 2024 - 10 May 2024

09:00 AM - 04:30 PM

$3,899.00

12 Aug 2024 - 16 Aug 2024

09:00 AM - 04:30 PM

$3,899.00

28 Oct 2024 - 01 Nov 2024

09:00 AM - 04:30 PM

$3,899.00

videocam

In person

update

5

language

English

school

Introductory


Questions? We're here to help you

Please complete this form and a NYIF Career Advisor will assist you.



Please fill in the field.

Next

Please complete this form and a NYIF Career Advisor will assist you.



Please fill in the field.

Prev
Next

Please complete this form and a NYIF Career Advisor will assist you.


Please fill in the field.

Prev
Next

Select preferred contact method

Schedule call

call center image

or

Please fill in the field.

Send us your questions

email image
Prev

Where Wall Street Goes to SchoolTM!

Please select a time and date from the calendar to book a 15-minute call with a NYIF Career Advisor.

You can also reach us on +1 347 842 2501 or marketing@nyif.com

Something went wrong, please try again later!

17

Financial Modeling Professional Certificate

In this financial modeling course, you learn how to build common to complex financial models on Excel with information provided both on financial statements and from external sources.

CPE Credits: 35

Prerequisite knowledge:

  • Undergraduate degree or equivalent, proficiency in basic Excel, Word processing skills

 

Click here to download course curriculum

Watch our Financial Modeling taster video to learn more about the course:

Learn now pay later with

To make it even easier to learn, you can finance your program through Affirm.

Loans offered through Affirm are available in the U.S. and Canada.

  • Easy monthly payments

    Learn more

  • Flexible payments

    Pay your monthly bill using a bank transfer, check, or debit card.

Module 1: Advanced Excel for Financial Modeling

  • Introduction / Tips & tricks that will help you speed up your spread sheeting
  • Multiple sheet models
  • Multiple file models
  • Drilling down: allows one to double-click a formula, and move back to its source. This can be particularly useful in the creation of menus
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot tables
  • Grouping downloaded data by account headings
  • Vertical and horizontal lookup tables
  • The Choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Outlining
  • Graphs
  • Indirect addressing

Module 1: Financial Modeling

  • Introduction and Overview
  • Projection-Valuation Modeling Best Practices
  • Pro-Forma Modeling
  • Exercises

Module 1: Basic Valuation Techniques

  • Case Study: Analyze historic information and develop a projection basis
  • Mergers and Acquisitions
  • Projecting financial statements for a complex M&A
  • Debt capacity and credit analysis for the acquisition
  • Alternative financing methods
  • Sensitivity analysis on cash flows
  • Case Study Exercises
  • Cost of Capital and CAPM
  • Return on equity
  • Seven steps using CAPM to determine the cost of capital
  • Implied risk premium in the current P/E multiple

Module 1: Valuation

  • Four Steps using the Gordon Model to determine the cost of capital
  • Four steps using the P/E multiple to determine the cost of capital
  • Financial Valuation Case Study Exercises Review and Discussion
  • Accrual Accounting Valuation
  • Accrual accounting valuation exercises
  • Valuation Using Multiples
  • Multiples valuation exercises
  • Transaction Multiples

Module 1: Special Valuation Issues

  • Implied profit margin
  • Three-stage valuation model
  • Develop an accrual accounting valuation model Review and Discussion
  • Warrants and Executive Stock Options
  • Warrant valuation
  • Value outstanding warrants
  • Share Repurchases
  • Using share repurchases to calculate growth in distributions
  • Sustainable growth rate
  • Share repurchases for comparable companies
  • Presentation of Valuation and conclusion

Module 2: Desk Ready Skills Knowledge Check

Customize Financial Modeling Professional Certificate

* Required Fields

Your Customization
Financial Modeling Professional Certificate

In stock

$3,899.00

Summary