|
1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />10
<br />11
<br />12
<br />13
<br />14
<br />15
<br />16
<br />17
<br />18
<br />19
<br />20
<br />21
<br />22
<br />23
<br />6.G. - Page 204 of 238
<br />Amended Attachment M-3
<br />Wholesale Capital Fund and Balancing Account Adjustment
<br />Reference Amended Section 6.08E
<br />Cash Flow in Wholesale Capital Fund
<br />Beginning Total Balance (1)
<br />Annual Appropriation (2)
<br />Annual Expenditures (3)
<br />Interest Earnings (4)
<br />June 30 Balances Before Balancing Account TransfE
<br />Total Balance (5)
<br />Amount Encumbered as of June 30 (6)
<br />Unencumbered Balance (7)
<br />Transfer From/(To) Balancing Account (8)
<br />Ending Balances After Balancing Account Transfers
<br />Ending Total Balance (9)
<br />Unencumbered Ending Balance (10)
<br />B. Calculation of Target Balance
<br />Target WCF Balance (11)
<br />C. Calculation of Remaining Cumulative Appropriation
<br />Cumulative Appropriation Since FYE 2010 (12)
<br />Cumulative Expenditures Since FYE 2010 (13)
<br />Total Remaining Cumulative Appropriation (14)
<br />Amount Encumbered as of June 30 (15)
<br />Unencumbered Remaining Cumulative Appropriation (16)
<br />8,818,323 12,404,275 15,761,658 16,268,065 29,358,756 17,243,583 32,251,212 29,842,765 33,698,785
<br />(1,927,466)
<br />n/a n/a n/a n/a 27,431,290 n/a n/a n/a n/a
<br />n/a n/a n/a n/a (20,274,452) n/a n/a n/a n/a
<br />8,818,323
<br />n/a
<br />10,476,724
<br />(1,778,695)
<br />42,508,440
<br />51,910,495
<br />32,848,850
<br />Original 5 Year True -up Method FYEs 2010-2018
<br />FYE 2010
<br />FYE 2011
<br />FYE 2012
<br />FYE 2013
<br />FYE 2014
<br />FYE 2015
<br />-
<br />8,818,323
<br />12,404,275
<br />15,761,658
<br />16,268,065
<br />9,084,304
<br />10,476,724
<br />8,636,920
<br />21,737,468
<br />11,285,643
<br />18,668,585
<br />15,432,451
<br />(1,778,695)
<br />(5,202,897)
<br />(18,553,119)
<br />(10,916,349)
<br />(5,758,565)
<br />(7,331,312)
<br />120,294
<br />151,929
<br />173,034
<br />137,113
<br />180,672
<br />58,140
<br />8,818,323 12,404,275 15,761,658 16,268,065 29,358,756 17,243,583 32,251,212 29,842,765 33,698,785
<br />(1,927,466)
<br />n/a n/a n/a n/a 27,431,290 n/a n/a n/a n/a
<br />n/a n/a n/a n/a (20,274,452) n/a n/a n/a n/a
<br />8,818,323
<br />n/a
<br />10,476,724
<br />(1,778,695)
<br />42,508,440
<br />51,910,495
<br />32,848,850
<br />17,206,239
<br />Amended Annual True -Up (FYE 2019 and Beyond)
<br />(1,000,000)
<br />FYE 2016
<br />FYE 2017
<br />FYE 2018
<br />FYE 2019
<br />F FYE 2020
<br />FYE 2021
<br />FYE 2022
<br />FYE 2023
<br />17,243,583
<br />32,251,212
<br />29,842,765
<br />33,698,785
<br />41,548,944
<br />47,366,205
<br />36,848,850
<br />21,206,239
<br />21,138,051
<br />11,184,265
<br />17,847,379
<br />26,424,000
<br />26,420,000
<br />13,210,000
<br />13,210,000
<br />13,210,000
<br />(6,245,954)
<br />(13,892,649)
<br />(14,361,409)
<br />(18,089,498)
<br />(16,723,232)
<br />(28,485,215)
<br />(33,563,793)
<br />(22,018,000)
<br />115,532
<br />299,936
<br />370,050
<br />475,153
<br />664,783
<br />757,859
<br />711,183
<br />409,280
<br />8,818,323 12,404,275 15,761,658 16,268,065 29,358,756 17,243,583 32,251,212 29,842,765 33,698,785
<br />(1,927,466)
<br />n/a n/a n/a n/a 27,431,290 n/a n/a n/a n/a
<br />n/a n/a n/a n/a (20,274,452) n/a n/a n/a n/a
<br />8,818,323
<br />n/a
<br />10,476,724
<br />(1,778,695)
<br />42,508,440
<br />51,910,495
<br />32,848,850
<br />17,206,239
<br />12,807,520
<br />(1,000,000)
<br />(1,000,000)
<br />(1,000,000)
<br />(2,000,000)
<br />(2,000,000)
<br />41,508,440
<br />50,910,495
<br />31,848,850
<br />15,206,239
<br />10,807,520
<br />(959,496)
<br />(4,544,290)
<br />4,000,000
<br />4,000,000
<br />4,000,000
<br />12,404,275 15,761,658 16,268,065 9,084,304
<br />17,243,583 32,251,212 29,842,765 33,698,785 41,548,944
<br />47,366,205
<br />36,848,850
<br />21,206,239
<br />16,807,520
<br />n/a n/a n/a 7,156,838
<br />n/a n/a n/a n/a 40,548,944
<br />46,366,205
<br />35,848,850
<br />19,206,239
<br />14,807,520
<br />7,156,838
<br />40,548,944
<br />46,366,205
<br />40,559,076
<br />34,346,800
<br />29,062,000
<br />19,113,644 40,851,112 52,136,755 70,805,340 86,237,791 107,375,842 118,560,107 136,407,486 162,831,486 189,251,486 202,461,486 215,671,486 228,881,486
<br />(6,981,592) (25,534,711) (36,451,060) (42,209,626) (49,540,938) (55,786,891) (69,679,540) (84,040,949) (102,130,447) (118,853,679) (147,338,893) (180,902,686) (202,920,686)
<br />n/a n/a n/a
<br />D. Lesser of Target Balance and Unencumbered Remaining Cumulative Appropriation
<br />Lesser of Target Balance (line 11) and Unencumbered Remaining Appropriation (line 16) (17)
<br />28,595,715
<br />(1,927,466)
<br />26,668,249
<br />36,696,854 51,588,951
<br />n/a n/a
<br />48,880,567 52,366,537 60,701,040
<br />70,397,808
<br />55,122,593
<br />34,768,800
<br />25,960,800
<br />- (1,000,000)
<br />(1,000,000)
<br />(1,000,000)
<br />(2,000,000)
<br />(2,000,000)
<br />n/a n/a 5-9,701,040
<br />69, 397, 808
<br />54,12Z593
<br />32, 768,800
<br />23, 960, 800
<br />E. Calculation of Excess Fund Balance and Refund to Wholesale Customers Through Balancing Account
<br />Is Unencumbered Balance (line 7) more than line 17? (18)
<br />Excess WCF Balance (applied as a negative entry on line 8) (19)
<br />F. Calculation of Deficiency Fund Balance and Charge to Wholesale Customers Through Balancing Account (This Section is Only Applicable in Any Year When Line 18 is No)
<br />Is Unencumbered Balance (line 7) less than line 17? (20)
<br />Tentative Amount Before Application of $4 million cap (21)
<br />Is line 21 more than $4,000,000 maximum? (22)
<br />Balancing Account Charge (applied as a positive entry on line 8):
<br />See Notes on Page 2
<br />Page 1 of 2
<br />40, 548, 944 46, 366, 205 40, 559, 076 32, 768, 800 23, 960, 800
<br />Yes Yes No No No
<br />959,496 4,544,290 - - -
<br />Yes Yes Yes
<br />8,710,226 17,562,561 13,153,280
<br />Yes Yes Yes
<br />4,000,000 4,000,000 4,000,000
<br />535
<br />
|