
Explore project finance fundamentals, including non-recourse financing, and follow a project from development through concession, construction, and long-term operation, with lenders, DPR, and EPC bidding.
Outline the assumption sheet for project finance modeling, detailing date assumptions, project period, award date, construction start after 12 months, 24-month construction, operation start, and a 30-year concession from award.
Learn to estimate project capital expenditure by separating hard costs (civil, mechanical, electrical, contingencies) from soft costs (development, license fees, insurance, admin) and describe the debt and promoter equity mix.
Explore project finance modeling with a 70/30 debt-to-equity structure, upfront promoter equity of 50% of total equity, term loan terms, ballooning repayment, and moratorium during operation.
Explain how a debt service reserve account (DSRA) protects lenders in project finance by maintaining a 25% annual debt service reserve and a 3-month liquidity buffer, plus working capital assumptions.
Explore how to compute a composite tariff from handling, bagging, storage, and miscellaneous charges using foreign and domestic vessel weights, storage days, and annual escalation.
Explore depreciation types—book straight-line and tax written-down value—alongside corporate tax, cess, and 81A benefits, then apply traffic growth and maximum capacity assumptions (4.5 million metric tons).
Explore the project cost sheet for capital expenditure, detailing construction hard costs (civil, mechanical, electrical), contingencies, preliminary and pre-operative expenses, license fees, insurance, admin, legal, salary, and financing costs.
Identify 5% contingencies on preliminary and pre-operative expenses, including license, insurance, admin, legal, salaries, and financing. Capitalize IDC and debt service reserve into total project cost, with a two-year moratorium.
Create an Excel construction schedule by naming the sheet and defining month ending, quarter, and financial year, linking dates to quarters with if and month functions.
Navigate a 24-month construction schedule with eight quarterly cost distributions, detailing construction costs, preliminary and pre-operative expenses, and non financing costs, including debt service reserve.
Learn to compute interest during construction (IDC) in project finance models, capitalizing debt interest into the total project cost. Link IDC calculations to assumptions, construction schedules, quarters, and financial years.
Model eight-quarter construction costs by separating non-financing costs (epc and soft costs) from financing costs (debt service reserve), and compute equity drawdown from the construction schedule.
Calculate the remaining debt for the total project cost using debt drawdown and equity drawdown; upfront equity of 50% is infused in quarter one.
Explain debt drawdown during construction by linking opening and closing balances with quarterly infusions, IDC, and debt service reserve to estimate total project cost and debt-equity ratio.
Create a traffic projection sheet for a project finance model, calculating operational days and operation factor from construction completion to 2047, linked to the assumption sheet.
Compute project traffic starting at 2.5 million tons with an if-based growth model (15%, 10%, 5%), capping at 4.5 million tons across two products.
Build and format the revenue sheet within the financial model, calculate operating days, year of operation, and the operation factor, then extend to future financial years alongside traffic projections.
Master calculating total traffic for multiple products using the sumif function, implement year-based traffic projections, apply tariff escalation to derive a composite tariff, and compute revenue.
Develop and format the operating expenses sheet to estimate year-by-year costs, including power fixed and variable charges, using traffic and revenue inputs from the revenue and traffic sheets.
Compute operating expense assumptions for opex, including variable charges, fuel expenses, and labour costs (manpower, onboard, wagon loading) using escalation, operation factors, and traffic volume.
Analyze housekeeping, security, and contractual laborers within the assumption and opex framework, noting 10% labor costs and escalation-driven repair, maintenance, and refurbishment cycles for mechanical, electrical, and civil costs.
Analyze license fees and related operating expenses in project finance models, including escalation, general admin costs, insurance, capital expenditure, and revenue share calculations.
Explore building a debt schedule for project finance modeling, calculating debt repayment and interest during operation, with moratoriums, ten-year repayment, and linking assumptions from the construction phase.
Develop a debt repayment schedule for project finance, calculating opening balances, principal repayments, and annual interest, with moratorium, construction schedule, and the debt service reserve.
Learn to calculate depreciation in project finance modeling using straight-line and written-down value methods, and build a depreciation sheet with opening balance, capex, depreciation, and accumulated depreciation.
Learn to calculate working capital in a financial model by computing receivables minus payables, applying credit periods, and the promoter-lender funding split with a 12.5% interest working capital loan.
Analyze year-on-year increase or decrease in working capital by syncing receivables and payables, with a 25% promoter margin and a 75% working capital loan, including end-of-project repayment and interest calculations.
This comprehensive course in project finance modeling takes students through the critical steps of developing, analyzing, and presenting complex financial models for large-scale projects. Designed for finance professionals, project managers, and analysts, this course provides an in-depth look at all stages of project finance—from creating initial assumptions to performing valuation exercises. Students will gain a hands-on understanding of how to structure models, assess project risks, and evaluate financial outcomes. By the end, they will be equipped to produce robust financial reports and valuations that can guide decision-making in real-world projects.
Section 1: Introduction
This opening section sets the stage by introducing the fundamentals of project finance, highlighting its key concepts and applications. Students will learn the purpose of project finance modeling and its importance in assessing long-term investments.
Section 2: Project Period Assumptions
In this section, students explore the assumptions that form the foundation of project finance models, including capital expenditure, capital structure, tariffs, operating expenses, depreciation, and taxes. This section emphasizes making accurate assumptions to create realistic project projections.
Section 3: Capital Expenditure
Students dive into the details of capital expenditure by preparing cost sheets and analyzing pre-operative expenses, learning how to estimate total project costs accurately.
Section 4: Construction Schedule
Here, students will learn to build detailed construction schedules that outline the project timeline, enabling them to predict costs, allocate resources, and plan for potential delays.
Section 5: Interest During Construction
This section covers financing and non-financing costs, debt amounts, and debt drawdowns, which are essential for managing cash flow during the project’s construction phase.
Section 6: Traffic Analysis
Students will explore traffic projections and calculate growth rates, learning methods for estimating demand and usage, which is essential for revenue forecasting.
Section 7: Revenue Projections
Students delve into the process of revenue estimation, calculating total traffic and projected income for a precise view of the project’s income potential.
Section 8: Operating Expenses
In this section, students review operating expenses and understand cost assumptions, including labor, fees, and other operational costs essential for estimating total project costs.
Section 9: Debt Schedule
This section addresses debt interest, repayment schedules, and depreciation, helping students structure a detailed debt repayment model that reflects the financial impact of borrowing.
Section 10: Working Capital Management
Students will calculate and adjust working capital requirements, understanding how fluctuations in working capital can impact cash flow and project sustainability.
Section 11: Debt Service Reserve
Students examine debt service reserves, learning to establish financial buffers to ensure stability in case of unforeseen disruptions.
Section 12: Profit and Loss Statement
This section guides students in preparing a comprehensive profit and loss statement, detailing all revenue, expenses, and depreciation entries to show overall profitability.
Section 13: Cash Flow Statement
Students develop cash flow statements covering profits, financial activities, working capital loans, and dividends, mastering cash flow management and planning.
Section 14: Balance Sheet Statement
In this section, students create a balance sheet by adding interest and investment outflows, giving them a complete snapshot of the project’s financial position.
Section 15: Project Returns
Students learn to calculate project returns, accounting for variations in working capital and assessing project profitability metrics such as NPV and IRR.
Section 16: Ratio Analysis
This section introduces various ratio analyses, such as DSCR (Debt Service Coverage Ratio), to assess the project’s financial health and debt coverage ability.
Section 17: Sensitivity Analysis
Students conduct sensitivity analysis to evaluate how changes in capital expenditure, revenue, and other key assumptions affect the project, enabling risk mitigation.
Section 18: Valuation Presentation
Students learn to present valuations, exploring methods like the NPV method, capital expenditure analysis, and cost of debt/equity for project and equity valuation.
Section 19: Valuation Exercise
In this practical section, students apply pre- and post-money valuation techniques, DSRA adjustments, and enterprise value calculations to enhance their modeling skills.
Section 20: Case Study Presentation and Assumptions
A hands-on case study covers inflation, market escalation, and market premiums, teaching students to make project assumptions and align valuations with market dynamics.
Section 21: Solution Case Study
Students dive deeper into case studies, learning to calculate equity and debt costs, repayment schedules, and minimum DSCR to solidify their understanding of complex project finance scenarios.
Section 22: Project Report Presentation
The course culminates with a project report presentation, where students learn to compile financial statements, cash flows, and valuation methodologies into a final report to showcase their project’s financial viability.
Conclusion:
By the end of this course, students will be equipped with the skills to build detailed project finance models, conduct thorough financial analysis, and present insights in a clear, data-driven format. Whether they aim to work in finance, project management, or as independent consultants, students will leave with the confidence and technical expertise needed to excel in the field of project finance.