Introduction to Financial Modeling using Excel
SKU: OC8FE8BFE24
Rs. 5999 Rs. 5999 ( % Off )
Check availability at:
* For Indian Pincodes only

  • 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 Requirement   :Basic Knowledge of Excel and accounting concepts

What Will I Learn

At the end of this course you will be able to:
  • 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

Training 5 or more people ?

We provide custom courses and group sessions as well. To know more about our Customized Programs, click here.

Try BSE Business

How It works

Live Classroom Sessions
Every session is a practical and comprehensive guide to Hedge Funds, interactive sessions and activities.

Interact, Learn and Grow
BSE Institute Community enables you to master the concepts, interact with expert faculty and other learners and be a part of the community whilst growing.

Get Certified
Share your success with the world. Earn an official recognition from the BSE Institute as a valuable certificate.