Tequila Grill Business Plan
 
 
 
 
 
 
 
 
 
 
 
 
 
Tequila Grill
1901 K St. NW
Washington, DC.
info@tequilagrill.com


Confidentiality Agreement

The undersigned reader acknowledges that the information provided by _______________ in this business plan is confidential; therefore, reader agrees not to disclose it without the express written permission of _______________.

It is acknowledged by reader that information to be furnished in this business plan is in all respects confidential in nature, other than information which is in the public domain through other means and that any disclosure or use of same by reader, may cause serious harm or damage to _______________.

Upon request, this document is to be immediately returned to _______________.

___________________
Signature

___________________
Name (typed or printed)

___________________
Date

This is a business plan. It does not imply an offering of securities.


Table of Contents

1.0 Executive Summary
     1.1 Objectives
     1.2 Mission
     1.3 Keys to Success
2.0 Company Summary
     2.1 Company Ownership
     2.2 Company History
3.0 Services
4.0 Market Analysis Summary
     4.1 Market Segmentation
     4.2 Target Market Segment Strategy
     4.3 Service Business Analysis
         4.3.1 Competition and Buying Patterns
5.0 Strategy and Implementation Summary
     5.1 Competitive Edge
     5.2 Marketing Strategy
     5.3 Sales Strategy
         5.3.1 Sales Forecast
     5.4 Milestones
6.0 Web Plan Summary
     6.1 Website Marketing Strategy
     6.2 Development Requirements
7.0 Management Summary
     7.1 Personnel Plan
8.0 Financial Plan
     8.1 Important Assumptions
     8.2 Break-even Analysis
     8.3 Projected Profit and Loss
     8.4 Projected Cash Flow
     8.5 Projected Balance Sheet
     8.6 Business Ratios

Appendices


1.0 Executive Summary

Tequila Grill is a "tex-mex" restaurant and bar located on the George Washington University campus.

Tequila Grill will be serving the university, as well as the other five universities in the Washington, DC area, with a constantly rotating lineup of fresh fruit drinks and premium alcoholic beverages.

Tequila Grill is a privately funded venture lead by Rasa Taghavi and Arjun Ranade.

The Market
The Washington, DC area is famous for its extensive nightlife and endless opportunities for excitement.  Because of the high concentration of college in the area, nightclubs and bars get a lot of business from college-aged students.

In addition to having a high concentration of students in the area, there are a myriad of professional firms also in the area.  Many of these firms hire young graduates straight out of school to begin training them for corporation they are a part of.

Tequila Grill will be targeting three distinct customer segments.  The first is the college student.  This segment has a yearly growth rate of 10% with over 30,000 possible customers.

Tequila Grill will also be targeting the young professional bar attending crowd.  This consists of professionals who use taverns as a palce to unwind after work and socialize.  This section is growing at 8% with 35,000 potential members.

The last group that Tequila Grill will be targeting is "fresh" food enthusiasts.  Due to the recent trends towards "fresh" food (i.e new ingredients as opposed to frozen ones) we will  cater to this crowd by featuring many dishes that fit this category.  This group is growing at the rate of 15% and is expected to be 25,000 additional potential customers.

The Competition
Tequila Grill has three direct competitors that are all located near the George Washington University campus.

Tequila Grill is able to differentiate itself from these competitors through its emphasis on lower prices, specifically dollar drinks.  The competitors target a more well-to-do crowd who doesn't mind spending a great deal of money for premium beverages.

Tequila Grill's emphasis on an outstanding rotating selection of fresh fruit alcoholic drinks is one of two competitive edges.

Its second competitive edge is a buddy website that was developed as an active feedback and community mechanism for the customers to express their preference of drink and event specials.  Customers can also 'chat' amongst each others to build a sense of community surrounding the establishment.  By placing pictures of successful nights on the website, we will attract repeat traffic from regulars who want to see their pictures online.  The website will also provide the customer with a feeling of empowerment and a sense that their needs are truly met at Tequila Grill.

The Management
Tequila Grill will be run by Rasa Taghavi and Arjun Ranade.

Taghavi's experience is primarily from the bar industry.  He spent a year working in Tequila Grill as a bartender and was responsible for inventory, accounting, and managerial decisions as well.  He is also connected to several top DC party promotion experts who can bring a large crowd to any nightlife venue. Taghavi's time spent working at Tequila Grill solidified his desire to be his own boss and remain in the restaurant/bar industry.

Ranade came from a more academic background with degrees in both Computer Science and Marketing. To this day, he owns and operates a profitable website development and hosting business.  He has a strong background in accounting and will be indispensable in assuring a solid control mechanism to accurately track and manage the large cash sums that will travel through Tequila Grill on a daily basis.

Tequila Grill will be a successful venture as it serves the huge demand for low-priced drinks in a classy yet casual atmosphere.

