Why
Stage 2 dollars are distributed to Stage 2 MW holders using the remainder of Financial Transmission Right (FTR) annual auction revenue after Auction Revenue Rights (ARRs) are funded. Stage 2 MW holders receive a portion of the total Stage 2 dollars based on their pro-rata share of Stage 2 MWs. Stage 2 MWs are known at the conclusion of the yearly ARR allocation, and the total amount of Stage 2 dollars are known at the end of the annual FTR auction.
How
To calculate an estimate of the market participant’s Stage 2 payment, the customer needs two pieces of information: their Stage 2 ARR MWs and the total Stage 2 revenue available.
Steps: First Gather Data
1. Login to FTR MOI
2. Navigate to Download, drop-down menu appears select Private.
/msdyn_blobfile/$value)
3. Download the Stage 2 ARRs file.
/msdyn_blobfile/$value)
4. Navigate to https://www.misoenergy.org.
5. Navigate to Market Reports, select FTR, then Annual Allocation Summary.
6. Download the latest allocation summary file.
/msdyn_blobfile/$value)
Steps: Second Calculate Stage 2 Payment
7. From the MUI Private download, open the STAGE_2_ARR.csv file.
8. Filter for the appropriate months (the FTR planning year runs from June through May)
9. From the allocation summary download, open the YYYY Stage 2 Residual.xlsx file.
10. The percentage column in the Stage 2 ARR file represents the pro-rata portion of dollars to be paid from the amount available in the Stage 2 Residual file for the corresponding season and time of use.
Note: The Percentage value must be divided by 100 before multiplying times Stage 2 dollars.
Example:
The highlighted Stage 2 ARR will receive 0.00078% of the Stage 2 Residual for Summer Off-peak in the month of June. This is the ratio of 0.5 MW to the total Stage 2 MW to the total Stage 2 MW of 63,743 for that season and time of use.
/msdyn_blobfile/$value)
The Stage 2 Residual for Summer Off-peak is about $28.9M.
/msdyn_blobfile/$value)
The highlighted ARR would receive (0.00078/100) * $28,866,464,59 = $225.16 for Summer Off-peak for the month of June.
The total expected Stage 2 Payment is found by calculating the payment for each ARR in the manner above and summing the results.
Stage 2 dollars are distributed to Stage 2 MW holders using the remainder of Financial Transmission Right (FTR) annual auction revenue after Auction Revenue Rights (ARRs) are funded. Stage 2 MW holders receive a portion of the total Stage 2 dollars based on their pro-rata share of Stage 2 MWs. Stage 2 MWs are known at the conclusion of the yearly ARR allocation, and the total amount of Stage 2 dollars are known at the end of the annual FTR auction.
How
To calculate an estimate of the market participant’s Stage 2 payment, the customer needs two pieces of information: their Stage 2 ARR MWs and the total Stage 2 revenue available.
Steps: First Gather Data
1. Login to FTR MOI
2. Navigate to Download, drop-down menu appears select Private.
3. Download the Stage 2 ARRs file.
4. Navigate to https://www.misoenergy.org.
5. Navigate to Market Reports, select FTR, then Annual Allocation Summary.
6. Download the latest allocation summary file.
Steps: Second Calculate Stage 2 Payment
7. From the MUI Private download, open the STAGE_2_ARR.csv file.
8. Filter for the appropriate months (the FTR planning year runs from June through May)
9. From the allocation summary download, open the YYYY Stage 2 Residual.xlsx file.
10. The percentage column in the Stage 2 ARR file represents the pro-rata portion of dollars to be paid from the amount available in the Stage 2 Residual file for the corresponding season and time of use.
Note: The Percentage value must be divided by 100 before multiplying times Stage 2 dollars.
Example:
The highlighted Stage 2 ARR will receive 0.00078% of the Stage 2 Residual for Summer Off-peak in the month of June. This is the ratio of 0.5 MW to the total Stage 2 MW to the total Stage 2 MW of 63,743 for that season and time of use.
The Stage 2 Residual for Summer Off-peak is about $28.9M.
The highlighted ARR would receive (0.00078/100) * $28,866,464,59 = $225.16 for Summer Off-peak for the month of June.
The total expected Stage 2 Payment is found by calculating the payment for each ARR in the manner above and summing the results.