| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Unit Sales | |||||||||||||
| Executive desk oak | 15% | 14 | 16 | 16 | 16 | 15 | 12 | 12 | 15 | 15 | 26 | 27 | 25 |
| Executive desk cherry | 5% | 2 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 3 | 4 | 3 | 2 |
| Other furniture oak | 5% | 3 | 4 | 4 | 4 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 4 |
| Other furniture cherry | 5% | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 |
| Other | 20% | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 |
| Total Unit Sales | 20 | 24 | 23 | 24 | 21 | 18 | 18 | 22 | 23 | 36 | 37 | 32 | |
| Unit Prices | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Executive desk oak | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | £1,600.00 | |
| Executive desk cherry | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | £1,750.00 | |
| Other furniture oak | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | £900.00 | |
| Other furniture cherry | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Other | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | £2,500.00 | |
| Sales | |||||||||||||
| Executive desk oak | £22,400 | £25,600 | £25,600 | £25,600 | £24,000 | £19,200 | £19,200 | £24,000 | £24,000 | £41,600 | £43,200 | £40,000 | |
| Executive desk cherry | £3,500 | £5,250 | £5,250 | £5,250 | £3,500 | £3,500 | £3,500 | £3,500 | £5,250 | £7,000 | £5,250 | £3,500 | |
| Other furniture oak | £2,700 | £3,600 | £3,600 | £3,600 | £2,700 | £2,700 | £2,700 | £3,600 | £3,600 | £3,600 | £4,500 | £3,600 | |
| Other furniture cherry | £0 | £1,000 | £0 | £0 | £0 | £1,000 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Other | £2,500 | £0 | £0 | £2,500 | £2,500 | £0 | £2,500 | £0 | £0 | £2,500 | £2,500 | £0 | |
| Total Sales | £31,100 | £35,450 | £34,450 | £36,950 | £32,700 | £26,400 | £27,900 | £32,100 | £33,850 | £55,700 | £56,450 | £48,100 | |
| Direct Unit Costs | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Executive desk oak | 0.00% | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 | £400.00 |
| Executive desk cherry | 0.00% | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 | £525.00 |
| Other furniture oak | 0.00% | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 | £180.00 |
| Other furniture cherry | 0.00% | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 | £300.00 |
| Other | 0.00% | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 |
| Direct Cost of Sales | |||||||||||||
| Executive desk oak | £5,600 | £6,400 | £6,400 | £6,400 | £6,000 | £4,800 | £4,800 | £6,000 | £6,000 | £10,400 | £10,800 | £10,000 | |
| Executive desk cherry | £1,050 | £1,575 | £1,575 | £1,575 | £1,050 | £1,050 | £1,050 | £1,050 | £1,575 | £2,100 | £1,575 | £1,050 | |
| Other furniture oak | £540 | £720 | £720 | £720 | £540 | £540 | £540 | £720 | £720 | £720 | £900 | £720 | |
| Other furniture cherry | £0 | £300 | £0 | £0 | £0 | £300 | £0 | £300 | £300 | £300 | £300 | £300 | |
| Other | £625 | £0 | £0 | £625 | £625 | £0 | £625 | £0 | £0 | £625 | £625 | £0 | |
| Subtotal Direct Cost of Sales | £7,815 | £8,995 | £8,695 | £9,320 | £8,215 | £6,690 | £7,015 | £8,070 | £8,595 | £14,145 | £14,200 | £12,070 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Production Personnel | |||||||||||||
| Workshop manager | 5% | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 |
| Assembly | 5% | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketing manager | 5% | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| General and Administrative Personnel | |||||||||||||
| President | 5% | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Other Personnel | |||||||||||||
| Design | 5% | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £12,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | |
| 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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £31,100 | £35,450 | £34,450 | £36,950 | £32,700 | £26,400 | £27,900 | £32,100 | £33,850 | £55,700 | £56,450 | £48,100 | |
| Direct Cost of Sales | £7,815 | £8,995 | £8,695 | £9,320 | £8,215 | £6,690 | £7,015 | £8,070 | £8,595 | £14,145 | £14,200 | £12,070 | |
| Production Payroll | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | £4,300 | |
| Other | £3,110 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £15,225 | £13,295 | £12,995 | £13,620 | £12,515 | £10,990 | £11,315 | £12,370 | £12,895 | £18,445 | £18,500 | £16,370 | |
| Gross Margin | £15,875 | £22,155 | £21,455 | £23,330 | £20,185 | £15,410 | £16,585 | £19,730 | £20,955 | £37,255 | £37,950 | £31,730 | |
| Gross Margin % | 51.05% | 62.50% | 62.28% | 63.14% | 61.73% | 58.37% | 59.44% | 61.46% | 61.91% | 66.89% | 67.23% | 65.97% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £4,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| Miscellaneous | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Advertising/Promotion | £8,000 | £8,000 | £0 | £8,000 | £8,000 | £0 | £8,000 | £8,000 | £0 | £8,000 | £8,000 | £0 | |
| Events | £0 | £750 | £0 | £0 | £3,000 | £0 | £0 | £0 | £0 | £2,500 | £0 | £0 | |
| Public Relations | £0 | £250 | £0 | £0 | £500 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Travel | £0 | £500 | £0 | £0 | £2,000 | £0 | £500 | £0 | £0 | £1,500 | £0 | £0 | |
| Total Sales and Marketing Expenses | £12,200 | £12,700 | £3,200 | £11,200 | £16,700 | £3,200 | £11,700 | £11,200 | £3,200 | £15,200 | £11,200 | £3,200 | |
| Sales and Marketing % | 39.23% | 35.83% | 9.29% | 30.31% | 51.07% | 12.12% | 41.94% | 34.89% | 9.45% | 27.29% | 19.84% | 6.65% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,000 | |
| Depreciation | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | |
| Rent | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Other | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Payroll Taxes | 15% | £1,883 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 | £1,733 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £6,608 | £6,458 | £6,458 | £6,458 | £6,458 | £6,458 | £6,458 | £6,458 | £6,458 | £6,458 | £6,458 | £7,958 | |
| General and Administrative % | 21.25% | 18.22% | 18.74% | 17.48% | 19.75% | 24.46% | 23.15% | 20.12% | 19.08% | 11.59% | 11.44% | 16.54% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | £250 | |
| Other % | 0.80% | 0.71% | 0.73% | 0.68% | 0.76% | 0.95% | 0.90% | 0.78% | 0.74% | 0.45% | 0.44% | 0.52% | |
| Total Operating Expenses | £19,058 | £19,408 | £9,908 | £17,908 | £23,408 | £9,908 | £18,408 | £17,908 | £9,908 | £21,908 | £17,908 | £11,408 | |
| Profit Before Interest and Taxes | (£3,183) | £2,748 | £11,548 | £5,423 | (£3,223) | £5,503 | (£1,823) | £1,823 | £11,048 | £15,348 | £20,043 | £20,323 | |
| EBITDA | (£3,183) | £2,748 | £11,548 | £5,423 | (£3,223) | £5,503 | (£1,823) | £1,823 | £11,048 | £15,348 | £20,043 | £21,323 | |
| Interest Expense | £625 | £667 | £667 | £708 | £667 | £625 | £625 | £667 | £708 | £875 | £958 | £958 | |
| Taxes Incurred | (£1,142) | £520 | £2,720 | £1,179 | (£972) | £1,219 | (£612) | £289 | £2,585 | £3,618 | £4,771 | £4,841 | |
| Net Profit | (£2,665) | £1,561 | £8,161 | £3,536 | (£2,917) | £3,658 | (£1,836) | £867 | £7,754 | £10,854 | £14,313 | £14,523 | |
| Net Profit/Sales | -8.57% | 4.40% | 23.69% | 9.57% | -8.92% | 13.86% | -6.58% | 2.70% | 22.91% | 19.49% | 25.36% | 30.19% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £23,325 | £26,588 | £25,838 | £27,713 | £24,525 | £19,800 | £20,925 | £24,075 | £25,388 | £41,775 | £42,338 | £36,075 | |
| Cash from Receivables | £13,803 | £14,062 | £7,811 | £8,854 | £8,633 | £9,202 | £8,123 | £6,613 | £7,010 | £8,040 | £8,645 | £13,931 | |
| Subtotal Cash from Operations | £37,128 | £40,649 | £33,649 | £36,567 | £33,158 | £29,002 | £29,048 | £30,688 | £32,398 | £49,815 | £50,982 | £50,006 | |
| 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 | £75,000 | £5,000 | £0 | £5,000 | £0 | £0 | £0 | £5,000 | £5,000 | £20,000 | £10,000 | £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 | £25,000 | £0 | £0 | £0 | £0 | £0 | £0 | £25,000 | £0 | £0 | £0 | |
| Subtotal Cash Received | £112,128 | £70,649 | £33,649 | £41,567 | £33,158 | £29,002 | £29,048 | £35,688 | £62,398 | £69,815 | £60,982 | £50,006 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £12,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | £11,550 | |
| Bill Payments | £11,821 | £19,044 | £23,217 | £14,708 | £22,505 | £22,519 | £9,962 | £18,585 | £20,549 | £15,863 | £38,572 | £30,250 | |
| Subtotal Spent on Operations | £24,371 | £30,594 | £34,767 | £26,258 | £34,055 | £34,069 | £21,512 | £30,135 | £32,099 | £27,413 | £50,122 | £41,800 | |
| 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 | £5,000 | £5,000 | £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 | £0 | £25,000 | £0 | £0 | £0 | £0 | £0 | £0 | £25,000 | £0 | £0 | £0 | |
| Dividends | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £24,371 | £55,594 | £34,767 | £26,258 | £39,055 | £39,069 | £21,512 | £30,135 | £57,099 | £27,413 | £50,122 | £41,800 | |
| Net Cash Flow | £87,757 | £15,056 | (£1,118) | £15,309 | (£5,897) | (£10,067) | £7,536 | £5,553 | £5,298 | £42,401 | £10,860 | £8,206 | |
| Cash Balance | £89,195 | £104,250 | £103,132 | £118,441 | £112,545 | £102,478 | £110,014 | £115,566 | £120,865 | £163,266 | £174,126 | £182,332 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,438 | £89,195 | £104,250 | £103,132 | £118,441 | £112,545 | £102,478 | £110,014 | £115,566 | £120,865 | £163,266 | £174,126 | £182,332 |
| Accounts Receivable | £27,605 | £21,578 | £16,378 | £17,180 | £17,563 | £17,105 | £14,503 | £13,355 | £14,768 | £16,220 | £22,105 | £27,573 | £25,667 |
| Inventory | £10,141 | £7,815 | £8,995 | £8,695 | £9,320 | £8,215 | £6,690 | £7,015 | £8,070 | £8,595 | £14,145 | £14,200 | £12,070 |
| Other Current Assets | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 | £2,375 |
| Total Current Assets | £41,559 | £120,962 | £131,999 | £131,382 | £147,699 | £140,239 | £126,046 | £132,759 | £140,779 | £148,055 | £201,892 | £218,274 | £222,444 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £3,210 | £3,210 | £28,210 | £28,210 | £28,210 | £28,210 | £28,210 | £28,210 | £28,210 | £53,210 | £53,210 | £53,210 | £53,210 |
| Accumulated Depreciation | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £1,720 | £2,720 |
| Total Long-term Assets | £1,490 | £1,490 | £26,490 | £26,490 | £26,490 | £26,490 | £26,490 | £26,490 | £26,490 | £51,490 | £51,490 | £51,490 | £50,490 |
| Total Assets | £43,049 | £122,452 | £158,489 | £157,872 | £174,189 | £166,729 | £152,536 | £159,249 | £167,269 | £199,545 | £253,382 | £269,764 | £272,934 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £11,191 | £18,260 | £22,735 | £13,958 | £21,740 | £22,196 | £9,345 | £17,894 | £20,047 | £14,568 | £37,551 | £29,620 | £18,267 |
| Current Borrowing | £0 | £75,000 | £80,000 | £80,000 | £85,000 | £80,000 | £75,000 | £75,000 | £80,000 | £85,000 | £105,000 | £115,000 | £115,000 |
| Other Current Liabilities | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 | £1,803 |
| Subtotal Current Liabilities | £12,994 | £95,063 | £104,538 | £95,761 | £108,543 | £103,999 | £86,148 | £94,697 | £101,850 | £101,371 | £144,354 | £146,423 | £135,070 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £12,994 | £95,063 | £104,538 | £95,761 | £108,543 | £103,999 | £86,148 | £94,697 | £101,850 | £101,371 | £144,354 | £146,423 | £135,070 |
| Paid-in Capital | £4,500 | £4,500 | £29,500 | £29,500 | £29,500 | £29,500 | £29,500 | £29,500 | £29,500 | £54,500 | £54,500 | £54,500 | £54,500 |
| Retained Earnings | £13,100 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 | £25,555 |
| Earnings | £12,455 | (£2,665) | (£1,105) | £7,056 | £10,592 | £7,675 | £11,333 | £9,497 | £10,364 | £18,119 | £28,973 | £43,286 | £57,809 |
| Total Capital | £30,055 | £27,390 | £53,950 | £62,111 | £65,647 | £62,730 | £66,388 | £64,552 | £65,419 | £98,174 | £109,028 | £123,341 | £137,864 |
| Total Liabilities and Capital | £43,049 | £122,452 | £158,489 | £157,872 | £174,189 | £166,729 | £152,536 | £159,249 | £167,269 | £199,545 | £253,382 | £269,764 | £272,934 |
| Net Worth | £30,055 | £27,390 | £53,950 | £62,111 | £65,647 | £62,730 | £66,388 | £64,552 | £65,419 | £98,173 | £109,028 | £123,341 | £137,864 |