Course Overview

The aim of the course is to give delegates a robust and flexible method for building project models, and to train them in established design solutions to the common challenges presented by project models. This will address the needs for time flexibility; flexible capex linked financing avoiding circularity; and scenario management. The course will be built around a live project case which will model a merchant or tolling project.

Training DurationTotal Training Hours : 30 Hours
Training Duration : 1 Week
Total Training Days : 5 Working Days
Training SchedulesWeekdays (Sunday to Thursday)
Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)

WeekEnds (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included
Certifications:1) Certificatel from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE

2) Certificate from American Institute of Professional Studies (AIPS) USA (After 15 Days of course Completion which will couriered to the attendees office address)
Learning AidsYes
Course MaterialHard & Soft Copies of Study Material
Language of InstructionEnglish
Instructor HelplineYes
1. Email
2. Social Media (For Emergency requirements)
Registration Requirements1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
Mode of Payment:Cash / Cheque / Credit Card / Bank Transfer.
Eligibility Criteria
(Who should attend this training)

Financial Modeling are widely used in Various Sectors like:

Investment Banks

Credit Rating Agencies

Equity Research

Mutual Funds

Financial KPOs

Project Finance companies."

Course Benefits

In the finance industry, the value of financial modelling is increasing rapidly.

Financial modeling acts as an important tool which enables business ideas and risks to be estimated in a cost-effective way.

Financial modeling is an action of creating attractive representation of a financial situation of company.

Financial Models are mathematical terms aimed at representing the economic performance of a business entity."

"Design Principles and Best Practice
Course Contents / Outline

1st rule of financial modelling – design, design, design

Modular design, the fundamentals

Design questionnaire

Project and PFI modelling defining in the problems

Creating a flexible non-circular funding scheme

Dealing with varying length forecasting periods

Time Management

Some popular design approaches

Creating a date flexible framework, varying period length from construction to operation

Flexing timing of events -Using flags

Flexible consolidation of periods to years – Index, Offset, Sumif

Construction Period Sources and Uses

Design approach

Dealing with circularity – interest during construction and sizing commitments, using goal seek

Creating a simple funding scheme with term debt and residual equity funding

Building the Model

Lookup tables – alternatives for generating revenues based on different load factors and thermal efficiencies

Cash Flow Cascade and Reserves

Typical priority of payments

Debt service reserve account

Capital maintenance reserve

Building a cash flow cascade

Accounts integration

Project Ratios

LLCR definition

DSCR definitions

Debt repayment profile optimization

Model Flexibility - Scenario Management

Implementing alternative debt structures

Excel’s scenario manager


Index, Choose and Offset

Visual basic tools


Dealing with multiple operating units and consolidating into a pro forma group accounts

Merger accounting

Consolidation eliminations

Consolidation template methodology"

© Laurels Training Institute 2017. All Rights Reserved.