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
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
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.
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.
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.
Bandra Kurla Complex, Mumbai
Bandra Kurla Complex - Trade Centre
G/F & 1/F, Trade Centre,
Bandra Kurla Complex,
Bandra (E), Mumbai
Drop us a line and we will call you.