Tequila Grill will offer customers a friendly social atmosphere where they can catch up with their colleagues, make new friends, and enjoy fine southwestern cuisine and drinks. It is forecasted that Tequila Grill will be profitable immediately and achieve over $550,000 in profits by year three.

1.1 Objectives
  1. Sales increasing to more than $2.5 million by the third year.
  2. Bring gross margin back up to above 30%, and maintain that level.
  3. Serve over 300 lunches per day.
  4. Improve current reputation of management and related services.
  5. Improve on current menu by adding deserts and new authentic dishes.
  6. Implement a public relations plan focusing on late-night entertainment.
  7. Implement electronic inventory tracking as well as a proper payroll system.
1.2 Mission
Tequila Grill strives to be the premier Tex-Mex Restaurant and Bar in Northwest DC. Our goal is to provide a unique atmosphere for professionals in Washington, DC. We want our customers to have Tequila Grill as the best place for after-work drinks and fun. We want to provide state-of-the-art entertainment to all of our customers via TV. We combine menu selection, atmosphere, ambiance, and service to create the best possible sense of "place" for the customer.
1.3 Keys to Success
The keys to success in this business are:
  • Marketing: Redefine a position for Tequila Grill that is the communicates the image of the premier Tex-Mex bar and grill.
  • Product quality. Keep product quality above par while improving service to concur with marketing campaign.
  • Management: Add more managers to improve service. Divide restaurant into sections for each manager.
  • Inventory: Insuring that inventory is properly tracked and accounted for.
2.0 Company Summary
Tequila Grill is a full-service restaurant bar in Washington, DC.  It is located on the George Washington University college campus which makes it a gathering place for college students and faculty alike.  Locals in the area also frequent the establishment and it has very successful "Happy Hour" nights in which it is custom for the restaurant to be at full capacity. The restaurant has been in business for five years already and therefore is an existing profitable business.
2.1 Company Ownership
Tequila Ventures, Inc. is a privately-held C corporation half-owned by its president, Rasa Taghavi, a past employee of the restaurant.. There are two part owners, Quin Dodd and Arjun Ranade, who own 10% and 40% respectively.  Both Ranade and Taghavi are responsible for management decisions and day-to-day operations. Quin Dodd is responsible for handling financial and legal matters for the business including but not limited to the assumption of debt needed to start the business.
2.2 Company History

Tequila Grill is an existing bar and restaurant which has been very successful in the area it is in.  Historically, Thursday nights have been very successful but there has been a decline in business due to new ownership and managerial problems.  Fewer customers have been frequenting the restaurant due to current managements inability to provide fresh food and drinks the bar is known for.

All of these concerns are part of the general trend affecting restaurants.

Past Performance
 200120022003
Sales$816,488$916,588$0
Gross Margin$454,024.48$454,024.48$0
Gross Margin %55.61%49.53%0.00%
Operating Expenses$260,624$260,624$0
Collection Period (days)000
Inventory Turnover0.000.000.00
    
Balance Sheet   
Current Assets200120022003
Cash$0$0$0
Accounts Receivable$0$0$0
Inventory$0$0$0
Other Current Assets$0$0$0
Total Current Assets$0$0$0
Long-term Assets   
Capital Assets$0$0$0
Accumulated Depreciation$0$0$0
Total Long-term Assets$0$0$0
Total Assets$0$0$0
    
Capital and Liabilities   
 200120022003
Accounts Payable$0$0$0
Current Borrowing$0$0$150,000
Other Current Liabilities$0$0$0
Subtotal Current Liabilities$0$0$150,000
    
Long-term Liabilities$0$0$0
Total Liabilities$0$0$150,000
Paid-in Capital$0$0$0
Retained Earnings$0$0($150,000)
Earnings$0$0$0
Total Capital$0$0($150,000)
Total Capital and Liabilities$0$0$0
    
Other Inputs200120022003
Payment Days000
Sales on Credit$0$0$0
Receivables Turnover0.000.000.00
3.0 Services
Tequila Grill will provide its customers with a unique and friendly environment for enjoying margaritas, quality beers and liquor. Tequila Grill will also provide customers with an innovative environment for enjoying margaritas and other popular drinks including two big screen televisions for sporting events.
4.0 Market Analysis Summary
Washington DC is a haven for those wanting to partake in a massive bar scene. In recent years, there has been a surge of interest in "fresh" foods and drinks particularly of the tex-mex variety. This is why we believe Tequila Grill, an already established restaurant and bar, will flourish in Washington, DC.  Our target markets include college students, young professionals, and "fresh" food enthusiasts.  The identification of these three markets will help us to better direct our advertising and marketing efforts.
4.1 Market Segmentation

Our numbers are based upon the approximate population of Washington DC.  Because many people are younger and therefore more likely to go to a bar, we decided upon the number 100,000 for the total of people considered available customers. These available customers are segmented into the following groups:

"Fresh" Food Enthusiasts: These people will be drawn to Tequila Grill because of their love and passion for fresh food.  The main people to this segment will be the large number of dishes we will offer that are available at our establishment in addition to the multitude of fresh-fruit drinks the bar is known for.

