Inspirational Grounds

Start your own business plan »

Religious Coffeeshop Business Plan

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
Sales
Fresh Brewed Coffee 0% $3,239 $3,271 $3,304 $3,337 $3,371 $3,404 $3,438 $3,473 $3,507 $3,542 $3,578 $3,614
Espresso Based Beverages 0% $4,219 $4,261 $4,304 $4,347 $4,390 $4,434 $4,479 $4,523 $4,569 $4,614 $4,660 $4,707
Specialty Drinks 0% $2,738 $2,765 $2,793 $2,821 $2,849 $2,878 $2,906 $2,936 $2,965 $2,995 $3,024 $3,055
Pastries/Desserts 0% $1,140 $1,151 $1,163 $1,175 $1,186 $1,198 $1,210 $1,222 $1,234 $1,247 $1,259 $1,272
Music/CDs 0% $915 $924 $933 $943 $952 $962 $971 $981 $991 $1,001 $1,011 $1,021
Books 0% $915 $924 $933 $943 $952 $962 $971 $981 $991 $1,001 $1,011 $1,021
Fresh Roasted Coffee 0% $1,525 $1,540 $1,556 $1,571 $1,587 $1,603 $1,619 $1,635 $1,651 $1,668 $1,685 $1,701
Misc Candies/Products 0% $1,350 $1,364 $1,377 $1,391 $1,405 $1,419 $1,433 $1,447 $1,462 $1,476 $1,491 $1,506
Total Sales $16,041 $16,201 $16,363 $16,527 $16,692 $16,859 $17,028 $17,198 $17,370 $17,544 $17,719 $17,896
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Fresh Brewed Coffee $108 $109 $110 $111 $112 $114 $115 $116 $117 $118 $119 $120
Espresso Based Beverages $304 $307 $310 $313 $316 $320 $323 $326 $329 $332 $336 $339
Specialty Drinks $569 $575 $580 $586 $592 $598 $604 $610 $616 $622 $629 $635
Fresh Roasted Coffee $458 $463 $467 $472 $477 $481 $486 $491 $496 $501 $506 $511
Pastries/Desserts 50% $570 $576 $581 $587 $593 $599 $605 $611 $617 $623 $630 $636
Candies, etc. 50% $675 $682 $689 $695 $702 $709 $717 $724 $731 $738 $746 $753
Books/Music $916 $925 $934 $944 $953 $963 $972 $982 $992 $1,002 $1,012 $1,022
Subtotal Direct Cost of Sales $3,600 $3,636 $3,672 $3,709 $3,746 $3,784 $3,821 $3,860 $3,898 $3,937 $3,977 $4,016
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
Albert Brown - Operations Manager 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
Owner 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Baristas 0% $4,680 $4,680 $4,680 $4,680 $4,680 $4,680 $4,680 $4,680 $4,680 $4,680 $4,680 $4,680
Total People 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180
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 $16,041 $16,201 $16,363 $16,527 $16,692 $16,859 $17,028 $17,198 $17,370 $17,544 $17,719 $17,896
Direct Cost of Sales $3,600 $3,636 $3,672 $3,709 $3,746 $3,784 $3,821 $3,860 $3,898 $3,937 $3,977 $4,016
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $3,600 $3,636 $3,672 $3,709 $3,746 $3,784 $3,821 $3,860 $3,898 $3,937 $3,977 $4,016
Gross Margin $12,441 $12,565 $12,691 $12,818 $12,946 $13,076 $13,206 $13,338 $13,472 $13,607 $13,743 $13,880
Gross Margin % 77.56% 77.56% 77.56% 77.56% 77.56% 77.56% 77.56% 77.56% 77.56% 77.56% 77.56% 77.56%
Expenses
Payroll $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180
Marketing/Promotion $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Depreciation $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167
Leased Equipment $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $400 $400 $400 $400
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $2,365 $2,365 $2,365 $2,365 $2,365 $2,365 $2,365 $2,365 $2,365 $2,365 $2,365 $2,365
Website Hosting and Maintenance 0% $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Payroll Taxes 15% $927 $927 $927 $927 $927 $927 $927 $927 $916 $927 $927 $927
Other $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Total Operating Expenses $11,614 $11,614 $11,614 $11,614 $11,614 $11,614 $11,614 $11,614 $11,703 $11,714 $11,714 $11,714
Profit Before Interest and Taxes $827 $951 $1,077 $1,204 $1,332 $1,462 $1,592 $1,724 $1,769 $1,893 $2,029 $2,166
EBITDA $994 $1,118 $1,244 $1,371 $1,499 $1,629 $1,759 $1,891 $1,936 $2,060 $2,196 $2,333
Interest Expense $132 $131 $131 $130 $129 $128 $127 $126 $125 $124 $123 $122
Taxes Incurred $174 $205 $237 $269 $301 $333 $366 $400 $411 $442 $476 $511
Net Profit $521 $615 $710 $806 $903 $1,000 $1,099 $1,199 $1,233 $1,326 $1,429 $1,533
Net Profit/Sales 3.25% 3.80% 4.34% 4.88% 5.41% 5.93% 6.45% 6.97% 7.10% 7.56% 8.07% 8.57%
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 $16,041 $16,201 $16,363 $16,527 $16,692 $16,859 $17,028 $17,198 $17,370 $17,544 $17,719 $17,896
Subtotal Cash from Operations $16,041 $16,201 $16,363 $16,527 $16,692 $16,859 $17,028 $17,198 $17,370 $17,544 $17,719 $17,896
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 $16,041 $16,201 $16,363 $16,527 $16,692 $16,859 $17,028 $17,198 $17,370 $17,544 $17,719 $17,896
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,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180 $6,180
Bill Payments $219 $6,662 $9,243 $9,349 $9,417 $9,486 $9,555 $9,626 $9,699 $9,836 $9,916 $9,989
Subtotal Spent on Operations $6,399 $12,842 $15,423 $15,529 $15,597 $15,666 $15,735 $15,806 $15,879 $16,016 $16,096 $16,169
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 $555 $555 $555 $555 $555 $555 $555 $555 $555 $555 $555 $555
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 $6,954 $13,397 $15,978 $16,084 $16,152 $16,221 $16,290 $16,361 $16,434 $16,571 $16,651 $16,724
Net Cash Flow $9,087 $2,804 $386 $443 $540 $638 $737 $837 $936 $973 $1,068 $1,173
Cash Balance $39,687 $42,491 $42,877 $43,320 $43,861 $44,499 $45,237 $46,074 $47,010 $47,983 $49,052 $50,224
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 $30,600 $39,687 $42,491 $42,877 $43,320 $43,861 $44,499 $45,237 $46,074 $47,010 $47,983 $49,052 $50,224
Inventory $6,600 $4,000 $4,000 $4,040 $4,080 $4,121 $4,162 $4,204 $4,246 $4,288 $4,331 $4,374 $4,418
Other Current Assets $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Total Current Assets $49,200 $55,687 $58,491 $58,917 $59,400 $59,982 $60,661 $61,440 $62,320 $63,298 $64,314 $65,426 $66,642
Long-term Assets
Long-term Assets $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000
Accumulated Depreciation $0 $167 $334 $501 $668 $835 $1,002 $1,169 $1,336 $1,503 $1,670 $1,837 $2,004
Total Long-term Assets $16,000 $15,833 $15,666 $15,499 $15,332 $15,165 $14,998 $14,831 $14,664 $14,497 $14,330 $14,163 $13,996
Total Assets $65,200 $71,520 $74,157 $74,416 $74,732 $75,147 $75,659 $76,271 $76,984 $77,795 $78,644 $79,589 $80,638
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 $0 $6,354 $8,931 $9,035 $9,101 $9,167 $9,235 $9,303 $9,371 $9,505 $9,583 $9,654 $9,725
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $6,354 $8,931 $9,035 $9,101 $9,167 $9,235 $9,303 $9,371 $9,505 $9,583 $9,654 $9,725
Long-term Liabilities $80,000 $79,445 $78,890 $78,335 $77,780 $77,225 $76,670 $76,115 $75,560 $75,005 $74,450 $73,895 $73,340
Total Liabilities $80,000 $85,799 $87,821 $87,370 $86,881 $86,392 $85,905 $85,418 $84,931 $84,510 $84,033 $83,549 $83,065
Paid-in Capital $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Retained Earnings ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800) ($29,800)
Earnings $0 $521 $1,136 $1,846 $2,652 $3,554 $4,554 $5,654 $6,852 $8,085 $9,412 $10,841 $12,373
Total Capital ($14,800) ($14,279) ($13,664) ($12,954) ($12,148) ($11,246) ($10,246) ($9,146) ($7,948) ($6,715) ($5,388) ($3,959) ($2,427)
Total Liabilities and Capital $65,200 $71,520 $74,157 $74,416 $74,732 $75,147 $75,659 $76,271 $76,984 $77,795 $78,644 $79,589 $80,638
Net Worth ($14,800) ($14,279) ($13,664) ($12,954) ($12,148) ($11,246) ($10,246) ($9,146) ($7,948) ($6,715) ($5,388) ($3,959) ($2,427)