Skip to main content

Proforma in Aire

The Proforma is a time-series financial table that shows how your project performs year by year—or quarter by quarter, month by month—across its operational life. It’s the view that investors, lenders, and internal stakeholders use to evaluate project viability, understand cash generation, and assess risk. In Aire, the Proforma is automatically built from your model’s terms and blocks. As you adjust assumptions or change cases, the table updates in real time, giving you immediate visibility into how changes affect revenue, expenses, debt service, taxes, and returns.

What It Shows

The Proforma displays the full financial cascade for your project:
  • Revenue: Energy sold, capacity payments, or other income streams
  • Operating Expenses: Maintenance, insurance, labor, and other recurring costs
  • EBITDA: Earnings before interest, taxes, depreciation, and amortization
  • Depreciation: Non-cash accounting for asset value decline
  • Interest Expense: Cost of debt over the repayment period
  • Pre-Tax Income: Earnings before tax obligations
  • Taxes: Corporate income tax or other tax liabilities
  • Net Income: Bottom-line profitability
  • Cashflow Adjustments: Add-backs for non-cash items and principal repayment
  • Free Cashflow: Actual cash generated or consumed each period
Each row represents a term from your model. Each column represents a time step—typically a year, but configurable to quarters or months based on your project’s needs.

Why It Matters

The Proforma is the standard format for communicating project economics. Financiers use it to evaluate debt capacity, equity returns, and project bankability. Aire generates the Proforma directly from your model, so it’s always current, consistent, and traceable to source assumptions.

How It Works

Automatic Structure

When you import a financial model or build one in Aire, the platform identifies key financial terms—revenue, opex, taxes, interest, depreciation—and organizes them into a standard Proforma structure. You don’t need to manually format a table or link cells; Aire constructs the layout based on your model’s logic. If your model includes custom revenue streams, tax credits, or financing structures, those appear in the appropriate sections of the Proforma.

Real-Time Updates

The Proforma recalculates instantly when you change assumptions. If you adjust PPA pricing, update debt terms, or switch between cases, the entire cashflow statement updates to reflect the new values. This eliminates version control issues and ensures every stakeholder sees the same numbers.

Case and Scenario Selection

The Proforma reflects the cases selected in your current scenario. Switch between different case combinations to see how alternative assumptions affect the cashflow profile.

What You See

Scan the Proforma to see annual cashflow, identify when the project becomes cash-positive, and understand financial patterns like revenue growth, declining interest expense, or tax shield effects from depreciation. The Proforma provides the raw data underlying key metrics like NPV, IRR, and payback period.

Structure and Layout

Row Groupings

The Proforma organizes financial terms into logical sections:
  • Operating Inputs: Physical or operational drivers like energy production
  • Revenue: Income from sales, contracts, or credits
  • Operating Expenses: Recurring costs
  • Non-Operating Items: Depreciation, interest, taxes
  • Cashflow Adjustments: Reconciliation from net income to free cashflow
Each section can be expanded or collapsed to focus on relevant details.

Column Headers

Columns represent time periods—typically years labeled by calendar year or project year.

Cell Values

Each cell displays the calculated value for that term in that time period. Values are formatted based on term type—currency, percentages, counts, or energy units.

Sparklines

Small inline charts next to term names show the shape of the trend over time—growth, decline, or stability—giving you visual cues without leaving the table view.

Reading the Proforma

Investment Decision-Making

Use the Proforma to assess whether a project generates sufficient returns. Review net income and free cashflow rows to evaluate profitability over time. Compare cashflow timing against capital requirements and investor return hurdles.

Understanding Financial Structure

The Proforma shows how project economics cascade from revenue through expenses to cash generation. Track how revenue translates to EBITDA, how depreciation and interest affect taxable income, and when the project becomes cash-positive.

Communicating to Stakeholders

The Proforma presents financial performance in the format investors and lenders expect. Use it to walk through revenue assumptions, cost structure, and cash generation with stakeholders who may not understand the underlying technical model.