Financial Modelling


Description

Financial Modeling (FM) is a fundamental skill for financial analysis that anybody who deals with business - be it an entrepreneur or an investment banker or Business Analyst - must acquire. At Foxmula we train a diverse category from B.Tech, BCom, MBA students and graduates to experienced professionals and even CFA® charter-holders.
In this Financial Modelling course, the candidates will learn to create flexible and effective financial models to evaluate and assess historical data, prepare future financial projections and provide crucial data like key financial ratios, integrated financial statements, outputs in a productive, logical and summarized manner.


  • Training | Skills

    Interactive professional training by industry experts

  • Certification | Recognition

    Course completion certificate from Foxmula to prove your skills.

  • Internship | Experience

    Live project with internship completion letter.

  • 100% Placement assistance


Available Modes

Live

INR 20,000 + GST
INR 25,000 + GST
21% discount price

What's included?

  • Live training by industry experts
  • Interactive doubt clearing
  • 80 hrs program with audio-video presentation on building models
  • Concise online study material
  • Get recorded session for future reference
  • Certificate of completion
  • Internship Completion letter

5000 INR now & pay rest next month

START NOW

JUST BY PAYING

INR 999*

  • Inclusive of all taxes
  • Remaining fees to be paid next month

Register

Self Paced

INR 15,000 + GST
INR 19,000 + GST
21% discount price

What's included?

  • 50+ hrs of self-paced content
  • Concise online study material
  • Online forum to discuss queries
  • Certificate of completion
  • Internship Completion letter

5000 INR now & pay rest next month

START NOW

JUST BY PAYING

INR 999*

  • Inclusive of all taxes
  • Remaining fees to be paid next month

Register

Curriculum

  • 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
  • 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
  • Why 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
  • Prepare Financial Statement
  • Analyze Revenue and Costs
  • Forecast Revenues, Costs, Debt etc.
  • Project Future Financial Statements
  • Perform Adjustments, Compute Margins/Ratios
  • Valuation- Discounted Cash Flow Method (DCF), Others
  • Prepare Presentation Sheet, Company Overview , Sector Overview
  • Report Writing: On the basis of Financial Modeling
  • Overview of different sectors such as retail, telecom, IT, Oil & Gas etc.