About COURSE

Financial modeling self-learn course is a flexible course that helps you to prepare for the exam at your own pace. This course is designed for self-directed learning, allowing participants to begin classes at their convenience with structured training and review exercises to reinforce learning, followed by an end-of-course examination.

Financial Modeling - Self learn Training
20+ Hrs (Recommended 10 weeks) of pre-recorded classes
Project Finance
20+ Hrs (Recommended 10 weeks) of pre-recorded classes
Study Notes
Download the study notes to supplement video tutorials.
24x7 Online Access
Access to Course Material (Unlocked Excel Models).ns
Case Study
Hands-on Case Study (Real Life) based learning
Certificate of Excellence
EduPristine and BSE Institute Ltd brings Financial Modeling Joint certificate program (if opted for BSE exams has to pay additional Rs. 3000/-)

Financial Modeling

Online	FM Online	FM Online with Excel School	Project Finance Online	Project Finance with Excel School	FM and Project Finance	FM and Project Finance with Excel School
Price	12600	16800	12600	23100	18900	23100
Pre-Recorded Videos
Downloadable Financial Models
Week-Wise Model Templates
24x7 Access to Online Materials
Discussion Forum
	Buy	Buy	Buy	Buy	Buy	Buy

Course Structure

Day 1: Excel Tips >

Understanding And Creating A Financial Model Template
Learning referencing (usage of $)Frame work in Excel
Learning Custom formatting in Excel
Excel Skills - Shortcuts, Formulas, Array Function and Pivot Tables
Implementing simple business modeling case in Excel
Simple exercise/models in excel

Day 2, 3, 4& 5: Case Study FMCG >

Case Study FMCG
Data Collection and Data Structuring
Preliminary Scrutiny of the Data and Information
Understand the Business Model and Operating Model
Modeling the Historical Statement
Business Drivers Identification and Modeling
Modeling Assumptions for Future Action
Modeling Revenue Build-up - projecting the future revenues
Modeling Cost Build-up - projecting the future cost
Modeling the Asset Schedule
Modeling the Depreciation Schedule - Book and Income Tax Depreciation
Working Capital & Term Loan Modeling - Debt Infusion Tax Modeling
Modeling MAT and MAT credit
Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble
Equity Modeling - Equity Infusion
Modeling Paid Up Capital and Share Premium Account
Modeling Retained Earning Schedule
Modeling the projected P/L and BS
Modeling the projected Cash Flow Statement
Conducting Covenant Testing
Performing Ratio Analysis
WACC and Cost of Equity Analysis
Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
Performing sensitivity/scenario analysis

Day 6: Project Finance >

Introduction to Project Finance
Understanding the Project Finance Model
Characteristics of Project Finance
Risk and contractual arrangement to Mitigate Risk
Understanding the Escrow Arrangement
Incorporating Date, logical functions and flags to make the Model Flexible Incorporating Delays in the Model
Cash Flow Waterfall model - Modeling Payoffs to Investors using Goal Seek
Implementing Interest During Construction and Breaking Circular Loops

Day 7 & 8: M &A I & II >

Meaning and categories of M&A
Merger motivations
Forms of payment in a Merger Deal
Hostile Vs Friendly offer
Evaluating a Merger Bid
Merger Analysis - Key Drivers and Inputs
Accretion/Dilution Analysis
Merger Plan - Ownership Vs Deal Price
Modeling a financing plan
Performing sensitivity analysis on Acquirer's EPS
Performing Contribution Analysis
Estimating value of a Merger Transaction
Discounted Cashflow Analysis
Comparable Company Analysis
Comparable Transaction Analysis

Day 9 & 10: Accenture Case Study >

Accenture Case Study
Data Collection from Public Sources
Understanding the Business Profile of the Company
Modeling Revenue & Expenses Drivers
Modeling Income Statement
Modeling Implied EBITDA
Balance Sheet Projections
Cash Flow Statement Projection
Performing Valuation And Sensitivity Analysis
Calculating Enterprise value and Implied Market capitalization

Day 11: Macros I >

Macros I
Introduction to Macros & Advanced Application Building in Excel
Key Concepts in Macros
Macros as recorded Robots!
Form Controls and Active X controls
Implementing user forms in Excel Macros
Linking forms to excel cells
Building flexible Charts in Excel

Day 12: Macros II >

