Financial Modeling with Excel- India

People regularly have to deal with situations in business where they have to make some decisions after analysing some data. In such cases, they often build a spreadsheet model of their problems. Financial Modeling using spreadsheets like MS Excel are used in many fields like financial analysis, risk analysis, valuations, investment management, credit analysis, scenario analysis, budgeting, sales forecast, financial projections, project evaluation, etc. Along with the use of Excel as a tool for modeling, basics skills in recording, writing and using Macros in Excel is also required.

This course is designed for professionals who are interested in learning financial modeling using MS Excel and basic VBA macro writing skills and their applications to finance and investing. The course starts with learning how to use advanced tools of Excel, then goes on to learn to model various kinds financial situations and ends with learning how to do Monte Carlo Simulations in Excel.

This course will be completed in 3 day. However, candidates can also opt for online learning for this course by visiting the official website of the provider. To apply online click here.

What the candidate will learn?

• How to design a model to suit your purpose
• Valuation modeling using conventional and new approaches
• Accurate forecasts, corporate cash flows for project finance deals and structures
• How to identify and control key sensitivities through advanced spreadsheet simulation
• How to build risk into candidate's model to enhance the decision making process
• How to design a model to maximize flexibility and reliability
• Practical tips for checking and debugging the model

Course Agenda:

• To benefit fully from the Financial Modeling course candidate needs to be familiar with various Excel tools and features that are frequently encountered in financial models. This optional workshop will prepare the way for the subsequent course by illustrating and giving participants many practical items, including those listed below.
• Accounting Boot Camp, Modeling Architecture, Sample Detailed Case, Time Line Modeling, Revenue & Capex, Depreciation, Financial Structure, Debt Schedule, Costs Drivers, Dividend & Tax, Integrating the Financials, Valuation, Ratio Analysis, Extra Excel Applications, Circularity Switch & Iteration, Simple Macros, Bond Valuation.

Registration & Pricing Details:

• Workshop fee: INR 15999
• Early bird fee: INR 13999

Early bird date:

• Delhi NCR: 21st March, 2014
• Chennai: 09th April,14
• Mumbai: 23rd April,14

Special concession: 10% off on Standard fee (only For Bangalore, Hyderabad & Pune)

Important dates:

Workshop starts on:

• Bangalore: 21-23 March, 2014
• Hyderabad: 21-23 March, 2014
• Pune: 21-23 March, 2014
• Delhi NCR: 4th-6th April, 2014
• Chennai:9th-11th April, 2014
• Mumbai: 23rd-25th May, 2014

Stay tuned with Oneindia Education on: Entrance Exams, Admissions, News, Value Read, Online Courses

More From Career India

‹ ›

UPSC CSE Mains 2025 Schedule Released: Exams from August 22 to 31

RRB NTPC UG Admit Card 2025 Released at rrb.digialm.com – Download Now

SEMICON India 2024: Which Indian States Are Set to Become the Hub of Semiconductor Manufacturing?

GSEB HSC Supplementary Result 2025 Declared for Science Stream at gseb.org

GATE 2026 Registration Starts Soon at gate2026.iitg.ac.in – Check Latest Date, Eligibility, Fees & Key Details

CBSE Class 10, 12 Compartment Result 2025 Likely in First Week of August

NEET PG 2025 Scorecard & Final Answer Key Released: Download at natboard.edu.in

IB Security Assistant Recruitment 2025 Announced for 4,987 Posts – Apply Soon at mha.gov.in

SSC to Share Marks of Non-Recommended Candidates with Other Recruiters: Policy Announced

APSC Recruitment 2025: Apply for 18 Junior Engineer Posts at apsc.gov.in

School Assembly News Headlines Today – February 12, 2026 | National, International, Educational & Sports

Independence Day 2025: India to Celebrate 79 Years of Freedom on August 15