Inspirational Grounds
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) |