Project Finance Modeling
Info
The program aims to impart essential skills and hands-on experience in developing detailed and adaptable project finance models crucial for effective financial planning and fundraising.
Participants will learn the comprehensive process of building financial models in Microsoft Excel, incorporating checks and audits, and conducting subsequent analyses.
Course Summary
This training session will furnish participants with valuable tools for tackling complex business decisions while considering multiple factors inherent in today’s dynamic business climate. By the end of the course, attendees will confidently construct a project finance model and perform analyses to make informed decisions for their organizations.
Intended Audience
This course is suited for anyone keen on honing their financial modeling abilities.
- Mid to senior-level managers in project finance and fundraising sectors
- Professionals involved or interested in financial modeling
- Consultants and advisors seeking to enhance their modeling expertise
- Managers from investment banks and financial institutions
Training Approach
Utilizing a hands-on approach, the course includes interactive discussions, case studies, and assignments to foster understanding of the relevant concepts. The class size is intentionally limited to 12 participants to ensure personalized attention and fulfillment of their learning goals.
Participants are encouraged to bring a laptop with Microsoft Excel for the sessions.
Instructor
The trainers selected for this course have extensive experience in the financial sector. One particular instructor boasts over 16 years of experience with some of the leading institutions in project finance, investment banking, and private equity.
Course Modules
Module 1
Establishing a project finance model and creating forecasts
- Best practices in financial modeling
- Understanding project finance structures and stakeholders
- Assessing project data
- Steps for model creation
- Effective presentation of model components
Module 2
Developing Layouts and Timeline Information
- Understanding model development and workflow
- Standard practices for layouts and structures
- Creating standard templates for consistency
- Identifying key project timelines
Module 3
Assumption Sheet Preparation
- Creating the assumptions sheet
- Assessing project assumptions related to timelines, revenues, and costs
- Shortlisting and adjusting assumptions
- Implementing forecasting techniques
Module 4
Understanding Capex and Depreciation
- Modeling fixed assets and their depreciation
- Amortization schedules
- Tax implications of depreciation
Module 5
Debt and Equity Scheduling
- Calculating funding needs and sourcing
- Understanding Interest During Construction (IDC)
- Debt service cash flow calculations
- Managing repayment structures
Module 6
Taxable Income Calculation
- Determining net taxable income and applying necessary adjustments
Module 7
Key Schedule Importance and Application
- Working capital schedules
- Debt and interested scheduled preparation
Module 8
Creating Working Capital Schedules
- Understanding working capital components
- Forecasting requirements
Module 9
Integrating Financial Statements
- Best practices for integrating key financial statements
Module 10
Conducting Scenario and Sensitivity Analysis
- Data utilization for sensitivity analysis
- Identifying impactful scenarios
Module 11
Model Review and Control Techniques
- Implementing various tests in the model
- Identifying and resolving common model errors
Module 12
Applying Financial Analysis Techniques
- Linking PV, NPV, and IRR to company valuation
- Evaluating capital budgeting decisions
Module 13
Managing Circularity and Macros
- Addressing circular references in models
- Utilizing macros to avoid circularities
For further details, interested individuals can visit www.riverstonetraining.com.sg or contact via email at info@riverstonetraining.com.sg.
Riverstone – Corporate Training
When
Where
Other events events in Denpasar Indonesia
