|
|

| Sales Forecast |
| COBRA/HIPAA |
0% |
0 |
0 |
0 |
20 |
25 |
30 |
35 |
40 |
45 |
50 |
55 |
60 |
| Flexible Spending |
0% |
0 |
0 |
0 |
10 |
10 |
10 |
10 |
10 |
10 |
40 |
40 |
40 |
| Basic Admin |
0% |
0 |
0 |
0 |
100 |
100 |
100 |
200 |
200 |
200 |
400 |
400 |
400 |
| All Inclusive |
0% |
0 |
0 |
0 |
100 |
100 |
100 |
200 |
200 |
200 |
400 |
400 |
400 |
| Start-up Fees |
0% |
0 |
0 |
0 |
65 |
5 |
5 |
45 |
5 |
5 |
100 |
5 |
5 |
| Total Unit Sales |
|
0 |
0 |
0 |
295 |
240 |
245 |
490 |
455 |
460 |
990 |
900 |
905 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| COBRA/HIPAA |
|
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
£12.75 |
| Flexible Spending |
|
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
| Basic Admin |
|
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
£12.00 |
| All Inclusive |
|
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
£18.00 |
| Start-up Fees |
|
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
£100.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| COBRA/HIPAA |
|
£0 |
£0 |
£0 |
£255 |
£319 |
£383 |
£446 |
£510 |
£574 |
£638 |
£701 |
£765 |
| Flexible Spending |
|
£0 |
£0 |
£0 |
£75 |
£75 |
£75 |
£75 |
£75 |
£75 |
£300 |
£300 |
£300 |
| Basic Admin |
|
£0 |
£0 |
£0 |
£1,200 |
£1,200 |
£1,200 |
£2,400 |
£2,400 |
£2,400 |
£4,800 |
£4,800 |
£4,800 |
| All Inclusive |
|
£0 |
£0 |
£0 |
£1,800 |
£1,800 |
£1,800 |
£3,600 |
£3,600 |
£3,600 |
£7,200 |
£7,200 |
£7,200 |
| Start-up Fees |
|
£0 |
£0 |
£0 |
£6,500 |
£500 |
£500 |
£4,500 |
£500 |
£500 |
£10,000 |
£500 |
£500 |
| Total Sales |
|
£0 |
£0 |
£0 |
£9,830 |
£3,894 |
£3,958 |
£11,021 |
£7,085 |
£7,149 |
£22,938 |
£13,501 |
£13,565 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| COBRA/HIPAA |
0.00% |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
| Flexible Spending |
0.00% |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
| Basic Admin |
0.00% |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
| All Inclusive |
0.00% |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
£2.75 |
| Start-up Fees |
0.00% |
£2.75 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
£0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| COBRA/HIPAA |
|
£0 |
£0 |
£0 |
£55 |
£69 |
£83 |
£96 |
£110 |
£124 |
£138 |
£151 |
£165 |
| Flexible Spending |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Basic Admin |
|
£0 |
£0 |
£0 |
£275 |
£275 |
£275 |
£550 |
£550 |
£550 |
£1,100 |
£1,100 |
£1,100 |
| All Inclusive |
|
£0 |
£0 |
£0 |
£275 |
£275 |
£275 |
£550 |
£550 |
£550 |
£1,100 |
£1,100 |
£1,100 |
| Start-up Fees |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£0 |
£0 |
£0 |
£605 |
£619 |
£633 |
£1,196 |
£1,210 |
£1,224 |
£2,338 |
£2,351 |
£2,365 |

| Personnel Plan |
| 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 |
| 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 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Marketer Part Time |
|
£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 |
| 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 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cindy Wells |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Diane Davis |
|
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Administrative Assistant Part Time |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,084 |
£1,084 |
£1,084 |
| Benefits Administrator |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Receptionist Part Time |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Benefits Administrator |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£6,084 |
£6,084 |
£6,084 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
| 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 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total People |
|
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
3 |
3 |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£6,084 |
£6,084 |
£6,084 |
| General Assumptions |
| Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
| Current 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% |
| Long-term Interest Rate |
|
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.00% |
8.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 |
| Direct Cost of Sales |
|
£0 |
£0 |
£0 |
£605 |
£619 |
£633 |
£1,196 |
£1,210 |
£1,224 |
£2,338 |
£2,351 |
£2,365 |
| Production Payroll |
|
£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 |
| Total Cost of Sales |
|
£0 |
£0 |
£0 |
£605 |
£619 |
£633 |
£1,196 |
£1,210 |
£1,224 |
£2,338 |
£2,351 |
£2,365 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£0 |
£0 |
£0 |
£9,225 |
£3,275 |
£3,325 |
£9,825 |
£5,875 |
£5,925 |
£20,600 |
£11,150 |
£11,200 |
| Gross Margin % |
|
0.00% |
0.00% |
0.00% |
93.85% |
84.11% |
84.02% |
89.15% |
82.92% |
82.88% |
89.81% |
82.58% |
82.57% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales and Marketing Payroll |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Advertising/Promotion |
|
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Travel |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Miscellaneous |
|
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
| Total Sales and Marketing Expenses |
|
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
| Sales and Marketing % |
|
0.00% |
0.00% |
0.00% |
1.53% |
3.85% |
3.79% |
1.36% |
2.12% |
2.10% |
0.65% |
1.11% |
1.11% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| General and Administrative Payroll |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£6,084 |
£6,084 |
£6,084 |
| Sales and Marketing and Other Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
|
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
£85 |
| Dues and Subscriptions |
|
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
| Professional Fees |
|
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
£50 |
| Rent |
|
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
£600 |
| Software Purchases |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Insurance |
|
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
£100 |
| Telephone and Internet Access |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Utilities |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Miscellaneous |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Payroll Taxes |
8% |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£487 |
£487 |
£487 |
| Other General and Administrative Expenses |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total General and Administrative Expenses |
|
£6,985 |
£6,985 |
£6,985 |
£6,985 |
£6,985 |
£6,985 |
£6,985 |
£6,985 |
£6,985 |
£8,156 |
£8,156 |
£8,156 |
| General and Administrative % |
|
0.00% |
0.00% |
0.00% |
71.06% |
179.39% |
176.50% |
63.38% |
98.59% |
97.71% |
35.56% |
60.41% |
60.12% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Other Payroll |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| 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 |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other % |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
(£7,135) |
(£7,135) |
(£7,135) |
£2,090 |
(£3,860) |
(£3,810) |
£2,690 |
(£1,260) |
(£1,210) |
£12,294 |
£2,844 |
£2,894 |
| EBITDA |
|
(£7,050) |
(£7,050) |
(£7,050) |
£2,175 |
(£3,775) |
(£3,725) |
£2,775 |
(£1,175) |
(£1,125) |
£12,379 |
£2,929 |
£2,979 |
| Interest Expense |
|
£0 |
£375 |
£375 |
£370 |
£365 |
£360 |
£355 |
£350 |
£345 |
£339 |
£334 |
£329 |
| Taxes Incurred |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
0.00% |
0.00% |
0.00% |
17.50% |
-108.51% |
-105.37% |
21.19% |
-22.72% |
-21.75% |
52.12% |
18.59% |
18.91% |
| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£0 |
£0 |
£0 |
£0 |
| |