Loading...
HomeMy WebLinkAboutBradley Overview of Budget Changes Between FY10 and FY11OVERVIEW OF BUDGET CHANGES BETWEEN FY10 AND FY11 FY10 Utility Contributions 17,645,106 DECREASES Schedule A Increase in projected interest earnings 15,347 Decrease in R&C Fund Repayment - Note 1 823,628 Decrease in projected arbitrage transfer 100,000 TOTAL DECREASES 938,975 INCREASES Schedule A Increase in Non R&C Capital - See A1 for detail 126,804 Increase in Operating Reserve due to increased operating budget 6,700 Increase in debt service 3,000 Schedule B 540-FERC Land Use Fee 315,000 544-Maintenance of Electric Plant 73,061 920-FERC Part 12 Inspection 75,000 Other increases off set by decreases 51,721 TOTAL INCREASES 651,286 FY11 Utility Contributions 17,357,417 17,357,417 0 Note 1 Decrease projected because FY10 was last year to pay for governor & runner projects. BRADLEY LAKE HYDROELECTRIC PROJECT Schedule A REVENUES, EXPENSES & CHANGES IN SURPLUS REVENUE: UTILITY CONTRIBUTIONS INTEREST INCOME OTHER MISC INCOME EXPENSES OPERATIONS RENEWALS/REPLACEMENTS (R&C FUND REPAYMENTS) NON R&C FUND CAPITAL PURCHASES-SEE A1 TRANSFER TO (FROM) OPERATING RESERVE DEBT SERVICE (net of Capital Reserve Reductions) ARBITRAGE TRANSFER CURRENT YEAR SURPLUS (DEFICIT) BEGINNING SURPLUS (DEFICIT) ENDING SURPLUS (DEFICIT) BALANCE SHEET ASSETS REVENUE FUND OPERATING FUND RECEIVABLE FROM UTILITIES OTHER RECEIVABLES PREPAID EXPENSES LIABILITIE: LIABILITIES PREPAID UTILITY CONTRIBUTION PAYABLE TO UTILITIES R&C REPAYMENT IRPLUS OTHER INFORMATION OPERATING RESERVE * MONTHLY CONTRIBUTIONS * Required to be 20% of budgeted operating expense 3/23/20103:05 PMC:\Documents and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1 BradleyBdgt-original-send2.xlsSchedule A-Budget Summary FY2008 FY2009 FY2010 FY2011 INC(DEC) ACTUALS ACTUALS BUDGET BUDGET FROM PY 15,649,321 16,596,797 17,645,106 17,357,417 (287,689) 1,776,916 1,717,303 1,652,616 1,667,963 15,347 0 1,000 0 0 0 0 0 0 0 0 17,426,237 18,315,100 19,297,722 19,025,380 J (272,342) 3,259,328 4,123,107 4,024,112 4,514,345 490,233 1,456,372 1,425,893 1,912,264 1,088,636 J (823,628) 117,728 166,573 675,196 802,000 126,804 48,000 5,000 66,000 97,250 31,250 12,269,850 12,268,950 12,270,150 12,273,150 3,000 274,959 325,577 350,000 250,000 f (100,000) 0 oO 0 0 17,426,237 18,315,100 19,297,722 19,025,380 J (272,342) 0 0 0 0 0 0 1,531,244 821,997 17,929 1,851,848 447,324 0 15,077 9,132 eoo0no 274,170 2,323,381 643,508 260,757 0 - 0 0 280,290 740,267 0 1,447,372 1,322,357 0 2,371,170 2,323,381 o 686,400 1,320,652 734,406 1,383,066 739,400 902,652 1,406,795 1,446,451 ALASKA ENERGY AUTHORITY BRADLEY LAKE HYDROELECTRIC PROJECT Schedule A-1 CAPITAL PURCHASES NOT FUNDED BY R&C FUND CULVERT REPAIRS AMBULANCE TRUCK, MOWER ATTACH, MILLING MACHINE FIRE WATER CONTROL VALVE_REPLACEMENT CATHODIC PROTECTION REPLACEMENT. HALCON FIRE SYSTEM REPLACEMENT MAN-LIFT, TRUCK & PLOW ATTACHMENT EMERGENCY BACKUP BATTERIES Purchase FW relief valve RV-8*** Grating in Transformer pits Acquire, develop Work Management System Procure spare facilities transformer Purchase small forklift w/ outside capability Modify Camp Residencies--add efficiency apartments Excavator w/ mower attachment Vehicle Lift Emergency/Standby Facilities Diesel Generator ‘Snow Cat with plow Replace Office Furniture Replace Furniture/Lockers/Appliances in Crew Quarters \Vidmar Storage Cabinets for Shops & Warehouse Shop Tools Test Equipment New Equipment Storage Barn for Heavy Equipment and Long Term Outage Equipment. Replace Telephone System / Upgrade Network FY2008 FY2009 FY2010 FY2011 ACTUALS ACTUALS BUDGET BUDGET , | © ce) 7 = s S > 2 So o So 1G D> 58,61 2 29,0. 116,78: 63,59: Current valve is leaking by because of problems the control which will be replaced shortly. The set point has been raised from the original 135psi to 170psi as a work around due to control valve. Operation of a firewater system at these pressures is outside current code requirements Safety implications during Nitrogen addition to the transformers Process improvement in work control, scheduling, PM optimization, materials inventory & icomponent database ‘Two transformers have failed leading to a fire and loss of power to the non-power house facilities. Since the cause of the failures is really unknown, we could be at risk for a repeat failure. Last failure cost >100K O&D says buy it. oe A need based on the movement of smaller items into and out of the warehouse and Power House which cannot be performed with the big loader. This will effectively modify the two duplexes from a 2 dwelling unit to a 4 dwelling unit; this will 250,000}help support space availability for an apprentice position-FY10 and complete 3 duplex units in FY11 40,001 @ 2 ° 2 N nS a ° 3 220.000 iii Needed for tail race repair, ditch and riprap maintenance, brush removal at the dam and other areas Current lift original design and placement does not-allows vehicles to be serviced unless the tere roll up door is open--this is a problem in winter and fowl weather [An emergency source of power is needed to provide backup power in case of future trouble 150,000} with the normal facilities power. This will provide cost savings for replacement power and repairs due to frozen pipes. Replace snow machines to enhance safe travel to the dam and gate house areas. Allows operators and contractors to travel to the dam in a sheltered environment which will increase ° S ° S Ss safety in case of breakdown. Also, allows transport of equipment, parts, and tools to perform repairs at the dam. This could save lots of $$$ if generation was affected. 20,000] Furniture is original furniture and needs to be updated. 32.000] Furniture and beds are aged and in need of repairs and replacement. Several appliances : need replacement. 40,001 50,001 35,001 0} |A covered storage area is needed to protect heavy equipment and long term outage equipment and parts from further degradation. ‘Telephone system and network are obsolete and unreliable. Need to replace phone switch 10,000} and some phone lines. Also, add voicemail capability. Integrate phone system with HEA Homer phone system to reduce phone company charges, ~ a Slsis 'S g S| A 11 166,573 675,196 802,000 BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B 31-Dec-09 FY2009 FY2009 FY2010 FY2010 FY2011 BUDGET ACTUAL VARIANCE BUDGET ACTUAL BUDGET SUMMARY (A) HEA Annual Operations & Maintenance 1,932,339 1,831,960 100,379 1,968,817 795,915 2,181,514 (B) CEA Dispatch and Substation/SVC Maintenance 70,500 229,627 (159,127) 80,000 47,821 119,327 (C) Other O&M and Maintenance Projects 437,540 877,910 (440,370) 735,242 228,336 918,540 (D) Insurance Costs 642,270 596,196 46,074 644,203 540,962 615,340 (E) Regulatory Costs 355,000 266,823 88,177 329,900 15,730 413,674 (H) Contingencies 0 59,393 (59,393) 0 0 0 3,437,649 3,861,909 (424,260) 3,758,162 1,628,764 4,248,395 (F) Administrative Costs 259,500 261,196 (1,696) 265,950 229,626 265,950 3,697,149 4,123,105 (425,956) 4,024,112 1,858,390 4,514,345 (G) BUDGET ADJUST ESTIMATE 0 0 0 0 0 0 |___ 3,697,149 4,123,105 (425,956) 4,024,112 1,858,390 | 4,514,345 3/23/2010 3:06 PM Raotwhénts and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1BradleyBdgt-original-send2.xlsSchedule B-Budget Detail BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B FERC 535 - Operation Supervision & Engineering (A) HEA O&M Contract (C) HEA Perform Exciter Stability Study (C) HEA Digitize & Control Project Drawings FERC 537 - Hydraulic Expenses (A) HEA O&M Contract FERC 538 - Electric Expenses (A) HEA O&M Contract (C) HEA Clean Generators #1 & #2 (A) HEA O&M Contract (C) Repair Microwave Tower Waveguide (C) HEA Circuits and Radio - To Bernice Lake (C) CEA Circuits -Bernice Lake to Anchorage FERC 540 - Rents (C) Bradley Lake FERC land use fees (5% increase b FERC 541 - Maintenance Supervision & Engineering (A) HEA O&M Contract FERC 542 - Maintenance of Structures (A) HEA O&M Contract (C) Architect Review (09) - Structure Maintenance (11 (C) Replace Haylon w/ FM-200 in Oil Separator RM (A) HEA O&M Contract FERC 539 - Misc. Hydraulic Power Generation Expenses FERC 543 - Maintenance of Reservoirs, Dams & Waterways 31-Dec-09 FY2009 FY2009 FY2010 FY2010 FY2011 BUDGET ACTUAL VARIANCE BUDGET ACTUAL BUDGET 226,274 187,036 39,238 237,941 122,336 250,283 0 0 40,000 25,138 0 0 0 0 L 226,274 187,036 39,238 277,941 147,474 250,283 71,159 47,347 23,812 75,698 26,121 92,619 71,159 47,347 23,812 75,698 26,121 92,619 | 191,122 195,305 (4,183) 193,733 73,059 201,203 0 0 0 50,000 0 0 191,122 195,305 | (4,183) 243,733 73,059 201,203 382,016 327,079 54,937 420,059 177,085 427,785 0 0 0 0 0 20,000 0 90,000 (90,000) 90,000 45,000 90,000 0 28,746 (28,746) 30,000 14,373 30,000 382,016 445,825 (63,809) 540,059 236,458 567,785 | | 65,000 378,141 (313,141) 65,000 0 380,000 65,000 378,141 (313,141) 65,000 0 L 380,000 125,283 142,863 (17,580) 120,000 72,813 126,000 L 125,283 142,863 (17,580) 120,000 72,813 126,000 45,809 39,554 6,255 113,641 45,505 105,339 30,000 11,669 18,331 0 0 45,000 0 oO} 0 30,000 0 0 L 75,809 51,223 24,586 | 143,641 45,505 150,339 29,023 99,389 (70,366) 27,095 16,587 77,498 3/23/2010 3:06 PM Rageo2tmhénts and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1BradleyBdgt-original-send2.xisSchedule B-Budget Detail BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B 31-Dec-09 FY2009 FY2009 FY2010 FY2010 FY2011 BUDGET ACTUAL VARIANCE BUDGET ACTUAL BUDGET (C) Trailer Mounted Sewer Cleaner 0 47,472 (47,472) 0 0 0 (C) Power Tunnel Maintenance 30,000 13,632 16,368 0 0 15,000 (C) Repairs. Cleaning & Inspections 0 0 0 90,000 9,344 0 (C) North Fork Comm Equipment Replacement 0 0 0 0 0 5,000 (C) 0 0 0 0 0 0 L 59,023 160,493 (101,470) 117,095 25,931 97,498 FERC 544 - Maintenance of Electric Plant (A) HEA O&M Contract 285,004 415,547 (130,543) 296,763 169,699 359,824 (C) Maint. Study (09)-Replace Control Room Console 40,000 27,841 12,159 0 0 10,000 iE 325,004 443,388 (118,384) 296,763 169,699 369,824 FERC 545 - Maintenance of Misc. Hydraulic Plant (A) HEA O&M Contract 178,019 73,196 104,823 110,000 74,966 148,909 (C) Transfer Switch for PT Gatehouse 0 0 0 0 0 5,000 (C) Fish Water Design & Middle Fork Equip. Shack | 0 0 0 55,000 14,150 20,000 178,019 73,196 104,823 165,000 89,116 173,909 FERC 556 - System Control & Load Dispatching (A) HEA O&M Contract 49,195 51,482 (2,287) 51,237 16,204 63,444 (A) HEA-Power House PCs & Develop Electronic Ops| 0 0 0 20,000 1,540 15,000 (C) SCS Snow Measurement 9,000 16,769 (7,769) 9,000 10,481 9,270 (C) UAA Seismic monitoring and reporting 56,500 56,500 0 56,500 0 56,500 (C) USGS Streamguaging 207,040 207,040 0 219,642 109,750 232,670 (C) State of Alaska Permits 0 100 (100) 100 100 100 321,735 331,891 (10,156) 356,479 138,075 376,984 FERC 562 - Station Expenses (B) CEA SVC/Substation Maintenance Contract 70,500 229,627 (159,127) 80,000 47,821 119,327 (C) 0 0 0 0 0 0 70,500 229,627 (159,127) 80,000 47,821 119,327 | FERC 571 - Maintenance of Overhead Lines (A) HEA Overhead Line Maintenance 349,435 253,162 96,273 302,650 0 313,610 349,435 253,162 96,273 302,650 0 djgii 313,610 (H) Contingencies 0 59,393 [ (59,393) 0 0 0 3/23/2010 3:06 PM Rag@oeufénts and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1 BradleyBdgt-original-send2.xlsSchedule B-Budget Detail BRADLEY LAKE OPERATIONS & MAINTENANCE SCHEDULE B 31-Dec-09 FY2009 FY2009 FY2010 FY2010 FY2011 BUDGET ACTUAL VARIANCE BUDGET ACTUAL BUDGET FERC 920 - Administrative Expense (F) AEA Admin Fee 200,000 200,000 0 200,000 200,000 200,000 AEA Administrative Costs 200,000 200,000 0 200,000 200,000 200,000 PMC Costs (F) Bradley Lake Audit fees 9,500 12,750 (3,250) 15,950 12,750 15,950 (F) Bradley Lake PMC Legal 25,000 25,677 (677) 25,000 2,904 25,000 (F) Bradley Lake Arbitrage Report 5,000 5,175 (175) 5,000 5,175 5,000 (F) Bradley Lake Trustee fees 20,000 17,594 2,406 20,000 8,797 20,000 (F) PMC Costs 59,500 61,196 (1,696) 65,950 29,626 65,950 Bond Refunding Costs Reimburseable costs «| Refunding Costs 0 0 0 0 0 TOTAL FERC 920 259,500 261,196 (1,696) 265,950 229,626 265,950 FERC Insurance Premiums 578,000 545,300 32,700 572,565 516,193 542,003 (D) Homer Electric Insurance 49,270 49,239 31 56,638 24,769 58,337 (D) Risk Assessment 15,000 1,657 13,343 15,000 0 15,000 642,270 596,196 | 46,074 644,203 540,962 615,340 FERC FERC administrative fees 200,000 184,249 15,751 229,900 0 202,674 (E) FERC Part 12 Inspection 0 0 0 0 0 75,000 (E) 0 0 0 (E) Contractual Engineer - FERC license issues 155,000 82,574 72,426 100,000 15,730 136,000 355,000 266,823 | 88,177 329,900 15,730 413,674 | 3,697,149 4,123,105 | (425,956)| L 4,024,112 1,858,390 4,51 4,345 | TOTAL BRADLEY LAKE BUDGET 3/23/2010 3:06 PM Ragotwhénts and Settings\mciark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1BradleyBdgt-original-send2.xlsSchedule B-Budget Detail BRADLEY LAKE MONTHLY UTILITY CONTRIBUTION SCHEDULE C ORIGINAL ACTUAL BUDGET PERCENT FY2009 FY2010 FY2011 FY2011 POWER PURCHASER SHARE TOTAL TOTAL TOTAL INCREASE CHUGACH ELECTRIC 30.4% 5,045,424 5,364,108 5,276,652 (87,456) MUNICIPALITY OF ANCHORAGE 25.9% 4,298,568 4,570,080 4,495,572 (74,508) AEG&T-HEA 12.0% 1,991,616 2,117,412 2,082,888 (34,524) AEG&T-MEA 13.8% 2,290,356 2,435,028 2,395,320 (39,708) GOLDEN VALLEY ELECTRIC 16.9% 2,804,856 2,982,024 2,933,400 (48,624) CITY OF SEWARD 1.0% 165,972 176,448 173,580 (2,868) Rounding 2 2 5 100.0% _ 16,596,794 17,645,102 287,688 ACTUAL BUDGET FY2009 FY2010 PERCENT MONTHLY MONTHLY FY2011 FY2011 POWER PURCHASER SHARE AVERAGE AVERAGE MONTHLY | INCREASE CHUGACH ELECTRIC 30.4% 420,452 447,009 439,721 (7,288) MUNICIPALITY OF ANCHORAGE 25.9% 358,214 380,840 374,631 (6,209) AEG&T-HEA 12.0% 165,968 176,451 173,574 (2,877) AEG&T-MEA 13.8% 190,863 202,919 199,610 (3,309) GOLDEN VALLEY ELECTRIC 16.9% 233,738 248,502 244,450 (4,052) CITY OF SEWARD 1.0% 13,831 14,704 14,465 (239) 100.0% 1,383,066 1,470,425 1,446,451 23,974 3/23/20103:06 PM C:\Documents and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\2011BradleyBdgt-original-send2.xlsSchedule C Utility Contrib BRADLEY LAKE R&C FUND DISBURSEMENTS AND REPAYMENTS SCHEDULE D Description R&C FUND PROJECTS (Governor Replace RFLS Replace Runners Replace cable from dam to power house Replace power system stabilizer Replace two RTUs Culvert Repairs Trans Towers Frost Jacking Repairs Replace Plant and SCADA Controls Integrated Power System Stabilizer Vibration Monitoring System Current Year R&C Repayment Adjust for Current Year Budget Less Interest in Fund Applied to Repayment Net Transfer from Revenue Fund (Cumulative Prior Years R&C Repayments Actual TO REPAY at 06/30/08 2,615,592.73 251,092.69 1,789,524.99 2,349,392.56 0.00 46,132.84 0.00 0.00 0.00 0.00 0.00 0.00 7,051,735.81 Actual Disburse 0.00 0.00 157,208.00 10,887.92 11,311.49 24,364.95 34,833.79 0.00 0.00 0.00 0.00 238,606.15 R&C Cumulative Interest (Retained) Applied As Part of Repayment NET DUE TO R&C FUND R&C FUND CASH FLOW PROJECTION Beginning Investment Balance Disbursements-current year Disbursements-prior year accrued Utilities' R&C Repayment Current year interest earnings [Accrued R&C Payable at year end Ending Investment Balance PROJECTED NET DUE + ENDING INVESTMENT BALANCE REPAYMENT AMOUNT $1,649,677 X 25% $4,139,810 X 25% $1 ,262,248.49 X 25% $238,606.15 X 25% "$235,000 X 25% "$2,618,689 X 25% Actual TO REPAY at 06/30/09 2,615,592.73 251,092.69 1,946,732.99 2,360,280.48 11,311.49 70,497.79 34,833.79 0.00 0.00 0.00 0.00 0.00 7,290,341.96 1,322,357.35 124,433.32 0.00 2,331,070.41 5,000,000.00 412,419.38 1,034,952.45 315,562.12 59,651.54 0.00 0.00 1,822,585.49 Projected Disburse 0.00 0.00 0.00 0.00 10,000.00 25,000.00 200,000.00 0.00 0.00 0.00 0.00 0.00 235,000.00 PROJECTED TO REPAY at 06/30/10 2,615,592.73 251,092.69 1,946,732.99 2,360,280.48 21,311.49 95,497.79 234,833.79 0.00 0.00 0.00 0.00 0.00 7,525,341.96 1,438,880.64 2,331,070.41 (235,000.00) (52,576.04) 1,301,459.82 216,165.17 0.00 3,561,119.36 5,000,000.00 1,034,952.45 315,562.12 59,651.54 58,750.00 0.00 1,468,916.11 PROJECTED Disburse 0.00 0.00 0.00 0.00 118,689.00 0.00 100,000.00 1,200,000.00 400,000.00 500,000.00 300,000.00 0.00 2,618,689.00 0.00 PROJECTED TO REPAY at 06/30/11 2,615,592.73 251,092.69 1,946,732.99 2,360,280.48 140,000.49 95,497.79 334,833.79 1,200,000.00 400,000.00 500,000.00 300,000.00 0.00 10,144,030.96 2,647 ,122.45 3,561,119.36 (2,600,000.00) 0.00 1,252,750.94 139,007.25 0.00 2,352,877.55 5,000,000.00 0.00 315,562.12 59,651.54 58,750.00 654,672.25 1,088,635.91 3/23/20103:06 PM C:\Documents and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1BradleyBdgt-original-send2.xisSchedule D R&C Disb & Repay BRADLEY LAKE BUDGET PROJECTED CASH FLOW BY FUND SCHEDULE G Rev Fund O&M Fund Debt Fund Op Reserve R&C Cap Reserve Total FY2010 Budget Revenues 17,645,106 - 17,645,106 Interest 1,562,616 216,165 1,778,781 Transfer back interest - - Transfers to O&M (4,024,112) 4,024,112 - - Transfers to Debt Service (12,270,150) 12,270,150 - Payback of R&C Fund (1,301,460) 1,301,460 - 2009 Payables (1,320,313) (445,820) - (1,766,133) 2010 O&M Requisitions (4,024,112) (4,024,112) 2010 Capital Requistions (675,196) 675,196 - (52,576) (52,576) Renewals/Replacements (675,196) - (235,000) - (910,196) To Excess Earnings fund (350,000) (350,000) Payment of Prior Year Deficit - - Debt Payments (12,270,150) (12,270,150) Increase Op Reserve (66,000) 66,000 2 6/30/2010 Projected Balance 1,167,263 - - 805,402 3,561,119 12,834,000 18,367,784 A FY2011 Budget - Revenues 17,357,417 - 17,357,417 Interest 1,528,956 139,007 1,667,963 Transfer back interest - - Transfers to O&M (4,514,345) 4,514,345 - - Transfers to Debt Service (12,273,150) 12,273,150 - Payback of R&C Fund (1,252,751) 1,252,751 - O&M Requisitions (4,514,345) (4,514,345) Capital Requistions (802,000) 802,000 - - - Renewals/Replacements (802,000) - (2,600,000) - (3,402,000) To Excess Earnings fund (250,000) (250,000) Payment of Prior Year Deficit - - Debt Payments (12,273,150) (12,273,150) Increase Op Reserve (97,250) 97,250 : 6/30/2011 Projected Balance 864,140 - - 902,652 2,352,877 12,834,000 16,953,669 Assumption: should be 20.00% For purpose of budget cash flows, July 01 debt service projected 20.00% is assumed to be disbursed on June 30 3/23/20103:14 PM C:\Documents and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1BradleyBdgt-original-send2.xIsSchedule G-Cash balances BRADLEY LAKE BUDGET PROJECTED INTEREST INCOME SCHEDULE | TOTAL Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 OTHER ADJ Beginning Balance 18,367,783.96 18,367,783.96 19,802,408.17 —_20,071,521.37 —20,626,637.57 — 21,226,753.77 —_21,931,869.97 —20,231,961.17 22,137,907.95 23,341,024.15 24,471,140.35 25,166,256.55 26,093,698.75 26,112,319.44 Receipts Utility Contributions 17,357,416.56 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,451.00 1,446,455.00 0.56 ADJ INTEREST Interest Income Received 1,667,963.02 679,608.01 100.00 100.00 100.00 100.00 100.00 761,930.58 100.00 100.00 100.00 100.00 100.00 (ZZSRAZAAaE TO ACCRUAL BASIS Equipment Sale 0.00 0.00 0.00 Repay Prior Year Deficit 0.00 0.00 19,025,379.58 2,126,059.01 1,446,551.00 1,446,551.00 1,446,551.00 1,446,551.00 1,446,551.00 2,208,381.58 1,446,551.00 1,446,551.00 1,446,551.00 1,446,551.00 1,446,555.00 225,424.99 Disbursements Prior year accrued expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 O & M Expenses (4,514,344.60) (441,434.80) (777,437.80) (241,434.80) (296,434.80) (241,434.80) (257,384.80) (302,434.80) (241,434.80) (241,434.80) (676,434.80) (444,108.80) (352,934.80) R&C Fund Disbursement-Sch D (2,599,999.51) 0.00 (400,000.00) (400,000.00) (400,000.00) (400,000.00) 0.00 0.00 0.00 0.00 0.00 0.00 (999,999.51) Debt Service Payment (12,273,150.00) 0.00 0.00 0.00 0.00 0.00 (2,889,075.00) 0.00 0.00 0.00 0.00 0.00 0.00 (9,384,075.00) ASSUME DEBT service SCH A Capital (802,000.00) 0.00 0.00 (250,000.00) (150,000.00) (100,000.00) 0.00 0.00 (2,000.00) (75,000.00) (75,000.00) (75,000.00) (75,000.00) 0.00 Excess Earnings Transfer (250,000.00) (250,000.00) 0.00 0.00 0.00 ¢ djustment-Equal Sch G 0.00 (20,439,494.11) (691,434.80) _(1,177,437.80) (891,434.80) (846,434.80) (741,434.80) (3,146,459.80) (302,434.80) (243,434.80) (316,434.80) (751,434.80) (519,108.80) _(1,427,934.31) _ (9,384,075.00) Adjust to Actual 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Ending Balance 16,953,669.43 19,802,408.17 —-20,071,521.37 _-20,626,637.57 —_—-21,226,753.77 _—-21,931,869.97 _20,231,961.17 _22,137,907.95 _23,341,024.15 _24,471,140.35 _—_-25,166,256.55 —_-26,093,698.75 —_26,112,319.44 —16,953,669.43 Interest Income Projection Estimated Accrued Interest 1,667,963.02 121,784.81 123,439.86 126,853.82 130,544.54 134,881.00 124,426.56 136,148.13 143,547.30 150,497.51 154,772.48 160,476.25 160,590.76 Adjust to Actual Received 1,667,963.02 121,784.81 123,439.86 126,853.82 130,544.54 134,881.00 124,426.56 136,148.13 143,547.30 150,497.51 154,772.48 160,476.25 160,590.76 0.00 Payment of Accrued Interest 761,930.58 CHK TP SCH G 0.00 3/23/20103:08 PM C:\Documents and Settings\mclark\Local Settings\Temporary Internet Files\Content.Outlook\8OM1G2ZY\201 1 BradleyBdgt-original-send2.xlsSchedule I-Interest Inc