Macros II
Understanding VBA - Sub & Functions
Understanding the Relevant Language Constructs
IDC Implementation using Macros
Breaking Circular Loops using Macro
Monte Carlo Simulation
Basics of Debugging VBA Code

Day 13: Charting >

Charting
Building Primary & Secondary Axis in a Chart
Radar Charts - Showing the progress of Commercial Property Development
Waterfall Charts - Showing Funding Breakup for Renewable Energy project
Football Field - Showing Valuation Summary using Different Parameters
Gantt Chart - Tracking the status of an Ongoing Project

Day 14: Advance Function >

Advance Function
Named Ranges
Index Match
Array Functions
Building Scenarios using Offset Functions
Creating growing models & Index functions
Usage of Indirect Functions
Usage of Goal Seek and Solver Functions

Week 1 - Introduction & Excel Formulas >

Lesson 0 - An Overview of Excel [46min.]
Relative & Absolute Cell References in Formulas [6min.]
Using IF Formula, Nesting IF Formulas [30min.]
COUNTIF, SUMIF Formulas [7min.]
Excel Text Formulas [22min.]
VLOOKUP formula, INDEX, MATCH Formulas [12min.]
OFFSET Formula [22min.]
SUMPRODUCT Formula [22min.]
SUMIFS Formula, COUNTIFS Formula [12min.]

Week 2 - Advanced Formulas >

Advanced VLOOKUP Tricks [23min.]
How to Get Unique Values from a List using Formulas [6min.]
SMALL, LARGE Formulas [13min.]
ROWS, COLUMNS Formulas [10min.]
Formula Editing Tips And Tricks [19min.]
Formula Debugging Using F9 Key [4min.]

Week 3 - Formatting & Conditional Formatting >

Formatting Paste Special [63min.]
Conditional Formatting - 1 [15min.]

Week 4 - Advanced Conditional Formatting >

Conditional Formatting - 2 [24min.]
Conditional Formatting - 3 [28min.]

Week 5 - Excel Charting - Basics >

How to Select Correct Chart [37min.]
Introduction to Excel Charts [50min.]
Chart Formatting - 10 Tips [64min.]
Bar & Column Chart Formatting [18min.]
Conditional Formatting - 3 [28min.]

Week 6 - Data Analysis using Excel - Tables, Pivot Tables >

Excel Tables [59min.]
Excel Pivot Tables [93min.]
Pivot Table Tricks [43min.]

Week 7 - Advanced Data Analysis - Validation, Filters & More >

Data Filters & Sorting [55min.]
Data Validation [39min.]

Week 8 - Advanced Excel Charting >

7 Advanced Charting Tutorials in Excel [61min.]
Dynamic Charts in Excel [34min.]

Week 9 - Interactive & Dynamic Charts in Excel >

Interactive Charts In Excel [37min.]
Create On Demand Charts in Excel using VBA & Magic [Bonus Lesson] [45min.]

Week 10 - Excel School Class Project >

Excel School Class Project

Week 11 - Working with External Data in Excel >

Importing External Data [72min.]
Export Excel to Other Formats [20min.]
Excel Access Integration [40min.]

Week 12 - More Advanced Formulas >

Advanced Formulas [77min.]

Week 13 - Introduction to Excel Macros etc. >

Introduction To Macros [75min.]
Working With Complex Worksheets [50min.]

Misc. >

Excel School Webinar Recording [50min.]
Excel 2010 - A Short Introduction [20min.]

Important Material for Project Finance Financial Modeling >

Integrated Valuation Model
Complete Material in Presentation
The Case Study for Project Finance
Making Stunning Charts with Excel
Glossary of Financial Terms

Week 1 >

Introduction To P&L
P&L Model In Excel
Introduction To Balance Sheet
Introduction To Cash Flow Statement
Integrating Financial Statements Business Case
Creating A Layout For Integrated Model
All Excel Templates for Week 1
Download Week 1 Newsletter

Week 2 >

Excel Shortcuts
Referencing Framework In Excel
Custom Formatting In Excel
Business Modeling Basic Case
Emi Basic Case
The Case Study for Project Finance
Introduction to Integrated Financial Model for Project Finance Sector
Glossary of Financial Terms
All Excel Templates for Week 2
Download Week 2 Newsletter
Lecture Notes for Week 2

Week 3 >

