Advanced Financial Modelling and Risk Management using Microsoft Excel 2007

Introduction


Financial modelling and risk management using Microsoft Excel are highly demanded professional affairs today. Though the course title emphasises heavily on finance and Microsoft Excel, development of sophisticated, comprehensive and dynamic financial model requires a little bit more than the skills in finance and spreadsheet applications. To be a professional financial modelling analyst it requires skills in system development, database, system security, project management and networking besides skills in finance and Microsoft Excel. Most of the contemporary training programs ignore these additional skills requirements. This course with the title “Advanced Financial Modelling with Microsoft Excel- Plan, Develop, Pack, Distribute and Protect” is developed with the objective of incorporating all these additional skills with the core finance and spreadsheet skills

Learning Outcomes
The course is designed for the professionals working in finance and accounting discipline having fundamental concepts of finance and Microsoft Excel.

1. Identify and Understand financial modelling scenarios and life cycle of a financial model and take necessary pre-development initiatives
2. Develop advance skills on Microsoft Excel Functions, Formulas and Referencing System
3. Understand and apply core and advance Financial functions needed in various financial activities
4. Understand risk management and take risk management decisions using What-if-analysis
5. Develop Costing, Budgeting and Other Financial Planning Models
6. Develop Investment analysis, Discounted Cash Flow Analysis and Portfolio Analysis Models
7. Making financial models dynamic using Control Tools
8. Implement security and sharing features as post-development activities

Methodology

The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:

Session 1: Financial Modelling Scenarios and Life Cycle
Scopes of Financial Modelling
Life Cycle of a Financial Model
Data collection and Assumptions
Application of Microsoft Excel in Financial Models

Session 2: Formulas, Functions and Referencing
Formulas with Absolute and Relative Referencing
Logical Functions
Lookup Functions
Financial Functions (Basic)

Session 3: Advance Financial Functions
Time value of money functions
Financial Evaluation Functions
Costing and Budgeting Related Functions
Accounting Functions

Session 4: Risk Management and What-if-Analysis
Risk Management in Finance
Goal Seek Analysis for Risk Management
Scenarios and Simulation
Advanced Referencing for Risk Management Models

Session 5: Costing, Budgeting and Financial Planning Models
Develop model for costing and pricing products and services
Prepare production, overhead and sales budgets

Session 6: Costing, Budgeting and Financial Planning Models
Prepare cash budget
Prepare pro-forma Financial Statements

Session 7: Investment Analysis and Planning Models
Develop a Investment Planning Model
Evaluate an Investment Project

Session 8: Investment Analysis and Planning Models
Discounted Cash Flow Analysis for Stock Valuation
Portfolio Analysis Models

Session 9: Model Control Tools
Drop-down Box, Check-box and Radio Button
Vertical and Horizontal Scroll Bars
Buttons and other Components
Macros and VBA

Session 10: Post-Development Activities
Testing models, finding Errors using Excel’s Error Handling Tools
Assigning Security
Adding Help Files and other Documents
Packaging the Model and Distributing

Related Courses

Enamul Haque Sujon
  • 28 Mar - 23 Apr 2017

Tally is a most powerful, yet very simple and easy, ...

Accounts
Dr. Md. Abdur Rouf
  • Saturday, April 8, 2017

Valued Added Tax (VAT) is a very important matter of ...

Accounts
Price 13,000 Tk + VAT
Md. Jehad Uddin
  • 11 Apr - 14 May 2017

This course is designed in such a way that participants ...

Accounts
Price 12,000 Tk + VAT
Dr. Md. Abdur Rouf
  • 14 - 22 Apr 2017 (4 days)

Accounts

Contact

9140345, 9117179

certificate@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

People who’re involved in financial decision making, financial analysts, financial controllers, and anyone who wants to be a financial modelling expert.