Financial Data Modeling
- Total time
Financial Data Modeling
Starting dates and places
Description
In this Training
Learn making Financial Models and assess viability of projects/firms 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 …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
In this Training
Learn making Financial Models and assess viability of projects/firms 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 11:15 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 –II
- Summarization, Q&A
Share your review
Do you have experience with this event? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.