Introducing Project Finance
Project Finance Characteristics
Understanding Date Function
PF Model - Updating Layout
PF Model - Building Area
PF Model - EPC Phasing
PF Model - EPC Costing
Additional Material (Complete Slide Pack with all material released)
Complete Slide Pack with All Material (Right Click and Download)
All recordings for Week 3
All Excel Templates for Week 3
Download Week 3 Newsletter
Lecture Notes for Week 3

Week 4 >

This week's Lessons are related to understanding Circular References in Excel and its application in Financial Modeling Lessons:
PF Model - Building Project Cost
Understanding Interest During Construction (IDC)
Understanding Circular References in Excel
A Short Case on Using Circular References to Update Interest Expense
Implementing IDC
Break Even Analysis
All recordings for Week 4

Week 5 >

Project Finance Model - Building Capex Schedule - I
Project Finance Model - Building Capex Schedule - II
Project Finance Model - Building Financing Schedule

Week 6 >

Live Webinar Recording
Excel - Understanding sumif and index-match functions
Project Finance Model - Building Yearly Schedules
Credit Risk Model - I (Understanding Array functions in Excel)
Download Week 6 Newsletter

Week 7 >

Sessions Related to Project Finance Model
Additional Material related to depreciation and deferred taxes
Download All recordings for Week 7
Download Week 7 Newsletter
Lecture Notes for Week 7

Week 8 >

Sessions Related to Project Finance Model
Additional Material related to Real Life IPO (Optional)
Download All recordings for Week 8
All recordings for Week 8
Week 8 - Extended (Bonus Material)
Download All recordings for Week 8 (Extended)
Download All Excel Templates for Week 8

Week 9 >

Sessions Related to Project Finance Model
Additional Material related to Building Cashflow Waterfall Model
Download All recordings for Week 9
Download All Excel Templates for Week 9
News Letter
Lecture Notes for Week 9

Week 10 >

Free Cash Flows (to the Firm and Equity) - FCFF, FCFE
Calculating FCFF and FCFE
Understanding Cost of Equity - CAPM
Understanding Cost of Capital - WACC
Understanding terminal value
Project Finance Model - Way forward
Project Finance Model - Valuation
Using Excel Data Tables for Scenarios
All recordings for Week 10

Week 11 >

PF Model – Scenario Analysis Using Data Tables
PF Model – Scenario Analysis for Civil Cost
PF Model – Advanced Scenario Analysis Using Macros
PF Model – Monte Carlo Simulation
PF Model – Monte Carlo Simulation - II

ENROLL NOW

Download Brochure

You Win Because of Your Team

Level up Your Team

With Corporate Training

About COURSE

EduPristine Financial Modeling classroom training program is designed for candidates planning to make a promising career in the finance industry. Learn Financial Modeling with us in the classroom environment with hands on experience. The first module is Equity Evaluations and the second module teaches advanced Excel. So you can make a model firstly, and then understand how to use that model for various purposes like projections, evaluations etc.

Financial modeling is the art of building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions by analyzing various parameters. At the end of the course, you will be able to do the task of building a model depicting financial statements/business model, which helps in decision making.

Extensive Classroom Training
14 days (70 hours) classroom training by topic experts with interactive learning.
Excel Workbooks
Create models following a step-by-step approach devised by professionals. These workbooks have been specially designed to ensure you incorporate best industry practices of financial modeling.
Live Webinar
Get Recordings for all the topics.
Pre-Recorded Videos
Access to Exclusive Videos with over 20+ hours of Recordings to help understanding aspcepts of Financial modeling (Available Online Only).
Comprehensive study notes
Topic wise study material is provided in the form of presentations
Objective Quizzes
Module wise quiz to check the conceptual knowledge of students after each module (Online).
Certification
1. Certificate of Participation from EduPristine 2. Certificate of Excellence from BSE Institute Ltd. (if test cleared)
Doubt Solving By Experts
Write to us and get your doubts solved by our experts within 2 business days. You can also initiate a discussion by posting it on active forums.
Assignments
Module wise assignments to test practical skills of students (Online).

Course Structure

Financial Modeling

Day 1: Excel Tips >

Understanding And Creating A Financial Model Template
- Case: Formatting the data, summarizing and creating a presentable format
Formatting the imported file with text to columns
Getting the relevant information from string of data using Left, Trim
Using referencing frame work (usage of $) to effectively use formulas
Converting text to numerical using text to columns
Summarize the sum of sales with Pivot Tables
- Grouping the data quarter/ month wise
- Converting sales number units to make it presentable
- Adding slicer to dig into number instantly
Converting data into tabular format
Identify high profit sales using conditional formatting

