Financial Modeling & Analysis are among the most highly-respected skills in the business world and job marketplace. The program gives candidates a scope to develop or progress in Accounting Finance and Financial Analysis Career.
The areas that you will learn:
- Financial Modeling with Dynamic Arrays (Newly Added Topic)
- Excel Functions and Features Required for Financial Modeling
- Defined Names
- What if Analysis in Excel
- Model Structure
- Understanding Workbook, Worksheet and Cell formatting for model
- Financial Modeling Best Practices & Revenue Drivers
- Scenarios Analysis and Integration with model
- Sensitivity Analysis
- Preparation of Schedules for Financial Model
- Preparation of Valuation Model - Case Study
- Project Appraisal Calculations: NPV, IRR, Payback Period, Profitability Index
- Model Auditing
- Getting data from multiple sources using power query
- Creating relationships among all sources using data modeling
- Data Analysis and Dashboard Reporting using Power Excel
Endorsed By:
The Institute of Financial Accountants has endorsed this program. After successfully completing the course the candidate will be provided with a completion certificate from the Institute of Financial Accountants (IFA) UK.
