-
Introduction to Financial Modeling using Excel
Online Course
Basic Info : Introductory course to Financial Modeling using Excel Level : Intermediary Commitment : 8 hour (4 sessions of 2 hours each) Language : English Technical Requirement:Laptop with minimum 2 GB RAM and OS windows XP or above
What Will I Learn
- Examine financial modeling functions in excel
- Interpret cash flow model
- Analyze Ratio Analysis
- Apply integrated 3 way financial model
Curriculum
SESSION 1: Introduction to Financial Modelling Concepts in Excel SESSION 2: Structuring the cash flow model SESSION 3: Ratio Analysis SESSION 4: Integrated 3 way financial model
- • Defining scope of model
- • Aims of the model
- • Model limitations
- • Planning financial model
- • Incorporating best practices
- Setting up work book and structure
- • Time scale
- • Data Sources
- Managing input section
- Building calculation section
- • Cash flow forecast
- • Performing ratio analysis
- • Understanding profitability ratios
- • Interpreting liquidity and solvency ratios
- • Balance sheet, income statement , cash flows
- • Interest circularity
- • mploying ratios to make financial forecast
Includes
Interactive Sessions
Session-specific Assignments(* Condition Apply)
Certificate from BSE Institute Ltd.
Training 5 or more people ?
We provide custom courses and group sessions as well. To know more about our Customized Programs, click here.
How It works
Live Online Sessions
Every session is a practical and comprehensive guide to Financial Modeling using Excel,interactive sessions and activities.
Interact, Learn and Grow
BSEVarsity.com enables you to master the concepts, interact with expert faculty and other learners and be a part of the community whilst growing.
Get Certified
Get Certified from BSE Institute Ltd. Share your success with world