| 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 | |||||||||||||
| Smart Soil, Hare Away, Rose Food, | 0% | £13,350 | £13,350 | £10,000 | £7,500 | £7,500 | £7,500 | £8,500 | £11,500 | £18,000 | £20,000 | £25,000 | £18,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £13,350 | £13,350 | £10,000 | £7,500 | £7,500 | £7,500 | £8,500 | £11,500 | £18,000 | £20,000 | £25,000 | £18,000 | |
| 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 | |
| Smart Soil, Hare Away, Rose Food, | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| 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 | ||
| Office Manager | 0% | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 |
| Justin Luber | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Jason Mysliwec | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Hunter Korth | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Robin Liu | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | |
| 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 | £13,350 | £13,350 | £10,000 | £7,500 | £7,500 | £7,500 | £8,500 | £11,500 | £18,000 | £20,000 | £25,000 | £18,000 | |
| Direct Cost of Sales | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| Gross Margin | £7,621 | £7,621 | £5,709 | £4,281 | £4,281 | £4,281 | £4,852 | £6,565 | £10,276 | £11,417 | £14,272 | £10,276 | |
| Gross Margin % | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | |
| Expenses | |||||||||||||
| Payroll | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | |
| Advertising/Promotion | £2,401 | £2,401 | £1,800 | £1,225 | £1,225 | £1,225 | £1,755 | £2,345 | £3,540 | £3,600 | £4,750 | £2,540 | |
| Depreciation | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Payroll Burden | 15% | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 |
| Miscellaneous | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Total Operating Expenses | £11,310 | £11,310 | £10,710 | £10,135 | £10,135 | £10,135 | £10,665 | £11,255 | £12,450 | £12,510 | £13,660 | £11,450 | |
| Profit Before Interest and Taxes | (£3,689) | (£3,689) | (£5,001) | (£5,853) | (£5,853) | (£5,853) | (£5,812) | (£4,690) | (£2,174) | (£1,092) | £612 | (£1,174) | |
| EBITDA | (£3,597) | (£3,597) | (£4,909) | (£5,761) | (£5,761) | (£5,761) | (£5,720) | (£4,598) | (£2,082) | (£1,000) | £704 | (£1,082) | |
| Interest Expense | £397 | £393 | £390 | £387 | £383 | £380 | £377 | £373 | £370 | £367 | £363 | £360 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,086) | (£4,082) | (£5,391) | (£6,240) | (£6,236) | (£6,233) | (£6,189) | (£5,063) | (£2,544) | (£1,459) | £249 | (£1,534) | |
| Net Profit/Sales | -30.60% | -30.58% | -53.91% | -83.20% | -83.15% | -83.11% | -72.81% | -44.03% | -14.13% | -7.29% | 0.99% | -8.52% | |
| 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,675 | £6,675 | £5,000 | £3,750 | £3,750 | £3,750 | £4,250 | £5,750 | £9,000 | £10,000 | £12,500 | £9,000 | |
| Cash from Receivables | £0 | £223 | £6,675 | £6,619 | £4,958 | £3,750 | £3,750 | £3,767 | £4,300 | £5,858 | £9,033 | £10,083 | |
| Subtotal Cash from Operations | £6,675 | £6,898 | £11,675 | £10,369 | £8,708 | £7,500 | £8,000 | £9,517 | £13,300 | £15,858 | £21,533 | £19,083 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £6,675 | £6,898 | £11,675 | £10,369 | £8,708 | £7,500 | £8,000 | £9,517 | £13,300 | £15,858 | £21,533 | £19,083 | |
| 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 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | |
| Bill Payments | £376 | £11,247 | £10,570 | £7,026 | £5,857 | £6,994 | £7,039 | £8,513 | £11,425 | £16,830 | £15,818 | £20,007 | |
| Subtotal Spent on Operations | £7,026 | £17,897 | £17,220 | £13,676 | £12,507 | £13,644 | £13,689 | £15,163 | £18,075 | £23,480 | £22,468 | £26,657 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £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 | £7,526 | £18,397 | £17,720 | £14,176 | £13,007 | £14,144 | £14,189 | £15,663 | £18,575 | £23,980 | £22,968 | £27,157 | |
| Net Cash Flow | (£851) | (£11,500) | (£6,045) | (£3,807) | (£4,298) | (£6,644) | (£6,189) | (£6,146) | (£5,275) | (£8,122) | (£1,435) | (£8,073) | |
| Cash Balance | £75,770 | £64,271 | £58,226 | £54,419 | £50,121 | £43,477 | £37,288 | £31,142 | £25,867 | £17,745 | £16,311 | £8,237 | |
| 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 | £76,621 | £75,770 | £64,271 | £58,226 | £54,419 | £50,121 | £43,477 | £37,288 | £31,142 | £25,867 | £17,745 | £16,311 | £8,237 |
| Accounts Receivable | £0 | £6,675 | £13,128 | £11,453 | £8,583 | £7,375 | £7,375 | £7,875 | £9,858 | £14,558 | £18,700 | £22,167 | £21,083 |
| Inventory | £5,729 | £6,302 | £6,302 | £4,721 | £3,540 | £3,540 | £3,540 | £4,012 | £5,429 | £8,497 | £9,441 | £11,801 | £8,497 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £82,350 | £88,747 | £83,700 | £74,399 | £66,543 | £61,036 | £54,392 | £49,175 | £46,429 | £48,922 | £45,886 | £50,279 | £37,817 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 |
| Accumulated Depreciation | £0 | £92 | £184 | £276 | £368 | £460 | £552 | £644 | £736 | £828 | £920 | £1,012 | £1,104 |
| Total Long-term Assets | £9,100 | £9,008 | £8,916 | £8,824 | £8,732 | £8,640 | £8,548 | £8,456 | £8,364 | £8,272 | £8,180 | £8,088 | £7,996 |
| Total Assets | £91,450 | £97,755 | £92,616 | £83,223 | £75,275 | £69,676 | £62,940 | £57,631 | £54,793 | £57,194 | £54,066 | £58,367 | £45,813 |
| 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 | £10,891 | £10,334 | £6,832 | £5,624 | £6,761 | £6,758 | £8,138 | £10,863 | £16,308 | £15,139 | £19,691 | £9,171 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £10,891 | £10,334 | £6,832 | £5,624 | £6,761 | £6,758 | £8,138 | £10,863 | £16,308 | £15,139 | £19,691 | £9,171 |
| Long-term Liabilities | £60,000 | £59,500 | £59,000 | £58,500 | £58,000 | £57,500 | £57,000 | £56,500 | £56,000 | £55,500 | £55,000 | £54,500 | £54,000 |
| Total Liabilities | £60,000 | £70,391 | £69,334 | £65,332 | £63,624 | £64,261 | £63,758 | £64,638 | £66,863 | £71,808 | £70,139 | £74,191 | £63,171 |
| Paid-in Capital | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 |
| Retained Earnings | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) |
| Earnings | £0 | (£4,086) | (£8,168) | (£13,559) | (£19,799) | (£26,035) | (£32,268) | (£38,457) | (£43,520) | (£46,064) | (£47,523) | (£47,274) | (£48,808) |
| Total Capital | £31,450 | £27,364 | £23,282 | £17,891 | £11,651 | £5,415 | (£818) | (£7,007) | (£12,070) | (£14,614) | (£16,073) | (£15,824) | (£17,358) |
| Total Liabilities and Capital | £91,450 | £97,755 | £92,616 | £83,223 | £75,275 | £69,676 | £62,940 | £57,631 | £54,793 | £57,194 | £54,066 | £58,367 | £45,813 |
| Net Worth | £31,450 | £27,364 | £23,282 | £17,891 | £11,651 | £5,415 | (£818) | (£7,007) | (£12,070) | (£14,614) | (£16,073) | (£15,824) | (£17,358) |
| 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 | |||||||||||||
| Smart Soil, Hare Away, Rose Food, | 0% | £13,350 | £13,350 | £10,000 | £7,500 | £7,500 | £7,500 | £8,500 | £11,500 | £18,000 | £20,000 | £25,000 | £18,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £13,350 | £13,350 | £10,000 | £7,500 | £7,500 | £7,500 | £8,500 | £11,500 | £18,000 | £20,000 | £25,000 | £18,000 | |
| 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 | |
| Smart Soil, Hare Away, Rose Food, | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| 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 | ||
| Office Manager | 0% | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 | £1,650 |
| Justin Luber | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Jason Mysliwec | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Hunter Korth | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Robin Liu | 0% | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 | £1,250 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | |
| 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 | £13,350 | £13,350 | £10,000 | £7,500 | £7,500 | £7,500 | £8,500 | £11,500 | £18,000 | £20,000 | £25,000 | £18,000 | |
| Direct Cost of Sales | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £5,729 | £5,729 | £4,291 | £3,219 | £3,219 | £3,219 | £3,648 | £4,935 | £7,724 | £8,583 | £10,728 | £7,724 | |
| Gross Margin | £7,621 | £7,621 | £5,709 | £4,281 | £4,281 | £4,281 | £4,852 | £6,565 | £10,276 | £11,417 | £14,272 | £10,276 | |
| Gross Margin % | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | 57.09% | |
| Expenses | |||||||||||||
| Payroll | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | |
| Advertising/Promotion | £2,401 | £2,401 | £1,800 | £1,225 | £1,225 | £1,225 | £1,755 | £2,345 | £3,540 | £3,600 | £4,750 | £2,540 | |
| Depreciation | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | £92 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Payroll Burden | 15% | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 | £998 |
| Miscellaneous | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | £170 | |
| Total Operating Expenses | £11,310 | £11,310 | £10,710 | £10,135 | £10,135 | £10,135 | £10,665 | £11,255 | £12,450 | £12,510 | £13,660 | £11,450 | |
| Profit Before Interest and Taxes | (£3,689) | (£3,689) | (£5,001) | (£5,853) | (£5,853) | (£5,853) | (£5,812) | (£4,690) | (£2,174) | (£1,092) | £612 | (£1,174) | |
| EBITDA | (£3,597) | (£3,597) | (£4,909) | (£5,761) | (£5,761) | (£5,761) | (£5,720) | (£4,598) | (£2,082) | (£1,000) | £704 | (£1,082) | |
| Interest Expense | £397 | £393 | £390 | £387 | £383 | £380 | £377 | £373 | £370 | £367 | £363 | £360 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£4,086) | (£4,082) | (£5,391) | (£6,240) | (£6,236) | (£6,233) | (£6,189) | (£5,063) | (£2,544) | (£1,459) | £249 | (£1,534) | |
| Net Profit/Sales | -30.60% | -30.58% | -53.91% | -83.20% | -83.15% | -83.11% | -72.81% | -44.03% | -14.13% | -7.29% | 0.99% | -8.52% | |
| 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,675 | £6,675 | £5,000 | £3,750 | £3,750 | £3,750 | £4,250 | £5,750 | £9,000 | £10,000 | £12,500 | £9,000 | |
| Cash from Receivables | £0 | £223 | £6,675 | £6,619 | £4,958 | £3,750 | £3,750 | £3,767 | £4,300 | £5,858 | £9,033 | £10,083 | |
| Subtotal Cash from Operations | £6,675 | £6,898 | £11,675 | £10,369 | £8,708 | £7,500 | £8,000 | £9,517 | £13,300 | £15,858 | £21,533 | £19,083 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £6,675 | £6,898 | £11,675 | £10,369 | £8,708 | £7,500 | £8,000 | £9,517 | £13,300 | £15,858 | £21,533 | £19,083 | |
| 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 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | £6,650 | |
| Bill Payments | £376 | £11,247 | £10,570 | £7,026 | £5,857 | £6,994 | £7,039 | £8,513 | £11,425 | £16,830 | £15,818 | £20,007 | |
| Subtotal Spent on Operations | £7,026 | £17,897 | £17,220 | £13,676 | £12,507 | £13,644 | £13,689 | £15,163 | £18,075 | £23,480 | £22,468 | £26,657 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Long-term Liabilities Principal Repayment | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Purchase Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Long-term Assets | £0 | £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 | £7,526 | £18,397 | £17,720 | £14,176 | £13,007 | £14,144 | £14,189 | £15,663 | £18,575 | £23,980 | £22,968 | £27,157 | |
| Net Cash Flow | (£851) | (£11,500) | (£6,045) | (£3,807) | (£4,298) | (£6,644) | (£6,189) | (£6,146) | (£5,275) | (£8,122) | (£1,435) | (£8,073) | |
| Cash Balance | £75,770 | £64,271 | £58,226 | £54,419 | £50,121 | £43,477 | £37,288 | £31,142 | £25,867 | £17,745 | £16,311 | £8,237 | |
| 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 | £76,621 | £75,770 | £64,271 | £58,226 | £54,419 | £50,121 | £43,477 | £37,288 | £31,142 | £25,867 | £17,745 | £16,311 | £8,237 |
| Accounts Receivable | £0 | £6,675 | £13,128 | £11,453 | £8,583 | £7,375 | £7,375 | £7,875 | £9,858 | £14,558 | £18,700 | £22,167 | £21,083 |
| Inventory | £5,729 | £6,302 | £6,302 | £4,721 | £3,540 | £3,540 | £3,540 | £4,012 | £5,429 | £8,497 | £9,441 | £11,801 | £8,497 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £82,350 | £88,747 | £83,700 | £74,399 | £66,543 | £61,036 | £54,392 | £49,175 | £46,429 | £48,922 | £45,886 | £50,279 | £37,817 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 | £9,100 |
| Accumulated Depreciation | £0 | £92 | £184 | £276 | £368 | £460 | £552 | £644 | £736 | £828 | £920 | £1,012 | £1,104 |
| Total Long-term Assets | £9,100 | £9,008 | £8,916 | £8,824 | £8,732 | £8,640 | £8,548 | £8,456 | £8,364 | £8,272 | £8,180 | £8,088 | £7,996 |
| Total Assets | £91,450 | £97,755 | £92,616 | £83,223 | £75,275 | £69,676 | £62,940 | £57,631 | £54,793 | £57,194 | £54,066 | £58,367 | £45,813 |
| 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 | £10,891 | £10,334 | £6,832 | £5,624 | £6,761 | £6,758 | £8,138 | £10,863 | £16,308 | £15,139 | £19,691 | £9,171 |
| Current Borrowing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £0 | £10,891 | £10,334 | £6,832 | £5,624 | £6,761 | £6,758 | £8,138 | £10,863 | £16,308 | £15,139 | £19,691 | £9,171 |
| Long-term Liabilities | £60,000 | £59,500 | £59,000 | £58,500 | £58,000 | £57,500 | £57,000 | £56,500 | £56,000 | £55,500 | £55,000 | £54,500 | £54,000 |
| Total Liabilities | £60,000 | £70,391 | £69,334 | £65,332 | £63,624 | £64,261 | £63,758 | £64,638 | £66,863 | £71,808 | £70,139 | £74,191 | £63,171 |
| Paid-in Capital | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 | £34,000 |
| Retained Earnings | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) | (£2,550) |
| Earnings | £0 | (£4,086) | (£8,168) | (£13,559) | (£19,799) | (£26,035) | (£32,268) | (£38,457) | (£43,520) | (£46,064) | (£47,523) | (£47,274) | (£48,808) |
| Total Capital | £31,450 | £27,364 | £23,282 | £17,891 | £11,651 | £5,415 | (£818) | (£7,007) | (£12,070) | (£14,614) | (£16,073) | (£15,824) | (£17,358) |
| Total Liabilities and Capital | £91,450 | £97,755 | £92,616 | £83,223 | £75,275 | £69,676 | £62,940 | £57,631 | £54,793 | £57,194 | £54,066 | £58,367 | £45,813 |
| Net Worth | £31,450 | £27,364 | £23,282 | £17,891 | £11,651 | £5,415 | (£818) | (£7,007) | (£12,070) | (£14,614) | (£16,073) | (£15,824) | (£17,358) |