|
|
| Sales Forecast |
| Rob Scott's Sales |
0% |
£30,000 |
£40,000 |
£50,000 |
£55,000 |
£60,000 |
£65,000 |
£70,000 |
£72,000 |
£75,000 |
£75,000 |
£78,000 |
£80,000 |
| Other |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Sales |
|
£30,000 |
£40,000 |
£50,000 |
£55,000 |
£60,000 |
£65,000 |
£70,000 |
£72,000 |
£75,000 |
£75,000 |
£78,000 |
£80,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Rob Scott's Sales |
|
£24,000 |
£32,000 |
£40,000 |
£44,000 |
£45,000 |
£48,750 |
£52,500 |
£54,000 |
£56,250 |
£52,500 |
£54,600 |
£56,000 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Direct Cost of Sales |
|
£24,000 |
£32,000 |
£40,000 |
£44,000 |
£45,000 |
£48,750 |
£52,500 |
£54,000 |
£56,250 |
£52,500 |
£54,600 |
£56,000 |
| Personnel Plan |
| Rob Scott |
0% |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
| Other |
0% |
£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 |
|
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
| 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 |
|
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
| Tax Rate |
|
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
30.00% |
| Other |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |

| Pro Forma Profit and Loss |
| Direct Cost of Sales |
|
£24,000 |
£32,000 |
£40,000 |
£44,000 |
£45,000 |
£48,750 |
£52,500 |
£54,000 |
£56,250 |
£52,500 |
£54,600 |
£56,000 |
| Other |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Cost of Sales |
|
£24,000 |
£32,000 |
£40,000 |
£44,000 |
£45,000 |
£48,750 |
£52,500 |
£54,000 |
£56,250 |
£52,500 |
£54,600 |
£56,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Margin |
|
£6,000 |
£8,000 |
£10,000 |
£11,000 |
£15,000 |
£16,250 |
£17,500 |
£18,000 |
£18,750 |
£22,500 |
£23,400 |
£24,000 |
| Gross Margin % |
|
20.00% |
20.00% |
20.00% |
20.00% |
25.00% |
25.00% |
25.00% |
25.00% |
25.00% |
30.00% |
30.00% |
30.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
| Marketing/Promotion |
|
£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 |
| Leased Equipment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Insurance |
|
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
£400 |
| Payroll Taxes |
15% |
£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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
|
£3,433 |
£5,433 |
£7,433 |
£8,433 |
£12,433 |
£13,683 |
£14,933 |
£15,433 |
£16,183 |
£19,933 |
£20,833 |
£21,433 |
| EBITDA |
|
£3,433 |
£5,433 |
£7,433 |
£8,433 |
£12,433 |
£13,683 |
£14,933 |
£15,433 |
£16,183 |
£19,933 |
£20,833 |
£21,433 |
| Interest Expense |
|
£417 |
£417 |
£408 |
£400 |
£391 |
£383 |
£374 |
£366 |
£357 |
£349 |
£340 |
£332 |
| Taxes Incurred |
|
£905 |
£1,505 |
£2,107 |
£2,410 |
£3,613 |
£3,990 |
£4,368 |
£4,520 |
£4,748 |
£5,875 |
£6,148 |
£6,330 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Profit/Sales |
|
7.04% |
8.78% |
9.83% |
10.22% |
14.05% |
14.32% |
14.56% |
14.65% |
14.77% |
18.28% |
18.39% |
18.46% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Sales |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Cash from Receivables |
|
£0 |
£1,000 |
£30,333 |
£40,333 |
£50,167 |
£55,167 |
£60,167 |
£65,167 |
£70,067 |
£72,100 |
£75,000 |
£75,100 |
| Subtotal Cash from Operations |
|
£0 |
£1,000 |
£30,333 |
£40,333 |
£50,167 |
£55,167 |
£60,167 |
£65,167 |
£70,067 |
£72,100 |
£75,000 |
£75,100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£37,000 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Received |
|
£0 |
£38,000 |
£30,333 |
£40,333 |
£50,167 |
£55,167 |
£60,167 |
£65,167 |
£70,067 |
£72,100 |
£75,000 |
£75,100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
£1,667 |
| Bill Payments |
|
£874 |
£26,508 |
£35,108 |
£43,559 |
£47,783 |
£50,041 |
£54,160 |
£58,197 |
£59,868 |
£62,167 |
£59,703 |
£62,040 |
| Subtotal Spent on Operations |
|
£2,541 |
£28,175 |
£36,775 |
£45,226 |
£49,450 |
£51,708 |
£55,827 |
£59,864 |
£61,535 |
£63,834 |
£61,370 |
£63,707 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
£1,020 |
| 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,541 |
£28,175 |
£37,795 |
£46,246 |
£50,470 |
£52,728 |
£56,847 |
£60,884 |
£62,555 |
£64,854 |
£62,390 |
£64,727 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£47,459 |
£57,284 |
£49,822 |
£43,910 |
£43,606 |
£46,045 |
£49,365 |
£53,648 |
£61,159 |
£68,405 |
£81,015 |
£91,388 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£50,000 |
£47,459 |
£57,284 |
£49,822 |
£43,910 |
£43,606 |
£46,045 |
£49,365 |
£53,648 |
£61,159 |
£68,405 |
£81,015 |
£91,388 |
| Accounts Receivable |
£0 |
£30,000 |
£69,000 |
£88,667 |
£103,333 |
£113,167 |
£123,000 |
£132,833 |
£139,667 |
£144,600 |
£147,500 |
£150,500 |
£155,400 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£50,000 |
£77,459 |
£126,284 |
£138,489 |
£147,243 |
£156,773 |
£169,045 |
£182,198 |
£193,314 |
£205,759 |
£215,905 |
£231,515 |
£246,788 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
£50,000 |
£77,459 |
£126,284 |
£138,489 |
£147,243 |
£156,773 |
£169,045 |
£182,198 |
£193,314 |
£205,759 |
£215,905 |
£231,515 |
£246,788 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£25,348 |
£33,661 |
£41,968 |
£46,119 |
£48,240 |
£52,222 |
£56,204 |
£57,793 |
£60,180 |
£57,637 |
£59,922 |
£61,443 |
| 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 |
£25,348 |
£33,661 |
£41,968 |
£46,119 |
£48,240 |
£52,222 |
£56,204 |
£57,793 |
£60,180 |
£57,637 |
£59,922 |
£61,443 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£50,000 |
£50,000 |
£50,000 |
£48,980 |
£47,960 |
£46,940 |
£45,920 |
£44,900 |
£43,880 |
£42,860 |
£41,840 |
£40,820 |
£39,800 |
| Total Liabilities |
£50,000 |
£75,348 |
£83,661 |
£90,948 |
£94,079 |
£95,180 |
£98,142 |
£101,104 |
£101,673 |
£103,040 |
£99,477 |
£100,742 |
£101,243 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£15,000 |
£15,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
£52,000 |
| Retained Earnings |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
(£15,000) |
| Earnings |
£0 |
£2,111 |
£5,623 |
£10,540 |
£16,164 |
£24,593 |
£33,903 |
£44,094 |
£54,641 |
£65,720 |
£79,429 |
£93,774 |
£108,544 |
| Total Capital |
£0 |
£2,111 |
£42,623 |
£47,540 |
£53,164 |
£61,593 |
£70,903 |
£81,094 |
£91,641 |
£102,720 |
£116,429 |
£130,774 |
£145,544 |
| Total Liabilities and Capital |
£50,000 |
£77,459 |
£126,284 |
£138,489 |
£147,243 |
£156,773 |
£169,045 |
£182,198 |
£193,314 |
£205,759 |
£215,905 |
£231,515 |
£246,788 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£0 |
£2,111 |
£42,623 |
£47,540 |
£53,164 |
£61,593 |
£70,903 |
£81,094 |
£91,641 |
£102,720 |
£116,429 |
£130,774 |
£145,544 |
|