Enron email

Algorithmic Indexing

27 Jul 2001, 15:57 UTC

Shortcut to CapEx Model

From
Kevin Hyatt kevin.hyatt@enron.com
To
Kimberly Watson, John Millar, Lindy Donoho, Lorraine Lindberg, TK Lohman, Michelle Lokay, Audrey Robertson
Cc
Eric Gadd, Steven Harris
Bcc
Eric Gadd, Steven Harris
Date
Fri, 27 Jul 2001 08:57:18 -0700 (PDT)
With Rod Hayslett's help, I put together an easy excel spreadsheet we can use to quickly evaluate capital investment projects.  It is set up for pipelines but can be modified for power development too.  If you add the inputs in the "yellow" boxes, the model can calcluate the rate you need to make the project viable.  

You can change the debt/equity ratios, targeted ROE, and whether the project is new greenfield development or expansion of existing assets.

Let me know if you have questions.
kh

Click the link below to access the spreadsheet.  I also put a copy in the Asset Development file folder.
 
 P:\Marketing\TW_NNG\TW Desk\CapEx Model.xls