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 table and chart indicate what is needed in monthly revenue to reach the break even point.
| Break-even Analysis |
|
|
| Monthly Revenue Break-even |
$11,869 |
|
|
| Average Percent Variable Cost |
15% |
| Estimated Monthly Fixed Cost |
$10,098 |
8.3 Projected Profit and Loss
The following table and charts will indicate projected profit and loss.
| Pro Forma Profit and Loss |
| Direct Cost of Sales |
$10,416 |
$31,808 |
$37,033 |
| Other Costs of Sales |
$0 |
$0 |
$0 |
| Total Cost of Sales |
$10,416 |
$31,808 |
$37,033 |
|
|
|
|
| Gross Margin |
$59,411 |
$181,433 |
$211,239 |
| Gross Margin % |
85.08% |
85.08% |
85.08% |
|
|
|
|
|
|
|
|
| Payroll |
$85,200 |
$117,600 |
$123,600 |
| Sales and Marketing and Other Expenses |
$0 |
$0 |
$0 |
| Depreciation |
$12,000 |
$12,000 |
$16,000 |
| Rent |
$7,500 |
$9,000 |
$9,000 |
| Utilities |
$2,200 |
$2,640 |
$2,640 |
| Insurance |
$1,500 |
$1,800 |
$1,800 |
| Payroll Taxes |
$12,780 |
$17,640 |
$18,540 |
|
|
|
|
|
|
|
|
| Profit Before Interest and Taxes |
($61,769) |
$20,753 |
$39,659 |
| EBITDA |
($49,769) |
$32,753 |
$55,659 |
| Interest Expense |
$6,394 |
$5,317 |
$4,219 |
| Taxes Incurred |
$0 |
$4,631 |
$10,632 |
|
|
|
|
| Net Profit/Sales |
-97.62% |
5.07% |
9.99% |
8.4 Projected Cash Flow
The following table and chart will indicate projected cash flow.

| Pro Forma Cash Flow |
|
|
|
|
| Cash from Operations |
|
|
|
| Cash Sales |
$69,827 |
$213,240 |
$248,272 |
| Subtotal Cash from Operations |
$69,827 |
$213,240 |
$248,272 |
|
|
|
|
| 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 |
$0 |
$0 |
$0 |
| Subtotal Cash Received |
$69,827 |
$213,240 |
$248,272 |
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
| Cash Spending |
$85,200 |
$117,600 |
$123,600 |
| Bill Payments |
$38,101 |
$74,393 |
$84,017 |
| Subtotal Spent on Operations |
$123,301 |
$191,993 |
$207,617 |
|
|
|
|
| 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 |
$11,359 |
$10,938 |
$11,029 |
| Purchase Other Current Assets |
$0 |
$0 |
$0 |
| Purchase Long-term Assets |
$0 |
$0 |
$20,000 |
| Dividends |
$0 |
$0 |
$0 |
| Subtotal Cash Spent |
$134,660 |
$202,931 |
$238,646 |
|
|
|
|
| Cash Balance |
$1,767 |
$12,076 |
$21,702 |
8.5 Projected Balance Sheet
The following table will indicate the projected balance sheet.
| Pro Forma Balance Sheet |
|
|
|
|
| Current Assets |
|
|
|
| Cash |
$1,767 |
$12,076 |
$21,702 |
| Inventory |
$1,683 |
$5,140 |
$5,984 |
| Other Current Assets |
$0 |
$0 |
$0 |
| Total Current Assets |
$3,450 |
$17,216 |
$27,686 |
|
|
|
|
| Long-term Assets |
|
|
|
| Long-term Assets |
$60,000 |
$60,000 |
$80,000 |
| Accumulated Depreciation |
$12,000 |
$24,000 |
$40,000 |
| Total Long-term Assets |
$48,000 |
$36,000 |
$40,000 |
| Total Assets |
$51,450 |
$53,216 |
$67,686 |
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
| Accounts Payable |
$4,372 |
$6,271 |
$6,962 |
| Current Borrowing |
$0 |
$0 |
$0 |
| Other Current Liabilities |
$0 |
$0 |
$0 |
| Subtotal Current Liabilities |
$4,372 |
$6,271 |
$6,962 |
|
|
|
|
| Long-term Liabilities |
$58,641 |
$47,703 |
$36,674 |
| Total Liabilities |
$63,013 |
$53,974 |
$43,637 |
|
|
|
|
| Paid-in Capital |
$65,000 |
$65,000 |
$65,000 |
| Retained Earnings |
($8,400) |
($76,563) |
($65,758) |
| Earnings |
($68,163) |
$10,805 |
$24,808 |
| Total Capital |
($11,563) |
($758) |
$24,050 |
| Total Liabilities and Capital |
$51,450 |
$53,216 |
$67,686 |
|
|
|
|
| Net Worth |
($11,563) |
($758) |
$24,050 |
8.6 Business Ratios
The following table represents ratios specific to Borrow My Tools as well as industry average ratios.

