|
Financial Forecasts /Budgets
<br />3 Year Projection
<br />YEAR END SUMMARY
<br />Year 1
<br />Year 2
<br />Year 3
<br />Total Sales
<br />867
<br />100%
<br />936,468
<br />100°x6
<br />1,011 385
<br />100%
<br />Food Sales
<br />563
<br />65%
<br />606,704
<br />65%
<br />657,401
<br />65%
<br />Liquor Sales
<br />130,065
<br />15%
<br />140,470
<br />15%
<br />151,708
<br />15%
<br />Beer Sales
<br />104,052
<br />12%
<br />112,376
<br />12%
<br />121,336
<br />12%
<br />Wine Sales
<br />43,355
<br />5%
<br />46,823
<br />5%
<br />50,569
<br />5%
<br />Other Beverage Sales
<br />26 013
<br />3%
<br />28
<br />3%
<br />30,342
<br />3%
<br />Retail Sales
<br />Food Costs
<br />185,993
<br />33%
<br />200
<br />33%
<br />216,942
<br />33%
<br />Liquor Costs
<br />28,614
<br />22%
<br />30,903
<br />22%
<br />33,376
<br />22%
<br />Beer Costs
<br />27,053
<br />26%
<br />29,218
<br />26%
<br />31,547
<br />25%
<br />Wine Costs
<br />16,475
<br />38%
<br />17,793
<br />38%
<br />19,216
<br />38%
<br />Other Beverage Costs
<br />7,803
<br />30%
<br />8,428
<br />30%
<br />9,102
<br />30%
<br />Total Cost of Sales
<br />265,938
<br />30.6%
<br />286,554
<br />30.6%
<br />310
<br />30.6%
<br />Total Gross Profit
<br />601,162
<br />69.4%
<br />649,914
<br />69.4%
<br />70-1
<br />69.4%
<br />Labor Cost
<br />Hourly-Service/Office
<br />95,381
<br />11%
<br />103,011
<br />11%
<br />111,252
<br />11%
<br />Hourly-Kitchen
<br />91,046
<br />10.5%
<br />98,330
<br />10.5%
<br />106 196
<br />10.5%
<br />Management
<br />73,703
<br />8.5%
<br />79,599
<br />8.5%
<br />85 967
<br />8.5%
<br />Subtotal Labor
<br />260
<br />30%
<br />280
<br />30%
<br />303,415
<br />30%
<br />Workers Comp.
<br />0
<br />0%
<br />0%
<br />0%
<br />Payroll Taxes
<br />43,366
<br />5%
<br />46,823
<br />5%
<br />50,569
<br />5 °1.
<br />Employee Benefits
<br />5,000
<br />0.6%
<br />5,400
<br />.6%
<br />5
<br />.6%
<br />Total Labor Cost
<br />308,485
<br />35.6%
<br />333,164
<br />35.6%
<br />359
<br />35.6%
<br />Other Controllables
<br />Operating Supplies
<br />21,678
<br />2.5%
<br />23
<br />2.5%
<br />25,285
<br />2.5%
<br />Repair & Maintenance
<br />22
<br />2.6%
<br />24,348
<br />2.5%
<br />26,296
<br />2.6%
<br />Other Operating Expenses
<br />8 671
<br />1.0%
<br />9,365
<br />1.0 0 /0
<br />10,114
<br />1.0%
<br />Administrative
<br />4
<br />0.5%
<br />4
<br />0.5%
<br />5,057
<br />0.5%
<br />Credit Card Commission
<br />21,678
<br />2.5%
<br />23,412
<br />2.5%
<br />125,285
<br />2.5%
<br />Linen & Laund
<br />8,671
<br />1.0%
<br />9,365
<br />1.0%
<br />10,114
<br />1.0%
<br />COMPS
<br />4,336
<br />0.5%
<br />4
<br />0.5%
<br />5,057
<br />0.5%
<br />utilities
<br />19,076
<br />2.2%
<br />20,602
<br />2.2%
<br />22
<br />2.2%
<br />Total Other Controllables
<br />111,324
<br />12.8%
<br />1 119,868
<br />12.8%
<br />129 457
<br />12.8%
<br />Total Controllable Expense
<br />685,747
<br />79.1%
<br />740,746
<br />79.1%
<br />800,006
<br />79.1%
<br />Total Controllable Income
<br />181
<br />20.9%
<br />195,722
<br />20.9%
<br />211,379
<br />20.9%
<br />Other Expenses
<br />Advertising & Promotion
<br />30,000
<br />3.5%
<br />24 000
<br />2.6%
<br />24,000
<br />2.4%
<br />Equipment Lease
<br />$2,500
<br />0.3%
<br />2.500
<br />0.3%
<br />2,500
<br />2.8%
<br />Rent/Pr Taxes /Ins.
<br />$80
<br />9.2%
<br />86,155
<br />9.2%
<br />91,025
<br />9.0%
<br />Income before the
<br />following:
<br />68,853
<br />7.9%
<br />83,067
<br />8.1%
<br />93,854
<br />7.9%
<br />Depreciation
<br />9 049
<br />1.0%
<br />9 049
<br />0.9%
<br />9,049
<br />0.9%
<br />Corporate Expense-s-
<br />6,000
<br />10.7%
<br />1 7,0
<br />0.7%
<br />7,000
<br />0.7%
<br />Net Income Before Taxes
<br />53,804
<br />16.2%
<br />1 67,018
<br />7.1%
<br />77,805
<br />17.7%
<br />Projected Cash Flow
<br />62853
<br />17.2%
<br />176.067
<br />8.1%
<br />86,854
<br />18.6%
<br />
|