Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Internet icon Tourism Website Services Business Plan

Start your plan

Spanish Resources

Executive Summary

The Internet is changing the World. Before our eyes, the World Wide Web is systematically transforming industry after industry. To an increasing extent, a company does not exist if it is not present on the Internet.

Spanish Resources plans to exploit this trend. The tourism industry is in the early stages of being transformed by the Internet. Spanish Resources will passionately focus on the Mexican tourism segments of this industry. The company will bring Mexican resorts and tourist destinations onto the World Wide Web. By creating websites for our clients, we will establish them on the Web at a key moment in the transformation of the tourism industry.

The company will use its marketing resources to define a new niche in the Mexican tourism market. This niche focus will include website design and overall Web strategy for resort operators and other tourist destinations in Mexico. We will then define ourselves as the leader in this niche.

Spanish Resources expects revenue of $751,350 in the first year, $1,441,500 in the second year and $1,807,550 in the third year. Profits for the same time periods will increase steadily.

We expect employee headcount to grow from four to eleven over the first year and to hold steady there after. The company expects paid-in capital of $300,000 to provide more then adequate working capital for the duration of the plan.

The company will provide a turn-key solution to its clients. However, we will rely on multiple outside vendors to supply website implementation and hosting. The company will provide all other aspects of the service.

Tourism website services business plan, executive summary chart image

1.1 Objectives

Our most important objectives are:

  1. Three major referenceable accounts in the first six months.
  2. An annual revenue of $1,441,500 in the second year.
  3. In the first year, at least fifteen mentions of the company in tourism industry magazines and newsletters.

1.2 Mission

Spanish Resources will remove the language and technology barriers to travel destination operators in Mexico through the use of the Internet in order to reach perspective english-speaking tourists.

We will provide a dynamic and fun work environment with stable, long-term job opportunities that will include exotic travel for some employees and incentive bonuses for all key personnel.

Company Summary

Spanish Resources will be incorporated in the state of Connecticut as a general corporation (Subchapter C).

The company will provide website development services to tourism destinations in Mexico. Although the company has no operating history, the founders, Carolyn and Jerry, have extensive experience in the competencies required for the company to succeed. The company will have a more than adequate amount, with $300,000 investment.

2.1 Start-up Summary

There are three features of the start-up expenses that are worth noting.

First, the research and development expense involves the founders traveling to appropriate destinations to gather first-hand information about the market and market conditions.

Second, the company is investing heavily in sales collateral because of the need to project a strong quality image from the company’s inception.

Third, the company is assuming the need for only a single base of operations.

Tourism website services business plan, company summary chart image

Start-up
Requirements
Start-up Expenses
Legal $5,000
Stationery etc. $1,000
Brochures $7,500
Consultants $20,000
Insurance $2,000
Rent $1,500
Research and development $20,000
Expensed equipment $500
Other $5,000
Total Start-up Expenses $62,500
Start-up Assets
Cash Required $367,500
Other Current Assets $0
Long-term Assets $20,000
Total Assets $387,500
Total Requirements $450,000
Start-up Funding
Start-up Expenses to Fund $62,500
Start-up Assets to Fund $387,500
Total Funding Required $450,000
Assets
Non-cash Assets from Start-up $20,000
Cash Requirements from Start-up $367,500
Additional Cash Raised $0
Cash Balance on Starting Date $367,500
Total Assets $387,500
Liabilities and Capital
Liabilities
Current Borrowing $100,000
Long-term Liabilities $0
Accounts Payable (Outstanding Bills) $50,000
Other Current Liabilities (interest-free) $0
Total Liabilities $150,000
Capital
Planned Investment
Founders $300,000
Other $0
Additional Investment Requirement $0
Total Planned Investment $300,000
Loss at Start-up (Start-up Expenses) ($62,500)
Total Capital $237,500
Total Capital and Liabilities $387,500
Total Funding $450,000

Services

The company will offer two basic services: creating a basic website, and creating an in-depth website.

The company’s core competencies are an understanding of cultural and linguistic issues and the infrastructure of the World Wide Web. The company intends to partner with firms that are proficient in website implementation, rather than building such an operation internally.

