Training on Financial Modeling using Excel
Training on Financial Modeling using Excel will enable participants to acquire the practical knowledge required to build reliable financial models that can be applied to corporate planning and evaluation. Participants will learn best practice design concepts for designing adaptable models using a variety of financial modeling in Excel techniques and functions that are used when creating a complete financial model from scratch.
Target ParticipantsĀ
Training on Financial Modeling using ExcelĀ is aimed at corporate finance professionals, CFOs, financial controllers, finance managers, financial analysts and business development analysts.
Course DurationĀ
OnlineĀ Ā Ā 7 Days
Classroom-basedĀ Ā Ā 5 Days
What you will learnĀ
By the end of this course the participants will be able to:Ā
- Prepare effective financial models utilizing powerful Excel functions
- Use core financial modeling techniques
- Create Scenario Analysis and Dash Boards
- Understand and apply Forecasting concepts and be able to track forecasting errors
- Forecast investments, and calculate valuations of projects and companies in an effective manner
- Develop comprehensive financial models to support investments decision
Introduction to Financial ModelingĀ
- Financial modeling fundamentals
- Steps in model building
- Key concepts of financial modelling
Getting Acquainted with ExcelĀ Ā
- Making Sense of the Different Versions of Excel
- Defining Modern Excel
- Recognizing the Dangers of Using Excel
- Looking at Alternatives and Supplements to Excel
Planning and Designing a Financial ModelĀ
- Identifying the problem that your financial model needs to solve
- Designing how the problemās answer will look
- Gathering data to put in your model
- Documenting the limitations of your model
- Structuring your model: What goes where
- Defining inputs, calculations, and output blocks
- Determining your audience
Excel Tools and TechniquesĀ
- Cell referencing
- Naming ranges
- Linking in excel
- Using shortcuts
Excel Functions and Formulas in FinanceĀ
- The difference between a formula and a function
- Understanding to most important functions and formulas
- Finding the function and you need
- Advanced functions and formulas
Applying Scenarios to Financial ModelĀ
- The Differences between types of analysis
- Building Drop-Down scenarios
- Applying sensitivity analysis with data tables
- Using scenario manager to model loan calculations
Charting and Presenting Model OutputĀ
- Deciding which data to display
- Conveying your message by charting scenarios
- Deciding which type of chart to use
Building Financial Statements Model
- Entering assumptions
- Calculating revenue
- Calculating expenses
- Building the Income Statement
- Building the Cash Flow Statement
- Building the Balance Sheet
- Building scenarios
Building a Discounted Cash Flow ValuationĀ
- Understanding how the discounted cash flow valuation works
- Step 1: calculating Free Cash Flow to Firm
- Step 2: calculating Weighted Average Cost of Capital
- Step 3: finding the Terminal Value
- Discounting Cash Flows and Valuation
Integrating Financial Statements ModelĀ
- Making a reusable budget model template
- Creating dynamic titles
- Calculating cash required for budgeted asset purchases
- Calculating budgeted depreciation
- Calculating the written-down value of assets for the balance sheet