The financial model is a template for a Wind energy power project with all the standard workings which can be tweaked for region/country-specific regulations. The model has three broad sections – Inputs, Calculations, and Output worksheets.
Model Functionalities:
•Scenario manager with the flexibility to record key outputs for multiple scenarios through a macro
•Timeline: Flexibility of monthly, quarterly, semi-annual, or annual for both construction phase and operation phase
•Macro-economic: 10 indexation profiles with the flexibility of uplifting periodic or annual
•Capital Expenditure: S-curve basis or on a fixed annual cost basis with the flexibility of either expensed/capitalized in P&L
•Generation: Gross generation with an option to select from P50, P75, and P90 scenarios and flexibility to change seasonality, availability, and degradation factors
•Revenue: PPA and market revenue with the flexibility to restrict PPA price in accordance to floor and cap price (after discount)
•Operating costs: Fixed and variable cost provided as an annual real value with flexibility to choose the required indexation
•Working capital: Month basis delay applied on revenue & costs
•Financing: Flexibility to use a combination between 2 senior debts, 2 shareholder loans and, equity; Repayment sized on annuity or sculpted basis with an option to achieve pre-specified target DSCR ratio and Flexibility to amend the debt tenor and grace period in addition to LIBOR, margin and base rates
•Reserves: DSRA calculated on look forward period approach.
•Accounting & Tax: Unit income tax assumption and the ability to choose the depreciation duration. Taxable income is calculated by utilizing the accrued taxable losses
•Ratios and returns: Key ratios such as DSCR (Annual historic and forecast) and LLCR along with project and equity IRR
•Cash waterfall: Net cashflow calculated on a priority basis on operational cashflow
Key Outputs
•Financial Statements as per model timeline and annual
•Dashboard presenting key outputs as per different perspective
– Project – IRR, timeline assumptions, plant assumptions, sources and uses of funds during construction and operations, EBITDA margins, revenue vs cost, capital expenditure
– Lender’s – key ratios comparison (DSCR, LLCR) & debts profile and balance, CFADS vs debt service
– Shareholder’s – Equity IRR, shareholder loan profile, cash balances, dividend distribution
File Types:
- Excel Model Template – .xlsb
- Macro Documentation – .docx
Similar Products
Other customers were also interested in...
Battery Energy Pricing Model
The Battery Energy Pricing Model calculates the required energy price for an industrial-scale batter... Read more
Green Ammonia from Renewable Energy Financial Mode...
This comprehensive 40-year tool aid investors in evaluating potential risks and returns and assess t... Read more
Wind Farm – 3 Statements Financial Model Tem...
Wind Farm - 3 Statements Financial Model with Flexible Timeline, NPV, IRR, Debt Covenants,... Read more
Renewable Energy Financial Model Template Bundle
Take this opportunity and get a discount by getting the Renewable Energy Bundle where you get Solar,... Read more
Wind Farm Development Model
Wind Farm Excel Model Template is an excellent tool to assess the financial feasibility a proposal t... Read more
Green Hydrogen (Electrolysis) Production Financial...
This green hydrogen financial model template builds a multi-year financial plan to analyze the finan... Read more
Green Hydrogen Production from Wind Energy Financi...
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Start Up Wind Farm Excel Model and Valuation (HAWT...
Start Up Wind Farm Excel Model presents the business case of an investment in the construction of a ... Read more
Wind Farm – Project Finance Model
Project Finance Model providing forecast and profitability analysis of a development and operating s... Read more
Renewable Energy Financial Models Bundle
A collection of user-friendly Project Finance Models in the Renewable Energy Sector offered at a dis... Read more
You must log in to submit a review.