Young Professionals: The general bar-attending public from Washington, DC. This group will be drawn to the bar after work to relax in a friendly and classy atmosphere.  They will also be drawn by the younger crowd which is identifiable to them based on their age group.

College Students: George Washington University, Georgetown University, American University, Howard University, University of Maryland College Park, and Marymount University. More bargain marketing such as $1 drinks will be aimed at this segment of the market.

 

Market Analysis
Potential CustomersGrowth20032004200520062007CAGR
College Students10%20,00022,00024,20026,62029,28210.00%
Young Professionals8%30,00032,40034,99237,79140,8148.00%
"Fresh" Food Enthusiasts14%15,00017,10019,49422,22325,33414.00%
Total10.08%65,00071,50078,68686,63495,43010.08%
4.2 Target Market Segment Strategy
Both advertising and word-of-mouth will play a big part in the success of Tequila Grill.  Therefore, we will strive to appeal to both new and old customers with a unique advertising campaign, including an online presence that will allow regulars to vote for their favorite drinks and drink specials to be featured this week.  We will seek to expand the young professional segment of our market by calling firms that hire young professionals to set up corporate events and catering.  We will allow companies to host sports-based events at the restaurant and build up our professional crowd in this manner.  We will also continue the tradition of a friendly atmosphere that will keep the customers coming back.
4.3 Service Business Analysis

The pub and bar industry in Washington DC has grown steadily in past years. Many factors contribute to the large demand for a college-oriented bar in Washington DC.  Currently, college students avoid going to bars in DC because of the prohibitive expense associated with them.  In short, Washington, DC is a college town without a college bar.

In our research, we found that in many college towns, bars have become successful by promoting dollar-drink specials.  One need not look any further than College Park, Maryland, a college town with three bars that make millions of dollars every year by using low-margin high volume specials.  Due to intense competition in College Park, bar owners must look for ways to differentiate their place of business from others in order to achieve and maintain a competitive advantage.  However, in DC, one easy way to accomplish this is to have a bar that exclusively targets a college crowd.  Historically, Tequila Grill has owned this position in the minds of college students living in the District.  The establishment is located on the campus circuit routes of George Washington University and therefore attracts a large folllowing from that school. The owners of Tequila Grill realize the need for differentiation and strongly believe that combining a bar with a classy and entertaining atmosphere, while still targeting a professional crowd, is the key to its success.
4.3.1 Competition and Buying Patterns
Since the business will be located on the George Washington campus, our three main competitors will be McFaddens, Mad Hatter, and Front Page. During the first six months of operation we will aggressively advertise ourselves to University students to differentiate ourselves from the competition.
5.0 Strategy and Implementation Summary
Tequila Grill will focus on one geographical market, Washington, DC.

The target customer is usually a college student looking for a classy yet affordable place to lounge at and occaisionally a younger professional looking to mingle with a younger crowd then other restaurants and bars that have a strictly professional clientele.

5.1 Competitive Edge
Tequila Grill will have an edge over the competition due to the large number of specialty margaritas and frozen drinks that we will make.  The companion website will also give regular customers additional incentive to keep returning to the bar due to the ability to vote and influence drink specials, what beers are on tap, and new drinks that could become regular menu-fare.  We will also further differentiate ourselves by offering dollar drinks, something no other DC bar offers at this time.  We will create a classy yet laid-back atmosphere that will include big screen coverage of sporting events and high quality service.
5.2 Marketing Strategy
Marketing in a restaurant/bar business depends on recognition for the best drink specials and best crowd.  It starts with our known friends and colleagues to recommend us to their friends as a bar that features these characteristics and continues with long-term efforts to slowly develop the young professional / "college" bar position in the minds of the DC bar-going public.

We will develop and maintain a database of people in the right positions both at Universities and Companies alike.   It starts with the contacts we already have established from our college experience. From there, we compile a list of major organizations and their heads at Universities such as fraternities and sororities.  We also target sports teams at the collegiate level and offer them a special setup or group discount.  From there, we expand to office managers at the various businesses in the area who are responsible for setting up corporate events.  We use the database to make regular contact with mailings of current specials.  We could also possibly conduct group studies and market research reports to better analyze how to bring in a larger crowd..

5.3 Sales Strategy
Sales in our business is client service. It is repeat business. One doesn't sell just a drink to a client, one develops an atmosphere conducive to drinking and enjoyment that works for the client.

We must always be aware of the big-franchise restaurant phenomenon of the split between selling food and serving food.  It is important to make a distinction because the former leads to client dissatisfaction.  In food service, atmosphere and ambience should be as important, if not more important, than the types of food sold. 