In order to provide a high level of service, the company will have operations in both Stamford, Connecticut and in Mexico. The Stamford operation will serve as headquarters and the point of contact for partner Web design firms. The Mexican operation will support direct sales, after sales support and account management.

3.1 Service Description

The company offers two basic categories of service.

The basic service, which is sold to small resorts and travel destination, provides a simple website. This website will typically include photographs, location and contact details for the destination. In addition, the website will be submitted to all of the Web search engines and be provided to travel- oriented websites.

The basic website is designed to inform Web users about the existence of resorts and travel destinations. This basic level of service is provided for people whose primary goal is establishing a presence on the Web. This service will cost $2,000 to $3,000 dollars.

The in-depth website is designed for large resorts. This site provides everything included in the basic website and adds more depth and interactivity. This form of website will provide more detailed description and images of the resort and its facilities.

In addition, the website will allow users to make bookings, ask for promotional literature to be mailed to them and make other requests directly of the resort operators. The in-depth website goes beyond a presence on the Web, by using the Web to establish the initial relationship with potential guests. We will make the in-depth website available to smaller resorts and other destinations if requested. This service cost $8,500.

We intend to provide ongoing services to basic and in-depth website customers that will include updates and expansions of their site, as well as brokerage for Web hosting services. We expect ongoing services to account for approximately the same dollar amounts as the initial contracts.

3.2 Fulfillment

Fulfillment for the company relies on both internal resources and our Web designer partners. The company will establish relations with at least two Web design firms.

The company will handle the direct relationships with the clients including all linguistic and cultural issues as well as a collection of imagery, identification of key resort facilities, and a high-level design concept for the website.

The Web design firm will be responsible for converting imagery to computer form, typesetting of text, and other technical website implementation issues. For basic website work, the Web design firm will be paid from $1,000 to $1,500 and for in-depth website work, they will be paid from $3,000-$3,500 dollars.

Market Analysis Summary

The tourism market in Mexico is enormous. In 1998, according to The Bank of Mexico, 19.8 million international tourists traveled to Mexico and spent over six billion dollars.

350 major hotels and thousands of smaller travel destinations serviced these tourists. Increasingly tourists are researching and booking travel using the Internet.

There are 20 travel websites already and this number is projected to increase by 100% by the end of 2001.

The company plans to target the large resorts that don’t yet have a website and expand into the thousands of smaller destinations as the business develops.

The company will approach this market primarily through advertising. Our advertising will serve two different functions.

First, we will use testimonials from reference accounts to expose the benefits of our services to tourism operators.

Second, we will use advertising through trade publications and direct mail to establish a brand that the Mexican tourism industry will associate with high-quality professional services.

4.1 Market Segmentation

We broadly divide our market between resort hotels and other travel destinations. Within resort hotels we segment between 1, 2, 3, 4, and 5 star hotels.

Within other travel destinations we include apartments, bed and breakfast, suits, villas, condos, trailer parks, and bungalows.

Within the category of resort hotels, we define large resorts as being 4 or 5 star hotels.

We define smaller resorts as 3 or 4 star hotels. Please note this analysis counts 4 star hotels twice.

In addition, we have excluded 1 and 2 star hotels entirely. Furthermore the company believes these estimates are conservative because they exclude the major beach resort areas such as Acapulco, Puerto Vayarta, Cancun, Zihuatenejo, Ixtapa, etc.

Tourism website services business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Large resorts 10% 557 613 674 741 815 9.98%
Smaller resorts 10% 1,136 1,250 1,375 1,513 1,664 10.01%
Other travel destinations 10% 678 746 821 903 993 10.01%
Total 10.00% 2,371 2,609 2,870 3,157 3,472 10.00%

4.2 Target Market Segment Strategy

The company’s market strategy is to focus on resort hotels and tourist travel destinations in Mexico that meet two important criteria.

First, we are targeting the segments of the market that can afford Web-based promotion.

Second, we are targeting those segments of the market that can benefit from a presence on the World Wide Web.

The company has gathered market data from the official Mexican tourism website. To be conservative, we gathered data that excludes the major beach resort areas.