| Ratio Analysis |
| Sales Growth |
0.00% |
205.39% |
16.43% |
7.07% |
|
|
|
|
|
| Inventory |
3.27% |
9.66% |
8.84% |
3.96% |
| Other Current Assets |
0.00% |
0.00% |
0.00% |
44.65% |
| Total Current Assets |
6.70% |
32.35% |
40.90% |
76.22% |
| Long-term Assets |
93.30% |
67.65% |
59.10% |
23.78% |
| Total Assets |
100.00% |
100.00% |
100.00% |
100.00% |
|
|
|
|
|
| Current Liabilities |
8.50% |
11.78% |
10.29% |
33.47% |
| Long-term Liabilities |
113.98% |
89.64% |
54.18% |
16.23% |
| Total Liabilities |
122.47% |
101.42% |
64.47% |
49.70% |
| Net Worth |
-22.47% |
-1.42% |
35.53% |
50.30% |
|
|
|
|
|
| Sales |
100.00% |
100.00% |
100.00% |
100.00% |
| Gross Margin |
85.08% |
85.08% |
85.08% |
100.00% |
| Selling, General & Administrative Expenses |
182.70% |
80.02% |
75.09% |
84.88% |
| Advertising Expenses |
0.00% |
0.00% |
0.00% |
1.01% |
| Profit Before Interest and Taxes |
-88.46% |
9.73% |
15.97% |
1.94% |
|
|
|
|
|
| Current |
0.79 |
2.75 |
3.98 |
1.73 |
| Quick |
0.40 |
1.93 |
3.12 |
1.33 |
| Total Debt to Total Assets |
122.47% |
101.42% |
64.47% |
3.77% |
| Pre-tax Return on Net Worth |
589.49% |
-2035.50% |
147.36% |
57.72% |
| Pre-tax Return on Assets |
-132.49% |
29.01% |
52.36% |
8.92% |
|
|
|
|
|
| Net Profit Margin |
-97.62% |
5.07% |
9.99% |
n.a |
| Return on Equity |
0.00% |
0.00% |
103.15% |
n.a |
|
|
|
|
|
| Inventory Turnover |
9.37 |
9.32 |
6.66 |
n.a |
| Accounts Payable Turnover |
9.72 |
12.17 |
12.17 |
n.a |
| Payment Days |
27 |
25 |
29 |
n.a |
| Total Asset Turnover |
1.36 |
4.01 |
3.67 |
n.a |
|
|
|
|
|
| Debt to Net Worth |
0.00 |
0.00 |
1.81 |
n.a |
| Current Liab. to Liab. |
0.07 |
0.12 |
0.16 |
n.a |
|
|
|
|
|
| Net Working Capital |
($922) |
$10,945 |
$20,724 |
n.a |
| Interest Coverage |
-9.66 |
3.90 |
9.40 |
n.a |
|
|
|
|
|
| Assets to Sales |
0.74 |
0.25 |
0.27 |
n.a |
| Current Debt/Total Assets |
8% |
12% |
10% |
n.a |
| Acid Test |
0.40 |
1.93 |
3.12 |
n.a |
| Sales/Net Worth |
0.00 |
0.00 |
10.32 |
n.a |
| Dividend Payout |
0.00 |
0.00 |
0.00 |
n.a |