LEXICON

Certified Financial Modeler (CFM)-UK

Financial Modeling & Analysis are among the most highly-respected skills in the business world and job marketplace from Banks, Accounting, Investment, Insurance and Business Decision Making rely on complex analytical decisions every day. We are pleased to share the features of Certified Financial Modeler (CFM)-UK this is professional qualification endorsed and awarded by Institute of Financial Accountants (IFA) UK. The qualification gives candidates scope to develop or progress in Accounting Finance and Financial Analysis Career.

Key Features

  • Global Designatory Words i.e CFM-UK
  • Competitive advantage with designarotyr letters
  • Increased recognition with UK certification
  • Career Growth with most emerging skill set
  • Practical course with Hands on Practice
Accounting
Finance
Modern Excel

Course Contents

    Advanced Excel Functions

  • Complex Excel Functions
  • Using What if Analysis
  • Goal Seek & Scenario Manager
  • Formatting especially number formatting
  • References, fixed and relative references

Business Reporting and Financial Analyses

  • Pivot Table, analyzing with pivot tables
  • Slicers & Timeline
  • Charts, Smart Tables
  •  Connection of Multiple Pivot Table
  • Connection of Multiple Slicers
  • IF Function
  • Multiple IFS

Fundamentals of Financial Modeling & Best Practices

  • Overview of Financial Modeling
  • Understanding Financial Statement Analysis
  • Learning Financial Modeling best Practices
  • Financials Model Setup
  • Strategies to build financial model

    Preparation of Schedules for Financial Modeling

  • Revenue and pricing
  • Cost of Sales
  • HR and Payroll
  • Operating Costs
  • Working Capital
  • PPE Lapsing & Depreciation
  • Debt and Loan Amortization
  • Equity
  • Income Tax

Financial Statement Projections Model

  • How to integrate financial statements
  • Forecasted Income Statement
  • Forecasted Balance Sheet
  • Forecasted Cash Flow Statement

Scenarios Management

  • Scenarios List i.e Base, Best and Worst
  • How to build scenario switch
  • Selection of Economic and other indicators for scenarios
  • Scenario switch integration
  • Summary of each scenario

Valuation Model

  • Understanding o Discounted Cash Flow (DCF) Model
  • Building of DCF model
  • Practical Case Study of DCF model
  • Calculation of NPV, IRR, Profitability Index (PI, Return on Investment (ROI) and Payback period with case study

I would like to say thank you to LEXICON trainer who patiently taught me new and advanced knowledge not only in excel but also topics about real business scenarios. I highly recommend LEXICON for the overall excellence in learning experience for Accounting and Finance professionals
Cherphil Ann V. Libunao,
Financial Planning & Analysis Lead

Have any Questions? Call us Today!

+92 3208875000

Brochures & Apply

You can download brochure to see complete details regarding course, trainer’s profile, schedule and fee

Awarded by

After successful completion of the training and assessment requirements, Certified of Completion will be awarded by Institute of Financial Accountants (IFA), an International Professional Accountancy Membership Body having more than 40000 members and students in more than 80 countries.