Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Advance Budgeting and Forecasting in Excel Plus Financial Modelling
On going

By: Fontini Consulting Ltd

Abuja FCT, Nigeria

18 - 22 Mar, 2024  5 days

Follow Event

  

NGN 285,000

Venue: Alexis Hotel and Conference Centre. Plot 693 ObafemiAwolowo Way Jabi- Abuja

Organizations cannot afford to make the wrong investments decisions as these decisions have a long-term impact on the business and could make or break the organization. Therefore, it is critical to master financial modelling techniques as they are the main basis for investment decisions. By helping you understand and build effective financial models, this course will have a significant impact on the effectiveness and feasibility of your investment’s decisions.

Course Methodology

This course uses hands-on applications of financial modelling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.

Course Objectives

  • By the end of the course, participants will be able to:
  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modelling techniques
  • Forecast investments and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions
  • Recognize special modelling and valuation considerations and best practices

Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

  • Using advanced Excel
  • Performing capital budgeting analysis
  • Forecasting cash flow
  • Calculating cost of capital
  • Practicing financial modelling
  • Understanding scenario analysis
  • Calculating free cash flow

Contents

  • Advanced Excel for financial modelling
  • Excel tips and tricks that will help you speed up your spread sheet
  • Logical tests
  • Protecting your data
  • Database activities
  • Pivot Tables
  • Grouping data
  • Vertical and horizontal lookup tables
  • The magical choose function
  • Interactive formulas to extract data
  • String functions
  • Data tables
  • Interactive Graphs
  • Fundamentals of financial modelling
  • Time value of money
  • Present Value (PV) Future Value (FV) and Net Present Value (NPV)
  • Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  • Equity IRR and project IRR
  • Using XNPV and XIRR
  • Contradicting NPV and IRR
  • Amortization of loan schedule
  • Enterprise value, market capitalization, firm value and equity value
  • Effective interest rate
  • Compound Annual Growth Rate (CAGR)
  • Investment assumptions and cash flows
  • What needs to be included?
  • Forecasting revenues
  • Forecasting costs and expenses
  • Focusing on income statement or cash flow?
  • Valuation techniques
  • Analysing historical information and developing a projection basis
  • Using ratio analysis to prepare projected financial statements
  • Debt capacity and credit analysis for the acquisition
  • Sensitivity analysis on cash flows
  • Weighted Average Cost of Capital (WACC)
  • Adjusted Present Value (APV)
  • Using Capital Assets Pricing Model (CAPM) to determine cost of equity
  • Implied risk premium in the current Price Earnings (PE) multiple
  • Gordon model to determine cost of equity
  • Using PE multiple to determine cost of equity
  • Accrual accounting valuation
  • Valuation using multiples
  • Transaction multiples
Alexis Hotel and Conference Centre. Plot 693 ObafemiAwolowo Way Jabi- Abuja Mar 18 - 22 Mar, 2024
NGN 285,000.00
(Convert Currency)

Dr. Francis okereke 08035062583

A distinguished team of Facilitators who are eminently qualified professionals

Related Courses

Agricultural Credit Management and Risk Analysis Course Agricultural Credit Management and Risk Analysis Course

4 days, 16 - 19 Apr, 2024 

2024-04-16 12:04:00 2024-04-16 12:04:00
Abuja FCT, Nigeria

Fontini Consulting Ltd

Agricultural credit officers are often required to analyze loan requests by farmers and other clients. This analysis is to ascertain the ability of the proposed project to operate at profit level as ...

Effective Office Administration and Management for Female Leaders and Professionals Effective Office Administration and Management for Female Leaders and Professionals

5 days, 22 - 26 Jul, 2024 

2024-07-22 12:07:00 2024-07-22 12:07:00
Ghana

Fontini Consulting Ltd

The roles of office professionals have evolved over recent years to include additional responsibilities and require advanced skills, such as the ability to tackle complex tasks, build relationships, ...

Effective Presentation and Communication Skills Course Effective Presentation and Communication Skills Course

4 days, 10 - 13 Jun, 2024 

2024-06-10 12:06:00 2024-06-10 12:06:00
State, Nigeria

Fontini Consulting Ltd

This 4-day course will focus on the latest practices in presentation skills especially in business and academic environments. Much has changed in recent years and the ever-increasing range of ...

Advanced Security Management Course Plus Strategies in Combating Anti Terrorism and Anti Money Laundering Issues Advanced Security Management Course Plus Strategies in Combating Anti Terrorism and Anti Money Laundering Issues

5 days, 08 - 12 Jul, 2024 

2024-07-08 12:07:00 2024-07-08 12:07:00
Ghana

Fontini Consulting Ltd

There is no organization or business that thrives or exists without any form of security measures. Therefore security principles are set down norms for efficient security planning and procedures to ...