Tall Drink of Water

Start your own business plan »

Pet Supplies 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
Basic small feeder 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic medium feeder 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic large feeder 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic extra large feeder 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Custom low-end feeder 0% $0 $0 $0 $0 $1,200 $1,200 $2,400 $1,200 $4,800 $8,400 $9,600 $12,000
Custom medium feeder 0% $0 $0 $0 $0 $0 $2,500 $2,500 $7,500 $2,500 $5,000 $10,000 $15,000
Custom high-end feeder 0% $0 $0 $0 $0 $0 $4,000 $8,000 $4,000 $4,000 $2,000 $16,000 $20,000
Total Sales $0 $0 $0 $0 $1,200 $7,700 $12,900 $12,700 $11,300 $15,400 $35,600 $47,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
Basic small feeder $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic medium feeder $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic large feeder $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic extra large feeder $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Custom low-end feeder $0 $0 $0 $0 $500 $500 $1,000 $500 $2,000 $3,500 $4,000 $5,000
Custom medium feeder $0 $0 $0 $0 $0 $600 $1,200 $1,800 $600 $1,200 $2,400 $3,600
Custom high-end feeder $0 $0 $0 $0 $0 $700 $1,400 $700 $700 $1,400 $2,800 $3,500
Subtotal Direct Cost of Sales $0 $0 $0 $0 $500 $1,800 $3,600 $3,000 $3,300 $6,100 $9,200 $12,100
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
TL McClendon 0% $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Part-time Sales Rep 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Inventory/Office Mgmt. 0% $0 $0 $0 $0 $0 $0 $0 $2,085 $2,085 $2,085 $2,085 $2,085
Total People 1 1 1 1 1 1 1 2 2 2 2 2
Total Payroll $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $4,485 $4,485 $4,485 $4,485 $4,485
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 $0 $0 $0 $0 $1,200 $7,700 $12,900 $12,700 $11,300 $15,400 $35,600 $47,000
Direct Cost of Sales $0 $0 $0 $0 $500 $1,800 $3,600 $3,000 $3,300 $6,100 $9,200 $12,100
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $500 $1,800 $3,600 $3,000 $3,300 $6,100 $9,200 $12,100
Gross Margin $0 $0 $0 $0 $700 $5,900 $9,300 $9,700 $8,000 $9,300 $26,400 $34,900
Gross Margin % 0.00% 0.00% 0.00% 0.00% 58.33% 76.62% 72.09% 76.38% 70.80% 60.39% 74.16% 74.26%
Expenses
Payroll $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $4,485 $4,485 $4,485 $4,485 $4,485
Sales and Marketing and Other Expenses $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Web site management $0 $0 $0 $0 $800 $800 $800 $800 $800 $800 $800 $800
Business travel 15% $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Miscellaneous $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Operating Expenses $5,437 $5,437 $5,437 $5,437 $6,237 $6,237 $6,237 $8,322 $8,322 $8,322 $8,322 $8,322
Profit Before Interest and Taxes ($5,437) ($5,437) ($5,437) ($5,437) ($5,537) ($337) $3,064 $1,379 ($322) $979 $18,079 $26,579
EBITDA ($5,437) ($5,437) ($5,437) ($5,437) ($5,537) ($337) $3,064 $1,379 ($322) $979 $18,079 $26,579
Interest Expense $410 $403 $396 $389 $382 $375 $368 $361 $354 $348 $341 $334
Taxes Incurred ($1,754) ($1,752) ($1,750) ($1,748) ($1,776) ($214) $809 $305 ($203) $189 $5,321 $7,873
Net Profit ($4,092) ($4,088) ($4,083) ($4,078) ($4,143) ($498) $1,887 $712 ($473) $442 $12,417 $18,371
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% -345.25% -6.47% 14.63% 5.61% -4.19% 2.87% 34.88% 39.09%
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 $300 $1,925 $3,225 $3,175 $2,825 $3,850 $8,900 $11,750
Cash from Receivables $0 $0 $0 $0 $0 $30 $1,063 $5,905 $9,670 $9,490 $8,578 $12,055
Subtotal Cash from Operations $0 $0 $0 $0 $300 $1,955 $4,288 $9,080 $12,495 $13,340 $17,478 $23,805
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 $50,000 $0 $0 $0 $25,000 $0 $0 $0
Subtotal Cash Received $0 $0 $0 $0 $50,300 $1,955 $4,288 $9,080 $37,495 $13,340 $17,478 $23,805
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 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $4,485 $4,485 $4,485 $4,485 $4,485
Bill Payments $56 $1,692 $1,687 $1,683 $1,803 $5,495 $7,032 $7,996 $7,486 $7,201 $13,674 $22,283
Subtotal Spent on Operations $2,456 $4,092 $4,087 $4,083 $4,203 $7,895 $9,432 $12,481 $11,971 $11,686 $18,159 $26,768
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 $830 $830 $830 $830 $830 $830 $830 $830 $830 $830 $830 $830
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 $3,286 $4,922 $4,917 $4,913 $5,033 $8,725 $10,262 $13,311 $12,801 $12,516 $18,989 $27,598
Net Cash Flow ($3,286) ($4,922) ($4,917) ($4,913) $45,267 ($6,770) ($5,975) ($4,231) $24,694 $824 ($1,512) ($3,793)
Cash Balance $36,714 $31,791 $26,874 $21,961 $67,228 $60,458 $54,484 $50,252 $74,947 $75,770 $74,259 $70,466
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 $40,000 $36,714 $31,791 $26,874 $21,961 $67,228 $60,458 $54,484 $50,252 $74,947 $75,770 $74,259 $70,466
Accounts Receivable $0 $0 $0 $0 $0 $900 $6,645 $15,258 $18,878 $17,683 $19,743 $37,865 $61,060
Inventory $1,000 $1,000 $1,000 $1,000 $1,000 $3,500 $4,700 $4,100 $4,100 $3,800 $6,710 $10,120 $13,310
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $41,000 $37,714 $32,791 $27,874 $22,961 $71,628 $71,803 $73,841 $73,230 $96,429 $102,223 $122,244 $144,836
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 $41,000 $37,714 $32,791 $27,874 $22,961 $71,628 $71,803 $73,841 $73,230 $96,429 $102,223 $122,244 $144,836
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 $1,636 $1,631 $1,627 $1,622 $5,262 $6,765 $7,746 $7,253 $6,755 $12,937 $21,372 $26,422
Current Borrowing $50,000 $49,170 $48,340 $47,510 $46,680 $45,850 $45,020 $44,190 $43,360 $42,530 $41,700 $40,870 $40,040
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $50,000 $50,806 $49,971 $49,137 $48,302 $51,112 $51,785 $51,936 $50,613 $49,285 $54,637 $62,242 $66,462
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $50,000 $50,806 $49,971 $49,137 $48,302 $51,112 $51,785 $51,936 $50,613 $49,285 $54,637 $62,242 $66,462
Paid-in Capital $22,200 $22,200 $22,200 $22,200 $22,200 $72,200 $72,200 $72,200 $72,200 $97,200 $97,200 $97,200 $97,200
Retained Earnings ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200) ($31,200)
Earnings $0 ($4,092) ($8,180) ($12,263) ($16,340) ($20,483) ($20,982) ($19,095) ($18,383) ($18,856) ($18,414) ($5,998) $12,374
Total Capital ($9,000) ($13,092) ($17,180) ($21,263) ($25,340) $20,517 $20,018 $21,905 $22,617 $47,144 $47,586 $60,002 $78,374
Total Liabilities and Capital $41,000 $37,714 $32,791 $27,874 $22,961 $71,628 $71,803 $73,841 $73,230 $96,429 $102,223 $122,244 $144,836
Net Worth ($9,000) ($13,092) ($17,180) ($21,263) ($25,340) $20,517 $20,018 $21,905 $22,617 $47,144 $47,586 $60,002 $78,374