5.3.1 Sales Forecast
Tequila Grill's sales forecast was estimated by breaking down each day we are open into hours, and then estimating the number of drinks during those hours.  In certain seasons, certain drinks are more popular.  For example, traditionally people will drink more margaritas in warmer months. In addition, traditionally more beer is consumed during the months college students are in school.  The same applies for rail drinks.
Sales Forecast
Sales200420052006
Food$72,000$75,600$79,380
Domestic Beers$120,000$126,000$132,300
Imported Beers$180,000$189,000$198,450
Rail Drinks$138,000$151,800$166,980
Margaritas & Frozen Drinks$180,000$225,000$281,250
Premium Cocktails$240,000$276,000$317,400
Total Sales$930,000$1,043,400$1,175,760
    
Direct Cost of Sales200420052006
Food$13,200$13,860$14,553
Domestic Beers$12,000$12,600$13,230
Imported Beers$13,000$14,300$15,730
Rail Drinks$6,000$6,900$7,935
Margaritas & Frozen Drinks$16,000$20,000$25,000
Premium Cocktails$12,000$14,400$17,280
Subtotal Direct Cost of Sales$72,200$82,060$93,728
5.4 Milestones
The management team has established some basic milestones to keep the business plan priorities in place. Responsibility for the implementation falls on the shoulders of Arjun Ranade and Rasa Taghavi.  The Milestones table below will be updated as the year progresses using the actual tables.  New milestones will be added as the first year of operations commences.
Milestones
MilestoneStart DateEnd DateBudgetManagerDepartment
Business Plan12/1/200312/31/2003$500Arjun RanadeMarketing
Website2/1/20043/1/2004$5,000Arjun RanadeWeb
GW Sports Advertising2/1/20042/15/2004$3,000Rasa TaghaviMarketing
Secure Funding12/15/20031/15/2004$10,000Quin DoddAdministrative
Hire Personnel1/15/20042/1/2004$1,000Rasa TaghaviAdministrative
Payroll Implementation1/15/20032/1/2003$5,000Arjun RanadeAccounting
Accounting Plan1/15/20032/1/2003$1,000Arjun RanadeAccounting
Newspaper Advertisement2/1/20042/31/2004$5,000Rasa TaghaviMarketing
Ordering New Supplies1/15/20042/1/2004$10,000Rasa TaghaviAdministrative
Inventory Accounting1/15/20041/31/2004$500Arjun RanadeAdministrative
Totals  $41,000  
6.0 Web Plan Summary
The TequilaGrill.com website will be the virtual business card and showcase for the establishment as well as its online "home."  

It will detail the drink specials and menu options of the establishment as well as pictures from particularly successful nights or events of past.  We will frequently have a photographer to take pictures of the crowd and handout cards advertising the website.  From this, we can have people continually checking for their pictures and wanting to come back to the establishment to be featured on the website.

The Tequila Grill website needs to be a simple yet classy and well designed website that, at the same time, is in keeping with the latest trends in user interface design. A site that is too flashy, or tries to use too much of the latest Shockwave of Flash technology can be over done, and cause potential clients to look elsewhere for online distribution expertise.

To further show off its necessity the website should have an upcoming events area which details the specials and events coming to the establishment. This area could also be used to detail any nights when the establishment is closed for a private party for a corporate office.

The key to the website strategy will be combining a very well designed front end, with a back end capable of recording and analyzing traffic from proper domains.  It will be important to have a lot of university based traffic on our websites.

6.1 Website Marketing Strategy

We will choose to affiliate with other major DC Nightlife websites in order to market the Tequila Grill website.

At certain events we will handout cards detailing the website and sections that are on it.  We can also offer "coupons" or online discount passes for a reduced bill on presentation.  We will contact Washington Post's nightlife section to add us to the best attractions list of the city.

6.2 Development Requirements
The website will be initially developed with few technical resources. A simple hosting provider, ASR Developers Inc., will host the site and provide the technical back end. Since this hosting provider is owned by one of the partners of Tequila Grill, website costs are certain to be minimal.

We will work with a contracted user interface designer to develop the simple, classy, yet Internet focused site. The user interface designer will work with a graphic artist to come up with the website logo, and the website graphics.

The maintenance of the site will be done by Arjun Ranade. As the website rolls out future endeavors such as newsletters and viewable pictures, a technical resource may need to be contracted to build the trackable download and the newsletter capabilities.

7.0 Management Summary
Tequila Grill is owned and operated by Rasa Taghavi and Arjun Ranade.  A third owner, Quin Dodd, is responsible for financial and legal matters but not the day-to-day operations.  The company, being small in nature, requires a simple organizational structure.  Implementation of this organizational form calls for the owners and two managers to make all of the major management decisions in addition to monitoring all other business activities.  Since both Taghavi and Ranade will function as managers, there is no need to incur the additional expense of manager salaries.
7.1 Personnel Plan
The following table summarizes our personnel expenditures for the first three years, with compensation increasing from less than $54K the first year to about $59K in the third. We believe this plan is a fair compromise between fairness and expedience, and meets the commitment of our mission statement. The detailed monthly personnel plan for the first year is included in the appendices.
Personnel Plan
 200420052006
