Project Finance Solar PV model with re-financing

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.