The following sections will outline important Financial Information.
8.1 Important Assumptions
The following table details important Financial Assumptions.
| General Assumptions |
| Plan Month |
1 |
2 |
3 |
| Current Interest Rate |
10.00% |
10.00% |
10.00% |
| Long-term Interest Rate |
10.00% |
10.00% |
10.00% |
| Tax Rate |
30.00% |
30.00% |
30.00% |
| Other |
0 |
0 |
0 |
8.2 Break-even Analysis
The Break-even Analysis is shown below.
| Break-even Analysis |
|
|
| Monthly Revenue Break-even |
$12,582 |
|
|
| Average Percent Variable Cost |
59% |
| Estimated Monthly Fixed Cost |
$5,160 |
8.3 Projected Profit and Loss
The following table will indicate Projected Profit and Loss.
| Pro Forma Profit and Loss |
| Direct Cost of Sales |
$70,680 |
$173,581 |
$205,082 |
| Other Costs of Goods |
$0 |
$0 |
$0 |
| Total Cost of Sales |
$70,680 |
$173,581 |
$205,082 |
|
|
|
|
| Gross Margin |
$49,141 |
$107,322 |
$127,342 |
| Gross Margin % |
41.01% |
38.21% |
38.31% |
|
|
|
|
|
|
|
|
| Payroll |
$41,500 |
$59,400 |
$73,000 |
| Sales and Marketing and Other Expenses |
$4,800 |
$4,800 |
$4,800 |
| Depreciation |
$996 |
$996 |
$996 |
| Rent |
$4,200 |
$4,200 |
$4,200 |
| Utilities |
$1,800 |
$1,800 |
$1,800 |
| Insurance |
$2,400 |
$2,400 |
$2,400 |
| Payroll Taxes |
$6,225 |
$8,910 |
$10,950 |
| Other |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
($12,780) |
$24,816 |
$29,196 |
| EBITDA |
($11,784) |
$25,812 |
$30,192 |
| Interest Expense |
$0 |
$0 |
$0 |
| Taxes Incurred |
$0 |
$7,445 |
$8,759 |
|
|
|
|
| Net Profit/Sales |
-10.67% |
6.18% |
6.15% |
8.4 Projected Cash Flow
The following table and chart will indicate Projected Cash Flow.

| Pro Forma Cash Flow |
|
|
|
|
| Cash from Operations |
|
|
|
| Cash Sales |
$29,955 |
$70,226 |
$83,106 |
| Cash from Receivables |
$67,585 |
$180,724 |
$239,738 |
| Subtotal Cash from Operations |
$97,540 |
$250,950 |
$322,844 |
|
|
|
|
| Additional Cash Received |
|
|
|
| Sales Tax, VAT, HST/GST Received |
$0 |
$0 |
$0 |
| New Current Borrowing |
$0 |
$0 |
$0 |
| New Other Liabilities (interest-free) |
$0 |
$0 |
$0 |
| New Long-term Liabilities |
$0 |
$0 |
$0 |
| Sales of Other Current Assets |
$0 |
$0 |
$0 |
| Sales of Long-term Assets |
$0 |
$0 |
$0 |
| New Investment Received |
$70,000 |
$0 |
$0 |
| Subtotal Cash Received |
$167,540 |
$250,950 |
$322,844 |
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
| Cash Spending |
$41,500 |
$59,400 |
$73,000 |
| Bill Payments |
$90,136 |
$210,618 |
$240,472 |
| Subtotal Spent on Operations |
$131,636 |
$270,018 |
$313,472 |
|
|
|
|
| Additional Cash Spent |
|
|
|
| Sales Tax, VAT, HST/GST Paid Out |
$0 |
$0 |
$0 |
| Principal Repayment of Current Borrowing |
$0 |
$0 |
$0 |
| Other Liabilities Principal Repayment |
$0 |
$0 |
$0 |
| Long-term Liabilities Principal Repayment |
$0 |
$0 |
$0 |
| Purchase Other Current Assets |
$0 |
$0 |
$0 |
| Purchase Long-term Assets |
$5,000 |
$0 |
$0 |
| Dividends |
$0 |
$0 |
$0 |
| Subtotal Cash Spent |
$136,636 |
$270,018 |
$313,472 |
|
|
|
|
| Cash Balance |
$36,359 |
$17,291 |
$26,663 |
8.5 Projected Balance Sheet
The following table will indicate the projected Balance Sheet.
| Pro Forma Balance Sheet |
|
|
|
|
| Current Assets |
|
|
|
| Cash |
$36,359 |
$17,291 |
$26,663 |
| Accounts Receivable |
$22,281 |
$52,234 |
$61,814 |
| Inventory |
$10,111 |
$24,832 |
$29,339 |
| Other Current Assets |
$800 |
$800 |
$800 |
| Total Current Assets |
$69,551 |
$95,157 |
$118,616 |
|
|
|
|
| Long-term Assets |
|
|
|
| Long-term Assets |
$6,000 |
$6,000 |
$6,000 |
| Accumulated Depreciation |
$996 |
$1,992 |
$2,988 |
| Total Long-term Assets |
$5,004 |
$4,008 |
$3,012 |
| Total Assets |
$74,555 |
$99,165 |
$121,628 |
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
| Accounts Payable |
$10,667 |
$17,906 |
$19,931 |
| Current Borrowing |
$0 |
$0 |
$0 |
| Other Current Liabilities |
$0 |
$0 |
$0 |
| Subtotal Current Liabilities |
$10,667 |
$17,906 |
$19,931 |
|
|
|
|
| Long-term Liabilities |
$0 |
$0 |
$0 |
| Total Liabilities |
$10,667 |
$17,906 |
$19,931 |
|
|
|
|
| Paid-in Capital |
$70,000 |
$70,000 |
$70,000 |
| Retained Earnings |
$6,668 |
($6,112) |
$11,259 |
| Earnings |
($12,780) |
$17,371 |
$20,437 |
| Total Capital |
$63,888 |
$81,259 |
$101,696 |
| Total Liabilities and Capital |
$74,555 |
$99,165 |
$121,628 |
|
|
|
|
| Net Worth |
$63,888 |
$81,259 |
$101,696 |
8.6 Business Ratios
The following table will display the common Business Ratios associated with this company as well as industry averages.

