financial modeling for analysis & forcasting

3
www.stockbangladesh.com PROFESSIONAL SKILL DEVELOPMENT TRAINING PROGRAM Exclusive Training Program on Financial Modeling for Analysis & Forecasting Venue: Dhaka Trade Center (14th floor), 99 Kazi Nazrul Islam Avenue, Kawran Bazar, Dhaka-1215. CERTIFICATE WILL BE AWARDED TO ALL THE PARTICIPANTS Training Details Date: April 05 & 06 of 2013 Days in Week: Friday & Saturday Time: 09:30 AM to 06:30 PM Duration: 18 Hours (09 Hrs/day) Total 2 days Last Date of Registration: April 04, 2013 Training Overview Financial modeling has become an imperative tool for financial decision making in today’s corporate world. Especially during uncertain and turbulent times, there is continuous pressure for properly defined financial models that identify and compare the impact of specific business initiatives and alternative scenarios on a company’s financial position. It is a vital task that provides the foundation for structural business change. The financial modeling technique requires the building of a financial representation of the business on a spreadsheet, and the identification and manipulation of key performance drivers to explore the impact of different operational and financial options. Financial modeling supports the reliability of decision making in many financial areas, such as valuation, forecasting, budgeting and investment appraisals. The capability to write simple spreadsheets is just not enough. You have to be able to incorporate all the "what if" scenarios Objectives of the Course: Build a financial model from scratch, or modify and improve an inherited model Select the most appropriate formula to achieve the desired outcome Mitigate errors by building in error checks Validate data entry by setting data entry parameters Develop drop-down boxes which enable a model to produce a series of results depending on scenario variable selected Registration Process Step 01: For online registration visit http://www.stockbanglade sh.com/courses/index Step 02: Deposit the training fee to Account No. 107-110-9792 at any branch of DUTCH-BANGLA BANK LTD. favoring STOCKBANGLADESH LTD. Step 03: email the scanned copy of the Bank deposit slip at training@stockbangladesh .com to ensure your participation. Or Visit our office for Why StockBangladesh Limited StockBangladesh, the pioneer technical analysis and outstanding information center of Bangladesh capital market offers comprehensive services to its clients by raising the bar of expectations. We recognize and support national development through the enhancement of technical analysis and effective application on stock market. We are pleased to inform you that StockBangladesh is the only training institute to provide training on both Technical Analysis and Fundamental Analysis of Facilitator's Profile Team of Expert Who Should Attend Personnel in Financial Institutions Students from Finance and Business studies Background Learning Methodologies • Presentation • Facilitator Feedback Special Notes Arrangement of Lunch, Refreshments during breaks. Course Material, Notebook, Pen etc. will

Upload: md-nayemuddin-shibli

Post on 28-Jan-2016

10 views

Category:

Documents


0 download

DESCRIPTION

Financial Modeling

TRANSCRIPT

Page 1: Financial Modeling for Analysis & Forcasting

www.stockbangladesh.comPROFESSIONAL SKILL DEVELOPMENT TRAINING PROGRAM

Exclusive Training Program on

Financial Modeling for Analysis & Forecasting

Venue: Dhaka Trade Center (14th floor), 99 Kazi Nazrul Islam Avenue, Kawran Bazar, Dhaka-1215.

CERTIFICATE WILL BE AWARDED TO ALL THE PARTICIPANTS

Training Details Date: April 05 & 06 of 2013 Days in Week: Friday & SaturdayTime: 09:30 AM to 06:30 PM Duration: 18 Hours (09 Hrs/day) Total 2 daysLast Date of Registration: April 04, 2013Training Fees: BDT 5,000.00 (Taka Five Thousand only) per Participant

Training Overview Financial modeling has become an imperative tool for financial decision making in today’s corporate world. Especially during uncertain and turbulent times, there is continuous pressure for properly defined financial models that identify and compare the impact of specific business initiatives and alternative scenarios on a company’s financial position. It is a vital task that provides the foundation for structural business change. The financial modeling technique requires the building of a financial representation of the business on a spreadsheet, and the identification and manipulation of key performance drivers to explore the impact of different operational and financial options. Financial modeling supports the reliability of decision making in many financial areas, such as valuation, forecasting, budgeting and investment appraisals.

The capability to write simple spreadsheets is just not enough. You have to be able to incorporate all the "what if" scenarios and stress any proposal to its limits. Financial Modeling with Excel is such a workshop where knowledge of Finance meets with Technology for better understanding of the Financial World.

The course on Business and Financial Modeling addresses these requirements through an emphasis on a systematic approach to building rigorous and structured financial models with practical applications to model building using Excel.

