Our Shop Certified Financial Modeler (CFM)-UK
Certified Financial Modeler (CFM)-UK
$499
Financial Modeling & Analysis are among the most highly-respected skills in the business world and job marketplace. Banks, Accounting, Investment, Insurance, and Business Decision Making rely on complex analytical decisions daily.
Aug 1 – 4 & 8 – 11
8:00 – 10:00 pm Instructor Led Live Online
This Package Includes:
16 Hours Live Training
Daily Lecture Recordings
MS Excel Files
Online Quiz & Assignments
Download Course Contents: Certified Financial Modeling
Description
Course Duration: 2 Weeks (Monday – Thursday)
Course Outline:
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 of 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
Instructor
Abdual Shakoor
Experienced Finance and Account professional with a demonstrated history of working in the manufacturing industry, education management industry, skilled in Internal Audit, Operations Management, Analytical Skills, Account Reconciliation, and Accounting and Financial Reporting. Strong finance professional with Certified Public Accountant (CPA), Master of Philosophy (M.Phil.) in Project Management and Certified Islamic Banker (CIB)-UK certifications.
Only logged in customers who have purchased this product may leave a review.
Reviews
There are no reviews yet.