Comgate

Start your own business plan »

Remodeling Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Unit Sales
Crown Molding 0% 357 357 357 357 357 357 357 357 357 342 342 342
Pilasters 0% 17 17 17 17 17 17 17 17 17 22 22 22
Haunched Passage Doors (Paint Grade) 0% 17 17 17 17 17 17 17 17 17 27 27 27
Haunched Passage Doors (Stain Grade) 0% 17 17 17 17 17 17 17 17 17 27 27 27
Cabinets 0% 40 40 40 40 40 40 40 40 40 77 77 77
Site Work 0% 523 523 523 523 523 523 523 523 523 980 980 980
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 971 971 971 971 971 971 971 971 971 1,475 1,475 1,475
Unit Prices Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Crown Molding $4.20 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00
Pilasters $316.96 $316.96 $316.96 $316.96 $316.96 $316.96 $316.96 $316.96 $316.96 $316.96 $316.96 $316.96
Haunched Passage Doors (Paint Grade) $592.35 $592.35 $592.35 $592.35 $592.35 $592.35 $592.35 $592.35 $592.35 $592.35 $592.35 $592.35
Haunched Passage Doors (Stain Grade) $783.09 $783.09 $783.09 $783.09 $783.09 $783.09 $783.09 $783.09 $783.09 $783.09 $783.09 $783.09
Cabinets $194.76 $194.76 $194.76 $194.76 $194.76 $194.76 $194.76 $194.76 $194.76 $194.76 $194.76 $194.76
Site Work $35.33 $35.33 $35.33 $35.33 $35.33 $35.33 $35.33 $35.33 $35.33 $35.33 $35.33 $35.33
Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Crown Molding $1,499 $1,428 $1,428 $1,428 $1,428 $1,428 $1,428 $1,428 $1,428 $1,368 $1,368 $1,368
Pilasters $5,388 $5,388 $5,388 $5,388 $5,388 $5,388 $5,388 $5,388 $5,388 $6,973 $6,973 $6,973
Haunched Passage Doors (Paint Grade) $10,070 $10,070 $10,070 $10,070 $10,070 $10,070 $10,070 $10,070 $10,070 $15,993 $15,993 $15,993
Haunched Passage Doors (Stain Grade) $13,313 $13,313 $13,313 $13,313 $13,313 $13,313 $13,313 $13,313 $13,313 $21,143 $21,143 $21,143
Cabinets $7,790 $7,790 $7,790 $7,790 $7,790 $7,790 $7,790 $7,790 $7,790 $14,997 $14,997 $14,997
Site Work $18,478 $18,478 $18,478 $18,478 $18,478 $18,478 $18,478 $18,478 $18,478 $34,623 $34,623 $34,623
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $56,538 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $95,098 $95,098 $95,098
Direct Unit Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Crown Molding 0.00% $2.06 $2.06 $2.06 $2.06 $2.06 $2.06 $2.06 $2.06 $2.06 $1.82 $1.82 $1.82
Pilasters 0.00% $50.04 $50.04 $50.04 $50.04 $50.04 $50.04 $50.04 $50.04 $50.04 $44.09 $44.09 $44.09
Haunched Passage Doors (Paint Grade) 0.00% $148.15 $148.15 $148.15 $148.15 $148.15 $148.15 $148.15 $148.15 $148.15 $130.53 $130.53 $130.53
Haunched Passage Doors (Stain Grade) 0.00% $281.34 $281.34 $281.34 $281.34 $281.34 $281.34 $281.34 $281.34 $281.34 $247.88 $247.88 $247.88
Cabinets 0.00% $65.44 $65.44 $65.44 $65.44 $65.44 $65.44 $65.44 $65.44 $65.44 $57.66 $57.66 $57.66
Site Work 0.00% $24.53 $24.53 $24.53 $24.53 $24.53 $24.53 $24.53 $24.53 $24.53 $27.69 $27.69 $27.69
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Crown Molding $735 $735 $735 $735 $735 $735 $735 $735 $735 $622 $622 $622
Pilasters $851 $851 $851 $851 $851 $851 $851 $851 $851 $970 $970 $970
Haunched Passage Doors (Paint Grade) $2,519 $2,519 $2,519 $2,519 $2,519 $2,519 $2,519 $2,519 $2,519 $3,524 $3,524 $3,524
Haunched Passage Doors (Stain Grade) $4,783 $4,783 $4,783 $4,783 $4,783 $4,783 $4,783 $4,783 $4,783 $6,693 $6,693 $6,693
Cabinets $2,618 $2,618 $2,618 $2,618 $2,618 $2,618 $2,618 $2,618 $2,618 $4,440 $4,440 $4,440
Site Work $12,829 $12,829 $12,829 $12,829 $12,829 $12,829 $12,829 $12,829 $12,829 $27,136 $27,136 $27,136
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $43,386 $43,386 $43,386
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Production Personnel
**David Malkinson $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,467 $3,467 $3,467
**Simon Lang $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $2,890 $2,890 $2,890
**Brian Mason $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,890 $2,890 $2,890
Production/Project Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
**Charles Davidson $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,185 $3,230 $3,230 $3,230
Subtotal $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $12,477 $12,477 $12,477
Sales and Marketing Personnel
Andrew Comins $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333
General and Administrative Personnel
**Stacy Greer $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860
Other Personnel
Name or Title $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
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $18,670 $18,670 $18,670
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $56,538 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $95,098 $95,098 $95,098
Direct Cost of Sales $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $24,334 $43,386 $43,386 $43,386
Production Payroll $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $9,555 $12,477 $12,477 $12,477
Other $3,089 $3,089 $3,089 $3,089 $3,089 $3,089 $3,089 $3,089 $5,539 $5,539 $5,539 $5,539
Total Cost of Sales $36,978 $36,978 $36,978 $36,978 $36,978 $36,978 $36,978 $36,978 $39,428 $61,402 $61,402 $61,402
Gross Margin $19,560 $19,489 $19,489 $19,489 $19,489 $19,489 $19,489 $19,489 $17,039 $33,696 $33,696 $33,696
Gross Margin % 34.60% 34.51% 34.51% 34.51% 34.51% 34.51% 34.51% 34.51% 30.17% 35.43% 35.43% 35.43%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333
Advertising/Promotion $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Travel $50 $50 $50 $50 $50 $50 $50 $50 $50 $100 $100 $100
Miscellaneous $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $3,383 $3,383 $3,383 $3,383 $3,383 $3,383 $3,383 $3,383 $3,383 $3,433 $3,433 $3,433
Sales and Marketing % 5.98% 5.99% 5.99% 5.99% 5.99% 5.99% 5.99% 5.99% 5.99% 3.61% 3.61% 3.61%
General and Administrative Expenses
General and Administrative Payroll $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860 $2,860
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220 $2,220
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $456 $456 $456 $456 $456 $456 $456 $456 $456 $456 $456 $456
Depreciation $27 $27 $27 $27 $27 $27 $27 $27 $27 $27 $27 $27
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Fees and Permits $390 $390 $390 $390 $390 $390 $390 $390 $390 $390 $390 $390
Office Supplies $346 $346 $346 $346 $346 $346 $346 $346 $346 $346 $346 $346
Bank Charges $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40
Rent $196 $196 $196 $196 $196 $196 $196 $196 $196 $196 $196 $196
Payroll Taxes 22% $3,457 $3,457 $3,457 $3,457 $3,457 $3,457 $3,457 $3,457 $3,457 $4,098 $4,098 $4,098
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $10,442 $10,442 $10,442 $10,442 $10,442 $10,442 $10,442 $10,442 $10,442 $11,083 $11,083 $11,083
General and Administrative % 18.47% 18.49% 18.49% 18.49% 18.49% 18.49% 18.49% 18.49% 18.49% 11.65% 11.65% 11.65%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $1,925 $1,925 $1,925 $1,925 $1,925 $3,625 $1,925 $1,925 $3,725 $5,550 $5,150 $5,200
CAD Contract Employee $0 $0 $0 $0 $0 $0 $0 $0 $1,633 $1,633 $1,633 $1,633
Total Other Expenses $1,925 $1,925 $1,925 $1,925 $1,925 $3,625 $1,925 $1,925 $5,358 $7,183 $6,783 $6,833
Other % 3.40% 3.41% 3.41% 3.41% 3.41% 6.42% 3.41% 3.41% 9.49% 7.55% 7.13% 7.19%
Total Operating Expenses $15,750 $15,750 $15,750 $15,750 $15,750 $17,450 $15,750 $15,750 $19,183 $21,699 $21,299 $21,349
Profit Before Interest and Taxes $3,810 $3,739 $3,739 $3,739 $3,739 $2,039 $3,739 $3,739 ($2,144) $11,997 $12,397 $12,347
EBITDA $6,030 $5,959 $5,959 $5,959 $5,959 $4,259 $5,959 $5,959 $76 $14,217 $14,617 $14,567
Interest Expense $1,313 $1,303 $1,293 $1,283 $1,274 $1,264 $1,669 $1,650 $1,631 $1,612 $1,594 $1,575
Taxes Incurred $749 $609 $611 $614 $616 $194 $518 $522 ($944) $2,596 $2,701 $2,693
Net Profit $1,748 $1,827 $1,834 $1,842 $1,849 $581 $1,553 $1,567 ($2,831) $7,789 $8,103 $8,079
Net Profit/Sales 3.09% 3.24% 3.25% 3.26% 3.27% 1.03% 2.75% 2.77% -5.01% 8.19% 8.52% 8.50%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash from Receivables $80,657 $82,541 $56,536 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $57,754 $95,098
Subtotal Cash from Operations $80,657 $82,541 $56,536 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $56,467 $57,754 $95,098
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 $54,072 $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 $108,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $80,657 $82,541 $164,536 $56,467 $56,467 $56,467 $110,539 $56,467 $56,467 $56,467 $57,754 $95,098
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $15,748 $18,670 $18,670 $18,670
Bill Payments $60,247 $56,409 $36,672 $36,664 $36,657 $36,692 $37,885 $36,946 $37,078 $42,865 $86,666 $66,106
Subtotal Spent on Operations $75,995 $72,157 $52,420 $52,412 $52,405 $52,440 $53,633 $52,694 $52,826 $61,535 $105,336 $84,776
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 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Other Liabilities Principal Repayment $0 $8,126 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $0 $2,400 $2,400 $2,400 $2,300 $2,400
Purchase Other Current Assets $0 $0 $0 $2,855 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $50,000 $0 $0 $60,412 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $5,992 $0 $0 $0 $0
Subtotal Cash Spent $77,295 $81,583 $103,720 $56,567 $53,705 $114,152 $53,733 $61,186 $55,326 $64,035 $107,736 $87,276
Net Cash Flow $3,362 $958 $60,816 ($101) $2,762 ($57,685) $56,806 ($4,719) $1,140 ($7,568) ($49,982) $7,822
Cash Balance $7,350 $8,307 $69,124 $69,023 $71,785 $14,099 $70,905 $66,186 $67,327 $59,759 $9,777 $17,598
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $3,988 $7,350 $8,307 $69,124 $69,023 $71,785 $14,099 $70,905 $66,186 $67,327 $59,759 $9,777 $17,598
Accounts Receivable $161,313 $137,195 $111,120 $111,051 $111,051 $111,051 $111,051 $111,051 $111,051 $111,051 $149,682 $187,026 $187,026
Inventory $6,500 $26,768 $26,768 $26,768 $26,768 $26,768 $26,768 $26,768 $26,768 $26,768 $47,724 $47,724 $47,724
Other Current Assets $0 $0 $0 $0 $2,855 $2,855 $2,855 $2,855 $2,855 $2,855 $2,855 $2,855 $2,855
Total Current Assets $171,801 $171,312 $146,196 $206,943 $209,697 $212,459 $154,773 $211,579 $206,860 $208,001 $260,020 $247,382 $255,203
Long-term Assets
Long-term Assets $140,203 $140,203 $140,203 $190,203 $190,203 $190,203 $250,615 $250,615 $250,615 $250,615 $250,615 $250,615 $250,615
Accumulated Depreciation $104,893 $107,113 $109,333 $111,553 $113,773 $115,993 $118,213 $120,433 $122,653 $124,873 $127,093 $129,313 $131,533
Total Long-term Assets $35,310 $33,090 $30,870 $78,650 $76,430 $74,210 $132,402 $130,182 $127,962 $125,742 $123,522 $121,302 $119,082
Total Assets $207,111 $204,402 $177,066 $285,593 $286,127 $286,669 $287,175 $341,761 $334,822 $333,743 $383,542 $368,684 $374,285
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $58,344 $55,187 $35,450 $35,442 $35,435 $35,428 $36,654 $35,714 $35,701 $39,952 $84,463 $63,902 $63,924
Current Borrowing $69,477 $69,377 $69,277 $69,177 $69,077 $68,977 $68,877 $68,777 $68,677 $68,577 $68,477 $68,377 $68,277
Other Current Liabilities $10,000 $10,000 $1,874 $1,874 $1,874 $1,874 $1,874 $1,874 $1,874 $1,874 $1,874 $1,874 $1,874
Subtotal Current Liabilities $137,821 $134,564 $106,601 $106,493 $106,386 $106,279 $107,405 $106,365 $106,252 $110,403 $154,814 $134,153 $134,075
Long-term Liabilities $99,179 $97,979 $96,779 $95,579 $94,379 $93,179 $91,979 $146,051 $143,651 $141,251 $138,851 $136,551 $134,151
Total Liabilities $237,000 $232,543 $203,380 $202,072 $200,765 $199,458 $199,384 $252,416 $249,903 $251,654 $293,665 $270,704 $268,226
Paid-in Capital $2,000 $2,000 $2,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000
Retained Earnings ($65,014) ($31,889) ($31,889) ($31,889) ($31,889) ($31,889) ($31,889) ($31,889) ($37,881) ($37,881) ($37,881) ($37,881) ($37,881)
Earnings $33,125 $1,748 $3,575 $5,409 $7,251 $9,100 $9,681 $11,234 $12,801 $9,969 $17,758 $25,861 $33,940
Total Capital ($29,889) ($28,141) ($26,314) $83,520 $85,362 $87,211 $87,792 $89,345 $84,920 $82,088 $89,877 $97,980 $106,059
Total Liabilities and Capital $207,111 $204,402 $177,066 $285,593 $286,127 $286,669 $287,175 $341,761 $334,822 $333,743 $383,542 $368,684 $374,285
Net Worth ($29,889) ($28,141) ($26,314) $83,520 $85,362 $87,211 $87,792 $89,345 $84,920 $82,088 $89,877 $97,980 $106,059