|
CITY OF ST. ANTHONY VILLAGE
<br />LIQUOR OPERATION CASH POSITION
<br />2015-2022 Maintain 25% gm
<br />4% higher operating costs
<br />2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 stress test 2024 stress test
<br />Operating Income AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED EST ACTUAL 4% drop in sales 2% drop in sales
<br />Sales 7,144,624 6,908,143 6,076,040 5,966,189 5,875,868 5,767,016 5,868,809 6,160,696 7,016,295 7,260,591 6,962,367 6,683,872 6,550,195
<br />Less COGS & Expenses 6,529,345 6,336,052 5,730,651 5,644,614 5,550,374 5,496,104 5,541,231 5,816,037 6,570,870 6,740,185 6,534,488 6,428,310 6,384,668
<br />Less Depreciation 85,500 81,695 76,566 75,658 68,064 68,064 68,782 71,110 70,859 72,085 72,085 72,085 72,085
<br />Less Interest Expense 5,475 - - - - - - - - - - - -
<br />Plus Interest income - - - 4,014 5,973 4,495 7,275 20,757 13,127 (3,466) 2,250 2,250 2,250
<br />Net Income Before Transfers 524,304 490,396 268,823 249,931 263,403 207,343 266,071 294,306 387,693 444,855 358,044 185,727 95,692
<br />Adjustments to Operating Income
<br />Internal Loan Principal 36,500 73,000 - - - - - - - - - - -
<br />Bond Principal - - - - - - - - - - - - -
<br />Capital Purchases - - 7,125 - - - - - - (49,273) - - -
<br />Budgeted Capital Expenditures - - - - - - - - - - - -
<br />Change in Inventory / Payables 100,064 108,551 (116,811) 110,321 70,635 (13,706) 94,816 (189,358) 148,524 (88,651) (50,000) (50,000) (50,000)
<br />Funds Available for Transfer 387,740 308,845 378,509 139,610 192,768 221,049 171,255 483,664 239,169 582,779 408,044 235,727 145,692
<br />Transfer to General Fund 305,800 330,800 214,244 67,849 156,396 156,396 250,000 250,000 250,000 250,000 275,000 275,000 275,000
<br />Transfer to Capital Equipment 204,200 108,200 108,200 181,200 92,653 92,653 - - - - - - -
<br />Transfer to Building Improvement - - 73,000 - - - - - - - - - -
<br />Add Back Depreciation 85,500 81,695 76,566 75,658 68,064 68,064 68,782 71,110 70,859 72,085 72,085 72,085 72,085
<br />Increase / (Decrease) in Cash (36,760) (48,460) 59,631 (33,781) 11,783 40,064 (9,963) 304,774 60,028 404,864 205,129 32,812 (57,223)
<br />Beginning Cash Balance 487,028 450,268 401,808 461,439 427,658 439,441 479,505 469,542 774,316 834,344 1,239,208 1,444,337 1,477,150
<br />Ending Cash Balance 450,268 401,808 461,439 427,658 439,441 479,505 469,542 774,316 834,344 1,239,208 1,444,337 1,477,150 1,419,927
<br />Cash Reserve Calculation
<br />Cash Floor 510,000 439,000 395,444 249,049 249,049 249,060 250,000 250,000 250,000 250,000 275,000 275,000 275,000
<br />One Year of Transfers
<br />Cash Ceiling 949,000 834,444 790,888 498,098 498,098 498,098 825,000 825,000 825,000 825,000 875,000 875,000 875,000
<br />Two Years of Transfers + 5yr CIP
<br />Cash Above / (Below) Floor (59,732) (37,192) 65,995 178,609 190,392 230,445 219,542 524,316 584,344 989,208 1,169,337 1,202,150 1,144,927
<br />Cash Above / (Below) Ceiling (498,732) (432,636) (329,449) (70,440) (58,657) (18,593) (355,458) (50,684) 9,344 414,208 569,337 602,150 544,927
<br />$0
<br />$200,000
<br />$400,000
<br />$600,000
<br />$800,000
<br />$1,000,000
<br />$1,200,000
<br />$1,400,000
<br />$1,600,000
<br />2016 2017 2018 2019 2020 2021 2022 2023 2024
<br />Current
<br />Ceiling
<br />Floor
<br />C:\Users\shelly.rueckert\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\WRAU8P5Z\Council Summary LQ cash flow.xlsx 8/3/2022
<br />16
|