Upcoming Events

No Events on The List at This Time

 

Be a Financial Analyst!

Certified Financial Modeling, UK  

Dice Analytics in collaboration with Lexicon School of Business and Finance (LSBF) has arranged an informative 2 weeks extensive workshop on Certified Financial Modeler (CFM) UK. Financial Modeling and 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. This financial modelling course will teach candidates to forecast the future performance of a company using a model built in Excel, candidates will learn the fundamentals of accounting, corporate finance, budgeting and forecasting and valuation.

 

By the completion of the course, the participant would be eligible for International Certification (CFM) by Institute of Financial Accountants (UK)!

 

You will further learn:

 

  • Identification and application of advanced excel functions essential for Financial Modeler.
  • Apply best practices for financial modelling for preparation of model.
  • Model structure designing based on pre-determined outputs & requirements.
  • Apply best practices in capital structure modelling and financial appraisal methods.
  • Build and incorporate Operating & Financial Schedules.
  • Perform sensitivity and scenario analysis in financial modeling.
  • Auditing Techniques in Excel to check the integrity and errors.
  • Valuation, forecasting and strategic financial decision making
View Course Outline Reserve Your Seat

Schedule

Starting

14th October, 2019

Duration

2 Weeks (Mon – Fri)

Timings

07:00PM to 09:30PM

Remaining

Limited spots available!

Meet the Trainers

Meet the trainers of this course who are financial analysts!

qodef-fullwidth-slider

Mr. Abdul Shakoor

Founder LEXICON I CFO I Regional Director IFA-UK I PU Lecturer I Advanced Excel Trainer

He is an experienced professional in the field of accounting, finance and advanced Excel. He also teaches as an adjunct faculty member in University of the Punjab and representing Pakistan as Regional Director of Institute of Financial Accountants (IFA) UK. Previously, he was teaching IT from Accountants to CA students in PAC group of Colleges, a leading institute for Chartered Accountancy.

qodef-fullwidth-slider

Mr. Saad Zubair Vohra

Business & Tax Consultant | Financial Modeller | Corporate Trainer

He has been actively involved in training & teaching professionals with many organizations and institutions as visiting faculty member, and trained thousands of professionals. He gained the repute of an international level trainer in excel with his knowledge of enabling maximum learning & retention in least possible time. Positively, training is more of his passion than profession as he empowers others to create value for their enterprises.

Course Outline

Week 1

    Advanced Excel Functions

    • Using Complex Excel Functions
    • Using Multi-sheet Formulas
    • Using What if Analysis
    • Goal Seek
    • Scenario Manager
    • Dynamic Vlookup
    • Fixed Asset Schedule
    • Loan Amortization

 

    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
    • Reporting through SUMIF, SUMIFS, Index & Match Etc.

 

    Taxation Implications in Financial Statements and Financial            Modeling

    • IF Function
    • Multiple IFS
    • Salaried & Non-Salaried Income Tax Calculator 2020
    • AOP Income Tax Calculator 2020
    • Tax Calculator on Rental Income Individual/AOP 2020
    • Capital Gain Tax Calculation with Tax Card 2020
    • IF AND Functions (Debtors/Creditors Ageing Report)

 

Week 2

    Fundamentals of Financial Modeling & Best Practices

    • Overview of Financial Modeling
    • Understanding Financial Statement Analysis
    • Learning Financial Modeling best practices
    • Financials Model Setup
    • Analysis Model
    • Data Table What-IF
    • NPV, ROI & Payback period
    • Comparison of two projects for financial decision making

   

    Financial Statement Projections Model & Visualization

    • Financial Model preparation and integration
    • Income Statement
    • Balance Sheet
    • Cash Flow Statement
    • Payroll

PRICING


Individual
Price for an Individual
Rs 15,000 per person
Group of Two
7% Discount for a group of two people
Rs 13,950 per person
Group of Three
10% Discount for a group of Three people
Rs 13,500 per person
Group of Four
15% Discount for a group of four people
Rs 12,750 per person

 

Frequently Asked Questions

Who should attend the course?

Students and working professionals with the background of Finance!

Who are the Instructors?

What is the timing of the course?

Duration: 2 Weeks

Class Days: Monday – Friday

Timings: 07:00 PM to 09:30 PM

Can I get a job after this course?

Since our instructors are industry experts so they do train the students about practical world and also recommend the shining students in industry for relevant positions.

Will I get a certificate after this course?

Yes, you will be eligible for IFA-UK Certification at the completion of this course.

How much hands-on will be performed in this course?

Since our courses are led by Industry Experts so it is made sure that content covered in course is designed with hand on knowledge of more than 70-75 % along with supporting theory.

What are the PC requirements?

For this Professional course, you need to have a PC with minimum 4GB RAM.

How this course will be helpful for students?

This hands-on program will prepare and equip students with the in-demand skills required to become a successful Analyst – BI and start a career in the growing and lucrative field of Financial Modeling!

How this course will be helpful for Working Professionals?

This course will equip working professionals with the best practices and actionable knowledge needed to put you and your organization aligned with advance cloud services.

Reserve your Seat

You can reserve your seat  by filling the form below!

 

Are you a: 
StudentWorking Professional

 

 

 





X