Introduction

Financial modeling is one of the most highly valued, but thinly understood, skills in financial analysis.

Creating a summary of the expenses and revenues incurred in the functioning of a business enterprise, Financial Modeling as a process aims to assess the company’s present financial expenses and profits to predict the impact of any future event and thus helps in facilitating better finance-related decisions.

With a good understanding of the key steps involved in financial modeling, participants will be able to build a well-structured and robust model and use it to solve important business problems. Participants will able to appreciate the use of the financial model as a powerful tool to communicate complex financial analyses and simulation results to stakeholders.

This workshop will cover the basic financial modeling principles, best practices in financial modelling and excel functions frequently used in models. Participants will also learn how to use model auditing tools to check for model errors. Learning is achieved via practical examples and which reinforce the theory; case studies and Excel-based exercises which allows participants to have hands-on experience with financial models.

Key Takeaways

  • Learn about the structure of a financial model
  • Financial Modelling Best Practices: Advanced excel tips, tricks & Modelling Tools
  • To get equipped with skills to create your quantitative financial models
  • To learn effective ways of working on spreadsheets and predicting data
  • To strengthen your decision-making abilities
  • Managing assumptions during Financial modelling
  • Explore the best tools for modeling scenario and sensitivity in Excel
  • Understand how to reduce the risk of modelling errors

Target Audience

  • Equity research professionals
  • Corporate Financial Officers
  • GM/VP/AVP/Manager M & A
  • CFOs, Treasurers and Senior Finance Executives
  • Executives of M&A Team
  • Directors of Strategic Planning
  • Commercial Bankers
  • Portfolio Managers -Corporate Restructuring
  • Fund Managers
  • Investment Bankers
  • Credit analysts at banks and other financial institutions
  • Business strategists at corporations
  • Compliance officers

Agenda

8:55 AM onwards
  • 8:55 AM – 9:00 AM

    Welcome Address

  • 9:00 AM – 10:00 AM

    Financial Modeling for Business

    • Financial modeling basics
    • Need and used of Financial Modeling
    • Explore the valuation process in financial models.
    • Financial Model development life cycle
    • Financial Modelling Best Practices: Advanced excel tips, tricks & Modelling Tools
    • Key differentiations – various industries

    Trainer: Vibhor Nayar, Vice President, Duff & Phelps

  • 10:00 AM – 11:00 AM

    Structuring Financial Models

    • Understanding objectives, timelines, purpose and level of detail
    • Relevance and Use of Historical Analysis
    • Key Assumptions and Control Variables
    • Use of estimates, surrogates and benchmarks
    • Essentials for developing sound Financial Models

    Trainer: Nilesh Lonare, Associate Director, Growth, Grant Thornton

  • 11:00 AM – 12:00 PM

    Managing Assumptions During Financial Modeling

    • Tax and other statutory Assumptions
    • Arithmetic accuracy
    • How to Ensure Accuracy on Financial Statements
    • Place adequate checks and balances

    Trainer: Kunal Shah, Partner, Price Waterhouse & Co LLP.

  • 12:00 PM – 1:00 PM

    Sensitivities, Scenario and switches

    • Building Scenario Analysis for Financial Models
    • Scenario Analysis vs. Sensitivity Analysis
    • What are the best tools for modelling scenario and sensitivity in Excel?
    • How to create switches in excel for building scenarios?
  • 1:00 PM – 2:00 PM

    Dashboarding

    • Dashboard Design Principles
    • Dashboard Function Toolbox
    • Basic & Advanced Dashboard components
    • Financial Dashboard Examples
  • 2:00 PM – Onwards

    End of Training


Experts

Image

Kunal Shah

Partner, Price Waterhouse & Co LLP.
Image

Nilesh Lonare

Associate Director, Growth, Grant Thornton
Image

Vibhor Nayar

Vice President, Duff & Phelps

Want to be part of it?

VCC Events opens up the avenues for participation. Join hands to be a part of India’s largest gathering of alternative investments leaders, industry stakeholders and Asia’s influential limited partners, general partners and marquee advisors. Your chance to actively participate and augment yourself as thought leaders.


Do you have any queries?

Drop us a line and we will call you.

I confirm that Mosaic Digital can share my information for commercial purposes with partners/sponsors and I can be contacted for business purposes.