AIM 1: Basic and Advance Excel

Basic Of Excel

Using Name Ranges

Index Matches

Formulas and functions

Logical Functions

Date Functions

H Lookup, V-Lookups and Reference Functions

Database Statistical Functions

Conditional Formatting

Aim2: Advance Excel

Camera tool

Data Tables

Circular References and breaking them

Key Concepts in Macros

Macros as recorded Robots

Form Contrls and Active X controls

Implementing user forms in Excel Macros

Linking forms to excel cells

Sensitivity tools & Scenario Analysis

Aim3: Financial Statement Modeling and Forecasting

Data mining and structuring

Data correcting and validations

Understanding business models

Taking Assumptions and integrating them into the model

Modeling Historical statements

Modeling Projected Income Statement

Modeling Projected Balance Sheet

Modeling The Cash Flow Statement (direct method & indirect method)

Modeling Working Capital Schedule

Fixed Assets Schedule (along with treatment of CWIP and Interest capitalization)

Modeling Depreciation & Amortization Schedule (Straight line & Written down Value)

Modeling Shareholders-Equity Schedule with a share repurchase table

Debt and Interest schedule with a 'cash sweep and moratorium-(Classification of debt as Senior Debt, Mezzanine Debt, Sub Debt along with repayment waterfall)

Modeling for Tax & Dividend

Aim 4: Valuation Methodologies

Modeling Discount Rate, Cost of Equity, Debt and Total Capital (CAPM and WACC)

Free Cash Flows to Firm (FCFF)

Free Cash Flows to Equity (FCFE)

The Discounted Cash Flow (DCF) valuation model for HCL Technologies

Estimate Terminal Value using The Perpetuity Growth Model

Modeling Estimate Enterprise Value

Calculate Equity Value using the Market Value Balance Sheet (MVBS) technique

Compute non diluted and diluted share value

Sensitivity & Scenario Analysis

Modeling EPS Forecasting

Aim 5: Merger Acquisition

Building merger plan

Hostile Vs friendly offer

Evaluating a merger bid/offer

Understand Accretion / Dilution Analysis

Building a Merger consequences Model

Estimating Synergies

After-tax Adjustments from Write-ups

Pro forma Earnings & Pro forma EPS

Earnings impact

Computation of Goodwill created with an Acquisition

LBO Modeling

Structure of a Leveraged Buyout

Funding a LBO

Understanding a LBO Model

Aim 6: Project Financing Models

Understanding the Project Finance Model

Risk and contractual arrangement to reduce Risk

Understanding the Escrow Arrangement and fund arrangement

Learn about how Project Financing is different from traditional loan/debt financing

Various elements of a Project Financing Model for an infra project

Understand about risk management in Project Financing under BOT model

Aim 7: Advance Charting

Building Primary & Secondary Axis in a Chart

Radar Charts

Waterfall Charts

Football Field

Gantt Chart

Storytelling with advanced Financial Graphs & Charts

*Additional Aim 8: Using VBA in Excel

Using VBA in MS Excel

Using VAB with Macros

Debugging VBA Code

Breaking Circular references

Monte carlo method

UGC Approved	no
AIU MemberShip	no
Institute of national importance	no

Iplane education Reviews on Courses, Pricing, Features & Career Impact

Iplane educationAbout Iplane education

Student Forum

Useful Links

Know more about Iplane education

Know more about Programs

Iplane education
About Iplane education