EN
Enron Financial Model

Logistics/Mobility Startup Financials (Free Excel Download)

Enron Communications ("ePower") is a wholly owned subsidiary of Enron Corp. pitching an application delivery platform built on a national Pure IP fiber optic network.

Free, no credit card required
Edit in Excel
Created by ex-finance
professionals from Deloitte
Loading...

Used by professionals from

About this model

Enron Communications, or ePower, pitched an application-delivery platform on a national Pure IP fibre network. The strategy paired network infrastructure with enterprise application delivery during Enron’s expansion period.

A model should connect network capacity and utilisation to enterprise contracts, bandwidth revenue, and the capital required to build the platform. Contract growth must be assessed against the timing of network investment.

Forecast operating cost, capex, financing, and utilisation together with enterprise revenue. This frames the business as an infrastructure-led platform whose returns depend on filling capacity efficiently. It should separately expose the investment required for the national fibre network and the revenue from application delivery.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

About Enron

Read the pitch deck
Enron pitch deck cover
View on makeslides.com
Funding round
Sales
Founded
1999
Category
Logistics/Mobility
Customer
B2B
Geography
USA

How to build a detailed financial model for Enron

A complete walkthrough of the business, drivers, and assumptions behind the downloadable Enron model - distilled from its pitch deck and publicly available information.

Product & value proposition

  • "Enron Intelligent Network" (EIN) - a Pure IP fiber optic backbone with community-distributed edge servers and proprietary InterAgent® middleware.
  • Claims to be the first global network to deploy GSR over DWDM (Cisco partnership).
  • Only network to deliver RealSystem G2 (RealNetworks) rich-media to the desktop over Pure IP.
  • Intel provides secure network technology; Sun Microsystems provides distributed server infrastructure and is a marketing partner.
  • Value prop: deliver next-generation "rich media application services" (branded ePowered™) to 100 million desktops.
  • Three platform requirements called out: Ubiquity, Reliability, Cross-platform network management / settlement.

Revenue model

  • Bandwidth/connectivity fees to enterprise customers or ISPs.
  • Application services / managed services fees for ePowered™ delivery.
  • Settlement and support services (mentioned as a platform capability, not a revenue line).

Traction & metrics

  • Parent company (Enron Corp.) revenues: $31 Billion.
  • Forbes "Most Innovative Company in America" - four years in a row.
  • Target desktop reach: 100 million desktops - stated as a goal, not current traction.
  • No subscriber, customer, or revenue numbers for Enron Communications itself appear in the deck.

Competition / moat

  • Moat is described as the platform stack: Pure IP national fiber + distributed edge servers + InterAgent® middleware + proprietary network management tools.
  • Ecosystem of 20+ named partners including Cisco, Intel, Sun, IBM, MCI WorldCom, Level 3, GTE, RealNetworks, Ciena - presented as a competitive barrier.
  • No explicit competitive analysis, named competitors, or differentiation matrix in the deck.

Team & funding ask / use of funds

  • No individual team members named; team slide is a partner/ecosystem logo grid.
  • No funding ask, valuation, or use-of-funds slide.
  • Enron Communications is a wholly owned subsidiary of Enron Corp.; this appears to be a corporate pitch / partnership deck, not a capital raise.

Recommended financial model

  • Archetype + why: Telecom / network services revenue build - specifically a bandwidth + managed services P&L model. This is a capital-intensive infrastructure business (fiber network + edge servers); the right model captures capex buildout, utilization ramp, blended ARPU per customer/desktop, and operating leverage as fixed-cost base scales. A simple 3-statement model with explicit capex schedule and operating cash flow bridge is appropriate given the infrastructure-heavy nature.
  • Forecast horizon & granularity: 5 years (2000–2004), monthly for Year 1 (buildout / ramp phase), quarterly thereafter.
  • Key drivers & assumptions:
  • Desktop/customer count ramp toward 100M target
  • ARPU (average revenue per user/desktop per month)
  • Network utilization rate (% of capacity sold)
  • Capex per unit of capacity deployed
  • Opex: network operations, support/settlement services as % of revenue
  • Partner revenue share or wholesale pricing to ISPs/enterprises
  • Parent company revenue ($31B Enron Corp.) - context only, not a model input
  • Scenarios (Base / Bull / Bear - which variables flex):
  • Base: gradual customer ramp, mid-range ARPU, 5-year path to breakeven
  • Bull: rapid enterprise adoption, higher ARPU from ePowered™ premium services, faster utilization fill
  • Bear: slow ramp, commoditized pricing pressure, higher capex overruns (relevant for a fiber network)
  • Required sheets / outputs:
  • Assumptions (all drivers centralized)
  • Revenue build (customers × ARPU, by segment if distinguishable)
  • Capex & network buildout schedule
  • Income Statement (5-year)
  • Cash Flow Statement (with capex / free cash flow)
  • Balance Sheet (simplified - capex-heavy asset base)
  • Sensitivity: ARPU × utilization rate

Frequently asked

Is the Enron financial model free?+

Yes. The Enron model is a free Excel (.xlsx) download with live formulas. Sign up with your email and the workbook is yours to keep, review, and edit.

What's included in the model?+

A 5-year monthly forecast with P&L, cash flow and runway, valuation (exit multiple plus a DCF cross-check), MOIC/IRR returns, and unit economics, with live formulas throughout.

How was this model built?+

It was built from Enron's pitch deck and publicly available information, then structured to investment-banking standards as a fully editable Excel model.

Can I change the assumptions?+

Yes. You can change assumptions and the live formulas will recalculate in the downloadable Excel model.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Go further

Build the financial model you need with Fina AI

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview
Career Principles

Learn Financial Modelling Skills with industry-leading Career Principles

Breaking into the finance industry? Explore courses in Excel, financial modeling, valuation, data analytics, and AI for business and finance.

Career Principles lesson on preparing a cash flow statement in Excel
Career Principles Financial Analyst Program
Career Principles Python for Data Analysis
Career Principles AI for Business and Finance course