Wilson Family Peach Farm

Start your own business plan »

Peach and Apricot Farm 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
Peaches 0% $40,000 $55,000 $65,000 $73,000 $42,000 $24,000 $0 $0 $0 $0 $0 $0
Nectarines 0% $5,000 $10,000 $10,000 $12,000 $5,000 $0 $0 $0 $0 $0 $0 $0
Total Sales $45,000 $65,000 $75,000 $85,000 $47,000 $24,000 $0 $0 $0 $0 $0 $0
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
Peaches $12,000 $16,500 $19,500 $21,900 $12,600 $7,200 $0 $0 $0 $0 $0 $0
Nectarines $1,500 $3,000 $3,000 $3,600 $1,500 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $13,500 $19,500 $22,500 $25,500 $14,100 $7,200 $0 $0 $0 $0 $0 $0
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
Payroll 0% $0 $0 $500 $1,500 $3,000 $3,000 $3,000 $2,000 $1,000 $0 $0 $0
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $0 $0 $500 $1,500 $3,000 $3,000 $3,000 $2,000 $1,000 $0 $0 $0
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 $45,000 $65,000 $75,000 $85,000 $47,000 $24,000 $0 $0 $0 $0 $0 $0
Direct Cost of Sales $13,500 $19,500 $22,500 $25,500 $14,100 $7,200 $0 $0 $0 $0 $0 $0
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $13,500 $19,500 $22,500 $25,500 $14,100 $7,200 $0 $0 $0 $0 $0 $0
Gross Margin $31,500 $45,500 $52,500 $59,500 $32,900 $16,800 $0 $0 $0 $0 $0 $0
Gross Margin % 70.00% 70.00% 70.00% 70.00% 70.00% 70.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Expenses
Payroll $0 $0 $500 $1,500 $3,000 $3,000 $3,000 $2,000 $1,000 $0 $0 $0
Sales and Marketing and Other Expenses $2,750 $2,700 $2,775 $2,800 $2,800 $3,400 $2,900 $2,900 $3,400 $3,400 $3,400 $3,400
Depreciation $200 $200 $200 $200 $200 $200 $200 $200 $400 $400 $400 $400
Leased Equipment $0 $0 $0 $2,000 $2,000 $2,000 $1,000 $1,000 $0 $0 $0 $0
Utilities $200 $200 $200 $200 $200 $400 $400 $400 $600 $600 $600 $600
Insurance $600 $600 $600 $600 $600 $1,200 $1,200 $1,200 $1,800 $1,800 $1,800 $1,800
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 15% $0 $0 $75 $225 $450 $450 $450 $300 $150 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $5,750 $5,700 $6,350 $9,525 $11,250 $12,650 $11,150 $10,000 $9,350 $8,200 $8,200 $8,200
Profit Before Interest and Taxes $25,750 $39,800 $46,150 $49,975 $21,650 $4,150 ($11,150) ($10,000) ($9,350) ($8,200) ($8,200) ($8,200)
EBITDA $25,950 $40,000 $46,350 $50,175 $21,850 $4,350 ($10,950) ($9,800) ($8,950) ($7,800) ($7,800) ($7,800)
Interest Expense $1,023 $1,004 $985 $967 $948 $929 $910 $892 $873 $854 $835 $817
Taxes Incurred $7,418 $11,639 $13,549 $14,703 $6,211 $966 ($3,618) ($3,267) ($3,067) ($2,716) ($2,711) ($2,705)
Net Profit $17,309 $27,157 $31,615 $34,306 $14,491 $2,255 ($8,442) ($7,624) ($7,156) ($6,338) ($6,325) ($6,312)
Net Profit/Sales 38.46% 41.78% 42.15% 40.36% 30.83% 9.39% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
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 $6,750 $9,750 $11,250 $12,750 $7,050 $3,600 $0 $0 $0 $0 $0 $0
Cash from Receivables $0 $1,275 $38,817 $55,533 $64,033 $71,173 $39,298 $19,720 $0 $0 $0 $0
Subtotal Cash from Operations $6,750 $11,025 $50,067 $68,283 $71,083 $74,773 $39,298 $19,720 $0 $0 $0 $0
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 $20,000 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $6,750 $11,025 $50,067 $88,283 $71,083 $74,773 $39,298 $19,720 $0 $0 $0 $0
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 $0 $0 $500 $1,500 $3,000 $3,000 $3,000 $2,000 $1,000 $0 $0 $0
Bill Payments $1,411 $42,404 $44,301 $46,195 $51,110 $16,588 $11,142 $5,248 $5,435 $5,762 $5,937 $5,924
Subtotal Spent on Operations $1,411 $42,404 $44,801 $47,695 $54,110 $19,588 $14,142 $7,248 $6,435 $5,762 $5,937 $5,924
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,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250 $1,250
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $5,661 $46,654 $49,051 $51,945 $58,360 $23,838 $18,392 $11,498 $10,685 $10,012 $10,187 $10,174
Net Cash Flow $1,089 ($35,629) $1,016 $36,338 $12,723 $50,936 $20,906 $8,222 ($10,685) ($10,012) ($10,187) ($10,174)
Cash Balance $128,809 $93,179 $94,195 $130,533 $143,256 $194,192 $215,098 $223,320 $212,635 $202,623 $192,435 $182,261
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 $127,720 $128,809 $93,179 $94,195 $130,533 $143,256 $194,192 $215,098 $223,320 $212,635 $202,623 $192,435 $182,261
Accounts Receivable $0 $38,250 $92,225 $117,158 $133,875 $109,792 $59,018 $19,720 $0 $0 $0 $0 $0
Inventory $0 $14,850 $21,450 $24,750 $28,050 $15,510 $8,310 $8,310 $8,310 $8,310 $8,310 $8,310 $8,310
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $127,720 $181,909 $206,854 $236,103 $292,458 $268,558 $261,520 $243,128 $231,630 $220,945 $210,933 $200,745 $190,571
Long-term Assets
Long-term Assets $140,280 $142,280 $144,280 $146,280 $148,280 $150,280 $152,280 $154,280 $156,280 $158,280 $160,280 $162,280 $164,280
Accumulated Depreciation $0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $2,000 $2,400 $2,800 $3,200
Total Long-term Assets $140,280 $142,080 $143,880 $145,680 $147,480 $149,280 $151,080 $152,880 $154,680 $156,280 $157,880 $159,480 $161,080
Total Assets $268,000 $323,989 $350,734 $381,783 $439,938 $417,838 $412,600 $396,008 $386,310 $377,225 $368,813 $360,225 $351,651
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 $40,930 $42,768 $44,452 $50,551 $16,210 $10,967 $5,068 $5,243 $5,564 $5,740 $5,727 $5,715
Current Borrowing $25,000 $24,000 $23,000 $22,000 $21,000 $20,000 $19,000 $18,000 $17,000 $16,000 $15,000 $14,000 $13,000
Other Current Liabilities $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Subtotal Current Liabilities $50,000 $89,930 $90,768 $91,452 $96,551 $61,210 $54,967 $48,068 $47,243 $46,564 $45,740 $44,727 $43,715
Long-term Liabilities $100,000 $98,750 $97,500 $96,250 $95,000 $93,750 $92,500 $91,250 $90,000 $88,750 $87,500 $86,250 $85,000
Total Liabilities $150,000 $188,680 $188,268 $187,702 $191,551 $154,960 $147,467 $139,318 $137,243 $135,314 $133,240 $130,977 $128,715
Paid-in Capital $175,000 $175,000 $175,000 $175,000 $195,000 $195,000 $195,000 $195,000 $195,000 $195,000 $195,000 $195,000 $195,000
Retained Earnings ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000) ($57,000)
Earnings $0 $17,309 $44,466 $76,081 $110,387 $124,879 $127,133 $118,691 $111,067 $103,911 $97,573 $91,248 $84,936
Total Capital $118,000 $135,309 $162,466 $194,081 $248,387 $262,879 $265,133 $256,691 $249,067 $241,911 $235,573 $229,248 $222,936
Total Liabilities and Capital $268,000 $323,989 $350,734 $381,783 $439,938 $417,838 $412,600 $396,008 $386,310 $377,225 $368,813 $360,225 $351,651
Net Worth $118,000 $135,309 $162,466 $194,081 $248,387 $262,879 $265,133 $256,691 $249,067 $241,911 $235,573 $229,248 $222,936