Spreadsheet: lindy_donoho__22182__SoCalIntCalc
Sheet: Sheet1 (2)

 | Amount | Totals
Month | in Dispute | by Month | Interest Rate | Interest
1996-11-01 00:00:00 | 35639.58
1996-11-01 00:00:00 | 2982.09 |  | 0.0068
1996-12-01 00:00:00 | 715.66
1996-12-01 00:00:00 | 3825
1996-12-01 00:00:00 | 20698.23
1996-12-01 00:00:00 | 13857.65 |  | 0.007
1997-01-01 00:00:00 | 4743
1997-01-01 00:00:00 | 76.5
1997-01-01 00:00:00 | 18968.72
1997-01-01 00:00:00 | 17683.44 |  | 0.007
1997-02-01 00:00:00 | 27990.81
1997-02-01 00:00:00 | 9515.91 |  | 0.0063
1997-03-01 00:00:00 | 32973.72
1997-03-01 00:00:00 | 8091.81 |  | 0.007
1997-04-01 00:00:00 | 36480.35
1997-04-01 00:00:00 | 4202.04 |  | 0.0068
1997-05-01 00:00:00 | 37603.4
1997-05-01 00:00:00 | 2341.81 |  | 0.007
1997-06-01 00:00:00 | 36191.27
1997-06-01 00:00:00 | 1885.71 |  | 0.0069
1997-07-01 00:00:00 | 29958.14
1997-07-01 00:00:00 | 11129.83 |  | 0.0072
1997-08-01 00:00:00 | 24571.34
1997-08-01 00:00:00 | 17143.64 |  | 0.0072
1997-09-01 00:00:00 | 17171.28
1997-09-01 00:00:00 | 21795.76 |  | 0.0069
1997-10-01 00:00:00 | 36283.46
1997-10-01 00:00:00 | 6563.28 |  | 0.0072
1997-11-01 00:00:00 | 28201.34
1997-11-01 00:00:00 | 9456.983 |  | 0.007
1997-12-01 00:00:00 | 17504.03
1997-12-01 00:00:00 | 9486.32 |  | 0.0072
1998-01-01 00:00:00 | 34788.56
1998-01-01 00:00:00 | 4528.66 |  | 0.0072
1998-02-01 00:00:00 | 18491.87
1998-02-01 00:00:00 | 18751.11 |  | 0.0065
1998-03-01 00:00:00 | 33086.5
1998-03-01 00:00:00 | 6998.83 |  | 0.0072
1998-04-01 00:00:00 | 38017.62
1998-04-01 00:00:00 | 1430.49
1998-04-01 00:00:00 | 406.83 |  | 0.007
1998-05-01 00:00:00 | 38659.06
1998-05-01 00:00:00 | 2027.07 |  | 0.0072
1998-06-01 00:00:00 | 36269.4
1998-06-01 00:00:00 | 1713.72
1998-06-01 00:00:00 | 618.51 |  | 0.007
1998-07-01 00:00:00 | 20480.09
1998-07-01 00:00:00 | 20906.94 |  | 0.0072
1998-08-01 00:00:00 | 36591.82
1998-08-01 00:00:00 | 3216.71 |  | 0.0072
1998-09-01 00:00:00 | 32274.69
1998-09-01 00:00:00 | 6497.35 |  | 0.007
1998-10-01 00:00:00 | 34225.15
1998-10-01 00:00:00 | 1849.78 |  | 0.0072
1998-11-01 00:00:00 | 39147.4 |  | 0.007
1998-12-01 00:00:00 | 42354.03 |  | 0.0072
1999-01-01 00:00:00 | 43185.33 |  | 0.0069
1999-02-01 00:00:00 | 39097.37 |  | 0.0063
1999-03-01 00:00:00 | 41489.31
1999-03-01 00:00:00 | 2002.5 |  | 0.0069
1999-04-01 00:00:00 | 49039.05
1999-04-01 00:00:00 | 115.31 |  | 0.0064
1999-05-01 00:00:00 | 48265.27
1999-05-01 00:00:00 | 130.97
1999-05-01 00:00:00 | 174.62
1999-05-01 00:00:00 | 600 |  | 0.0066
1999-06-01 00:00:00 | 42416.78 |  | 0.0064
1999-07-01 00:00:00 | 44132.91 |  | 0.0066
1999-08-01 00:00:00 | 43640.36 |  | 0.0066
1999-09-01 00:00:00 | 42416.65 |  | 0.0064
1999-10-01 00:00:00 | 44319.95 |  | 0.0068
1999-11-01 00:00:00 | 45699.42 |  | 0.0065
1999-12-01 00:00:00 | 47310.94 |  | 0.0068
2000-01-01 00:00:00 | 47018.51
2000-01-01 00:00:00 | 320 |  | 0.007
2000-02-01 00:00:00 | 44084.48
2000-02-01 00:00:00 | 200 |  | 0.0066
2000-03-01 00:00:00 | 51828.25 |  | 0.007
2000-04-01 00:00:00 | 40635.95 |  | 0.007
2000-05-01 00:00:00 | 46607.72 |  | 0.0073 |  |  |  |  |  | .
2000-06-01 00:00:00 | 43796.64 |  | 0.007
2000-07-01 00:00:00 | 45280.4 |  | 0.0076 |  |  | (50% of principal Nov, 1996 - July, 2000)
2000-08-01 00:00:00 | 45027.46 |  | 0.0076 |  |  | 0.0076
2000-09-01 00:00:00 | 42450.18 |  | 0.0074 |  |  | 0.0074
2000-10-01 00:00:00 | 43792.73 |  | 0.0081 |  |  | 0.0081
2000-11-01 00:00:00 | 48689.7 |  | 0.0078 |  |  | 0.0078
2000-12-01 00:00:00 | 50241.81 |  | 0.0081 |  |  | 0.0081
2001-01-01 00:00:00 | 49987.46 |  | 0.0081 |  |  | 0.0081
 |  | (Retro billed March 20, 2001) |  |  |  |  |  | Interest Aug, 2000 - Jan, 2001
