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