| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Hair and Skin Services | 0% | £8,000 | £8,400 | £8,820 | £9,261 | £9,724 | £10,210 | £10,721 | £11,257 | £11,820 | £12,411 | £13,031 | £13,683 |
| Massage | 0% | £3,000 | £3,060 | £3,120 | £3,120 | £3,120 | £3,150 | £3,180 | £3,210 | £3,270 | £3,270 | £3,320 | £3,330 |
| Booth Rent | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Products | 0% | £3,000 | £3,150 | £3,308 | £3,473 | £3,647 | £3,829 | £4,020 | £4,221 | £4,432 | £4,654 | £4,887 | £5,131 |
| Total Sales | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Hair Services | £2,000 | £2,100 | £2,205 | £2,315 | £2,431 | £2,553 | £2,680 | £2,814 | £2,955 | £3,103 | £3,258 | £3,421 | |
| Massage | £60 | £61 | £62 | £62 | £62 | £63 | £64 | £64 | £65 | £65 | £66 | £67 | |
| Products | £1,500 | £1,575 | £1,654 | £1,736 | £1,823 | £1,914 | £2,010 | £2,111 | £2,216 | £2,327 | £2,443 | £2,566 | |
| Subtotal Direct Cost of Sales | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Receptionist | 0% | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 |
| Massage Therapists | 0% | £1,800 | £1,830 | £1,860 | £1,860 | £1,860 | £1,875 | £1,890 | £1,905 | £1,935 | £1,935 | £1,960 | £1,965 |
| Cosmetologist (Phyllis) | 0% | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 |
| Cosmetologist (Phoebe) | 0% | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £8,840 | £8,870 | £8,900 | £8,900 | £8,900 | £8,915 | £8,930 | £8,945 | £8,975 | £8,975 | £9,000 | £9,005 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Direct Cost of Sales | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 | |
| Gross Margin | £13,040 | £13,474 | £13,926 | £14,340 | £14,774 | £15,259 | £15,767 | £16,299 | £16,886 | £17,440 | £18,070 | £18,691 | |
| Gross Margin % | 78.55% | 78.29% | 78.03% | 77.71% | 77.39% | 77.11% | 76.83% | 76.56% | 76.33% | 76.04% | 75.81% | 75.54% | |
| Expenses | |||||||||||||
| Payroll | £8,840 | £8,870 | £8,900 | £8,900 | £8,900 | £8,915 | £8,930 | £8,945 | £8,975 | £8,975 | £9,000 | £9,005 | |
| Marketing/Promotion | £0 | £900 | £0 | £900 | £0 | £900 | £0 | £900 | £0 | £900 | £0 | £900 | |
| Depreciation | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | |
| Rent | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Utilities | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | |
| Insurance | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
| Payroll Taxes | 15% | £1,326 | £1,331 | £1,335 | £1,335 | £1,335 | £1,337 | £1,340 | £1,342 | £1,346 | £1,346 | £1,350 | £1,351 |
| Merchant Account Fees | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Moving Expenses | 15% | £2,300 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Redecorating New Location | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,840 | £13,475 | £12,609 | £13,509 | £12,609 | £13,526 | £12,644 | £13,561 | £12,695 | £13,595 | £12,724 | £13,630 | |
| Profit Before Interest and Taxes | (£4,800) | (£1) | £1,317 | £831 | £2,165 | £1,733 | £3,124 | £2,738 | £4,190 | £3,844 | £5,346 | £5,061 | |
| EBITDA | (£4,783) | £16 | £1,334 | £848 | £2,182 | £1,750 | £3,141 | £2,755 | £4,207 | £3,861 | £5,363 | £5,078 | |
| Interest Expense | £23 | £23 | £20 | £18 | £15 | £12 | £9 | £6 | £3 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,447) | (£7) | £389 | £244 | £645 | £516 | £934 | £820 | £1,256 | £1,153 | £1,604 | £1,518 | |
| Net Profit | (£3,376) | (£17) | £908 | £569 | £1,505 | £1,205 | £2,180 | £1,913 | £2,931 | £2,691 | £3,742 | £3,543 | |
| Net Profit/Sales | -20.34% | -0.10% | 5.09% | 3.08% | 7.88% | 6.09% | 10.63% | 8.98% | 13.25% | 11.73% | 15.70% | 14.32% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Subtotal Cash from Operations | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| 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 | £4,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 | £20,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £8,840 | £8,870 | £8,900 | £8,900 | £8,900 | £8,915 | £8,930 | £8,945 | £8,975 | £8,975 | £9,000 | £9,005 | |
| Bill Payments | £3,939 | £13,006 | £8,506 | £8,239 | £9,151 | £8,904 | £9,857 | £9,652 | £10,642 | £10,482 | £11,505 | £11,388 | |
| Subtotal Spent on Operations | £12,779 | £21,876 | £17,406 | £17,139 | £18,051 | £17,819 | £18,787 | £18,597 | £19,617 | £19,457 | £20,505 | £20,393 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £1,400 | £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 | £14,179 | £21,876 | £17,906 | £17,639 | £18,551 | £18,319 | £19,387 | £19,197 | £20,217 | £20,057 | £20,605 | £20,493 | |
| Net Cash Flow | £6,421 | (£4,666) | (£58) | £815 | £540 | £1,470 | £1,134 | £2,091 | £1,905 | £2,878 | £3,233 | £4,251 | |
| Cash Balance | £7,452 | £2,787 | £2,729 | £3,543 | £4,083 | £5,553 | £6,687 | £8,778 | £10,683 | £13,561 | £16,794 | £21,044 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,031 | £7,452 | £2,787 | £2,729 | £3,543 | £4,083 | £5,553 | £6,687 | £8,778 | £10,683 | £13,561 | £16,794 | £21,044 |
| Inventory | £1,519 | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 |
| Other Current Assets | £1,675 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 |
| Total Current Assets | £4,225 | £14,087 | £9,598 | £9,725 | £10,732 | £11,474 | £13,158 | £14,515 | £16,842 | £18,994 | £22,131 | £25,636 | £30,172 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Accumulated Depreciation | £126 | £143 | £160 | £177 | £194 | £211 | £228 | £245 | £262 | £279 | £296 | £313 | £330 |
| Total Long-term Assets | £1,674 | £1,657 | £1,640 | £1,623 | £1,606 | £1,589 | £1,572 | £1,555 | £1,538 | £1,521 | £1,504 | £1,487 | £1,470 |
| Total Assets | £5,899 | £15,744 | £11,238 | £11,348 | £12,338 | £13,063 | £14,730 | £16,070 | £18,380 | £20,515 | £23,635 | £27,123 | £31,642 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £3,500 | £12,722 | £8,232 | £7,934 | £8,855 | £8,575 | £9,537 | £9,297 | £10,294 | £10,098 | £11,126 | £10,973 | £12,049 |
| Current Borrowing | £0 | £4,000 | £4,000 | £3,500 | £3,000 | £2,500 | £2,000 | £1,500 | £1,000 | £500 | £0 | £0 | £0 |
| Other Current Liabilities | £1,135 | £1,135 | £1,135 | £1,135 | £1,135 | £1,135 | £1,135 | £1,035 | £935 | £835 | £735 | £635 | £535 |
| Subtotal Current Liabilities | £4,635 | £17,857 | £13,367 | £12,569 | £12,990 | £12,210 | £12,672 | £11,832 | £12,229 | £11,433 | £11,861 | £11,608 | £12,584 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £4,635 | £17,857 | £13,367 | £12,569 | £12,990 | £12,210 | £12,672 | £11,832 | £12,229 | £11,433 | £11,861 | £11,608 | £12,584 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | (£2,049) | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 |
| Earnings | £3,313 | (£3,376) | (£3,393) | (£2,485) | (£1,916) | (£411) | £794 | £2,974 | £4,887 | £7,818 | £10,509 | £14,252 | £17,795 |
| Total Capital | £1,264 | (£2,112) | (£2,129) | (£1,221) | (£652) | £853 | £2,058 | £4,238 | £6,151 | £9,082 | £11,773 | £15,516 | £19,059 |
| Total Liabilities and Capital | £5,899 | £15,744 | £11,238 | £11,348 | £12,338 | £13,063 | £14,730 | £16,070 | £18,380 | £20,515 | £23,635 | £27,123 | £31,642 |
| Net Worth | £1,264 | (£2,112) | (£2,129) | (£1,221) | (£652) | £853 | £2,058 | £4,238 | £6,151 | £9,082 | £11,773 | £15,516 | £19,059 |
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Hair and Skin Services | 0% | £8,000 | £8,400 | £8,820 | £9,261 | £9,724 | £10,210 | £10,721 | £11,257 | £11,820 | £12,411 | £13,031 | £13,683 |
| Massage | 0% | £3,000 | £3,060 | £3,120 | £3,120 | £3,120 | £3,150 | £3,180 | £3,210 | £3,270 | £3,270 | £3,320 | £3,330 |
| Booth Rent | 0% | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 | £2,600 |
| Products | 0% | £3,000 | £3,150 | £3,308 | £3,473 | £3,647 | £3,829 | £4,020 | £4,221 | £4,432 | £4,654 | £4,887 | £5,131 |
| Total Sales | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Hair Services | £2,000 | £2,100 | £2,205 | £2,315 | £2,431 | £2,553 | £2,680 | £2,814 | £2,955 | £3,103 | £3,258 | £3,421 | |
| Massage | £60 | £61 | £62 | £62 | £62 | £63 | £64 | £64 | £65 | £65 | £66 | £67 | |
| Products | £1,500 | £1,575 | £1,654 | £1,736 | £1,823 | £1,914 | £2,010 | £2,111 | £2,216 | £2,327 | £2,443 | £2,566 | |
| Subtotal Direct Cost of Sales | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Receptionist | 0% | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 | £1,280 |
| Massage Therapists | 0% | £1,800 | £1,830 | £1,860 | £1,860 | £1,860 | £1,875 | £1,890 | £1,905 | £1,935 | £1,935 | £1,960 | £1,965 |
| Cosmetologist (Phyllis) | 0% | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 | £2,560 |
| Cosmetologist (Phoebe) | 0% | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 | £3,200 |
| Total People | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
| Total Payroll | £8,840 | £8,870 | £8,900 | £8,900 | £8,900 | £8,915 | £8,930 | £8,945 | £8,975 | £8,975 | £9,000 | £9,005 | |
| Pro Forma Profit and Loss | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Direct Cost of Sales | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 | |
| Other Costs of Goods | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 | |
| Gross Margin | £13,040 | £13,474 | £13,926 | £14,340 | £14,774 | £15,259 | £15,767 | £16,299 | £16,886 | £17,440 | £18,070 | £18,691 | |
| Gross Margin % | 78.55% | 78.29% | 78.03% | 77.71% | 77.39% | 77.11% | 76.83% | 76.56% | 76.33% | 76.04% | 75.81% | 75.54% | |
| Expenses | |||||||||||||
| Payroll | £8,840 | £8,870 | £8,900 | £8,900 | £8,900 | £8,915 | £8,930 | £8,945 | £8,975 | £8,975 | £9,000 | £9,005 | |
| Marketing/Promotion | £0 | £900 | £0 | £900 | £0 | £900 | £0 | £900 | £0 | £900 | £0 | £900 | |
| Depreciation | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | £17 | |
| Rent | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | £1,750 | |
| Utilities | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | £374 | |
| Insurance | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | £83 | |
| Payroll Taxes | 15% | £1,326 | £1,331 | £1,335 | £1,335 | £1,335 | £1,337 | £1,340 | £1,342 | £1,346 | £1,346 | £1,350 | £1,351 |
| Merchant Account Fees | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Moving Expenses | 15% | £2,300 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Redecorating New Location | £3,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £17,840 | £13,475 | £12,609 | £13,509 | £12,609 | £13,526 | £12,644 | £13,561 | £12,695 | £13,595 | £12,724 | £13,630 | |
| Profit Before Interest and Taxes | (£4,800) | (£1) | £1,317 | £831 | £2,165 | £1,733 | £3,124 | £2,738 | £4,190 | £3,844 | £5,346 | £5,061 | |
| EBITDA | (£4,783) | £16 | £1,334 | £848 | £2,182 | £1,750 | £3,141 | £2,755 | £4,207 | £3,861 | £5,363 | £5,078 | |
| Interest Expense | £23 | £23 | £20 | £18 | £15 | £12 | £9 | £6 | £3 | £0 | £0 | £0 | |
| Taxes Incurred | (£1,447) | (£7) | £389 | £244 | £645 | £516 | £934 | £820 | £1,256 | £1,153 | £1,604 | £1,518 | |
| Net Profit | (£3,376) | (£17) | £908 | £569 | £1,505 | £1,205 | £2,180 | £1,913 | £2,931 | £2,691 | £3,742 | £3,543 | |
| Net Profit/Sales | -20.34% | -0.10% | 5.09% | 3.08% | 7.88% | 6.09% | 10.63% | 8.98% | 13.25% | 11.73% | 15.70% | 14.32% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Subtotal Cash from Operations | £16,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| 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 | £4,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 | £20,600 | £17,210 | £17,848 | £18,454 | £19,091 | £19,789 | £20,521 | £21,288 | £22,122 | £22,935 | £23,838 | £24,744 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £8,840 | £8,870 | £8,900 | £8,900 | £8,900 | £8,915 | £8,930 | £8,945 | £8,975 | £8,975 | £9,000 | £9,005 | |
| Bill Payments | £3,939 | £13,006 | £8,506 | £8,239 | £9,151 | £8,904 | £9,857 | £9,652 | £10,642 | £10,482 | £11,505 | £11,388 | |
| Subtotal Spent on Operations | £12,779 | £21,876 | £17,406 | £17,139 | £18,051 | £17,819 | £18,787 | £18,597 | £19,617 | £19,457 | £20,505 | £20,393 | |
| 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 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £0 | £0 | |
| Other Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Long-term Liabilities Principal Repayment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Purchase Other Current Assets | £1,400 | £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 | £14,179 | £21,876 | £17,906 | £17,639 | £18,551 | £18,319 | £19,387 | £19,197 | £20,217 | £20,057 | £20,605 | £20,493 | |
| Net Cash Flow | £6,421 | (£4,666) | (£58) | £815 | £540 | £1,470 | £1,134 | £2,091 | £1,905 | £2,878 | £3,233 | £4,251 | |
| Cash Balance | £7,452 | £2,787 | £2,729 | £3,543 | £4,083 | £5,553 | £6,687 | £8,778 | £10,683 | £13,561 | £16,794 | £21,044 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £1,031 | £7,452 | £2,787 | £2,729 | £3,543 | £4,083 | £5,553 | £6,687 | £8,778 | £10,683 | £13,561 | £16,794 | £21,044 |
| Inventory | £1,519 | £3,560 | £3,736 | £3,921 | £4,114 | £4,317 | £4,530 | £4,754 | £4,989 | £5,236 | £5,495 | £5,768 | £6,053 |
| Other Current Assets | £1,675 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 | £3,075 |
| Total Current Assets | £4,225 | £14,087 | £9,598 | £9,725 | £10,732 | £11,474 | £13,158 | £14,515 | £16,842 | £18,994 | £22,131 | £25,636 | £30,172 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 | £1,800 |
| Accumulated Depreciation | £126 | £143 | £160 | £177 | £194 | £211 | £228 | £245 | £262 | £279 | £296 | £313 | £330 |
| Total Long-term Assets | £1,674 | £1,657 | £1,640 | £1,623 | £1,606 | £1,589 | £1,572 | £1,555 | £1,538 | £1,521 | £1,504 | £1,487 | £1,470 |
| Total Assets | £5,899 | £15,744 | £11,238 | £11,348 | £12,338 | £13,063 | £14,730 | £16,070 | £18,380 | £20,515 | £23,635 | £27,123 | £31,642 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £3,500 | £12,722 | £8,232 | £7,934 | £8,855 | £8,575 | £9,537 | £9,297 | £10,294 | £10,098 | £11,126 | £10,973 | £12,049 |
| Current Borrowing | £0 | £4,000 | £4,000 | £3,500 | £3,000 | £2,500 | £2,000 | £1,500 | £1,000 | £500 | £0 | £0 | £0 |
| Other Current Liabilities | £1,135 | £1,135 | £1,135 | £1,135 | £1,135 | £1,135 | £1,135 | £1,035 | £935 | £835 | £735 | £635 | £535 |
| Subtotal Current Liabilities | £4,635 | £17,857 | £13,367 | £12,569 | £12,990 | £12,210 | £12,672 | £11,832 | £12,229 | £11,433 | £11,861 | £11,608 | £12,584 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £4,635 | £17,857 | £13,367 | £12,569 | £12,990 | £12,210 | £12,672 | £11,832 | £12,229 | £11,433 | £11,861 | £11,608 | £12,584 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | (£2,049) | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 | £1,264 |
| Earnings | £3,313 | (£3,376) | (£3,393) | (£2,485) | (£1,916) | (£411) | £794 | £2,974 | £4,887 | £7,818 | £10,509 | £14,252 | £17,795 |
| Total Capital | £1,264 | (£2,112) | (£2,129) | (£1,221) | (£652) | £853 | £2,058 | £4,238 | £6,151 | £9,082 | £11,773 | £15,516 | £19,059 |
| Total Liabilities and Capital | £5,899 | £15,744 | £11,238 | £11,348 | £12,338 | £13,063 | £14,730 | £16,070 | £18,380 | £20,515 | £23,635 | £27,123 | £31,642 |
| Net Worth | £1,264 | (£2,112) | (£2,129) | (£1,221) | (£652) | £853 | £2,058 | £4,238 | £6,151 | £9,082 | £11,773 | £15,516 | £19,059 |