| COURSE : CERTIFIED PROJECT FINANCE AND CASHFLOW MODELLING PROFESSIONAL | |
|---|---|
| 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 Duration | Total Training Hours : 30 Hours Training Duration : 1 Week Total Training Days : 5 Working Days |
| Training Schedules | Weekdays (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 OPTIONAL 2) Certificate from American Institute of Professional Studies (AIPS) USA (After 15 Days of course Completion which will couriered to the attendees office address) |
| Tests | Yes |
| Learning Aids | Yes |
| Course Material | Hard & Soft Copies of Study Material |
| Language of Instruction | English |
| Instructor Helpline | Yes 1. Email 2. Social Media (For Emergency requirements) |
| Registration Requirements | 1. 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 Vlookup Index, Choose and Offset Visual basic tools Consolidation Dealing with multiple operating units and consolidating into a pro forma group accounts Merger accounting Consolidation eliminations Consolidation template methodology" |