|
Reserve Advisors, LLC Page 1 of 1
<br />RESERVE FUNDING PLAN
<br />CASH FLOW ANALYSIS
<br />Arden Hills City Hall Individual Reserve Budgets & Cash Flows for the Next 30 Years
<br />Arden Hills, Minnesota FY2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040
<br />Reserves at Beginning of Year (Note 1)0 0 64,357 52,052 186,649 330,557 77,554 268,469 112,086 244,334 364,048 78,066 192,660 279,585 397,919 445,107
<br />Total Recommended Reserve Contributions (Note 2)0 63,500 127,000 190,500 196,800 203,300 210,000 216,900 127,500 131,700 136,000 136,000 136,000 136,000 136,000 136,000
<br />Estimated Interest Earned, During Year (Note 3)0 857 1,551 3,180 6,889 5,436 4,609 5,069 4,748 8,104 5,889 3,606 6,290 9,024 11,229 11,223
<br />Anticipated Expenditures, By Year 0 0 (140,856)(59,083)(59,781)(461,739)(23,694)(378,352)0 (20,091)(427,871)(25,012)(55,365)(26,690)(100,041)(194,886)--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Anticipated Reserves at Year End $0 $64,357 $52,052 $186,649 $330,557 $77,554 $268,469 $112,086 $244,334 $364,048 $78,066 $192,660 $279,585 $397,919 $445,107 $397,444
<br />(NOTE 5)(NOTE 5)
<br />(continued)Individual Reserve Budgets & Cash Flows for the Next 30 Years, Continued
<br />2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055
<br />Reserves at Beginning of Year 397,444 525,014 323,675 264,160 353,056 75,022 223,434 80,676 229,455 420,209 606,790 820,096 942,153 1,177,690 1,426,478
<br />Total Recommended Reserve Contributions 140,500 145,100 149,900 154,800 159,900 165,200 170,700 176,300 182,100 188,100 194,300 200,700 207,300 214,100 221,200
<br />Estimated Interest Earned, During Year 12,287 11,305 7,830 8,221 5,702 3,975 4,051 4,131 8,654 13,680 19,006 23,473 28,237 34,688 23,479
<br />Anticipated Expenditures, By Year (25,217)(357,744)(217,245)(74,125)(443,635)(20,763)(317,509)(31,652)0 (15,199)0 (102,117)0 0 (1,335,006)---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Anticipated Reserves at Year End $525,014 $323,675 $264,160 $353,056 $75,022 $223,434 $80,676 $229,455 $420,209 $606,790 $820,096 $942,153 $1,177,690 $1,426,478 $336,150
<br />(NOTE 5)(NOTE 4)
<br />Explanatory Notes:
<br />1)Year 2025 starting reserves are as of December 31, 2024; FY2025 starts January 1, 2025 and ends December 31, 2025.
<br />2)Reserve Contributions for 2025 are budgeted; 2026 is the first year of recommended contributions.
<br />3)2.7%is the estimated annual rate of return on invested reserves.
<br />4)Accumulated year 2055 ending reserves consider the age, size, overall condition and complexity of the property.
<br />5)Threshold Funding Years (reserve balance at critical point).
<br /> Printed on 4/4/2025 Funding Plan - Section 3
|