| NAME OF THE COURSE |
| FINANCIAL MODELLING, VALUATIONS &INVESTMENT BANKING |
| |
| CERTIFICATION |
| CERTIFIED FINANCIAL MODELLING, VALUATIONS &INVESTMENT BANKING PROFESSIONAL |
| |
| COURSE OVERVIEW |
| The course provides the technical skills for implementing financial models with Excel. Students are equipped with the basic operational tools to understand financial markets and can employ the modelling abilities developed via sample applications to build their own models. Coursework mainly focuses on functions already embedded in the worksheet as well as on procedures designed to solve specific problems. The course concentrates on the application of several theoretical models for financial valuation, optimal portfolio choice and performance evaluation |
| The programme will walk participants through an analysis of an organization’s financial statements using case study exercises, where participants will calculate key ratios and analyze trends over time. Engaging in discussions on both historic and current fraud cases, participants will learn how to recognize “red flags” in financial statement reporting. |
| |
| TRAINING DURATION |
| Total Training Hours : 22 Hours |
| Training Duration : 1 Week |
| Total Training Days : 4-5 Working Days |
| |
| TRAINING SCHEDULE |
| Weekdays (Sunday to Thursday) |
| Regular Sessions : 4 – 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm) |
| Food & refreshments Included |
| Weekends (Friday & Saturday) |
| Fast Track Sessions: 8 Hours per day (9am to 5pm) |
| Food & refreshments Included |
| |
| CERTIFICATION |
| Globally recognized certificate from “Kings Global Career Academy” |
| |
| TEST |
| No |
| |
| LEARNING AIDS |
| Yes |
| |
| COURSE MATERIAL |
| Hard & Soft Copies of Study Material |
| |
| LANGUAGE OF INSTRUCTION |
| English |
| |
| INSTRUCTOR HELPLINE |
| Yes |
| 1. Email |
| 2. Social Media (For Emergency requirements) |
| |
| REGISTRATION REQUIREMENTS |
| 1. Passport Copy |
| 2. Curriculum Vitae |
| 3. Passport size photographs |
| 4. Course Fee |
| |
| MODE OF PAYMENT |
| Cash / Cheque / Credit Card / Bank Transfer. |
| |
| ELIGIBILITY |
| Graduate Students |
| Mid-Level Managers / Senior Managers |
| CXOs |
| Executives |
| Investment banking analysts |
| Entrepreneurs |
| |
| COURSE BENEFITS |
- Financial modelling has a huge prospect as the experts are required in all businesses, irrespective of size and genre. The global economy is developing day by day and every business wants to know whether they can be on the top or how they can mould the parameters into their benefits. That is why the career in financial modelling has such a boost.
|
- Establish and maintain robust internal control systems.
|
- Identify the critical cost area with different business units.
|
- Improve the internal control systems.
|
- Liaise with business units to provide insights to performance and efficiency to facilitate achievement of departmental Key Performance Indicators (KPI).
|
- Liaise with internal and external functions to promote understanding of business performance.
|
- Perform analysis of revenue performance and growth, profit and loss reports, operating variances, revenue reports, track and analyse key performance indicators.
|
- Prepare accurate and timely statutory reports.
|
- Prepare the management report.
|
- Propose cost improvement to business units
|
| |
| COURSE CONTENTS |
- A management position in acquisitions
|
- Financial modelling and audit management
|
- Project management in Financial Model Conversion
|
- Analyst in Equity research
|
- Economic data research analyst
|
|
- Basic Excel Formulas and Functions
- Adv Formulas and Functions of Excel
- Data Analysis Tools of Excel
- Financial Statements Analysis and Accounting
|