|
|
| 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 |
|