Advanced Financial Modelling, Quantitative Finance and Econometrics · Physical, Online
Project Finance Modelling and Investment Appraisal Training Workshop
5 Days3 sessions available Certificate on completion
The Project Finance Modelling and Investment Appraisal Training Workshop equips participants with practical skills to assess project feasibility, develop integrated financial models, evaluate investment opportunities and determine the financial sustainability of projects. The workshop covers capital expenditure estimation, revenue projections, operating costs, cash-flow modelling, financing structures, debt repayment schedules, financial statement projections, investment appraisal techniques and risk analysis. Participants learn to apply Net Present Value (NPV), Internal Rate of Return (IRR), payback period, debt service coverage ratios and sensitivity analysis using Microsoft Excel, with Power BI for financial dashboards and Python for advanced scenario modelling where appropriate. Practical applications include infrastructure, energy, real estate, manufacturing, public-private partnerships (PPPs) and development-funded projects.
The **Project Finance Modelling and Investment Appraisal Training Workshop** equips participants with practical skills in financial modelling, project feasibility analysis, cash-flow forecasting, investment appraisal and financing structures. Using Microsoft Excel, Power BI and Python, participants learn to calculate NPV and IRR, analyse debt repayment capacity, conduct sensitivity analysis and assess financial risks. The workshop is ideal for financial analysts, project managers, investment professionals, accountants and infrastructure developers seeking to evaluate project viability and make informed investment decisions.
Course objectives
Develop integrated project finance models incorporating capital expenditure, operating expenditure, revenue projections, working capital, financing assumptions and project cash flows.
Prepare project financial reports, investment appraisal recommendations and decision-support dashboards using Excel, Power BI and selected Python tools.
Conduct sensitivity analysis, scenario modelling and financial risk assessment to evaluate the impact of changing costs, revenues, interest rates, inflation and other investment assumptions.
Construct financing models incorporating debt and equity structures, loan amortisation, interest expenses, repayment schedules and debt service coverage ratios.
Apply investment appraisal techniques, including NPV, IRR, payback period and profitability index, to assess project viability and compare investment alternatives.
Who should attend
Project finance professionals, investment analysts, financial analysts, accountants, corporate finance managers, project managers, infrastructure developers, energy project developers, real estate investors, banking professionals, credit analysts, investment officers, public-private partnership specialists, government project planners, development finance professionals, donor-funded project managers, financial consultants, business owners and entrepreneurs.
Course content
Module 1: Fundamentals of Project Finance and Investment Appraisal Principles of project finance, project finance versus corporate finance, project financing structures, project development lifecycle, identification of project stakeholders, financial and
Module 2: Project Feasibility Studies and Financial Data Preparation Technical, commercial and financial feasibility, project market assumptions, demand and revenue drivers, capital and operating cost estimates, project implementation timelines, financial
Module 3: Capital Expenditure, Operating Costs and Working Capital Modelling Capital expenditure (CAPEX) estimation, operating expenditure (OPEX) projections, construction and implementation costs, contingency allowances, maintenance and replacement expen
Module 4: Project Revenue Forecasting and Demand Modelling Revenue streams and pricing assumptions, market demand forecasts, production and capacity assumptions, utilisation rates, sales volume projections, tariff and fee modelling, contracted versus vari
Module 5: Integrated Project Financial Modelling Using Excel Financial model architecture, model assumptions and calculation sheets, timeline and project lifecycle modelling, integrated revenue and cost schedules, cash-flow projections, projected income s
Module 6: Investment Appraisal Techniques and Project Viability Time value of money, discount rates, cost of capital, Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), simple and discounted payback periods, p
Module 7: Project Financing Structures and Capital Structure Modelling Debt and equity financing, shareholder contributions, commercial bank loans, development finance institutions, concessional financing, subordinated debt, financing fees, capital struct
Module 8: Debt Schedules, Loan Amortisation and Debt Service Analysis Loan repayment structures, principal and interest calculations, repayment profiles, grace periods, repayment holidays, balloon payments, floating and fixed interest rates, loan amortisa
Module 9: Project Cash-Flow Forecasting, Taxation and Financial Statements Project cash-flow forecasting, operating and financing cash flows, construction-period cash flows, tax assumptions, depreciation and capital allowances, tax liabilities, tax shield
Module 10: Sensitivity Analysis and Financial Scenario Modelling Single-variable and multi-variable sensitivity analysis, best-case and worst-case scenarios, revenue and cost shocks, construction cost overruns, project delays, interest rate changes, infla
Module 11: Project Risk Analysis and Monte Carlo Simulation Financial risk identification, construction and operational risks, demand and revenue uncertainty, cost escalation risk, financing and refinancing risk, interest rate and currency exposure, risk
Module 12: Economic Appraisal and Development Impact Assessment Financial appraisal versus economic appraisal, financial and economic costs and benefits, economic opportunity costs, shadow pricing concepts, externalities, social and environmental impacts,
Module 13: Sector-Specific Project Finance Modelling Infrastructure and transport project finance, renewable energy and power generation models, real estate development cash flows, manufacturing and industrial investment models, water and sanitation proje
Module 14: Financial Reporting and Investment Dashboards Using Power BI Preparing project model outputs for reporting, importing financial model data from Excel, designing financial performance dashboards, capital expenditure tracking, revenue and operati
Module 15: Integrated Project Finance Modelling and Investment Appraisal Project Selection of an infrastructure, energy, real estate or business investment project, preparation of project assumptions, estimation of CAPEX and OPEX, revenue forecasting, wor
General notes
Tools and Software Microsoft Excel for integrated financial modelling, project cash-flow projections, investment appraisal, NPV and IRR calculations, debt schedules, loan amortisation, sensitivity analysis, Scenario Manager and financial forecasting, Microsoft Power BI for project performance dashboards, financial reporting, investment comparisons, debt service monitoring and visualisation of key project indicators, Python for advanced financial calculations, scenario automation, probability-based risk analysis and Monte Carlo simulation, Pandas and NumPy for financial data preparation and numerical analysis, Matplotlib and Seaborn for project risk visualisation and financial charts, and CSV and Excel datasets for financial model inputs, outputs and reporting.
Practical Exercises and Outputs Develop an integrated Excel project finance model for an infrastructure, renewable energy, real estate or commercial investment project, prepare CAPEX, OPEX, working capital and revenue projection schedules, construct projected income statements, balance sheets and cash-flow statements, calculate NPV, IRR, MIRR and payback periods to assess investment feasibility, develop debt and equity financing schedules with loan amortisation and repayment calculations, calculate DSCR and assess project debt repayment capacity, conduct sensitivity analysis to evaluate the impact of revenue reductions, cost overruns, inflation and interest rate changes, develop best-case, base-case and worst-case investment scenarios, perform introductory Monte Carlo simulation using Python to assess uncertainty in project returns, prepare a Power BI dashboard showing project cash flows, profitability, financing requirements and risk indicators, and produce a comprehensive project finance model and investment appraisal report with evidence-based
Frequently asked questions
The workshop is suitable for project finance professionals, investment analysts, accountants, financial managers, project developers, infrastructure specialists, banking professionals, credit analysts, development finance practitioners and professionals responsible for evaluating capital-intensive investments.
Microsoft Excel is the primary tool for financial modelling, investment appraisal, cash-flow projections and debt schedules. Power BI supports financial dashboards and reporting, while Python can be used for advanced scenario analysis and Monte Carlo simulation.
Participants will learn to calculate and interpret Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), simple and discounted payback periods, profitability index, and debt service coverage ratios to assess project viability and financing capacity.
Yes. The workshop covers debt and equity structures, financing drawdowns, loan amortisation, interest calculations, repayment schedules, financing costs, debt service coverage and lender-oriented financial analysis.
You will develop an integrated project finance model, investment appraisal calculations, debt repayment schedules, sensitivity and scenario analysis, a financial risk assessment, a Power BI project finance dashboard and a final investment appraisal report suitable for supporting investment and financing decisions.