Concessão ANEEL Lote 4
Transmissão · Horizonte 30 anos · R$ milhões
TransmissãoCash Flow
Annual projection — all periods
P&L Statement
DRE projetada — horizon completo
Tax Apportionment
CIT · Revenue Tax — annual projection
Sources & Uses
Financing structure e application de recursos
Control Points
Mathematical consistency verification of the model
Model Traceability
Technical documentation — concepts, definitions and formulas for each statement line
| Line | Concept | Operation / Formula | Note |
|---|---|---|---|
| RAP (Receita Anual Permitida) | Receita fixa anual paga pelo ONS à concessionária de transmissão | RAP = RAP_Leilão × (1 − deságio) | Valor nominal constante ao longo da concessão de 30 anos. Reajustado anualmente pelo IPCA na prática regulatória. |
| Revenue by Energy Generated | Revenue from the full energy effectively generated | Rev_Energy = Energy_Generated × Tariff_phase × (1 + adj_common)^(yr−1) | The Including Capital Cost tariff applies first; the Excluded Capital Cost tariff starts immediately after the configured transition year. |
| Receita Bruta Total | RAP ofertada anual | Rev = RAP_Leilão × (1 − deságio) | Base para tributos sobre receita (PIS/COFINS). |
| Line | Concept | Operation / Formula | Note |
|---|---|---|---|
| Receita Bruta | Receita total antes de deduções | = RAP | Receita anual fixa permitida pela ANEEL, apurada pelo ONS. |
| (−) Base O&M | Core operations and maintenance cost | = CAPEX × %O&M × (1 + escal_OM)^(yr−1) | Based on total CAPEX. Annual escalation configurable. Includes personnel, preventive maintenance, insurance, and other. |
| (−) Total OPEX | Total recurring operating cost | = Base O&M | Total recurring operating cost deducted from gross revenue before EBITDA. |
| EBITDA | Earnings before interest, taxes, depreciation and amortization | = Gross Revenue − Total OPEX | Revenue Tax (if any) is deducted below with CIT, not at the EBITDA line. Major overhauls are treated as capital expenditure and do not reduce EBITDA. |
| (−) Depreciation | Accounting amortization of fixed assets | = CAPEX / depTerm [while opYr ≤ depTerm] | Straight-line on total CAPEX. After the depreciation term the asset is fully amortized and depreciation ceases. Term is configurable — may differ from useful life. Ver nota fiscal brasileira na seção 2a abaixo. |
| EBIT | Operating result before interest and taxes | = EBITDA − Depreciation | — |
| (−) Interest on Debt | Financial charges for the period | = Balance_outstanding × debt_rate | Calculated on the outstanding balance (SAC). During grace period: interest only, no amortization. |
| EBT (pre-NOL) | Earnings before income taxes (pre-carryforward) | = max(0, EBIT − Interest) | Floored at 0 for display parity. Losses do not create negative tax; they accumulate in the NOL pool applied on the next line. |
| Taxable Base (post-NOL) | Effective CIT base after NOL carryforward | = max(0, EBT + accumulated NOL) | NOL pool from prior losses offsets current-year EBT. This is the actual base multiplied by the CIT rate. |
| (−) Corporate Income Tax (CIT) | Tax on taxable income | = Taxable × CIT × (1 − tax-holiday factor) | The tax-holiday exemption factor follows the yearly tapering schedule (configurable — see Opex tab). During full exemption CIT = 0. |
| (−) Revenue Tax (Turnover) | Tax levied on gross revenue | = Gross Revenue × Revenue Tax rate | Independent of net income. Zero para projetos PPA sob concessão ANEEL. Appears under Income Taxes because it shares the same annual cash timing as CIT. |
| Net Income | Profit or loss for the period | = EBIT − Interest − CIT − Revenue Tax | Equity investor perspective after all charges. |
A legislação tributária brasileira (RIR/1999, Lei 12.973/2014) classifica bens do ativo imobilizado por grupos fiscais com taxas anuais de depreciação definidas pela Receita Federal. A vida útil fiscal pode divergir da vida econômica do projeto. Para concessões de infraestrutura energética reguladas pela ANEEL, aplicam-se as normas contábeis do setor elétrico (IFRS 16 / ICPC 01).
| Asset Group | Fiscal Useful Life | Straight-line Rate | Typical Assets |
|---|---|---|---|
| Group I | 4 years | 25%/yr | Office equipment, tools, light vehicles |
| Group II | 8 years | 12.5%/yr | Heavy equipment, electrical installations |
| Group III | 16 years | 6.25%/yr | Industrial machinery, turbines, transformers |
| Group IV | 20 years | 5%/yr | Infrastructure, civil works, long-life plant |
| Buildings | 20 years (permanent) / 10 years (non-permanent) | 5% / 10%/yr | Powerhouse, dam structures, substations |
| Line | Concept | Operation / Formula | Note |
|---|---|---|---|
| FCFF — Free Cash Flow to the Firm (project perspective) | |||
| EBITDA | Gross operating cash generation | = Gross Revenue − Total OPEX | Total OPEX = Base O&M. Depreciation is non-cash and does not enter here. |
| (−) CAPEX Construction | Physical investment during construction | = CAPEX × disbursement_profile[yr] | Disbursement profile configured via the interactive editor (up to 10 years). |
| (−) CAPEX Overhauls | Periodic reinvestment for major maintenance | = CAPEX × %overhaul × (1 + revInfl)^(opYr − 1) [in years that are multiples of the configured interval] | Base cost in Op Year 1 prices, escalated to nominal value at the year of occurrence. Same convention as tariff and OPEX escalation (Op Year 1 = base × 1). Does not pass through EBITDA. |
| (−) Taxes UNLEVERED | CIT on EBIT without interest deduction + Revenue Tax | = max(0, taxable_EBIT) × CIT + Revenue Tax | Key point: the CIT base in FCFF uses EBIT without deducting interest. This ensures the project IRR is an intrinsic property of the asset, independent of capital structure. NOL carryforward is applied separately on the unlevered base. |
| (−) ΔWorking Capital | Change in strict working capital between periods | = WC[t] − WC[t−1], where WC = Receivables + Inventory − Payables | Optional (toggleable in Opex tab). Receivables = Revenue / turns; Payables = OPEX / turns_pay; Inventory = OPEX / turns_inv. Increase absorbs cash; decrease releases cash. In the final year, remaining WC balance is released back to cash as part of residual value (orthodox convention). |
| FCFF | Free cash flow available to all capital providers | = EBITDA − CAPEX_constr − CAPEX_overhauls − Tax_unlevered − ΔWC | Used to calculate Project IRR and Project NPV. Does not include financing effects. |
| (+) Residual Value | Asset exit value at the end of the horizon | = CAPEX × %residual + WC_released [last year only] | Economic residual — not a book value. Added to FCFF of the final period to complete the IRR series. If WC strict is modelled, the final-year WC balance is also released here. |
| FCFE — Free Cash Flow to Equity (equity investor perspective) | |||
| FCFF (base) | Starting point | = FCFF as calculated above | — |
| (−) Debt Service | Total debt service paid in the period across active debt facilities | = Main Loan Debt Service + IDC Loan Debt Service + Working Capital Loan Debt Service | In FCFE, the model deducts the aggregate debt service of all active facilities. The main loan follows SAC with grace from COD; auxiliary facilities follow their own single-draw schedules. |
| (+) Debt Disbursement | Inflow of lender funds | = Main Loan Disbursement + IDC Loan Draw + Working Capital Loan Draw | Main loan disbursements are proportional to construction CAPEX. Auxiliary loan draws enter FCFE in their configured draw year. |
| (+) Tax Shield | Tax saving from interest deductibility | = Tax_unlevered − Tax_levered = (EBIT − EBT) × CIT | The debt tax shield enters FCFE explicitly, separate from FCFF. This preserves the purity of the project IRR and isolates the leverage effect on the equity IRR. Note: in years where the NOL pools of the unlevered and levered bases diverge (e.g. levered NOL already consumed, unlevered NOL still active), the computed shield can be small or negative — this is mathematically consistent with the FCFF/FCFE framework and indicates the interest deduction has already been fully captured in prior periods. |
| FCFE | Cash flow available to the equity investor after debt service | = FCFF − Debt_Service + Debt_Disbursement + Tax_Shield | Used to calculate Equity IRR and Equity NPV (discounted at Ke). |
| Indicators derived from Cash Flow | |||
| Project IRR | Rate at which project NPV equals zero | NPV(FCFF₁..ₙ + Residual, IRR) = 0 — all flows at t=1..N | CAPEX outflows are embedded in years 1–constYrs of the FCFF series (no separate t=0 term). Solved by bisection (400 iterations, tolerance 1e−9). |
| Equity IRR | Rate at which equity NPV equals zero | NPV(FCFE₁..ₙ + Residual_net, IRR_eq) = 0 | Equity outflows are embedded in construction-year FCFE. Must exceed Ke for value creation. |
| Project NPV | Net present value discounted at hurdle rate | NPV = Σ FCFF_t / (1 + Hurdle)^t for t=1..N | Hurdle rate configurable in Settings tab. If NPV > 0, the project returns above the hurdle rate. |
| Equity NPV | Net present value of equity discounted at Ke | NPV_eq = Σ FCFE_t / (1 + Ke)^t for t=1..N | Discounted at cost of equity (Ke). If NPV_eq > 0, the equity investor earns above their opportunity cost. |
| Payback | First year the cumulative FCFF (including construction outflows) crosses zero | First t such that Σ FCFF_i (i=1..t) ≥ 0 | Calculated on the full FCFF series. Returns the absolute model year. |
| DSCR (main) | Debt Service Coverage Ratio on senior loan only | DSCR = EBITDA / Main_Loan_Debt_Service | Standard lender covenant on the senior project-finance tranche. Most PF documentation defines the covenant test on this metric. Values < 1.0 indicate EBITDA does not cover senior-loan debt service in that period. |
| DSCR (consolidated) | DSCR over all debt tranches combined | DSCR_cons = EBITDA / (Main + IDC + WC Debt Service) | All-tranches view of coverage. Complements the main-loan DSCR by showing the burden of subordinated/working-capital loans. Expected to be lower than DSCR (main) whenever IDC/WC are active. |
| LLCR (main) | Loan Life Coverage Ratio on senior loan only | LLCR = PV(remaining EBITDA over main-loan life, Kd) / Main_Loan_Outstanding_Balance | Prospective lender metric. Tests whether future EBITDA over the remaining senior-loan life covers the outstanding senior balance, discounted at the loan rate. |
| LLCR (consolidated) | LLCR over all outstanding debt | LLCR_cons = PV(remaining EBITDA, Kd) / Total_Outstanding_Balance | Consolidated coverage against the aggregated balance of all tranches (main + IDC + WC). Same discount rate as the main-loan LLCR. |
| Tax | Tax Base | Formula | Perspective |
|---|---|---|---|
| Revenue Tax (Turnover Tax) | Gross Revenue | = Gross Revenue × Revenue Tax rate | Equal in FCFF and FCFE. Levied on sales, independent of net income or financing structure. |
| CIT — unlevered (FCFF) | Taxable EBIT (no interest deduction) | = max(0, taxable_EBIT) × CIT rate | Used in FCFF. Isolates tax from financing effects — project IRR is independent of capital structure. NOL carryforward applied on unlevered base. |
| CIT — levered (P&L / FCFE) | Taxable EBT = EBIT − Interest | = max(0, taxable_EBT) × CIT rate | Used in P&L and FCFE. Captures the tax shield from debt (deductible interest). NOL carryforward applied on levered base (separate accumulator). |
| Tax Shield | Difference between unlevered and levered tax | = Tax_FCFF − Tax_FCFE = (EBIT − EBT) × CIT | Tax saving attributable to debt financing. Added explicitly to FCFE. Grows with interest volume and decreases as debt is amortized. |
| NOL Carryforward | Net Operating Loss accumulated from prior periods | taxable_base = max(0, current_base + accumulated_NOL) | Implemented separately for the unlevered (FCFF) and levered (FCFE) perspectives. Years with negative EBIT or EBT accumulate a deferred tax asset consumed in subsequent profitable years. |
| Line | Concept | Operation / Formula | Note |
|---|---|---|---|
| SOURCES OF FUNDS — development phase | |||
| Equity Capital | Equity investor contribution | = CAPEX_yr × (1 − %debt) [per construction year] | Disbursed proportionally to CAPEX of each construction year. Total = CAPEX × (1 − %debt). |
| Debt (Financing) | Lender disbursement | = CAPEX_yr × %debt [per construction year] | Disbursed proportionally to CAPEX of each construction year. Total = CAPEX × %debt. |
| Total Sources | Sum of funds raised | = Equity + Debt = Total CAPEX | By accounting identity, total sources equal total uses in the development phase. |
| USES OF FUNDS — development phase | |||
| CAPEX — Physical Investment | Application of funds raised | = Total CAPEX | Disbursement profile configured via the interactive editor. |
| MAIN LOAN SCHEDULE — operational phase (SAC) | |||
| Interest — Construction | Interest charged on cumulative main-loan disbursed balance during construction | = Cumulative_main_loan_disbursed × debt_rate [each construction year] | This row documents the main-loan schedule only. IDC treatment (paid current vs. capitalized) is selectable via toggle in the Capex tab. |
| Opening Outstanding Balance | Main-loan debt outstanding at the start of the period | = Main_Loan_Balance[t−1] − Main_Loan_Amort[t−1] | Builds up during construction as main-loan disbursements occur. |
| Period Interest | Main-loan financial charge on the outstanding balance | = Main_Loan_Balance_outstanding × debt_rate | Calculated on the main-loan balance at the start of the period. Charged even during the grace period. |
| Amortization | Main-loan repayment of principal | = Main_Loan_Balance_at_COD / n_installments [SAC — constant principal installments] | Starts at COD + grace period. n_installments = debt_term, capped at the remaining horizon. |
| Debt Service | Main-loan disbursement to the lender in the period | = Main_Loan_Amortization + Main_Loan_Interest | This row documents the main-loan SAC schedule. In cash-flow outputs, total debt service may also include IDC and Working Capital loan service. |
| Closing Outstanding Balance | Main-loan debt remaining at the end of the period | = Main_Loan_Balance_outstanding − Main_Loan_Amortization | Reaches zero when debt_term ≤ useful_life. Otherwise a residual main-loan balance remains at the end of the horizon. |
| Parameter | Concept | Formula | Note |
|---|---|---|---|
| Ke | Cost of equity — minimum return required by the equity investor | Configurable directly in the sidebar (% p.a.) | Discount rate for FCFE. See detailed section below. |
| Kd | Cost of debt — main-loan interest rate used in WACC | = debt_rate configured in the Capex tab | Nominal main-loan rate. The tax shield (1−T) is applied in the WACC calculation. Auxiliary loan rates are not blended into the WACC formula. |
| T (tax rate) | Combined rate for WACC | = CIT (effective income tax rate) | Used to calculate Kd × (1−T) in WACC. |
| WACC | Weighted average cost of capital | = Ke × %E + Kd_main × (1−T) × %D_main | Calculated automatically in the sidebar using the main-loan share and main-loan rate. Used as reference for the hurdle rate. If hurdle rate ≠ WACC, the model shows an alert. |
| Hurdle Rate (TMA) | Minimum attractiveness rate — FCFF discount rate | Configurable directly in the sidebar | Ideally equal to the WACC. May differ by investor decision (e.g., regulatory rate, portfolio floor). |
| B/C | Benefit-Cost Ratio | = PV(Benefits) / PV(Costs) @ Hurdle Rate Benefits = Revenue × factor_BC Costs = PV(CAPEX + O&M + Taxes) | The BC factor multiplies revenue to estimate total benefits (including positive externalities not captured in revenue). B/C > 1 indicates benefits exceed costs at the chosen discount rate. |
Ke is the minimum return rate that an investor requires to contribute equity capital to a project. It is the price of risk the investor assumes by giving up liquidity and accepting the uncertainty of future cash flows.
The equity investor has alternatives: sovereign bonds, real estate funds, other infrastructure projects. Ke is the return of the best equivalent-risk alternative — the opportunity cost of capital. If the project does not return at least Ke, the investor destroys economic value even if the project is profitable in absolute terms.
| Component | Definition | Typical reference | Note |
|---|---|---|---|
| Rf — Risk-free rate | Return of an asset with no credit risk. Floor for any rational investment. | US Treasury 10yr (~4.5% in 2024) or local sovereign bond | No rational investor accepts below Rf. Represents the time value of money without a risk premium. |
| β — Project beta | Sensitivity of the project return to market variations. Measures systematic (non-diversifiable) risk. | β = 0.3–0.5 regulated transmission β = 0.6–0.9 generation with PPA β = 1.0–1.4 merchant generation | Projects with contracted revenue have lower β because their revenue is less exposed to the economic cycle. |
| (Rm − Rf) — Market risk premium | Additional return the market pays above the risk-free asset to compensate for systematic risk. | 5% – 6% (developed markets, historical S&P 500 average) | Represents the compensation for investing in real assets instead of sovereign bonds. |
| Country Risk | Compensation for sovereign risk of the country where the project operates. Captures regulatory, political and macroeconomic risk. | Brasil: 150–250 bps (CDS 5y, Abr/2025) América Latina: 200–400 bps típico Ajustar conforme cenário macro atual | Measured by the sovereign CDS spread. Varies with the political and fiscal cycle of the country. |
| FX Risk | Aplicável quando o FCFE é em BRL mas o investidor mede retornos em USD. | Diferencial de inflação BRL/USD ou custo de hedge cambial | For projects with USD-denominated PPA revenue, this component is typically zero. |
| Project Type | Ke típico (BRL) | Ke typical (+ Brasil) | Justificativa do risk |
|---|---|---|---|
| Regulated transmission | 7% – 9% | 9% – 12% | Revenue guaranteed by regulatory contract. Very low volume risk. β ≈ 0.3–0.5. |
| Hydroelectric with long-term PPA | 9% – 12% | 11% – 14% | PPA elimina risk de price. Risk remaining: hidrologia e operation. β ≈ 0,6–0,8. |
| Wind / Solar with PPA | 10% – 13% | 12% – 16% | PPA reduces price risk but there is resource risk (wind, irradiation) and degradation. β ≈ 0,7–0,9. |
| Generation thermal power (despacho por ordem de merit) | 11% – 15% | 13% – 18% | Risk de despacho variable. Fuel cost impacts margin. β ≈ 0,9–1,2. |
| Generation a market (100% spot) | 14% – 18% | 16% – 22% | Maximum exposure ao price de energy. Alta volatilidade de revenue. β ≈ 1,2–1,5. |
Reference: ANEEL WACC regulatory 2023 (transmissão ~8,6% real BRL), BNDES TJLP, dados de market ABRACEEL / EPE.
The lender has priority over the equity investor. In case of financial distress, the bank is paid first — principal, interest and real guarantees. The equity investor takes the residual risk: if everything goes well they gain more, if it goes wrong they lose everything. Essa assimetria exige um premium permanente.
If in the model Ke < Kd, there is an inconsistency in assumptions — the equity investor would be accepting a lower return than the lender for higher risk. This does not occur in an efficient market.
| Situation | Condition | Equity NPV | Interpretation |
|---|---|---|---|
| Value creation | TIR equity > Ke | > 0 | The project returns above the equity investor's cost of opportunity. Cada R$ investido gera valor econômico líquido positivo. |
| Economic indifference | TIR equity = Ke | = 0 | The project only recovers the cost of opportunity. The equity investor is indifferent between this project and the equivalent-risk alternative. |
| Value destruction | Equity IRR < Ke | < 0 | The project generates positive returns but below the minimum required. The equity investor would have done better in any equivalent-risk alternative. |
Attention: it is possible to have a positive equity IRR (e.g. 10%) with negative equity NPV if Ke = 13%. The project is profitable — but not sufficiently to cover the opportunity cost of capital. This is the most common conceptual errors frequente na assessment de projects: confusing "profitable project" with "value-creating project".
Em project finance (ex: 70% debt / 30% equity), a leverage amplifica o return ao equity investor. Se o project returns 12% (project IRR) and debt costs 8% net, the leveraged equity may return 18%–24% — exactly what the model calculates as equity IRR.
This amplification works both ways: cheap debt relative to project IRR increases equity return; expensive or excessive debt can drive equity IRR below Ke even with a positive project IRR. DSCR measures the safety of this leverage — low values signal that debt service consumes most of EBITDA, leaving little for the equity investor in years of heavy amortization.
| # | Limitation / Assumption | Impact |
|---|---|---|
| 1 | Net Operating Loss (NOL) carryforward — implemented | Years with negative EBIT (FCFF perspective) or negative EBT (FCFE perspective) accumulate a tax loss that is carried forward and consumed in subsequent profitable years. Two independent accumulators are maintained: one for the unlevered (project) tax base and one for the levered (equity) tax base. This avoids overstating the tax burden in projects with a ramp-up phase or early operational losses. |
| 2 | Straight-line depreciation only | Depreciation is computed as CAPEX ÷ depTerm, applied uniformly over the depreciation period. Accelerated depreciation schedules and specific tax incentive regimes (e.g. PPh Badan asset group categories) are not modeled. Ver nota sobre vida útil fiscal brasileira na seção de depreciação. |
| 3 | SAC as the only amortization method | Constant principal installments with decreasing interest. The Price method (constant total installments) and other amortization schedules are not implemented. IDC treatment (paid current vs. capitalized) is selectable via toggle. |
| 4 | No working-capital variation modeling | Working capital balance variations are not modeled. The model may include a working-capital loan facility, but it does not simulate receivables, payables, or annual working-capital build-up and release. |
| 5 | No component-level inflation indexation | Revenue, O&M and fixed payments each carry individually configurable annual escalation rates, but there is no automatic linkage to external price indices (CPI, PPI, fuel indices). |
| 6 | Single-root IRR assumption | The bisection algorithm assumes a single sign change in the FCFF series. Projects with non-conventional cash flows (multiple sign changes, e.g. large overhauls late in the project life) may produce an IRR that does not represent the true economic return. The model flags IRR as undefined when no sign change is detected. |
| 7 | Base BRL nominal (sem correção monetária) | All escalation rates represent nominal growth above the base year. There is no automatic conversion to local currency or real-term deflation. The analyst must ensure that discount rates and escalation assumptions are consistently nominal or consistently real. |