probp coffee shop spreadsheet business plan
TRANSCRIPT
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
1/60
The Business Plan
for Your Coffee Shop
Fourth Edition
Jack Samson
Prepared with ProBPThe Professional Business Plan Software Solu
Copyright 2004-2014 by BusinessBookSource.com
A rights reser!ed.
BusinessBookSource.com" 12#aday" 12#aday.com" Business $ak and ProBP %busine
are trademarks of Dallas Distribution and Publishing Company, Inc.
BusinessBookSource.com
P( Bo) #414
*risco" $e)as +#0,#
-/00-++
$his pubication is designed to pro!ide accurate and authoritati!e in&ormation in regard to the subec
understanding that the pubisher is not engaged in rendering pro&essiona ser!ices. & ega" account
e)pert assistance is reuired" the ser!ices o& a competent pro&essiona person shoud be sought.
P58CP7S (* A 9(8$ C(66$$ (* $: A65CA8 BA5 ASS(CA$(8 A83 P;B7S:5S.
5eproduction or transation o& any part o& this work beyond that permitted by Section 10+ or 10 o&
without the permission o& the copyright owner is unaw&u. 5euests &or permission or &urther in&o
Permissions 3epartment" BusinessBookSource.com
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
2/60
The Business Plan for the Name of Your Small Business
Copyright !""# Pro$P %ll &ights &eser'ed Page ! of ("
Personal Net Worth Calculation
Assets
Property
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
3/60
The Business Plan for the Name of Your Small Business
Copyright !""# Pro$P %ll &ights &eser'ed Page ) of ("
Your Personal Bu#get
stimate# e%pen#iture &non'"usiness( 1 month , months months >ear
6ortgage =0 0 0 0
5ent =0 0 0 0
Property $a) =0 0 0 0
Property nsurance =0 0 0 0
;tiities %ectricity" water etc' =0 0 0 0
Persona nsurance =0 0 0 0
*ood ? @enera :ousekeeping =0 0 0 0
$eephone =0 0 0 0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
4/60
The Business Plan for the Name of Your Small Business
Copyright !""# Pro$P %ll &ights &eser'ed Page + of ("
* ! ) +
"
*","""
!","""
)","""
+","""
-","""
, ncome ee e
Total Income
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
5/60
The Business Plan for the Name of Your Small Business
Copyright !""# Pro$P %ll &ights &eser'ed Page - of ("
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
6/60
The Business Plan for the Name of Your Small Business
Copyright !""# Pro$P %ll &ights &eser'ed Page ( of ("
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
7/60
The Business Plan for the Name of Your Small Business
Copyright !""# Pro$P %ll &ights &eser'ed Page # of ("
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
8/60
Copyright !""# Pro$P %ll &ights &eser'ed Page of ("
$he Business Pan
*or
The Name of Your Small Business
O)ner Information
Business 8ame
Address Address 7ine 1
Address 7ine 2
City" S$ 22222
$eephone 222-,,,-4444
*a) 111-222-,,,,
mai )ye)ampe.com
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
9/60
Copyright !""# Pro$P %ll &ights &eser'ed Page / of ("
%ecutive Summary
The Company
*ission Statement
*anagement
The Opportunity
Pro#ucts + *ar,ets
Sales an# Profit Summary
-un#ing .e/uirement
Investment Proposal
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
10/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *" of ("
0eneral Company 1escription
Company 0oals an# O"2ectives
Business Philosophy
!egal -orm of O)nership
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
11/60
Copyright !""# Pro$P %ll &ights &eser'ed Page ** of ("
Pro#ucts an# Services 1escription
n %planation of the -acts3 Assumptions3 an# Information Pertaining to the Pro#
an# Services of the Company4
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
12/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *! of ("
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
13/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *) of ("
Start'5p Costs
An %planation of the -acts3 Assumptions3 an# Information Pe
Start 5p Costs Section of this Small Business Pla
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
14/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *+ of ("
Start'up Costs
%Pre-5e!enue %,-6onths
Cash 5euirements' assuming no re!enue'
Audit ? Accounting *ees =0 =0
Bus 3e!. - $ra!e =0 =0
Bus. 3e!. - ntertainment =0 =0
Bus. 3e!. - 6eas =0 =0Capita Acuisitions =0 =0
Charitabe Contributions =0 =0
Commissions =0 =0
Con&erences D Seminars =0 =0
Consuting *ees =0 =0
Contingencies =0 =0
mpoyee Bene&its =0 =0
ntertainment =0 =0
uipment 7ease =0 =0
*aciities - nsurance =0 =0
*aciities - Phone =0 =0
*aciities - Property $a)es =0 =0*aciities - 5ent =0 =0
*aciities - Security =0 =0
*aciities - ;tiities =0 =0
*aciity - (ther =0 =0
*inancia Charges =0 =0
*urniture =0 =0
nsurance =0 =0
n!entory Purchases =0 =0
$ Consuting =0 =0
7ega *ees =0 =0
7oan nterest =0 =0
7oan Capita =0 =06isceaneous =0 =0
(&&ice Suppies =0 =0
Payro - Administrati!e Sta&& =0 =0
Payro - Saes ? 6arketing =0 =0
Payro - (wner ? 3irectors =0 =0
Payro $a)es =0 =0
Posta ? Shipping =0 =0
P5 ? Ad!ertising =0 =0
5epairs D 6aintenance =0 =0
5esearch and 3e!eopment =0 =0
Storage =0 =0
Subscriptions D 3ues =0 =0$a)es D 7icenses =0 =0
$eecommunications =0 =0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
15/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *- of ("
*ar,eting Plan
conomics
Pro#uct
Customers
Competition
Niche
*ar,eting Strategy
Promotion
Promotional Bu#get
Pricing
Propose# !ocation
1istri"ution Channels
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
16/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *( of ("
Saes *orecast
Month 1 2 3 Quarter 1
.evenue $4 $4 $4 $
Co&&ee Cub 1 0 0 0 =0Specia Bend 2 0 0 0 =0
*u Ser!ice 6enu , 0 0 0 =0
@rab and @o 6enu 4 0 0 0 =0
(ther Co&&ee Shop Products # 0 0 0 =0
(ther Co&&ee Shop Products 0 0 0 =0
(ther Co&&ee Shop Products + 0 0 0 =0
(ther Co&&ee Shop Products 0 0 0 =0
(ther Co&&ee Shop Products / 0 0 0 =0
(ther Co&&ee Shop Products 10 0 0 0 =0
(ther Co&&ee Shop Products 1 0 0 0 =0
(ther Co&&ee Shop Products 2 0 0 0 =0
(ther Co&&ee Shop Products , 0 0 0 =0Sou!enirs 4 0 0 0 =0
3ei!ery Ser!ice # 0 0 0 =0
Bakery Products 0 0 0 =0
Business 6eetings + 0 0 0 =0
(ther Co&&ee Shop Products 0 0 0 =0
(ther Co&&ee Shop Products / 0 0 0 =0
(ther Co&&ee Shop Products 10 0 0 0 =0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
17/60
Copyright !""# Pro$P %ll &ights &eser'ed Page *# of ("
Saes *orecast
Month
.evenue
Co&&ee Cub 1Specia Bend 2
*u Ser!ice 6enu ,
@rab and @o 6enu 4
(ther Co&&ee Shop Products #
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
(ther Co&&ee Shop Products 1
(ther Co&&ee Shop Products 2
(ther Co&&ee Shop Products ,Sou!enirs 4
3ei!ery Ser!ice #
Bakery Products
Business 6eetings +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
4 5 6 Quarter 2
$4 $4 $4 $
=0 =0 =0 =0=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
".""
".*"
".!"
".)"
".+"
".-"
".("
".#"
"."
"./"
*.""
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
18/60
Copyright !""# Pro$P %ll &ights &eser'ed Page * of ("
Saes *orecast
Month
.evenue
Co&&ee Cub 1Specia Bend 2
*u Ser!ice 6enu ,
@rab and @o 6enu 4
(ther Co&&ee Shop Products #
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
(ther Co&&ee Shop Products 1
(ther Co&&ee Shop Products 2
(ther Co&&ee Shop Products ,Sou!enirs 4
3ei!ery Ser!ice #
Bakery Products
Business 6eetings +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
7 8 9
$4 $4 $4
=0 =0 =0=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
=0 =0 =0
Sales Forecasting
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
19/60
Copyright !""# Pro$P %ll &ights &eser'ed Page */ of ("
Saes *orecast
Month
.evenue
Co&&ee Cub 1Specia Bend 2
*u Ser!ice 6enu ,
@rab and @o 6enu 4
(ther Co&&ee Shop Products #
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
(ther Co&&ee Shop Products 1
(ther Co&&ee Shop Products 2
(ther Co&&ee Shop Products ,Sou!enirs 4
3ei!ery Ser!ice #
Bakery Products
Business 6eetings +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
Quarter 3 10 11 12
$ $4 $4 $4
=0 =0 =0 =0=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
=0 =0 =0 =0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
20/60
Copyright !""# Pro$P %ll &ights &eser'ed Page !" of ("
Saes *orecast
Month
.evenue
Co&&ee Cub 1Specia Bend 2
*u Ser!ice 6enu ,
@rab and @o 6enu 4
(ther Co&&ee Shop Products #
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
(ther Co&&ee Shop Products 1
(ther Co&&ee Shop Products 2
(ther Co&&ee Shop Products ,Sou!enirs 4
3ei!ery Ser!ice #
Bakery Products
Business 6eetings +
(ther Co&&ee Shop Products
(ther Co&&ee Shop Products /
(ther Co&&ee Shop Products 10
uarter 4 Year Total
$ $
=0 =0=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
=0 =0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
21/60
Copyright !""# Pro$P %ll &ights &eser'ed Page !* of ("
The Operational Plan
Pro#uction
!ocation
!egal nvironment
Personnel
Inventory
Suppliers
Cre#it Policies
*anaging your Accounts .eceiva"le
*anaging your Accounts Paya"le
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
22/60
Copyright !""# Pro$P %ll &ights &eser'ed Page !! of ("
6anagement and (rganiation
An %planation of the Information Pertaining to *anagement a
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
23/60
Copyright !""# Pro$P %ll &ights &eser'ed Page !) of ("
-inancial Plan Narrative
Profit an# !oss Statement
Balance Sheet
Brea,even Analysis
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
24/60
Profit'!oss Statement
Month 1 Month 2 Month 3 Quarter 1
.evenue
@ross Saes =0 =0 =0 =07ess 5eturns and Aowances 0
Net Sales 0 0 0 0
Cost of SalesBeginning n!entory 0 0 0 0
Purchases %8et' 0
Sub-Contractors 0
3irect 7abor 0
nding n!entory %8egati!e' 0
Total Cost of Sales 0 0 0 0
0ross Profit &!oss( =0 =0 =0 =0
%pensesAudit ? Accounting *ees 0 0 0 0
Bus 3e!. - $ra!e 0 0 0 0
Bus. 3e!. - ntertainment 0 0 0 0Bus. 3e!. - 6eas 0 0 0 0
Capita Acuisitions n?a n?a n?a n?a
Charitabe Contributions 0 0 0 0
Commissions 0 0 0 0
Con&erences D Seminars 0 0 0 0
Consuting *ees 0 0 0 0
3epreciation 0 0 0 0
mpoyee Bene&its 0 0 0 0
ntertainment 0 0 0 0
uipment 7ease 0 0 0 0
*aciities - nsurance 0 0 0 0
*aciities - Phone 0 0 0 0
*aciities - Property $a)es 0 0 0 0
*aciities - 5ent 0 0 0 0
*aciities - Security 0 0 0 0*aciities - ;tiities 0 0 0 0
*aciity - (ther 0 0 0 0
*inancia Charges 0 0 0 0
*urniture 0 0 0 0
nsurance 0 0 0 0
n!entory Purchases 0 0 0 n?a
$ Consuting 0 0 0 0
7ega *ees 0 0 0 0
7oan Capita 0 0 0 n?a
7oan nterest 0 0 0 0
6isceaneous 0 0 0 0
(&&ice Suppies 0 0 0 0
Payro - (perationa sta&& 0 0 0 0
Payro - Administrati!e Sta&& 0 0 0 0
Payro - (wner ? 3irectors 0 0 0 0Payro - Saes ? 6arketing 0 0 0 0
Payro $a)es 0 0 0 0
Posta ? Shipping 0 0 0 0
P5 ? Ad!ertising 0 0 0 0
5epairs D 6aintenance 0 0 0 0
5esearch and 3e!eopment 0 0 0 0
Storage 0 0 0 0
Subscriptions D 3ues 0 0 0 0
$a)es D 7icenses 0 0 0 0
$eecommunications 0 0 0 0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
25/60
Profit'!oss Statem
.evenue
@ross Saes7ess 5eturns and Aowances
Net Sales
Cost of SalesBeginning n!entory
Purchases %8et'
Sub-Contractors
3irect 7abor
nding n!entory %8egati!e'
Total Cost of Sales
0ross Profit &!oss(
%pensesAudit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainmentBus. 3e!. - 6eas
Capita Acuisitions
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees
3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
n!entory Purchases
$ Consuting
7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectorsPayro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
Storage
Subscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
26/60
Profit'!oss Statem
.evenue
@ross Saes7ess 5eturns and Aowances
Net Sales
Cost of SalesBeginning n!entory
Purchases %8et'
Sub-Contractors
3irect 7abor
nding n!entory %8egati!e'
Total Cost of Sales
0ross Profit &!oss(
%pensesAudit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainmentBus. 3e!. - 6eas
Capita Acuisitions
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees
3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
n!entory Purchases
$ Consuting
7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectorsPayro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
Storage
Subscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
27/60
Profit'!oss Statem
.evenue
@ross Saes7ess 5eturns and Aowances
Net Sales
Cost of SalesBeginning n!entory
Purchases %8et'
Sub-Contractors
3irect 7abor
nding n!entory %8egati!e'
Total Cost of Sales
0ross Profit &!oss(
%pensesAudit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainmentBus. 3e!. - 6eas
Capita Acuisitions
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees
3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
n!entory Purchases
$ Consuting
7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectorsPayro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
Storage
Subscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
28/60
nterest ncome
Total Other Income 0 0 0
Net Income &!oss( =0 =0 =0
Cumulative Net Income &!oss( =0 =0 =0
A B C D E F G H I
72
7374757677
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
29/60
nterest ncome
Total Other Income
Net Income &!oss(
Cumulative Net Income &!oss(
0 0 0
=0 =0 =0
=0 =0 =0
A B K L M N O P Q
72
7374757677
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
30/60
nterest ncome
Total Other Income
Net Income &!oss(
Cumulative Net Income &!oss(
0 0 0
=0 =0 =0
=0 =0 =0
A B S T U ! " #
72
7374757677
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
31/60
nterest ncome
Total Other Income
Net Income &!oss(
Cumulative Net Income &!oss(
0
0 0 0 0
=0 =0 =0 =0
=0 =0 =0 =0
A B AA AB AC AD AE AF AG AH
72
7374
75
7677
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
32/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )! of ("
Pro2ecte# Cash -lo)
Month 1
Budget Actual Variance To ate
.evenue5eceipts 0 0 0 0
Cash Saes 0 0 0 0
(ther ncome 0 0 0 0
Total .eceipts $ $ $ $
Payments6ateria Purchases - Cash 0 0 0 0
6ateria Purchases - Creditors 0 0
Sub-Contractors 0 0
Audit ? Accounting *ees 0 0 0
Bus 3e!. - $ra!e 0 0 0
Bus. 3e!. - ntertainment 0 0 0
Bus. 3e!. - 6eas 0 0 0
Charitabe Contributions 0 0 0
Commissions 0 0 0
Con&erences D Seminars 0 0 0
Consuting *ees 0 0 03epreciation n?a n?a
mpoyee Bene&its 0 0 0
ntertainment 0 0 0
uipment 7ease 0 0 0
*aciities - nsurance 0 0 0
*aciities - Phone 0 0 0
*aciities - Property $a)es 0 0 0
*aciities - 5ent 0 0 0
*aciities - Security 0 0 0
*aciities - ;tiities 0 0 0
*aciity - (ther 0 0 0
*inancia Charges 0 0 0
*urniture 0 0 0
nsurance 0 0 0
$ Consuting 0 0 07ega *ees 0 0 0
7oan Capita 0 0 0
7oan nterest 0 0 0
6isceaneous 0 0 0
(&&ice Suppies 0 0 0
Payro - (perationa Sta&& 0 0 0
Payro - Administrati!e Sta&& 0 0 0
Payro - (wner ? 3irectors 0 0 0
Payro - Saes ? 6arketing 0 0 0
Payro $a)es 0 0 0
Posta ? Shipping 0 0 0
P5 ? Ad!ertising 0 0 0
5epairs D 6aintenance 0 0 0
5esearch and 3e!eopment 0 0 0
Storage 0 0 0Subscriptions D 3ues 0 0 0
$a)es D 7icenses 0 0 0
$eecommunications 0 0 0
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
33/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )) of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
34/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )+ of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
35/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )- of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
36/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )( of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
37/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )# of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
38/60
Copyright !""# Pro$P %ll &ights &eser'ed Page ) of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
39/60
Copyright !""# Pro$P %ll &ights &eser'ed Page )/ of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
40/60
Copyright !""# Pro$P %ll &ights &eser'ed Page +" of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
41/60
Copyright !""# Pro$P %ll &ights &eser'ed Page +* of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
42/60
Copyright !""# Pro$P %ll &ights &eser'ed Page +! of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
43/60
Copyright !""# Pro$P %ll &ights &eser'ed Page +) of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
44/60
Copyright !""# Pro$P %ll &ights &eser'ed Page ++ of ("
Pro2ecte# Cash -lo
.evenue5eceipts
Cash Saes
(ther ncome
Total .eceipts
Payments6ateria Purchases - Cash
6ateria Purchases - Creditors
Sub-Contractors
Audit ? Accounting *ees
Bus 3e!. - $ra!e
Bus. 3e!. - ntertainment
Bus. 3e!. - 6eas
Charitabe Contributions
Commissions
Con&erences D Seminars
Consuting *ees3epreciation
mpoyee Bene&its
ntertainment
uipment 7ease
*aciities - nsurance
*aciities - Phone
*aciities - Property $a)es
*aciities - 5ent
*aciities - Security
*aciities - ;tiities
*aciity - (ther
*inancia Charges
*urniture
nsurance
$ Consuting7ega *ees
7oan Capita
7oan nterest
6isceaneous
(&&ice Suppies
Payro - (perationa Sta&&
Payro - Administrati!e Sta&&
Payro - (wner ? 3irectors
Payro - Saes ? 6arketing
Payro $a)es
Posta ? Shipping
P5 ? Ad!ertising
5epairs D 6aintenance
5esearch and 3e!eopment
StorageSubscriptions D 3ues
$a)es D 7icenses
$eecommunications
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
45/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
46/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
47/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
48/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
49/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
50/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
51/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
52/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
53/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
54/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
55/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
56/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
57/60
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
58/60 Copyright !""# Pro$P %ll &ights &eser'ed Page - of (
Baance Sheet
A""et"
#urrent A""et"
Cash 0
Accounts 5ecei!abe 0
7ess 5eser!e &or Bad 3ebts 0 0
6erchandise n!entory 0Prepaid )penses 0
8otes 5ecei!abe 0
Total #urrent A""et" =0
$i%ed A""et"
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
59/60
Total #a)ital =0
#a)ital
0
0
=0
=0
uity %beginning in!estment with income ? oss'
8et Pro&it %&rom actua pD'
Total #a)ital ,"hould e-ual line 59.
Total A""et" ,"hould e-ual line 37.
-
7/23/2019 ProBP Coffee Shop Spreadsheet Business Plan
60/60
Brea,'ven Analysis
A77 B;S8SS P7A8S 83 $( FP7A8 E:8 $: B;S8SS E77 B5AG