Project Finance Model - Advanced Timeline
Originally published: 16/08/2020 16:05
Last version published: 18/05/2021 07:49
Publication number: ELQ-12830-6
View all versions & Certificate
certified

Project Finance Model - Advanced Timeline

Project finance model with the flexible timeline including the developing stage.

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

https://www.eloquens.com/tool/7jq0HrME/finance/project-finance-models/project-finance-model-base

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;
• 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 $39.50

Add to cart

Add to bookmarks

Discuss

Further information

Introduce the flexible timeline to increase the accuracy of the outcome.

Feasibility study from the inception of the projects.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Samir Asadov CFA

keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Project Finance Model - Advanced Timeline

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

  • Hairi Ali
    I don't understand that the model is optimised for achieving the required RoE IRR, and yet I have a negative cash flow position. How to resolve this? Many Thanks.
    arrow_drop_uparrow_drop_downReply reply
    • Samir Asadov CFA
      You probably assumed volatile OPEX, IRR can be acheived with negative cash flow - assuming equity injections.
      arrow_drop_uparrow_drop_downReply reply
    • Hairi Ali
      "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."

      However, it is not easy for me to incorporate another sources of revenue based on your model's current design despite your above statement. Please help. Thanks.
      arrow_drop_uparrow_drop_downReply reply
      • Samir Asadov CFA
        The easiest approach would be a blended revenue line. However, feel free to reach out through the private messages to discuss how assumptions on second revenue line differ.
        arrow_drop_uparrow_drop_downReply reply
      • Hairi Ali
        Ok Samir, now I see that in Curve Tab, row 2.3.1 is relating to the Operations period. I was thinking the model is still governed by the period defined by you in row 2 of the same tab. My apologies.
        1arrow_drop_uparrow_drop_downReply reply
        • Samir Asadov CFA
          Hi Hairi,

          Thanks for your questions. And good observation in the end, Scen tab includes time independent inputs while Curve tab incorporates time dependant inputs. And follow unique timeline for the construction and operation curves.

          Let me know if you have any other questions.

          Best regards,
          Samir
          arrow_drop_uparrow_drop_downReply reply
        • Hairi Ali
          Hi Samir, I'm a bit confused here. Where are the input placeholders for Fixed Cost for the Operation periods? There is 7.1,7.2 but nothing on the area for:

          Wages
          Rent
          Admin Cost
          Maintenance
          Advisory Fees
          Insurance

          Many thanks.

          Reply reply
          1arrow_drop_uparrow_drop_downReply reply
        • Hairi Ali
          Hi Samir, I'm a bit confused here. Where are the input placeholders for Fixed Cost for the Operation periods? There is 7.1,7.2 but nothing on the area for Wages:

          Rent
          Admin Cost
          Maintenance
          Advisory Fees
          Insurance

          Many thanks.
          1arrow_drop_uparrow_drop_downReply reply


        0.0 / 5 (0 votes)

        please wait...