Many of the major beach resorts already have websites. Although we intend to target those areas as well, for purposes of this analysis, we have left them out of the numerical totals. If they were included, these resorts would approximately double the number of large resorts. Smaller resorts and other travel destinations would also be affected, but by a smaller amount.

Although there are many more 1 and 2 star hotels then any other category, the company decided to exclude them because their segment can neither afford nor benefit from a presence on the World Wide Web.

We decided to include 4 star hotels in both large and small resort segments because we predict that 4 star operators will divide themselves between large and small service offerings.

It is also important to note that many of the 4 and 5 star hotels are controled by resort chains, where as the smaller hotels tend to be individually owned.

Furthermore, 5 star hotels often have affiliations with other travel destinations such as golf courses. Also note that the predicted 10% growth rate was estimated by the company, not by the tourism board.

Strategy and Implementation Summary

The company will focus on the Mexican tourism market. By using the company’s services, our clients will either establish, or improve, their presence on the World Wide Web. By using this Web presence, they will be able to reach ten of millions of consumers who use the Web regularly.

Our marketing strategy is based on testimonial and reference advertising. We will use trade publications and direct advertising to establish our brand as the high quality source for Web design and infrastructure services in the Mexican tourism industry.

Our strategy involves creating a niche for Web services in our industry and then positioning ourselves as the leader in this new niche.

Our sales strategy will begin by supporting marketing’s need for reference accounts.

Subsequently sales will focus in two areas. First, the sales force will work leads generated by advertising and word of mouth to establish new customer accounts. Second, the sales force will work with existing customers to renew and improve their website.

5.1 Competitive Edge

There are four principal things that will differentiate Spanish Resources from the competition.

First, the company will have a blend of both Mexican cultural understanding, and World Wide Web infrastructure.

Second, the company will build a strong brand through advertising and promotion.

Third, the company intends to define its business activities as a new niche blending website design with Mexican tourism.

Fourth, the company will use its position as an early entrant in this new niche to create opportunities for a word of mouth reputation based on quality and a high level of service.

Taken together, these four differentiators represent a proven World Wide Web competitive strategy.

As Web markets move from the early stages of experimentation into more mainstream usage, an opportunity is created to aggressively define a new service niche targeted specifically on the peculiar needs of a specialized market.

The company’s research indicates that several resorts are experimenting with websites. As tourism booking move online, this market is a natural target for such a strategy.

5.2 Sales Strategy

The company’s sales strategy has two distinct phases.

In the first phase the company will identify direct sales opportunities in Mexican regions that have a high concentration of resorts. The direct sales force will approach these sales opportunities in one-on-one meetings.

The primary goals in this first phase are locating accounts that appear to be good candidates for advertising references (for example a famous Acapulco resort), improving the quality of the sales presentation and refining sales technique. Meeting revenue targets are secondary consideration in the first phase.

In the second phase, the company expects to generate sales leads from advertising promotion and word of mouth. This should make the direct sales force more efficient, and therefore capable of making revenue targets the primary sales goal. Furthermore, the sales force will be operating on a steadily increasing client base from whom new orders can be taken.

The company expects the first phase to take approximately six months and the second phase to begin thereafter.

The company’s compensation plan for salespeople is based on a combination of base salary and sales commissions.

5.2.1 Sales Forecast

The sales forecast is based on several assumptions.

First, that the potential market is very large, in particular there is significant pent-up demand for an Internet presence among travel destination operators.

Second, that initial sales will come from sales calls on potential clients.

Third, that establishing reference accounts are the most important early sales targets.

Fourth, that advertising and promotion, in the presence of referenceable accounts, will generate most of the sales leads starting in the third quarter of operation and extending into the steady state.

The principal limiter of sales volume is the company’s capacity. We expect advertising to generate more sales leads then the company can fulfill.

Therefore, we have projected approximately 25% year-on-year sales growth based roughly on the growth and size of operation. Furthermore, we anticipate the ability to be selective about clientele due to the excess demand for the company’s services.

Tourism website services business plan, strategy and implementation summary chart image

