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