Latheethen Feeds

Start your own business plan »

Feed and Farm Supply Business Plan

Appendix

Sales Forecast
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Sales
Equine Feed $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170
Deer Feed $2,800 $2,800 $100 $100 $100 $100 $100 $100 $100 $100 $2,800 $2,800
Livestock Feed $7,200 $8,900 $6,400 $6,300 $6,600 $7,200 $8,654 $8,200 $7,900 $8,600 $9,300 $8,092
Misc. Products & Supplies $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Boarding Stable $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $13,670 $15,370 $10,170 $10,070 $10,370 $10,970 $12,424 $11,970 $11,670 $12,370 $15,770 $14,562
Direct Cost of Sales Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Corn, Oats, Molasses, Other Ingredients $5,600 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $4,000 $5,600
Misc. Products & Supplies $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Boarding Stable $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Bags, Ties, Pallets, Labels $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
Subtotal Direct Cost of Sales $5,970 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370 $5,970
Personnel Plan
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Dennis 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Kay 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Extra Mill Operator 0% $0 $0 $0 $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Extra Store Help 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
General Assumptions
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.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
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Sales $13,670 $15,370 $10,170 $10,070 $10,370 $10,970 $12,424 $11,970 $11,670 $12,370 $15,770 $14,562
Direct Cost of Sales $5,970 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370 $5,970
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $5,970 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370 $5,970
Gross Margin $7,700 $12,200 $7,000 $6,900 $7,200 $7,800 $9,254 $8,800 $8,500 $9,200 $11,400 $8,592
Gross Margin % 56.33% 79.38% 68.83% 68.52% 69.43% 71.10% 74.48% 73.52% 72.84% 74.37% 72.29% 59.00%
Expenses
Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Advertising & Marketing $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $10
Depreciation $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Fuel $629 $672 $542 $539 $547 $562 $598 $587 $579 $597 $682 $652
Maintenance of Delivery Truck $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Utilities $256 $256 $256 $256 $256 $256 $256 $256 $256 $256 $256 $256
Insurance $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Postage $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15 $15
Bank Charges $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20 $20
Stable Renovation Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accounting & Legal $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Feed Dealers Permit $0 $0 $15 $0 $0 $0 $0 $0 $0 $0 $0 $0
Website Development $500 $500 $500 $0 $0 $0 $0 $0 $0 $0 $0 $0
Website hosting $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Online Payment Account Mgmt 15% $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30
Sales Tax License $0 $0 $25 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $5,375 $5,418 $5,328 $4,785 $4,793 $5,808 $5,844 $5,833 $5,825 $5,843 $5,928 $5,808
Profit Before Interest and Taxes $2,325 $6,782 $1,672 $2,115 $2,407 $1,992 $3,410 $2,967 $2,675 $3,357 $5,472 $2,784
EBITDA $2,575 $7,032 $1,922 $2,365 $2,657 $2,242 $3,660 $3,217 $2,925 $3,607 $5,722 $3,034
Interest Expense $88 $83 $78 $73 $68 $63 $58 $53 $49 $44 $39 $34
Taxes Incurred $671 $2,010 $478 $613 $702 $579 $1,005 $874 $788 $994 $1,630 $825
Net Profit $1,566 $4,690 $1,116 $1,429 $1,637 $1,350 $2,346 $2,040 $1,838 $2,319 $3,803 $1,925
Net Profit/Sales 11.46% 30.51% 10.97% 14.19% 15.79% 12.31% 18.88% 17.04% 15.75% 18.75% 24.12% 13.22%
Pro Forma Cash Flow
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Cash Received
Cash from Operations
Cash Sales $13,670 $15,370 $10,170 $10,070 $10,370 $10,970 $12,424 $11,970 $11,670 $12,370 $15,770 $14,562
Subtotal Cash from Operations $13,670 $15,370 $10,170 $10,070 $10,370 $10,970 $12,424 $11,970 $11,670 $12,370 $15,770 $14,562
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 $15,000 $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 $28,670 $15,370 $10,170 $10,070 $10,370 $10,970 $12,424 $11,970 $11,670 $12,370 $15,770 $14,562
Expenditures Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Expenditures from Operations
Cash Spending $2,000 $2,000 $2,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Bill Payments $231 $6,881 $5,791 $6,664 $6,394 $6,479 $6,385 $6,823 $6,677 $6,589 $6,904 $9,952
Subtotal Spent on Operations $2,231 $8,881 $7,791 $8,664 $8,394 $9,479 $9,385 $9,823 $9,677 $9,589 $9,904 $12,952
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 $833 $833 $833 $833 $833 $833 $833 $834 $834 $834 $834
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 $15,000 $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 $17,231 $9,714 $8,624 $9,497 $9,227 $10,312 $10,218 $10,656 $10,511 $10,423 $10,738 $13,786
Net Cash Flow $11,439 $5,656 $1,546 $573 $1,143 $658 $2,206 $1,314 $1,159 $1,947 $5,032 $776
Cash Balance $11,966 $17,622 $19,168 $19,741 $20,884 $21,542 $23,748 $25,062 $26,221 $28,168 $33,200 $33,976
Pro Forma Balance Sheet
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Assets Starting Balances
Current Assets
Cash $527 $11,966 $17,622 $19,168 $19,741 $20,884 $21,542 $23,748 $25,062 $26,221 $28,168 $33,200 $33,976
Inventory $8,904 $5,970 $3,300 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370 $5,970
Other Current Assets $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463 $75,463
Total Current Assets $84,894 $93,399 $96,385 $97,801 $98,374 $99,517 $100,175 $102,381 $103,695 $104,854 $106,801 $113,033 $115,409
Long-term Assets
Long-term Assets $170,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000 $185,000
Accumulated Depreciation $39,089 $39,339 $39,589 $39,839 $40,089 $40,339 $40,589 $40,839 $41,089 $41,339 $41,589 $41,839 $42,089
Total Long-term Assets $130,911 $145,661 $145,411 $145,161 $144,911 $144,661 $144,411 $144,161 $143,911 $143,661 $143,411 $143,161 $142,911
Total Assets $215,805 $239,060 $241,796 $242,962 $243,285 $244,178 $244,586 $246,542 $247,606 $248,515 $250,212 $256,194 $258,320
Liabilities and Capital Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Current Liabilities
Accounts Payable $0 $6,689 $5,568 $6,451 $6,178 $6,266 $6,157 $6,600 $6,458 $6,362 $6,574 $9,586 $10,620
Current Borrowing $0 $15,000 $14,167 $13,334 $12,501 $11,668 $10,835 $10,002 $9,169 $8,335 $7,501 $6,667 $5,833
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $21,689 $19,735 $19,785 $18,679 $17,934 $16,992 $16,602 $15,627 $14,697 $14,075 $16,253 $16,453
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $21,689 $19,735 $19,785 $18,679 $17,934 $16,992 $16,602 $15,627 $14,697 $14,075 $16,253 $16,453
Paid-in Capital $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Retained Earnings $205,465 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805 $214,805
Earnings $9,340 $1,566 $6,256 $7,372 $8,801 $10,439 $11,789 $14,135 $16,175 $18,013 $20,332 $24,136 $26,061
Total Capital $215,805 $217,371 $222,061 $223,177 $224,606 $226,244 $227,594 $229,940 $231,980 $233,818 $236,137 $239,941 $241,866
Total Liabilities and Capital $215,805 $239,060 $241,796 $242,962 $243,285 $244,178 $244,586 $246,542 $247,606 $248,515 $250,212 $256,194 $258,320
Net Worth $215,805 $217,371 $222,061 $223,177 $224,606 $226,244 $227,594 $229,940 $231,980 $233,818 $236,137 $239,941 $241,866
Inventory Detail
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct
Months of Inventory On-hand 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Minimum Inventory Purchase $500
Inventory Balance
Beginning Inventory Balance $8,904 $5,970 $3,300 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370
Less Inventory Used as COGS $5,970 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370 $5,970
Plus Inventory Purchase $3,036 $500 $3,040 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $5,570 $7,570
Ending Inventory Balance $5,970 $3,300 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $3,170 $4,370 $5,970