|
2016 Liquor Sales Projection
<br /> Traditional Projection - Prior Years Sales Mix
<br />SALES GM NET INCOME
<br /> JAN-JUN 49% 2,741,792 634,452 84,214
<br /> JUL-DEC 51% 2,853,702 660,348 87,651
<br /> TOTAL 5,595,494 1,294,800 171,865
<br /> 100,000
<br /> 200,000
<br /> 300,000
<br /> 400,000
<br /> 500,000
<br /> 600,000
<br /> 700,000
<br /> 800,000
<br />Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
<br />Total - Sales
<br />2012 2013 2014 2015
<br />Liquor Transfers Summary
<br />2012 2013 2014 2015 2016
<br />Net Income Before Transfers 524,304 490,396 268,823 171,865 171,865
<br />Adjustments for cash flow available (51,064) (99,856) 186,252 77,184 77,184
<br />Net Income Available for Transfer 473,240 390,540 455,075 249,049 249,049
<br />Transfers Schedule
<br />Transfer to General Fund 305,800 330,800 214,244 214,244 249,049
<br />Transfer to Capital Equipment 204,200 108,200 108,200 108,200 -
<br />Transfer to Building Improvement - - 73,000 73,000 -
<br />Total Transfers 510,000 439,000 395,444 395,444 249,049
<br /> Change in year end cash (36,760) (48,460) 59,631 (146,395) -
<br />12
|