Tourism website services business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3
Unit Sales
Large resorts 41 90 113
Smaller resorts 89 150 188
Other travel destinations 71 120 150
Total Unit Sales 201 360 451
Unit Prices Year 1 Year 2 Year 3
Large resorts $8,350.00 $8,350.00 $8,350.00
Smaller resorts $3,000.00 $3,000.00 $3,000.00
Other travel destinations $2,000.00 $2,000.00 $2,000.00
Sales
Large resorts $342,350 $751,500 $943,550
Smaller resorts $267,000 $450,000 $564,000
Other travel destinations $142,000 $240,000 $300,000
Total Sales $751,350 $1,441,500 $1,807,550
Direct Unit Costs Year 1 Year 2 Year 3
Large resorts $3,000.00 $3,000.00 $3,000.00
Smaller resorts $1,500.00 $1,500.00 $1,500.00
Other travel destinations $1,000.00 $1,000.00 $1,000.00
Direct Cost of Sales
Large resorts $123,000 $270,000 $339,000
Smaller resorts $133,500 $225,000 $282,000
Other travel destinations $71,000 $120,000 $150,000
Subtotal Direct Cost of Sales $327,500 $615,000 $771,000

Management Summary

At the end of the first year of operation, the company will have eleven employees. Of these, two of whom will be founders and two of whom will be managers (yet to be hired). The plan also includes three account managers, a bookkeeper, and three administrative assistants.

Carolyn’s general responsibilities will be: overseeing client relationships, supervising all cultural and linguistic issues, and insuring that the final design meets the customer’s expectations.

Carolyn will also provide overall management for the company by supervising the sales and marketing manager and the production manager (yet to be hired).

Carolyn was born in Mexico City and grew up completely bilingual and bicultural. She has an undergrad degree from the University of Notre Dame and a masters in Spanish and education from the University of Connecticut. She has had the wonderful opportunity of working as director of human resources for Palo Alto Software, Inc.. In that role Carolyn has gained experience hiring, training and managing people.

Jerry’s overall responsibilities will include: finance, legal, accounting, and general business guidance. Jerry will also negotiate and oversee the partnering relationships with Web design firms.

Jerry has been a founder or cofounder of six businesses including Spanish Resources. One of his companies, Intertrust Technologies Corp, is publicly traded on the NASDAQ exchange. He has thirteen years experience in all areas of general business including technology, management, finance, legal and general administrative functions.

The sales and marketing manager will report to Carolyn and be responsible for overseeing both the account managers in sales and the company’s marketing efforts.

The marketing activities will involve extensive contact with the press, as well as overseeing outside contractors for the development of sales collateral and other materials. The sales and marketing manager will also be responsible for developing corporate identity materials.

The account managers serve a dual role: they provide the direct sales force as well as a point of customer care after the sale. The first account manager will be located in Mexico to provide the cultural familiarity necessary to make sales. The account managers report to the sales and marketing manager.

The production manager will oversee the day to day flow of information between customers, Spanish Resources, and the outside Web design firms. The production manger will insure that the high-level design is carried out, that production schedules are met, and that standards of quality are maintained. The production manager reports to Carolyn.

6.1 Personnel Plan

The initial team consists of the founders, Carolyn and Jerry, an office assistant and an account manager.

Carolyn and Jerry will be production, sales and marketing management for the initial team. After the reference accounts are established, the team will be expanded to include a half-time bookkeeper, a second account manger, and both the sales and marketing manager and the production manager.

As sales ramp up, the bookkeeper will move to full time, and an additional account manager will be added as well as assistants for both the sales and marketing manager and the production manager.

Personnel Plan
Year 1 Year 2 Year 3
Carolyn $24,000 $28,000 $30,000
Jerry $12,000 $26,000 $28,000
Office assistant $18,000 $20,000 $22,000
Bookkeeper $13,500 $26,000 $32,000
Account manager $16,500 $27,000 $30,000
Account manager $22,500 $26,500 $29,000
Account manager $4,500 $24,000 $2,700
Production manager $12,750 $33,000 $36,000
Production assistant $4,500 $20,000 $22,000
Sales and marketing manager $18,000 $36,000 $39,000
Sales and marketing assistant $4,500 $20,000 $22,000
Total People 11 17 18
Total Payroll $150,750 $286,500 $292,700