Objectives of the Course: Build a financial model from scratch, or modify and improve an inherited model Select the most appropriate formula to achieve the desired outcome Mitigate errors by building in error checks Validate data entry by setting data entry parameters Develop drop-down boxes which enable a model to produce a series of results depending

on scenario variable selected Fixing modeling problems, such as circular references Optimizing financial decision based on constraints

Registration Process

Step 01: For online registration visit http://www.stockbangladesh.com/courses/index

Step 02: Deposit the training fee to Account No. 107-110-9792 at any branch of DUTCH-BANGLA BANK LTD. favoring STOCKBANGLADESH LTD.

Step 03: email the scanned copy of the Bank deposit slip at [email protected] to ensure your participation.

OrVisit our office for registration.

Seat will be confirmed after payment. For registration or information please call Hot-Line

0192 9912 8780192 9912 8790192 9912 877

Why StockBangladesh LimitedStockBangladesh, the pioneer technical analysis and outstanding information center of Bangladesh capital market offers comprehensive services to its clients by raising the bar of expectations. We recognize and support national development through the enhancement of technical analysis and effective application on stock market. We are pleased to inform you that StockBangladesh is the only training institute to provide training on both Technical Analysis and Fundamental Analysis of Shares. We have been providing training courses on Technical Analysis and Fundamental Analysis since 2007 to investors, traders and other interested individuals. Moreover, StockBangladesh Ltd. conducted training on ‘Technical Analysis' under the training program of “Comprehensive Training Program on Capital Market” organized by Chittagong Stock Exchange for several times.

Facilitator's Profile Team of Expert Researchers from StockBangladesh Ltd. Research & Development Department

Who Should Attend• Personnel in Financial Institutions• Students from Finance and

Business studies Background• Anyone who is interested work in

financial institutions

Learning Methodologies • Presentation • Facilitator Feedback• Discussion, Q & A• Exercises, Case Study, Practice

Special Notes Arrangement of Lunch,

Refreshments during breaks. Course Material, Notebook, Pen

etc. will be provided. SEATS ARE LIMITED

Page 2: Financial Modeling for Analysis & Forcasting

www.stockbangladesh.comPROFESSIONAL SKILL DEVELOPMENT TRAINING PROGRAM

DAY-01

Session 01:Naming of cells and range of cells: Creating name Editing name Deleting name Creating dynamic name ranges using function How naming can help building financial model How naming can save lot of your time

Vlookup and Hlook up Function: Static Vlookup and Hlookup Dynamic Vlookup and Hlookup Combining vlookup with other functions to customize

works and saving a lot of time.

Index Function and Match Function: Index and Match functions can be used together, to

create a powerful and flexible formula. Dynamic searching using Vlookup, Match and Index

function

Text functions Use Left, Right, Trim, Concatenate etc functions Search function

Dates and Date Functions Date, DatedIf, Datevalue, Days360, Edate, Eomonth,

Month, networkdays, Today, Weekday etc functions

Logical Functions If function and Nested if function If error function

Session 02:Auditing Tools Trade precedents Trade dependents Checking errors

Sorting, Filtering and Tables Sorting Filtering and advanced filtering Using tables to create dynamic charts

Pivot Tables Build a pivot table from database, analyze and display

data Consolidation by category and consolidating using pivot

tables Pivot charts

Session 03:Understanding Financial Modeling & Case for it

DAY-02

Session 04:Financial Model Derivation with case study

Session 05:Risk Management and What If analysis Goal Seek Scenario Analysis Sensitivity analysis Monte Carlo Simulation Linear programming using solver function Scenario analysis using Spin buttons, Scroll bars, option

buttons, combo boxes etc

Statistical analysis and Business forecasting Summarizing data by using histograms Summarizing data using descriptive statistics Linear Regression analysis Multiple regression analysis Variance, Covariance, Standard deviation Correlation function Analysis of variance: ANOVA Forecast function Random variables and randomization

Miscellaneous Solving the problem of circular references Countif, countifs, count, counta, countblank functions Sumif, averageif, sumifs, averageifs functions Transpose function Upper, Lower, Proper function Offset function Using offset function for building scrolling table Indirect function Conditional formatting Choose Function Indirect Function

Session 06:Question & Answer

Training ContentVisit WWW.STOCKBANGLADESH.COM for more information

Above schedule is subject to change without prior intimations.

SMOKING FREE ZONE. Please keep your mobile in SILENT MOOD.

Payment Policies and Procedures:Payment is to be made by last date of registration. If you cannot attend any program for which you have paid, a notification within no less than 2 business days prior to your session’s start is required for courtesy transfer to use in any future Training program. If you fail to attend without notifying us in writing, in fairness to all attendees, neither a refund nor a courtesy transfer will be issued.