Waiter$12,000$12,500$13,000
Cook (2)$36,000$37,000$38,000
Bartenders (3)$6,000$7,000$8,000
Total People666
Total Payroll$54,000$56,500$59,000
8.0 Financial Plan
  • We want to finance growth mainly through cash flow. We recognize that this means we will have to grow more slowly than we might like.
  • We are also assuming start-up capital of $50,000, and an initial long-term loan from the partners of another $150,000.
8.1 Important Assumptions
The financial plan depends on important assumptions, most of which are shown in the following table as annual assumptions. The monthly assumptions are included in the appendices. From the beginning, we recognize that collection days are critical, but not a factor we can influence easily. At least we are planning on the problem, and dealing with it. Interest rates, tax rates, and personnel burden are based on conservative assumptions.

Two of the more important underlying assumptions are:

  1. We assume a strong economy, without major recession. It should be noted, however, that traditionally restaurant/bar business are not prone to the same tides of recession as the rest of the economy.
  2. We assume, of course, that there are no unforeseen events such as natural disasters.
General Assumptions
 200420052006
Plan Month123
Current Interest Rate10.00%10.00%10.00%
Long-term Interest Rate10.00%10.00%10.00%
Tax Rate30.00%30.00%30.00%
Other0.00%0.00%0.00%
Calculated Totals   
Payroll Expense$54,000$56,500$59,000
New Accounts Payable$456,890$477,538$528,810
Inventory Purchase$79,460$82,945$94,761
8.2 Break-even Analysis

For the purposes of Break-Even analysis the following assumptions were made:

  1. Advertising costs were to be no more than $200.00 per week.
  2. Supplies expense is to be no more than $300.00 per week.
  3. Payroll taxes are estimated to cost $200.00 per week.
  4. Rent expense is estimated to be $1900.00 per week but is subject to change at a rate of 3% anually.
  5. Utilities and repairs are to cost no more than $550.00 per week.
  6. All above expenses in addition to miscellaneous expenses (i.e Cable, Music, Licenses, Credit Card Fees) are estimated to total $5,012.00 per week.
Break-even Analysis:
Monthly Units Break-even5,728
Monthly Revenue Break-even$22,912
  
Assumptions: 
Average Per-Unit Revenue$4.00
Average Per-Unit Variable Cost$0.50
Estimated Monthly Fixed Cost$20,048
8.3 Projected Profit and Loss
Our projected profit and loss is shown on the following table, with sales increasing from more than $930K the first year to more than $1 million the third, and profits are already occuring despite the repayment of debt.

As with the break-even, we are projecting very conservatively regarding cost of sales and gross margin. Our cost of sales should be much lower, and gross margin higher, than in this projection. Initially, we will depend on our partners for most of fulfillment, which is why costs should be lower than shown. We prefer to project conservatively so that we make sure we have enough cash.

The detailed monthly projections are included in the appendices.

Pro Forma Profit and Loss
 200420052006
Sales$930,000$1,043,400$1,175,760
Direct Cost of Sales$72,200$82,060$93,728
Other Costs of Sales$0$0$0
 ------------------------------------
Total Cost of Sales$72,200$82,060$93,728
Gross Margin$857,800$961,340$1,082,032
Gross Margin %92.24%92.14%92.03%
Expenses:   
Payroll$54,000$56,500$59,000
Sales and Marketing and Other Expenses$6,000$7,000$8,000
Depreciation$0$0$0
Rent$108,000$111,240$114,577.20
Utilities$14,400$15,000$16,000
Insurance$19,200$19,200$19,200
Payroll Taxes$8,100$8,475$8,850
Debt Service $300,000 at 8%$24,000$0$0
 ------------------------------------
Total Operating Expenses$233,700$217,415$225,627
Profit Before Interest and Taxes$624,100$743,925$856,405
Interest Expense$15,000$15,000$15,000
Taxes Incurred$182,730$218,678$252,421
Net Profit$426,370$510,248$588,983
Net Profit/Sales45.85%48.90%50.09%
Include Negative TaxesTRUETRUETRUE
8.4 Projected Cash Flow

Cash flow projections are critical to our success. The monthly cash flow is shown in the illustration, with one bar representing the cash flow per month, and the other the monthly cash balance. The annual cash flow figures are included here and the more important detailed monthly numbers are included in the appendices.

Pro Forma Cash Flow
 200420052006
Cash Received   
Cash from Operations:    
Cash Sales$930,000$1,043,400$1,175,760
Cash from Receivables$0$0$0
Subtotal Cash from Operations$930,000$1,043,400$1,175,760
    
Additional Cash Received   
Non Operating (Other) Income$0$0$0
Sales Tax, VAT, HST/GST Received$0$0$0
New Current Borrowing$0$0$0
New Other Liabilities (interest-free)$0$0$0
New Long-term Liabilities$0$0$0
Sales of Other Current Assets$0$0$0
Sales of Long-term Assets$0$0$0
New Investment Received$0$0$0
Subtotal Cash Received$930,000$1,043,400$1,175,760
    
