|
CITY OF ST. ANTHONY VILLAGE
<br />LIQUOR OPERATION CASH POSITION
<br />2018-2024 Maintain 25% gm
<br />4% higher operating costs
<br />2018 2019 2020 2021 2022 2023 2024 2025 stress test 2026 stress test
<br />Operating Income AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED ESTIMATED 4% drop off sales 2% drop off sales
<br />Sales 5,868,809 6,160,696 7,025,468 7,260,591 7,041,690 7,066,785 7,041,807 6,760,135 6,624,932
<br />Less COGS & Expenses 5,541,231 5,816,037 6,561,376 6,740,185 6,483,952 6,624,191 6,840,731 6,560,159 6,518,359
<br />Less Depreciation 68,782 71,110 70,859 72,085 80,142 80,143 80,143 80,142 80,142
<br />Less Interest Expense - - - - - - - -
<br />Plus Interest income 7,275 20,757 13,127 (3,466) (27,751) 63,934 2,250 2,250 2,250
<br />Net Income Before Transfers 266,071 294,306 406,360 444,855 449,845 426,385 123,183 122,084 28,681
<br />Adjustments to Operating Income
<br />Internal Loan Principal - - - - - - - - -
<br />Bond Principal - - - - - - - - -
<br />Capital Purchases - - - (49,273) - - - - -
<br />Budgeted Capital Expenditures - - - - - - - - -
<br />Change in Inventory / Payables 94,816 (189,358) 167,191 (88,651) 114,269 125,400 (50,000) (50,000) (50,000)
<br />Funds Available for Transfer 171,255 483,664 239,169 582,779 335,576 300,985 173,183 172,084 78,681
<br />Transfer to General Fund 250,000 250,000 250,000 250,000 275,000 275,000 275,000 275,000 275,000
<br />Transfer to Capital Equipment - - - - - - - -
<br />Transfer to Building Improvement - - - - - - - -
<br />Add Back Depreciation 68,782 71,110 70,859 72,085 80,142 80,143 80,143 80,142 80,142
<br />Increase / (Decrease) in Cash (9,963) 304,774 60,028 404,864 140,718 106,128 (21,674) (22,774) (116,177)
<br />Beginning Cash Balance 479,505 469,542 774,316 834,344 1,239,208 1,379,926 1,486,054 1,464,380 1,441,606
<br />Ending Cash Balance 469,542 774,316 834,344 1,239,208 1,379,926 1,486,054 1,464,380 1,441,606 1,325,429
<br />Cash Reserve Calculation
<br />Cash Floor 250,000 250,000 250,000 250,000 275,000 275,000 275,000 275,000 275,000
<br />One Year of Transfers
<br />Cash Ceiling 1,075,000 1,075,000 1,075,000 1,175,000 1,350,000 1,350,000 1,350,000 875,000 875,000
<br />Three Years of Transfers + 5yr CIP
<br />Cash Above / (Below) Floor 219,542 524,316 584,344 989,208 1,104,926 1,211,054 1,189,380 1,166,606 1,050,429
<br />Cash Above / (Below) Ceiling (605,458) (300,684) (240,656) 64,208 29,926 136,054 114,380 566,606 450,429
<br />$100,000
<br />$250,000
<br />$400,000
<br />$550,000
<br />$700,000
<br />$850,000
<br />$1,000,000
<br />$1,150,000
<br />$1,300,000
<br />$1,450,000
<br />$1,600,000
<br />2018 2019 2020 2021 2022 2023 2024 2025 2026
<br />Low
<br />High
<br />Current
<br />Ceiling
<br />Floor
<br />Z:\LIQUOR\Liquor Financial Statements\Council Summary LQ cash flow 8/13/2024
|