Financial Feasibility Model.xls


	Company / Setup Information

	Name of Business
	Type of Entity		LLC
	Name of Entity		RB LLC
	Type of Concept		Luxury Dog Care Facility
	Number of Boarding Suites
	Square Footage
	Projected Opening Date		January 1, 2009
	Equity Capital

Projected Sources & Uses of Cash

Development & Startup Period

SOURCES OF CASH:

Equity Contributions

Loan Financing

TOTAL SOURCES OF CASH

USES OF CASH:

Land & Building

Leasehold Improvements

Grooming Equipment

Boarding Equipment

Professional Services

Organizational & Development

Interior Finishes & Equipment

Exterior Finishes & Equipment

Pre-Opening Expenses

Working Capital & Contingency

TOTAL USES OF CASH

Cost Classification used to calculate depreciation & amortization.

Capital Budget

TOTAL COST

Detail

Classification

Building

Leasehold

Equipment

Start Up

Expense

Non-Ded.

LAND & BUILDING

Land

Building - Construction / Contractor Fees

LEASEHOLD IMPROVEMENTS

Construction Contract

Landlord Contribution

GROOMING EQUIPTMENT

Sinks

Tables

Dryers

Cages

Other

BOARDING EQUIPTMENT (35 Suites)

Bedding

Webcams

T.V.

Suite Build out

Other

PROFESSIONAL SERVICES

Architect & Engineering

Legal (lease & incorporation)

Project Consultant

Accounting & Tax

Name, Logo & Graphic Design

ORGANIZATIONAL & DEVELOPMENT

Deposits (utilities, sales tax, etc.)

Insurance Binder (property, casualty, liability)

Workers Comp. Binder

Licensing

Building Permits

Other Licenses & Permits

Utility Deposits (gas, electric, water)

Change, Operating Banks & Petty Cash

Flyers / Pamphlets

Lease Deposit

Travel, Research, Concept Development

INTERIOR FINISHES & EQUIPMENT

Grooming Smallwares

Misc Tools

Kitchen Equiptment

Artwork & Specialty Décor

Security System

Music/Sound/Audio-Visual Systems

Cash Register / Point of Sale

Phone System

Office Equipment / Computer

Office Supplies

Interior Signs

EXTERIOR FINISHES & EQUIPMENT

Landscaping

Exterior Signs & Decorations

Resurfacing

Parking Bumpers

Parking Lot Striping

PRE-OPENING EXPENSES

Construction Period Utilities

Construction Period Building Lease

Construction Period Interest

Uniforms

Opening Inventories -

Retail Food

Retail Merchandise

Grooming Supplies

Cleaning Supplies

Other Supplies

Marketing -

Advertising

Public Relations

Opening Parties

Personnel -

Management

Hourly Employees

Payroll Taxes & Employee Beneifts

WORKING CAPITAL & CONTINGENCY

Working Capital

Contingency

PROOF

TOTAL PROJECT COST

Building

Leasehold

Equipment

Start Up

Expense

Non-Ded.

Project Cost Per Square Foot

Project Cost Per Suite


Sales Projection Worksheet - Typical Week

Number of Seats

		Purchases			Daily Sales By Category			% of
		per Day	# Sales	Price	Retail	Services	Total	Week
Monday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals

Tuesday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals

Wednesday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals

Thursday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals

Friday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals

Saturday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals

Sunday	Daycare
	Boarding
	Grooming
	Retail
	Bath Sp.
	Packages
	Day Totals
WEEK TOTALS (In-house only)	Totals in $
WEEK TOTALS (In-house only)	Sales Mix %						$ 1.00
Special Events	Ave. # of Events per Week
	Ave. # of Guests
	Per Person Average $
	Sales Mix %
	Special Event Sales Per Week
WEEK TOTALS - All Sales	Totals in $
WEEK TOTALS - All Sales	Sales Mix %						$ 1.00

RECAP: Key Sales Numbers:
Annual Sales
Average Monthly Sales
Annual Sales Per Square Foot
Annual Sales Per Suite


Calculate Per Person Check Average:
Daycare	Ave. Price Point		Orders/		Ave CK
			Customer
Service -
Daycare
TOTALS


Boarding	Ave. Price Point		Orders/
	Point		Customer		Ave CK
Service -
Boarding
TOTALS


Grooming	Ave. Price Point		Orders/		Ave CK
			Customer
Service -
Grooming
TOTALS


