Concrete Fabricators
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 |