Glen Mar Forest Products
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 | |||||||||||||
Wholesale Distributors | 0% | $14,000 | $14,000 | $14,000 | $16,000 | $16,000 | $17,500 | $18,000 | $18,000 | $20,000 | $20,000 | $20,000 | $22,000 |
Landscaping Professionals | 0% | $5,000 | $5,000 | $6,000 | $6,000 | $8,000 | $10,000 | $12,000 | $12,000 | $13,000 | $14,000 | $16,000 | $17,000 |
Total Sales | $19,000 | $19,000 | $20,000 | $22,000 | $24,000 | $27,500 | $30,000 | $30,000 | $33,000 | $34,000 | $36,000 | $39,000 | |
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 | |
Wholesale Distributors | $4,000 | $4,000 | $4,000 | $4,400 | $6,000 | $6,300 | $8,000 | $8,200 | $9,000 | $10,000 | $10,000 | $12,000 | |
Landscaping Professionals | $1,000 | $1,000 | $1,000 | $1,080 | $1,200 | $1,280 | $1,700 | $1,740 | $1,800 | $2,000 | $2,000 | $2,500 | |
Subtotal Direct Cost of Sales | $5,000 | $5,000 | $5,000 | $5,480 | $7,200 | $7,580 | $9,700 | $9,940 | $10,800 | $12,000 | $12,000 | $14,500 |
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 | ||
Chales Marshall | 0% | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 |
Production Manager | 0% | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 | $2,800 |
Production Staff (3) | 0% | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | $19,000 | $19,000 | $20,000 | $22,000 | $24,000 | $27,500 | $30,000 | $30,000 | $33,000 | $34,000 | $36,000 | $39,000 | |
Direct Cost of Sales | $5,000 | $5,000 | $5,000 | $5,480 | $7,200 | $7,580 | $9,700 | $9,940 | $10,800 | $12,000 | $12,000 | $14,500 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $5,000 | $5,000 | $5,000 | $5,480 | $7,200 | $7,580 | $9,700 | $9,940 | $10,800 | $12,000 | $12,000 | $14,500 | |
Gross Margin | $14,000 | $14,000 | $15,000 | $16,520 | $16,800 | $19,920 | $20,300 | $20,060 | $22,200 | $22,000 | $24,000 | $24,500 | |
Gross Margin % | 73.68% | 73.68% | 75.00% | 75.09% | 70.00% | 72.44% | 67.67% | 66.87% | 67.27% | 64.71% | 66.67% | 62.82% | |
Expenses | |||||||||||||
Payroll | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | |
Sales and Marketing and Other Expenses | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Depreciation | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | $240 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Payroll Taxes | 15% | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | $17,700 | |
Profit Before Interest and Taxes | ($3,700) | ($3,700) | ($2,700) | ($1,180) | ($900) | $2,220 | $2,600 | $2,360 | $4,500 | $4,300 | $6,300 | $6,800 | |
EBITDA | ($3,460) | ($3,460) | ($2,460) | ($940) | ($660) | $2,460 | $2,840 | $2,600 | $4,740 | $4,540 | $6,540 | $7,040 | |
Interest Expense | $827 | $820 | $813 | $807 | $800 | $793 | $787 | $780 | $773 | $767 | $760 | $753 | |
Taxes Incurred | ($1,358) | ($1,356) | ($1,054) | ($596) | ($510) | $428 | $544 | $474 | $1,118 | $1,060 | $1,662 | $1,814 | |
Net Profit | ($3,169) | ($3,164) | ($2,459) | ($1,391) | ($1,190) | $999 | $1,269 | $1,106 | $2,609 | $2,473 | $3,878 | $4,233 | |
Net Profit/Sales | -16.68% | -16.65% | -12.30% | -6.32% | -4.96% | 3.63% | 4.23% | 3.69% | 7.91% | 7.27% | 10.77% | 10.85% |
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 | $5,700 | $5,700 | $6,000 | $6,600 | $7,200 | $8,250 | $9,000 | $9,000 | $9,900 | $10,200 | $10,800 | $11,700 | |
Cash from Receivables | $0 | $443 | $13,300 | $13,323 | $14,047 | $15,447 | $16,882 | $19,308 | $21,000 | $21,070 | $23,123 | $23,847 | |
Subtotal Cash from Operations | $5,700 | $6,143 | $19,300 | $19,923 | $21,247 | $23,697 | $25,882 | $28,308 | $30,900 | $31,270 | $33,923 | $35,547 | |
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 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $5,700 | $6,143 | $19,300 | $19,923 | $21,247 | $33,697 | $25,882 | $28,308 | $30,900 | $31,270 | $33,923 | $35,547 | |
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 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | $10,400 | |
Bill Payments | $218 | $6,529 | $6,567 | $7,985 | $12,901 | $16,437 | $16,417 | $20,359 | $18,591 | $20,748 | $22,183 | $21,662 | |
Subtotal Spent on Operations | $10,618 | $16,929 | $16,967 | $18,385 | $23,301 | $26,837 | $26,817 | $30,759 | $28,991 | $31,148 | $32,583 | $32,062 | |
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 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
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 | $11,418 | $17,729 | $17,767 | $19,185 | $24,101 | $27,637 | $27,617 | $31,559 | $29,791 | $31,948 | $33,383 | $32,862 | |
Net Cash Flow | ($5,718) | ($11,585) | $1,533 | $739 | ($2,854) | $6,060 | ($1,736) | ($3,251) | $1,109 | ($678) | $541 | $2,685 | |
Cash Balance | $16,482 | $4,897 | $6,430 | $7,169 | $4,315 | $10,375 | $8,639 | $5,388 | $6,497 | $5,820 | $6,361 | $9,045 |
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 | $22,200 | $16,482 | $4,897 | $6,430 | $7,169 | $4,315 | $10,375 | $8,639 | $5,388 | $6,497 | $5,820 | $6,361 | $9,045 |
Accounts Receivable | $0 | $13,300 | $26,157 | $26,857 | $28,933 | $31,687 | $35,490 | $39,608 | $41,300 | $43,400 | $46,130 | $48,207 | $51,660 |
Inventory | $20,000 | $15,000 | $10,000 | $6,000 | $6,028 | $7,920 | $8,338 | $10,670 | $10,934 | $11,880 | $13,200 | $13,200 | $15,950 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $42,200 | $44,782 | $41,054 | $39,287 | $42,130 | $43,921 | $54,203 | $58,917 | $57,622 | $61,777 | $65,150 | $67,767 | $76,655 |
Long-term Assets | |||||||||||||
Long-term Assets | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
Accumulated Depreciation | $0 | $240 | $480 | $720 | $960 | $1,200 | $1,440 | $1,680 | $1,920 | $2,160 | $2,400 | $2,640 | $2,880 |
Total Long-term Assets | $50,000 | $49,760 | $49,520 | $49,280 | $49,040 | $48,800 | $48,560 | $48,320 | $48,080 | $47,840 | $47,600 | $47,360 | $47,120 |
Total Assets | $92,200 | $94,542 | $90,574 | $88,567 | $91,170 | $92,721 | $102,763 | $107,237 | $105,702 | $109,617 | $112,750 | $115,127 | $123,775 |
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,311 | $6,307 | $7,559 | $12,353 | $15,894 | $15,737 | $19,742 | $17,901 | $20,007 | $21,466 | $20,766 | $25,981 |
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,311 | $6,307 | $7,559 | $12,353 | $15,894 | $15,737 | $19,742 | $17,901 | $20,007 | $21,466 | $20,766 | $25,981 |
Long-term Liabilities | $100,000 | $99,200 | $98,400 | $97,600 | $96,800 | $96,000 | $95,200 | $94,400 | $93,600 | $92,800 | $92,000 | $91,200 | $90,400 |
Total Liabilities | $100,000 | $105,511 | $104,707 | $105,159 | $109,153 | $111,894 | $110,937 | $114,142 | $111,501 | $112,807 | $113,466 | $111,966 | $116,381 |
Paid-in Capital | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 | $110,000 |
Retained Earnings | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) | ($107,800) |
Earnings | $0 | ($3,169) | ($6,333) | ($8,792) | ($10,183) | ($11,373) | ($10,374) | ($9,105) | ($7,999) | ($5,390) | ($2,917) | $961 | $5,194 |
Total Capital | ($7,800) | ($10,969) | ($14,133) | ($16,592) | ($17,983) | ($19,173) | ($8,174) | ($6,905) | ($5,799) | ($3,190) | ($717) | $3,161 | $7,394 |
Total Liabilities and Capital | $92,200 | $94,542 | $90,574 | $88,567 | $91,170 | $92,721 | $102,763 | $107,237 | $105,702 | $109,617 | $112,750 | $115,127 | $123,775 |
Net Worth | ($7,800) | ($10,969) | ($14,133) | ($16,592) | ($17,983) | ($19,173) | ($8,174) | ($6,905) | ($5,799) | ($3,190) | ($717) | $3,161 | $7,394 |