Oasis Juice

Start your own business plan »

Wholesale Juice Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Products 0% $60,000 $60,000 $70,000 $80,000 $80,000 $90,000 $90,000 $90,000 $100,000 $100,000 $100,000 $100,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $60,000 $60,000 $70,000 $80,000 $80,000 $90,000 $90,000 $90,000 $100,000 $100,000 $100,000 $100,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Products $13,000 $13,000 $17,000 $20,000 $20,000 $25,000 $25,000 $25,000 $30,000 $30,000 $30,000 $30,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $13,000 $13,000 $17,000 $20,000 $20,000 $25,000 $25,000 $25,000 $30,000 $30,000 $30,000 $30,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Tama Gardner 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
William Harris 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Production Staff 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Distribution Staff 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Sales Staff 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Total People 13 13 13 13 13 13 13 13 13 13 13 13
Total Payroll $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $60,000 $60,000 $70,000 $80,000 $80,000 $90,000 $90,000 $90,000 $100,000 $100,000 $100,000 $100,000
Direct Cost of Sales $13,000 $13,000 $17,000 $20,000 $20,000 $25,000 $25,000 $25,000 $30,000 $30,000 $30,000 $30,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $13,000 $13,000 $17,000 $20,000 $20,000 $25,000 $25,000 $25,000 $30,000 $30,000 $30,000 $30,000
Gross Margin $47,000 $47,000 $53,000 $60,000 $60,000 $65,000 $65,000 $65,000 $70,000 $70,000 $70,000 $70,000
Gross Margin % 78.33% 78.33% 75.71% 75.00% 75.00% 72.22% 72.22% 72.22% 70.00% 70.00% 70.00% 70.00%
Expenses
Payroll $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Sales and Marketing and Other Expenses $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Depreciation $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Insurance $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
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% $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800 $4,800
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $48,400 $48,400 $48,400 $48,400 $48,400 $48,400 $48,400 $48,400 $48,400 $48,400 $48,400 $48,400
Profit Before Interest and Taxes ($1,400) ($1,400) $4,600 $11,600 $11,600 $16,600 $16,600 $16,600 $21,600 $21,600 $21,600 $21,600
EBITDA ($600) ($600) $5,400 $12,400 $12,400 $17,400 $17,400 $17,400 $22,400 $22,400 $22,400 $22,400
Interest Expense $401 $469 $538 $606 $674 $742 $810 $878 $946 $1,014 $1,082 $1,151
Taxes Incurred ($540) ($561) $1,219 $3,298 $3,278 $4,757 $4,737 $4,717 $6,196 $6,176 $6,155 $6,135
Net Profit ($1,261) ($1,309) $2,844 $7,696 $7,648 $11,101 $11,053 $11,006 $14,458 $14,410 $14,363 $14,314
Net Profit/Sales -2.10% -2.18% 4.06% 9.62% 9.56% 12.33% 12.28% 12.23% 14.46% 14.41% 14.36% 14.31%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $15,000 $15,000 $17,500 $20,000 $20,000 $22,500 $22,500 $22,500 $25,000 $25,000 $25,000 $25,000
Cash from Receivables $40,000 $41,500 $45,000 $45,250 $52,750 $60,000 $60,250 $67,500 $67,500 $67,750 $75,000 $75,000
Subtotal Cash from Operations $55,000 $56,500 $62,500 $65,250 $72,750 $82,500 $82,750 $90,000 $92,500 $92,750 $100,000 $100,000
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 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,500
New Other Liabilities (interest-free) $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
New Long-term Liabilities $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
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 $69,333 $70,833 $76,833 $79,583 $87,083 $96,833 $97,083 $104,333 $106,833 $107,083 $114,333 $114,500
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Bill Payments $21,092 $32,619 $28,850 $38,891 $42,695 $39,953 $51,417 $46,148 $46,596 $58,060 $52,791 $52,839
Subtotal Spent on Operations $53,092 $64,619 $60,850 $70,891 $74,695 $71,953 $83,417 $78,148 $78,596 $90,060 $84,791 $84,839
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 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666 $1,666
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Purchase Other Current Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Purchase Long-term Assets $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $60,258 $71,785 $68,016 $78,057 $81,861 $79,119 $90,583 $85,314 $85,762 $97,226 $91,957 $92,005
Net Cash Flow $9,075 ($952) $8,817 $1,526 $5,222 $17,714 $6,500 $19,019 $21,071 $9,857 $22,376 $22,495
Cash Balance $49,075 $48,123 $56,940 $58,465 $63,687 $81,401 $87,900 $106,919 $127,990 $137,847 $160,222 $182,717
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $40,000 $49,075 $48,123 $56,940 $58,465 $63,687 $81,401 $87,900 $106,919 $127,990 $137,847 $160,222 $182,717
Accounts Receivable $80,000 $85,000 $88,500 $96,000 $110,750 $118,000 $125,500 $132,750 $132,750 $140,250 $147,500 $147,500 $147,500
Inventory $10,000 $14,300 $14,300 $18,700 $22,000 $22,000 $27,500 $27,500 $27,500 $33,000 $33,000 $33,000 $33,000
Other Current Assets $5,000 $7,000 $9,000 $11,000 $13,000 $15,000 $17,000 $19,000 $21,000 $23,000 $25,000 $27,000 $29,000
Total Current Assets $135,000 $155,375 $159,923 $182,640 $204,215 $218,687 $251,401 $267,150 $288,169 $324,240 $343,347 $367,722 $392,217
Long-term Assets
Long-term Assets $50,000 $52,000 $54,000 $56,000 $58,000 $60,000 $62,000 $64,000 $66,000 $68,000 $70,000 $72,000 $74,000
Accumulated Depreciation $12,000 $12,800 $13,600 $14,400 $15,200 $16,000 $16,800 $17,600 $18,400 $19,200 $20,000 $20,800 $21,600
Total Long-term Assets $38,000 $39,200 $40,400 $41,600 $42,800 $44,000 $45,200 $46,400 $47,600 $48,800 $50,000 $51,200 $52,400
Total Assets $173,000 $194,575 $200,323 $224,240 $247,015 $262,687 $296,601 $313,550 $335,769 $373,040 $393,347 $418,922 $444,617
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $20,000 $31,669 $27,558 $37,464 $41,377 $38,233 $49,879 $44,609 $44,655 $56,301 $51,030 $51,076 $51,123
Current Borrowing $0 $6,667 $13,334 $20,001 $26,668 $33,335 $40,002 $46,669 $53,336 $60,003 $66,670 $73,337 $80,171
Other Current Liabilities $0 $3,000 $6,000 $9,000 $12,000 $15,000 $18,000 $21,000 $24,000 $27,000 $30,000 $33,000 $36,000
Subtotal Current Liabilities $20,000 $41,336 $46,892 $66,465 $80,045 $86,568 $107,881 $112,278 $121,991 $143,304 $147,700 $157,413 $167,294
Long-term Liabilities $40,000 $41,500 $43,000 $44,500 $46,000 $47,500 $49,000 $50,500 $52,000 $53,500 $55,000 $56,500 $58,000
Total Liabilities $60,000 $82,836 $89,892 $110,965 $126,045 $134,068 $156,881 $162,778 $173,991 $196,804 $202,700 $213,913 $225,294
Paid-in Capital $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Retained Earnings $9,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000 $33,000
Earnings $24,000 ($1,261) ($2,570) $274 $7,970 $15,619 $26,720 $37,773 $48,778 $63,236 $77,646 $92,009 $106,323
Total Capital $113,000 $111,739 $110,430 $113,274 $120,970 $128,619 $139,720 $150,773 $161,778 $176,236 $190,646 $205,009 $219,323
Total Liabilities and Capital $173,000 $194,575 $200,323 $224,240 $247,015 $262,687 $296,601 $313,550 $335,769 $373,040 $393,347 $418,922 $444,617
Net Worth $113,000 $111,739 $110,430 $113,274 $120,970 $128,619 $139,720 $150,773 $161,778 $176,236 $190,646 $205,009 $219,323