WELCOME TO BSE Institute Ltd.

Financial Statement Analysis Using Excel

BASIC INFORMATION

  • Level : Beginner
  • Mode : Online
  • Eligibility : Graduate
  • Duration : 6 Days
  • Location : Mumbai
  • Start Date : TBA

Course Description

This course provides the knowledge for the investors who can use Excel to run technical calculations or produce fundamental accounting ratios. Corporations may use Excel to run a capital budgeting analysis, risk analysis or discount cash flows. Options traders often use Excel to run Black-Scholes pricing.

Learn all the Excel tips, techniques, shortcuts, functions, and formulae you'll ever need. This course is tailored at Excel users who conduct professional financial analysis and modelling. We cater to users of all skill levels, from beginners to experts.

Objective of the Course

  • Enter and Format data in Excel
  • Use Formulas and Conditionals in Excel
  • Create Charts in Excel
  • Perform professional level financial analysis in Excel
  • At the end the course students will be able use industry best practices
  • Building financial models in Excel

Course Syllabus

  • Navigation and data
  • Formatting and Style
  • Formulas and Conditionals
  • Charts
  • Time Value of Money
  • Financial Statement Analysis & Forecasting

Partner / University

The University of Mumbai (known earlier as University of Bombay) is one of the oldest and premier Universities in India. It was established in 1857 consequent upon "Wood's Education Dispatch", and it is one amongst the first three Universities in India. As a sequel to the change in the name of the city from Bombay to Mumbai, the name of the University has been changed from "University of Bombay" to "University of Mumbai", vide notification issued by the Government of Maharashtra and published in the Government Gazette dated 4th September, 1996. The University was accorded 5 star status in 2001 & 'A' grade status in April 2012 by the National Assessment and Accreditation Council (NAAC). It has been granted University with Potential for Excellence (UPE) status by UGC and PURSE Scheme by DST.

mumbai University

Key Takeaways

  • Use Excel to perform Time Value of Money calculations
  • Learn to analyse the three Financial Statements using Excel: the income
  • statement, balance sheet, statement of cash flows
  • Create Charts in Excel
  • Perform professional level financial analysis in Excel
  • At the end the course students will be able use industry best practices
  • Building financial models in Excel

Program Highlights

domains

300+ world class practitioners
as faculty members

Our trainers and coaches are experts in their fields of study, with intensive knowledge
and industry experience that guide
their teaching methodologies.


domains

Cutting edge curriculum

Each course is designed by industry-experts aligned to market demand.


domains

Learning Design

Learn what is necessary, experiential
and hands on.


domains

Globally recognized

Certifications recognized not just in
India but globally.


domains

Gateway to International opportunities

Build your learning credentials and use them for pathways to International Universities.


domains

Iconic Campus

Iconic building and a place to meet merchant bankers regulators, market gurus to expand your network.


Participant Testimonials

OUR RECRUITMENT PARTNERS

BNP Paribas
Morningstar
Morgan Stanley
Integreon
Axis Bank
Motilal Oswal
V Createk
Standard Chartered Bank
Angel Broking
Anand Rathi