|
|
| Sales Forecast |
| All Products |
0% |
£13,351 |
£12,271 |
£12,421 |
£15,099 |
£14,370 |
£15,850 |
£14,350 |
£13,800 |
£14,112 |
£13,643 |
£13,100 |
£16,235 |
| Other |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£13,351 |
£12,271 |
£12,421 |
£15,099 |
£14,370 |
£15,850 |
£14,350 |
£13,800 |
£14,112 |
£13,643 |
£13,100 |
£16,235 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| All Products |
|
£3,981 |
£3,726 |
£6,924 |
£4,659 |
£5,093 |
£5,615 |
£5,925 |
£6,173 |
£5,313 |
£5,500 |
£5,875 |
£6,132 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£3,981 |
£3,726 |
£6,924 |
£4,659 |
£5,093 |
£5,615 |
£5,925 |
£6,173 |
£5,313 |
£5,500 |
£5,875 |
£6,132 |
| Personnel Plan |
| Patricia Torres |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
| Ricardo Torres |
0% |
£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 |
£0 |
| Total People |
|
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£3,981 |
£3,726 |
£6,924 |
£4,659 |
£5,093 |
£5,615 |
£5,925 |
£6,173 |
£5,313 |
£5,500 |
£5,875 |
£6,132 |
| Other Costs of Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£3,981 |
£3,726 |
£6,924 |
£4,659 |
£5,093 |
£5,615 |
£5,925 |
£6,173 |
£5,313 |
£5,500 |
£5,875 |
£6,132 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£9,370 |
£8,545 |
£5,497 |
£10,440 |
£9,277 |
£10,235 |
£8,425 |
£7,627 |
£8,799 |
£8,143 |
£7,225 |
£10,103 |
| Gross Margin % |
|
70.18% |
69.64% |
44.26% |
69.14% |
64.56% |
64.57% |
58.71% |
55.27% |
62.35% |
59.69% |
55.15% |
62.23% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
| Marketing/Promotion |
|
£466 |
£722 |
£330 |
£845 |
£335 |
£435 |
£595 |
£470 |
£800 |
£470 |
£675 |
£620 |
| Depreciation |
|
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
£460 |
| Rent |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
£500 |
| Utilities |
|
£315 |
£400 |
£315 |
£300 |
£315 |
£315 |
£315 |
£315 |
£315 |
£315 |
£315 |
£315 |
| Leased Equipment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£65 |
£0 |
£0 |
£75 |
£0 |
£325 |
£0 |
| Insurance |
|
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
£87 |
| Payroll Taxes |
15% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other |
|
£167 |
£1,591 |
£118 |
£614 |
£225 |
£225 |
£225 |
£225 |
£225 |
£225 |
£225 |
£225 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
£7,875 |
£5,285 |
£4,187 |
£8,134 |
£7,855 |
£8,148 |
£6,243 |
£3,650 |
£4,417 |
£4,166 |
£2,718 |
£5,976 |
| EBITDA |
|
£8,335 |
£5,745 |
£4,647 |
£8,594 |
£8,315 |
£8,608 |
£6,703 |
£4,110 |
£4,877 |
£4,626 |
£3,178 |
£6,436 |
| Interest Expense |
|
£67 |
£67 |
£754 |
£753 |
£753 |
£752 |
£751 |
£743 |
£735 |
£727 |
£719 |
£710 |
| Taxes Incurred |
|
£1,952 |
£1,305 |
£858 |
£1,845 |
£1,776 |
£1,849 |
£1,373 |
£727 |
£920 |
£860 |
£500 |
£1,316 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
43.86% |
31.89% |
20.73% |
36.66% |
37.07% |
35.00% |
28.70% |
15.80% |
19.57% |
18.90% |
11.44% |
24.33% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£11,348 |
£10,430 |
£10,558 |
£12,834 |
£12,215 |
£13,473 |
£12,198 |
£11,730 |
£11,995 |
£11,597 |
£11,135 |
£13,800 |
| Cash from Receivables |
|
£0 |
£67 |
£1,997 |
£1,841 |
£1,877 |
£2,261 |
£2,163 |
£2,370 |
£2,150 |
£2,072 |
£2,114 |
£2,044 |
| Subtotal Cash from Operations |
|
£11,348 |
£10,497 |
£12,555 |
£14,676 |
£14,091 |
£15,734 |
£14,360 |
£14,100 |
£14,145 |
£13,668 |
£13,249 |
£15,843 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£165,000 |
£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,348 |
£10,497 |
£177,555 |
£14,676 |
£14,091 |
£15,734 |
£14,360 |
£14,100 |
£14,145 |
£13,668 |
£13,249 |
£15,843 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
£1,920 |
| Bill Payments |
|
£264 |
£7,912 |
£7,793 |
£12,694 |
£6,694 |
£9,106 |
£10,407 |
£10,092 |
£9,463 |
£8,054 |
£8,914 |
£9,652 |
| Subtotal Spent on Operations |
|
£264 |
£7,912 |
£7,793 |
£12,694 |
£6,694 |
£9,106 |
£10,407 |
£12,012 |
£11,383 |
£9,974 |
£10,834 |
£11,572 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
£100 |
£100 |
£100 |
£100 |
£100 |
£200 |
£200 |
£500 |
£500 |
£500 |
£500 |
£750 |
| 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 |
£1,420 |
£1,420 |
£1,420 |
£1,420 |
£1,420 |
| 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 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£5,000 |
£0 |
£0 |
£0 |
£20,000 |
| Subtotal Cash Spent |
|
£364 |
£8,012 |
£7,893 |
£17,794 |
£11,794 |
£14,306 |
£15,607 |
£18,932 |
£13,303 |
£11,894 |
£12,754 |
£33,742 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£11,110 |
£13,595 |
£183,257 |
£180,139 |
£182,436 |
£183,864 |
£182,617 |
£177,785 |
£178,627 |
£180,401 |
£180,896 |
£162,998 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£126 |
£11,110 |
£13,595 |
£183,257 |
£180,139 |
£182,436 |
£183,864 |
£182,617 |
£177,785 |
£178,627 |
£180,401 |
£180,896 |
£162,998 |
| Accounts Receivable |
£0 |
£2,003 |
£3,777 |
£3,642 |
£4,066 |
£4,345 |
£4,461 |
£4,451 |
£4,151 |
£4,118 |
£4,093 |
£3,943 |
£4,335 |
| Inventory |
£3,492 |
£4,379 |
£4,099 |
£7,616 |
£5,125 |
£5,602 |
£6,177 |
£6,518 |
£6,790 |
£5,844 |
£6,050 |
£6,463 |
£6,745 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£3,618 |
£17,492 |
£21,471 |
£194,516 |
£189,330 |
£192,383 |
£194,502 |
£193,585 |
£188,726 |
£188,589 |
£190,544 |
£191,302 |
£174,078 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
£23,368 |
| Accumulated Depreciation |
£9,792 |
£10,252 |
£10,712 |
£11,172 |
£11,632 |
£12,092 |
£12,552 |
£13,012 |
£13,472 |
£13,932 |
£14,392 |
£14,852 |
£15,312 |
| Total Long-term Assets |
£13,576 |
£13,116 |
£12,656 |
£12,196 |
£11,736 |
£11,276 |
£10,816 |
£10,356 |
£9,896 |
£9,436 |
£8,976 |
£8,516 |
£8,056 |
| Total Assets |
£17,194 |
£30,608 |
£34,127 |
£206,712 |
£201,066 |
£203,659 |
£205,318 |
£203,941 |
£198,622 |
£198,025 |
£199,520 |
£199,818 |
£182,134 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£7,658 |
£7,363 |
£12,474 |
£6,392 |
£8,759 |
£10,070 |
£9,775 |
£9,196 |
£7,757 |
£8,593 |
£9,312 |
£9,849 |
| Current Borrowing |
£16,207 |
£16,107 |
£16,007 |
£15,907 |
£15,807 |
£15,707 |
£15,507 |
£15,307 |
£14,807 |
£14,307 |
£13,807 |
£13,307 |
£12,557 |
| Other Current Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Current Liabilities |
£16,207 |
£23,765 |
£23,370 |
£28,381 |
£22,199 |
£24,466 |
£25,577 |
£25,082 |
£24,003 |
£22,064 |
£22,400 |
£22,619 |
£22,406 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£0 |
£0 |
£0 |
£165,000 |
£165,000 |
£165,000 |
£165,000 |
£165,000 |
£163,580 |
£162,160 |
£160,740 |
£159,320 |
£157,900 |
| Total Liabilities |
£16,207 |
£23,765 |
£23,370 |
£193,381 |
£187,199 |
£189,466 |
£190,577 |
£190,082 |
£187,583 |
£184,224 |
£183,140 |
£181,939 |
£180,306 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
£25,000 |
| Retained Earnings |
(£9,755) |
(£24,013) |
(£24,013) |
(£24,013) |
(£29,013) |
(£34,013) |
(£39,013) |
(£44,013) |
(£49,013) |
(£49,013) |
(£49,013) |
(£49,013) |
(£69,013) |
| Earnings |
(£14,258) |
£5,856 |
£9,770 |
£12,345 |
£17,880 |
£23,207 |
£28,753 |
£32,872 |
£35,052 |
£37,814 |
£40,393 |
£41,892 |
£45,841 |
| Total Capital |
£987 |
£6,843 |
£10,757 |
£13,332 |
£13,867 |
£14,194 |
£14,740 |
£13,859 |
£11,039 |
£13,801 |
£16,380 |
£17,879 |
£1,828 |
| Total Liabilities and Capital |
£17,194 |
£30,608 |
£34,127 |
£206,712 |
£201,066 |
£203,659 |
£205,318 |
£203,941 |
£198,622 |
£198,025 |
£199,520 |
£199,818 |
£182,134 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£987 |
£6,843 |
£10,757 |
£13,332 |
£13,867 |
£14,194 |
£14,740 |
£13,859 |
£11,039 |
£13,801 |
£16,380 |
£17,879 |
£1,828 |
| General Assumptions |
| Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
| Current Interest Rate |
|
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
| Long-term Interest Rate |
|
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
5.00% |
| Tax Rate |
|
25.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 |
|