Our biggest savings of the year
Borrow My Tools
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | |||||||||||||
Wood | 0% | $0 | $0 | $350 | $800 | $1,350 | $1,800 | $3,100 | $3,500 | $3,750 | $3,900 | $4,100 | $3,900 |
Assorted | 0% | $0 | $0 | $305 | $696 | $1,175 | $1,566 | $2,697 | $3,045 | $3,263 | $3,393 | $3,567 | $3,393 |
Exterior | 0% | $0 | $0 | $266 | $608 | $1,026 | $1,368 | $2,356 | $2,660 | $2,850 | $2,964 | $3,116 | $2,964 |
Total Sales | $0 | $0 | $921 | $2,104 | $3,551 | $4,734 | $8,153 | $9,205 | $9,863 | $10,257 | $10,783 | $10,257 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Wood | $0 | $0 | $35 | $80 | $135 | $180 | $310 | $350 | $375 | $390 | $410 | $390 | |
Assorted | $0 | $0 | $52 | $118 | $200 | $266 | $458 | $518 | $555 | $577 | $606 | $577 | |
Exterior | $0 | $0 | $51 | $116 | $195 | $260 | $448 | $505 | $542 | $563 | $592 | $563 | |
Subtotal Direct Cost of Sales | $0 | $0 | $137 | $314 | $530 | $706 | $1,216 | $1,373 | $1,471 | $1,530 | $1,608 | $1,530 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Josh | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Sales | 0% | $0 | $0 | $0 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Sales | 0% | $0 | $0 | $0 | $0 | $0 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Bookkeeper | 0% | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Service | 0% | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
Service | 0% | $0 | $0 | $0 | $0 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 |
Total People | 0 | 0 | 1 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | |
Total Payroll | $0 | $0 | $2,000 | $6,400 | $8,200 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
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 | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $0 | $0 | $921 | $2,104 | $3,551 | $4,734 | $8,153 | $9,205 | $9,863 | $10,257 | $10,783 | $10,257 | |
Direct Cost of Sales | $0 | $0 | $137 | $314 | $530 | $706 | $1,216 | $1,373 | $1,471 | $1,530 | $1,608 | $1,530 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $137 | $314 | $530 | $706 | $1,216 | $1,373 | $1,471 | $1,530 | $1,608 | $1,530 | |
Gross Margin | $0 | $0 | $783 | $1,790 | $3,021 | $4,028 | $6,937 | $7,832 | $8,391 | $8,727 | $9,175 | $8,727 | |
Gross Margin % | 0.00% | 0.00% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | 85.08% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $2,000 | $6,400 | $8,200 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Rent | $0 | $0 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Utilities | $0 | $0 | $220 | $220 | $220 | $220 | $220 | $220 | $220 | $220 | $220 | $220 | |
Insurance | 15% | $0 | $0 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 |
Payroll Taxes | 15% | $0 | $0 | $300 | $960 | $1,230 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 | $1,470 |
Total Operating Expenses | $1,000 | $1,000 | $4,420 | $9,480 | $11,550 | $13,390 | $13,390 | $13,390 | $13,390 | $13,390 | $13,390 | $13,390 | |
Profit Before Interest and Taxes | ($1,000) | ($1,000) | ($3,637) | ($7,690) | ($8,529) | ($9,362) | ($6,453) | ($5,558) | ($4,999) | ($4,663) | ($4,215) | ($4,663) | |
EBITDA | $0 | $0 | ($2,637) | ($6,690) | ($7,529) | ($8,362) | ($5,453) | ($4,558) | ($3,999) | ($3,663) | ($3,215) | ($3,663) | |
Interest Expense | $576 | $568 | $561 | $553 | $545 | $537 | $529 | $521 | $513 | $505 | $497 | $489 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($1,576) | ($1,568) | ($4,197) | ($8,243) | ($9,074) | ($9,899) | ($6,982) | ($6,079) | ($5,512) | ($5,168) | ($4,712) | ($5,152) | |
Net Profit/Sales | 0.00% | 0.00% | -455.99% | -391.76% | -255.57% | -209.11% | -85.64% | -66.04% | -55.89% | -50.39% | -43.70% | -50.23% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $921 | $2,104 | $3,551 | $4,734 | $8,153 | $9,205 | $9,863 | $10,257 | $10,783 | $10,257 | |
Subtotal Cash from Operations | $0 | $0 | $921 | $2,104 | $3,551 | $4,734 | $8,153 | $9,205 | $9,863 | $10,257 | $10,783 | $10,257 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $0 | $921 | $2,104 | $3,551 | $4,734 | $8,153 | $9,205 | $9,863 | $10,257 | $10,783 | $10,257 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $0 | $0 | $2,000 | $6,400 | $8,200 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | $9,800 | |
Bill Payments | $19 | $576 | $649 | $2,969 | $2,675 | $3,903 | $4,135 | $4,370 | $4,658 | $4,682 | $4,693 | $4,773 | |
Subtotal Spent on Operations | $19 | $576 | $2,649 | $9,369 | $10,875 | $13,703 | $13,935 | $14,170 | $14,458 | $14,482 | $14,493 | $14,573 | |
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 | $904 | $911 | $919 | $927 | $934 | $942 | $950 | $958 | $966 | $974 | $982 | $990 | |
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 | $923 | $1,487 | $3,568 | $10,296 | $11,809 | $14,645 | $14,885 | $15,128 | $15,424 | $15,457 | $15,475 | $15,563 | |
Net Cash Flow | ($923) | ($1,487) | ($2,647) | ($8,192) | ($8,259) | ($9,911) | ($6,732) | ($5,923) | ($5,561) | ($5,200) | ($4,692) | ($5,306) | |
Cash Balance | $65,677 | $64,190 | $61,543 | $53,351 | $45,092 | $35,181 | $28,449 | $22,526 | $16,965 | $11,765 | $7,073 | $1,767 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $66,600 | $65,677 | $64,190 | $61,543 | $53,351 | $45,092 | $35,181 | $28,449 | $22,526 | $16,965 | $11,765 | $7,073 | $1,767 |
Inventory | $0 | $0 | $0 | $863 | $549 | $1,019 | $1,313 | $1,338 | $1,510 | $1,618 | $1,683 | $1,769 | $1,683 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $66,600 | $65,677 | $64,190 | $62,405 | $53,900 | $46,111 | $36,494 | $29,787 | $24,036 | $18,583 | $13,448 | $8,842 | $3,450 |
Long-term Assets | |||||||||||||
Long-term Assets | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 | $60,000 |
Accumulated Depreciation | $0 | $1,000 | $2,000 | $3,000 | $4,000 | $5,000 | $6,000 | $7,000 | $8,000 | $9,000 | $10,000 | $11,000 | $12,000 |
Total Long-term Assets | $60,000 | $59,000 | $58,000 | $57,000 | $56,000 | $55,000 | $54,000 | $53,000 | $52,000 | $51,000 | $50,000 | $49,000 | $48,000 |
Total Assets | $126,600 | $124,677 | $122,190 | $119,405 | $109,900 | $101,111 | $90,494 | $82,787 | $76,036 | $69,583 | $63,448 | $57,842 | $51,450 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $0 | $557 | $549 | $2,881 | $2,545 | $3,765 | $3,990 | $4,215 | $4,502 | $4,526 | $4,533 | $4,622 | $4,372 |
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 | $557 | $549 | $2,881 | $2,545 | $3,765 | $3,990 | $4,215 | $4,502 | $4,526 | $4,533 | $4,622 | $4,372 |
Long-term Liabilities | $70,000 | $69,096 | $68,185 | $67,265 | $66,339 | $65,404 | $64,462 | $63,512 | $62,554 | $61,588 | $60,614 | $59,632 | $58,641 |
Total Liabilities | $70,000 | $69,653 | $68,734 | $70,147 | $68,884 | $69,169 | $68,452 | $67,727 | $67,056 | $66,114 | $65,147 | $64,254 | $63,013 |
Paid-in Capital | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 |
Retained Earnings | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) | ($8,400) |
Earnings | $0 | ($1,576) | ($3,144) | ($7,341) | ($15,584) | ($24,658) | ($34,557) | ($41,540) | ($47,619) | ($53,131) | ($58,299) | ($63,012) | ($68,163) |
Total Capital | $56,600 | $55,024 | $53,456 | $49,259 | $41,016 | $31,942 | $22,043 | $15,060 | $8,981 | $3,469 | ($1,699) | ($6,412) | ($11,563) |
Total Liabilities and Capital | $126,600 | $124,677 | $122,190 | $119,405 | $109,900 | $101,111 | $90,494 | $82,787 | $76,036 | $69,583 | $63,448 | $57,842 | $51,450 |
Net Worth | $56,600 | $55,024 | $53,456 | $49,259 | $41,016 | $31,942 | $22,043 | $15,060 | $8,981 | $3,469 | ($1,699) | ($6,412) | ($11,563) |