Please wait while we get your page ...

Financial Data Modeling 2 Days Training by MindCypress at Nairobi
Financial Data Modeling 2 Days Training by MindCypress at Nairobi

By - Ayo Obafemi

Posted - 12-01-2020

This Financial Modeling training will make you learn the art of constructing an integrated financial model. After this session you will be building financial models that are resilient and provide you with strong projections that can be used to analyze a company on the points like Planning, Investment, Financing and Valuation.

Benefits of attending:
Design & Structure various financial problems and translate them to Excel
Will be able to create robust models quickly
Implement Sensitivity & Charting techniques
Understanding techniques to quickly audit the financial model

Who should attend this Training?

  • Business planning & strategy
  • Financial Research Analysts
  • Corporate Finance managers
  • Project Finance Analyst
  • Investment Banking Associates
  • Entrepreneurs
  • Credit Analysts

Course Agenda for 2 Days of Financial Modelling Training
Day 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

Day 2

  • 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

Day 3

  • 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

Day 4

  • 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

online finance courses
financial modelling course
finance courses
financial analysis online course
financial modelling online course
best financial modeling course
financial modelling course fees
excel for finance course
excel financial modelling course
excel financial modelling course online

MindCypress brings you the engaging Financial Modeling Workshop for finance related professionals. Register now for early bird discounts.

Date And Time
Sat, Jan 18, 2020, 9:00 AM –Sun, Jan 19, 2020, 5:00 PM EAT

ibis Styles Hotel Westlands Nairobi
Rhapta Road Rhapta Road- Westlands
Nairobi, Nairobi County 00800

Ticket: $637.10

Inline Feedbacks
View all comments
Would love your thoughts, please comment.x