Financial Plan

The company plans to raise $300,000 in paid-in capital.

As the following tables indicate, this will provide a substantial working capital reserve. This reserve can be used either to finance unexpected short falls in sales or to exploit new market opportunities as the plan unfolds.

Each of the tables contains additional explanatory materials related to the details of our plan.

7.1 Important Assumptions

In addition to general assumption in the table below, the company has made additional assumption about the state of the ecomony, the tourism industry, and the Internet.

The company assumes the economy remains strong, and in particular that the tourism industry continues to experience moderate growth.

The company assumes that the Internet will continue to expand into mainstream of everyday life and particularly that the Internet is increasingly important to the tourism industry.

The company assumes that significant and increasing demand exists for the company’s services.

General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest Rate 12.00% 12.00% 12.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

Note that break-even is expected in the second year of operations.

Tourism website services business plan, financial plan chart image

Break-even Analysis
Monthly Units Break-even 18
Monthly Revenue Break-even $67,711
Assumptions:
Average Per-Unit Revenue $3,738.06
Average Per-Unit Variable Cost $1,629.35
Estimated Monthly Fixed Cost $38,197

7.3 Projected Profit and Loss

There are several features of the company’s Profit and Loss statement that merit explanation.

First, note the 90% increase in sales between year one and year two and the 25% increase between year two and year three.

The dramatic difference is explained by examining fourth quarter sales numbers in year one. If the fourth quarter numbers in year one were extended for an entire year, the sales growth between that year and year two would be approximately 25%.

Second, the dramatic growth in overall marketing budget (60% from year one to year two) is explained by the company’s strategy of using advertising generated sales leads as the most important source of new clients.

Third, it is worth noting that the increase in profit from year two to year three is much greater then the corresponding increase in sales. This is due to the need to both hire and train personnel ahead of increased sales expected in year three and the need to spend heavily in marketing in year two to achieve those sales.

Fourth, the lack of an advertising and promotion budget for the first quarter in year one is due to the company’s strategy of using reference account in company’s advertisements. The first reference accounts will be established in the first quarter of year one with advertising based on those accounts starting in the second quarter.

Tourism website services business plan, financial plan chart image

Tourism website services business plan, financial plan chart image

Tourism website services business plan, financial plan chart image

Tourism website services business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $751,350 $1,441,500 $1,807,550
Direct Cost of Sales $327,500 $615,000 $771,000
Other $0 $0 $0
Total Cost of Sales $327,500 $615,000 $771,000
Gross Margin $423,850 $826,500 $1,036,550
Gross Margin % 56.41% 57.34% 57.35%
Expenses
Payroll $150,750 $286,500 $292,700
Sales and Marketing and Other Expenses $250,200 $406,000 $470,000
Depreciation $0 $0 $0
Leased Equipment $0 $0 $0
Utilities $15,000 $0 $0
Insurance $1,800 $0 $0
Rent $18,000 $0 $0
Payroll Taxes $22,613 $42,975 $43,905
Other $0 $0 $0
Total Operating Expenses $458,363 $735,475 $806,605
Profit Before Interest and Taxes ($34,513) $91,025 $229,945
EBITDA ($34,513) $91,025 $229,945
Interest Expense $12,000 $12,000 $12,000
Taxes Incurred $0 $19,756 $55,394
Net Profit ($46,513) $59,269 $162,551
Net Profit/Sales -6.19% 4.11% 8.99%

7.4 Projected Cash Flow

Note that the company uses a significantly portion of its working capital to manage cash requirements.

Also note that accounts receivable vs. accounts payable is well within manageable limits relative to the company’s monthly cash flow.

