Developing an efficient and accurate valuation model that is theoretically valid, well structured, flexible and accurate is essential for any professional in finance. Unfortunately, many corporate finance models are biased, clumsy and inflexible rendering the whole valuation process at best meaningless. Taught by Edward Bodmer, a global leader in financial modelling, the intensive 2-day modelling valuation and modelling program will inform finance executives, accountants, financial consultants, and investors on innovative valuation and modelling techniques. Theoretical and applied techniques and implementation issues are addressed for efficiently creating corporate models with flexible history, automating historic data acquisition, accurately modelling depreciation and creating structured assumptions with interpolation. Valuation techniques that deal with unique methods of measuring normalized cash flow, cost of capital, interest tax shields, terminal value from value drivers and effective presentation are covered with hands-on models. A practical case study from India will be used to illustrate the applied valuation and financial modelling concepts.
The programme will be hands-on and highly interactive, and sessions will include combine:
• Seminars in which techniques and ideas are introduced and discussed in detail
• Hands-on Modelling sessions where participants work through practical solutions
• Case Studies in which participants examine ways to avoid pitfalls in valuation and modelling
• Retention of Learning with strategies for continued learning and reinforcement of ideas
Participants receive a Comprehensive Resource Library filled with financial models, databases, case studies, articles and utilities to make analysis more efficient.
Who Should Attend
• 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
• Investment Bankers
• Portfolio Managers -Corporate Restructuring
• Fund Managers
• Credit analysts at banks and other financial institutions
• Business strategists at corporations
• Compliance officers
Benefits of Attending:
• Understand the theoretical issues with structuring of corporate models, development of assumptions, computation of rate of return on invested capital. risk analysis, valuation formulas, capital structure and other issues.
• Create a structured corporate model that uses and updates historic information in a flexible manner and allows efficient statistical analysis of assumptions.
• Add valuation sections to corporate models that include provisions for changing terminal growth, WACC, multiples and valuation dates; normalise working capital, capital expenditures, depreciation and deferred taxes; and evaluate items that comprise the difference between equity value and enterprise value;
• Resolve tricky issues in terminal value from derived EV/EBITDA ratios that correct for flaws in the value driver (1-g/ROIC)/(WACC-g) formula and consider alternative growth rates; changes in cost of capital and variations in the spread between cost of capital and return on invested capital.
• Compute equity value from enterprise value through creating proofs of how different items such as deferred taxes, warranty provisions, derivatives, long-term receivables, unfunded pensions and stock options affect the difference between equity value and enterprise value.
• Use corporate models to quantify risks to risks to debt and equity investors using structured scenario analysis, break-even analysis, sensitivity analysis and Monte Carlo simulation.
• Learn Excel techniques including selected user-defined VBA functions to make better presentations from models, to resolve circular references and to make models more transparent and efficient
Day 1 Session 1 - Creating an Efficient and Well-Structured Corporate Model
• A review of model objectives, model structure and flexible using examples of completed models that will be used as references throughout the training.
• Development of historic/projected timing switches that allow you to add new historic financial statements to a model and efficient ways to add historic data to a model
• Setting up assumptions for variables that vary over time and scalar variables that remain constant and that compare historic levels with projected values and facilitate statistical analysis of the assumptions.
• Computation of revenues, operating expense, capital expenditures, pre-tax cash flow, free cash flow and from operating assumptions and computation of return on invested capital using the financing and direct approaches.
• Case Study of HT Media – Uploading Data and Creating Assumptions
Day 1 Session 2 – Enterprise Valuation from Corporate Model and Financial Statements
• Development of enterprise valuation analysis that allows for flexible start dates; flexible terminal dates and holding periods; and different terminal valuation approaches.
• Calculation of financial statements through adding financial routines with a cash flow waterfall to the model in debt and cash balance schedules and using the model to establish a target capital structure.
• Illustration of complexities in corporate models related to asset retirements, income taxes, minority interest and capital expenditures.
• Case Study of HT Media – Problems with Financial Models
Day 1 Session 3 Innovations in Corporate Finance Theory
• Solution to IRR problem of re-investment and ranking with Weighted Average IRR
• Computing Cost of Capital with Market to Book Regression Rather than CAPM
• Demonstration of Flaws in Value Driver Formula: V=Income x (1-g/ROI)/(COC-g)
• Correct Evaluation of WACC using Tax Shield from Interest Expense
• Use of Credit Spread to Derive Debt Beta and More Properly Derive Unlevered Beta
• Evaluation of Terminal Value Adjustments for Capital Expenditures, Working Capital and Deferred Tax that Depend on Growth
• Adjustments to Free Cash Flow and EV to Enterprise Value Bridge for Deferred Tax, Warranty Cost and Other Items
• Development of Terminal Valuation Techniques for Financial Institutions that Use Market to Book Ratio and ROE from Financial Models
• Evaluation of Political Risk Premiums from Computing Implied Probability of Default
Day 2; Session 1 - Valuation Using Corporate Model
• Demonstrate financial theory associated with multiples, terminal value and credit analysis using financial models.
• Demonstrate variability in enterprise value and use of the return on invested capital to evaluate the reasonableness of the EBITDA assumptions.
• Development of normalised working capital changes, normalised depreciation expense, normalised capital expenditures and normalised deferred taxes that vary as a function of different terminal growth rates and incorporate derived historic growth rates.
Day 2; Session 2 – Advanced Valuation and Multiples
• Computation of P/E and EV/EBITDA multiples from growth rates, cost of capital, returns, tax rates and asset life as well as transition periods of each value driver and demonstration of problems with the (1-g/ROIC)/(WACC-g) formula.
• Evaluation of which balance sheet items should be included in the bridge between equity value and enterprise value through creating long-term models that prove whether items should be included in free cash flow or as an adjustment to enterprise value.
• Calculation of value from equity cash flow rather than free cash flow and derivation of equity multiples (P/E or market to book) to evaluation how multiples are affected by return and growth forecasts in the model.
Day 2; Session 3 –Innovations in Corporate Modelling
• Use of Historic Switch to Make Incorporation of New Financial Statements
• Evaluation of ROIC and Invested Capital Using Switches and SUMPRODUCT
• Development of INTERPOLATE Function to Evaluate Assumptions
• Automation of Scenario Analysis with Scenario Reporter
• Effective Automation of Historic Data Graphs with Flexible Spinner Box
• Resolution of Circular References Related to Interest Expense and Taxes
• Deprecation Techniques that Account for Changing Growth and Implied Retirements
• Development of Techniques to Automate Constant Capital Structure in Financial Models
• Dynamic Goal Seek Functions for Evaluation of Cost of Capital Using P/E Ratios
• User Defined Functions for Computing Stable Capital Expenditures to Depreciation and Other Items
Day 2; Session 4 –Innovations in Corporate Data Analysis
• Creation of techniques to download stock price data, financial statement data and economic data
• Stock price database that allows you to evaluate IRR’s, volatility and beta for stocks, stock price indices, economic series and commodity prices.
• Financial Database that allows you to extract and evaluate financial data, financial ratios, and cost of capital across companies.
• Extraction of Data that Enables you to have Historic Basis for Creating Financial Models.
• Interest Rate, Exchange Rate and Commodity Price Databases that Include Historic Evaluation of Term Structures, Volatility and Other Statistics.
• Comprehensive Country by Country Database to Evaluate Growth and Risks Across the World.
CFA Society India (Indian Association of Investment Professionals), established in April 2005, is an association of local investment professionals, consisting of portfolio managers, security analysts, investment advisers, and other financial professionals. As one of the over 149 CFA Institute member societies, CFA Society India connects local members to a global network of investment professionals.
\r\n\r\nFor more than 60 years, CFA Institute and Member Societies such as CFA Society India, have held educational events featuring prominent investment professionals and thought leaders, and as the number of investment professionals across India continue to grow, we are committed to offering quality educational and networking opportunities in the region.
\r\n\r\nThe key objectives of the society are to:
\r\n\r\nPromote ethical and professional standards within the investment industry in India
\r\nFacilitate the exchange of information and opinions among people within the local investment community and beyond
\r\nWork to further the public’s understanding of the CFA® designation and the investment industry.
*CFA Society India is a registered trademark of CFA Institute licensed to be used by the Indian Association of Investment Professionals.”
\r\nVCC 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.
Bengaluru
Date: April 22-23, 2019
Venue: Bengaluru
Drop us a line and we will call you.
