|
|
| Sales Forecast |
| SCRAPBOOK SUPPLIES |
0% |
£3,000 |
£3,000 |
£3,000 |
£4,000 |
£4,000 |
£4,500 |
£4,500 |
£4,500 |
£4,500 |
£5,000 |
£5,000 |
£5,000 |
| CLASSES |
0% |
£1,000 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£3,000 |
£3,000 |
£3,000 |
| PAGE DESIGN |
0% |
£250 |
£500 |
£500 |
£500 |
£500 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,500 |
£1,500 |
£1,500 |
| Other |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£4,250 |
£5,000 |
£5,000 |
£6,000 |
£6,000 |
£8,100 |
£8,100 |
£8,100 |
£8,100 |
£9,500 |
£9,500 |
£9,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| SCRAPBOOK SUPPLIES |
|
£750 |
£750 |
£750 |
£1,000 |
£1,000 |
£1,125 |
£1,125 |
£1,125 |
£1,125 |
£1,250 |
£1,250 |
£1,250 |
| CLASSES |
|
£250 |
£375 |
£375 |
£375 |
£375 |
£650 |
£650 |
£650 |
£650 |
£750 |
£750 |
£750 |
| PAGE DESIGN |
|
£63 |
£125 |
£125 |
£125 |
£125 |
£250 |
£250 |
£250 |
£250 |
£375 |
£375 |
£375 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£1,063 |
£1,250 |
£1,250 |
£1,500 |
£1,500 |
£2,025 |
£2,025 |
£2,025 |
£2,025 |
£2,375 |
£2,375 |
£2,375 |
| Personnel Plan |
| Owner/Manager |
0% |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
£1,200 |
| PART-TIME HELP |
0% |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
| PART-TIME HELP |
0% |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
£700 |
| Other |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total People |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
| General Assumptions |
| 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 |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
| Tax Rate |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
| Other |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£1,063 |
£1,250 |
£1,250 |
£1,500 |
£1,500 |
£2,025 |
£2,025 |
£2,025 |
£2,025 |
£2,375 |
£2,375 |
£2,375 |
| Other Costs of Goods |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£1,063 |
£1,250 |
£1,250 |
£1,500 |
£1,500 |
£2,025 |
£2,025 |
£2,025 |
£2,025 |
£2,375 |
£2,375 |
£2,375 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£3,188 |
£3,750 |
£3,750 |
£4,500 |
£4,500 |
£6,075 |
£6,075 |
£6,075 |
£6,075 |
£7,125 |
£7,125 |
£7,125 |
| Gross Margin % |
|
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
75.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
| Sales and Marketing and Other Expenses |
|
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
| Depreciation |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Rent |
|
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
£1,500 |
| Utilities |
|
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
| Insurance |
|
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
£150 |
| Payroll Taxes |
15% |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
(£2,563) |
(£2,000) |
(£2,000) |
(£1,250) |
(£1,250) |
£325 |
£325 |
£325 |
£325 |
£1,375 |
£1,375 |
£1,375 |
| EBITDA |
|
(£2,563) |
(£2,000) |
(£2,000) |
(£1,250) |
(£1,250) |
£325 |
£325 |
£325 |
£325 |
£1,375 |
£1,375 |
£1,375 |
| Interest Expense |
|
£58 |
£57 |
£56 |
£55 |
£55 |
£54 |
£53 |
£53 |
£52 |
£51 |
£50 |
£50 |
| Taxes Incurred |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
-61.65% |
-41.14% |
-41.12% |
-21.76% |
-21.75% |
3.35% |
3.35% |
3.36% |
3.37% |
13.93% |
13.94% |
13.95% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£4,250 |
£5,000 |
£5,000 |
£6,000 |
£6,000 |
£8,100 |
£8,100 |
£8,100 |
£8,100 |
£9,500 |
£9,500 |
£9,500 |
| Subtotal Cash from Operations |
|
£4,250 |
£5,000 |
£5,000 |
£6,000 |
£6,000 |
£8,100 |
£8,100 |
£8,100 |
£8,100 |
£9,500 |
£9,500 |
£9,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£7,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 |
|
£11,250 |
£5,000 |
£5,000 |
£6,000 |
£6,000 |
£8,100 |
£8,100 |
£8,100 |
£8,100 |
£9,500 |
£9,500 |
£9,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
£2,600 |
| Bill Payments |
|
£107 |
£3,208 |
£3,207 |
£3,206 |
£3,269 |
£5,105 |
£5,123 |
£5,228 |
£5,228 |
£5,251 |
£5,948 |
£5,575 |
| Subtotal Spent on Operations |
|
£2,707 |
£5,808 |
£5,807 |
£5,806 |
£5,869 |
£7,705 |
£7,723 |
£7,828 |
£7,828 |
£7,851 |
£8,548 |
£8,175 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
£86 |
| 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 |
|
£2,793 |
£5,893 |
£5,893 |
£5,892 |
£5,954 |
£7,791 |
£7,808 |
£7,914 |
£7,913 |
£7,937 |
£8,634 |
£8,261 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£9,957 |
£9,064 |
£8,171 |
£8,280 |
£8,325 |
£8,634 |
£8,926 |
£9,112 |
£9,298 |
£10,861 |
£11,727 |
£12,966 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£1,500 |
£9,957 |
£9,064 |
£8,171 |
£8,280 |
£8,325 |
£8,634 |
£8,926 |
£9,112 |
£9,298 |
£10,861 |
£11,727 |
£12,966 |
| Inventory |
£7,000 |
£5,938 |
£4,688 |
£3,438 |
£1,938 |
£2,338 |
£2,228 |
£2,228 |
£2,228 |
£2,228 |
£2,613 |
£2,613 |
£2,613 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£8,500 |
£15,895 |
£13,752 |
£11,609 |
£10,217 |
£10,663 |
£10,862 |
£11,153 |
£11,339 |
£11,526 |
£13,474 |
£14,340 |
£15,579 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Accumulated Depreciation |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Long-term Assets |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
£2,500 |
| Total Assets |
£11,000 |
£18,395 |
£16,252 |
£14,109 |
£12,717 |
£13,163 |
£13,362 |
£13,653 |
£13,839 |
£14,026 |
£15,974 |
£16,840 |
£18,079 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£3,101 |
£3,100 |
£3,099 |
£3,099 |
£4,935 |
£4,948 |
£5,054 |
£5,053 |
£5,053 |
£5,762 |
£5,390 |
£5,389 |
| Current Borrowing |
£0 |
£6,914 |
£6,829 |
£6,743 |
£6,657 |
£6,571 |
£6,486 |
£6,400 |
£6,314 |
£6,229 |
£6,143 |
£6,057 |
£5,971 |
| Other Current Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Current Liabilities |
£0 |
£10,015 |
£9,929 |
£9,842 |
£9,756 |
£11,506 |
£11,434 |
£11,454 |
£11,368 |
£11,281 |
£11,905 |
£11,447 |
£11,360 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Liabilities |
£0 |
£10,015 |
£9,929 |
£9,842 |
£9,756 |
£11,506 |
£11,434 |
£11,454 |
£11,368 |
£11,281 |
£11,905 |
£11,447 |
£11,360 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£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 |
| Retained Earnings |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
(£9,000) |
| Earnings |
£0 |
(£2,620) |
(£4,677) |
(£6,733) |
(£8,039) |
(£9,343) |
(£9,073) |
(£8,801) |
(£8,528) |
(£8,255) |
(£6,932) |
(£5,607) |
(£4,282) |
| Total Capital |
£11,000 |
£8,380 |
£6,323 |
£4,267 |
£2,961 |
£1,657 |
£1,927 |
£2,199 |
£2,472 |
£2,745 |
£4,068 |
£5,393 |
£6,718 |
| Total Liabilities and Capital |
£11,000 |
£18,395 |
£16,252 |
£14,109 |
£12,717 |
£13,163 |
£13,362 |
£13,653 |
£13,839 |
£14,026 |
£15,974 |
£16,840 |
£18,079 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£11,000 |
£8,380 |
£6,323 |
£4,267 |
£2,961 |
£1,657 |
£1,927 |
£2,199 |
£2,472 |
£2,745 |
£4,068 |
£5,393 |
£6,718 |
|