Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: SrDebt

 |  | Project Year |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Senior Debt
 | Total Net Operating Cash - Calendar Year
 | Total Net Operating Cash - Project Year
 | TRANCHE A |  | Weight
 | Cash Available for SR Debt -- Project Year
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Target Coverage Ratios
 | Actual Coverage Ratios
 | Interest
 | PVF
 | Cash Available for Coverage
 | Cash Used for SR Debt
 | PV
 | Total PV + Fine Tuner
 | Target Term |  |  |  |  |  | Actual Term
 | Cash Available for Coverage | Weight
 | 1st S.A. Repayment Period
 | 2nd S.A. Repayment Period
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Project Start Date
 | Days in Period
 | Beginning Loan Balance
 | Interest
 | Principal
 | Ending Balance
 | First Payment Date
 | Days in Period
 | Mid-Year Loan Balance
 | Interest
 | Principal
 | Ending Balance
 | Second Payment Date
 | Counter Beginning Period
 | Counter Mid Year
 | Average Life
 | PROJECT YEAR TRANCHE A
 | Annual Interest Payment
 | Annual Principle Payment
 | Total P & I Payment
 | ADJUSTMENT FOR CALENDAR YEAR TRANCHE A
 | TRANCHE B |  | Weight
 | Cash Available for SR Debt -- Project Year
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Target Coverage Ratios
 | Actual Coverage Ratios
 | Interest
 | PVF
 | Cash Available for Coverage
 | Cash Used for SR Debt
 | PV
 | Total PV + Fine Tuner
 | Target Term |  |  |  |  |  | Actual Term
 | Cash Available for Coverage | Weight
 | 1st S.A. Repayment Period
 | 2nd S.A. Repayment Period
 |  |  | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Project Start Date
 | Days in Period
 | Beginning Loan Balance
 | Interest
 | Principal
 | Ending Balance
 | First Payment Date
 | Days in Period
 | Mid-Year Loan Balance
 | Interest
 | Principal
 | Ending Balance
 | Second Payment Date
 | Counter Beginning Period
 | Counter Mid Year
 | Average Life
 | PROJECT YEAR TRANCHE B
 | Annual Interest Payment
 | Annual Principle Payment
 | Total P & I Payment
 | ADJUSTMENT FOR CALENDAR YEAR TRANCHE B
 | PROJECT YEAR TOTAL
 | Beginning Loan Balance
 | Annual Interest Payment
 | Annual Principle Payment
 | Ending Loan Balance
 | Total P & I Payment
 | TOTALS TO MODEL
 | CALENDAR YEAR TRANCHE A
 | Beginning Balance
 | Total Annual Interest
 | Total Annual Principle
 | Ending Balance
 | CALENDAR YEAR TRANCHE B
 | Beginning Balance
 | Total Annual Interest
 | Total Annual Principle
 | Ending Balance
 | CALENDAR YEAR TOTAL
 | Beginning Balance
 | Total Annual Interest
 | Total Annual Principle
 | Ending Balance
 | NOTE: Calendar Year Totals are hooked to rest of model by default. During Debt and Equity closing, Project Year totals may more accurately reflect the timing of cash flows