Sign Up, Its Free

Join our Affiliate Program by simply copying the link of our products on your site and earn affiliate commission on every sale

Are you a Marketing expert, having some strategic tools? Come and Join as our Vendor

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 "[email protected]" 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

Solar PV Project Finance Model Template

Type of Business :

Project Finance Financial Models

Price : USD 127 127.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    Financial model for a typical Solar PV with project finance type of deal. The model contains a simple copy and paste macro to break the circular reference in the sources and uses of fund. The code is password free.

  • Full Description

    The Financial Model (the “Model”) is a cash flow based project finance model that applies a set of stated assumptions in order to model the cash flows of a typical project finance PV solar project and produce forecast financial statements. The Model was created in Microsoft Excel and is based on best practice financial modelling standards. The Model’s building blocks are distributed between preliminary sheets, input sheets, calculation sheets and output sheets. The Financial model contains 15 worksheets which are dynamically linked. 1. Guide: Contains the color codes used in the model, model structure and macros used in the model are listed in this worksheet. Key assumptions and results are also extracted here in form of tables and can be used as the databook and aims to facilitate the extraction of financial model assumptions and results to be used in project documents. 2. Tracker: Aims to keep a track of the changes through multiple versions 3. Q&A: To keep track of questions and answers on the financial model 4. Inputs: Contains the model inputs structure in form of scenario analysis. 5. Sens: Contains sensitivity inputs and outputs 6. Time: Calculation of the different timing flags and counters, used as time reference throughout the model. 7. CapEx: Calculation of construction cost breakdown 8. Financining: Includes: - Calculation of sources and uses of funds during the construction period. - Calculation of disbursement profile, interest and fees during construction - Debt drawdown and repayment profiles 9. Rev & Opex: Includes: - Revenues of the project - Opex calculation - Account receivables - Account Payables 9. Tax: Includes calculation of: - Depreciation - Corporate Income tax payment 10. Return and Ratios: Calculation of debt and equity ratios, including the debt service coverage ratio (DSCR), loan life coverage ratio (LLCR) average loan life, debt returns, weighted average cost of capital (WACC) and equity IRR 11. IFS: Cashflow, balance sheet and income statement on periodic basis using time inputs from "Inputs" sheet. 12. Checks: contains model error and integrity checks 13. Summary: Summary key inputs & Outputs like Summary Sources and Uses of Funds Cover ratios, average loan life, and Shareholder return 14. AFS: Cashflow, balance sheet and income statement on annual basis The Model assumptions are in a dedicated sheet labeled "Inputs" Input Sheets. The layout of the "Inputs" sheet is designed in such a way to enable the user to run multiple scenarios. To calculate the Model, you should press the button: Run Macro. This should be done each time an assumption is changed. You can find the "Run Macro" button on top of each worksheet and also on top of the summary sheet.

  • Table of Content
    No. Content
    Project Finance Solar Model Financial model for a typical Solar PV with project finance type of deal
  • Reviews

    No Review. Write a review and be the first.

Related Products