General
Location Name | The Location Name field allows users to define the location. This is a mandatory field. |
Scenario Group | The Scenario Group field allows users to segment different stresses to projects. Users can group projects together here or single out certain projects to run specific stress tests on. |
Cashflow Group | The Cash Flow Group field allows users to define a cash flow group for a single project or for several projects, and use the cash flows from these projects specifically to pay into a selected collection account. |
Location Count | The Location Count field defines how many units of this location are pledged into the project. |
Months to Opening | The difference between the cut-off date and when the project begins generating revenue, measured in the period compared to the cut-off date. This is an index that relates to the cut-off date, defaults to 0 - meaning, the projects begin making money on the cut-off date, it can also be negative - meaning the projects generate revenue before the cut-off date, or positive - the projects generate revenue after the cut-off date. |
PV Discount Rate (%) | The PV Discount Rate (%) field is the present value of the Total Revenue. It is calculated every period for all remaining periods. This can also be defined as a vector. |
PV Location Count Decline % | The PV Location Count Decline % field is the present value of the Net Operating Income. It is calculated every period for all remaining periods. This can also be defined as a vector. |
Address/City/State/ Country | The Address/City/State/ Country fields allow users to note where each project is physically located. The State field is relevant for tax purposes. Note, once a project has a defined name, it will enable the location, and this location will be added to the State Tax Table under Portfolio Settings.
|
Income
Term (Months) | The Term field defines how many months the contract lasts. |
Operating Company | The Operating Company field defines the name of the Operating Company. |
Operating Company Rating | The Operating Company Rating field defines the rating of the Operating Company. |
Average Unit Volume (AUV) | The Average Unit Volume (AUV) field is the price per unit sold in $. |
AUV Escalator % | The AUV Escalator % defines by how much the price will escalate each month. For example, if the price is $100 and the escalator is 10%, then the price next month would be $110. |
AUV Escalator Start (Months) | The AUV Escalator Start (Months) field defines which month the escalation starts. This is the month the escalator will begin. |
Royalty (%) | The Royalty (%) field defines the royalty revenue in a percent. |
Scheduled Revenue $ | The Scheduled Revenue $ field allows users to define cash flow that is coming in from alternative revenue streams related to the project that are also pledged in. The user will define the amount here. |
Scheduled Revenue Escalator % | The Scheduled Revenue Escalator % field defines the percent at which the scheduled revenue will escalate each month. |
Scheduled Revenue Escalator Start (Months) | The Scheduled Revenue Escalator Start (Months) field defines which month the escalation starts. This is the month the escalator will begin. |
Other Revenue $ | The Other Revenue $ field defines any other revenues that will be generated from the project. |
| Dynamic Income
| This allows users to add different types of project income. See Dynamic Income article for further details. |
OpEx
Operating Expenses
OpEx Production Lag (Months) | The OpEx Production Lag (Months) allows users to input a delay in months between OpEX Energy accounting recognition and actual distribution. |
Cost 1 ($/mo) | The Cost 1 ($/mo) field allows users to define OpEx Cost 1 $ amount per month. |
Cost 1 Escalator (%) | The Cost 1 Escalator (%) field allows users to set what % the OpEx Cost 1 will escalate each month. |
Cost 1 Escalator Start (Months) | The Cost 1 Escalator Start field allows users to set which month the escalation will start. |
Cost 2 ($/mo) | The Cost 2 ($/mo) field allows users to define the OpEx Cost 2 $ amount per month. |
Cost 2 Escalator (%) | The Cost 2 Escalator (%) field allows users to set what % the OpEx Cost 2 will escalate each month. |
Cost 2 Escalator Start (Months) | The Cost 2 Escalator Start field allows users to set which month the escalation will start. |
Cost/Location ($/Location Count/mo) | The Cost/Location ($/Location Count/mo) field allows users to define the cost of the location based on location count per month. |
Cost/Location Escalator (%) | The Cost/Location Escalator (%) allows users to set what % the cost based on location count will escalate per month. |
Cost/Location Escalator Start (Months) | The Cost/Location Escalator Start (Months) field allows users to set which month the escalator will start. |
Cost/Location Floor ($) | The Cost/Location Floor ($) field allows users to define the cost per location floor ($) |
General
Wind Project Name | The Wind Project name field allows users to give their project a name. This is a mandatory field. |
Project ID | The Project ID field allows users to create an ID which is unique per project, this is used to then link the projects and the loans. This ID will be defined under Loans within the Use Asset CF section. |
Scenario Group | The Scenario Group field allows users to segment different stresses to projects. Users can group projects together here or single out certain projects to run specific stress tests on. |
Cashflow Group | The Cash Flow Group field allows users to define a cash flow group for a single project or for several projects and use the cash flows from these projects specifically to pay into a selected collection account. |
Fair Mkt Value $/w | The Fair Mkt Value $/w field allows users to define the fair market value per unit produced. This is most often used for calculating depreciation. |
Capacity (kW DC) | The Capacity (kW DC) field allows users to define the capacity per unit which the project can produce. This is the amount of production coming from the project. |
Acres | The Acres field allows users to define the size of the project in acres. |
Months to COD | The Months to COD field is the months to cut-off-date which is when the project begins producing and generating revenue. This index can be negative, and thus indicate that the project begins generating money before the cut-off date.
Months to COD (defined as prefunded month in loans) |
Aggregate Project Value Discount Rate (%) | The Aggregate Project Value Discount rate field is the present value of the Total Revenue. It is calculated for all periods of all remaining periods. This can be defined as a vector. |
Degradation (%) for Gross/Net Aggregate Project | The Degradation (%) for Gross/Net Aggregate Project field is the present value of Net Operating Income. It is calculated for all periods of all remaining periods. The user can define the discount rate used to calculate degradation. This can also be defined as a vector. |
Address/City/State/ Country | The Address/City/State/ Country fields allow users to note where each project is physically located. The State field is relevant for tax purposes. Note, once a project has a defined name, it will enable the location, and this location will be added to the State Tax Table under Portfolio Settings.
|
Power Generation
Mode | The Mode field allows users to define the power generation of the project to be measured either Monthly or Hourly. |
Months Fields in kWh | The Months fields for power generation allows users to define kWh per each month. This allows users the ability to take account for seasonality in different locations. |
Income
PPA Offtaker | The PPA Offtaker field allows users to document the projects with the entity who issued the PPA. |
Offtaker Rating | The Offtaker Rating field allows users to document the rating which the offtaker deemed for the project. |
PPA Price $ | The PPA Price $ field allows users to define the primary price of energy- primary product. |
PPA Escalator (%) | The PPA Escalator (%) field allows users to define the percentage in which the price will increase. |
PPA Escalator Start (month) | The PPA Escalator Start (month) allows users to define the month in which the escalator starts.This is the month that the escalator will begin. |
PPA Production Lag (Months) | The PPA Production Lag (months) allows users to define the lag of the PPA Production in months. This is the delay between PPA accounting revenue recognition and actual cash flow distribution. |
Alt. Revenue $ | The Alt. Revenue field allows users to define the amount of cash flow from alternative revenue streams related to the projects which are also pledged into the project. |
Alt. Revenue Escalator % | The Alt. Revenue Escalator% field allows users to define the percentage in which the Alt. Revenue will increase. |
Alt. Revenue Escalator Start (Months) | The Alt. Revenue Escalator Start (Months) field defines which month the escalation starts. This is the month the escalator will begin. |
Contract Term | The Contract Term field allows users to define the length in which the contact will last for. |
REC Price $ | The REC Price $ field allows users to model a renewable energy credit price in $. |
REC Price Production Lag (Months) | The REC Price Production Lag (Month) field allows users to define the length of a lag of the renewable energy credit in months. This accounts for the delay between REC accounting revenue recognition and actual cash flow distribution. |
Additional Revenue $ | The Additional Revenue $ field allows users to model any other additional revenues created from the project. |
| Dynamic Income
| This allows users to add different types of project income. See Dynamic Income article for further details. |
CapEx & Tax
Capital Expenses & Taxes
PTC/ITC | The PTC/ITC field allows users to toggle to model a Production Tax Credit or an Investment Tax Credit. |
PTC $/kWh | The PTC $/kWh field allows users to define the amount per kWh, to be utilized as PTC. See PTC Article for further details. |
PTC Lag (months) | The PTC Lag (months) field allows users to define the months latency of PTC cash flow. |
Tax Credit Cost Basis (Optional) | The Tax Credit Cost Basis field is an optional field where users can define the cost of the system, which ITC Rate will apply. If blank, the basis is the depreciation basis. |
ITC Rate (%) | The ITC Rate (%) field allows users to define the tax credit percent of the cost of the system. See ITC Article for further details. |
ITC Basis Reduction (%) | The ITC Basis Reduction (%) field allows users to define the percent of the ITC to be reduced before depreciation calculation. |
ITC Benefit Spread Over First Year | The ITC Benefit Spread Over First Year field allows users to toggle Yes or No. The ITC Benefit is either credit once at the first year or spread over tax payment dates, at the first year. |
Total COGS ($) | The Total COGS ($) field allows users to input the total cost of doing business. This total cost is made up of all the inputs needed for production, including tangible (physical) and intangible. Note, that this field refers to the initial cost of the goods, and will be used to calculate depreciation. The total cost of goods sold defines the amount of money spent to make the project functional. |
Ineligible COGS ($) | The Ineligible COGS ($) field allows users to input the cost of goods which are not tangible and can not be on the same calculation basis of the tax credit calculation. By defining the cost of goods which are not physical, the user can separate the tangible from the non-tangible goods for the purpose of tax calculations. |
Depreciation Basis | The Depreciation Basis field allows users to toggle to No Basis, COGS or FMV. The user can calculate the depreciation based on the value of the COGS or on FMV (fair market value). This is an important section; as once the goods lose value, the user can get tax breaks or tax credit for them. |
Federal Depreciation Schedule | The Federal Depreciation Schedule field allows users to set a schedule in which the goods will lose value. This field is used for federal tax deductions.This must be a sum equal to 100 (and there is a validation in this field), meaning at the end of its life, the good will be worth nothing. The user will define the schedule here. This field is used for federal tax deductions. |
State Depreciation Schedule | The State Depreciation Schedule field allows users to set a schedule in which the good loses value. This must be a sum equal to 100 (and there is a validation in this field), meaning at the end of its life, the good will be worth nothing. This allows the user to determine the schedule in which this will happen.
This field is used for state tax deductions. |
Depreciation Schedule | The Depreciation Schedule field is set to Yearly. |
OpEx
Operating Expenses
OpEx | Within the operating expenses (OpEx) section users can input any operating expenses related to the project. For example: insurance, tax, O&M (operating and maintaining).
Users can also add additional customized expenses by using the settings wheel next to the OpEx. Within the customized expenses the user has the structure of 3 columns per expense:
|
OpEx Production Lag (Months) | The OpEx Production Lag (Months) allows users to input a delay in months between energy OpEX accounting recognition and actual distribution (applies on $/kWh/mo & $/MWh/mo) |
Cost 1 ($/mo) | The Cost 1 ($/mo) field allows users to define OpEx Cost 1 $ amount per month. |
Cost 1 Escalator (%) | The Cost 1 Escalator (%) field allows users to set what % the OpEx Cost 1 will escalate each month. |
Cost 1 Escalator Start (Months) | The Cost 1 Escalator Start field allows users to set which month the escalation will start. |
Cost 2 ($/mo) | The Cost 2 ($/mo) field allows users to define the OpEx Cost 2 $ amount per month. |
Cost 2 Escalator (%) | The Cost 2 Escalator (%) field allows users to set what % the OpEx Cost 2 will escalate each month. |
Cost 2 Escalator Start (Months) | The Cost 2 Escalator Start field allows users to set which month the escalation will start. |
Cost / Kilo Capacity ($/kW/mo) | The Cost/Kilo Capacity ($/kW/mo) field allows users to define the $ amount per month. |
Cost / Kilo Capacity Escalator (%) | The Cost / Kilo Capacity Escalator (%) field allows users to set what % the Cost / Kilo Capacity will escalate each month. |
Cost / Kilo Escalator Start (Months) | The Cost / Kilo Escalator Start field allows users to set which month the escalation will start. |