Financial Modelling for Corporate Finance Using Ms Excel/ 22-Jul-2019 - 26-Jul-2019

Financial Modelling for Corporate Finance Using Ms Excel

Bankers Committee members pay N 156,335.00 only

Background

In a dynamic business environment, the need to accurately model and forecast volatile economic inputs is a critical skill required by business managers. Currently, there are various valuation and forecasting theories, the financial analyst should be able to test these techniques by creating business events using a financial model, in order to draw inferences from past events to make future decisions.

Target Participants

Financial Control Officers, Treasurers, Corporate Strategy Officers, Assets and Liability Managers, Accountants, Bankers, Corporate Finance Officers, Credit Administration Officers, Products Development Officers, and Business Development Staff.

Objectives

At the end of the course, participants should be able to effectively:

  • Demonstrate the use of Ms Excel tools in data analysis
  • Demonstrate how to integrate and model the key financial statements
  • Solve complex modeling issues and debug common errors
  • Interprete a financial statement forecast using information from financial reports, including templates and input cleaning
  • Utilize sensitivity and scenario analysis to examine various financial issues

Contents

Financial Statements Basics
- The Core Financial Accounting Statements
- Financial Statements and their relevance (Income Statement, Balance Sheet and Cash Flow)
- The role of Accounting in Finance
- How the Core Financial Statements are Related

Overview of Financial Modelling
- What is Financial Modelling
- Types of Financial Modelling
- The parts of a Model
- The Flow of a Model
- Intermediate Excel for Data Analysis

The Use of Advanced Ms Excel Tools
- SUMIFS
- SUMPRODUCT
- VLOOKUP
- INDEX
- MATCH
- Handling Formula Errors
- Array Formulas
- Circular References
- Formula Auditing

Modeling and projecting the financial statements
- Projecting the income statement
- Projecting the balance sheet
- Projecting the cash flow statement
- Creating the debt and interest schedule
- Forecasting

Analyzing and concluding the model
- Analyzing the output
- Stress testing the model
- Fixing modeling errors
- Advanced modeling techniques

Valuation: Discounted Cash Flow (DCF) analysis
- Understanding unlevered free cash flow
- Forecasting free cash flow
- Forecasting terminal value
- Present value and discounting
- Understanding stub periods

Weighted Average Cost of Capital (WACC)
- Using the CAPM to estimate the cost of equity
- Estimating the cost of debt
- Understanding and analyzing WACC

CAPEX and Depreciation Schedule
- What is CAPEX and Depreciation Schedule
- How to calculate CAPEX
- How to model a depreciation schedule?
- Forecasting CAPEX and Depreciation

Sensitivity Analysis and Scenario Building
- Designing the Structure for Scenarios
- Excel CHOOSE Function to Build Scenarios
- Testing and Analyzing the Scenarios
- Preparing for Sensitivity Analysis
- Using integration method
- Using Direct Method (change to replace growth)
- Indirect Method (change in formula)

The Use of Macros, Basic VBA Codes and Form Controls in Modelling
Best Practice in Financial Modelling and Application


For more information: Call Chris: 08084716114 or via email: cadigwe@fitc-ng.com

Register Now

If you would like to attend this training programme, please fill the form below and we will contact you as soon as possible. You can also pay for courses online.




Our learning sessions are unique in 4 ways

  1. Programme design & delivery recognize the needs of adult learners in career
  2. Experience sharing by practitioners, with well over two decases of experience in areas relevant to course topic, whom we call "Programme Directors"
  3. Course delivery by practitioners based on conceptual research background
  4. The essence of our corproate brand and orientation within concept implementation thinking

The fees cover tuition, course materials, group lunch, tea/coffee and snacks but EXCLUDE accommodation.
Dress Code: Formal

Discount on Fees

3 participants 5% Discount
4 participants & Above 7.5% Discount


Payment of Fees

Payment of fees should be in cash or CERTIFIED CHEQUE/BANK DRAFT made payable to the FITC before the commencement date or on arrival at the venue.

Refund of Fees

Fees paid for participants who do not turn up eventually would be refunded, subject to deduction of 25% administrative cost.

Methodology

Formal lectures, case studies, participative group exercises and experience sharing.

Administration

The programme commences at 10.00a.m. on Monday, 9.00a.m other days and ends at 4.00p.m. daily.

In-plant Option

Do you intend to train more than 20 participants? Are you considering an in-plant option?
Please call us ☎


International Participants

International participants should please inform FITC of their attendance ahead of the programme, to enable us prepare airport pick-up for them.

Copyright © 2019. All Rights Reserved FITC.
Developed by Tulabyte