Concrete Fabricators

Start your own business plan »

Formwork Construction Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Single Family Housing 0% $8,320 $10,920 $12,480 $11,180 $12,610 $13,790 $11,700 $11,700 $12,455 $12,870 $13,260 $13,114
Other Residential Housing 0% $3,200 $4,200 $4,800 $4,300 $4,850 $5,304 $4,500 $4,500 $4,790 $4,950 $5,100 $5,044
Commercial Construction 0% $4,480 $5,880 $6,720 $6,020 $6,790 $7,426 $6,300 $6,300 $6,707 $6,930 $7,140 $7,062
Total Sales $16,000 $21,000 $24,000 $21,500 $24,250 $26,520 $22,500 $22,500 $23,952 $24,750 $25,500 $25,220
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Single Family Housing $433 $433 $433 $433 $433 $433 $433 $433 $433 $433 $433 $433
Other Residential Housing $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167
Commercial Construction $233 $233 $233 $233 $233 $233 $233 $233 $233 $233 $233 $233
Subtotal Direct Cost of Sales $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Lloyd James 0% $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Anne James 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Sam McDonald 0% $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Cement Layer No. 1 0% $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842
Cement Layer No. 2 0% $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842
Cement Layer No. 3 0% $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842 $1,842
Part time Cement Layer No.4 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Part time Cement Layer No. 5 0% $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 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626
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 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% 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 $16,000 $21,000 $24,000 $21,500 $24,250 $26,520 $22,500 $22,500 $23,952 $24,750 $25,500 $25,220
Direct Cost of Sales $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Other $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Total Cost of Sales $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083 $1,083
Gross Margin $14,917 $19,917 $22,917 $20,417 $23,167 $25,437 $21,417 $21,417 $22,869 $23,667 $24,417 $24,137
Gross Margin % 93.23% 94.84% 95.49% 94.96% 95.53% 95.92% 95.19% 95.19% 95.48% 95.62% 95.75% 95.70%
Expenses
Payroll $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626
Sales and Marketing and Other Expenses $2,862 $2,862 $2,862 $2,862 $2,862 $2,862 $2,862 $2,862 $2,862 $2,862 $2,862 $2,862
Depreciation $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Rent/Mortgage $1,035 $1,035 $1,035 $1,035 $1,035 $1,035 $1,035 $1,035 $1,035 $1,035 $1,035 $1,035
Supplies and Equipment $827 $827 $827 $827 $827 $827 $827 $827 $827 $827 $827 $827
Insurance $1,205 $1,205 $1,205 $1,205 $1,205 $1,205 $1,205 $1,205 $1,205 $1,205 $1,205 $1,205
Services $236 $236 $236 $236 $236 $236 $236 $236 $236 $236 $236 $236
Payroll Taxes 15% $829 $829 $829 $829 $829 $829 $829 $829 $829 $829 $829 $829
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $22,620 $22,620 $22,620 $22,620 $22,620 $22,620 $22,620 $22,620 $22,620 $22,620 $22,620 $22,620
Profit Before Interest and Taxes ($7,703) ($2,703) $297 ($2,203) $547 $2,817 ($1,203) ($1,203) $249 $1,047 $1,797 $1,517
EBITDA ($3,703) $1,297 $4,297 $1,797 $4,547 $6,817 $2,797 $2,797 $4,249 $5,047 $5,797 $5,517
Interest Expense $161 $156 $151 $146 $141 $136 $131 $126 $121 $116 $111 $106
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($7,864) ($2,859) $146 ($2,349) $406 $2,681 ($1,334) ($1,329) $128 $931 $1,686 $1,411
Net Profit/Sales -49.15% -13.61% 0.61% -10.92% 1.68% 10.11% -5.93% -5.91% 0.54% 3.76% 6.61% 5.60%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $4,000 $5,250 $6,000 $5,375 $6,063 $6,630 $5,625 $5,625 $5,988 $6,188 $6,375 $6,305
Cash from Receivables $11,663 $12,063 $12,125 $15,825 $17,938 $16,194 $18,244 $19,790 $16,875 $16,911 $17,984 $18,581
Subtotal Cash from Operations $15,663 $17,313 $18,125 $21,200 $24,000 $22,824 $23,869 $25,415 $22,863 $23,099 $24,359 $24,886
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 $2,000 $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 $3,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $20,663 $17,313 $18,125 $21,200 $24,000 $22,824 $23,869 $25,415 $22,863 $23,099 $24,359 $24,886
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626 $11,626
Bill Payments $40,871 $8,238 $8,233 $8,228 $8,223 $8,218 $8,213 $8,208 $8,203 $8,198 $8,193 $8,188
Subtotal Spent on Operations $52,497 $19,864 $19,859 $19,854 $19,849 $19,844 $19,839 $19,834 $19,829 $19,824 $19,819 $19,814
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 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Other Liabilities Principal Repayment $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Long-term Liabilities Principal Repayment $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
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 $53,497 $20,964 $20,959 $20,954 $20,949 $20,944 $20,939 $20,934 $20,929 $20,924 $20,919 $20,914
Net Cash Flow ($32,834) ($3,651) ($2,834) $246 $3,051 $1,880 $2,931 $4,481 $1,934 $2,175 $3,440 $3,973
Cash Balance $12,474 $8,824 $5,990 $6,236 $9,287 $11,167 $14,098 $18,579 $20,513 $22,688 $26,128 $30,101
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $45,308 $12,474 $8,824 $5,990 $6,236 $9,287 $11,167 $14,098 $18,579 $20,513 $22,688 $26,128 $30,101
Accounts Receivable $23,326 $23,663 $27,350 $33,225 $33,525 $33,775 $37,471 $36,102 $33,188 $34,277 $35,928 $37,069 $37,403
Other Current Assets $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830 $8,830
Total Current Assets $77,464 $44,967 $45,004 $48,045 $48,591 $51,892 $57,469 $59,030 $60,596 $63,620 $67,446 $72,027 $76,333
Long-term Assets
Long-term Assets $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687 $507,687
Accumulated Depreciation $45,691 $49,691 $53,691 $57,690 $61,690 $65,690 $69,690 $73,689 $77,689 $81,689 $85,689 $89,688 $93,688
Total Long-term Assets $461,996 $457,996 $453,997 $449,997 $445,997 $441,997 $437,998 $433,998 $429,998 $425,998 $421,999 $417,999 $413,999
Total Assets $539,460 $502,964 $499,000 $498,042 $494,588 $493,890 $495,466 $493,028 $490,594 $489,618 $489,444 $490,026 $490,332
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $40,596 $7,963 $7,958 $7,954 $7,949 $7,944 $7,939 $7,934 $7,929 $7,925 $7,920 $7,915 $7,910
Current Borrowing $0 $2,000 $1,900 $1,800 $1,700 $1,600 $1,500 $1,400 $1,300 $1,200 $1,100 $1,000 $900
Other Current Liabilities $22,785 $22,285 $21,785 $21,285 $20,785 $20,285 $19,785 $19,285 $18,785 $18,285 $17,785 $17,285 $16,785
Subtotal Current Liabilities $63,381 $32,248 $31,643 $31,039 $30,434 $29,829 $29,224 $28,619 $28,014 $27,410 $26,805 $26,200 $25,595
Long-term Liabilities $17,766 $17,266 $16,766 $16,266 $15,766 $15,266 $14,766 $14,266 $13,766 $13,266 $12,766 $12,266 $11,766
Total Liabilities $81,147 $49,514 $48,409 $47,305 $46,200 $45,095 $43,990 $42,885 $41,780 $40,676 $39,571 $38,466 $37,361
Paid-in Capital $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
Retained Earnings $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313 $458,313
Earnings $0 ($7,864) ($10,722) ($10,576) ($12,925) ($12,518) ($9,837) ($11,171) ($12,499) ($12,371) ($11,440) ($9,753) ($8,342)
Total Capital $458,313 $453,449 $450,591 $450,737 $448,388 $448,795 $451,476 $450,142 $448,814 $448,942 $449,873 $451,560 $452,971
Total Liabilities and Capital $539,460 $502,964 $499,000 $498,042 $494,588 $493,890 $495,466 $493,028 $490,594 $489,618 $489,444 $490,026 $490,332
Net Worth $458,313 $453,449 $450,591 $450,737 $448,388 $448,795 $451,476 $450,142 $448,814 $448,942 $449,874 $451,560 $452,971