HodgePodge Sealcoating Company

Start your own business plan »

Construction Repair 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
Middle to upper class 0% $0 $0 $1,456 $2,564 $3,545 $4,785 $5,265 $6,500 $6,014 $0 $0 $0
Older people 0% $0 $0 $1,345 $2,478 $3,654 $4,875 $6,000 $5,325 $5,874 $0 $0 $0
Total Sales $0 $0 $2,801 $5,042 $7,199 $9,660 $11,265 $11,825 $11,888 $0 $0 $0
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
Middle to upper class $0 $0 $146 $256 $355 $479 $527 $650 $601 $0 $0 $0
Older people $0 $0 $135 $248 $365 $488 $600 $533 $587 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $280 $504 $720 $966 $1,127 $1,183 $1,189 $0 $0 $0
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
Dan 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Employee 1 0% $0 $0 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $0 $0 $0
Employee 2 0% $0 $0 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $0 $0 $0
Employee 3 0% $0 $0 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $0 $0 $0
Employee 4 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Employee 5 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Employee 6 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 41 4 4 4 4 4 4 4 1 1 1
Total Payroll $3,000 $3,000 $6,840 $6,840 $6,840 $6,840 $6,840 $6,840 $6,840 $3,000 $3,000 $3,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 $2,801 $5,042 $7,199 $9,660 $11,265 $11,825 $11,888 $0 $0 $0
Direct Cost of Sales $0 $0 $280 $504 $720 $966 $1,127 $1,183 $1,189 $0 $0 $0
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $280 $504 $720 $966 $1,127 $1,183 $1,189 $0 $0 $0
Gross Margin $0 $0 $2,521 $4,538 $6,479 $8,694 $10,139 $10,643 $10,699 $0 $0 $0
Gross Margin % 0.00% 0.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 0.00% 0.00% 0.00%
Expenses
Payroll $3,000 $3,000 $6,840 $6,840 $6,840 $6,840 $6,840 $6,840 $6,840 $3,000 $3,000 $3,000
Sales and Marketing and Other Expenses $0 $0 $100 $100 $100 $100 $100 $100 $100 $0 $0 $0
Depreciation $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180 $180
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Rent $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Payroll Taxes 15% $450 $450 $1,026 $1,026 $1,026 $1,026 $1,026 $1,026 $1,026 $450 $450 $450
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,180 $4,180 $8,696 $8,696 $8,696 $8,696 $8,696 $8,696 $8,696 $4,180 $4,180 $4,180
Profit Before Interest and Taxes ($4,180) ($4,180) ($6,175) ($4,158) ($2,217) ($2) $1,443 $1,947 $2,003 ($4,180) ($4,180) ($4,180)
EBITDA ($4,000) ($4,000) ($5,995) ($3,978) ($2,037) $178 $1,623 $2,127 $2,183 ($4,000) ($4,000) ($4,000)
Interest Expense ($1) ($2) ($3) ($3) ($4) ($5) ($6) ($7) ($8) ($8) ($9) ($10)
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,179) ($4,178) ($6,173) ($4,155) ($2,213) $3 $1,448 $1,953 $2,011 ($4,172) ($4,171) ($4,170)
Net Profit/Sales 0.00% 0.00% -220.37% -82.41% -30.74% 0.03% 12.86% 16.52% 16.91% 0.00% 0.00% 0.00%
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 $2,801 $5,042 $7,199 $9,660 $11,265 $11,825 $11,888 $0 $0 $0
Subtotal Cash from Operations $0 $0 $2,801 $5,042 $7,199 $9,660 $11,265 $11,825 $11,888 $0 $0 $0
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 $2,801 $5,042 $7,199 $9,660 $11,265 $11,825 $11,888 $0 $0 $0
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 $3,000 $3,000 $6,840 $6,840 $6,840 $6,840 $6,840 $6,840 $6,840 $3,000 $3,000 $3,000
Bill Payments $33 $999 $1,030 $1,961 $2,184 $2,400 $2,642 $2,799 $2,852 $2,795 $992 $991
Subtotal Spent on Operations $3,033 $3,999 $7,870 $8,801 $9,024 $9,240 $9,482 $9,639 $9,692 $5,795 $3,992 $3,991
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 $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 $3,133 $4,099 $7,970 $8,901 $9,124 $9,340 $9,582 $9,739 $9,792 $5,895 $4,092 $4,091
Net Cash Flow ($3,133) ($4,099) ($5,169) ($3,859) ($1,925) $320 $1,683 $2,086 $2,096 ($5,895) ($4,092) ($4,091)
Cash Balance $25,667 $21,568 $16,398 $12,539 $10,614 $10,934 $12,617 $14,704 $16,800 $10,904 $6,813 $2,722
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 $28,800 $25,667 $21,568 $16,398 $12,539 $10,614 $10,934 $12,617 $14,704 $16,800 $10,904 $6,813 $2,722
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $28,800 $25,667 $21,568 $16,398 $12,539 $10,614 $10,934 $12,617 $14,704 $16,800 $10,904 $6,813 $2,722
Long-term Assets
Long-term Assets $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800 $10,800
Accumulated Depreciation $0 $180 $360 $540 $720 $900 $1,080 $1,260 $1,440 $1,620 $1,800 $1,980 $2,160
Total Long-term Assets $10,800 $10,620 $10,440 $10,260 $10,080 $9,900 $9,720 $9,540 $9,360 $9,180 $9,000 $8,820 $8,640
Total Assets $39,600 $36,287 $32,008 $26,658 $22,619 $20,514 $20,654 $22,157 $24,064 $25,980 $19,904 $15,633 $11,362
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 $966 $965 $1,888 $2,104 $2,312 $2,549 $2,703 $2,757 $2,762 $959 $958 $957
Current Borrowing $0 ($100) ($200) ($300) ($400) ($500) ($600) ($700) ($800) ($900) ($1,000) ($1,100) ($1,200)
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $866 $765 $1,588 $1,704 $1,812 $1,949 $2,003 $1,957 $1,862 ($41) ($142) ($243)
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $866 $765 $1,588 $1,704 $1,812 $1,949 $2,003 $1,957 $1,862 ($41) ($142) ($243)
Paid-in Capital $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Retained Earnings ($400) ($400) ($400) ($400) ($400) ($400) ($400) ($400) ($400) ($400) ($400) ($400) ($400)
Earnings $0 ($4,179) ($8,358) ($14,530) ($18,685) ($20,898) ($20,895) ($19,446) ($17,493) ($15,483) ($19,654) ($23,825) ($27,995)
Total Capital $39,600 $35,421 $31,243 $25,070 $20,915 $18,702 $18,705 $20,154 $22,107 $24,118 $19,946 $15,775 $11,605
Total Liabilities and Capital $39,600 $36,287 $32,008 $26,658 $22,619 $20,514 $20,654 $22,157 $24,064 $25,980 $19,904 $15,633 $11,362
Net Worth $39,600 $35,421 $31,243 $25,070 $20,915 $18,702 $18,705 $20,154 $22,107 $24,118 $19,946 $15,775 $11,605