financial modeling for analysis & forcasting
DESCRIPTION
Financial ModelingTRANSCRIPT
![Page 1: Financial Modeling for Analysis & Forcasting](https://reader036.vdocuments.us/reader036/viewer/2022082519/5695d01d1a28ab9b029106d6/html5/thumbnails/1.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082519/5695d01d1a28ab9b029106d6/html5/thumbnails/2.jpg)
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.