Day 2, 3, 4 & 5: Case Study FMCG >

Data Collection and Data Structuring
Preliminary Scrutiny of the Data and Information
Understand the Business Model and Operating Model
Modeling the Historical Statement
Business Drivers Identification and Modeling
Modeling Assumptions for Future Action
Modeling Revenue Build-up - projecting the future revenues
Modeling Cost Build-up - projecting the future cost
Modeling the Asset Schedule
Modeling the Depreciation Schedule - Book and Income Tax Depreciation
Working Capital & Term Loan Modeling - Debt Infusion Tax Modeling
Tax Modeling, MAT and MAT credit
Modeling Impact of Accumulated Losses, Current Tax and Deferred Tax on Tax Payble
Equity Modeling - Equity Infusion
Modeling Paid Up Capital and Share Premium Account
Modeling Retained Earning Schedule
Modeling the Financial statements, Ratio analysis
WACC and Cost of Equity Analysis
Performing Valuation using DCF (FCFF & Enterprise Value) and Comparable analysis (Relative Valuation)
Performing sensitivity/scenario analysis
Comparing the valuation Summary using Different Parameters on football field
Objective test: 10 questions covering basics of financial statement and modelling concepts.
Excel Assignments:
- Assignment 1: Calculating Time value of Money on 5 year fixed deposit
- Assignment 2: Calculating 10 years CAGR of annual sales of a manufacturing company
- Assignment 3: Applying DCF to value LinkedIn using CFs, P&Ls and BS

Day 6 & 7: M &A I & II >

Meaning and categories of M&A
Merger motivations, Forms of payment in a Merger Deal
Hostile Vs Friendly offer, Evaluating a Merger Bid
Case: Estimating fair acquisition price of the target company in M & A
Discounted Cash Flows
- Identifying assumptions for estimating future cash flows
- Making pro-forma financial estimates
- Calculating FCFF, discount and terminal rate and NPV
Comparables Companies
- Finding out comparable companies and defining comparitive value metric
- Estimating takeover premium and calculating takeover price
Comparable Transactions
- Finding out comparable companies and defining comparitive value metric
- Calculating Valuation of the company
Case: LinkedIn acquisition by Microsoft
Why LinkedIn and Microsoft
Finding out Rationale for the transaction
Searching and researching relevant reports
- Understading and Usage of 10K and 10Q
- LinkedIn's Schedule 14A, LinkedIn's 10Q, Microsoft's fund raise
Collecting and projecting numbers
- Merger Analysis - Key Drivers and Inputs
- Projecting Microsoft and LinkedIn numbers
- Findout the impact of deal announcement on share price
Creating high level merger accounting for goodwill - Pooling method
Accretion/Dilution Analysis and modeling a financing plan
Performing sensitivity analysis on Acquirer's EPS, contribution analysis
Objective test:10 questions covering Merger and acquisition fundamentals.
Excel Assignments:
- Assignment 1: Performing sensitivity analysis on the provided factors
- Assignemnt 2: Performing comparable analysis by calculating ratios

Day 8, 9, 10, 11 and 12: Macros, Charting, and Project Finance >

Macros
- Accessing VB editor, Developer tab
  - Creating and deleting modules
- Changing security to "Disable all macros with notification"
- Recording your first macro - Copy pasting values
- Formatting chart with macros
- Creating flexible CAPM model using Form Controls and Active X controls
- Writing your first macro - Adding a new worksheet and populating content
- Debugging and stepping into the VBA Code of your first macro
- Correcting circular reference in IDC using VBA/ macros
VBA Assignments:
- Assignment 1: Breaking circular loops using macros from the cash flow model
- Assignment 2: Creating a macro to find out which company(s) (out of 20) are eligible for funding
Project Finance
Case: Creating a Project model for development of toll road under build, own, operate and transfer model
- Creating flexible activity timeline chart - Gantt chart
  - Using AND function to identify the timelines
  - Using Webdings to create special characters
  - Conditional formatting to highlight the timeline
- Establishing Design parameter
  - Calculating monthly traffic handling capacity
- Forecasting toll charges and monthly traffic
  - Creating monthly timeline using date function(s)
  - Calculating toll rate using min/ max functions
  - Estimating traffic under 3 different scenarios: Pessimistic, Most likely and Optimistic
  - Adding two more scenarios: Custom and Simulated
