Overview
The global business challenges integrated with the challenges in information technology requires astute managers with the knowledge and skills to advance the profitability and growth of any organization.
Project evaluation/finance and investment decision could be a mirage for managers without the required analytical skills. When looking at any financial opportunity, the ability to perform accurate and realistic analysis is imperative
KEY LEARNING OUTCOME
At the end of the course, participants should be able to:
- Understand the dos and don’ts in Building a Financial Model using Excel
- Prepare Financial Models using Excel systematically
- Leverage on some Excel Functions to enhance the Financial Models
- Prepare Financial Forecast by years with detail supporting worksheets for future changes
COURSE OUTLINE
- Introduction to MS-Excel
- Introduction to Advanced spread sheet
- Financial Models
- Impact of source of capital on model outcomes
- Ratio Analysis
- Risk Scenarios
- Enhancing The Model With More Creative Excel Functions
- Understand The Business Perspective And How To Effectively Use The Financial Model To Support Management For Better Decision Making
- Cash Flow Projections
- Fixed Assets
- Chart
- Supporting Work Sheets
- Macro Recording
TARGET PARTICIPANTS
- Equity and Credit analyst
- Research staff
- Financial analyst
- Investment analyst
- Stock Brokers
- Bankers
- Funds and Portfolio managers
- Trading and Risk Managers
- Accountants
- Pension Fund Managers
- Investor
COURSE DURATION: 3 Days
