|
CITY OF ST. ANTHONY VILLAGE
<br />LIQUOR OPERATION CASH POSITION 1,196,467 1,201,192 1,309,372 1,308,622 1,271,675 1,325,000 - -
<br />2017-2023 Maintain 24% gm
<br />4% higher operating costs
<br />2018 2019 2020 2021 2022 2023 2024 stress test 2024 stress test
<br />Operating Income AUDITED AUDITED AUDITED AUDITED AUDITED EST ACTUAL 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,175,000 6,888,000 6,750,240
<br />Less COGS & Expenses 5,541,231 5,816,037 6,561,376 6,740,185 6,483,952 6,650,000 6,650,286 6,534,702
<br />Less Depreciation 68,782 71,110 70,859 72,085 80,142 80,142 80,142 80,142
<br />Less Interest Expense - - - - - - - -
<br />Plus Interest income 7,275 20,757 13,127 (3,466) (27,751) 1,000 2,250 2,250
<br />Net Income Before Transfers 266,071 294,306 406,360 444,855 449,845 445,858 159,822 137,646
<br />Adjustments to Operating Income
<br />Capital Purchases - - - (49,273) - - - -
<br />Budgeted Capital Expenditures - - - - - - - -
<br />Change in Inventory / Payables 94,816 (189,358) 167,191 (88,651) 114,269 150,000 (50,000) (50,000)
<br />Funds Available for Transfer 171,255 483,664 239,169 582,779 335,576 295,858 209,822 187,646
<br />Transfer to General Fund 250,000 250,000 250,000 250,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,142 80,142 80,142
<br />Increase / (Decrease) in Cash (9,963) 304,774 60,028 404,864 140,718 101,000 14,964 (7,212)
<br />Beginning Cash Balance 479,505 469,542 774,316 834,344 1,239,208 1,379,926 1,379,926 1,394,891
<br />Ending Cash Balance 469,542 774,316 834,344 1,239,208 1,379,926 1,480,926 1,394,891 1,387,679
<br />Cash Reserve Calculation
<br />Cash Floor 483,199 507,231 578,430 597,789 579,766 590,742 567,112 555,770
<br />Peak month payables
<br />Cash Ceiling 874,356 910,995 1,031,317 1,060,261 1,028,608 1,051,738 875,000 875,000
<br />Cash Above / (Below) Floor (13,656) 267,086 255,914 641,420 800,160 890,185 827,779 831,909
<br />Cash Above / (Below) Ceiling (404,814) (136,679) (196,973) 178,948 351,318 429,189 519,891 512,679
<br />45 days peak payables & operating expenses &
<br />transfer
<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 />2017 2018 2019 2020 2021 2022 2023
<br />Low
<br />High
<br />Current
<br />Ceiling
<br />Floor
<br />Z:\LIQUOR\Liquor Financial Statements\Council Summary LQ cash flow 8/4/2023
|