Financial Modeling Course - APG Learning
nav-closed

Register for interview

financial modeling course

Write to us for more information

Financial Modeling Course

Financial Modeling is one of the most fundamental and widely sought after skills in the finance industry. It helps in building a model to depict financial statements and investment analysis using MS Excel. This helps arrive at optimal business solutions…

  • Please Login..review_star
  • student_enrolled Student's Enrolled
  • best_selling Best Selling
Write to us for more information

Course Detail

Format:

Full Time

Duration:

1 Year

Accreditation:

TISS SVE

Course Provider:

APG Learning

Start Date:

01 August 2019

Fees:

₹1,75,000/-

Duration

2.5 Months

Modules

5

Hours

Start Date

22 Jul 2019

Course Provider:

APG Learning

25,000.00 30,000.00

Address:Sakal Nagar,

Gate No. 1, Baner Road,

Aundh, Pune 411 007

Training 5 or more people?

Get your team access to APG Learning top 200+ courses anytime, anywhere.

Try APG Learning for Business

About Course

Financial Modeling is one of the most fundamental and widely sought after skills in the finance industry. It helps in 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.

Modules

Introduction to Financial Statement Analysis

• Financial Reporting Mechanics,
• Understanding Income Statement, Balance Sheet, Cash Flow Statement
• Financial Analysis Techniques
• Inventories, Long-Lived Assets
• Non-Current Liabilities
• Financial Statement Application
• Ratio analysis of industries
• Du point Analysis
• Peer to peer analysis
• Preparation of Financial Analysis report on an industry

 

Time value of money

• Long term financing
• Cost of capital
• Measure Of Leverage

Project evaluations

• Stages of project
• Construction & development phase
• Funding during investment phase
• Costs during investment phase
• Life of project; decision making
• Cash flow waterfall
• Resolving circular reference

 

  • Financial Statement
  • Analyze Revenue and Costs
  • Forecast Revenues, Costs, Debt etc.
  • Project Future Financial Statements
  • Performa Adjustments, Compute Margins/Ratios
  • Valuation- Discounted Cash Flow Method (DCF), Others
  • Prepare Presentation Sheet, Company Overview , Sector Overview

 

Formatting of Excel Sheets

• Advanced Modeling Techniques
• Data Filter and Sort
• Charts and Graphs
• Table formula and Scenario building
• Lookups: Vlookup
• pivot tables
• Use of Excel Formula Function

 

Application of macros to Financial modeling, Circular reference problem, Sensitivity table, Scenario analysis and Simulation.

USP

  • Hands on training
  • Placement assistance.
  • Industry expert

 

 

 

Who Should Attend

This program is suitable for students and professionals related to Investment, Equity Research, Credit, Project, Mergers & Acquisition, Corporate Finance, Critical Thinking and analytical skills. It is also ideal for CA, CFA Program candidates, FRM, MBA Finance, B TECH and Commerce Graduates who want a career in any of the above profiles. Financial Modeling is also a suitable choice for those in non finance related careers such as in the preparation of Business Plan, working on Excel, decision making and mapping theory to practical.

Fee Structure

Duration

2.5 Months

Fees- Rs 25,000 + taxes

SIMILAR COURSES

nav-closed

Download Brochure