Project Finance Model - Unlimited Scenarios
Originally published: 17/08/2020 11:06
Last version published: 18/05/2021 07:48
Publication number: ELQ-16975-4
View all versions & Certificate

Project Finance Model - Unlimited Scenarios

The project finance model with unlimited amount of scenarios and cost profiles.

This project finance model is an advance version of the model you can find under the following link:

The model incorporates the functionality of the unlimited amount of time independent scenarios and time dependant cost profiles.

Project finance model which is not fixed to any particular industry. Easy to incorporate various revenue and cost lines. Particularly useful for the feasibility study of the potential projects side by side. The main outcome of the model is to resolve the optimum price to achieve required hurdle rate, based on the flexible cost and debt terms.

In addition to the functionality described in the base version, this model incorporates new features:

• Multiple scenarios in one model provides an opportunity to user to evaluate multiple projects side by side;
• Ability to have multiple construction and operation cost profiles for different scenarios;
• Macro based functionality to automatically operate the circularity macro when the scenarios are changed;
• Saving the outcomes of each scenario and time of the last optimization run;
• Additional feature to the dashboard – ranking of all scenarios based on different parameters;
• Macro solution to add and delete scenarios and cost profiles.

The template follows best practices in financial modelling and VBA. The model will be expanded in the future to incorporate more complex aspects. Stay in touch to see the new features. Please contact me directly if you have any questions or suggestions. After purchase, use private messages if you need help in populating the models.

This Best Practice includes
1 Excel based model

Acquire business license for $39.50

Add to cart

Add to bookmarks


Further information

Provide ability to compare multiple projects

Feasibility study for unlimited amount of projects


  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


More Best Practices from Samir Asadov CFA


Any questions on Project Finance Model - Unlimited Scenarios?

The user community and author are here to help. Go ahead!

0.0 / 5 (0 votes)

please wait...