Expenditures200420052006
Expenditures from Operations:   
Cash Spending$54,000$56,500$59,000
Payment of Accounts Payable$412,413$472,114$522,480
Subtotal Spent on Operations$466,413$528,614$581,480
    
Additional Cash Spent   
Non Operating (Other) Expense$0$0$0
Sales Tax, VAT, HST/GST Paid Out$0$0$0
Principal Repayment of Current Borrowing$0$0$0
Other Liabilities Principal Repayment$0$0$0
Long-term Liabilities Principal Repayment$0$0$0
Purchase Other Current Assets$0$0$0
Purchase Long-term Assets$0$0$0
Dividends$0$0$0
Subtotal Cash Spent$466,413$528,614$581,480
    
Net Cash Flow$463,588$514,786$594,280
Cash Balance$463,588$978,373$1,572,653
8.5 Projected Balance Sheet
The balance sheet in the following table shows managed but sufficient growth of net worth, and a sufficiently healthy financial position. The monthly estimates are included in the appendices.
Pro Forma Balance Sheet
    
Assets   
Current Assets200420052006
Cash$463,588$978,373$1,572,653
Inventory$7,260$8,145$9,179
Other Current Assets$0$0$0
Total Current Assets$470,848$986,518$1,581,832
Long-term Assets   
Long-term Assets$0$0$0
Accumulated Depreciation$0$0$0
Total Long-term Assets$0$0$0
Total Assets$470,848$986,518$1,581,832
    
Liabilities and Capital   
 200420052006
Accounts Payable$44,478$49,901$56,231
Current Borrowing$150,000$150,000$150,000
Other Current Liabilities$0$0$0
Subtotal Current Liabilities$194,478$199,901$206,231
    
Long-term Liabilities$0$0$0
Total Liabilities$194,478$199,901$206,231
    
Paid-in Capital$0$0$0
Retained Earnings($150,000)$276,370$786,618
Earnings$426,370$510,248$588,983
Total Capital$276,370$786,618$1,375,601
Total Liabilities and Capital$470,848$986,518$1,581,832
Net Worth$276,370$786,618$1,375,601
8.6 Business Ratios
The following table shows the projected businesses ratios. We expect to maintain healthy ratios for profitability, risk, and return.
Ratio Analysis
 200420052006Industry Profile
Sales Growth0.00%12.19%12.69%6.32%
     
Percent of Total Assets    
Accounts Receivable0.00%0.00%0.00%6.29%
Inventory1.54%0.83%0.58%3.84%
Other Current Assets0.00%0.00%0.00%25.18%
Total Current Assets100.00%100.00%100.00%35.31%
Long-term Assets0.00%0.00%0.00%64.69%
Total Assets100.00%100.00%100.00%100.00%
     
Current Liabilities41.30%20.26%13.04%15.88%
Long-term Liabilities0.00%0.00%0.00%29.33%
Total Liabilities41.30%20.26%13.04%45.21%
Net Worth58.70%79.74%86.96%54.79%
     
Percent of Sales    
Sales100.00%100.00%100.00%100.00%
Gross Margin92.24%92.14%92.03%44.48%
Selling, General & Administrative Expenses46.39%43.23%41.93%24.68%
Advertising Expenses0.00%0.00%0.00%2.47%
Profit Before Interest and Taxes67.11%71.30%72.84%3.61%
     
Main Ratios    
Current2.424.947.671.54
Quick2.384.897.631.05
Total Debt to Total Assets41.30%20.26%13.04%50.20%
Pre-tax Return on Net Worth220.39%92.67%61.17%5.83%
Pre-tax Return on Assets129.36%73.89%53.19%11.70%
     
Business Vitality Profile200320042005Industry
Sales per Employee$155,000$173,900$195,960$32,619
Survival Rate   69.64%
     
Additional Ratios200420052006 
Net Profit Margin45.85%48.90%50.09%n.a
Return on Equity154.28%64.87%42.82%n.a
     
Activity Ratios    
Accounts Receivable Turnover0.000.000.00n.a
Collection Days000n.a
Inventory Turnover16.4710.6510.82n.a
Accounts Payable Turnover10.279.579.40n.a
Payment Days283637n.a
Total Asset Turnover1.981.060.74n.a
     
Debt Ratios    
Debt to Net Worth0.700.250.15n.a
Current Liab. to Liab.1.001.001.00n.a
     
Liquidity Ratios    
Net Working Capital$276,370$786,618$1,375,601n.a
Interest Coverage41.6149.6057.09n.a
     
Additional Ratios    
Assets to Sales0.510.951.35n.a
Current Debt/Total Assets41%20%13%n.a
Acid Test 2.384.897.63n.a
Sales/Net Worth3.371.330.85n.a
Dividend Payout0.000.000.00n.a

