HandyMan Stan
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 | |||||||||||||
Plumbing | 0% | $0 | $0 | $100 | $165 | $150 | $280 | $305 | $450 | $525 | $650 | $775 | $850 |
Electrical | 0% | $0 | $0 | $87 | $144 | $131 | $244 | $265 | $392 | $457 | $566 | $674 | $740 |
Fences | 0% | $0 | $0 | $23 | $38 | $35 | $64 | $70 | $104 | $121 | $150 | $178 | $0 |
Windows | 0% | $0 | $0 | $32 | $53 | $48 | $90 | $98 | $144 | $168 | $208 | $248 | $272 |
Decks | 0% | $0 | $0 | $36 | $59 | $54 | $101 | $110 | $162 | $189 | $234 | $0 | $0 |
Paint | 0% | $0 | $0 | $59 | $97 | $89 | $165 | $180 | $266 | $310 | $384 | $457 | $502 |
Weather proofing | 0% | $0 | $0 | $33 | $54 | $50 | $92 | $101 | $149 | $173 | $215 | $256 | $281 |
Parts | 0% | $0 | $0 | $20 | $33 | $30 | $56 | $61 | $90 | $105 | $130 | $155 | $170 |
Floors | 0% | $0 | $0 | $38 | $63 | $57 | $106 | $116 | $171 | $200 | $247 | $295 | $323 |
Total Sales | $0 | $0 | $428 | $706 | $642 | $1,198 | $1,305 | $1,926 | $2,247 | $2,782 | $3,038 | $3,137 | |
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 | |
Plumbing | $0 | $0 | $7 | $12 | $11 | $20 | $21 | $32 | $37 | $46 | $54 | $60 | |
Electrical | $0 | $0 | $4 | $7 | $7 | $12 | $13 | $20 | $23 | $28 | $34 | $37 | |
Fences | $0 | $0 | $1 | $1 | $1 | $2 | $2 | $3 | $4 | $4 | $5 | $0 | |
Windows | $0 | $0 | $3 | $4 | $4 | $7 | $8 | $12 | $13 | $17 | $20 | $22 | |
Decks | $0 | $0 | $1 | $2 | $2 | $4 | $4 | $6 | $8 | $9 | $0 | $0 | |
Paint | $0 | $0 | $5 | $9 | $8 | $15 | $16 | $24 | $28 | $35 | $41 | $45 | |
Weather proofing | $0 | $0 | $2 | $3 | $3 | $6 | $6 | $9 | $10 | $13 | $15 | $17 | |
Parts | $0 | $0 | $16 | $26 | $24 | $45 | $49 | $72 | $84 | $104 | $124 | $136 | |
Floors | $0 | $0 | $2 | $3 | $2 | $4 | $5 | $7 | $8 | $10 | $12 | $13 | |
Subtotal Direct Cost of Sales | $0 | $0 | $41 | $67 | $61 | $114 | $125 | $184 | $214 | $266 | $305 | $329 |
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 | ||
Stan | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
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 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
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 | $428 | $706 | $642 | $1,198 | $1,305 | $1,926 | $2,247 | $2,782 | $3,038 | $3,137 | |
Direct Cost of Sales | $0 | $0 | $41 | $67 | $61 | $114 | $125 | $184 | $214 | $266 | $305 | $329 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $41 | $67 | $61 | $114 | $125 | $184 | $214 | $266 | $305 | $329 | |
Gross Margin | $0 | $0 | $387 | $639 | $581 | $1,084 | $1,181 | $1,742 | $2,033 | $2,516 | $2,733 | $2,807 | |
Gross Margin % | 0.00% | 0.00% | 90.46% | 90.46% | 90.46% | 90.46% | 90.46% | 90.46% | 90.46% | 90.46% | 89.95% | 89.51% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Sales and Marketing and Other Expenses | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Depreciation | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | $133 | |
License fees (electrical & plumbing) | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Payroll Taxes | 15% | $0 | $0 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 |
Gas/other incidentals | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Total Operating Expenses | $663 | $663 | $2,963 | $2,963 | $2,963 | $2,963 | $2,963 | $2,963 | $2,963 | $2,963 | $2,963 | $2,963 | |
Profit Before Interest and Taxes | ($663) | ($663) | ($2,576) | ($2,324) | ($2,382) | ($1,879) | ($1,782) | ($1,221) | ($930) | ($447) | ($230) | ($156) | |
EBITDA | ($530) | ($530) | ($2,443) | ($2,191) | ($2,249) | ($1,746) | ($1,649) | ($1,088) | ($797) | ($314) | ($97) | ($23) | |
Interest Expense | $247 | $244 | $240 | $237 | $234 | $230 | $227 | $223 | $220 | $216 | $213 | $209 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($910) | ($907) | ($2,816) | ($2,561) | ($2,616) | ($2,109) | ($2,009) | ($1,444) | ($1,150) | ($663) | ($443) | ($365) | |
Net Profit/Sales | 0.00% | 0.00% | -657.96% | -362.66% | -407.46% | -176.00% | -153.90% | -74.99% | -51.20% | -23.83% | -14.60% | -11.64% |
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 | $428 | $706 | $642 | $1,198 | $1,305 | $1,926 | $2,247 | $2,782 | $3,038 | $3,137 | |
Subtotal Cash from Operations | $0 | $0 | $428 | $706 | $642 | $1,198 | $1,305 | $1,926 | $2,247 | $2,782 | $3,038 | $3,137 | |
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 | $428 | $706 | $642 | $1,198 | $1,305 | $1,926 | $2,247 | $2,782 | $3,038 | $3,137 | |
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 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Bill Payments | $26 | $777 | $785 | $1,112 | $1,134 | $1,127 | $1,175 | $1,183 | $1,238 | $1,266 | $1,313 | $1,349 | |
Subtotal Spent on Operations | $26 | $777 | $2,785 | $3,112 | $3,134 | $3,127 | $3,175 | $3,183 | $3,238 | $3,266 | $3,313 | $3,349 | |
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 | $387 | $391 | $394 | $397 | $400 | $404 | $407 | $411 | $414 | $417 | $421 | $424 | |
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 | $413 | $1,167 | $3,179 | $3,509 | $3,534 | $3,530 | $3,582 | $3,594 | $3,652 | $3,683 | $3,734 | $3,774 | |
Net Cash Flow | ($413) | ($1,167) | ($2,751) | ($2,803) | ($2,892) | ($2,332) | ($2,277) | ($1,668) | ($1,405) | ($901) | ($696) | ($637) | |
Cash Balance | $20,087 | $18,919 | $16,169 | $13,366 | $10,473 | $8,141 | $5,865 | $4,197 | $2,792 | $1,890 | $1,194 | $557 |
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 | $20,500 | $20,087 | $18,919 | $16,169 | $13,366 | $10,473 | $8,141 | $5,865 | $4,197 | $2,792 | $1,890 | $1,194 | $557 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $20,500 | $20,087 | $18,919 | $16,169 | $13,366 | $10,473 | $8,141 | $5,865 | $4,197 | $2,792 | $1,890 | $1,194 | $557 |
Long-term Assets | |||||||||||||
Long-term Assets | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 |
Accumulated Depreciation | $0 | $133 | $266 | $399 | $532 | $665 | $798 | $931 | $1,064 | $1,197 | $1,330 | $1,463 | $1,596 |
Total Long-term Assets | $8,000 | $7,867 | $7,734 | $7,601 | $7,468 | $7,335 | $7,202 | $7,069 | $6,936 | $6,803 | $6,670 | $6,537 | $6,404 |
Total Assets | $28,500 | $27,954 | $26,653 | $23,770 | $20,834 | $17,808 | $15,343 | $12,934 | $11,133 | $9,595 | $8,560 | $7,731 | $6,961 |
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 | $751 | $748 | $1,074 | $1,097 | $1,087 | $1,135 | $1,142 | $1,196 | $1,222 | $1,268 | $1,303 | $1,323 |
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 | $751 | $748 | $1,074 | $1,097 | $1,087 | $1,135 | $1,142 | $1,196 | $1,222 | $1,268 | $1,303 | $1,323 |
Long-term Liabilities | $30,000 | $29,613 | $29,222 | $28,828 | $28,431 | $28,030 | $27,627 | $27,219 | $26,809 | $26,395 | $25,977 | $25,556 | $25,132 |
Total Liabilities | $30,000 | $30,363 | $29,970 | $29,902 | $29,527 | $29,118 | $28,762 | $28,361 | $28,005 | $27,617 | $27,246 | $26,860 | $26,455 |
Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Retained Earnings | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($1,500) |
Earnings | $0 | ($910) | ($1,816) | ($4,632) | ($7,193) | ($9,809) | ($11,919) | ($13,928) | ($15,372) | ($16,522) | ($17,185) | ($17,629) | ($17,994) |
Total Capital | ($1,500) | ($2,410) | ($3,316) | ($6,132) | ($8,693) | ($11,309) | ($13,419) | ($15,428) | ($16,872) | ($18,022) | ($18,685) | ($19,129) | ($19,494) |
Total Liabilities and Capital | $28,500 | $27,954 | $26,653 | $23,770 | $20,834 | $17,808 | $15,343 | $12,934 | $11,133 | $9,595 | $8,560 | $7,731 | $6,961 |
Net Worth | ($1,500) | ($2,410) | ($3,316) | ($6,132) | ($8,693) | ($11,309) | ($13,419) | ($15,428) | ($16,872) | ($18,022) | ($18,685) | ($19,129) | ($19,494) |