Wishbone Pet Products

Start your own business plan »

Pet Products Manufacturer 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
Scoops 0% $0 $0 $0 $0 $30,975 $32,450 $33,925 $36,875 $38,350 $39,825 $42,775 $44,250
Bags 0% $0 $0 $0 $0 $7,088 $7,425 $7,763 $8,438 $15,863 $16,538 $17,550 $18,563
Total Sales $0 $0 $0 $0 $38,063 $39,875 $41,688 $45,313 $54,213 $56,363 $60,325 $62,813
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
Scoops $0 $0 $0 $0 $12,600 $13,200 $13,800 $15,000 $15,600 $16,200 $17,400 $18,000
Bags $0 $0 $0 $0 $3,150 $3,300 $3,450 $3,750 $7,050 $7,350 $7,800 $8,250
Subtotal Direct Cost of Sales $0 $0 $0 $0 $15,750 $16,500 $17,250 $18,750 $22,650 $23,550 $25,200 $26,250
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
General 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
Sales Manager 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Marketing Assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Marketing Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Operations Assistant 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Operations Manager 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
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 $0 $0 $38,063 $39,875 $41,688 $45,313 $54,213 $56,363 $60,325 $62,813
Direct Cost of Sales $0 $0 $0 $0 $15,750 $16,500 $17,250 $18,750 $22,650 $23,550 $25,200 $26,250
Shipping and Handling - scoops $0 $0 $0 $2,361 $464 $382 $297 $2,815 $676 $574 $471 $357
Shipping and Handling - bags $0 $0 $0 $1,594 $318 $262 $203 $2,576 $947 $822 $692 $555
Total Cost of Sales $0 $0 $0 $3,955 $16,532 $17,145 $17,750 $24,141 $24,273 $24,946 $26,364 $27,162
Gross Margin $0 $0 $0 ($3,955) $21,530 $22,730 $23,937 $21,171 $29,939 $31,417 $33,961 $35,650
Gross Margin % 0.00% 0.00% 0.00% 0.00% 56.57% 57.00% 57.42% 46.72% 55.23% 55.74% 56.30% 56.76%
Expenses
Payroll $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Sales and Marketing and Other Expenses $0 $0 $0 $0 $5,709 $5,981 $6,253 $6,797 $8,132 $8,454 $9,049 $9,422
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Insurance - liability $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Payroll Taxes 15% $825 $825 $825 $825 $825 $825 $825 $825 $825 $825 $825 $825
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $7,275 $7,275 $7,275 $7,275 $12,984 $13,256 $13,528 $14,072 $15,407 $15,729 $16,324 $16,697
Profit Before Interest and Taxes ($7,275) ($7,275) ($7,275) ($11,230) $8,546 $9,474 $10,409 $7,099 $14,532 $15,687 $17,638 $18,954
EBITDA ($7,275) ($7,275) ($7,275) ($11,230) $8,546 $9,474 $10,409 $7,099 $14,532 $15,687 $17,638 $18,954
Interest Expense $425 $418 $411 $404 $397 $390 $383 $376 $369 $362 $355 $348
Taxes Incurred ($2,310) ($2,308) ($2,306) ($3,490) $2,445 $2,725 $3,008 $2,017 $4,249 $4,598 $5,185 $5,582
Net Profit ($5,390) ($5,385) ($5,380) ($8,144) $5,704 $6,359 $7,018 $4,706 $9,914 $10,728 $12,098 $13,024
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 14.99% 15.95% 16.84% 10.39% 18.29% 19.03% 20.05% 20.73%
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 $0 $0 $9,516 $9,969 $10,422 $11,328 $13,553 $14,091 $15,081 $15,703
Cash from Receivables $0 $0 $0 $0 $0 $952 $28,592 $29,952 $31,356 $34,207 $40,713 $42,371
Subtotal Cash from Operations $0 $0 $0 $0 $9,516 $10,920 $39,014 $41,280 $44,909 $48,298 $55,794 $58,074
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 $0 $0 $9,516 $10,920 $39,014 $41,280 $44,909 $48,298 $55,794 $58,074
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 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
Bill Payments ($110) ($174) ($232) ($118) $1,354 $24,798 $36,001 $29,456 $33,601 $40,133 $42,041 $42,947
Subtotal Spent on Operations $5,390 $5,326 $5,268 $5,382 $6,854 $30,298 $41,501 $34,956 $39,101 $45,633 $47,541 $48,447
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 $0 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
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 $5,390 $6,726 $6,668 $6,782 $8,254 $31,698 $42,901 $36,356 $40,501 $47,033 $48,941 $49,847
Net Cash Flow ($5,390) ($6,726) ($6,668) ($6,782) $1,261 ($20,778) ($3,887) $4,924 $4,409 $1,264 $6,853 $8,227
Cash Balance $94,610 $87,884 $81,216 $74,433 $75,695 $54,917 $51,030 $55,954 $60,363 $61,627 $68,480 $76,707
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 $100,000 $94,610 $87,884 $81,216 $74,433 $75,695 $54,917 $51,030 $55,954 $60,363 $61,627 $68,480 $76,707
Accounts Receivable $0 $0 $0 $0 $0 $28,547 $57,502 $60,175 $64,208 $73,511 $81,576 $86,107 $90,845
Inventory $0 $0 $0 $0 $0 $17,325 $18,150 $18,975 $20,625 $24,915 $25,905 $27,720 $28,875
Other Current Assets $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
Total Current Assets $115,000 $109,610 $102,884 $96,216 $89,433 $136,567 $145,569 $145,180 $155,787 $173,789 $184,108 $197,307 $211,427
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $115,000 $109,610 $102,884 $96,216 $89,433 $136,567 $145,569 $145,180 $155,787 $173,789 $184,108 $197,307 $211,427
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 $0 $59 $171 $2,933 $45,762 $49,805 $43,798 $51,098 $60,586 $61,577 $64,078 $66,575
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 $0 $59 $171 $2,933 $45,762 $49,805 $43,798 $51,098 $60,586 $61,577 $64,078 $66,575
Long-term Liabilities $85,000 $85,000 $83,600 $82,200 $80,800 $79,400 $78,000 $76,600 $75,200 $73,800 $72,400 $71,000 $69,600
Total Liabilities $85,000 $85,000 $83,659 $82,371 $83,733 $125,162 $127,805 $120,398 $126,298 $134,386 $133,977 $135,078 $136,175
Paid-in Capital $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
Retained Earnings ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000)
Earnings $0 ($5,390) ($10,775) ($16,155) ($24,299) ($18,595) ($12,236) ($5,218) ($512) $9,403 $20,130 $32,228 $45,252
Total Capital $30,000 $24,610 $19,225 $13,845 $5,701 $11,405 $17,764 $24,782 $29,488 $39,403 $50,130 $62,228 $75,252
Total Liabilities and Capital $115,000 $109,610 $102,884 $96,216 $89,433 $136,567 $145,569 $145,180 $155,787 $173,789 $184,108 $197,307 $211,427
Net Worth $30,000 $24,610 $19,225 $13,845 $5,701 $11,405 $17,764 $24,782 $29,488 $39,403 $50,130 $62,228 $75,252