| Ratio Analysis |
| Sales Growth |
565.67% |
134.44% |
18.34% |
4.01% |
|
|
|
|
|
| Accounts Receivable |
29.88% |
52.67% |
50.82% |
15.71% |
| Inventory |
13.56% |
25.04% |
24.12% |
39.55% |
| Other Current Assets |
1.07% |
0.81% |
0.66% |
24.92% |
| Total Current Assets |
93.29% |
95.96% |
97.52% |
80.18% |
| Long-term Assets |
6.71% |
4.04% |
2.48% |
19.82% |
| Total Assets |
100.00% |
100.00% |
100.00% |
100.00% |
|
|
|
|
|
| Current Liabilities |
14.31% |
18.06% |
16.39% |
40.00% |
| Long-term Liabilities |
0.00% |
0.00% |
0.00% |
14.33% |
| Total Liabilities |
14.31% |
18.06% |
16.39% |
54.33% |
| Net Worth |
85.69% |
81.94% |
83.61% |
45.67% |
|
|
|
|
|
| Sales |
100.00% |
100.00% |
100.00% |
100.00% |
| Gross Margin |
41.01% |
38.21% |
38.31% |
31.56% |
| Selling, General & Administrative Expenses |
51.68% |
32.02% |
32.16% |
19.76% |
| Advertising Expenses |
0.00% |
0.00% |
0.00% |
1.49% |
| Profit Before Interest and Taxes |
-10.67% |
8.83% |
8.78% |
1.66% |
|
|
|
|
|
| Current |
6.52 |
5.31 |
5.95 |
1.80 |
| Quick |
5.57 |
3.93 |
4.48 |
0.69 |
| Total Debt to Total Assets |
14.31% |
18.06% |
16.39% |
59.54% |
| Pre-tax Return on Net Worth |
-20.00% |
30.54% |
28.71% |
3.82% |
| Pre-tax Return on Assets |
-17.14% |
25.03% |
24.00% |
9.44% |
|
|
|
|
|
| Net Profit Margin |
-10.67% |
6.18% |
6.15% |
n.a |
| Return on Equity |
-20.00% |
21.38% |
20.10% |
n.a |
|
|
|
|
|
| Accounts Receivable Turnover |
4.03 |
4.03 |
4.03 |
n.a |
| Collection Days |
56 |
65 |
83 |
n.a |
| Inventory Turnover |
10.91 |
9.93 |
7.57 |
n.a |
| Accounts Payable Turnover |
9.36 |
12.17 |
12.17 |
n.a |
| Payment Days |
27 |
24 |
28 |
n.a |
| Total Asset Turnover |
1.61 |
2.83 |
2.73 |
n.a |
|
|
|
|
|
| Debt to Net Worth |
0.17 |
0.22 |
0.20 |
n.a |
| Current Liab. to Liab. |
1.00 |
1.00 |
1.00 |
n.a |
|
|
|
|
|
| Net Working Capital |
$58,884 |
$77,251 |
$98,684 |
n.a |
| Interest Coverage |
0.00 |
0.00 |
0.00 |
n.a |
|
|
|
|
|
| Assets to Sales |
0.62 |
0.35 |
0.37 |
n.a |
| Current Debt/Total Assets |
14% |
18% |
16% |
n.a |
| Acid Test |
3.48 |
1.01 |
1.38 |
n.a |
| Sales/Net Worth |
1.88 |
3.46 |
3.27 |
n.a |
| Dividend Payout |
0.00 |
0.00 |
0.00 |
n.a |