Sales Forecast
Sales JulAugSepOctNovDecJanFebMarAprMayJun
Food $6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000
Domestic Beers $10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000$10,000
Imported Beers $15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000
Rail Drinks $11,500$11,500$11,500$11,500$11,500$11,500$11,500$11,500$11,500$11,500$11,500$11,500
Margaritas & Frozen Drinks $15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000$15,000
Premium Cocktails $20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000$20,000
Total Sales $77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500
              
Direct Cost of Sales JulAugSepOctNovDecJanFebMarAprMayJun
Food $1,100$1,100$1,100$1,100$1,100$1,100$1,100$1,100$1,100$1,100$1,100$1,100
Domestic Beers $1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000
Imported Beers $1,000$1,000$1,000$2,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000
Rail Drinks $500$500$500$500$500$500$500$500$500$500$500$500
Margaritas & Frozen Drinks $1,000$2,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$2,000$2,000$2,000
Premium Cocktails $1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000
Subtotal Direct Cost of Sales $5,600$6,600$5,600$6,600$5,600$5,600$5,600$5,600$5,600$6,600$6,600$6,600

Personnel Plan
  JulAugSepOctNovDecJanFebMarAprMayJun
Waiter $1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000$1,000
Cook (2) $3,000$3,000$3,000$3,000$3,000$3,000$3,000$3,000$3,000$3,000$3,000$3,000
Bartenders (3) $500$500$500$500$500$500$500$500$500$500$500$500
Total People 666666666666
Total Payroll $4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500

General Assumptions
  JulAugSepOctNovDecJanFebMarAprMayJun
Plan Month 123456789101112
Current Interest Rate 10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%
Long-term Interest Rate 10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%10.00%
Tax Rate 30.00%30.00%30.00%30.00%30.00%30.00%30.00%30.00%30.00%30.00%30.00%30.00%
Other 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Calculated Totals             
Payroll Expense $4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500
New Accounts Payable $43,338$38,978$31,578$43,478$31,578$41,678$31,578$42,778$31,578$44,578$31,278$44,478
Inventory Purchase $11,760$7,700$0$12,200$0$10,100$0$11,200$0$13,300$0$13,200

Pro Forma Profit and Loss
  JulAugSepOctNovDecJanFebMarAprMayJun
Sales $77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500
Direct Cost of Sales $5,600$6,600$5,600$6,600$5,600$5,600$5,600$5,600$5,600$6,600$6,600$6,600
Other Costs of Sales $0$0$0$0$0$0$0$0$0$0$0$0
  ------------------------------------------------------------------------------------------------------------------------------------------------
Total Cost of Sales $5,600$6,600$5,600$6,600$5,600$5,600$5,600$5,600$5,600$6,600$6,600$6,600
Gross Margin $71,900$70,900$71,900$70,900$71,900$71,900$71,900$71,900$71,900$70,900$70,900$70,900
Gross Margin % 92.77%91.48%92.77%91.48%92.77%92.77%92.77%92.77%92.77%91.48%91.48%91.48%
Expenses:             
Payroll $4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500
Sales and Marketing and Other Expenses $500$500$500$500$500$500$500$500$500$500$500$500
Depreciation $0$0$0$0$0$0$0$0$0$0$0$0
Rent $9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000
Utilities $1,200$1,200$1,200$1,200$1,200$1,200$1,200$1,200$1,200$1,200$1,200$1,200
Insurance $1,600$1,600$1,600$1,600$1,600$1,600$1,600$1,600$1,600$1,600$1,600$1,600
Payroll Taxes15%$675$675$675$675$675$675$675$675$675$675$675$675
Debt Service $300,000 at 8% $2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000$2,000
  ------------------------------------------------------------------------------------------------------------------------------------------------
Total Operating Expenses $19,475$19,475$19,475$19,475$19,475$19,475$19,475$19,475$19,475$19,475$19,475$19,475
Profit Before Interest and Taxes $52,425$51,425$52,425$51,425$52,425$52,425$52,425$52,425$52,425$51,425$51,425$51,425
Interest Expense $1,250$1,250$1,250$1,250$1,250$1,250$1,250$1,250$1,250$1,250$1,250$1,250
Taxes Incurred $15,353$15,053$15,353$15,053$15,353$15,353$15,353$15,353$15,353$15,053$15,053$15,053
Net Profit $35,823$35,123$35,823$35,123$35,823$35,823$35,823$35,823$35,823$35,123$35,123$35,123
Net Profit/Sales 46.22%45.32%46.22%45.32%46.22%46.22%46.22%46.22%46.22%45.32%45.32%45.32%
Include Negative Taxes             

Pro Forma Cash Flow
  JulAugSepOctNovDecJanFebMarAprMayJun
Cash Received             
Cash from Operations:              
Cash Sales $77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500
Cash from Receivables $0$0$0$0$0$0$0$0$0$0$0$0
Subtotal Cash from Operations $77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500
              