- Auditing the Project details
  - Converting all hardcoded numbers to a different color in one go
- Using Macros (Form controls) to create flexible scenarios
  - Creating flexibility for 5 different scenarios
  - Using OFFSET function to get the output against selected scenario
- Creating flexible Project momentum
  - Using Date functions to create montly, quarterly (CEILING) and yearly timelines
  - Importing data of relevant scenario using TRANSPOSE function
  - Importing traffic and toll charges using HLOOKUP
  - Cleaning the output using IFERROR
  - Creating a name manager to use a factor frequently
  - Projecting Power and Insurance expenses
  - Modeling CAPEX, Government grant, Exit Value
- Calculating NPV, IRR and Payback period
  - Creating flexibile model to calculate cost of equity (CAPM) using Form controls
  - Calculating XNPV, XIRR, payback period using COUNTIF
- Creating Yearly statements
  - Coverting monthly statements to yearly statements using SUMIF
  - Calculating NPV and IRR, Discuss problems with NPV and IRR functions
- Linking output with Project chart using hyperlinks
- Performing Sensitivity analysis of 9 variables on 3 outputs
  - Using Scenario manager to perform sensitivity analysis
  - Facing and correcting issues with Scenario Manager
- Creating bar diagram of annual traffic chart
- Drawing Project financial Dashboard
  - Creating chart using primary and secondary axis
  - Creating flexible chart for toll revenues, operating expenses, profits and profit margin - Macros
  - Creating waterfall chart for build-up of Traffic
  - Creating cash flow chart - combination of bar and line chart
- Creating custom scenario to mix-match scenarios during construction, after construction and/ or revenues - Macros
  - Inserting a userform to get the input for simulation
  - Inserting the combo box, text box, spin button, Ok/ cancel button, message box
  - Generating random numbers to tackle growth
  - Creating Monte Carlo Simulation for traffic/ growth
  - Creating status bar with REPT function
  - Calculating frequency using FREQUENCY function
Objective test: 10 questions covering Project finance fundamentals, Debt, revenue, equity & Deferred taxes.
Excel assignments:
- Assignment 1: Calculating IDC value of ongoing construction of a mall
- Assignment 2: Calculating operating income from given revenue and costs of a retail project
- Assignment 3: Calculating discounted cash flows from given cash inflows of a real estate project

Day 13 & 14: Accenture Case Study >

Data Collection from Public Sources
Understanding the Business Profile of the Company
Modeling Revenue, Expenses Drivers and Income statement
Modeling Implied EBITDA and Balance sheet projections
Cash Flow Statement Projection,Valuation and sensitivity analysis
Calculating Enterprise value and Implied Market capitalization
Objective test:10 questions covering Income statement, Balance sheet, Cash flow statement
Excel assignments:
- Assignment 1: To match net worth from given Assets and liabilities data
- Assignment 2: Calculating Implied EBIDTA from given P&L and other relevent information
- Assignemnt 3: Preparing Cash flow statement from given P&L and Balance sheet of LinkedIn

ENROLL NOW

Download Brochure

You Win Because of Your Team

Level up Your Team

With Corporate Training

About COURSE

Live Online Financial modeling course classes are being conducted using professional grade IT conferencing system from Citrix. The students can interact with the faculty in real-time during the class using chat and voice. The students will be required to install a light-weight IT application on their device which could be a laptop, desktop, tablet or a mobile. Citrix supports Windows, iOS operating system and recommends an internet speed of 1 MBPS at the user's end.

Live Webinar Training
8 days of Live Virtual Training by Experienced Professionals
Software Requirement to access Live webinar Sessions
1) LMS Login Access Provided from EduPristine after the enrollment can access the Live Webinar Sessions2) Internet Connection
Recordings
Full Recordings of all online classes in downloadable format (60 hrs).
Online Learning
Access to online materials in the form of presentation covers each topic
Objective Quizzes
Module wise quiz to check the conceptual knowledge of students after each module (Online).
Comprehensive study notes
You can browse through these notes while viewing the videos as per your convenience
Certification
1. Certificate of Participation from EduPristine 2. Certificate of Excellence from BSE Institute Ltd. (if test cleared)
Assignments
Module wise assignments to test practical skills of students (Online).
24x7 Online Access
24x7 Online Access* to Course Material (Unlocked Excel Models, Presentations, etc)
Case Study
Hands-on Case Study (Real Life) based learning

Course Structure

Financial Modeling

