Hamlin and Park Design

Start your own business plan »

Home Interior Design Business Plan

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
Hamlin and Park Design home interior design business plan appendix. Hamlin and Park Design will offer interior design services to residential clients for new home construction, remodel projects, or redesign of existing spaces.