Financial Modeling Professional Certificate (NYIF)

Colleagues, in the “Financial Modeling Professional Certificate” program from the New York Institute of Finance 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]. Learn from hands-on training to build real-world models with examples from today's top firmsUse 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 and the value of equity or the firm using multiples. Skill-based training modules include: 1) Advanced Excel for Financial Modeling, 2) Financial Modeling, 3) Basic Valuation Techniques, 4) Valuation, 5) Special Valuation Issues, and 6) Desk Ready Skills Knowledge Check. 

Enroll today at (teams & execs welcome): https://tinyurl.com/566dkpay 

Download your free Finance, Accounting & Banking - Career Transformation Guide.

Much career success, Lawrence Wilson – Financial Certification Academy (share with your team)