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

  • Complex Excel Functions
  • Using What if Analysis
  • Goal Seek & Scenario Manager
  • Formatting especially number formatting
  • References, fixed and relative references
  • Pivot Table, analyzing with pivot tables
  • Slicers & Timeline
  • Charts, Smart Tables
  •  Connection of Multiple Pivot Table
  • Connection of Multiple Slicers
  • IF Function
  • Multiple IFS
  • Overview of Financial Modeling
  • Understanding Financial Statement Analysis
  • Learning Financial Modeling best Practices
  • Financials Model Setup
  • Strategies to build financial model
  • Revenue and pricing
  • Cost of Sales
  • HR and Payroll
  • Operating Costs
  • Working Capital
  • PPE Lapsing & Depreciation
  • Debt and Loan Amortization
  • Equity
  • Income Tax
  • How to integrate financial statements
  • Forecasted Income Statement
  • Forecasted Balance Sheet
  • Forecasted Cash Flow Statement
  • 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
  • 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.

Fee Schedule

Actual Training Fee: PKR 26000

50% OFF Fee: PKR 13000

IFA UK Certificate Fee: GBP65

Note: Dispatch of hardcopy certificate in Pakistan is Free of cost whereas for international courier actual cost will apply.

Online Payment

image

To Register for Certified Financial Modeler (CFM) UK, got to shop, add to card and proceed to check out for payment.

Chat Now
Welcome to LEXICON Chat!
Welcome to LEXICON
Let's connect on WhatsApp to help you further.