HRinAction 2017 BESPOKE AND INHOUSE TRAINING.

0 downloads 274 Views 1MB Size Report
How to build a Sensitivity Table ... Build forecast financial statement projections based on assumptions ... Estimating
HRinAction 2017 BESPOKE AND INHOUSE TRAINING. FINANCIAL MODELS, VALUATION, ANALYSIS AND FORECASTING TECHNIQUES

About Us HRinAction is a human capability development and career leadership social enterprise located in Lagos Nigeria. Established February 2013, we are passionate about helping people develop their natural and innate talent in order to be the best at work, make the best of their lives hence contribute effectively to society.

Our Mission

Our Values

Contacts

Learning

Passion

+234 (0) 8187518571, 8188579830

Employment Opportunities

Integrity

[email protected]

Innovation

Commitment

http://www.hrinactionandcsr.org/

Introduction to Financial Modelling • Overview of Financial Modelling • How financial Models Work: Theory and Practice • Capital Budgeting Techniques • Future Values and Applications

DAY 1

Formulae and Functions for Modelers • Basic Facts about Formulas • Review of the key Functions: • Efficient ways to enter functions • The New Model friendly functions of Excel 2010, 2013 & 2016 • Abuse of the IF Function, the alternatives: • The importance of Direct editable logic in a model as against nested IF’s • Using the XIRR, XNPV, NPV & IRR Functions • Various Function Drills

Financial Models, Valuation, Analysis And Forecasting Techniques

Financial Statement Modeling • Financial Statement Models • Estimating Free Cash Flow to Firm • Equity and Firm Valuation

DAY 2 Creating Scenarios & Sensitivity Analysis • Creating Scenarios with Goal Seek • Using CHOOSE & OFFSET to create Scenarios • How to build a Sensitivity Table • Advanced Sensitivity Table Techniques • How to toggle between input sheets (How to create two models in one with Input Sheet scenarios)

Financial Models, Valuation, Analysis And Forecasting Techniques

Advanced use of LOOKUP Functions • Modeling & Data Analysi • Review of VLOOKUP • How to automate the col_index_no argument of VLOOKUP • Lookup to the left with INDEX and MATCH

DAY 3

Intro to Array Formulas & other Techniques • Understanding Array Formulas • The Controversy: Should you use Array formulas in a model? • Amazing examples of their use • Using the TRANSPOSE function • Useful Conditional Formatting Techniques • Methods of extracting info from a text string

Financial Models, Valuation, Analysis And Forecasting Techniques

Creating Debt & Depreciation Schedules • A simple Debt Schedule • A Dynamic Debt Schedule • Using the Depreciation Functions (SLN, DB, DDB, SYD, VDB) • Inserting a Dynamic Depreciation Schedule into an existing Model

DAY 3 (Contd.)

• Review of various debt calculation techniques

Understanding the Big picture • Reading the company’s financial reports like a modeller and not like an accountant • How to identify the Company's Key driver(s) (the KPI’s) • Understanding the relationships b/w accounts/financial statements • Build assumptions based on historical trends • Build forecast financial statement projections based on assumptions • Identify and review alternative approaches (time constraint issues, insert scenarios etc)

Financial Models, Valuation, Analysis And Forecasting Techniques

Case Study on Financial Models - Preambles • Reading between the lines: Chairman and CEO statements in the financials • Where to get information on a company • Understanding the Business -read the reports, understanding the Company’s strategy, Industry analysis and core financial analysis • Copy historical from PDF to Excel (Merge & Split accounting line items -

DAY 4

clean up the financials as required for the model) • Reconstructing the P&L, Why it is extremely critical to get it right • Understanding the difference between a Modellers P&L Case Study on Financial Models • Overview • Creating Assumptions • Building the Computation Template • Analyzing the 10-year financial statements of a Firm • Developing the Model • Free Cash Flows and Valuation • Modeling the Firm’s Dividend Policy • Estimating the Cost of Equity and the Cost of Debt • Calculating the WACC • Sensitivity Analysis

Financial Models, Valuation, Analysis And Forecasting Techniques



Model Completion Steps



Model Analysis & Review



Practice! Practice! Practice!

DAY 5 Financial Models, Valuation, Analysis And Forecasting Techniques

OUR TRACK RECORD.

OUR TRACK RECORD.