Wishbone Pet 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 | |||||||||||||
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 |