Overview
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 30th, 2012
Session 1: Presentation and Discussion on Intrinsic/extrinsic Valuation, Leveraged buyout to Investment Banking/Private Equity Transaction
-
Trading comps Valuation – Extrinsic Valuation
-
Picking the right comparables
-
Normalizing non-recurring items
-
Determining Equity and Enterprise value of the target
-
-
DCF Valuation – Intrinsic Valuation
-
Forecast 5 Years Profit and Loss statement
-
Forecast Capex, Assets and Net working capital
-
Estimating and Pricing the Cost of Equity & Debt of public and private companies
-
Calculation of terminal value by Exit multiples and Perpetuity growth methods
-
Unleveraged Beta of private companies
-
-
Leveraged Buyout (LBO) analysis
-
Characteristics of the transactions
-
Valuing the business
-
Financing the transaction
-
Measurement of the investment from the eyes of the investor
-
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
-
Setting up the model for historic and 5 years projections
-
Industry accepted assumptions and their logic for sales growth, COGS, EBITDA
-
Analysis of historic numbers
-
Various Margins forecast
-
Forecasting Net Working Capital
-
Day 2 August 31st, 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
Speakers
Anuj Tandon
Co-Founder & COO, Rolocule Games
Anuj Tandon
Co-Founder & COO, Rolocule Games
Anuj Tandon, Co-Founder & COO of Rolocule Games, handles Products and Product Marketing at Rolocule. He is responsible for growing downloads of Rolocule's games to more than 5 million globally and handles all aspects of marketing. Rolocule Games is an award winning game development studio that creates engaging games for global audience as well as award winning gaming technology.
Anila Andrade
Producer, 99 Games
Anila Andrade
Producer, 99 Games
A relentless and passionate game designer with over 9 years of experience in the Software Industry with particular emphasis in the mobile gaming spectrum, Anila now leads the production team at 99Games. Her scope of work on the production side extends right from conceptualizing a game, brainstorming with the team and reviewing final deliverables all the way up to planning go-to market strategies, publishing and measuring the game performance.
She is a regular Speaker at premier industry wide gaming conferences like Casual Connect, NASSCOM Product and Gaming Conclave among several others.
Our Sponsors & Partners
Venue :
Bandra Kurla Complex, Mumbai
Bandra Kurla Complex - Trade Centre
G/F & 1/F, Trade Centre,
Bandra Kurla Complex,
Bandra (E), Mumbai
Do you have any queries?
Drop us a line and we will call you.
