Project Finance Model - Scenarios & Ratios & Timeline
Originally published: 28/12/2020 08:50
Last version published: 18/05/2021 07:48
Publication number: ELQ-67144-5
View all versions & Certificate

Project Finance Model - Scenarios & Ratios & Timeline

Project Finance Model, which combines advanced ratios, unlimited scenarios and flexible timeline

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

It has a flexible timeline for a different stages of the project, and provides more accurate results both from the project start and financial close.

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 from the inception. 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:

• User can assume different number of month in a period for each stage of the project – focusing on the main aspects of the project. For example the timeline of the cash flows during the development stage can be annual, during construction stage – monthly and during operations – semi-annual;
• Separate column for financial close to increase the precision in IRR calculations and separate all costs and refunds associated with the date;
• Different IRR calcs from the development stage;
• Separate development cost profile with the ability to refinance it in full or partially at the financial close;
• Ability to delay the construction and calculate liquidated damages per day;
• Added second revenue stream;
• Simplified calculations of the development premium.

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 $159.50

Add to cart

Add to bookmarks


Further information

Prepare initial feasibility study for your project


  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Samir Asadov CFA


Discussion feed for Project Finance Model - Scenarios & Ratios & Timeline

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

  • Hairi Ali
    Hi Samir, is this model easy for me to incorporate a new revenue source to add to the total revenue.

    I was thinking to modify it into a two-stream project. One for the gate fee and the other one is for the FiT revenue from the project. Please advise.

    If I were to purchase, may I have a discount too?

    Many thanks.
    arrow_drop_uparrow_drop_downReply reply
    • Samir Asadov CFA
      Hi Hairi,

      I can add multiple revenue streams in this version if you can disclose the assumptions. Probably, better to take it in the private messages.

      I will discuss how to incorporate the discount for this model.

      Best regards,
      arrow_drop_uparrow_drop_downReply reply
    • Sunday Idoko
      Hi Samir. I am looking to model a PPP project to build an IT platform for government services. Can I use this model for that?
      arrow_drop_uparrow_drop_downReply reply
      • Samir Asadov CFA
        Hi Sunday. Thanks for you message. You can use this model for a PPP projects. It is structured to optimize towards towards target IRR, by changing price. Thanks for the download and feel free to reach out to me dirctly if you have any questions.
        arrow_drop_uparrow_drop_downReply reply

      0.0 / 5 (0 votes)

      please wait...