Tourism website services business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $300,540 $576,600 $723,020
Cash from Receivables $337,412 $760,739 $1,029,284
Subtotal Cash from Operations $637,952 $1,337,339 $1,752,304
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 $637,952 $1,337,339 $1,752,304
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $150,750 $286,500 $292,700
Bill Payments $625,144 $1,077,639 $1,331,212
Subtotal Spent on Operations $775,894 $1,364,139 $1,623,912
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 $775,894 $1,364,139 $1,623,912
Net Cash Flow ($137,942) ($26,801) $128,392
Cash Balance $229,558 $202,757 $331,149

7.5 Projected Balance Sheet

Due to the $300,000 of paid-in capital and the company’s turn to profitability in the second year, the company’s balance sheet is robust.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $229,558 $202,757 $331,149
Accounts Receivable $113,398 $217,559 $272,806
Other Current Assets $0 $0 $0
Total Current Assets $342,956 $420,316 $603,955
Long-term Assets
Long-term Assets $20,000 $20,000 $20,000
Accumulated Depreciation $0 $0 $0
Total Long-term Assets $20,000 $20,000 $20,000
Total Assets $362,956 $440,316 $623,955
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $71,968 $90,060 $111,148
Current Borrowing $100,000 $100,000 $100,000
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $171,968 $190,060 $211,148
Long-term Liabilities $0 $0 $0
Total Liabilities $171,968 $190,060 $211,148
Paid-in Capital $300,000 $300,000 $300,000
Retained Earnings ($62,500) ($109,013) ($49,744)
Earnings ($46,513) $59,269 $162,551
Total Capital $190,988 $250,256 $412,807
Total Liabilities and Capital $362,956 $440,316 $623,955
Net Worth $190,988 $250,256 $412,807

7.6 Business Ratios

