Project Finance Solar PV model with re-financing
Originally published: 02/03/2021 18:02
Publication number: ELQ-83383-1
View all versions & Certificate
certified

Project Finance Solar PV model with re-financing

An advanced financial model for a project finance solar project and also include the analysis of the financing structure

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 comes with a manual that explains the model functionalities, color codes, and worksheet and workbook structure.

You can use the model to identify the project's optimal capital structure and test the impact of different mix of equity and debt to fund the construction phase and impact of refinancing post construction.

The Financial model contains 16 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.
2. Table of Content: Lists all the worksheet with links
3. Q&A: To keep track of questions and answers on the financial model
4. InputC: Contains the model inputs structure in form of scenario analysis.
5. InputS: Contains time-based inputs like capex payment curves and principal repayment profiles.
6. Sens: Contains sensitivity inputs and outputs
Calculation sheet
7. Time: Calculation of the different timing flags and counters used as time reference throughout the model.
8. CapEx: Calculation of construction cost breakdown
9. Financing: 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
-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
10. Rev & Opex: Includes:
- Revenues of the project
- Opex calculation
- Account receivables
- Account Payables
11. Tax: Includes calculation of:
- Depreciation
- Corporate Income tax payment
12. IFS: Cashflow, balance sheet and income statement on periodic basis using time inputs from "Inputs" sheet.
13. Checks: contains model error and integrity checks
Output sheets
14. Summary: Summary key inputs & Outputs like Summary Sources and Uses of Funds Cover ratios, average loan life, and Shareholder return
15. AFS: Cashflow, balance sheet and income statement on annual basis

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 on top of the summary sheet.

If you have any questions http://www.finexmod.com to reach me directly or send me a private message via my Eloquens channel.

This Best Practice includes
1 PDF manual and 1 Excel template

Acquire business license for $99.00

Add to cart

Add to bookmarks

Discuss

Further information

identify the project's optimal capital structure and test the impact of different mix of equity and debt to fund the construction phase and impact of refinancing post construction.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from FinExMod


See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Project Finance Solar PV Model With Re-financing

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

  • Tome Ongalo
    Thanks Hedeih for your prompt and cordial response! No problems with model all is OK!
    arrow_drop_uparrow_drop_downReply reply
  • Tome Ongalo
    Hi I purchased the model but every time I change a single assumption in the InputS the model restarts itself and goes back to default assumptions??
    arrow_drop_uparrow_drop_downReply reply
    • FinExMod
      Hi please send me a pm and I will organize a one to one session to walk you through the model.
      arrow_drop_uparrow_drop_downReply reply


    0.0 / 5 (0 votes)

    please wait...