Latheethen Feeds
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 | |