| 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 | |||||||||||||
| Translation Projects | 0% | £0 | £17,000 | £19,000 | £21,000 | £24,000 | £24,000 | £27,000 | £27,000 | £29,000 | £31,000 | £28,000 | £26,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £17,000 | £19,000 | £21,000 | £24,000 | £24,000 | £27,000 | £27,000 | £29,000 | £31,000 | £28,000 | £26,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 | |
| Translation Projects | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| 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 | ||
| Project Managers (2) | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Marketing Person | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Other | 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| 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 | £0 | £17,000 | £19,000 | £21,000 | £24,000 | £24,000 | £27,000 | £27,000 | £29,000 | £31,000 | £28,000 | £26,000 | |
| Direct Cost of Sales | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| Gross Margin | £0 | £11,000 | £12,000 | £13,000 | £15,000 | £15,000 | £17,000 | £17,000 | £17,000 | £18,500 | £16,500 | £16,000 | |
| Gross Margin % | 0.00% | 64.71% | 63.16% | 61.90% | 62.50% | 62.50% | 62.96% | 62.96% | 58.62% | 59.68% | 58.93% | 61.54% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Sales and Marketing and Other Expenses | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Depreciation | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | |
| Profit Before Interest and Taxes | (£10,738) | £262 | £1,262 | £2,262 | £4,262 | £4,262 | £6,262 | £6,262 | £6,262 | £7,762 | £5,762 | £5,262 | |
| EBITDA | (£10,500) | £500 | £1,500 | £2,500 | £4,500 | £4,500 | £6,500 | £6,500 | £6,500 | £8,000 | £6,000 | £5,500 | |
| Interest Expense | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Taxes Incurred | (£3,346) | (£46) | £254 | £554 | £1,154 | £1,154 | £1,754 | £1,754 | £1,754 | £2,204 | £1,604 | £1,454 | |
| Net Profit | (£7,808) | (£108) | £592 | £1,292 | £2,692 | £2,692 | £4,092 | £4,092 | £4,092 | £5,142 | £3,742 | £3,392 | |
| Net Profit/Sales | 0.00% | -0.64% | 3.11% | 6.15% | 11.22% | 11.22% | 15.15% | 15.15% | 14.11% | 16.59% | 13.36% | 13.05% | |
| 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 | £0 | £4,250 | £4,750 | £5,250 | £6,000 | £6,000 | £6,750 | £6,750 | £7,250 | £7,750 | £7,000 | £6,500 | |
| Cash from Receivables | £0 | £0 | £425 | £12,800 | £14,300 | £15,825 | £18,000 | £18,075 | £20,250 | £20,300 | £21,800 | £23,175 | |
| Subtotal Cash from Operations | £0 | £4,250 | £5,175 | £18,050 | £20,300 | £21,825 | £24,750 | £24,825 | £27,500 | £28,050 | £28,800 | £29,675 | |
| 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 | £0 | £4,250 | £5,175 | £18,050 | £20,300 | £21,825 | £24,750 | £24,825 | £27,500 | £28,050 | £28,800 | £29,675 | |
| 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | (£430) | (£120) | £8,914 | £10,214 | £11,524 | £13,070 | £13,124 | £14,670 | £14,737 | £16,702 | £17,567 | £15,965 | |
| Subtotal Spent on Operations | £7,570 | £7,880 | £16,914 | £18,214 | £19,524 | £21,070 | £21,124 | £22,670 | £22,737 | £24,702 | £25,567 | £23,965 | |
| 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 | £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,570 | £7,880 | £16,914 | £18,214 | £19,524 | £21,070 | £21,124 | £22,670 | £22,737 | £24,702 | £25,567 | £23,965 | |
| Net Cash Flow | (£7,570) | (£3,630) | (£11,739) | (£164) | £776 | £755 | £3,626 | £2,155 | £4,763 | £3,348 | £3,233 | £5,710 | |
| Cash Balance | £18,430 | £14,799 | £3,061 | £2,897 | £3,674 | £4,428 | £8,055 | £10,210 | £14,973 | £18,321 | £21,554 | £27,263 | |
| 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 | £26,000 | £18,430 | £14,799 | £3,061 | £2,897 | £3,674 | £4,428 | £8,055 | £10,210 | £14,973 | £18,321 | £21,554 | £27,263 |
| Accounts Receivable | £0 | £0 | £12,750 | £26,575 | £29,525 | £33,225 | £35,400 | £37,650 | £39,825 | £41,325 | £44,275 | £43,475 | £39,800 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £26,000 | £18,430 | £27,549 | £29,636 | £32,422 | £36,899 | £39,828 | £45,705 | £50,035 | £56,298 | £62,596 | £65,029 | £67,063 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Accumulated Depreciation | £0 | £238 | £476 | £714 | £952 | £1,190 | £1,428 | £1,666 | £1,904 | £2,142 | £2,380 | £2,618 | £2,856 |
| Total Long-term Assets | £20,000 | £19,762 | £19,524 | £19,286 | £19,048 | £18,810 | £18,572 | £18,334 | £18,096 | £17,858 | £17,620 | £17,382 | £17,144 |
| Total Assets | £46,000 | £38,192 | £47,073 | £48,922 | £51,470 | £55,709 | £58,400 | £64,039 | £68,131 | £74,156 | £80,216 | £82,411 | £84,207 |
| 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 | £0 | £8,990 | £10,247 | £11,503 | £13,050 | £13,050 | £14,597 | £14,597 | £16,530 | £17,448 | £15,902 | £14,307 |
| 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 | £0 | £8,990 | £10,247 | £11,503 | £13,050 | £13,050 | £14,597 | £14,597 | £16,530 | £17,448 | £15,902 | £14,307 |
| Long-term Liabilities | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Liabilities | £50,000 | £50,000 | £58,990 | £60,247 | £61,503 | £63,050 | £63,050 | £64,597 | £64,597 | £66,530 | £67,448 | £65,902 | £64,307 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) |
| Earnings | £0 | (£7,808) | (£7,917) | (£7,325) | (£6,033) | (£3,341) | (£650) | £3,442 | £7,534 | £11,626 | £16,767 | £20,509 | £23,901 |
| Total Capital | (£4,000) | (£11,808) | (£11,917) | (£11,325) | (£10,033) | (£7,341) | (£4,650) | (£558) | £3,534 | £7,626 | £12,767 | £16,509 | £19,901 |
| Total Liabilities and Capital | £46,000 | £38,192 | £47,073 | £48,922 | £51,470 | £55,709 | £58,400 | £64,039 | £68,131 | £74,156 | £80,216 | £82,411 | £84,207 |
| Net Worth | (£4,000) | (£11,808) | (£11,917) | (£11,325) | (£10,033) | (£7,341) | (£4,650) | (£558) | £3,534 | £7,626 | £12,767 | £16,509 | £19,901 |
| 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 | |||||||||||||
| Translation Projects | 0% | £0 | £17,000 | £19,000 | £21,000 | £24,000 | £24,000 | £27,000 | £27,000 | £29,000 | £31,000 | £28,000 | £26,000 |
| Other | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Sales | £0 | £17,000 | £19,000 | £21,000 | £24,000 | £24,000 | £27,000 | £27,000 | £29,000 | £31,000 | £28,000 | £26,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 | |
| Translation Projects | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| 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 | ||
| Project Managers (2) | 0% | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 | £5,000 |
| Marketing Person | 0% | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 |
| Other | 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| General Assumptions | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| 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 | £0 | £17,000 | £19,000 | £21,000 | £24,000 | £24,000 | £27,000 | £27,000 | £29,000 | £31,000 | £28,000 | £26,000 | |
| Direct Cost of Sales | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| Other Production Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £6,000 | £7,000 | £8,000 | £9,000 | £9,000 | £10,000 | £10,000 | £12,000 | £12,500 | £11,500 | £10,000 | |
| Gross Margin | £0 | £11,000 | £12,000 | £13,000 | £15,000 | £15,000 | £17,000 | £17,000 | £17,000 | £18,500 | £16,500 | £16,000 | |
| Gross Margin % | 0.00% | 64.71% | 63.16% | 61.90% | 62.50% | 62.50% | 62.96% | 62.96% | 58.62% | 59.68% | 58.93% | 61.54% | |
| Expenses | |||||||||||||
| Payroll | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Sales and Marketing and Other Expenses | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Depreciation | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | £238 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Insurance | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Payroll Taxes | 15% | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | £10,738 | |
| Profit Before Interest and Taxes | (£10,738) | £262 | £1,262 | £2,262 | £4,262 | £4,262 | £6,262 | £6,262 | £6,262 | £7,762 | £5,762 | £5,262 | |
| EBITDA | (£10,500) | £500 | £1,500 | £2,500 | £4,500 | £4,500 | £6,500 | £6,500 | £6,500 | £8,000 | £6,000 | £5,500 | |
| Interest Expense | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | £417 | |
| Taxes Incurred | (£3,346) | (£46) | £254 | £554 | £1,154 | £1,154 | £1,754 | £1,754 | £1,754 | £2,204 | £1,604 | £1,454 | |
| Net Profit | (£7,808) | (£108) | £592 | £1,292 | £2,692 | £2,692 | £4,092 | £4,092 | £4,092 | £5,142 | £3,742 | £3,392 | |
| Net Profit/Sales | 0.00% | -0.64% | 3.11% | 6.15% | 11.22% | 11.22% | 15.15% | 15.15% | 14.11% | 16.59% | 13.36% | 13.05% | |
| 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 | £0 | £4,250 | £4,750 | £5,250 | £6,000 | £6,000 | £6,750 | £6,750 | £7,250 | £7,750 | £7,000 | £6,500 | |
| Cash from Receivables | £0 | £0 | £425 | £12,800 | £14,300 | £15,825 | £18,000 | £18,075 | £20,250 | £20,300 | £21,800 | £23,175 | |
| Subtotal Cash from Operations | £0 | £4,250 | £5,175 | £18,050 | £20,300 | £21,825 | £24,750 | £24,825 | £27,500 | £28,050 | £28,800 | £29,675 | |
| 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 | £0 | £4,250 | £5,175 | £18,050 | £20,300 | £21,825 | £24,750 | £24,825 | £27,500 | £28,050 | £28,800 | £29,675 | |
| 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 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Bill Payments | (£430) | (£120) | £8,914 | £10,214 | £11,524 | £13,070 | £13,124 | £14,670 | £14,737 | £16,702 | £17,567 | £15,965 | |
| Subtotal Spent on Operations | £7,570 | £7,880 | £16,914 | £18,214 | £19,524 | £21,070 | £21,124 | £22,670 | £22,737 | £24,702 | £25,567 | £23,965 | |
| 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 | £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,570 | £7,880 | £16,914 | £18,214 | £19,524 | £21,070 | £21,124 | £22,670 | £22,737 | £24,702 | £25,567 | £23,965 | |
| Net Cash Flow | (£7,570) | (£3,630) | (£11,739) | (£164) | £776 | £755 | £3,626 | £2,155 | £4,763 | £3,348 | £3,233 | £5,710 | |
| Cash Balance | £18,430 | £14,799 | £3,061 | £2,897 | £3,674 | £4,428 | £8,055 | £10,210 | £14,973 | £18,321 | £21,554 | £27,263 | |
| 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 | £26,000 | £18,430 | £14,799 | £3,061 | £2,897 | £3,674 | £4,428 | £8,055 | £10,210 | £14,973 | £18,321 | £21,554 | £27,263 |
| Accounts Receivable | £0 | £0 | £12,750 | £26,575 | £29,525 | £33,225 | £35,400 | £37,650 | £39,825 | £41,325 | £44,275 | £43,475 | £39,800 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £26,000 | £18,430 | £27,549 | £29,636 | £32,422 | £36,899 | £39,828 | £45,705 | £50,035 | £56,298 | £62,596 | £65,029 | £67,063 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 | £20,000 |
| Accumulated Depreciation | £0 | £238 | £476 | £714 | £952 | £1,190 | £1,428 | £1,666 | £1,904 | £2,142 | £2,380 | £2,618 | £2,856 |
| Total Long-term Assets | £20,000 | £19,762 | £19,524 | £19,286 | £19,048 | £18,810 | £18,572 | £18,334 | £18,096 | £17,858 | £17,620 | £17,382 | £17,144 |
| Total Assets | £46,000 | £38,192 | £47,073 | £48,922 | £51,470 | £55,709 | £58,400 | £64,039 | £68,131 | £74,156 | £80,216 | £82,411 | £84,207 |
| 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 | £0 | £8,990 | £10,247 | £11,503 | £13,050 | £13,050 | £14,597 | £14,597 | £16,530 | £17,448 | £15,902 | £14,307 |
| 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 | £0 | £8,990 | £10,247 | £11,503 | £13,050 | £13,050 | £14,597 | £14,597 | £16,530 | £17,448 | £15,902 | £14,307 |
| Long-term Liabilities | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Total Liabilities | £50,000 | £50,000 | £58,990 | £60,247 | £61,503 | £63,050 | £63,050 | £64,597 | £64,597 | £66,530 | £67,448 | £65,902 | £64,307 |
| Paid-in Capital | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 | £50,000 |
| Retained Earnings | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) | (£54,000) |
| Earnings | £0 | (£7,808) | (£7,917) | (£7,325) | (£6,033) | (£3,341) | (£650) | £3,442 | £7,534 | £11,626 | £16,767 | £20,509 | £23,901 |
| Total Capital | (£4,000) | (£11,808) | (£11,917) | (£11,325) | (£10,033) | (£7,341) | (£4,650) | (£558) | £3,534 | £7,626 | £12,767 | £16,509 | £19,901 |
| Total Liabilities and Capital | £46,000 | £38,192 | £47,073 | £48,922 | £51,470 | £55,709 | £58,400 | £64,039 | £68,131 | £74,156 | £80,216 | £82,411 | £84,207 |
| Net Worth | (£4,000) | (£11,808) | (£11,917) | (£11,325) | (£10,033) | (£7,341) | (£4,650) | (£558) | £3,534 | £7,626 | £12,767 | £16,509 | £19,901 |