Additional Cash Received             
Non Operating (Other) Income $0$0$0$0$0$0$0$0$0$0$0$0
Sales Tax, VAT, HST/GST Received0.00%$0$0$0$0$0$0$0$0$0$0$0$0
New Current Borrowing $0$0$0$0$0$0$0$0$0$0$0$0
New Other Liabilities (interest-free) $0$0$0$0$0$0$0$0$0$0$0$0
New Long-term Liabilities $0$0$0$0$0$0$0$0$0$0$0$0
Sales of Other Current Assets $0$0$0$0$0$0$0$0$0$0$0$0
Sales of Long-term Assets $0$0$0$0$0$0$0$0$0$0$0$0
New Investment Received $0$0$0$0$0$0$0$0$0$0$0$0
Subtotal Cash Received $77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500$77,500
              
Expenditures JulAugSepOctNovDecJanFebMarAprMayJun
Expenditures from Operations:             
Cash Spending $4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500$4,500
Payment of Accounts Payable $0$43,338$38,978$31,578$43,478$31,578$41,678$31,578$42,778$31,578$44,578$31,278
Subtotal Spent on Operations $4,500$47,838$43,478$36,078$47,978$36,078$46,178$36,078$47,278$36,078$49,078$35,778
              
Additional Cash Spent             
Non Operating (Other) Expense $0$0$0$0$0$0$0$0$0$0$0$0
Sales Tax, VAT, HST/GST Paid Out $0$0$0$0$0$0$0$0$0$0$0$0
Principal Repayment of Current Borrowing $0$0$0$0$0$0$0$0$0$0$0$0
Other Liabilities Principal Repayment $0$0$0$0$0$0$0$0$0$0$0$0
Long-term Liabilities Principal Repayment $0$0$0$0$0$0$0$0$0$0$0$0
Purchase Other Current Assets $0$0$0$0$0$0$0$0$0$0$0$0
Purchase Long-term Assets $0$0$0$0$0$0$0$0$0$0$0$0
Dividends $0$0$0$0$0$0$0$0$0$0$0$0
Subtotal Cash Spent $4,500$47,838$43,478$36,078$47,978$36,078$46,178$36,078$47,278$36,078$49,078$35,778
              
Net Cash Flow $73,000$29,663$34,023$41,423$29,523$41,423$31,323$41,423$30,223$41,423$28,423$41,723
Cash Balance $73,000$102,663$136,685$178,108$207,630$249,053$280,375$321,798$352,020$393,443$421,865$463,588

Pro Forma Balance Sheet
              
Assets             
Current AssetsStarting BalancesJulAugSepOctNovDecJanFebMarAprMayJun
Cash$0$73,000$102,663$136,685$178,108$207,630$249,053$280,375$321,798$352,020$393,443$421,865$463,588
Inventory$0$6,160$7,260$1,660$7,260$1,660$6,160$560$6,160$560$7,260$660$7,260
Other Current Assets$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Current Assets$0$79,160$109,923$138,345$185,368$209,290$255,213$280,935$327,958$352,580$400,703$422,525$470,848
Long-term Assets             
Long-term Assets$0$0$0$0$0$0$0$0$0$0$0$0$0
Accumulated Depreciation$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Long-term Assets$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Assets$0$79,160$109,923$138,345$185,368$209,290$255,213$280,935$327,958$352,580$400,703$422,525$470,848
              
Liabilities and Capital             
  JulAugSepOctNovDecJanFebMarAprMayJun
Accounts Payable$0$43,338$38,978$31,578$43,478$31,578$41,678$31,578$42,778$31,578$44,578$31,278$44,478
Current Borrowing$150,000$150,000$150,000$150,000$150,000$150,000$150,000$150,000$150,000$150,000$150,000$150,000$150,000
Other Current Liabilities$0$0$0$0$0$0$0$0$0$0$0$0$0
Subtotal Current Liabilities$150,000$193,338$188,978$181,578$193,478$181,578$191,678$181,578$192,778$181,578$194,578$181,278$194,478
              
Long-term Liabilities$0$0$0$0$0$0$0$0$0$0$0$0$0
Total Liabilities$150,000$193,338$188,978$181,578$193,478$181,578$191,678$181,578$192,778$181,578$194,578$181,278$194,478
              
Paid-in Capital$0$0$0$0$0$0$0$0$0$0$0$0$0
Retained Earnings($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)($150,000)
Earnings$0$35,823$70,945$106,768$141,890$177,713$213,535$249,358$285,180$321,003$356,125$391,248$426,370
Total Capital($150,000)($114,178)($79,055)($43,233)($8,110)$27,713$63,535$99,358$135,180$171,003$206,125$241,248$276,370
Total Liabilities and Capital$0$79,160$109,923$138,345$185,368$209,290$255,213$280,935$327,958$352,580$400,703$422,525$470,848
Net Worth($150,000)($114,178)($79,055)($43,233)($8,110)$27,713$63,535$99,358$135,180$171,003$206,125$241,248$276,370