|
|

| Sales Forecast |
| collegiate maternity t-shirts short sleeved |
0% |
1,000 |
1,500 |
2,000 |
5,000 |
6,000 |
4,000 |
3,000 |
2,000 |
3,000 |
3,000 |
3,000 |
3,000 |
| Other |
0% |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| Total Unit Sales |
|
1,000 |
1,500 |
2,000 |
5,000 |
6,000 |
4,000 |
3,000 |
2,000 |
3,000 |
3,000 |
3,000 |
3,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| collegiate maternity t-shirts short sleeved |
|
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
£29.99 |
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| collegiate maternity t-shirts short sleeved |
|
£29,990 |
£44,985 |
£59,980 |
£149,950 |
£179,940 |
£119,960 |
£89,970 |
£59,980 |
£89,970 |
£89,970 |
£89,970 |
£89,970 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£29,990 |
£44,985 |
£59,980 |
£149,950 |
£179,940 |
£119,960 |
£89,970 |
£59,980 |
£89,970 |
£89,970 |
£89,970 |
£89,970 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| collegiate maternity t-shirts short sleeved |
25.00% |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
£7.50 |
| Other |
25.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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| collegiate maternity t-shirts short sleeved |
|
£7,498 |
£11,246 |
£14,995 |
£37,488 |
£44,985 |
£29,990 |
£22,493 |
£14,995 |
£22,493 |
£22,493 |
£22,493 |
£22,493 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£7,498 |
£11,246 |
£14,995 |
£37,488 |
£44,985 |
£29,990 |
£22,493 |
£14,995 |
£22,493 |
£22,493 |
£22,493 |
£22,493 |
| Personnel Plan |
| Owner |
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 |
| Fulfillment Representative 1 |
0% |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Fulfillment Representative 2 |
0% |
£0 |
£0 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Total People |
|
2 |
2 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£4,000 |
£4,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£7,498 |
£11,246 |
£14,995 |
£37,488 |
£44,985 |
£29,990 |
£22,493 |
£14,995 |
£22,493 |
£22,493 |
£22,493 |
£22,493 |
| Other Costs of Sales |
|
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Total Cost of Sales |
|
£12,498 |
£16,246 |
£19,995 |
£42,488 |
£49,985 |
£34,990 |
£27,493 |
£19,995 |
£27,493 |
£27,493 |
£27,493 |
£27,493 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£17,493 |
£28,739 |
£39,985 |
£107,463 |
£129,955 |
£84,970 |
£62,478 |
£39,985 |
£62,478 |
£62,478 |
£62,478 |
£62,478 |
| Gross Margin % |
|
58.33% |
63.89% |
66.66% |
71.67% |
72.22% |
70.83% |
69.44% |
66.66% |
69.44% |
69.44% |
69.44% |
69.44% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£4,000 |
£4,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Marketing/Promotion |
|
£15,000 |
£20,000 |
£25,000 |
£25,000 |
£25,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
£10,000 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Web Design and Maintenance |
|
£3,000 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Payroll Taxes |
15% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other |
|
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
(£6,508) |
£2,739 |
£7,985 |
£75,463 |
£97,955 |
£67,970 |
£45,478 |
£22,985 |
£45,478 |
£45,478 |
£45,478 |
£45,478 |
| EBITDA |
|
(£6,508) |
£2,739 |
£7,985 |
£75,463 |
£97,955 |
£67,970 |
£45,478 |
£22,985 |
£45,478 |
£45,478 |
£45,478 |
£45,478 |
| Interest Expense |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Taxes Incurred |
|
(£1,952) |
£822 |
£2,396 |
£22,639 |
£29,387 |
£20,391 |
£13,643 |
£6,896 |
£13,643 |
£13,643 |
£13,643 |
£13,643 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
-15.19% |
4.26% |
9.32% |
35.23% |
38.11% |
39.66% |
35.38% |
26.82% |
35.38% |
35.38% |
35.38% |
35.38% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£29,990 |
£44,985 |
£59,980 |
£149,950 |
£179,940 |
£119,960 |
£89,970 |
£59,980 |
£89,970 |
£89,970 |
£89,970 |
£89,970 |
| Subtotal Cash from Operations |
|
£29,990 |
£44,985 |
£59,980 |
£149,950 |
£179,940 |
£119,960 |
£89,970 |
£59,980 |
£89,970 |
£89,970 |
£89,970 |
£89,970 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£29,990 |
£44,985 |
£59,980 |
£149,950 |
£179,940 |
£119,960 |
£89,970 |
£59,980 |
£89,970 |
£89,970 |
£89,970 |
£89,970 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£4,000 |
£4,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
| Bill Payments |
|
£768 |
£23,207 |
£28,499 |
£50,346 |
£114,594 |
£111,820 |
£52,161 |
£45,163 |
£32,368 |
£60,383 |
£53,136 |
£53,136 |
| Subtotal Spent on Operations |
|
£4,768 |
£27,207 |
£33,499 |
£55,346 |
£119,594 |
£116,820 |
£57,161 |
£50,163 |
£37,368 |
£65,383 |
£58,136 |
£58,136 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£4,768 |
£27,207 |
£33,499 |
£55,346 |
£119,594 |
£116,820 |
£57,161 |
£50,163 |
£37,368 |
£65,383 |
£58,136 |
£58,136 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£30,222 |
£48,000 |
£74,481 |
£169,086 |
£229,432 |
£232,572 |
£265,381 |
£275,198 |
£327,800 |
£352,387 |
£384,221 |
£416,055 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£5,000 |
£30,222 |
£48,000 |
£74,481 |
£169,086 |
£229,432 |
£232,572 |
£265,381 |
£275,198 |
£327,800 |
£352,387 |
£384,221 |
£416,055 |
| Inventory |
£35,000 |
£27,503 |
£16,256 |
£14,995 |
£37,488 |
£44,985 |
£29,990 |
£22,493 |
£14,995 |
£22,493 |
£22,493 |
£22,493 |
£22,493 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£40,000 |
£57,724 |
£64,256 |
£89,476 |
£206,573 |
£274,417 |
£262,562 |
£287,874 |
£290,193 |
£350,293 |
£374,879 |
£406,714 |
£438,548 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£40,000 |
£57,724 |
£64,256 |
£89,476 |
£206,573 |
£274,417 |
£262,562 |
£287,874 |
£290,193 |
£350,293 |
£374,879 |
£406,714 |
£438,548 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£22,279 |
£26,894 |
£46,525 |
£110,798 |
£110,073 |
£50,640 |
£44,117 |
£30,347 |
£58,612 |
£51,365 |
£51,365 |
£51,365 |
| 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 |
£22,279 |
£26,894 |
£46,525 |
£110,798 |
£110,073 |
£50,640 |
£44,117 |
£30,347 |
£58,612 |
£51,365 |
£51,365 |
£51,365 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Liabilities |
£0 |
£22,279 |
£26,894 |
£46,525 |
£110,798 |
£110,073 |
£50,640 |
£44,117 |
£30,347 |
£58,612 |
£51,365 |
£51,365 |
£51,365 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
£63,750 |
| Retained Earnings |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
(£23,750) |
| Earnings |
£0 |
(£4,555) |
(£2,638) |
£2,951 |
£55,775 |
£124,344 |
£171,923 |
£203,757 |
£219,846 |
£251,681 |
£283,515 |
£315,349 |
£347,183 |
| Total Capital |
£40,000 |
£35,445 |
£37,362 |
£42,951 |
£95,775 |
£164,344 |
£211,923 |
£243,757 |
£259,846 |
£291,681 |
£323,515 |
£355,349 |
£387,183 |
| Total Liabilities and Capital |
£40,000 |
£57,724 |
£64,256 |
£89,476 |
£206,573 |
£274,417 |
£262,562 |
£287,874 |
£290,193 |
£350,293 |
£374,879 |
£406,714 |
£438,548 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£40,000 |
£35,445 |
£37,362 |
£42,951 |
£95,775 |
£164,344 |
£211,923 |
£243,757 |
£259,846 |
£291,681 |
£323,515 |
£355,349 |
£387,183 |
|