Sign Up, Its Free

We have launched one more exciting feature on the site!! Now, as a Vendor apart from selling tools and templates, you can also provide hourly consultation!

Vendors who will register with us until 30.09.2020, will get the benefit of "subscription-free" registration. Vendors who are registering post 30.09.2020 might have to pay a yearly subscription fee for using our platform. So, get registered soon and spread the word.

We are launching with few Categories... However, we will be continuously multiplying our bucket list with exciting categories and sub-categories of different fields and professions!!

If you are a Vendor looking to sell tools in any specific category which is not present at the moment on our platform, for instance, say "Branding and Strategy." Simply, email us along with one of your sample business tools on "support@icrestmodels.com" and we will add the same after verifying.

We have our showcased inventory as well so that the upcoming vendors can view the quality of business tools we are looking for.

What's New

Project Finance Covenants Excel Model Template

Type of Business : Project Finance Financial Models

Price : USD 0 0.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    Project Finance Covenants template aims to appraise user with Project Finance Fundamentals. This template can be used for understand the calculations and logic behind Project Finance Covenants. This template shouldn't be used in Real World Situation.

  • Full Description

    Project Finance Covenants template aims to appraise user with Project Finance Fundamentals Like: 1. Cash Waterfall 2. Cash Flow Available for Debt Service (CFADS) 3. Debt Service Coverage Ratio 4. Debt Service Reserve Account 5. Loan Life Coverage Ratio 6. Project Life Coverage Ratio 7. Project IRR 8. Equity IRR Template is designed to include calculations on Quarterly Basis. Please refer to sheet wise details below: 1. Assumptions: User can Input Construction Start Date and Construction Term. Operations are expected to start from next day of construction end date and user can input operations term to calculated operations end date. All the flags and model timeline will automatically account these changes. User can also add various other assumptions like Debt Equity Ratio, Tax Rate, Interest rate etc. This template can incorporate ten scenarios at a time and user can switch to desired scenario using the switch in cell D5. 2. CFADS: This sheet includes calculation of CFADS. User can input the desired numbers in the yellow shaded cells. Please note that all the inflows are to be added as Positive number and Outflows are Negative numbers. 3. DSCR & DSRA: This sheet includes calculation for DSCR and DSRA based on inputs provided on Assumptions and CFADS sheet. 4. LLCR: This sheet includes calculation for LLCR based on inputs provided on Assumptions and CFADS sheet. 5. PLCR: This sheet includes calculation for PLCR based on inputs provided on Assumptions and CFADS sheet. 6. IRR: This sheet includes calculation for Equity and Project Level IRR based on inputs provided on Assumptions and CFADS sheet.

  • Table of Content
    No. Content
    Project Finance Covenants Excel Model Template Project Finance Covenants template aims to appraise user with Project Finance Fundamentals
  • Reviews

    No Review. Write a review and be the first.

Related Products