Master in Financial Modelling
Overview
Financial Modelling is the process of combining historical & projected information to make informed business decisions.
Its use cases include- Raising Capital, Acquisitions, Organic Growth, Budgeting and Forecasting, Valuation, Management Accounting
Who should Attend:-
- Commerce Graduates / PG, MBAs etc. who are perusing for career in Accounting & Finance.
- Finance & Accounts executives- - for up-skilling their Financial Modelling & Budgeting skills.
Course Contains:-
Module 1- Advance Excel for (Finance Professionals)
- Basic Concepts- Formulas, Relative & Absolute References.
- Most commonly used Functions- Financial, Data & Time, Logical, Lookup etc.
- Importing or Connecting Data from various sources.
- Data manipulation- Filter, Sort, Group etc.
- Data Presentation & Visualization- Charts, Conditional Formatting, Pivot Tables.
- Practical cases studies- Cash Flow Planning, Payroll Processing, Sales Dashboards.
Module 2- Financial Statements & Analysis
Conceptual Understating of-
- Capital Budgeting Concepts, Time value of Money, NPV.
- Balance sheet, Income Statements, Cash Flow Statement Analysis, Ratio Analysis
Module 3– Case Studies
Projects on Creating Financial Models for-
- Multiproduct Manufacturing Company.
- IT/ITES Company
This Course will Help you:-
- To gain Conceptual understanding as well as Practical insight of preparing Financial Models.
- To gain particle experience of preparing Financial Models real life scenarios.
Certification & Placement Assistance:-
- On successful completion, participants will receive a certificate from Acecom Skills Development.
-
Upload your Resume & Get Free benefit of our Job Assistance program.