On The Water
Executive Summary
On the Water is a new Mediterranean restaurant on the Sunset Strip. On the Water will target both fun-seeking as well as sophisticated diners looking for good food in a fascinating atmosphere. On the Water will seek to earn 85% gross margins through an innovative setting, a wonderful menu, and an experienced restaurateur.
The Market
On the Water will be targeting locals and tourists who are active restaurant seekers. There will be a special focus on young adults with $15K-$60K of income looking for good food and a great time. In addition to the young adults with money to spend, On the Water will also be targeting adults and tourists known to frequent Sunset Blvd. The general demographics are males and females ages 20-50 with some or all of a college education. In addition to local Hollywood area people, On the Water will also serve party animals from neighboring cities and tourists.
Historically, if there is a dip in the general economy, the restaurant industry is usually effected far less that the overall economy. To some degree this is because of people’s perception that food, regardless whether it is from the grocery or a restaurant is a fundamental necessity of life and spend accordingly.
The Service and Products
One thing that is always consistent with On the Water is their impeccable service. All server staff hired have extensive experience and all go through three weeks of training, ensuring benchmarked customer service. On the Water’s services are all delivered in their extraordinary atmosphere which includes a comprehensive art and culture collection from Mediterranean Europe. This provides an authentic surrounding that at times seems to distract everyone as they analyze the wealth of artifacts on display.
The menu is Lily Valdivia’s pride. It is a culmination of over 20 years of cooking. The menu contains traditional favorites such as hummus, baba ganouj, and tabouli. These favorites are differentiated through the use of the freshest organic ingredients. Most people are not aware of how much better the items taste when they are prepared with the freshest ingredients and made with love. Other menu items are kebobs, chutneys, flat breads and desserts. Everything is fresh, homemade, and prepared daily.
Management
The restaurant is led by Lily Valdivia, an industry veteran. Her restaurant experience began 12 years ago as a server. She quickly moved up to fine dining serving where she perfected her formal, customer-centric serving approach. For the last five years Lily has been the manager at a European restaurant with over $2.5 million in annual sales. As mentioned earlier, Lily started cooking 20 years ago as a child in Greece. Lily came from a large family and it quickly became her responsibility to cook for the entire family. Her mother, who had three generations of traditional recipes, trained her. Lily quickly mastered these and began experimenting with her own dishes. The feedback from her family was always very positive. She knew one day she would have to parlay this skill into a business opportunity.
On the Water is forecasted to reach profitability by month two. Sales are forecasted to reach $1,785,000 by year two and grow to $2,345,000 by year three. We forecast a high net profit on these sales.
1.1 Objectives
- Sales increasing to more than $2,345,000 by the third year.
- Keeping gross margin at approximately 80%.
- Improve inventory turnover to two-hundred turns next year in year two, and to 240 in year three.
1.2 Mission
On The Water is a business that envelopes fine dining of unique mediterranean taste and an excellent bar and grill atmosphere. The mission is not only to have great tasting food, but have efficient and friendly service. Our dining environment is not only welcoming and sophisticated, it is unique in design, with walls on almost all sides that are constantly wet with running water and a lush jungle ceiling that will hang from above. We concentrate on customer satisfaction and quality food that is always fresh and specially selected. We will not judge a customer on class or dress. We want the On The Water grill to be place people can enjoy a good meal and meet new friends at our tropical Mediterranean Honey bar located inside the restaurant.
Company Summary
On The Water creates and serves a wild atmosphere for dining and eloquent mediterranean feasts for people who love the restaurant and bar scene, as well as a good time spent out on the town. Its customers are creative, fun-seeking, and sophisticated diners who wish to be best served by the restaurant they choose.
2.1 Company Ownership
On The Water is a sole-proprietorship business owned in majority by its founder and president Lily Valdivia. The business employs the owner, one investor and eight employees.
2.2 Start-up Summary
Our start-up expenses come to $61,450 which is mostly expensed equipment, rent, and legal and consulting costs associated with opening our first restaurant. We also require $69,000 of start-up assets, which includes $22,000 cash and $45,000 of long-term assets. The start-up costs are to be financed some by direct owner investment, as well as with the help of a major investor.
Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $500 |
Stationery etc. | $750 |
Menus | $200 |
Consultants | $1,000 |
Insurance | $1,000 |
Rent | $6,000 |
Expensed equipment | $50,000 |
Other | $2,000 |
Total Start-up Expenses | $61,450 |
Start-up Assets | |
Cash Required | $22,000 |
Start-up Inventory | $2,000 |
Other Current Assets | $0 |
Long-term Assets | $45,000 |
Total Assets | $69,000 |
Total Requirements | $130,450 |
Start-up Funding | |
Start-up Expenses to Fund | $61,450 |
Start-up Assets to Fund | $69,000 |
Total Funding Required | $130,450 |
Assets | |
Non-cash Assets from Start-up | $47,000 |
Cash Requirements from Start-up | $22,000 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $22,000 |
Total Assets | $69,000 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $0 |
Long-term Liabilities | $0 |
Accounts Payable (Outstanding Bills) | $15,450 |
Other Current Liabilities (interest-free) | $0 |
Total Liabilities | $15,450 |
Capital | |
Planned Investment | |
Investor 1 | $85,000 |
Other | $30,000 |
Additional Investment Requirement | $0 |
Total Planned Investment | $115,000 |
Loss at Start-up (Start-up Expenses) | ($61,450) |
Total Capital | $53,550 |
Total Capital and Liabilities | $69,000 |
Total Funding | $130,450 |
Products and Services
On The Water provides delicious mediterranean cuisine, with friendly, efficient service and atmosphere. We are especially focused on providing a unique environment for people to dine and meet. We have a full Mediterranean Honey bar for young adults and adults to enjoy drinks and music. We also provide the value of flawless and creative staff at a “hip” location located on Sunset Strip with valet included.
Market Analysis Summary
On The Water focuses on local and tourist active restaurant seekers, with special focus on young adults with a $20-30,000/year income and a desire for good food and a fascinating atmosphere as our target market.
4.1 Market Segmentation
Our target market segmentation is divided between young restaurant seekers with money to spend, as well as other adults and tourists who are known to frequent Sunset Blvd. for recreational enjoyment. Defining the high-end crowd is difficult because most of Sunset Strip goers are such.
We generally know the characteristics of our clientele with our available demographics of the area, our personal crowd would consist of young adults (ages 20-29) and adults (ages 30-50), both male and female, usually at least one year of college if not already fully graduated. Our geographics include people from the local Hollywood area, party animals from other neighboring cities, and tourists from other states and countries. The psychographics of our clientele include “yuppies, big spenders, club hoppers, baby boomers, Sunset rats, etc…” The buying patterns of our clientele will be people who like to spend money on pampering themselves, on quality food, feeling special, projecting an image of wealth, trying new things, and thrill seeking.
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Young adults | 8% | 638,949 | 686,870 | 738,385 | 793,764 | 853,296 | 7.50% |
Adults | 5% | 1,152,870 | 1,210,514 | 1,271,040 | 1,334,592 | 1,401,322 | 5.00% |
Total | 5.91% | 1,791,819 | 1,897,384 | 2,009,425 | 2,128,356 | 2,254,618 | 5.91% |
4.2 Target Market Segment Strategy
On The Water will focus on attracting young adults and adults ages 20-55, with an annual income of at least $15,000 to $60,000. We will concentrate on the high-end spenders who enjoy new restaurants, eating out, a fun atmosphere, and high-end food and service. We want the yuppies, baby boomers, high-end clubbers, tourists with money, wealthy image seekers and compulsive spenders. We focus on these specific groups because these are the types of people who frequent other clubs and restaurants like ours on Sunset Blvd. They are the ones that are willing to spend their money on good dining and service at high prices.
We generally know the characteristics of our clientele with our available demographics of the area, our personal crowd would consist of young adults and adults ages 20-55, both male and female, usually at least one year of college if not already fully graduated. Our geographics include people from the local Hollywood area, party animals from other neighboring cities, and tourists from other states and countries. The psychographics of our clientele include “yuppies, big spenders, club hoppers, baby boomers, Sunset rats, etc…” The buying patterns of our clientele will be people who like to spend money on pampering themselves, on quality food, feeling special, projecting an image of wealth, trying new things, and thrill seeking.
Strategy and Implementation Summary
The following sections outline the strategy and implementation summary for On The Water.
5.1 Sales Strategy
The important elements of the sales forecast are shown in the following table. The sales of food, drinks, and merchandise take a while to grow but will near $2 million in the second year.
Sales Forecast | |||
Year 1 | Year 2 | Year 3 | |
Unit Sales | |||
Covercharge | 0 | 0 | 0 |
Meals | 38,277 | 57,000 | 63,000 |
Drinks | 147,136 | 180,000 | 196,000 |
Restaurant Merchandise | 1,225 | 3,000 | 3,500 |
Total Unit Sales | 186,638 | 240,000 | 262,500 |
Unit Prices | Year 1 | Year 2 | Year 3 |
Covercharge | $0.00 | $0.00 | $0.00 |
Meals | $15.00 | $15.00 | $18.00 |
Drinks | $5.00 | $5.00 | $6.00 |
Restaurant Merchandise | $8.00 | $10.00 | $10.00 |
Sales | |||
Covercharge | $0 | $0 | $0 |
Meals | $574,155 | $855,000 | $1,134,000 |
Drinks | $735,680 | $900,000 | $1,176,000 |
Restaurant Merchandise | $9,800 | $30,000 | $35,000 |
Total Sales | $1,319,635 | $1,785,000 | $2,345,000 |
Direct Unit Costs | Year 1 | Year 2 | Year 3 |
Covercharge | $0.00 | $0.00 | $0.00 |
Meals | $3.00 | $4.00 | $5.00 |
Drinks | $0.50 | $0.60 | $0.75 |
Restaurant Merchandise | $3.00 | $4.00 | $4.50 |
Direct Cost of Sales | |||
Covercharge | $0 | $0 | $0 |
Meals | $114,831 | $228,000 | $315,000 |
Drinks | $73,568 | $108,000 | $147,000 |
Restaurant Merchandise | $3,675 | $12,000 | $15,750 |
Subtotal Direct Cost of Sales | $192,074 | $348,000 | $477,750 |
5.2 Milestones
The following table lists important program milestones, with dates and managers in charge, and budgets for each. The milestone schedule indicates our emphasis on planning for implementation. The most important programs are the sales and marketing programs listed in detail in the previous topics.
Milestones | |||||
Milestone | Start Date | End Date | Budget | Manager | Department |
Getting all furniture for restaurant | 11/4/2000 | 11/13/2000 | $3,000 | LVM | Design |
Getting jungle decorations for ceiling | 11/4/2000 | 11/18/2000 | $600 | LVM | Design |
Valet preparations | 10/5/2000 | 10/14/2000 | $500 | LVM | Management |
Painting/reconstuction of restaurant | 9/4/2000 | 10/16/2000 | $2,000 | LVM | Design |
Buying food for opening | 10/28/2000 | 10/29/2000 | $500 | LVM | Food |
Creation and distribution of fliers | 11/4/2000 | 1/20/2001 | $1,000 | LVM | Promotional |
Website | 9/1/2000 | 10/1/2000 | $1,000 | LVM | Management |
Production and completion of menus | 10/1/2000 | 10/30/2000 | $400 | LVM | Design |
Buying all supplies for kitchen | 8/1/2000 | 10/4/2000 | $7,000 | LVM | Management |
Staff Schedules | 8/1/2000 | 8/15/2000 | $0 | LVM | Management |
Totals | $16,000 |
Management Summary
Our management philosophy is based on responsibility and mutual respect. People who work at On The Water want to work there because we have an environment that encourages creativity and achievement. The team includes a maximum of eight to twelve employees, under a president/manager of one.
6.1 Personnel Plan
The personnel plan reflects what we would like to keep as a steady positioning through out the years. Our total headcount will increase from 8 to 12 come June because that’s the beginning of our “good” season. However, we plan to keep the head count at 12 because of the space and dynamics of the restaurant. It appears we don’t need more than 12 employees to run the business untill the fourth and fifth year, if and when we are successful enough to expand. Detailed monthly projections are included in the appendix.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Management | $41,580 | $45,738 | $50,312 |
Hostess | $16,170 | $17,787 | $19,566 |
Waiters/Waitresses | $55,860 | $61,446 | $67,591 |
Bartenders | $27,540 | $30,294 | $33,323 |
Bus Boys | $7,920 | $8,712 | $9,583 |
Cocktail Waitresses | $3,360 | $3,696 | $4,066 |
Chefs | $73,920 | $81,312 | $89,443 |
Total People | 12 | 12 | 12 |
Total Payroll | $226,350 | $248,985 | $273,884 |
Financial Plan
The following topics and tables outline our financial plan. We plan to turn a significant profit, but we will structure the business so as to maintain a healthy cash flow.
7.1 Important Assumptions
The financial plan depends upon important assumptions, most of which are shown in the following table. The key underlying assumptions are:
- We assume a slow-growth economy, without major recession.
- We assume that there are no unforseen changes in the expectancy in the popularity of our restaurant.
- We assume access to investments and financing are sufficient to maintain and fulfill our financial plan as shown in the tables.
General Assumptions | |||
Year 1 | Year 2 | Year 3 | |
Plan Month | 1 | 2 | 3 |
Current Interest Rate | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% |
Tax Rate | 25.42% | 25.00% | 25.42% |
Other | 0 | 0 | 0 |
7.2 Break-even Analysis
For our Break-even Analysis, we assume running costs which include our full payroll, rent, and utilities, and an estimation of other running costs.
Break-even Analysis | |
Monthly Units Break-even | 4,117 |
Monthly Revenue Break-even | $29,113 |
Assumptions: | |
Average Per-Unit Revenue | $7.07 |
Average Per-Unit Variable Cost | $1.03 |
Estimated Monthly Fixed Cost | $24,875 |
7.3 Projected Profit and Loss
The most important assumption in the Projected Profit and Loss statement is the gross margin. Although it doesn’t jump drastically in the first year, over given time the restaurant will develop its customer base and name, and the growth will pick up more rapidly towards the fourth and fifth years of business. The increase in gross margin will be due to a slow increase in sales prices and an increase in customer base, which is critical.
Month-by-month assumptions for profit and loss are included in the appendix.
Pro Forma Profit and Loss | |||
Year 1 | Year 2 | Year 3 | |
Sales | $1,319,635 | $1,785,000 | $2,345,000 |
Direct Cost of Sales | $192,074 | $348,000 | $477,750 |
Other | $0 | $0 | $0 |
Total Cost of Sales | $192,074 | $348,000 | $477,750 |
Gross Margin | $1,127,561 | $1,437,000 | $1,867,250 |
Gross Margin % | 85.44% | 80.50% | 79.63% |
Expenses | |||
Payroll | $226,350 | $248,985 | $273,884 |
Sales and Marketing and Other Expenses | $2,200 | $200 | $300 |
Depreciation | $0 | $0 | $0 |
Insurance | $0 | $0 | $0 |
Rent | $36,000 | $36,000 | $36,000 |
Utilities | $0 | $0 | $0 |
Leased Equipment | $0 | $0 | $0 |
Payroll Taxes | $33,953 | $37,348 | $41,083 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $298,503 | $322,533 | $351,266 |
Profit Before Interest and Taxes | $829,059 | $1,114,467 | $1,515,984 |
EBITDA | $829,059 | $1,114,467 | $1,515,984 |
Interest Expense | $0 | $0 | $0 |
Taxes Incurred | $207,115 | $278,617 | $385,313 |
Net Profit | $621,944 | $835,850 | $1,130,671 |
Net Profit/Sales | 47.13% | 46.83% | 48.22% |
7.4 Projected Cash Flow
The cash flow depends on assumptions for inventory turnover, payment days, and accounts receivable management. Our projected same-day collection is critical, and also reasonable and expected in the restaurant industry. We don’t expect to need that much continued support even when we reach the less profitable months, as they are expected.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Sales | $1,319,635 | $1,785,000 | $2,345,000 |
Subtotal Cash from Operations | $1,319,635 | $1,785,000 | $2,345,000 |
Additional Cash Received | |||
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 | $1,319,635 | $1,785,000 | $2,345,000 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $226,350 | $248,985 | $273,884 |
Bill Payments | $455,248 | $717,511 | $938,543 |
Subtotal Spent on Operations | $681,598 | $966,496 | $1,212,426 |
Additional Cash Spent | |||
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 | $681,598 | $966,496 | $1,212,426 |
Net Cash Flow | $638,037 | $818,504 | $1,132,574 |
Cash Balance | $660,037 | $1,478,541 | $2,611,115 |
7.5 Projected Balance Sheet
The projected Balance Sheet is quite solid. We do not project any real trouble meeting our debt obligations, as long as we can achieve our specific goals.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $660,037 | $1,478,541 | $2,611,115 |
Inventory | $25,988 | $47,085 | $64,641 |
Other Current Assets | $0 | $0 | $0 |
Total Current Assets | $686,025 | $1,525,626 | $2,675,755 |
Long-term Assets | |||
Long-term Assets | $45,000 | $45,000 | $45,000 |
Accumulated Depreciation | $0 | $0 | $0 |
Total Long-term Assets | $45,000 | $45,000 | $45,000 |
Total Assets | $731,025 | $1,570,626 | $2,720,755 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $55,531 | $59,282 | $78,740 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $55,531 | $59,282 | $78,740 |
Long-term Liabilities | $0 | $0 | $0 |
Total Liabilities | $55,531 | $59,282 | $78,740 |
Paid-in Capital | $115,000 | $115,000 | $115,000 |
Retained Earnings | ($61,450) | $560,494 | $1,396,344 |
Earnings | $621,944 | $835,850 | $1,130,671 |
Total Capital | $675,494 | $1,511,344 | $2,642,016 |
Total Liabilities and Capital | $731,025 | $1,570,626 | $2,720,755 |
Net Worth | $675,494 | $1,511,344 | $2,642,016 |
7.6 Business Ratios
Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 5812, Eating places, are shown for comparison.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Sales Growth | 0.00% | 35.26% | 31.37% | 7.60% |
Percent of Total Assets | ||||
Inventory | 3.56% | 3.00% | 2.38% | 3.60% |
Other Current Assets | 0.00% | 0.00% | 0.00% | 35.60% |
Total Current Assets | 93.84% | 97.13% | 98.35% | 43.70% |
Long-term Assets | 6.16% | 2.87% | 1.65% | 56.30% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 7.60% | 3.77% | 2.89% | 32.70% |
Long-term Liabilities | 0.00% | 0.00% | 0.00% | 28.50% |
Total Liabilities | 7.60% | 3.77% | 2.89% | 61.20% |
Net Worth | 92.40% | 96.23% | 97.11% | 38.80% |
Percent of Sales | ||||
Sales | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Margin | 85.44% | 80.50% | 79.63% | 60.50% |
Selling, General & Administrative Expenses | 38.33% | 65.53% | 56.44% | 39.80% |
Advertising Expenses | 0.00% | 0.00% | 0.00% | 3.20% |
Profit Before Interest and Taxes | 62.82% | 62.44% | 64.65% | 0.70% |
Main Ratios | ||||
Current | 12.35 | 25.74 | 33.98 | 0.98 |
Quick | 11.89 | 24.94 | 33.16 | 0.65 |
Total Debt to Total Assets | 7.60% | 3.77% | 2.89% | 61.20% |
Pre-tax Return on Net Worth | 122.73% | 73.74% | 57.38% | 1.70% |
Pre-tax Return on Assets | 113.41% | 70.96% | 55.72% | 4.30% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Profit Margin | 47.13% | 46.83% | 48.22% | n.a |
Return on Equity | 92.07% | 55.31% | 42.80% | n.a |
Activity Ratios | ||||
Inventory Turnover | 10.81 | 9.52 | 8.55 | n.a |
Accounts Payable Turnover | 8.92 | 12.17 | 12.17 | n.a |
Payment Days | 28 | 29 | 26 | n.a |
Total Asset Turnover | 1.81 | 1.14 | 0.86 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.08 | 0.04 | 0.03 | n.a |
Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $630,494 | $1,466,344 | $2,597,016 | n.a |
Interest Coverage | 0.00 | 0.00 | 0.00 | n.a |
Additional Ratios | ||||
Assets to Sales | 0.55 | 0.88 | 1.16 | n.a |
Current Debt/Total Assets | 8% | 4% | 3% | n.a |
Acid Test | 11.89 | 24.94 | 33.16 | n.a |
Sales/Net Worth | 1.95 | 1.18 | 0.89 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Unit Sales | |||||||||||||
Covercharge | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Meals | 0% | 0 | 1,822 | 2,552 | 2,552 | 2,552 | 2,552 | 2,552 | 4,739 | 4,739 | 4,739 | 4,739 | 4,739 |
Drinks | 0% | 0 | 7,006 | 9,809 | 9,809 | 9,809 | 9,809 | 9,809 | 18,217 | 18,217 | 18,217 | 18,217 | 18,217 |
Restaurant Merchandise | 0% | 0 | 25 | 100 | 100 | 100 | 100 | 100 | 200 | 200 | 100 | 100 | 100 |
Total Unit Sales | 0 | 8,853 | 12,461 | 12,461 | 12,461 | 12,461 | 12,461 | 23,156 | 23,156 | 23,056 | 23,056 | 23,056 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Covercharge | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Meals | $0.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | |
Drinks | $0.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | |
Restaurant Merchandise | $0.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | $8.00 | |
Sales | |||||||||||||
Covercharge | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Meals | $0 | $27,330 | $38,280 | $38,280 | $38,280 | $38,280 | $38,280 | $71,085 | $71,085 | $71,085 | $71,085 | $71,085 | |
Drinks | $0 | $35,030 | $49,045 | $49,045 | $49,045 | $49,045 | $49,045 | $91,085 | $91,085 | $91,085 | $91,085 | $91,085 | |
Restaurant Merchandise | $0 | $200 | $800 | $800 | $800 | $800 | $800 | $1,600 | $1,600 | $800 | $800 | $800 | |
Total Sales | $0 | $62,560 | $88,125 | $88,125 | $88,125 | $88,125 | $88,125 | $163,770 | $163,770 | $162,970 | $162,970 | $162,970 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Covercharge | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Meals | 0.00% | $0.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 |
Drinks | 0.00% | $0.00 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 |
Restaurant Merchandise | 0.00% | $0.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 |
Direct Cost of Sales | |||||||||||||
Covercharge | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Meals | $0 | $5,466 | $7,656 | $7,656 | $7,656 | $7,656 | $7,656 | $14,217 | $14,217 | $14,217 | $14,217 | $14,217 | |
Drinks | $0 | $3,503 | $4,905 | $4,905 | $4,905 | $4,905 | $4,905 | $9,109 | $9,109 | $9,109 | $9,109 | $9,109 | |
Restaurant Merchandise | $0 | $75 | $300 | $300 | $300 | $300 | $300 | $600 | $600 | $300 | $300 | $300 | |
Subtotal Direct Cost of Sales | $0 | $9,044 | $12,861 | $12,861 | $12,861 | $12,861 | $12,861 | $23,926 | $23,926 | $23,626 | $23,626 | $23,626 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Management | 0% | $0 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 | $3,780 |
Hostess | 0% | $0 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 |
Waiters/Waitresses | 0% | $0 | $4,410 | $4,410 | $4,410 | $4,410 | $4,410 | $4,410 | $5,880 | $5,880 | $5,880 | $5,880 | $5,880 |
Bartenders | 0% | $0 | $0 | $2,430 | $2,430 | $2,430 | $2,430 | $2,430 | $3,078 | $3,078 | $3,078 | $3,078 | $3,078 |
Bus Boys | 0% | $0 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 | $720 |
Cocktail Waitresses | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $672 | $672 | $672 | $672 | $672 |
Chefs | 0% | $0 | $4,620 | $4,620 | $4,620 | $4,620 | $4,620 | $4,620 | $9,240 | $9,240 | $9,240 | $9,240 | $9,240 |
Total People | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 12 | 12 | 12 | 12 | |
Total Payroll | $0 | $15,000 | $17,430 | $17,430 | $17,430 | $17,430 | $17,430 | $24,840 | $24,840 | $24,840 | $24,840 | $24,840 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
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% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $0 | $62,560 | $88,125 | $88,125 | $88,125 | $88,125 | $88,125 | $163,770 | $163,770 | $162,970 | $162,970 | $162,970 | |
Direct Cost of Sales | $0 | $9,044 | $12,861 | $12,861 | $12,861 | $12,861 | $12,861 | $23,926 | $23,926 | $23,626 | $23,626 | $23,626 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $9,044 | $12,861 | $12,861 | $12,861 | $12,861 | $12,861 | $23,926 | $23,926 | $23,626 | $23,626 | $23,626 | |
Gross Margin | $0 | $53,516 | $75,265 | $75,265 | $75,265 | $75,265 | $75,265 | $139,845 | $139,845 | $139,345 | $139,345 | $139,345 | |
Gross Margin % | 0.00% | 85.54% | 85.41% | 85.41% | 85.41% | 85.41% | 85.41% | 85.39% | 85.39% | 85.50% | 85.50% | 85.50% | |
Expenses | |||||||||||||
Payroll | $0 | $15,000 | $17,430 | $17,430 | $17,430 | $17,430 | $17,430 | $24,840 | $24,840 | $24,840 | $24,840 | $24,840 | |
Sales and Marketing and Other Expenses | $0 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Utilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Payroll Taxes | 15% | $0 | $2,250 | $2,615 | $2,615 | $2,615 | $2,615 | $2,615 | $3,726 | $3,726 | $3,726 | $3,726 | $3,726 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $3,000 | $20,450 | $23,245 | $23,245 | $23,245 | $23,245 | $23,245 | $31,766 | $31,766 | $31,766 | $31,766 | $31,766 | |
Profit Before Interest and Taxes | ($3,000) | $33,066 | $52,020 | $52,020 | $52,020 | $52,020 | $52,020 | $108,079 | $108,079 | $107,579 | $107,579 | $107,579 | |
EBITDA | ($3,000) | $33,066 | $52,020 | $52,020 | $52,020 | $52,020 | $52,020 | $108,079 | $108,079 | $107,579 | $107,579 | $107,579 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($900) | $8,267 | $13,005 | $13,005 | $13,005 | $13,005 | $13,005 | $27,020 | $27,020 | $26,895 | $26,895 | $26,895 | |
Net Profit | ($2,100) | $24,800 | $39,015 | $39,015 | $39,015 | $39,015 | $39,015 | $81,059 | $81,059 | $80,684 | $80,684 | $80,684 | |
Net Profit/Sales | 0.00% | 39.64% | 44.27% | 44.27% | 44.27% | 44.27% | 44.27% | 49.50% | 49.50% | 49.51% | 49.51% | 49.51% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $62,560 | $88,125 | $88,125 | $88,125 | $88,125 | $88,125 | $163,770 | $163,770 | $162,970 | $162,970 | $162,970 | |
Subtotal Cash from Operations | $0 | $62,560 | $88,125 | $88,125 | $88,125 | $88,125 | $88,125 | $163,770 | $163,770 | $162,970 | $162,970 | $162,970 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.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 | $0 | $62,560 | $88,125 | $88,125 | $88,125 | $88,125 | $88,125 | $163,770 | $163,770 | $162,970 | $162,970 | $162,970 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $0 | $15,000 | $17,430 | $17,430 | $17,430 | $17,430 | $17,430 | $24,840 | $24,840 | $24,840 | $24,840 | $24,840 | |
Bill Payments | $15,520 | $3,054 | $30,881 | $35,738 | $31,680 | $31,680 | $31,680 | $32,959 | $69,637 | $57,846 | $57,127 | $57,446 | |
Subtotal Spent on Operations | $15,520 | $18,054 | $48,311 | $53,168 | $49,110 | $49,110 | $49,110 | $57,799 | $94,477 | $82,686 | $81,967 | $82,286 | |
Additional Cash Spent | |||||||||||||
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 | $15,520 | $18,054 | $48,311 | $53,168 | $49,110 | $49,110 | $49,110 | $57,799 | $94,477 | $82,686 | $81,967 | $82,286 | |
Net Cash Flow | ($15,520) | $44,506 | $39,814 | $34,957 | $39,015 | $39,015 | $39,015 | $105,971 | $69,293 | $80,284 | $81,003 | $80,684 | |
Cash Balance | $6,480 | $50,986 | $90,800 | $125,757 | $164,772 | $203,787 | $242,802 | $348,773 | $418,066 | $498,350 | $579,353 | $660,037 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $22,000 | $6,480 | $50,986 | $90,800 | $125,757 | $164,772 | $203,787 | $242,802 | $348,773 | $418,066 | $498,350 | $579,353 | $660,037 |
Inventory | $2,000 | $2,000 | $9,948 | $14,147 | $14,147 | $14,147 | $14,147 | $14,147 | $26,318 | $26,318 | $25,988 | $25,988 | $25,988 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $24,000 | $8,480 | $60,935 | $104,947 | $139,904 | $178,919 | $217,934 | $256,949 | $375,091 | $444,384 | $524,338 | $605,341 | $686,025 |
Long-term Assets | |||||||||||||
Long-term Assets | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
Total Assets | $69,000 | $53,480 | $105,935 | $149,947 | $184,904 | $223,919 | $262,934 | $301,949 | $420,091 | $489,384 | $569,338 | $650,341 | $731,025 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $15,450 | $2,030 | $29,685 | $34,682 | $30,624 | $30,624 | $30,624 | $30,624 | $67,708 | $55,942 | $55,212 | $55,531 | $55,531 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $15,450 | $2,030 | $29,685 | $34,682 | $30,624 | $30,624 | $30,624 | $30,624 | $67,708 | $55,942 | $55,212 | $55,531 | $55,531 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $15,450 | $2,030 | $29,685 | $34,682 | $30,624 | $30,624 | $30,624 | $30,624 | $67,708 | $55,942 | $55,212 | $55,531 | $55,531 |
Paid-in Capital | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 | $115,000 |
Retained Earnings | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) | ($61,450) |
Earnings | $0 | ($2,100) | $22,700 | $61,715 | $100,730 | $139,745 | $178,760 | $217,775 | $298,833 | $379,892 | $460,576 | $541,260 | $621,944 |
Total Capital | $53,550 | $51,450 | $76,250 | $115,265 | $154,280 | $193,295 | $232,310 | $271,325 | $352,383 | $433,442 | $514,126 | $594,810 | $675,494 |
Total Liabilities and Capital | $69,000 | $53,480 | $105,935 | $149,947 | $184,904 | $223,919 | $262,934 | $301,949 | $420,091 | $489,384 | $569,338 | $650,341 | $731,025 |
Net Worth | $53,550 | $51,450 | $76,249 | $115,265 | $154,280 | $193,295 | $232,310 | $271,325 | $352,383 | $433,442 | $514,126 | $594,810 | $675,494 |