Financial Modeling Professional Certificate

New York Institute of Finance

How long?

  • 5 days
  • in person, online

What are the topics?

New York Institute of Finance

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Reviews

Make sure this course is right for you.

Get unbiased reviews and personalized recommendations.

Who should attend

  • Entry level finance professionals
  • investment professionals
  • financial analysts
  • corporate bankers
  • and lateral hires

About the course

Learn how to build common to complex financial models on Excel with information provided both on financial statements and from external sources. Prerequisite knowledge:

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

CURRICULUM

Day 1

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

Day 2

MODULE 1: FINANCIAL MODELING

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

Day 3

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

Day 4

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

Day 5

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

** WHAT YOU'LL LEARN**

  • Use common function keys
  • Construct a basic IF statement
  • Differentiate between different ways of summing and counting
  • Select alternatives to using the IF function
  • Use error trapping
  • Control the appearance of numbers and text
  • Apply various methods for determining dates
  • Select and apply appropriate lookup and reference functions
  • Create a Pivot Table to analyze data sets
  • Use functions for discounting on uneven periods
  • Understand other useful Excel features
  • Apply financial modeling best practices
  • Project an income statement and balance sheet
  • Force-balance the balance sheet
  • Construct a Statement of Cash Flows
  • Calculate free cash flow
  • Incorporate projection scenarios in a model
  • Add an automatic cash sweep feature to a model
  • Construct a discounted cash flow model to determine the intrinsic value of equity
  • Perform meaningful sensitivity analysis
  • Construct a valuation sheet to apply the APV valuation approach
  • Value a stream of future interest tax shields
  • Measure residual earnings (earnings above or below required earnings).
  • Determine the value of earnings using accrual accounting
  • Determine the value of equity or the firm using multiples

Financial Modeling Professional Certificate at New York Institute of Finance

From  $3,119

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.