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.