Hass Irrigation Systems
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 | |||||||||||||
New Home Construction | 0% | $19,000 | $19,000 | $19,000 | $23,000 | $27,000 | $30,000 | $29,000 | $24,000 | $19,000 | $14,000 | $11,000 | $14,000 |
Landscaping Projects | 0% | $0 | $0 | $4,000 | $6,000 | $7,000 | $9,000 | $9,000 | $8,000 | $6,000 | $4,000 | $4,000 | $6,000 |
Total Sales | $19,000 | $19,000 | $23,000 | $29,000 | $34,000 | $39,000 | $38,000 | $32,000 | $25,000 | $18,000 | $15,000 | $20,000 | |
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 | |
New Home Construction | $5,000 | $5,000 | $5,000 | $6,400 | $7,800 | $9,000 | $8,000 | $6,400 | $5,000 | $4,000 | $3,000 | $4,000 | |
Landscaping Projects | $0 | $0 | $1,000 | $1,800 | $2,200 | $2,700 | $2,700 | $2,000 | $1,800 | $1,200 | $1,200 | $1,800 | |
Subtotal Direct Cost of Sales | $5,000 | $5,000 | $6,000 | $8,200 | $10,000 | $11,700 | $10,700 | $8,400 | $6,800 | $5,200 | $4,200 | $5,800 |
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 | ||
Andrew Hass | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Irrigation Crew Members (3) | 0% | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,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 | $19,000 | $19,000 | $23,000 | $29,000 | $34,000 | $39,000 | $38,000 | $32,000 | $25,000 | $18,000 | $15,000 | $20,000 | |
Direct Cost of Sales | $5,000 | $5,000 | $6,000 | $8,200 | $10,000 | $11,700 | $10,700 | $8,400 | $6,800 | $5,200 | $4,200 | $5,800 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $5,000 | $5,000 | $6,000 | $8,200 | $10,000 | $11,700 | $10,700 | $8,400 | $6,800 | $5,200 | $4,200 | $5,800 | |
Gross Margin | $14,000 | $14,000 | $17,000 | $20,800 | $24,000 | $27,300 | $27,300 | $23,600 | $18,200 | $12,800 | $10,800 | $14,200 | |
Gross Margin % | 73.68% | 73.68% | 73.91% | 71.72% | 70.59% | 70.00% | 71.84% | 73.75% | 72.80% | 71.11% | 72.00% | 71.00% | |
Expenses | |||||||||||||
Payroll | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | |
Sales and Marketing and Other Expenses | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Depreciation | $357 | $357 | $357 | $357 | $357 | $357 | $357 | $357 | $357 | $357 | $357 | $357 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Payroll Taxes | 15% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | $14,557 | |
Profit Before Interest and Taxes | ($557) | ($557) | $2,443 | $6,243 | $9,443 | $12,743 | $12,743 | $9,043 | $3,643 | ($1,757) | ($3,757) | ($357) | |
EBITDA | ($200) | ($200) | $2,800 | $6,600 | $9,800 | $13,100 | $13,100 | $9,400 | $4,000 | ($1,400) | ($3,400) | $0 | |
Interest Expense | $826 | $819 | $813 | $806 | $799 | $792 | $785 | $778 | $771 | $764 | $757 | $750 | |
Taxes Incurred | ($415) | ($413) | $489 | $1,631 | $2,593 | $3,585 | $3,587 | $2,480 | $862 | ($756) | ($1,354) | ($332) | |
Net Profit | ($968) | ($964) | $1,141 | $3,806 | $6,051 | $8,366 | $8,371 | $5,786 | $2,010 | ($1,765) | ($3,160) | ($775) | |
Net Profit/Sales | -5.10% | -5.07% | 4.96% | 13.12% | 17.80% | 21.45% | 22.03% | 18.08% | 8.04% | -9.80% | -21.07% | -3.87% |
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 | $4,750 | $4,750 | $5,750 | $7,250 | $8,500 | $9,750 | $9,500 | $8,000 | $6,250 | $4,500 | $3,750 | $5,000 | |
Cash from Receivables | $0 | $475 | $14,250 | $14,350 | $17,400 | $21,875 | $25,625 | $29,225 | $28,350 | $23,825 | $18,575 | $13,425 | |
Subtotal Cash from Operations | $4,750 | $5,225 | $20,000 | $21,600 | $25,900 | $31,625 | $35,125 | $37,225 | $34,600 | $28,325 | $22,325 | $18,425 | |
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 | $5,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $4,750 | $10,225 | $20,000 | $21,600 | $25,900 | $31,625 | $35,125 | $37,225 | $34,600 | $28,325 | $22,325 | $18,425 | |
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 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | |
Bill Payments | $154 | $4,611 | $4,636 | $5,539 | $6,842 | $13,104 | $22,015 | $18,011 | $13,246 | $10,765 | $7,616 | $6,885 | |
Subtotal Spent on Operations | $10,154 | $14,611 | $14,636 | $15,539 | $16,842 | $23,104 | $32,015 | $28,011 | $23,246 | $20,765 | $17,616 | $16,885 | |
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 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |
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 | $10,987 | $15,444 | $15,469 | $16,372 | $17,675 | $23,937 | $32,848 | $28,844 | $24,079 | $21,598 | $18,449 | $17,718 | |
Net Cash Flow | ($6,237) | ($5,219) | $4,531 | $5,228 | $8,225 | $7,688 | $2,277 | $8,381 | $10,521 | $6,727 | $3,876 | $707 | |
Cash Balance | $6,463 | $1,244 | $5,775 | $11,002 | $19,227 | $26,915 | $29,193 | $37,574 | $48,096 | $54,823 | $58,698 | $59,405 |
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 | $12,700 | $6,463 | $1,244 | $5,775 | $11,002 | $19,227 | $26,915 | $29,193 | $37,574 | $48,096 | $54,823 | $58,698 | $59,405 |
Accounts Receivable | $0 | $14,250 | $28,025 | $31,025 | $38,425 | $46,525 | $53,900 | $56,775 | $51,550 | $41,950 | $31,625 | $24,300 | $25,875 |
Inventory | $40,000 | $35,000 | $30,000 | $24,000 | $15,800 | $11,000 | $12,870 | $11,770 | $9,240 | $7,480 | $5,720 | $4,620 | $6,380 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $52,700 | $55,713 | $59,269 | $60,800 | $65,227 | $76,752 | $93,685 | $97,738 | $98,364 | $97,526 | $92,168 | $87,618 | $91,660 |
Long-term Assets | |||||||||||||
Long-term Assets | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 |
Accumulated Depreciation | $0 | $357 | $714 | $1,071 | $1,428 | $1,785 | $2,142 | $2,499 | $2,856 | $3,213 | $3,570 | $3,927 | $4,284 |
Total Long-term Assets | $50,000 | $49,643 | $49,286 | $48,929 | $48,572 | $48,215 | $47,858 | $47,501 | $47,144 | $46,787 | $46,430 | $46,073 | $45,716 |
Total Assets | $102,700 | $105,356 | $108,555 | $109,729 | $113,799 | $124,967 | $141,543 | $145,239 | $145,508 | $144,313 | $138,598 | $133,691 | $137,376 |
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 | $4,458 | $4,453 | $5,318 | $6,416 | $12,366 | $21,409 | $17,566 | $12,883 | $10,510 | $7,393 | $6,479 | $11,772 |
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 | $4,458 | $4,453 | $5,318 | $6,416 | $12,366 | $21,409 | $17,566 | $12,883 | $10,510 | $7,393 | $6,479 | $11,772 |
Long-term Liabilities | $100,000 | $99,167 | $98,334 | $97,501 | $96,668 | $95,835 | $95,002 | $94,169 | $93,336 | $92,503 | $91,670 | $90,837 | $90,004 |
Total Liabilities | $100,000 | $103,625 | $102,787 | $102,819 | $103,084 | $108,201 | $116,411 | $111,735 | $106,219 | $103,013 | $99,063 | $97,316 | $101,776 |
Paid-in Capital | $60,000 | $60,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 |
Retained Earnings | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) | ($57,300) |
Earnings | $0 | ($968) | ($1,932) | ($791) | $3,016 | $9,067 | $17,433 | $25,803 | $31,589 | $33,600 | $31,835 | $28,675 | $27,900 |
Total Capital | $2,700 | $1,732 | $5,768 | $6,909 | $10,716 | $16,767 | $25,133 | $33,503 | $39,289 | $41,300 | $39,535 | $36,375 | $35,600 |
Total Liabilities and Capital | $102,700 | $105,356 | $108,555 | $109,729 | $113,799 | $124,967 | $141,543 | $145,239 | $145,508 | $144,313 | $138,598 | $133,691 | $137,376 |
Net Worth | $2,700 | $1,732 | $5,768 | $6,909 | $10,716 | $16,767 | $25,133 | $33,503 | $39,289 | $41,300 | $39,535 | $36,375 | $35,600 |