Retail	Ave. Price Point		Orders
			Customer		Ave CK
Service -
Retail
TOTALS

Bath Special	Ave. Price Point		Orders/ Customer		Ave CK
Service -
Bath Special
TOTALS


Packages	Ave. Price Point		Orders/ Customer		Ave CK
Service -
Packages
TOTALS

Hourly Labor Projection Worksheet

- RETAIL -

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

WEEK

# Retail Sales

Total Retail Sales

Position

Rate

Hours

Labor $

Reception

Receptionist

Retail -

Opening Cashier

Closing Cashier

Check-In/Out

Labor Cost Per Shift - $

Labor Cost Per Shift - %

- Services -

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

WEEK

# Number of Dogs Serviced

Total Service Sales

Position

Rate

Hours

Labor $

Daycare/ Boarding -

Dog Handler

Other

Grooming -

Groomer

Washer/Cleaner

Other

Labor Cost Per Shift - $

Labor Cost Per Shift - %

- DAY / WEEK TOTALS - LABOR -

Hourly Labor - $

Hourly Labor Cost - %

- SPECIAL EVENT LABOR -

Average # of Guests

Per Person Average $

Average Sales Per Event

Position

Rate

Hours

Labor Cost $

Sales Person Commission %

Supervision

Other

Ave. Labor Cost Per Event - $

Ave. Labor Cost Per Event - %

RECAP - HOURLY LABOR COST

Week

Annual

Sales:

Facility Sales

Special Events

Total

Hourly Labor Cost:

Facility Labor

Special Events

Total


Assumptions to the Operating Projections


	Sales (from "Sales Projection" worksheet)				Weekly Ave	Annual
		Retail
		Services
	Total Sales

	Cost of Sales						Annual $	% of Sales
		Retail Cost %				of retail sales
		Service Cost %				of service sales
	Total Cost of Sales

	Management Salaries (Annual)					% of Sales
		General Managers
		Assistant Manager


	Hourly Labor Cost (from "Hourly Labor" worksheet)				Weekly Ave	Annual	%
		In-House Only
		Special Events
	Total Hourly Labor Cost
	Total Management Salaries
	Total Gross Payroll

					Monthly $		Annual $	% of Sales
		FICA Taxes - as a % of Gross Payroll
		State Unemployment-as a % of Gross P/R
		Federal Unemployment-as a % of Gross P/R
		Other Payroll Taxes-as a % of Gross P/R
		Worker's Comp. - as a % of Gross P/R
		Group Medical Ins.-cost per employee
		Group Medical Ins.-# of employees covered
		Disability & Life Insurance
		401k Plan - per month
		Employee Education - per month
		Awards & Prizes - per month
		Employee Christmas & Other Parties
		Transportation & Housing
	Total Employee Benefits

					Monthly $	% of Sales	Annual $	% of Sales
		Auto Expense
		Cleaning Supplies
		Contract Cleaning
		Extermination
		Flowers & Decorations
		Kitchen Utensils
		Laundry & Linen
		Licenses & Permits
		Miscellaneous
		Security System
		Uniforms
	Total Direct Operating Expenses

					Monthly $		Annual $	% of Sales
		Musak & Sound System
		Other
	Total Music & Entertainment

					Monthly $		Annual $	% of Sales
		Selling & Promotions
		Advertising
		Printed Materials
		Research
	Total Marketing

					Monthly $		Annual $	% of Sales
		Electricity
		Gas
		Water
		Trash Removal
	Total Utilities

					Monthly $		Annual $	% of Sales
		Accounting Services
		Bank Charges
		Bank Deposit Services
		Cash (Over) / Short
		Credit Card Charges
		Dues & Subscriptions
		Miscellaneous
		Office Supplies
		Payroll Processing
		Postage
		Professional Fees
		Protective Services
		Telephone
		Training Materials
	Total General & Administrative

	Credit Card Charges:
		Percentage of Credit Card Sales
		Average Discount Percentage

					Monthly $		Annual $	% of Sales
		Building Repairs & Maint.
		Equipment Repairs & Maint.
		Grounds, Landscaping & Parking Lot
	Total Repairs & Maintenance

					Monthly $		Annual $	% of Sales
		Base (minimum) Rent
		Percentage Rent -
		Percentage amount
		On annual sales above
		Common Area Maintenance (CAM)
		Equipment Rental
		Real Estate Taxes
		Personal Property Taxes
		Insurance on Building & Contents
		Liability Insurance
	Total Occupancy Costs

	Depreciation & Amortization:				Basis	Period	Per Year	% of Sales
		Building				30 years
		Leasehold Improvements				7 years
		Furniture & Equipment				7 years
		Pre-Opening Costs				7 years
	Total Depreciation & Amortization

	Other Income				Monthly $		Annual $
		Vending & Telephone Commissions
		Misc Other Income

	Other Expense				Monthly $		Annual $



	Loan Financing
		Principle Amount
		Rate
		Term				years	Annual $
		Monthly Payment				monthly pmt.


			Loan Amortiation Schedule
				Loan			Annual Totals
			Period	Balance	Interest	Principal	Interest	Prin Repmt











									Year 1











									Year 2











									Year 3











									Year 4











									Year 5











									Year 6











									Year 7