Day 1: Financial Modeling Principle I >

Excel as a Tool for Financial Modeling
Referencing & Excel Shortcuts for Financial Modeling
Building Layout for Scalable Financial Model
Building Growth Drivers for Revenue

Day 2: Financial Modeling Principles II >

Building Growth Drivers for Cost
Building Asset and Debt Schedule
Projecting P&L and Balance Sheet

Day 3: Valuation Principles I >

Projecting Cash Flow Statement
Circular References in Cash and Interest
Analyzing Financial Statements with Ratios
Corporate Finance Concepts for Financial Modeling

Day 4: Valuation Principles II >

Key Valuation Concepts
Valuation Using DCF and Comps
Scenario Analysis and Building Dashboards

Day 5: Advanced Functions and Tools >

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

Day 6: Charting Technique >

Mastering Financial Functions – Lease Analysis for Facebook
Advanced Charting Techniques in Excel – Creating Football Field
Creating Dashboard for Financial Data

Day 7: Macros and VBAs >

Understanding Macros
Creating Flexible Dashboards & Charts Using Form Controls
Introduction to VBA for Financial Modeling
Recording Macros to Break Circular References

Day 8: Monte Carlo Simulation >

Implementing Monte Carlo Simulation for Revenue Analysis – I
Implementing Monte Carlo Simulation for Revenue Analysis – II
Summarization and Concluding Session

ENROLL NOW

Download Brochure

You Win Because of Your Team

Level up Your Team

With Corporate Training

It provide great financial exposure to young graduated who are interested in making their career in finance. Highly qualified teachers and very supportive staff. The backup material was really organized and could be used as a future reference for building business plans from A to Z.

Jaikishan Thadani Sr. Financial Analyst at JPMorgan

I must appreciate the whole team of edupristine to launch such a good course on Financial Modelling, as this is the need of the day where more and more complex business scenarios needs to be modelled in MS excel for better decision making.

Dhaval Khandelwal Asst. Manager at GSPL India

Financial Modeling Course

Need more info?

DID YOU KNOW?

Russel Reynolds Study 2017

About COURSE

Financial Modeling - Self learn Training

Project Finance

Study Notes

24x7 Online Access

Case Study

Certificate of Excellence

Financial Modeling

Course Structure

Day 1: Excel Tips >

Day 2, 3, 4& 5: Case Study FMCG >

Day 6: Project Finance >

Day 7 & 8: M &A I & II >

Day 9 & 10: Accenture Case Study >

Day 11: Macros I >

Day 12: Macros II >

Day 13: Charting >

Day 14: Advance Function >

Week 1 - Introduction & Excel Formulas >

Week 2 - Advanced Formulas >

Week 3 - Formatting & Conditional Formatting >

Week 4 - Advanced Conditional Formatting >

Week 5 - Excel Charting - Basics >

Week 6 - Data Analysis using Excel - Tables, Pivot Tables >

Week 7 - Advanced Data Analysis - Validation, Filters & More >

Week 8 - Advanced Excel Charting >

Week 9 - Interactive & Dynamic Charts in Excel >

Week 10 - Excel School Class Project >

Week 11 - Working with External Data in Excel >

Week 12 - More Advanced Formulas >

Week 13 - Introduction to Excel Macros etc. >

Misc. >

Important Material for Project Finance Financial Modeling >

Week 1 >

Week 2 >

Week 3 >

Week 4 >

Week 5 >

Week 6 >

Week 7 >

Week 8 >

Week 9 >

Week 10 >

Week 11 >

About COURSE

Extensive Classroom Training

Excel Workbooks

Live Webinar

Pre-Recorded Videos

Comprehensive study notes

Objective Quizzes

Certification

Doubt Solving By Experts

Assignments

Course Structure

Day 1: Excel Tips >

Day 2, 3, 4 & 5: Case Study FMCG >

Day 6 & 7: M &A I & II >

Day 8, 9, 10, 11 and 12: Macros, Charting, and Project Finance >

Day 13 & 14: Accenture Case Study >

About COURSE

Live Webinar Training

Software Requirement to access Live webinar Sessions

Recordings

Online Learning

Objective Quizzes

Comprehensive study notes

Certification

Assignments

24x7 Online Access

Case Study

Course Structure

Day 1: Financial Modeling Principle I >

Day 2: Financial Modeling Principles II >

Day 3: Valuation Principles I >

Day 4: Valuation Principles II >