Overview

Financial Modeling Course with MS Excel Outline This 3 day course includes the following

(Excel and Intro to Financial Modeling)

 Linking sheets and building templates

 Duplicating sheets (better than copy and paste) for faster report building

 Inserting sheets, labeling and coloring the professional way

 Freezing Panes and splitting windows

 Conditional formatting

 Formulas for dynamically setting up the model and reports: VLOOKUP, INDEX and CHOOSE

 Formulas for programming the model: IF, IFERROR, AND, OR, ISBLANK, and others in the same family

 Data Table for sensitivity analysis

 Goal Seek and Scenario Manager for scenario What-If-Analysis

 Charts: Line Charts, Column Charts, Bar Charts and Pie Charts

 Introduction to Financial Modelling (The above listed may not be required if participants have a good grasp of MS Excel)

Day 1 (Financial Modelling and Live Practice on a Nigerian Company)

 The core theory behind Financial Modelling and Company Valuation

 Income Statement, Balance Sheet and Cash Flow from Trial Balance

 Different Valuation Model: DCF, Book Value, M&A Model and Market Valuation

 How DCF is superior and the recommended

 Learn how to build a Discounted Cash Flow model in Excel

 The various stages of a complete DCF Valuation

 Description of the structure of the DCF model

 Modeling the top line

 Introducing scenarios to the model with Choose

 Modeling other items: Other revenues and COGS

 Modeling other items: Operating expenses and D&A

 Modeling other items: Interest expenses, Extraordinary items and Taxes

Day 2: (Continuation of Live Practice and Valuation Model)

 Forecasting Balance Sheet items

 An introduction to the “Days” methodology

 Calculation of DSO, DPO and DOI for the historical period

 Forecasting DSO, DPO and DOI

 Forecasting Property, Plant & Equipment, Other assets and Other liabilities

 Creating an output P&L sheet

 Populating the output P&L sheet

 Populating the output BS sheet

 Completing the output BS sheet for the historical period

Day 3:
 Creating a structure for the calculation of Unlevered Free Cash Flows
 Bridging Unlevered Free Cash Flow to Net Cash Flow
 Calculating Net Cash Flow
 Introducing Weighted Average Cost of Capital and Perpetuity growth
 Discounting Unlevered Free Cash Flows in order to obtain Present Value
 Calculating Continuing Value and Enterprise Value of the business
 Calculating Equity Value
 Sensitivity analysis for WACC and perpetuity growth
 Using charts in order to summarize the results of the DCF Model

Group discounts – 10 or more participants get 10% discount.
We are delighted at the prospects of your team members attending this training and we are confident that it
will be a rewarding experience for them and a worthwhile investment for your organisation.
Best Regards,
Oluseye Kolawole, PMP, Certified Trainer (IASP, PECB, PTTLS, ITF)
Managing Partner.