Applied Valuation and Financial Modeling

Horizontal Tabs

INTRODUCTION

VCCircle Trainings upcoming 2Days workshop on Applied Valuation and Financial Modelling is designed to provide the attendees with an advanced understanding of valuation and financial modelling and to equip them with skills to create a comprehensive financial model and valuation analysis. This instructor-led training will highlight the various tools in Microsoft Excel to create a robust financial spreadsheet of a business entity to address the corporate investment opportunity and risk in the current challenging business world.

Learning Outcomes of the Training

• Financial Cash Flow Modelling: The delegate will be able to build the valuation financial models (Integration of Financial statements, DCF and LBO) from scratch in Excel.
• Business Valuation: The delegate will be able to value businesses by extrinsic and intrinsic methods like investment banking practitioners.

Who Should Attend It?

This training is beneficial to the delegates from the following roles or who wish to build their career in the following industry

• Investment Banking professionals                        • Asset Management professionals
• Entrepreneurs                                                  • Corporate Finance and Strategy professionals
• Private Equity professionals                                • Private Wealth Management professionals
• Equity Research professionals                             • Business and Finance professionals

Benefits of attending - Application of Learnt Skills in the Following Areas

• Mergers and acquisitions                                    • Transaction advisory
• Sales and trading                                              • Financial analysis
• Investment banking                                           • Equity research
• Finance and business entrepreneurship                  • Hedge funds
• Corporate finance                                              • Private equity & venture capital
• Valuation consulting                                           • Corporate banking

AGENDA

Day 1 August 30^th, 2012

Session 1: Presentation and Discussion on Intrinsic/extrinsic Valuation, Leveraged buyout to Investment Banking/Private Equity Transaction

Trading comps Valuation – Extrinsic Valuation
1. Picking the right comparables
2. Normalizing non-recurring items
3. Determining Equity and Enterprise value of the target

DCF Valuation – Intrinsic Valuation
1. Forecast 5 Years Profit and Loss statement
2. Forecast Capex, Assets and Net working capital
3. Estimating and Pricing the Cost of Equity & Debt of public and private companies
4. Calculation of terminal value by Exit multiples and Perpetuity growth methods
5. Unleveraged Beta of private companies

Leveraged Buyout (LBO) analysis
1. Characteristics of the transactions
2. Valuing the business
3. Financing the transaction
4. Measurement of the investment from the eyes of the investor
5. Exit strategies

Session 2: Building step by step financial model from SCRATCH for Investment banking and Private equity transactions

Overview of best investment banking practices for financial Modeling and setting up the model
1. Setting up the model for historic and 5 years projections
2. Industry accepted assumptions and their logic for sales growth, COGS, EBITDA
3. Analysis of historic numbers
4. Various Margins forecast
5. Forecasting Net Working Capital

Day 2 August 31^st, 2012

Session 3: Building step by step financial model from SCRATCH for Investment banking and Private equity transactions (Contd.)

Forecasting Capital expenditure
Forecasting tangible and intangible assets
Calculation of Depreciation and Amortization expense
Establishing Debt and shareholders’ Equity schedules
Integration of Income & Cashflow statements and Balance sheet

Session 4: Building step by step financial model from SCRATCH for Investment banking and Private equity transactions (Contd.)

Valuation of the company by using DCF method
Comparing your per share price valuation with real-time market price to recommend Buy/Hold/Sell the share
Sensitivity and graphical representation of the relevant information
Sensitivity analysis of WACC, Enterprise value and Sales
Industry practices on handling exceptions
Leveraged buyout Investment return analysis (Cash returns & IRR)
Modeling of all stakeholders (Financial sponsor, Lenders and Seller) in LBO

EXPERTS

Dr. Vishwajeet Rana

Professional Trainer - Global Bankng Training, London & Chairman, Sanrock Capital LLP

Dr. Rana is a seasoned investment banker with US $5-billion+ investment banking transaction experience. He has executed a number of complex cross-border equity/debt structured investments and financing transactions in the UK, Canada, Australia, South Africa and Hong Kong jurisdictions while working at HSBC New York office. He started his Investment banking career with UBS Investment Banking in New York in Investment portfolio management. He likes public speaking, playing golf, squash and mentoring ambitious minds in his free time.

He has hands on experience:

• Raised Equity and Debt for 40MW Bio Energy (Bagasse) cogeneration plant.
• US$100m equity and debt investment in Mid-west wind farm project in USA.
• US$70m equity Investment in west coast based photovoltaic solar project in USA.
• Issuance of US$1.5bn Bond in Hong Kong for Canadian client, sale of the coupons to Hong Kong based Investors, private placement of the Principal in Germany.
• CAD$700m investment in leading Australian Bank via two tier partnership structure.
• Financial structuring of £1bn note out of premium of dual resident subsidiary in the UK.
• Financial structuring of limited partnership interest of CAD$1bn with leading Canadian Bank.

Gajesh Jain

Corporate Finance, Yes Bank

Gajesh Jain is a Chartered Accountant (ICAI). He is also an MBA from IE Business School, Spain (Consistently Ranked among Top 10 MBA Institutes globally) and a Bachelor of Commerce (B.Com.) from R.A. Podar College of Commerce and Economics, Mumbai.

He has a vide international as well as domestic experience in Auditing & Assurance, GAAP Conversions, Corporate Finance, M&A Advisory, Business Consulting and Due Diligence across diverse sectors including Insurance, Information Technology, Real Estate, Renewable Energy, Hospitality, Textile, Healthcare, Education, Automobile, manufacturing and pharmaceuticals.

Presently, he is working with India 4^th largest private sector Bank – YES Bank in its Corporate Finance Division which takes care of Real Estate, Hospitality, Healthcare and Education sectors for 2 years. Previously he had also worked for BDO International, India (World’s 5^th largest financial advisory firm) for 3 years in Financial Advisory and Assurance divisions. He is also a partner in M/s S.Jain Bohra & Co., Chartered Accountants, a 17 year old firm based out of Mumbai, India. He has also worked with on an assignment with Delphi Diesel Systems, a Hived off subsidiary of General Motors (GM) in Barcelona, Spain in its Financial Control Division for financial restructuring, cost management, and modelling. Further, he has also edited several case studies on Cost Management and Cost controls at IE Business School.

VENUE

Bandra Kurla Complex - Trade Centre

G/F & 1/F, Trade Centre,

Bandra Kurla Complex,

Bandra (E), Mumbai

PARTNERS

LEX Witness

Official Magazine Partner

LEX WITNESS – India’s 1st Magazine on Legal & Corporate Affairs

LEX WITNESS vows to be a high quality monthly magazine with the powers of fresh and original content that would deal exclusively with subjects pertaining to legality. Country's top notch practitioners and experts are being invited to contribute in WITNESS with what we feel is relevant to all stakeholders in this profession, aiming at brainstorming between the legal luminaries and hence bettering this practice in all its aspects.

For more info visit: www.witnesslive.in

CAclub India

Online Media Partner

With the strength of more than 8.5 Lac members, CAclubindia turns out to be the largest Interactive platform for Finance professionals in the country.

Knowledge is power and it increases manifold if it is shared and distributed. CAclubindia with its potent reach seeks to create such an intellectual and powerful community. It gives an opportunity to the Finance professional to get in touch with the who's who of the finance world and also to achieve professional excellence through interaction and sharing of new ideas and opinions.

Other portals include LAWyersclubindia.com and MBAclubindia.com for Legal and Management professionals.

url: http://www.CAclubindia.com - Interactive platform for Finance Professionals

Print Media Partner

Registration Closed

Search form

Horizontal Tabs