The following table outlines some of the more important ratios from the Administrative Management and General Management industry. The final column, Industry Profile, details specific ratios based on the industry as it is classified by the Standard Industry Classification (SIC) code, 8742.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth 0.00% 91.85% 25.39% 6.98%
Percent of Total Assets
Accounts Receivable 31.24% 49.41% 43.72% 26.80%
Other Current Assets 0.00% 0.00% 0.00% 43.95%
Total Current Assets 94.49% 95.46% 96.79% 75.76%
Long-term Assets 5.51% 4.54% 3.21% 24.24%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 47.38% 43.16% 33.84% 31.78%
Long-term Liabilities 0.00% 0.00% 0.00% 17.26%
Total Liabilities 47.38% 43.16% 33.84% 49.04%
Net Worth 52.62% 56.84% 66.16% 50.96%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 56.41% 57.34% 57.35% 100.00%
Selling, General & Administrative Expenses 62.60% 53.22% 48.30% 85.31%
Advertising Expenses 10.94% 13.87% 13.28% 1.02%
Profit Before Interest and Taxes -4.59% 6.31% 12.72% 1.90%
Main Ratios
Current 1.99 2.21 2.86 1.88
Quick 1.99 2.21 2.86 1.48
Total Debt to Total Assets 47.38% 43.16% 33.84% 55.78%
Pre-tax Return on Net Worth -24.35% 31.58% 52.80% 3.41%
Pre-tax Return on Assets -12.81% 17.95% 34.93% 7.72%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin -6.19% 4.11% 8.99% n.a
Return on Equity -24.35% 23.68% 39.38% n.a
Activity Ratios
Accounts Receivable Turnover 3.98 3.98 3.98 n.a
Collection Days 56 70 83 n.a
Accounts Payable Turnover 8.99 12.17 12.17 n.a
Payment Days 29 27 27 n.a
Total Asset Turnover 2.07 3.27 2.90 n.a
Debt Ratios
Debt to Net Worth 0.90 0.76 0.51 n.a
Current Liab. to Liab. 1.00 1.00 1.00 n.a
Liquidity Ratios
Net Working Capital $170,988 $230,256 $392,807 n.a
Interest Coverage -2.88 7.59 19.16 n.a
Additional Ratios
Assets to Sales 0.48 0.31 0.35 n.a
Current Debt/Total Assets 47% 43% 34% n.a
Acid Test 1.33 1.07 1.57 n.a
Sales/Net Worth 3.93 5.76 4.38 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
Large resorts 0% 0 1 1 2 2 2 5 5 5 6 6 6
Smaller resorts 0% 3 3 5 8 8 8 8 8 8 10 10 10
Other travel destinations 0% 3 3 5 6 6 6 6 6 6 8 8 8
Total Unit Sales 6 7 11 16 16 16 19 19 19 24 24 24
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
Large resorts $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00 $8,350.00
Smaller resorts $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00
Other travel destinations $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00 $2,000.00
Sales
Large resorts $0 $8,350 $8,350 $16,700 $16,700 $16,700 $41,750 $41,750 $41,750 $50,100 $50,100 $50,100
Smaller resorts $9,000 $9,000 $15,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $30,000 $30,000 $30,000
Other travel destinations $6,000 $6,000 $10,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $16,000 $16,000 $16,000
Total Sales $15,000 $23,350 $33,350 $52,700 $52,700 $52,700 $77,750 $77,750 $77,750 $96,100 $96,100 $96,100
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
Large resorts 0.00% $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00
Smaller resorts 0.00% $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00
Other travel destinations 0.00% $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
Direct Cost of Sales
Large resorts $0 $3,000 $3,000 $6,000 $6,000 $6,000 $15,000 $15,000 $15,000 $18,000 $18,000 $18,000
Smaller resorts $4,500 $4,500 $7,500 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $15,000 $15,000 $15,000
Other travel destinations $3,000 $3,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $8,000 $8,000 $8,000
Subtotal Direct Cost of Sales $7,500 $10,500 $15,500 $24,000 $24,000 $24,000 $33,000 $33,000 $33,000 $41,000 $41,000 $41,000
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
Carolyn 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Jerry 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Office assistant 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Bookkeeper 0% $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $3,000 $3,000 $3,000
Account manager 0% $0 $0 $0 $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Account manager 0% $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Account manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Production manager 0% $0 $0 $0 $0 $0 $0 $1,250 $1,250 $1,250 $3,000 $3,000 $3,000
Production assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Sales and marketing manager 0% $0 $0 $0 $0 $0 $0 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales and marketing assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500 $1,500 $1,500
Total People 4 4 4 5 5 5 8 8 8 11 11 11
Total Payroll $6,000 $6,000 $6,000 $8,000 $8,000 $8,000 $14,250 $14,250 $14,250 $22,000 $22,000 $22,000

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 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.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 $15,000 $23,350 $33,350 $52,700 $52,700 $52,700 $77,750 $77,750 $77,750 $96,100 $96,100 $96,100
Direct Cost of Sales $7,500 $10,500 $15,500 $24,000 $24,000 $24,000 $33,000 $33,000 $33,000 $41,000 $41,000 $41,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $7,500 $10,500 $15,500 $24,000 $24,000 $24,000 $33,000 $33,000 $33,000 $41,000 $41,000 $41,000
Gross Margin $7,500 $12,850 $17,850 $28,700 $28,700 $28,700 $44,750 $44,750 $44,750 $55,100 $55,100 $55,100
Gross Margin % 50.00% 55.03% 53.52% 54.46% 54.46% 54.46% 57.56% 57.56% 57.56% 57.34% 57.34% 57.34%
Expenses
Payroll $6,000 $6,000 $6,000 $8,000 $8,000 $8,000 $14,250 $14,250 $14,250 $22,000 $22,000 $22,000
Sales and Marketing and Other Expenses $14,000 $14,000 $14,000 $21,000 $21,000 $21,000 $15,200 $26,000 $26,000 $26,000 $26,000 $26,000
Depreciation $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
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $900 $900 $900 $1,200 $1,200 $1,200 $2,138 $2,138 $2,138 $3,300 $3,300 $3,300
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $23,550 $23,550 $23,550 $32,850 $32,850 $32,850 $34,738 $45,538 $45,538 $54,450 $54,450 $54,450
Profit Before Interest and Taxes ($16,050) ($10,700) ($5,700) ($4,150) ($4,150) ($4,150) $10,013 ($788) ($788) $650 $650 $650
EBITDA ($16,050) ($10,700) ($5,700) ($4,150) ($4,150) ($4,150) $10,013 ($788) ($788) $650 $650 $650
Interest Expense $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($17,050) ($11,700) ($6,700) ($5,150) ($5,150) ($5,150) $9,013 ($1,788) ($1,788) ($350) ($350) ($350)
Net Profit/Sales -113.67% -50.11% -20.09% -9.77% -9.77% -9.77% 11.59% -2.30% -2.30% -0.36% -0.36% -0.36%

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 $6,000 $9,340 $13,340 $21,080 $21,080 $21,080 $31,100 $31,100 $31,100 $38,440 $38,440 $38,440
Cash from Receivables $0 $300 $9,167 $14,210 $20,397 $31,620 $31,620 $32,121 $46,650 $46,650 $47,017 $57,660
Subtotal Cash from Operations $6,000 $9,640 $22,507 $35,290 $41,477 $52,700 $62,720 $63,221 $77,750 $85,090 $85,457 $96,100
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 $6,000 $9,640 $22,507 $35,290 $41,477 $52,700 $62,720 $63,221 $77,750 $85,090 $85,457 $96,100
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 $6,000 $6,000 $6,000 $8,000 $8,000 $8,000 $14,250 $14,250 $14,250 $22,000 $22,000 $22,000
Bill Payments $50,868 $26,150 $29,217 $34,577 $49,850 $49,850 $50,005 $54,848 $65,288 $65,593 $74,450 $74,450
Subtotal Spent on Operations $56,868 $32,150 $35,217 $42,577 $57,850 $57,850 $64,255 $69,098 $79,538 $87,593 $96,450 $96,450
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 $56,868 $32,150 $35,217 $42,577 $57,850 $57,850 $64,255 $69,098 $79,538 $87,593 $96,450 $96,450
Net Cash Flow ($50,868) ($22,510) ($12,710) ($7,287) ($16,373) ($5,150) ($1,535) ($5,877) ($1,788) ($2,503) ($10,993) ($350)
Cash Balance $316,632 $294,122 $281,412 $274,125 $257,752 $252,602 $251,068 $245,191 $243,404 $240,901 $229,908 $229,558
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 $367,500 $316,632 $294,122 $281,412 $274,125 $257,752 $252,602 $251,068 $245,191 $243,404 $240,901 $229,908 $229,558
Accounts Receivable $0 $9,000 $22,710 $33,553 $50,963 $62,186 $62,186 $77,216 $91,745 $91,745 $102,755 $113,398 $113,398
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $367,500 $325,632 $316,832 $314,965 $325,088 $319,938 $314,788 $328,284 $336,936 $335,149 $343,656 $343,306 $342,956
Long-term Assets
Long-term Assets $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $20,000 $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 Assets $387,500 $345,632 $336,832 $334,965 $345,088 $339,938 $334,788 $348,284 $356,936 $355,149 $363,656 $363,306 $362,956
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 $50,000 $25,182 $28,082 $32,915 $48,188 $48,188 $48,188 $52,671 $63,111 $63,111 $71,968 $71,968 $71,968
Current Borrowing $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $150,000 $125,182 $128,082 $132,915 $148,188 $148,188 $148,188 $152,671 $163,111 $163,111 $171,968 $171,968 $171,968
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $150,000 $125,182 $128,082 $132,915 $148,188 $148,188 $148,188 $152,671 $163,111 $163,111 $171,968 $171,968 $171,968
Paid-in Capital $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000
Retained Earnings ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500) ($62,500)
Earnings $0 ($17,050) ($28,750) ($35,450) ($40,600) ($45,750) ($50,900) ($41,888) ($43,675) ($45,463) ($45,813) ($46,163) ($46,513)
Total Capital $237,500 $220,450 $208,750 $202,050 $196,900 $191,750 $186,600 $195,613 $193,825 $192,038 $191,688 $191,338 $190,988
Total Liabilities and Capital $387,500 $345,632 $336,832 $334,965 $345,088 $339,938 $334,788 $348,284 $356,936 $355,149 $363,656 $363,306 $362,956
Net Worth $237,500 $220,450 $208,750 $202,050 $196,900 $191,750 $186,600 $195,613 $193,825 $192,038 $191,688 $191,338 $190,988