2001-02-01 00:00:00 | 44931.54 |  | 0.0073 |  |  | 0.0073
2001-03-01 00:00:00 | 49623.5 |  | 0.0081 |  |  | 0.0081
2001-04-01 00:00:00 | 47715.96 |  | 0.0074 |  |  | 0.0074
2001-05-01 00:00:00 | 48145.57 |  | 0.0076 |  |  | 0.0076
2001-06-01 00:00:00 | 48653.71 |  | 0.0074 |  |  | 0.0074
2001-07-01 00:00:00 | 50013.5 |  | 0.0066 |  |  | 0.0066
2001-08-01 00:00:00 | 49723.05 |  | 0.0066 |  |  | 0.0066
2001-09-01 00:00:00 | 47737.68 |  | 0.0064 |  |  | 0.0064
2001-10-01 00:00:00 | 50268.16 |  |  |  |  | 0.0058
 |  |  |  |  |  |  |  | Interest Feb, 2001 - Oct, 2001
12 Month Ave
 | SoCal Settlement Options:
 |  |  |  | [NAME]-active Amount 50/50 |  | 6 Months Back
 |  |  |  | & No Interest |  | & No Interest
 |  |  | Amt in Dispute | SoCal Pays | TW Gives Up | SoCal Pays | TW Gives Up
 | Nov, 1996 - Jan, 2001 Revenue
 | Nov, 1996 - Jan, 2001 Interest
 | Feb, 2001 - Oct, 2001 Revenue
 | Feb, 2001 - Sep, 2001 Interest
 |  | Total
 |  |  | Amt in Dispute | SoCal Pays | TW Gives Up
 | Nov, 1996 - July, 2000 Revenue
 | Nov, 1996 - July, 2000 Interest
 | Aug, 2000 - Jan, 2001 Revenue
 | Aug, 2000 - Jan, 2001 Interest
 | Feb, 2001 - Oct, 2001 Revenue
 | Feb, 2001 - Oct, 2001 Interest
 |  | Total
 | SoCal pays 50% of revenue prior to 6 months back (Nov, 1996 - July, 2000).
 | TW waives 50% of revenue prior to 6 months back.
 | TW waives interest prior to 6 months back.
 | SoCal pays total revenue 6 months back.
 | SoCal pays total interest 6 months back (calculated starting with 50% principal Nov, 1996 - July, 2000).
 | SoCal pays total revenue Feb, 2001 - Oct, 2001.
 | SoCal pays total interest Feb, 2001 - Oct, 2001.
 | SoCal pays escalated settlement rate going forward.