Barton Interiors

Start your own business plan »

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
Residential Consulting 0% $800 $900 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $2,400 $2,800 $3,200 $3,600
Commercial Consulting 0% $0 $0 $0 $240 $280 $320 $360 $400 $440 $560 $640 $720
Product Sales 0% $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $2,400 $3,000 $3,600
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $1,200 $1,500 $1,800 $2,440 $2,880 $3,320 $3,760 $4,200 $4,840 $5,760 $6,840 $7,920
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
Residential Consulting $120 $135 $150 $180 $210 $240 $270 $300 $360 $420 $480 $540
Commercial Consulting $0 $0 $0 $36 $42 $48 $54 $60 $66 $84 $96 $108
Product Sales $220 $330 $440 $550 $660 $770 $880 $990 $1,100 $1,320 $1,650 $1,980
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $340 $465 $590 $766 $912 $1,058 $1,204 $1,350 $1,526 $1,824 $2,226 $2,628
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 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50% 9.50%
Long-term Interest Rate 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
Tax Rate 30.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.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 $1,200 $1,500 $1,800 $2,440 $2,880 $3,320 $3,760 $4,200 $4,840 $5,760 $6,840 $7,920
Direct Cost of Sales $340 $465 $590 $766 $912 $1,058 $1,204 $1,350 $1,526 $1,824 $2,226 $2,628
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $340 $465 $590 $766 $912 $1,058 $1,204 $1,350 $1,526 $1,824 $2,226 $2,628
Gross Margin $860 $1,035 $1,210 $1,674 $1,968 $2,262 $2,556 $2,850 $3,314 $3,936 $4,614 $5,292
Gross Margin % 71.67% 69.00% 67.22% 68.61% 68.33% 68.13% 67.98% 67.86% 68.47% 68.33% 67.46% 66.82%
Expenses
Payroll $1,200 $1,200 $1,200 $1,500 $1,500 $1,500 $1,800 $1,800 $1,800 $2,100 $2,100 $2,100
Sales and Marketing and Other Expenses $2,165 $615 $615 $885 $625 $625 $685 $685 $935 $685 $2,425 $615
Depreciation $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45 $45
Insurance $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $80
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,515 $1,965 $1,965 $2,535 $2,275 $2,275 $2,635 $2,635 $2,885 $2,935 $4,675 $2,865
Profit Before Interest and Taxes ($2,655) ($930) ($755) ($861) ($307) ($13) ($79) $215 $429 $1,001 ($61) $2,427
EBITDA ($2,630) ($905) ($730) ($836) ($282) $12 ($54) $240 $454 $1,026 ($36) $2,452
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($2,655) ($930) ($755) ($861) ($307) ($13) ($79) $215 $429 $1,001 ($61) $2,427
Net Profit/Sales -221.25% -62.00% -41.94% -35.29% -10.66% -0.39% -2.10% 5.12% 8.86% 17.38% -0.89% 30.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 $840 $1,050 $1,260 $1,708 $2,016 $2,324 $2,632 $2,940 $3,388 $4,032 $4,788 $5,544
Cash from Receivables $0 $12 $363 $453 $546 $736 $868 $1,000 $1,132 $1,266 $1,461 $1,739
Subtotal Cash from Operations $840 $1,062 $1,623 $2,161 $2,562 $3,060 $3,500 $3,940 $4,520 $5,298 $6,249 $7,283
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 $210 $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 $840 $1,062 $1,623 $2,371 $2,562 $3,060 $3,500 $3,940 $4,520 $5,298 $6,249 $7,283
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 $1,200 $1,200 $1,200 $1,500 $1,500 $1,500 $1,800 $1,800 $1,800 $2,100 $2,100 $2,100
Bill Payments $88 $2,583 $1,209 $1,345 $1,772 $1,667 $1,815 $2,019 $2,174 $2,588 $2,705 $4,729
Subtotal Spent on Operations $1,288 $3,783 $2,409 $2,845 $3,272 $3,167 $3,615 $3,819 $3,974 $4,688 $4,805 $6,829
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $1,288 $3,783 $2,409 $2,845 $3,272 $3,167 $3,615 $3,819 $3,974 $4,688 $4,805 $6,829
Net Cash Flow ($448) ($2,721) ($786) ($474) ($710) ($106) ($114) $122 $546 $611 $1,444 $454
Cash Balance $9,332 $6,612 $5,826 $5,352 $4,642 $4,536 $4,421 $4,543 $5,089 $5,700 $7,143 $7,597
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 $9,780 $9,332 $6,612 $5,826 $5,352 $4,642 $4,536 $4,421 $4,543 $5,089 $5,700 $7,143 $7,597
Accounts Receivable $0 $360 $798 $975 $1,254 $1,572 $1,831 $2,091 $2,350 $2,670 $3,132 $3,722 $4,360
Other Current Assets $1,000 $1,000 $1,000 $1,000 $790 $790 $790 $790 $790 $790 $790 $790 $790
Total Current Assets $10,780 $10,692 $8,410 $7,801 $7,396 $7,004 $7,157 $7,302 $7,683 $8,549 $9,621 $11,656 $12,747
Long-term Assets
Long-term Assets $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Accumulated Depreciation $0 $25 $50 $75 $100 $125 $150 $175 $200 $225 $250 $275 $300
Total Long-term Assets $3,000 $2,975 $2,950 $2,925 $2,900 $2,875 $2,850 $2,825 $2,800 $2,775 $2,750 $2,725 $2,700
Total Assets $13,780 $13,667 $11,360 $10,726 $10,296 $9,879 $10,007 $10,127 $10,483 $11,324 $12,371 $14,381 $15,447
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 $2,542 $1,165 $1,286 $1,717 $1,607 $1,748 $1,947 $2,088 $2,500 $2,546 $4,617 $3,256
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 $2,542 $1,165 $1,286 $1,717 $1,607 $1,748 $1,947 $2,088 $2,500 $2,546 $4,617 $3,256
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,542 $1,165 $1,286 $1,717 $1,607 $1,748 $1,947 $2,088 $2,500 $2,546 $4,617 $3,256
Paid-in Capital $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Retained Earnings ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220) ($11,220)
Earnings $0 ($2,655) ($3,585) ($4,340) ($5,201) ($5,508) ($5,521) ($5,600) ($5,385) ($4,956) ($3,955) ($4,016) ($1,589)
Total Capital $13,780 $11,125 $10,195 $9,440 $8,579 $8,272 $8,259 $8,180 $8,395 $8,824 $9,825 $9,764 $12,191
Total Liabilities and Capital $13,780 $13,667 $11,360 $10,726 $10,296 $9,879 $10,007 $10,127 $10,483 $11,324 $12,371 $14,381 $15,447
Net Worth $13,780 $11,125 $10,195 $9,440 $8,579 $8,272 $8,259 $8,180 $8,395 $8,824 $9,825 $9,764 $12,191
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
Jill Barton 0% $1,200 $1,200 $1,200 $1,500 $1,500 $1,500 $1,800 $1,800 $1,800 $2,100 $2,100 $2,100
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $1,200 $1,200 $1,200 $1,500 $1,500 $1,500 $1,800 $1,800 $1,800 $2,100 $2,100 $2,100