| 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 | ||
| Unit Sales | |||||||||||||
| Propery Insurance | 25 | 29 | 32 | 37 | 42 | 48 | 55 | 63 | 71 | 81 | 93 | 106 | |
| Life Insurance | 12 | 13 | 15 | 17 | 20 | 22 | 25 | 28 | 37 | 38 | 42 | 49 | |
| Long Term Care/Disability | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | 5 | 6 | 8 | |
| Valuable Items | 13 | 15 | 17 | 20 | 23 | 26 | 29 | 33 | 38 | 43 | 49 | 57 | |
| Personal Liability | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 7 | 11 | 15 | 18 | |
| Total Unit Sales | 50 | 57 | 64 | 74 | 85 | 97 | 112 | 130 | 156 | 178 | 205 | 238 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Propery Insurance | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | |
| Life Insurance | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | |
| Long Term Care/Disability | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | |
| Valuable Items | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | |
| Personal Liability | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | |
| Sales | |||||||||||||
| Propery Insurance | £2,500 | £2,900 | £3,200 | £3,700 | £4,200 | £4,800 | £5,500 | £6,300 | £7,100 | £8,100 | £9,300 | £10,600 | |
| Life Insurance | £1,800 | £1,950 | £2,250 | £2,550 | £3,000 | £3,300 | £3,750 | £4,200 | £5,550 | £5,700 | £6,300 | £7,350 | |
| Long Term Care/Disability | £0 | £0 | £0 | £0 | £0 | £150 | £150 | £300 | £450 | £750 | £900 | £1,200 | |
| Valuable Items | £975 | £1,125 | £1,275 | £1,500 | £1,725 | £1,950 | £2,175 | £2,475 | £2,850 | £3,225 | £3,675 | £4,275 | |
| Personal Liability | £0 | £0 | £0 | £0 | £0 | £0 | £150 | £300 | £525 | £825 | £1,125 | £1,350 | |
| Total Sales | £5,275 | £5,975 | £6,725 | £7,750 | £8,925 | £10,200 | £11,725 | £13,575 | £16,475 | £18,600 | £21,300 | £24,775 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Propery Insurance | 16.00% | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 |
| Life Insurance | 16.00% | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 |
| Long Term Care/Disability | 16.00% | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 |
| Valuable Items | 16.00% | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 |
| Personal Liability | 16.00% | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 |
| Direct Cost of Sales | |||||||||||||
| Propery Insurance | £400 | £464 | £512 | £592 | £672 | £768 | £880 | £1,008 | £1,136 | £1,296 | £1,488 | £1,696 | |
| Life Insurance | £288 | £312 | £360 | £408 | £480 | £528 | £600 | £672 | £888 | £912 | £1,008 | £1,176 | |
| Long Term Care/Disability | £0 | £0 | £0 | £0 | £0 | £24 | £24 | £48 | £72 | £120 | £144 | £192 | |
| Valuable Items | £156 | £180 | £204 | £240 | £276 | £312 | £348 | £396 | £456 | £516 | £588 | £684 | |
| Personal Liability | £0 | £0 | £0 | £0 | £0 | £0 | £24 | £48 | £84 | £132 | £180 | £216 | |
| Subtotal Direct Cost of Sales | £844 | £956 | £1,076 | £1,240 | £1,428 | £1,632 | £1,876 | £2,172 | £2,636 | £2,976 | £3,408 | £3,964 | |
| 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 | ||
| Kolem Plynthe | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Associate Agent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £5,275 | £5,975 | £6,725 | £7,750 | £8,925 | £10,200 | £11,725 | £13,575 | £16,475 | £18,600 | £21,300 | £24,775 | |
| Direct Cost of Sales | £844 | £956 | £1,076 | £1,240 | £1,428 | £1,632 | £1,876 | £2,172 | £2,636 | £2,976 | £3,408 | £3,964 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £844 | £956 | £1,076 | £1,240 | £1,428 | £1,632 | £1,876 | £2,172 | £2,636 | £2,976 | £3,408 | £3,964 | |
| Gross Margin | £4,431 | £5,019 | £5,649 | £6,510 | £7,497 | £8,568 | £9,849 | £11,403 | £13,839 | £15,624 | £17,892 | £20,811 | |
| Gross Margin % | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Marketing/Promotion | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £450 | £450 | £450 | £600 | £600 | £600 | £600 | £600 | £750 | £750 | £750 | £750 |
| Education | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Total Operating Expenses | £6,300 | £6,300 | £6,300 | £7,450 | £7,450 | £7,450 | £7,450 | £7,450 | £8,600 | £8,600 | £8,600 | £8,600 | |
| Profit Before Interest and Taxes | (£1,869) | (£1,281) | (£651) | (£940) | £47 | £1,118 | £2,399 | £3,953 | £5,239 | £7,024 | £9,292 | £12,211 | |
| EBITDA | (£1,869) | (£1,281) | (£651) | (£940) | £47 | £1,118 | £2,399 | £3,953 | £5,239 | £7,024 | £9,292 | £12,211 | |
| Interest Expense | £48 | £45 | £42 | £39 | £35 | £32 | £27 | £23 | £18 | £12 | £6 | £0 | |
| Taxes Incurred | (£575) | (£398) | (£208) | (£294) | £3 | £326 | £712 | £1,179 | £1,566 | £2,103 | £2,786 | £3,663 | |
| Net Profit | (£1,342) | (£928) | (£485) | (£685) | £8 | £761 | £1,660 | £2,751 | £3,655 | £4,908 | £6,500 | £8,548 | |
| Net Profit/Sales | -25.44% | -15.54% | -7.21% | -8.84% | 0.09% | 7.46% | 14.16% | 20.27% | 22.18% | 26.39% | 30.52% | 34.50% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £176 | £5,298 | £6,000 | £6,759 | £7,789 | £8,968 | £10,251 | £11,787 | £13,672 | £16,546 | £18,690 | |
| Subtotal Cash from Operations | £0 | £176 | £5,298 | £6,000 | £6,759 | £7,789 | £8,968 | £10,251 | £11,787 | £13,672 | £16,546 | £18,690 | |
| 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 | £176 | £5,298 | £6,000 | £6,759 | £7,789 | £8,968 | £10,251 | £11,787 | £13,672 | £16,546 | £18,690 | |
| 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 | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £1,121 | £3,626 | £3,913 | £4,218 | £4,451 | £4,934 | £5,460 | £6,090 | £6,857 | £7,849 | £8,729 | £9,848 | |
| Subtotal Spent on Operations | £4,121 | £6,626 | £6,913 | £8,218 | £8,451 | £8,934 | £9,460 | £10,090 | £11,857 | £12,849 | £13,729 | £14,848 | |
| 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 | £175 | £218 | £238 | £259 | £282 | £307 | £335 | £365 | £398 | £434 | £473 | £516 | |
| 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 | £4,296 | £6,844 | £7,151 | £8,477 | £8,733 | £9,241 | £9,795 | £10,455 | £12,255 | £13,283 | £14,202 | £15,364 | |
| Net Cash Flow | (£4,296) | (£6,668) | (£1,853) | (£2,477) | (£1,974) | (£1,452) | (£828) | (£204) | (£468) | £388 | £2,344 | £3,326 | |
| Cash Balance | £19,704 | £13,036 | £11,183 | £8,706 | £6,732 | £5,280 | £4,452 | £4,248 | £3,779 | £4,168 | £6,512 | £9,838 | |
| 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 | £24,000 | £19,704 | £13,036 | £11,183 | £8,706 | £6,732 | £5,280 | £4,452 | £4,248 | £3,779 | £4,168 | £6,512 | £9,838 |
| Accounts Receivable | £0 | £5,275 | £11,074 | £12,501 | £14,251 | £16,417 | £18,827 | £21,585 | £24,909 | £29,598 | £34,526 | £39,280 | £45,365 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £24,000 | £24,979 | £24,110 | £23,684 | £22,957 | £23,149 | £24,107 | £26,037 | £29,157 | £33,377 | £38,694 | £45,792 | £55,203 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £24,000 | £24,979 | £24,110 | £23,684 | £22,957 | £23,149 | £24,107 | £26,037 | £29,157 | £33,377 | £38,694 | £45,792 | £55,203 |
| 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 | £1,000 | £3,496 | £3,773 | £4,070 | £4,287 | £4,753 | £5,258 | £5,863 | £6,596 | £7,559 | £8,402 | £9,473 | £10,853 |
| Current Borrowing | £4,000 | £3,825 | £3,607 | £3,369 | £3,110 | £2,828 | £2,521 | £2,186 | £1,821 | £1,423 | £989 | £516 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £7,321 | £7,380 | £7,439 | £7,397 | £7,581 | £7,779 | £8,049 | £8,417 | £8,982 | £9,391 | £9,989 | £10,853 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £5,000 | £7,321 | £7,380 | £7,439 | £7,397 | £7,581 | £7,779 | £8,049 | £8,417 | £8,982 | £9,391 | £9,989 | £10,853 |
| Paid-in Capital | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 |
| Retained Earnings | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) |
| Earnings | £0 | (£1,342) | (£2,270) | (£2,755) | (£3,440) | (£3,432) | (£2,672) | (£1,012) | £1,740 | £5,394 | £10,303 | £16,802 | £25,350 |
| Total Capital | £19,000 | £17,658 | £16,730 | £16,245 | £15,560 | £15,568 | £16,328 | £17,988 | £20,740 | £24,394 | £29,303 | £35,802 | £44,350 |
| Total Liabilities and Capital | £24,000 | £24,979 | £24,110 | £23,684 | £22,957 | £23,149 | £24,107 | £26,037 | £29,157 | £33,377 | £38,694 | £45,792 | £55,203 |
| Net Worth | £19,000 | £17,658 | £16,730 | £16,245 | £15,560 | £15,568 | £16,328 | £17,988 | £20,740 | £24,394 | £29,303 | £35,802 | £44,350 |
| 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 | ||
| Unit Sales | |||||||||||||
| Propery Insurance | 25 | 29 | 32 | 37 | 42 | 48 | 55 | 63 | 71 | 81 | 93 | 106 | |
| Life Insurance | 12 | 13 | 15 | 17 | 20 | 22 | 25 | 28 | 37 | 38 | 42 | 49 | |
| Long Term Care/Disability | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | 5 | 6 | 8 | |
| Valuable Items | 13 | 15 | 17 | 20 | 23 | 26 | 29 | 33 | 38 | 43 | 49 | 57 | |
| Personal Liability | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 7 | 11 | 15 | 18 | |
| Total Unit Sales | 50 | 57 | 64 | 74 | 85 | 97 | 112 | 130 | 156 | 178 | 205 | 238 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Propery Insurance | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | £100.00 | |
| Life Insurance | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | |
| Long Term Care/Disability | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | £150.00 | |
| Valuable Items | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | |
| Personal Liability | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | £75.00 | |
| Sales | |||||||||||||
| Propery Insurance | £2,500 | £2,900 | £3,200 | £3,700 | £4,200 | £4,800 | £5,500 | £6,300 | £7,100 | £8,100 | £9,300 | £10,600 | |
| Life Insurance | £1,800 | £1,950 | £2,250 | £2,550 | £3,000 | £3,300 | £3,750 | £4,200 | £5,550 | £5,700 | £6,300 | £7,350 | |
| Long Term Care/Disability | £0 | £0 | £0 | £0 | £0 | £150 | £150 | £300 | £450 | £750 | £900 | £1,200 | |
| Valuable Items | £975 | £1,125 | £1,275 | £1,500 | £1,725 | £1,950 | £2,175 | £2,475 | £2,850 | £3,225 | £3,675 | £4,275 | |
| Personal Liability | £0 | £0 | £0 | £0 | £0 | £0 | £150 | £300 | £525 | £825 | £1,125 | £1,350 | |
| Total Sales | £5,275 | £5,975 | £6,725 | £7,750 | £8,925 | £10,200 | £11,725 | £13,575 | £16,475 | £18,600 | £21,300 | £24,775 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Propery Insurance | 16.00% | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 | £16.00 |
| Life Insurance | 16.00% | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 |
| Long Term Care/Disability | 16.00% | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 | £24.00 |
| Valuable Items | 16.00% | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 |
| Personal Liability | 16.00% | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 | £12.00 |
| Direct Cost of Sales | |||||||||||||
| Propery Insurance | £400 | £464 | £512 | £592 | £672 | £768 | £880 | £1,008 | £1,136 | £1,296 | £1,488 | £1,696 | |
| Life Insurance | £288 | £312 | £360 | £408 | £480 | £528 | £600 | £672 | £888 | £912 | £1,008 | £1,176 | |
| Long Term Care/Disability | £0 | £0 | £0 | £0 | £0 | £24 | £24 | £48 | £72 | £120 | £144 | £192 | |
| Valuable Items | £156 | £180 | £204 | £240 | £276 | £312 | £348 | £396 | £456 | £516 | £588 | £684 | |
| Personal Liability | £0 | £0 | £0 | £0 | £0 | £0 | £24 | £48 | £84 | £132 | £180 | £216 | |
| Subtotal Direct Cost of Sales | £844 | £956 | £1,076 | £1,240 | £1,428 | £1,632 | £1,876 | £2,172 | £2,636 | £2,976 | £3,408 | £3,964 | |
| 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 | ||
| Kolem Plynthe | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Associate Agent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total People | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |
| Total Payroll | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| 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 | £5,275 | £5,975 | £6,725 | £7,750 | £8,925 | £10,200 | £11,725 | £13,575 | £16,475 | £18,600 | £21,300 | £24,775 | |
| Direct Cost of Sales | £844 | £956 | £1,076 | £1,240 | £1,428 | £1,632 | £1,876 | £2,172 | £2,636 | £2,976 | £3,408 | £3,964 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £844 | £956 | £1,076 | £1,240 | £1,428 | £1,632 | £1,876 | £2,172 | £2,636 | £2,976 | £3,408 | £3,964 | |
| Gross Margin | £4,431 | £5,019 | £5,649 | £6,510 | £7,497 | £8,568 | £9,849 | £11,403 | £13,839 | £15,624 | £17,892 | £20,811 | |
| Gross Margin % | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | 84.00% | |
| Expenses | |||||||||||||
| Payroll | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Marketing/Promotion | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Rent | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Utilities | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Insurance | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Payroll Taxes | 15% | £450 | £450 | £450 | £600 | £600 | £600 | £600 | £600 | £750 | £750 | £750 | £750 |
| Education | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Total Operating Expenses | £6,300 | £6,300 | £6,300 | £7,450 | £7,450 | £7,450 | £7,450 | £7,450 | £8,600 | £8,600 | £8,600 | £8,600 | |
| Profit Before Interest and Taxes | (£1,869) | (£1,281) | (£651) | (£940) | £47 | £1,118 | £2,399 | £3,953 | £5,239 | £7,024 | £9,292 | £12,211 | |
| EBITDA | (£1,869) | (£1,281) | (£651) | (£940) | £47 | £1,118 | £2,399 | £3,953 | £5,239 | £7,024 | £9,292 | £12,211 | |
| Interest Expense | £48 | £45 | £42 | £39 | £35 | £32 | £27 | £23 | £18 | £12 | £6 | £0 | |
| Taxes Incurred | (£575) | (£398) | (£208) | (£294) | £3 | £326 | £712 | £1,179 | £1,566 | £2,103 | £2,786 | £3,663 | |
| Net Profit | (£1,342) | (£928) | (£485) | (£685) | £8 | £761 | £1,660 | £2,751 | £3,655 | £4,908 | £6,500 | £8,548 | |
| Net Profit/Sales | -25.44% | -15.54% | -7.21% | -8.84% | 0.09% | 7.46% | 14.16% | 20.27% | 22.18% | 26.39% | 30.52% | 34.50% | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Cash from Receivables | £0 | £176 | £5,298 | £6,000 | £6,759 | £7,789 | £8,968 | £10,251 | £11,787 | £13,672 | £16,546 | £18,690 | |
| Subtotal Cash from Operations | £0 | £176 | £5,298 | £6,000 | £6,759 | £7,789 | £8,968 | £10,251 | £11,787 | £13,672 | £16,546 | £18,690 | |
| 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 | £176 | £5,298 | £6,000 | £6,759 | £7,789 | £8,968 | £10,251 | £11,787 | £13,672 | £16,546 | £18,690 | |
| 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 | £3,000 | £3,000 | £3,000 | £4,000 | £4,000 | £4,000 | £4,000 | £4,000 | £5,000 | £5,000 | £5,000 | £5,000 | |
| Bill Payments | £1,121 | £3,626 | £3,913 | £4,218 | £4,451 | £4,934 | £5,460 | £6,090 | £6,857 | £7,849 | £8,729 | £9,848 | |
| Subtotal Spent on Operations | £4,121 | £6,626 | £6,913 | £8,218 | £8,451 | £8,934 | £9,460 | £10,090 | £11,857 | £12,849 | £13,729 | £14,848 | |
| 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 | £175 | £218 | £238 | £259 | £282 | £307 | £335 | £365 | £398 | £434 | £473 | £516 | |
| 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 | £4,296 | £6,844 | £7,151 | £8,477 | £8,733 | £9,241 | £9,795 | £10,455 | £12,255 | £13,283 | £14,202 | £15,364 | |
| Net Cash Flow | (£4,296) | (£6,668) | (£1,853) | (£2,477) | (£1,974) | (£1,452) | (£828) | (£204) | (£468) | £388 | £2,344 | £3,326 | |
| Cash Balance | £19,704 | £13,036 | £11,183 | £8,706 | £6,732 | £5,280 | £4,452 | £4,248 | £3,779 | £4,168 | £6,512 | £9,838 | |
| 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 | £24,000 | £19,704 | £13,036 | £11,183 | £8,706 | £6,732 | £5,280 | £4,452 | £4,248 | £3,779 | £4,168 | £6,512 | £9,838 |
| Accounts Receivable | £0 | £5,275 | £11,074 | £12,501 | £14,251 | £16,417 | £18,827 | £21,585 | £24,909 | £29,598 | £34,526 | £39,280 | £45,365 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £24,000 | £24,979 | £24,110 | £23,684 | £22,957 | £23,149 | £24,107 | £26,037 | £29,157 | £33,377 | £38,694 | £45,792 | £55,203 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Long-term Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Assets | £24,000 | £24,979 | £24,110 | £23,684 | £22,957 | £23,149 | £24,107 | £26,037 | £29,157 | £33,377 | £38,694 | £45,792 | £55,203 |
| 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 | £1,000 | £3,496 | £3,773 | £4,070 | £4,287 | £4,753 | £5,258 | £5,863 | £6,596 | £7,559 | £8,402 | £9,473 | £10,853 |
| Current Borrowing | £4,000 | £3,825 | £3,607 | £3,369 | £3,110 | £2,828 | £2,521 | £2,186 | £1,821 | £1,423 | £989 | £516 | £0 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £5,000 | £7,321 | £7,380 | £7,439 | £7,397 | £7,581 | £7,779 | £8,049 | £8,417 | £8,982 | £9,391 | £9,989 | £10,853 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £5,000 | £7,321 | £7,380 | £7,439 | £7,397 | £7,581 | £7,779 | £8,049 | £8,417 | £8,982 | £9,391 | £9,989 | £10,853 |
| Paid-in Capital | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 | £27,000 |
| Retained Earnings | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) | (£8,000) |
| Earnings | £0 | (£1,342) | (£2,270) | (£2,755) | (£3,440) | (£3,432) | (£2,672) | (£1,012) | £1,740 | £5,394 | £10,303 | £16,802 | £25,350 |
| Total Capital | £19,000 | £17,658 | £16,730 | £16,245 | £15,560 | £15,568 | £16,328 | £17,988 | £20,740 | £24,394 | £29,303 | £35,802 | £44,350 |
| Total Liabilities and Capital | £24,000 | £24,979 | £24,110 | £23,684 | £22,957 | £23,149 | £24,107 | £26,037 | £29,157 | £33,377 | £38,694 | £45,792 | £55,203 |
| Net Worth | £19,000 | £17,658 | £16,730 | £16,245 | £15,560 | £15,568 | £16,328 | £17,988 | £20,740 | £24,394 | £29,303 | £35,802 | £44,350 |