Annual Operating Projection - Detail

First Full Year of Operations

MONTHLY AVE

ANNUAL

Sales:

Retail

Services

TOTAL SALES

100.0%

Cost of Sales:

Retail

Services

TOTAL COST OF SALES

Gross Profit

Payroll:

Salaries & Wages -

Management

Hourly Employees

Total Salaries & Wages

Employee Benefits -

Payroll Taxes - Mgt. Incentive

Worker's Comp.

Group Medical Insurance

Other

Total Employee Benefits

TOTAL PAYROLL

PRIME COST

Other Controllable Expenses:

Direct Operating Expenses

Auto Expense

Cleaning Supplies

Contract Cleaning

Extermination

Flowers & Decorations

Kitchen Utensils

Laundry & Linen

Licenses & Permits

Miscellaneous

Security System

Uniforms

Total Direct Operating Expenses

Music & Entertainment -

Musak & Sound System

Other

Total Music & Entertainment

Marketing -

Selling & Promotions

Advertising

Printed Materials

Research

Total Marketing

Utilities -

Electrical

Gas

Water

Trash Removal

Total Utilities

General & Administrative -

Accounting Services

Bank Charges

Bank Deposit Services

Cash (Over) / Short

Credit Card Charges

Dues & Subscriptions

Miscellaneous

Office Supplies

Payroll Processing

Postage

Legal & Professional Fees

Protective Services

Telephone

Training Costs

Total General & Administrative

Repairs & Maintenance -

Building Repairs & Maint.

Equipment Repairs & Maint.

Grounds, Landscaping & Parking Lot

Total Repairs & Maintenance

CONTROLLABLE PROFIT

Occupancy Costs & Depreciation

Occupancy Costs -

Rent & Common Area Maintenance

Percentage Rent

Common Area Maintenance (CAM)

Equipment Rental

Real Estate Taxes

Personal Property Taxes

Insurance on Building & Contents

Pet Liability Insurance

Total Occupancy Costs

Depreciation & Amortization -

Building

Leasehold Improvements

Furniture & Equipment

Pre-Opening Costs

Total Depreciation

TOTAL OCCUPANCY & DEPREC.

Other (Income) Expense -

Vending & Telephone Commissions

Misc Other Income

Interest

Misc Other Expense

Total Other (Income) Expense

NET INCOME BEFORE INCOME TAXES

ADD BACK:

Depreciation & Amortization

DEDUCT:

Loan Principal Payments

CASH FLOW BEFORE INCOME TAXES

Annual Operating Projection - Summary

First Full Year of Operations

MONTHLY AVE

ANNUAL

Sales:

Retail

Services

TOTAL SALES

100.0%

Cost of Sales:

Retail

Services

TOTAL COST OF SALES

Gross Profit

Payroll:

Salaries & Wages

Employee Benefits

TOTAL PAYROLL

PRIME COST

Other Controllable Expenses:

Direct Operating Expenses

Music & Entertainment

Marketing

Utilities

General & Administrative Expenses

Repairs & Maintenance

TOTAL OTHER CONTROLLABLE EXP.

CONTROLLABLE PROFIT

Occupancy Costs & Depreciation

Occupancy Costs

Depreciation & Amortization

Other (Income) Expenses

Other (Income)

Interest Expense

Other Expense

NET INCOME BEFORE INCOME TAXES

ADD BACK:

Depreciation & Amortization

DEDUCT:

Loan Principal Payments

CASH FLOW BEFORE INCOME TAXES

KEY RATIOS:

Sales Per Square Foot

Sales Per Suite

Sales to Investment

5 Year Operating Projections

Year 1

Year 2

Year 3

