Hamlin and Park Design
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 | |||||||||||||
Remodeling Projects | 0% | $2,100 | $2,200 | $3,020 | $6,000 | $8,500 | $12,000 | $14,000 | $18,000 | $10,022 | $5,210 | $3,820 | $2,800 |
New Home Construction | 0% | $0 | $0 | $2,000 | $3,000 | $4,000 | $5,000 | $7,000 | $8,000 | $5,000 | $3,000 | $2,000 | $2,000 |
Interior Design of Existing Home | 0% | $3,000 | $3,000 | $4,240 | $6,300 | $9,000 | $11,000 | $14,000 | $17,000 | $13,000 | $4,322 | $3,222 | $2,655 |
Total Sales | $5,100 | $5,200 | $9,260 | $15,300 | $21,500 | $28,000 | $35,000 | $43,000 | $28,022 | $12,532 | $9,042 | $7,455 | |
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 | |
Remodeling Projects | $0 | $230 | $433 | $630 | $950 | $1,201 | $1,550 | $1,700 | $850 | $530 | $300 | $260 | |
New Home Construction | $0 | $0 | $300 | $400 | $500 | $600 | $700 | $900 | $800 | $600 | $400 | $300 | |
Interior Design of Existing Home | $0 | $320 | $590 | $800 | $1,002 | $1,202 | $1,409 | $1,650 | $1,200 | $390 | $280 | $248 | |
Subtotal Direct Cost of Sales | $0 | $550 | $1,323 | $1,830 | $2,452 | $3,003 | $3,659 | $4,250 | $2,850 | $1,520 | $980 | $808 |
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 | ||
Courtney Hamlin | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Katherine Park | 0% | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 |
Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
Total Payroll | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,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 | $5,100 | $5,200 | $9,260 | $15,300 | $21,500 | $28,000 | $35,000 | $43,000 | $28,022 | $12,532 | $9,042 | $7,455 | |
Direct Cost of Sales | $0 | $550 | $1,323 | $1,830 | $2,452 | $3,003 | $3,659 | $4,250 | $2,850 | $1,520 | $980 | $808 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $550 | $1,323 | $1,830 | $2,452 | $3,003 | $3,659 | $4,250 | $2,850 | $1,520 | $980 | $808 | |
Gross Margin | $5,100 | $4,650 | $7,937 | $13,470 | $19,048 | $24,997 | $31,341 | $38,750 | $25,172 | $11,012 | $8,062 | $6,647 | |
Gross Margin % | 100.00% | 89.42% | 85.71% | 88.04% | 88.60% | 89.28% | 89.55% | 90.12% | 89.83% | 87.87% | 89.16% | 89.16% | |
Expenses | |||||||||||||
Payroll | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Sales and Marketing and Other Expenses | $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 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Insurance | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Rent | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Payroll Taxes | 15% | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | |
Profit Before Interest and Taxes | ($8,200) | ($8,650) | ($5,363) | $170 | $5,748 | $11,697 | $18,041 | $25,450 | $11,872 | ($2,288) | ($5,238) | ($6,653) | |
EBITDA | ($8,200) | ($8,650) | ($5,363) | $170 | $5,748 | $11,697 | $18,041 | $25,450 | $11,872 | ($2,288) | ($5,238) | ($6,653) | |
Interest Expense | $245 | $241 | $236 | $232 | $227 | $223 | $218 | $213 | $209 | $204 | $200 | $195 | |
Taxes Incurred | ($2,534) | ($2,667) | ($1,680) | ($18) | $1,656 | $3,442 | $5,347 | $7,571 | $3,499 | ($748) | ($1,631) | ($2,054) | |
Net Profit | ($5,912) | ($6,224) | ($3,919) | ($43) | $3,865 | $8,032 | $12,476 | $17,666 | $8,164 | ($1,745) | ($3,806) | ($4,794) | |
Net Profit/Sales | -115.92% | -119.68% | -42.33% | -0.28% | 17.98% | 28.69% | 35.65% | 41.08% | 29.14% | -13.92% | -42.10% | -64.30% |
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 | $2,550 | $2,600 | $4,630 | $7,650 | $10,750 | $14,000 | $17,500 | $21,500 | $14,011 | $6,266 | $4,521 | $3,728 | |
Cash from Receivables | $0 | $85 | $2,552 | $2,668 | $4,731 | $7,753 | $10,858 | $14,117 | $17,633 | $21,250 | $13,753 | $6,208 | |
Subtotal Cash from Operations | $2,550 | $2,685 | $7,182 | $10,318 | $15,481 | $21,753 | $28,358 | $35,617 | $31,644 | $27,516 | $18,274 | $9,935 | |
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 | $2,550 | $2,685 | $7,182 | $10,318 | $15,481 | $21,753 | $28,358 | $35,617 | $31,644 | $27,516 | $18,274 | $9,935 | |
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 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | $8,000 | |
Bill Payments | $10,100 | $3,026 | $3,482 | $5,252 | $7,420 | $9,713 | $12,053 | $14,618 | $17,152 | $11,672 | $6,229 | $4,828 | |
Subtotal Spent on Operations | $18,100 | $11,026 | $11,482 | $13,252 | $15,420 | $17,713 | $20,053 | $22,618 | $25,152 | $19,672 | $14,229 | $12,828 | |
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 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | $550 | |
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 | $18,650 | $11,576 | $12,032 | $13,802 | $15,970 | $18,263 | $20,603 | $23,168 | $25,702 | $20,222 | $14,779 | $13,378 | |
Net Cash Flow | ($16,100) | ($8,891) | ($4,850) | ($3,484) | ($489) | $3,490 | $7,755 | $12,449 | $5,943 | $7,295 | $3,495 | ($3,443) | |
Cash Balance | $43,350 | $34,459 | $29,609 | $26,125 | $25,636 | $29,126 | $36,881 | $49,330 | $55,273 | $62,568 | $66,063 | $62,620 |
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 | $59,450 | $43,350 | $34,459 | $29,609 | $26,125 | $25,636 | $29,126 | $36,881 | $49,330 | $55,273 | $62,568 | $66,063 | $62,620 |
Accounts Receivable | $0 | $2,550 | $5,065 | $7,143 | $12,126 | $18,145 | $24,392 | $31,033 | $38,417 | $34,794 | $19,810 | $10,578 | $8,098 |
Other Current Assets | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
Total Current Assets | $79,450 | $65,900 | $59,524 | $56,752 | $58,250 | $63,781 | $73,518 | $87,915 | $107,747 | $110,067 | $102,378 | $96,641 | $90,717 |
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 | $79,450 | $65,900 | $59,524 | $56,752 | $58,250 | $63,781 | $73,518 | $87,915 | $107,747 | $110,067 | $102,378 | $96,641 | $90,717 |
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 | $10,000 | $2,911 | $3,309 | $5,007 | $7,098 | $9,314 | $11,569 | $14,040 | $16,757 | $11,462 | $6,067 | $4,687 | $4,107 |
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 | $10,000 | $2,911 | $3,309 | $5,007 | $7,098 | $9,314 | $11,569 | $14,040 | $16,757 | $11,462 | $6,067 | $4,687 | $4,107 |
Long-term Liabilities | $30,000 | $29,450 | $28,900 | $28,350 | $27,800 | $27,250 | $26,700 | $26,150 | $25,600 | $25,050 | $24,500 | $23,950 | $23,400 |
Total Liabilities | $40,000 | $32,361 | $32,209 | $33,357 | $34,898 | $36,564 | $38,269 | $40,190 | $42,357 | $36,512 | $30,567 | $28,637 | $27,507 |
Paid-in Capital | $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 |
Retained Earnings | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) | ($20,550) |
Earnings | $0 | ($5,912) | ($12,135) | ($16,055) | ($16,098) | ($12,233) | ($4,201) | $8,275 | $25,941 | $34,105 | $32,360 | $28,554 | $23,760 |
Total Capital | $39,450 | $33,538 | $27,315 | $23,395 | $23,352 | $27,217 | $35,249 | $47,725 | $65,391 | $73,555 | $71,810 | $68,004 | $63,210 |
Total Liabilities and Capital | $79,450 | $65,900 | $59,524 | $56,752 | $58,250 | $63,781 | $73,518 | $87,915 | $107,747 | $110,067 | $102,378 | $96,641 | $90,717 |
Net Worth | $39,450 | $33,538 | $27,315 | $23,395 | $23,352 | $27,217 | $35,249 | $47,725 | $65,391 | $73,555 | $71,810 | $68,004 | $63,210 |