Red, White & Bloom
Appendix
| 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 | $0 | $0 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $11,960 | $11,960 | |
| Direct Cost of Sales | $0 | $0 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $3,588 | $3,588 | |
| Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $3,588 | $3,588 | |
| Gross Margin | $0 | $0 | $4,872 | $4,872 | $4,872 | $4,872 | $4,872 | $4,872 | $4,872 | $4,872 | $8,372 | $8,372 | |
| Gross Margin % | 0.00% | 0.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | 70.00% | |
| Expenses | |||||||||||||
| Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Marketing & Advertising | $0 | $0 | $464 | $464 | $464 | $464 | $464 | $464 | $464 | $464 | $464 | $464 | |
| Depreciation | $0 | $0 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | |
| Rent | $0 | $0 | $0 | $0 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Delivery Labor | $0 | $0 | $400 | $400 | $450 | $450 | $500 | $500 | $500 | $500 | $600 | $700 | |
| Temp Labor | $0 | $0 | $0 | $192 | $192 | $0 | $0 | $0 | $0 | $0 | $192 | $192 | |
| Contracted Floral Designer | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Insurance | $0 | $0 | $339 | $339 | $339 | $339 | $339 | $339 | $339 | $339 | $339 | $339 | |
| Dues & Subscriptions | $0 | $0 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | $25 | |
| Repairs & Maintenance | $0 | $0 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Supplies | $0 | $0 | $265 | $265 | $265 | $265 | $265 | $265 | $265 | $265 | $265 | $265 | |
| Taxes | $0 | $0 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | |
| Other Fees | $0 | $0 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Buildout Costs | $0 | $9,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Deposits | $1,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $0 | $0 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| Van | 15% | $0 | $0 | $141 | $141 | $141 | $141 | $141 | $141 | $141 | $141 | $141 | $141 |
| Merchant Fees | $0 | $0 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | |
| Total Operating Expenses | $1,000 | $9,000 | $2,615 | $2,807 | $3,457 | $3,265 | $3,315 | $3,315 | $3,315 | $3,315 | $3,607 | $3,707 | |
| Profit Before Interest and Taxes | ($1,000) | ($9,000) | $2,257 | $2,065 | $1,415 | $1,607 | $1,557 | $1,557 | $1,557 | $1,557 | $4,765 | $4,665 | |
| EBITDA | ($1,000) | ($9,000) | $2,372 | $2,180 | $1,530 | $1,722 | $1,672 | $1,672 | $1,672 | $1,672 | $4,880 | $4,780 | |
| Interest Expense | $208 | $208 | $202 | $196 | $190 | $183 | $177 | $171 | $165 | $158 | $152 | $146 | |
| Taxes Incurred | ($362) | ($2,763) | $616 | $561 | $368 | $427 | $414 | $416 | $418 | $420 | $1,384 | $1,356 | |
| Net Profit | ($846) | ($6,446) | $1,438 | $1,308 | $858 | $997 | $966 | $970 | $975 | $979 | $3,229 | $3,163 | |
| Net Profit/Sales | 0.00% | 0.00% | 20.67% | 18.80% | 12.32% | 14.32% | 13.88% | 13.94% | 14.00% | 14.07% | 27.00% | 26.45% | |
| 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 | $70,350 | $70,322 | $69,289 | $68,312 | $67,590 | $67,499 | $66,976 | $66,587 | $66,168 | $65,753 | $65,343 | $69,791 | $70,037 |
| Inventory | $1,500 | $1,500 | $1,500 | $2,297 | $2,297 | $2,297 | $2,297 | $2,297 | $2,297 | $2,297 | $2,297 | $3,947 | $3,947 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $71,850 | $71,822 | $70,789 | $70,608 | $69,887 | $69,796 | $69,273 | $68,884 | $68,465 | $68,050 | $67,640 | $73,737 | $73,984 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 | $11,550 |
| Accumulated Depreciation | $0 | $0 | $0 | $115 | $230 | $345 | $460 | $575 | $690 | $805 | $920 | $1,035 | $1,150 |
| Total Long-term Assets | $11,550 | $11,550 | $11,550 | $11,435 | $11,320 | $11,205 | $11,090 | $10,975 | $10,860 | $10,745 | $10,630 | $10,515 | $10,400 |
| Total Assets | $83,400 | $83,372 | $82,339 | $82,043 | $81,207 | $81,001 | $80,363 | $79,859 | $79,325 | $78,795 | $78,270 | $84,252 | $84,384 |
| 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 | $818 | $6,231 | $5,997 | $5,352 | $5,788 | $5,653 | $5,683 | $5,679 | $5,675 | $5,670 | $9,924 | $8,392 |
| Current Borrowing | $50,000 | $50,000 | $50,000 | $48,500 | $47,000 | $45,500 | $44,000 | $42,500 | $41,000 | $39,500 | $38,000 | $36,500 | $35,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $50,000 | $50,818 | $56,231 | $54,497 | $52,352 | $51,288 | $49,653 | $48,183 | $46,679 | $45,175 | $43,670 | $46,424 | $43,392 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $50,000 | $50,818 | $56,231 | $54,497 | $52,352 | $51,288 | $49,653 | $48,183 | $46,679 | $45,175 | $43,670 | $46,424 | $43,392 |
| Paid-in Capital | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
| Retained Earnings | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) | ($11,600) |
| Earnings | $0 | ($846) | ($7,292) | ($5,853) | ($4,545) | ($3,687) | ($2,690) | ($1,725) | ($754) | $221 | $1,200 | $4,429 | $7,592 |
| Total Capital | $33,400 | $32,554 | $26,108 | $27,547 | $28,855 | $29,713 | $30,710 | $31,675 | $32,646 | $33,621 | $34,600 | $37,829 | $40,992 |
| Total Liabilities and Capital | $83,400 | $83,372 | $82,339 | $82,043 | $81,207 | $81,001 | $80,363 | $79,859 | $79,325 | $78,795 | $78,270 | $84,252 | $84,384 |
| Net Worth | $33,400 | $32,554 | $26,108 | $27,547 | $28,855 | $29,713 | $30,710 | $31,675 | $32,646 | $33,620 | $34,600 | $37,829 | $40,992 |
| 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 | |||||||||||||
| Retail Sales | 0% | $0 | $0 | $660 | $660 | $660 | $660 | $660 | $660 | $660 | $660 | $660 | $660 |
| Commercial Accounts | 0% | $0 | $0 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 |
| Frequent Buyer Programs | 0% | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Holidays/Events | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,000 | $5,000 |
| Total Sales | $0 | $0 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $11,960 | $11,960 | |
| 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 | |
| Flowers & Materials | $0 | $0 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $3,588 | $3,588 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $2,088 | $3,588 | $3,588 | |
| 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 | $0 | $0 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $11,960 | $11,960 | |
| Subtotal Cash from Operations | $0 | $0 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $11,960 | $11,960 | |
| 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 | $0 | $0 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $6,960 | $11,960 | $11,960 | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Bill Payments | $28 | $1,033 | $6,438 | $6,181 | $5,552 | $5,983 | $5,849 | $5,879 | $5,875 | $5,870 | $6,013 | $10,213 | |
| Subtotal Spent on Operations | $28 | $1,033 | $6,438 | $6,181 | $5,552 | $5,983 | $5,849 | $5,879 | $5,875 | $5,870 | $6,013 | $10,213 | |
| 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 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | $28 | $1,033 | $7,938 | $7,681 | $7,052 | $7,483 | $7,349 | $7,379 | $7,375 | $7,370 | $7,513 | $11,713 | |
| Net Cash Flow | ($28) | ($1,033) | ($978) | ($721) | ($92) | ($523) | ($389) | ($419) | ($415) | ($410) | $4,447 | $247 | |
| Cash Balance | $70,322 | $69,289 | $68,312 | $67,590 | $67,499 | $66,976 | $66,587 | $66,168 | $65,753 | $65,343 | $69,791 | $70,037 | |