Business Plan Lotus Spa 1
Business Plan Lotus Spa 1
Business Plan Lotus Spa 1
╦╦╦╦╦╦╦╦╦╦╦╦╦
26/06/2009
& Pauline
Prepared by Shermarn
For lotus spa company
2
Foreword
Lotus Spa with a innovation of healing body and mind Through a unique combination of
offered services to those who receive our healthcare spa service. Enhancing our own accountability
has left us better placed to establish an effective framework for spa service that is independent of
government as the dominant provider of healthcare in Thailand and independent of dominance by
any single group. We are setting the strategic direction of the organization and this Business Plan
in many respects informs and foreshadows the longer-term Strategic Plan that we intend to do and
publish in the course of this year (2009). We will take all the key decisions, and will be responsible
for overseeing the operational performance healthcare service as a whole, ensuring that the
organization delivers to the standards required of it.
We look forward to working with our key interest groups across the four areas of Thailand to take
forward what is a challenging but achievable set of key aims and objectives. Our Business Plan
sets out the key components of a regulatory framework that is capable of adapting to meet the
needs of customers and changing healthcare way.
Shermarn , Pauline
July 2009
3
BUSINESS PLAN
LOTUS SPA
26/06/2009
Contents
Executive summary 5
Ch 1 The company 5
1.1 History 5
1.2 Mission statement 5
1.3 Product and service 6
1.4 Current Status 6
1.5 Legal Status and ownership 6
1.6 Basic Corporation information 6
1.7 Company structure 7
Ch 2 Industry Analysis
2.1 Industry definition 7
2.2 Industry size, growth and sales projections 7
2.3 Industry characteristics 8
2.4 Industry trends 8
Ch 3 Market Analysis
3.1 Marketing segmentation and target market selection 8
3.2 Buyer behavior 8
3.3 Competitor analysis 9
3.4 Estimation of annual sales and market share 9
Ch 4 Marketing Plan
4.1 Market strategy 10
4.1.1 Position strategy 10
4.1.2 Points of differentiation 10
4.2 Pricing strategy 10
4.3 Sales process and promotion mix 11
4.4 Distribution and sales 11
Ch 6 Financial analysis
6.1 Start up Expenses 13
6.2 Assumption sheet 14
6.3 Pro forma financial statement 15
6.3.1 Opening Day Balance Sheet (beginning of year) 16
6.3.2 Profit and Loss projection (12 months) 16
6.3.3 Cash flow (12 months) 17
6.3.4 Projected balance sheet (end of year) 17
6.4 Ratio analysis 18
5
6.5 Break Even Analysis 19
6.6 Profit Projection (5 years) 20
Recommendation
Review
Appendix
Executive Summary
6
Lotus Spa is a new upscale destination in Freeway in Bangkok, Thailand, offering a complete day spa experience. We offer
seven ultra-boutique, ultra-comfortable treatment rooms with the finest spa linens and equipment. We offer massage in a variety of
styles - traditional Thai Massage, Deep Tissue work, Hot Stone Massage, Reflexology, Sports, Pregnancy and others. We also offer
facial and body treatments, like a Vitamin C Antioxidant Facial Treatment. Lotus Spa has the latest in anti-aging products and
techniques but does not offer services on hair such as cutting, styling and coloring. The only time a pedicure would be provided, is
when it's part of a full treatment like Calendula Foot and Leg Reflexology Treatment. In fact, for location, we prefer being
located near hair and nail salon for co-marketing opportunities.
This business plan has been developed to track progress prior to grand opening and following through with a five-year
projection. In addition, this plan has been written to for Spa's successful.
1. The company
1.1 History
The timing is right for starting this new venture. We are patiently searching for six months for the perfect location, one was
finally found in January 2009 in the Freeway Red Road in Bangkok Thailand. The demand from the owner's clients, as well as the
ambitions of us, and the procurement of highly professional and qualified beauticians and healthy, has made this business one of
great potential.
Shermarn co-owner with Pauline own the company. We have been working in a famous upscale spa in our Town. We have been
creating a large client following through hard work and dedication. Our talented team of beauticians and physicians has what it
takes to make this venture an extremely successful one. We expect our growing reputation to lead to new clients and beauticians to
support our anticipated growth.
To achieve our objectives, we are seeking additional loan financing. This loan will be paid from the cash flow from the business and
will be collateralized by the assets of the company, and backed by the character, experience, and personal guarantees of the owners.
Our mission is to run a profitable business by providing high-end therapeutic massage and beautiful services in a caring,
upscale, professional environment. We offer massage in a variety of styles - traditional Thai Massage, Sports Massage, Deep Tissue
work, Sports Massage, Hot Stone Massage, Reflexology, and others. Our licensed aestheticians offer the latest in skin treatments,
body treatments and anti-aging therapies.
Our goal is to tailor the client's experience based on initial interview information, as well as feedback during the treatments, to
ensure the client's comfort and satisfaction, and to increase repeat business. We are mindful of the overall experience - using only
the finest oils and lotions, beauty treatments and aromatherapies. Special lighting, music, decor, and textiles are used throughout the
spa to complete the comfortable, plush environment and enhance the client's overall spa experience.
Lotus Spa offers therapeutic massage services, body treatments, facials and anti-aging treatments. Services are provided by licensed
therapists and aestheticians who are independently contracted and paid on a commission basis. The upside of the commissioned
employee is that there is very little overhead without sales; employees only make money when the business makes money.
We also offer a full retail line that complements the services menu. Products included are high-end cosmetics, creams, candles,
and other beauty products. These high-end items tend to retail at a minimum of $20-$25 per item and have 50% mark - up, or
higher.
Lotus Spa is a new destination offering customers the combination of massage, body treatments, facials and anti-aging
treatments. The settings are upscale, beautiful and serene. We cater to both men and women and offer the latest in skin care
products and therapies.
Red Road Freeway, Bangkok Thailand, where we plan to locate, has a daily traffic count of 10,000 cars. It is also only two blocks
from a commuter train stop, and has an upscale hair and nail salon which would complement our services nicely.
Lotus Spa is a privately held partnership, owned by Ms. Shermarn and Ms. Pauline. In the course of fund raising, we will explore
the feasibility of both a partnership, and a limited liability partnership.
After spending several months searching for a spa to purchase, we decided to start a Lotus Spa from the ground up. The bulk of
the start-up costs will be invested by us and the remainder will be funded through short-term financing. Details are provided
Managing
director
L
Pauline
None Executive
HRM director
Director
B D
A C
Finance director Marketing Research
IT manager
director director
I
F
E G H
Customer
Purchasing
Accountant Secretary Sales manager service manger
manager
Line manager
2. Industry analysis
Nowadays in Thailand we are more concerning about our health and this makes this kind of business very popular
recently and it tends to be larger and larger from metropolis to downtown. The Target group is particular in Women
because as we know well that they like to pamper themselves to be “Good-looking” without concerning cost
According to this, it is rapidly growing the sales could be lower due to many competitions. For Lotus Spa we have
placed ours as a medium Spa and Beauty industry.
9
Staffs of Spa industry and health care is projected to increase 27 percent through 2014 in Thailand, compared with 14
percent for all industries combined The slowest growing industry segment to 69 percent in the much smaller Spa
health care services.
About 40,000 establishments Spa care industry; they vary greatly in terms of size, staffing patterns, and organizational
structures. About 76 percent of Spa care establishments are offices of physicians, or other health practitioners.
Although hospitals constitute only 2 percent of all health care establishments.
From: http://www.industry.go.th/ops/pio/lamphun/Lists/News/Disp.aspx?List=ac4ae0a1-8bae-
4b99-b985-9fa9ee646282&ID=143
3 Market Analysis
We are primarily targeting potential clients within our facility’s zone with a household income over $5,000. Our secondary
market will include visitors staying in a local hotel. Within Thailand approximately 14% of the population has never tried a
massage. We will assume that a conservative 70% of these two categories has tried a massage and would undergo one again, if
offered appealing services at the right price. Our market Analysis table thus reflects 70% of the local and visiting population who
might be targeted.
3. Serious Athletes
Injury and workout recovery also preventative.
Many serious runners, surfers, bicyclists and college athletes in the local area.
Massage for improved performance - great for word-of mouth referrals if they see results.
The closest competitor is the Leelawadee Spa which is a Hair salon that offers additional, limited, spa services. The Siam Hotel
also offers massage treatments, but we will mostly cater to visitors to the area and not the local residential base. Finally, Ravanda
Spa, located in Plaza Center is not a traditional day spa but combines a day spa with a female gymnasium. No men are allowed at
Ravanda Spa, either. The going rate for massage in Freeway County is $70-$90 per hour which is slightly above most of the other
residential areas in Metropolis which can even be as low as $40 per hour in saturated or low-income areas.
Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Within 5 Miles over $25k 2% 284,950 288,883 292,869 296,911 337,885 4.35%
4 Marketing Plan
Local Advertising & Seasonal Promotions - Local newspaper advertising, local fliers, grand opening party and promotion for
first 30 days. Continue regular advertising and plan for seasonal events like Song Grand Festival, Mother's Day and New Year's.
Local Networking - Charities, women's groups, country clubs, wedding planners, and membership with the Metropolis
Chamber of Commerce.
Health Care Referrals-Prior to opening, work current contacts and create new contacts with health care providers, especially
chiropractors. Also, become a Provider with health insurance companies that offer Alternative Care to their members. Most people
don't know that massage therapy is usually paid by insurance when billed correctly and when prescribed by a physician. Lotus Spa
already has practice management software to handle medically billable massage. When the insurance does not cover the entire
amount of a service the client will pay the difference. For that reason, we will not want to participate with any health insurance that
require write-off for amounts over the usual and customary fee (which tends to be too low). A list of acceptable insurance company
plans will be maintained and those clients will be able to handle massage therapy through their insurance. Any opportunity to
convince allopathic physicians to see massage as having long-term healing benefits for their patients will also be taken, since
they hold key to having massage paid for as medically necessary. The client will also help drive that with the physicians if they are
properly educated.
Hotel Referrals - Hotels that do not offer their own spa services will send their guests to our spa or use our out-call
spa services. Prior to opening, we will make contacts with managers and concierges at local hotels to ensure they are aware of the
services available. Promotions will be offered to professionals in these industries to build relationships.
Online Website - our spa will show up on major website in Thailand e.g. Mthai.com, Kapook.com and in the phone directory
(Yellow pages). The website will have a full menu of services and eventually have the ability to schedule appointments on-line. The
spa software we are using will allow a user to see the schedule and make and appointment without making a phone call.
Location traffic - It is imperative that we be located in a high-traffic strip mall that is high-end, modern, and clean. We prefer
locating near a complementary business like a nail or hair salon that does not offer any massage or facial treatments.
4.2Pricing strategy
We define it as several levels strategies follow:
Premium Pricing
We use a high price where there is uniqueness about the product or service to approach a substantial competitive advantage
exists. Such high prices are charge for luxuries such as rooms, beautician courses and delivery service.
Penetration Pricing
The price charged for services is set artificially low in order to gain market share. Once this is achieved, the price is increased.
Economy Pricing
This is a no frills low price. The cost of marketing and manufacture are kept at a minimum. We have economy services for,
such as hands massage.
Price Skimming
12
Charge a high price because we have a substantial competitive advantage. However, the advantage is not sustainable. The high
price tends to attract new competitors into the market. Once other spas were tempted into the market and the services were
produced at a lower unit cost.
Promotional Pricing
Pricing to promote our services is a very common application. There are many promotional pricing including approaches such
as Buy One Get One Free.
Advertising – we pay promotions using multimedia deliver the Lotus Spa’s message such as health magazines. While we
have involved one-way communication with mass feedback opportunity for the customer experiencing that the advent of
Internet such as Lotus’s website, community profiles (Fackebook,Youtube) that allow customers to provide quick feedback.
Sales Promotion – we involve the use of special short-term techniques in the form of incentives, to encourage customers
to respond or undertake some activity. For instance, the use of retail coupons with expiration dates requires customers to act
while the incentive is still valid.
Public Relations – we also referred to as publicity, this type of promotion uses third-party sources, and particularly the
news media, to offer a favorable mention of our company or services without direct payment to the publisher of the
information.
Personal Selling – we involve personal contact between company alliance and those who have a role in purchase
decisions (member of a company buying center). Often this occurs face-to-face or via telephone, though newer technologies
allow this to occur online via video conferencing or text chat.
If, as it has been said, the top item which determine success in business is location then a busy location at Plaza center in a
thriving residential community represents our top marketing strategy. We are focusing on the sales, marketing and management and
delegating the massage and aesthetician therapies to employees--business profitability potential is exponentially maximized over a
one or two person operation by a direct care-giver without any marketing, management or sales background.
As the owners, we have done extensive market research and visited some of the best spas in Thailand and have taken ideas from the
best to offer an upscale, ultra-amenity, spa experience. Once a client experiences the comfortable, high-end level of personalized
care that we offer, we are confident that we will have a return client.
5.1Operations plan
Lotus Spa Operations Development Plan is designed to provide for upgrading and development of all those
function, standards, services, systems, and regulatory activities which will allow safe, timely and economical
integration of Lotus Spa into all-weather operations in Spa community. We describe a five-year development program
our objectives are to improve our services System so as to enable us to utilize our unique employees’s capabilities. It
includes the collection of ingredients treatment (both near and long term) for ensuring full integration into Lotus Spa
13
of this rapidly growing segment of aviation. These areas are covered in the plan: (1) Technical Operations; (2)
communication Systems Development; (3) Cost Control; (4) Weather Environment; (5) Spa Services Certification
Standards; (6) Risk reduction.
Strategy
To raise the profile of Lotus Spa this will help by improving uptake of services and increasing public consideration
of customers. This Services Development Plan is intended to serve our strategy and therefore indirectly to increase the
Lotus Spa’s effectiveness. In developing a Services Development Plan we have built the following ideas in mind.
Plans
To implement this strategy we are developing plans in the following:
Management
If once plan have been agreed we will seek the advice of other relevant authorities in drawing up an operating schedule
for the proper management of all our activities.
Provision of Services
Purpose
Significant revenue on those items upon which it does make a profit (e.g. ingredients, Staffs)
Nevertheless Lotus Spa provides a number of popular and valuable member services
Service Provision
This view emphasizes that a range of services is available it’s not just a service material but also service mind.
We are friend this redefinition has begun , has led to substantially increased turnover since the start of term (against
comparable recent periods). This indicates that service uptake has increased, as well as improving the financial
viability of the activity.
Coffee Bar
Purpose
Lotus Spa is looking at ways to increase involvement of workers and university students, to increase uptake of the
services it offers and to attempt to make more relationship community. At the same time we are keen to ensure
sustainability and to develop systems which will handle increased activity without consuming the time of elected us. In
pursuing these aims we would like to consider the possibility of providing a coffee bar during customer’s relaxing.
Consultation
Timescale
.
We and relevant workers are keen to actively pursue each of the activities described, and wishes to present the plans
for their information, for approval, and for any advice which members wish to offer on the content of the plans and
how best to take them forward.
14
6 Financial analysis
Start-up
Requirements
Start-up Expenses
Legal $2,500
Brochures $500
Construction/Design $45,000
Insurance $2,000
Rent $17,000
Advertising $5,000
15
Accountant $950
Linens $4,000
Other $0
Start-up Assets
Long-term Assets $0
Start-up Funding
Assets
Liabilities
Long-term Liabilities $0
Capital
Planned Investment
N/A $0
16
Additional Investment Requirement $0
The financial plan depends on important assumptions, most of which are shown in the following table as annual assumptions. We
assume cash payments for all services, except for the 1% of sales projected as insurance reimbursements, with collection days at 90.
The collection days are for insurance billings only. Interest rates, tax rates, and personnel burden are based on conservative
assumptions.
General Assumptions
Year 1 Year 2 Year 3 Year 4 Year 5
Plan Month 1 2 3 4 5
Other 0 0 0 0 0
Fixed expenses are the customary: rent, electric, advertising, insurance. There are four main areas of income: massage,
aesthetician retail and out call. Massage and aesthetician services are $65 per service minimum, with 55% of that going to the
service provider. The basis for the sales projections is a conservative estimate of 7 services per day the first month in business and
53 services per day by the end of the first year. At 53 services per day we would still only be operating 75% to capacity with 7
treatment rooms operating 7 days a week, 8-10 hours per day.
On retail services/product, the gross margin is consistently 50% across the board. The retail lines go in conjunction with the spa
services as an extension of the spa experience. The more customer’s sales will be driven. These high-end spa services are hard to
find items that generate repeat purchases.
18
Expenses
Payroll Taxes $0 $0 $0 $0 $0
Profit Before Interest and Taxes $154,721 $173,380 $183,480 $196,155 $209,130
19
EBITDA $154,721 $173,430 $183,530 $196,205 $209,180
Based on our conservative sales forecasts, the following Cash Flow table shows Lotus Spa with a consistently positive Cash Flow.
After two months, the spa will show a consistent increase in the cash balance. Because the business is a partnership, our draw is
obviously the area of cash flow where adjustments can be made if Cash Flow becomes tight.
The only Accounts Receivable carried is any Insurance Billings that are not paid during the month. Although some insurance
companies pay promptly, within 10 working days, others take more than 6 weeks to pay. We have set our collection days for this
small percentage of non-cash sales at 90 days, to be conservative.
The Balance Sheet shows a steady increase in earnings and net worth over the next five years.
Assets
Current Assets
20
Cash $213,263 $293,531 $414,568 $547,351 $697,823
Long-term Assets
Current Liabilities
Long-term Liabilities $0 $0 $0 $0 $0
Ratio Analysis
Year 1 Year 2 Year 3 Year 4 Year 5 Industry Profile
Percent of Sales
Selling, General & Administrative Expenses 90.28% 94.36% 90.99% 0.00% 0.00% 69.59%
Profit Before Interest and Taxes 18.78% 20.23% 20.39% 20.74% 21.30% 4.07%
Main Ratios
Total Debt to Total Assets 40.46% 19.01% 12.73% 8.93% 7.19% 58.83%
Pre-tax Return on Net Worth 95.65% 60.66% 44.05% 35.25% 29.64% 4.43%
Activity Ratios
Debt Ratios
Liquidity Ratios
22
Net Working Capital $159,528 $281,282 $410,428 $551,427 $701,667 n.a
Additional Ratios
The break-even analysis table shows what we need to make in sales to meet costs. Our variable costs include both the direct costs
shown in the Sales Forecast table, for linens, ingredients, equipment, but also include the commissions paid to contracted massage
therapists and aestheticians. We should surpass the break-even point by month four of operations.
Break-even Analysis
Monthly Revenue Break-even $31,022
Assumptions:
Average Percent Variable Cost 39%
Estimated Monthly Fixed Cost $18,893
23
Literature review
25
Appendices
Sales Forecast
Month Month Month Month Month Month Month Month Month Month Month
Month 12
1 2 3 4 5 6 7 8 9 10 11
Sales
Massage Therapy 0% $9,000 $14,105 $20,150 $29,250 $40,300 $42,900 $50,375 $56,420 $54,600 $64,480 $68,250 $78,000
Facials and Anti-
0% $3,600 $6,045 $8,060 $9,750 $12,090 $13,650 $16,120 $18,135 $18,200 $22,165 $23,400 $26,195
Aging Treatments
Outcall Services 0% $400 $800 $1,200 $1,600 $1,600 $1,760 $2,080 $2,400 $2,560 $2,800 $3,200 $3,200
Retail 0% $1,240 $2,480 $3,100 $3,600 $4,650 $6,000 $6,975 $7,750 $9,800 $15,500 $16,500 $17,250
Total Sales $14,240 $23,430 $32,510 $44,200 $58,640 $64,310 $75,550 $84,705 $85,160 $104,945 $111,350 $124,645
Month Month Month Month Month Month Month Month Month Month Month
Direct Cost of Sales Month 12
1 2 3 4 5 6 7 8 9 10 11
Linens and Cleaning 1% $65 $105 $147 $203 $270 $292 $343 $385 $377 $447 $474 $537
Oils & Lotions 2% $260 $419 $588 $812 $1,080 $1,166 $1,372 $1,539 $1,507 $1,789 $1,897 $2,148
Cost of Retail
products / 50% of 50% $620 $1,240 $1,550 $1,800 $2,325 $3,000 $3,488 $3,875 $4,900 $7,750 $8,250 $8,625
Sales
Subtotal Direct Cost
$945 $1,764 $2,285 $2,815 $3,675 $4,458 $5,202 $5,799 $6,784 $9,986 $10,621 $11,310
of Sales
Personnel Plan
Month Month Month Month Month Month Month Month Month Month Month Month
1 2 3 4 5 6 7 8 9 10 11 12
Owner Draw 0% $3,750 $5,000 $6,000 $7,500 $8,000 $8,500 $9,000 $9,500 $10,000 $11,000 $12,500 $12,500
Front Desk 0% $0 $1,500 $1,820 $1,820 $3,640 $3,640 $3,640 $3,640 $3,640 $3,640 $3,640 $3,640
Total People 1 2 2 2 3 3 3 3 3 3 3 3
Total Payroll $3,750 $6,500 $7,820 $9,320 $11,640 $12,140 $12,640 $13,140 $13,640 $14,640 $16,140 $16,140
General Assumptions
Month Month Month
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9
10 11 12
26
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest
7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Rate
Long-term
5.65% 5.65% 5.65% 5.65% 5.65% 5.65% 5.65% 5.65% 5.65% 5.65% 5.65% 5.65%
Interest Rate
Tax Rate 30.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Sales $14,240 $23,430 $32,510 $44,200 $58,640 $64,310 $75,550 $84,705 $85,160 $104,945 $111,350 $124,645
Direct Cost of Sales $945 $1,764 $2,285 $2,815 $3,675 $4,458 $5,202 $5,799 $6,784 $9,986 $10,621 $11,310
Massage Therapists'
55% $4,950 $7,758 $11,083 $16,088 $22,165 $23,595 $27,706 $31,031 $30,030 $35,464 $37,538 $42,900
commission
Aestheticians'
40% $1,440 $2,418 $3,224 $3,900 $4,836 $5,460 $6,448 $7,254 $7,280 $8,866 $9,360 $10,478
commission
Out-call Services
65% $260 $520 $780 $1,040 $1,040 $1,144 $1,352 $1,560 $1,664 $1,820 $2,080 $2,080
commission
Total Cost of Sales $7,595 $12,460 $17,372 $23,843 $31,716 $34,657 $40,708 $45,644 $45,758 $56,136 $59,599 $66,768
Gross Margin $6,645 $10,971 $15,138 $20,358 $26,924 $29,653 $34,842 $39,061 $39,402 $48,809 $51,751 $57,877
Gross Margin % 46.66% 46.82% 46.56% 46.06% 45.91% 46.11% 46.12% 46.11% 46.27% 46.51% 46.48% 46.43%
Expenses
Payroll $3,750 $6,500 $7,820 $9,320 $11,640 $12,140 $12,640 $13,140 $13,640 $14,640 $16,140 $16,140
Marketing/Promotion $2,000 $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 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Utilities $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Advertising $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Phone $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Other $100 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Total Operating
$12,100 $13,850 $15,170 $16,670 $18,990 $19,490 $19,990 $20,490 $20,990 $21,990 $23,490 $23,490
Expenses
EBITDA ($5,455) ($2,880) ($32) $3,688 $7,934 $10,163 $14,852 $18,571 $18,412 $26,819 $28,261 $34,387
Interest Expense $200 $196 $192 $188 $184 $180 $176 $172 $167 $163 $159 $155
Taxes Incurred ($1,697) ($861) ($63) $980 $2,170 $2,795 $4,109 $5,152 $5,108 $7,464 $7,869 $9,585
27
Net Profit ($3,959) ($2,214) ($161) $2,520 $5,580 $7,188 $10,567 $13,248 $13,136 $19,192 $20,233 $24,647
Net Profit/Sales -27.80% -9.45% -0.50% 5.70% 9.52% 11.18% 13.99% 15.64% 15.43% 18.29% 18.17% 19.77%
Cash Received
Cash Sales $14,098 $22,961 $31,535 $42,874 $56,881 $62,381 $73,284 $82,164 $82,605 $101,797 $108,010 $120,906
Cash from Receivables $0 $0 $5 $153 $485 $987 $1,340 $1,765 $1,941 $2,276 $2,542 $2,575
Subtotal Cash Received $14,098 $22,961 $31,539 $43,027 $57,366 $63,368 $74,624 $83,929 $84,546 $104,072 $110,551 $123,480
Month
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 11Month 12
10
Expenditures from
Operations
Cash Spending $3,750 $6,500 $7,820 $9,320 $11,640 $12,140 $12,640 $13,140 $13,640 $14,640 $16,140 $16,140
Bill Payments $450 $13,633 $17,604 $24,369 $33,257 $42,481 $46,087 $53,355 $58,990 $59,973 $74,670 $75,973
Subtotal Spent on
$4,200 $20,133 $25,424 $33,689 $44,897 $54,621 $58,727 $66,495 $72,630 $74,613 $90,810 $92,113
Operations
Principal Repayment of $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
28
Current Borrowing
Long-term Liabilities
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment
Purchase Long-term
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Assets
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $4,900 $20,833 $26,124 $34,389 $45,597 $55,321 $59,427 $67,195 $73,330 $75,313 $91,510 $92,813
Net Cash Flow $9,197 $2,129 $5,416 $8,638 $11,769 $8,046 $15,197 $16,733 $11,215 $28,759 $19,041 $30,667
Cash Balance $55,652 $57,781 $63,197 $71,835 $83,604 $91,651 $106,847 $123,581 $134,796 $163,555 $182,596 $213,263
Starting
Assets Balance
s
Curre
nt
Assets
Accou
nts
$0 $142 $611 $1,582 $2,754 $4,028 $4,970 $5,896 $6,673 $7,287 $8,160 $8,958 $10,123
Recei
vable
Invent
$6,000 $5,055 $3,291 $2,514 $3,097 $4,042 $4,904 $5,722 $6,379 $7,462 $10,985 $11,683 $12,441
ory
Other
Curre
$32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095 $32,095
nt
Assets
Total
Curre $109,78 $123,76 $133,61 $150,56 $168,72 $181,64 $214,79 $235,33
$84,550 $92,945 $93,778 $99,387 $267,923
nt 1 9 9 1 7 0 5 3
Assets
Long-
term
Assets
Long-
term $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Assets
Accu
mulat
ed
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depre
ciatio
n
Total
Long-
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
term
Assets
29
Total $109,78 $123,76 $133,61 $150,56 $168,72 $181,64 $214,79 $235,33
$84,550 $92,945 $93,778 $99,387 $267,923
Assets 1 9 9 1 7 0 5 3
Liabili
ties
Month Month
and Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9 Month 12
10 11
Capita
l
Curre
nt
Liabili
ties
Accou
nts
$0 $13,053 $16,801 $23,271 $31,845 $40,953 $44,315 $51,390 $57,008 $57,485 $72,148 $73,153 $81,795
Payab
le
Curre
nt
$35,000 $34,300 $33,600 $32,900 $32,200 $31,500 $30,800 $30,100 $29,400 $28,700 $28,000 $27,300 $26,600
Borro
wing
Other
Curre
nt $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Liabili
ties
Subtot
al
Curre $100,14 $100,45
$35,000 $47,353 $50,401 $56,171 $64,045 $72,453 $75,115 $81,490 $86,408 $86,185 $108,395
nt 8 3
Liabili
ties
Long-
term
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Liabili
ties
Total
$100,14 $100,45
Liabili $35,000 $47,353 $50,401 $56,171 $64,045 $72,453 $75,115 $81,490 $86,408 $86,185 $108,395
8 3
ties
Paid-
in $130,00 $130,00 $130,00 $130,00 $130,00 $130,00 $130,00 $130,00 $130,00 $130,00 $130,00 $130,00
$130,000
Capita 0 0 0 0 0 0 0 0 0 0 0 0
l
Retain
ed ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45 ($80,45
($80,450)
Earnin 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0)
gs
Earnin
$0($3,959)($6,173)($6,334)($3,814) $1,766 $8,954 $19,521 $32,769 $45,905 $65,097 $85,331 $109,978
gs
Total
$114,64 $134,88
Capita $49,550 $45,591 $43,377 $43,216 $45,736 $51,316 $58,504 $69,071 $82,319 $95,455 $159,528
7 1
l
Total
Liabili
ties $109,78 $123,76 $133,61 $150,56 $168,72 $181,64 $214,79 $235,33
$84,550 $92,945 $93,778 $99,387 $267,923
and 1 9 9 1 7 0 5 3
Capita
l
30
Net
Worth
Process management
Text & Cases
Joel D. Wisner
Linda L. Stanley
Financial Management
For decision maker
Peter Atrill 4th
URL List
http://www.nald.ca/fulltext/business/NILA.pdf
http://74.125.77.132/search?q=cache:wV91wpXMQVQJ:www.solutions-
etc.com/entrepreneurship/sbdc/worksheets/Business%2520Plan
%2520Template.doc+business+plan+cover+page&cd=2&hl=th&ct=clnk&gl=th
http://www.microsoft.com/business/smb/th-th/issues/starting/businessplan.mspx
http://www.beautyimagentt.com/
http://www.businessplans.org/Market.html
http://www.thai-tour.com/Spa-Resort-Thailand.htm
http://www.thaispaassociation.com/TSPA/newsletter.php
http://www.tnantaspa.com/
http://www.ajarnkan.com/economic_web/na-07.pdf
http://www.dinkytown.net/java/BreakEven.html
http://www.samunpri.com/spa/
http://www.google.co.th/imgres?
imgurl=http://www.dfat.gov.au/dept/annual_reports/06_07/_lib/img/fins/balance_sheet_
aj.gif&imgrefurl=http://www.dfat.gov.au/dept/annual_reports/06_07/financials-
austjapan/income_statement_01.html&h=709&w=550&sz=29&tbnid=dklBtefmNmbnfM:&
tbnh=140&tbnw=109&prev=/images%3Fq%3Dbalance
%2Bsheet&hl=th&usg=__lrgP0TiLxXF1mF39HfQPBMLn8mA=&ei=AFheSq6HA4jt-
Aby4fHmAQ&sa=X&oi=image_result&resnum=7&ct=image
31
http://www.engr.sjsu.edu/fayad/current.courses/cmpe133-
spring07/docs/projects/Sample-Process-1.pdf
http://findarticles.com/p/articles/mi_m3072/is_1_219/ai_112654992/
http://www.va-interactive.com/inbusiness/editorial/sales/ibt/sales_fo.html
http://ohioline.osu.edu/cd-fact/1153.html
http://www.epos-spa.co.uk/
http://www.va-interactive.com/inbusiness/editorial/sales/ibt/sales_fo.html#9