Year 4

Year 5

Sales:

Retail

Services

TOTAL SALES

100.0%

Cost of Sales:

Retail

Services

TOTAL COST OF SALES

Gross Profit

Payroll:

Salaries & Wages

Employee Benefits

TOTAL PAYROLL

PRIME COST

Other Controllable Expenses:

Direct Operating Expenses

Marketing

Utilities

General & Administrative Expenses

Repairs & Maintenance

TOTAL OTHER CONTROLLABLE EXP.

CONTROLLABLE PROFIT

Occupancy Costs & Depreciation

Occupancy Costs

Depreciation & Amortization

Other (Income) Expenses

Other (Income)

Interest Expense

Other Expense

NET INCOME BEFORE INCOME TAXES

ADD BACK:

Depreciation & Amortization

DEDUCT:

Loan Principal Payments

CASH FLOW BEFORE INCOME TAXES

PROJECTED INVESTMENT RETURNS

Distributable Cash Flow Percent *

Distributable Cash Flow

Cash Distribution:

Investment Partner/Member (LLC)

Operating Partner/Member (LLC)

Investment Partner/Member (LLC) Returns:

Net Investment After Cash Distributions - End of Year

Payback Period

yrs.

Annual Return on Investment (before tax)

Average Annual Return on Investment

* It may be advantageous to retain a portion of the cash flow in the business for working capital, capital improvement reserves or for other reasons.

INVESTMENT ASSUMPTIONS

Total Equity Investment

Operating Partner/Member (LLC)

Equity Contribution

Cash Distribution Ratio Before Investor Payback*

Cash Distribution Ratio After Investor Payback

Investment Partner/Member (LLC)

Equity Contribution

Cash Distribution Ratio Before Investor Payback

Cash Distribution Ratio After Investor Payback

* Investor "Payback" is the point at which the investor recoups 100% of their Equity Contribution.

CASH DISTRIBUTION WORKSHEET - DO NOT PRINT

OPERATING ASSUMPTIONS - Years 2 - 5

Year 1

Sales - % Increase Over Prior Year

Investment Balance

Retail

Investor - Before Payback

Services

Investor - After Payback

Cost of Sales - Cost as a % of Sales

Total Cash Distributions

PROOF

Retail

Investor Portion-Before Payback

Services

Operator Portion-Before Payback

Salaries & Wages - % Increase over Prior Year

Amount Distributed - Before Payback

Salaries & Wages

Investor Portion-After Payback

Employee Benefits

Operator Portion-After Payback

Other Expenses - % Increase over Prior Year

PROOF

Direct Operating Expenses

Utilities

General & Administrative Expenses

Repairs & Maintenance

Occupancy Costs

Depreciation & Amortization (assumed to be constant in years 1-5)

Other (Income)

Interest Expense (from annual interest expense on loan amortization schedule on "Assumpti

Other Expense

Loan Principal Payments (from annual total principal payments on loan amortization schedule on "Assumptions" page)


CASH FLOW Break-Even Worksheet

Fixed Costs			Annual	Monthly

Minimum Hourly Labor










Loan Principal Payments


Variable Costs			% of Sales	$
Cost of Sales
Hourly Labor
Employee Benefits
Credit Card Expense


			Annual	Monthly
Percentage Rent

			Annual	Monthly	Weekly
		Break-even Sales

			Annual	Monthly	Weekly
	Sales Break-Down:
		Retail
		Services
		Total

Cash Flow Break-Even Sales Volume

MONTHLY

ANNUAL

Sales:

Retail

Services

TOTAL SALES

100.0%

Cost of Sales:

Retail

Services

TOTAL COST OF SALES

Gross Profit

Payroll:

Salaries & Wages

Employee Benefits

TOTAL PAYROLL

PRIME COST

Other Controllable Expenses:

Direct Operating Expenses

Music & Entertainment

Marketing

Utilities

General & Administrative Expenses

Repairs & Maintenance

TOTAL OTHER CONTROLLABLE EXP.

CONTROLLABLE PROFIT

Occupancy Costs & Depreciation

Occupancy Costs

Depreciation & Amortization

Other (Income) Expenses

Other (Income)

Interest Expense

Other Expense

NET INCOME BEFORE INCOME TAXES

ADD BACK:

Depreciation & Amortization

DEDUCT:

Loan Principal Payments

CASH FLOW BEFORE INCOME TAXES

BREAK-EVEN SALES

Week

Month

Year