LIVE – Financial Modeling using Excel - Kolkata
$0 – $560
LIVE – Financial Modeling using Excel - Kolkata

LIVE – Financial Modeling using Excel - Kolkata

Event Information

Share this event

Date and Time

Location

Location

Kolkata

Kolkata

India

View Map

Friends Who Are Going
Event description

Description

Training_Internship

The Six week weekend (Fri & Sat) program aims to impart essential skills for Valuation, Advance Excel and Financial Modeling using Excel from Scratch including one full day workshop.

Key Takeaway :

  • Measure, interpret and predict company performance using excel modeling
  • Construct reliable and realistic financial models that are REALISTIC and EASY to review.
  • Based on real-time valuation and research projects. No Case studies.

Program Includes:
- 20 Hours Free Basic & Intermediate Excel Video
- 20 Hours VBA Video Session
- 3 Months Free Forum Access

Program Outline


Advance Excel Skills
Data Analysis & Presentation
• Basic and Advance Pivot Tables
• Single / Multi-Dimensional Analysis
• Advance Charting Techniques
• Sensitivity Analysis
Advance Excel Formulas
• Intro. Formulas & Syntax
• Text / Date / Numerical Formulas
• Stats and Financial Functions
• Formula Auditing and Error Finding
• Reference Styles

Excel Automation
• Introduction to Macros
• Macro Recording & Customizing Excel Menu
• Relative & Absolute Macros

Financial Modeling
First Basic Financial Model
• Generating Loan Amortization Schedule
• Adding Dynamic Control & Functionality

Second Model
• Capital Budgeting Decision Model
• Adding sensitivity parameters

Valuation Model Setup
• Learn Financial Modeling Best Practices
• Setup Integrated Financials
• Perform Historical Analysis
• Integrate Key Revenue Drivers

Financial Statement Analysis
• Ratio Analysis
• Horizontal / Vertical / Trend Analysis
• Financial Strength Analysis
• Bankruptcy Analysis

Financial Modeling
Forecasting Financial
• Setup Assumptions for P/L & B/S Forecasting
• Forecasting Income Statement & Balance Sheet
• Preparing Forecasted Cash flow statement

Simulation & Dashboard
• Monte Carlo Simulation of Stock Prices
• Basic Valuation Dashboard

Valuation
• Estimating Firm Beta / Cost of Equity & Cost of Capital
• Determining Peer Group
• Determining Terminal Cash Flows / Growth Rates
• Valuation DCF / Asset Based / Relative Models


Financial Modeling Workshop
Financial Modeling
• Setup Loan Amortization Model (2 Hours)
• Setup Equity Valuation Model

Download Complete Program Details
Download Trainer Profile

For more details please call / text / whatsapp +91 8106000606/4064622633


Share with friends

Date and Time

Location

Kolkata

Kolkata

India

View Map

Save This Event

Event Saved