Nigerian Seminars and Trainings

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

business logo

Workshop on Financial Modeling for Finance Professionals Using Excel Professionals

By: Rekrut Consulting Limited

Lagos State, Nigeria

28 - 29 Nov, 2022  2 day

Follow Event   

  

NGN 80,000

Venue: Rekrut Consulting, Ilupeju, Lagos

Microsoft Excel is one of the most powerful software used for analyzing data to make a better decision. It helps in data organization, data analysis, and data interpretation. Finance professionals are frequently required to prepare management reports, scorecards, and dashboards. Attending this course will help participants used advanced Excel levels tools and features to produce such important reports. The course starts with pivot tables, the most important tool ever created to perform data reporting, analysis, and reconciliation. It then continues with high level modeling techniques, integration, and report visualization, and it ends with automation that is guaranteed to add value to participants daily and periodic tasks. This course is specifically designed for finance professionals and is the perfect course for those working with budgets on a regular basis.

For whom:

This course is designed for finance and accounting professionals, management accountants and anyone 
looking to learn or extend their knowledge of using Excel to assist with financial decision making in a 
business context.

Learning objectives:

At the end of the program, participants will be able to: 

  • Use Excel is an essential tool for financial modeling, 
  • Learn some key models in financial modeling using excel 
  • Practice rolling forecast using Excel
  • Tie up their financial models with dashboard reporting. 

Course outline:

Module 1: Fundamentals of Financial Modeling 

  • Applications for financial models
  • The major differences between financial models and spreadsheets 
  • Best practice in developing and building financial models
  • Getting the best results with Excel

 Module 2: Financial models and techniques for forecasting

  • Using Excel’s data analysis toolkit
  • Avoiding common forecasting problems
  • Using moving averages to isolate trends in time series data
  • Using linear regression to isolate trends in time series data
  • Using exponential smoothing to forecast sales demand
  • Building a financial model to make sales forecast
  • Using Excel Solver to minimize forecast error
  • Using Excel correlation tools to identify links between variables
  • Building a financial model to forecast costs
  •  Understanding the drivers of business cash flow
  •  Building a financial model to forecast cash flow

Module 3: Financial models for capital investment decision-making 

  • Principles of capital budgeting
  • Common approaches to capital investment decision-making 
  • Understanding the time value of money
  • Principles of discounted cash flow (DCF)
  • Understanding and using Excel DCF functions
  • Building a financial model for capital investment decision-making

Module 4: Financial models for forecasting and improving business performance 

  • The elements, structure and dynamics of financial statements 
  • Understanding the shareholder value concept
  • Measuring profitability with Return on Net Assets (RONA) 
  • Managing the key drivers of RONA
  • Understanding and managing business risk
  • Building a financial model to forecast financial statements 
  • Using rolling forecasts in adaptive management processes- Building a financial model to make rolling forecasts 

Module 5: Financial models for business valuation

  • The need for business valuation 
  • Approaches to business valuation
  • Understanding the shareholder value added (SVA) method 
  • Building a financial model for business valuation
Rekrut Consulting, Ilupeju, Lagos Nov 28 - 29 Nov, 2022

Registration: 09:00:am - 09:45:am

Class Session: 10:00:am - 03:00:am

NGN 80,000.00
(Convert Currency)

LEKE OSHIYEMI 08033071649

Early Bird: 5% Discount. 5-10 Participants (5% discount). 11 or more participants. (10% discount). This covers Course materials and Certificate of attendance.
Available on Request
NST PPC Advert

Related Courses

Effective Logistics Management Effective Logistics Management

2 day, 06 - 07 Feb, 2023 

2023-02-06 12:02:00 2023-02-06 12:02:00
Lagos State, Nigeria

Rekrut Consulting Limited

Logistics management is an important factor in the success of manufacturing operations and has a direct impact on the final outcome. The overall scope of logistics management usually includes many ...

Workshop on Basic Fire Fighting Workshop on Basic Fire Fighting

2 day, 28 - 29 Nov, 2022 

2022-11-28 12:11:00 2022-11-28 12:11:00
Lagos State, Nigeria

Rekrut Consulting Limited

The course is designed for training and competence in basic knowledge of the causes of fire, and prevention and firefighting techniques as well as risk minimization as well as actions to be taken in ...

HR Metrics and Analytics, Concepts and Tools for Effective Decision Making HR Metrics and Analytics, Concepts and Tools for Effective Decision Making

2 day, 16 - 17 Feb, 2023 

2023-02-16 12:02:00 2023-02-16 12:02:00
Lagos State, Nigeria

Rekrut Consulting Limited

Essentials of HR Analytics training helps HR Teams to Interpret, analyze and make justifiable decisions with data in their organizations. HR Officers, Business Partners should sign up for this ...

Workshop on Leading with Confidence Workshop on Leading with Confidence

2 day, 28 - 29 Nov, 2022 

2022-11-28 12:11:00 2022-11-28 12:11:00
Lagos State, Nigeria

Rekrut Consulting Limited

This program is designed for participants who wish to achieve a high level of self-confidence and assertiveness skills with the ability to communicate in a strong, assertive, and confident manner. ...