Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
  • Project Finance Model - Base
Originally published: 13/08/2020 06:52
Last version published: 21/08/2020 07:40
Publication number: ELQ-67982-5
View all versions & Certificate
certified

Project Finance Model - Base

Flexible Project Finance model - applicable to any industry.

Description
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. 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. Model incorporates the following concepts:

• Flexible construction, fixed operation and variable operation costs with multiple cost curves;
• Dynamic timeline;
• Multiple currencies and indexations affecting both revenue and cost;
• Depreciation, capital allowances and corporate tax calculations;
• VAT refund structure is flexible to incorporate rules form different countries;
• Waterfall to determine the funding requirement, including 3 options for debt and equity drawdown: pari passu, debt first and equity first.
• Debt service includes upfront fees, commitment fees and interest expense;
• Multiple debt repayment options – cash sweep, pmt and sculpting;
• Financial statements - income statement, balance sheet and cash flow statement;
• Dashboard with the main outcomes and visualisation of cash flows and equity outputs;
• Circularity break macro – copy paste approach;
• Count and present errors if optimisation is required;
• Optimisation macro – incorporating goal seek and circularity break.

This is a base project finance model, which 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.

This Best Practice includes
1 Excel based model

Acquire business license for $19.50

Add to cart

Add to bookmarks

Discuss

Further information

A base model following all the main concepts

Feasibility study of the new project

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Project Finance Model - Base?

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


0.0 / 5 (0 votes)

please wait...