One of the most frequently occurring issue in Project Finance Model is the circularity problem. Most frequently we encounter this during linking of IDC (Interest During Construction) to TPC (Total Project Cost). TPC and IDC are interdependent and hence the circularity error. I have seen models which resort to complicated calculations and Macros to resolve this issue.
In reality, there is a very simple technique to address this problem. In the Excel sheet, Go to File>Options>Formula and enable Iterations on the Top Right. The excel automatically enables iterations and resolves the circular error issue. Please do this at the beginning of building the model.
I am a Management consultant in the area of Project Finance. I provide Financial Modelling support to PPP and other Infrastructure Projects for both Government and Private Clients. So far I have built models in Tourism, Health care, Agri-Business, EV Logistics & Power Sectors. I have an overall experience of 10 years and an MBA in Finance from IIM. This blog is to share my insights in the area of Project Finance. Discussions are most welcome.
Friday, 29 November 2024
Circularity Issue in Financial Modelling of Infrastructure Projects
Subscribe to:
Post Comments (Atom)
DSCR Ratio
The Debt Service Coverage Ratio is the most important ratio in Fund Raising Mandates. Banks want to see this ratio to understand Debt Repaym...
-
I was working for a government client recently and the client wanted Valuation exercise to be done for their organisation. The valuation a...
-
One of the most frequently occurring issue in Project Finance Model is the circularity problem. Most frequently we encounter this during lin...
-
The Debt Service Coverage Ratio is the most important ratio in Fund Raising Mandates. Banks want to see this ratio to understand Debt Repaym...
No comments:
Post a Comment