| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Individuals | 0% | £2,500 | £2,900 | £2,876 | £3,565 | £3,938 | £4,223 | £4,432 | £4,654 | £4,998 | £5,112 | £5,332 | £5,454 |
| Distributors | 0% | £0 | £0 | £0 | £0 | £6,565 | £7,121 | £8,098 | £8,767 | £9,878 | £9,987 | £9,656 | £9,765 |
| Total Sales | £2,500 | £2,900 | £2,876 | £3,565 | £10,503 | £11,344 | £12,530 | £13,421 | £14,876 | £15,099 | £14,988 | £15,219 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Individuals | £1,125 | £1,305 | £1,294 | £1,604 | £1,772 | £1,900 | £1,994 | £2,094 | £2,249 | £2,300 | £2,399 | £2,454 | |
| Distributors | £0 | £0 | £0 | £0 | £4,530 | £4,913 | £5,588 | £6,049 | £6,816 | £6,891 | £6,663 | £6,738 | |
| Subtotal Direct Cost of Sales | £1,125 | £1,305 | £1,294 | £1,604 | £6,302 | £6,814 | £7,582 | £8,144 | £9,065 | £9,191 | £9,062 | £9,192 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Josh | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Employee #1 | 0% | £0 | £0 | £0 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 0 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £2,000 | £2,000 | £2,000 | £3,500 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £2,500 | £2,900 | £2,876 | £3,565 | £10,503 | £11,344 | £12,530 | £13,421 | £14,876 | £15,099 | £14,988 | £15,219 | |
| Direct Cost of Sales | £1,125 | £1,305 | £1,294 | £1,604 | £6,302 | £6,814 | £7,582 | £8,144 | £9,065 | £9,191 | £9,062 | £9,192 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,125 | £1,305 | £1,294 | £1,604 | £6,302 | £6,814 | £7,582 | £8,144 | £9,065 | £9,191 | £9,062 | £9,192 | |
| Gross Margin | £1,375 | £1,595 | £1,582 | £1,961 | £4,201 | £4,530 | £4,948 | £5,277 | £5,811 | £5,908 | £5,926 | £6,027 | |
| Gross Margin % | 55.00% | 55.00% | 55.00% | 55.00% | 40.00% | 39.93% | 39.49% | 39.32% | 39.06% | 39.13% | 39.54% | 39.60% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £2,000 | £3,500 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Depreciation | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
| Rent | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £300 | £300 | £300 | £525 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,483 | £3,483 | £3,483 | £5,208 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | |
| Profit Before Interest and Taxes | (£2,108) | (£1,888) | (£1,901) | (£3,247) | (£1,582) | (£1,253) | (£835) | (£506) | £28 | £125 | £143 | £244 | |
| EBITDA | (£2,025) | (£1,805) | (£1,818) | (£3,164) | (£1,499) | (£1,170) | (£752) | (£423) | £111 | £208 | £226 | £327 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,108) | (£1,888) | (£1,901) | (£3,247) | (£1,582) | (£1,253) | (£835) | (£506) | £28 | £125 | £143 | £244 | |
| Net Profit/Sales | -84.32% | -65.10% | -66.11% | -91.09% | -15.06% | -11.04% | -6.66% | -3.77% | 0.19% | 0.83% | 0.95% | 1.60% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £625 | £725 | £719 | £891 | £2,626 | £2,836 | £3,133 | £3,355 | £3,719 | £3,775 | £3,747 | £3,805 | |
| Cash from Receivables | £0 | £63 | £1,885 | £2,174 | £2,174 | £2,847 | £7,898 | £8,538 | £9,420 | £10,102 | £11,163 | £11,321 | |
| Subtotal Cash from Operations | £625 | £788 | £2,604 | £3,066 | £4,800 | £5,683 | £11,031 | £11,893 | £13,139 | £13,877 | £14,910 | £15,126 | |
| 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 | £70,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £70,625 | £788 | £2,604 | £3,066 | £4,800 | £5,683 | £11,031 | £11,893 | £13,139 | £13,877 | £14,910 | £15,126 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,000 | £2,000 | £2,000 | £3,500 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Bill Payments | £1,099 | £3,347 | £2,896 | £2,712 | £3,890 | £13,033 | £9,112 | £10,138 | £10,505 | £11,754 | £11,017 | £10,634 | |
| Subtotal Spent on Operations | £3,099 | £5,347 | £4,896 | £6,212 | £7,890 | £17,033 | £13,112 | £14,138 | £14,505 | £15,754 | £15,017 | £14,634 | |
| 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 | £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 | £5,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 | £8,099 | £5,347 | £4,896 | £6,212 | £7,890 | £17,033 | £13,112 | £14,138 | £14,505 | £15,754 | £15,017 | £14,634 | |
| Net Cash Flow | £62,526 | (£4,560) | (£2,292) | (£3,146) | (£3,090) | (£11,350) | (£2,081) | (£2,245) | (£1,366) | (£1,877) | (£107) | £493 | |
| Cash Balance | £67,981 | £63,421 | £61,130 | £57,983 | £54,893 | £43,543 | £41,462 | £39,217 | £37,850 | £35,974 | £35,867 | £36,359 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £5,455 | £67,981 | £63,421 | £61,130 | £57,983 | £54,893 | £43,543 | £41,462 | £39,217 | £37,850 | £35,974 | £35,867 | £36,359 |
| Accounts Receivable | £0 | £1,875 | £3,988 | £4,260 | £4,759 | £10,462 | £16,123 | £17,622 | £19,150 | £20,887 | £22,109 | £22,188 | £22,281 |
| Inventory | £400 | £1,238 | £1,436 | £1,424 | £1,765 | £6,932 | £7,495 | £8,340 | £8,958 | £9,971 | £10,111 | £9,968 | £10,111 |
| Other Current Assets | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Total Current Assets | £6,655 | £71,893 | £69,644 | £67,613 | £65,307 | £73,087 | £67,961 | £68,224 | £68,125 | £69,509 | £68,994 | £68,823 | £69,551 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Accumulated Depreciation | £0 | £83 | £166 | £249 | £332 | £415 | £498 | £581 | £664 | £747 | £830 | £913 | £996 |
| Total Long-term Assets | £1,000 | £5,917 | £5,834 | £5,751 | £5,668 | £5,585 | £5,502 | £5,419 | £5,336 | £5,253 | £5,170 | £5,087 | £5,004 |
| Total Assets | £7,655 | £77,810 | £75,478 | £73,364 | £70,975 | £78,672 | £73,463 | £73,643 | £73,461 | £74,762 | £74,164 | £73,910 | £74,555 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £987 | £3,250 | £2,806 | £2,593 | £3,451 | £12,730 | £8,774 | £9,789 | £10,112 | £11,386 | £10,663 | £10,266 | £10,667 |
| 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 | £987 | £3,250 | £2,806 | £2,593 | £3,451 | £12,730 | £8,774 | £9,789 | £10,112 | £11,386 | £10,663 | £10,266 | £10,667 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £987 | £3,250 | £2,806 | £2,593 | £3,451 | £12,730 | £8,774 | £9,789 | £10,112 | £11,386 | £10,663 | £10,266 | £10,667 |
| Paid-in Capital | £0 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Retained Earnings | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 |
| Earnings | £0 | (£2,108) | (£3,996) | (£5,897) | (£9,144) | (£10,726) | (£11,979) | (£12,814) | (£13,320) | (£13,292) | (£13,167) | (£13,024) | (£12,780) |
| Total Capital | £6,668 | £74,560 | £72,672 | £70,771 | £67,524 | £65,942 | £64,689 | £63,854 | £63,348 | £63,376 | £63,501 | £63,644 | £63,888 |
| Total Liabilities and Capital | £7,655 | £77,810 | £75,478 | £73,364 | £70,975 | £78,672 | £73,463 | £73,643 | £73,461 | £74,762 | £74,164 | £73,910 | £74,555 |
| Net Worth | £6,668 | £74,560 | £72,672 | £70,771 | £67,524 | £65,942 | £64,689 | £63,854 | £63,348 | £63,376 | £63,501 | £63,644 | £63,888 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Individuals | 0% | £2,500 | £2,900 | £2,876 | £3,565 | £3,938 | £4,223 | £4,432 | £4,654 | £4,998 | £5,112 | £5,332 | £5,454 |
| Distributors | 0% | £0 | £0 | £0 | £0 | £6,565 | £7,121 | £8,098 | £8,767 | £9,878 | £9,987 | £9,656 | £9,765 |
| Total Sales | £2,500 | £2,900 | £2,876 | £3,565 | £10,503 | £11,344 | £12,530 | £13,421 | £14,876 | £15,099 | £14,988 | £15,219 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Individuals | £1,125 | £1,305 | £1,294 | £1,604 | £1,772 | £1,900 | £1,994 | £2,094 | £2,249 | £2,300 | £2,399 | £2,454 | |
| Distributors | £0 | £0 | £0 | £0 | £4,530 | £4,913 | £5,588 | £6,049 | £6,816 | £6,891 | £6,663 | £6,738 | |
| Subtotal Direct Cost of Sales | £1,125 | £1,305 | £1,294 | £1,604 | £6,302 | £6,814 | £7,582 | £8,144 | £9,065 | £9,191 | £9,062 | £9,192 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Josh | 0% | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Employee #1 | 0% | £0 | £0 | £0 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Total People | 0 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | £2,000 | £2,000 | £2,000 | £3,500 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £2,500 | £2,900 | £2,876 | £3,565 | £10,503 | £11,344 | £12,530 | £13,421 | £14,876 | £15,099 | £14,988 | £15,219 | |
| Direct Cost of Sales | £1,125 | £1,305 | £1,294 | £1,604 | £6,302 | £6,814 | £7,582 | £8,144 | £9,065 | £9,191 | £9,062 | £9,192 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £1,125 | £1,305 | £1,294 | £1,604 | £6,302 | £6,814 | £7,582 | £8,144 | £9,065 | £9,191 | £9,062 | £9,192 | |
| Gross Margin | £1,375 | £1,595 | £1,582 | £1,961 | £4,201 | £4,530 | £4,948 | £5,277 | £5,811 | £5,908 | £5,926 | £6,027 | |
| Gross Margin % | 55.00% | 55.00% | 55.00% | 55.00% | 40.00% | 39.93% | 39.49% | 39.32% | 39.06% | 39.13% | 39.54% | 39.60% | |
| Expenses | |||||||||||||
| Payroll | £2,000 | £2,000 | £2,000 | £3,500 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Depreciation | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
| Rent | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £300 | £300 | £300 | £525 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £3,483 | £3,483 | £3,483 | £5,208 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | £5,783 | |
| Profit Before Interest and Taxes | (£2,108) | (£1,888) | (£1,901) | (£3,247) | (£1,582) | (£1,253) | (£835) | (£506) | £28 | £125 | £143 | £244 | |
| EBITDA | (£2,025) | (£1,805) | (£1,818) | (£3,164) | (£1,499) | (£1,170) | (£752) | (£423) | £111 | £208 | £226 | £327 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Net Profit | (£2,108) | (£1,888) | (£1,901) | (£3,247) | (£1,582) | (£1,253) | (£835) | (£506) | £28 | £125 | £143 | £244 | |
| Net Profit/Sales | -84.32% | -65.10% | -66.11% | -91.09% | -15.06% | -11.04% | -6.66% | -3.77% | 0.19% | 0.83% | 0.95% | 1.60% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £625 | £725 | £719 | £891 | £2,626 | £2,836 | £3,133 | £3,355 | £3,719 | £3,775 | £3,747 | £3,805 | |
| Cash from Receivables | £0 | £63 | £1,885 | £2,174 | £2,174 | £2,847 | £7,898 | £8,538 | £9,420 | £10,102 | £11,163 | £11,321 | |
| Subtotal Cash from Operations | £625 | £788 | £2,604 | £3,066 | £4,800 | £5,683 | £11,031 | £11,893 | £13,139 | £13,877 | £14,910 | £15,126 | |
| 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 | £70,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £70,625 | £788 | £2,604 | £3,066 | £4,800 | £5,683 | £11,031 | £11,893 | £13,139 | £13,877 | £14,910 | £15,126 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £2,000 | £2,000 | £2,000 | £3,500 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Bill Payments | £1,099 | £3,347 | £2,896 | £2,712 | £3,890 | £13,033 | £9,112 | £10,138 | £10,505 | £11,754 | £11,017 | £10,634 | |
| Subtotal Spent on Operations | £3,099 | £5,347 | £4,896 | £6,212 | £7,890 | £17,033 | £13,112 | £14,138 | £14,505 | £15,754 | £15,017 | £14,634 | |
| 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 | £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 | £5,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 | £8,099 | £5,347 | £4,896 | £6,212 | £7,890 | £17,033 | £13,112 | £14,138 | £14,505 | £15,754 | £15,017 | £14,634 | |
| Net Cash Flow | £62,526 | (£4,560) | (£2,292) | (£3,146) | (£3,090) | (£11,350) | (£2,081) | (£2,245) | (£1,366) | (£1,877) | (£107) | £493 | |
| Cash Balance | £67,981 | £63,421 | £61,130 | £57,983 | £54,893 | £43,543 | £41,462 | £39,217 | £37,850 | £35,974 | £35,867 | £36,359 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £5,455 | £67,981 | £63,421 | £61,130 | £57,983 | £54,893 | £43,543 | £41,462 | £39,217 | £37,850 | £35,974 | £35,867 | £36,359 |
| Accounts Receivable | £0 | £1,875 | £3,988 | £4,260 | £4,759 | £10,462 | £16,123 | £17,622 | £19,150 | £20,887 | £22,109 | £22,188 | £22,281 |
| Inventory | £400 | £1,238 | £1,436 | £1,424 | £1,765 | £6,932 | £7,495 | £8,340 | £8,958 | £9,971 | £10,111 | £9,968 | £10,111 |
| Other Current Assets | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Total Current Assets | £6,655 | £71,893 | £69,644 | £67,613 | £65,307 | £73,087 | £67,961 | £68,224 | £68,125 | £69,509 | £68,994 | £68,823 | £69,551 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 | £6,000 |
| Accumulated Depreciation | £0 | £83 | £166 | £249 | £332 | £415 | £498 | £581 | £664 | £747 | £830 | £913 | £996 |
| Total Long-term Assets | £1,000 | £5,917 | £5,834 | £5,751 | £5,668 | £5,585 | £5,502 | £5,419 | £5,336 | £5,253 | £5,170 | £5,087 | £5,004 |
| Total Assets | £7,655 | £77,810 | £75,478 | £73,364 | £70,975 | £78,672 | £73,463 | £73,643 | £73,461 | £74,762 | £74,164 | £73,910 | £74,555 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £987 | £3,250 | £2,806 | £2,593 | £3,451 | £12,730 | £8,774 | £9,789 | £10,112 | £11,386 | £10,663 | £10,266 | £10,667 |
| 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 | £987 | £3,250 | £2,806 | £2,593 | £3,451 | £12,730 | £8,774 | £9,789 | £10,112 | £11,386 | £10,663 | £10,266 | £10,667 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £987 | £3,250 | £2,806 | £2,593 | £3,451 | £12,730 | £8,774 | £9,789 | £10,112 | £11,386 | £10,663 | £10,266 | £10,667 |
| Paid-in Capital | £0 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 | £70,000 |
| Retained Earnings | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 | £6,668 |
| Earnings | £0 | (£2,108) | (£3,996) | (£5,897) | (£9,144) | (£10,726) | (£11,979) | (£12,814) | (£13,320) | (£13,292) | (£13,167) | (£13,024) | (£12,780) |
| Total Capital | £6,668 | £74,560 | £72,672 | £70,771 | £67,524 | £65,942 | £64,689 | £63,854 | £63,348 | £63,376 | £63,501 | £63,644 | £63,888 |
| Total Liabilities and Capital | £7,655 | £77,810 | £75,478 | £73,364 | £70,975 | £78,672 | £73,463 | £73,643 | £73,461 | £74,762 | £74,164 | £73,910 | £74,555 |
| Net Worth | £6,668 | £74,560 | £72,672 | £70,771 | £67,524 | £65,942 | £64,689 | £63,854 | £63,348 | £63,376 | £63,501 | £63,644 | £63,888 |