Financial Modeling - MindCypress | Educartis

baltimore
4 days
Course
Online

We are sorry!

The course Financial Modeling Course provided by MindCypress is no longer available. You can find similar courses here:

Check more courses in Finance Courses >>

Benefits

Course Overview

The Financial Modeling" course is designed for senior level, managers, and business owners in financial positions willing to extend their knowledge of modern finance to upgrade their forecasting and decision making skills for the business. This training will make learners learn the art of constructing an integrated financial model. After the session learners will be building financial models that are resilient and provide strong projections that can be used to analyze a company on the points like Planning, Investment, Financing and Valuation.

How This Course Will Benefit Your Career

The objective of the Financial Modeling course is to meet the fast track requirements of the qualified professionals and students. At the end of the program, learners will be able to: 

  1. Design & Structure various financial problems and translate them to Excel
  2. Will be able to create robust models quickly
  3. Implement Sensitivity & Charting techniques
  4. Understanding techniques to quickly audit the financial models
Certification obtained

Financial Data Modeling Certification

What jobs will I qualify for?

Financial Analyst 
Financial Manager 

Admission Criteria

If you are interested in this course, you need to have working knowledge of MS Excel, cash flow statement, income statement, balance sheets and Finance.

How do I apply?

Contact us for details on how to apply

Payment options

Online and Bank wire transfer:
Beneficiary Account Number: 01410983390038
Account Name: MINDCYPRESS CONSULTANCY FZE
Bank SWIFT Code: NISLAEAD
Bank Name: NOOR ISLAMIC BANK
BankAddress: Emaar Business Park, Dubai- 8822
IBAN Number: AE140520001410983390038
Beneficiary Full Name and Address: MINDCYPRESS CONSULTANCY FZE,Business Center,Al Shmookh Building, UAQ Free Trade Zone, Umm Al Quwain, U.A.E
USD correspondent Bank: Citibank NEWYORK
SWIFT CODE: CITIUS33

Detailed course information

Course Agenda. Module 1: 
  • Excel as a Tool for Financial Modeling
  • Referencing & Excel Shortcuts for Financial Modeling
  • Building Layout for Scalable Financial Model
  • Building Growth Drivers for Revenue
  • Building Growth Drivers for Cost
  • Building Asset and Debt Schedule
  • Projecting P&L and Balance Sheet
  • Projecting Cash Flow Statement
  • Circular References in Cash and Interest
  • Analyzing Financial Statements with Ratios
  • Corporate Finance Concepts for Financial Modeling
  • Key Valuation Concepts
  • Valuation Using DCF and Comps
  • Scenario Analysis and Building Dashboards

Course Agenda. Module 2: 
  • Advanced Tools in Excel for Auditing Financial Models
  • Auditing Large Models and Complicated Formulas
  • Advanced Excel Functions to Create Flexible Financial Models
  • Using Index, Match and Offset Functions to create Flexible Models
  • Mastering Financial Functions – Lease Analysis for Facebook
  • Advanced Charting Techniques in Excel – Creating Football Field
  • Creating Dashboard for Financial Data
  • Understanding Macros
  • Creating Flexible Dashboards & Charts Using Form Controls
  • Introduction to VBA for Financial Modeling
  • Recording Macros to Break Circular References
  • Implementing Monte Carlo Simulation for Revenue Analysis –I
  • Implementing Monte Carlo Simulation for Revenue Analysis –I I
  • Summarization, Q&A
Show More

Where and When

16/10/2018


Course Provider

Contact Information

Email & Website
  • alankrita@mindcypress.com
  • https://www.mindcypress.com/
Phone & Location
  • +14438390850
  • +14438390850
  • 201 N Charles St, Suite 2406, Baltimore MD 21201
  • Business Center, Al Shmookh Building, UAQ Free Trade Zone, Umm Al Quwain, U.A.E.