Be a Financial Analyst!
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
To be announced soon
Duration
2 Weeks (Mon – Fri)
Timings
07:00PM to 09:00PM
Remaining
Limited spots available!
Meet the Trainers
Meet the trainers of this course who is an experienced financial analyst!
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:00 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 and you can get the certificate after paying £50 as a fee required by the IFA-UK Institute.
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!