Financial Modelling ExampleProject Finance Financial Model
Sample Project Finance Financial Model
Client:
International development company
Project:
To create a project finance model to support a number of potential renewable energy projects using both solar and wind
Reason for new model:
To secure funding to enable the project to proceed.
Inputs:
Construction cost estimates from EPC's, projected operating returns and costs. Funding structure.
Structure:
Construction workings on a monthly basis and operations quarterly for 20 years. IDC calculated using a copy and paste macro.
Outputs:
Summary page with sources and uses, debt structure and project returns. Summary and detail Cash flow waterfall and financial statements and sensitivity chart.
Challenges:
Modelling the construction costs and timing, calculating IDC (interest on construction) in a clear and transparent way. Incorporating the unique tax implications of the area.
With our experience in developing project finance financial models in Excel, our financial modelling consultancy is a responsive and competitive alternative to hiring an interim financial modeller.
