Spreadsheet: louise_kitchen__24070__CashPlan_11
Sheet: PGG

Portland General Group
Sources & Uses of Cash - Dec 2001 thru Dec 2002
 |  | Week Ended |  |  |  |  |  |  |  |  |  | 2001 |  | 2002
 |  | 2001-12-08 00:00:00 |  | 2001-12-15 00:00:00 |  | 2001-12-22 00:00:00 |  | 2001-12-29 00:00:00 |  | 2001-12-31 00:00:00 |  | Dec |  | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC |  | TOTAL
Revenues (Cash) |  | 51.2 |  | 44.8 |  | 44.8 |  | 44.8 |  | 12.8 |  |  |  | 157.3652889885578 |  | 139.7775346190438 |  | 143.0480126811158 |  | 135.1713366326354 |  | 129.3205037515953 |  | 126.6841694054175 |  | 135.6888818700416 |  | 134.2818931783937 |  | 127.6516569068127 |  | 135.9718523125921 |  | 142.1038007411126 |  | 158.3302999423303
PRMA - Liquidations |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Customer Deposits/Broker Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Cost of Goods Sold |  | -34.5 |  | -30.2 |  | -30.2 |  | -30.2 |  | -8.59999999999998 |  |  |  | -92.20672627213541 |  | -77.59825103190103 |  | -80.82859702604168 |  | -66.02616778190102 |  | -65.51948018229167 |  | -69.36166068033853 |  | -75.01303847526042 |  | -77.43291429166668 |  | -72.56590807096353 |  | -69.65027252994793 |  | -70.66577950455729 |  | -75.93287513932292
"Gross Margin"
Operating Expenses
Severance |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Interest Expense |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Current Taxes |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dividend/Interest Income |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895 |  | 0.7895
Other Operating Income |  | -2.3 |  | -2 |  | -2 |  | -2 |  | -0.5794400033333318 |  |  |  | 1.850099097222222 |  | 1.850099097222222 |  | 1.850099097222222 |  | 1.850099097222222 |  | 1.850099097222222 |  | 1.850099097222222 |  | 1.850099097222222 |  | 1.822935763888889 |  | 1.822935763888889 |  | 1.819540347222222 |  | 1.816144930555556 |  | 1.812749513888889
Equity Distributions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Funds Flow |  | -0.4 |  | -0.3 |  | -0.3 |  | -0.3 |  | -0.2 |  |  |  | 2.613006599555515 |  | 2.683573324750462 |  | 2.646545165942829 |  | 2.583244659144437 |  | 2.647768729374299 |  | 2.780862812757995 |  | 3.471635730510631 |  | 3.5352154211404 |  | 3.557487420297743 |  | 3.567876146116536 |  | 2.193415126188903 |  | -0.4541307297427437
Merchant - Proceeds |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Merchant - Additions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Working Capital |  | 1.1 |  | 1 |  | 1 |  | 1 |  | 0.1603133404941648 |  |  |  | -41.69550522642272 |  | -9.068288004119776 |  | -37.8299187610042 |  | -55.96258194491189 |  | 24.44913096562283 |  | 15.48003764644299 |  | -54.24261176670701 |  | 91.72057741501085 |  | 7.88787820937678 |  | 40.55407128759501 |  | -53.89684594473647 |  | -1.597576070493147
Other |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1 |  | 0.1694134549471243 |  |  |  | -0.804981234474468 |  | -0.7276827680022109 |  | -0.743184845772916 |  | -0.700817047292702 |  | -0.6595145551656927 |  | -0.6134279308985633 |  | -0.48777264695795 |  | -0.4515900398606263 |  | -0.4172569315548884 |  | -0.6192670542195273 |  | -0.7861433788004604 |  | -0.8070434174082521
Other Operating cash
Proceeds on Sale of Assets |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Capital Expenditures |  | -4.8 |  | -4.2 |  | -4.2 |  | -4.2 |  | -1.2 |  |  |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667 |  | -17.70966666666667
Other Investing |  | 1.3 |  | 1.2 |  | 1.2 |  | 1.2 |  | 0.1999999999999993 |  |  |  | -1.735195015525524 |  | -1.812493481997783 |  | -1.79699140422706 |  | -1.83935920270729 |  | -1.880661694834293 |  | -1.926748319101432 |  | -2.052403603042027 |  | -2.08858621013938 |  | -2.122919318445099 |  | -1.920909195780486 |  | -1.754032871199551 |  | -1.73313283259174
Net Investing
PRMA - Prepay Settlements |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Repayment of Long-term Debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | -15 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dividends - Preferred Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Dividends - Common Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
[NAME] to Corp |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Treasury Stock Activity |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Off-Balance Sheet Refinancings |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Financing Outflows
Sub-Total
PRMA - Prepay Inflows |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
New Long-Term Debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Short-term Debt (net) |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Issuance of Stock |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Financing Inflows
Cash To / (From) Corp
Memo:
Operating Expenses (Cash)
Employee Related Expenses |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Operating Expenses |  | -8.4 |  | -7.4 |  | -7.4 |  | -7.4 |  | -2.119693833333336 |  |  |  | -28.03951434329469 |  | -27.94116661577787 |  | -28.02462795953831 |  | -27.9959409672241 |  | -28.01946483426548 |  | -28.05935662819007 |  | -28.77775531002463 |  | -28.78149557266992 |  | -28.72836838787944 |  | -28.82832844892951 |  | -28.88157687987678 |  | -28.72836838787945
Adjustments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Chapter 11 Reductions |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Transfers to NETCo. |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Net
 |  | -8.4 |  | -7.4 |  | -7.4 |  | -7.4 |  | -2.119693833333336
 |  | 0.26 |  | 0.22 |  | 0.22 |  | 0.22 |  | 0.09