Willow Park Golf Course

Start your own business plan »

Golf Course 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
Memberships/Use Fees 0% $20,000 $30,000 $40,000 $40,000 $40,000 $45,000 $45,000 $50,000 $45,000 $40,000 $25,000 $25,000
Day Use Fees (for 1 or more days) 0% $20,000 $20,000 $20,000 $30,000 $30,000 $35,000 $35,000 $40,000 $35,000 $30,000 $15,000 $15,000
Golf Lessons 0% $8,000 $16,000 $20,000 $20,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $10,000 $10,000
Snacks 0% $16,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $12,000 $12,000
Pro Shop 0% $4,000 $10,000 $8,000 $7,000 $7,000 $4,000 $5,000 $6,000 $5,000 $4,500 $8,000 $12,000
Driving Range 0% $5,000 $6,000 $7,000 $8,000 $9,000 $11,000 $11,000 $12,000 $11,000 $9,000 $8,000 $6,000
Total Sales $73,000 $106,000 $119,000 $129,000 $135,000 $144,000 $145,000 $157,000 $145,000 $132,500 $78,000 $80,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
Memberships/Use Fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Day Use Fees (for 1 or more days) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Golf Lessons $4,000 $8,000 $10,000 $10,000 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $5,000 $5,000
Snacks $4,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $3,000 $3,000
Pro Shop $1,400 $4,000 $3,600 $3,000 $3,000 $1,500 $2,300 $2,700 $2,300 $1,500 $3,000 $4,000
Driving Range $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750 $1,750
Subtotal Direct Cost of Sales $11,150 $19,750 $21,350 $20,750 $23,250 $21,750 $22,550 $22,950 $22,550 $21,750 $12,750 $13,750
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
Manager 0% $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Assistant Manager 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Pro Shop Manager/Head Teaching Pro 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Greeens/Landscape Superintendent 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Course Staff 0% $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000 $13,000
Snack Shop Staff 0% $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Pro Shop Staff 0% $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Greens Maintenance Staff 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Golf Cart Maintenance Staff 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 24 24 24 24 24 24 24 24 24 24 24 24
Total Payroll $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,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 $73,000 $106,000 $119,000 $129,000 $135,000 $144,000 $145,000 $157,000 $145,000 $132,500 $78,000 $80,000
Direct Cost of Sales $11,150 $19,750 $21,350 $20,750 $23,250 $21,750 $22,550 $22,950 $22,550 $21,750 $12,750 $13,750
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $11,150 $19,750 $21,350 $20,750 $23,250 $21,750 $22,550 $22,950 $22,550 $21,750 $12,750 $13,750
Gross Margin $61,850 $86,250 $97,650 $108,250 $111,750 $122,250 $122,450 $134,050 $122,450 $110,750 $65,250 $66,250
Gross Margin % 84.73% 81.37% 82.06% 83.91% 82.78% 84.90% 84.45% 85.38% 84.45% 83.58% 83.65% 82.81%
Expenses
Payroll $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000
Sales and Marketing and Other Expenses $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Depreciation $2,380 $2,380 $2,380 $2,380 $2,380 $2,380 $2,380 $2,380 $2,380 $2,380 $2,380 $2,380
Leased Equipment $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Utilities $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $1,500 $1,300 $1,300 $1,300 $1,300 $1,300
Insurance $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Lease $20,833 $20,833 $20,833 $20,833 $20,833 $20,833 $20,833 $20,833 $20,833 $20,833 $20,833 $20,837
Payroll Taxes 15% $7,350 $7,350 $7,350 $7,350 $7,350 $7,350 $7,350 $7,350 $7,350 $7,350 $7,350 $7,350
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $95,563 $95,563 $95,563 $95,563 $95,563 $95,563 $94,063 $93,863 $93,863 $93,863 $93,863 $93,867
Profit Before Interest and Taxes ($33,713) ($9,313) $2,087 $12,687 $16,187 $26,687 $28,387 $40,187 $28,587 $16,887 ($28,613) ($27,617)
EBITDA ($31,333) ($6,933) $4,467 $15,067 $18,567 $29,067 $30,767 $42,567 $30,967 $19,267 ($26,233) ($25,237)
Interest Expense $2,475 $2,450 $2,426 $2,401 $2,376 $2,351 $2,326 $2,302 $2,277 $2,252 $2,227 $2,202
Taxes Incurred ($10,856) ($3,529) ($102) $3,086 $4,143 $7,301 $7,818 $11,366 $7,893 $4,391 ($9,252) ($8,946)
Net Profit ($25,332) ($8,234) ($237) $7,200 $9,668 $17,035 $18,242 $26,520 $18,417 $10,245 ($21,588) ($20,874)
Net Profit/Sales -34.70% -7.77% -0.20% 5.58% 7.16% 11.83% 12.58% 16.89% 12.70% 7.73% -27.68% -26.09%
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 $73,000 $106,000 $119,000 $129,000 $135,000 $144,000 $145,000 $157,000 $145,000 $132,500 $78,000 $80,000
Subtotal Cash from Operations $73,000 $106,000 $119,000 $129,000 $135,000 $144,000 $145,000 $157,000 $145,000 $132,500 $78,000 $80,000
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 $73,000 $106,000 $119,000 $129,000 $135,000 $144,000 $145,000 $157,000 $145,000 $132,500 $78,000 $80,000
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 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000 $49,000
Bill Payments $1,193 $36,799 $65,859 $69,622 $69,991 $76,610 $74,012 $76,367 $79,381 $74,604 $68,939 $38,718
Subtotal Spent on Operations $50,193 $85,799 $114,859 $118,622 $118,991 $125,610 $123,012 $125,367 $128,381 $123,604 $117,939 $87,718
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 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976 $2,976
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,169 $88,775 $117,835 $121,598 $121,967 $128,586 $125,988 $128,343 $131,357 $126,580 $120,915 $90,694
Net Cash Flow $19,831 $17,225 $1,165 $7,402 $13,033 $15,414 $19,012 $28,657 $13,643 $5,920 ($42,915) ($10,694)
Cash Balance $54,431 $71,655 $72,820 $80,223 $93,255 $108,669 $127,681 $156,338 $169,981 $175,901 $132,986 $122,292
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 $34,600 $54,431 $71,655 $72,820 $80,223 $93,255 $108,669 $127,681 $156,338 $169,981 $175,901 $132,986 $122,292
Inventory $30,000 $18,850 $21,725 $23,485 $22,825 $25,575 $23,925 $24,805 $25,245 $24,805 $23,925 $14,025 $15,125
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $64,600 $73,281 $93,380 $96,305 $103,048 $118,830 $132,594 $152,486 $181,583 $194,786 $199,826 $147,011 $137,417
Long-term Assets
Long-term Assets $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000 $210,000
Accumulated Depreciation $0 $2,380 $4,760 $7,140 $9,520 $11,900 $14,280 $16,660 $19,040 $21,420 $23,800 $26,180 $28,560
Total Long-term Assets $210,000 $207,620 $205,240 $202,860 $200,480 $198,100 $195,720 $193,340 $190,960 $188,580 $186,200 $183,820 $181,440
Total Assets $274,600 $280,901 $298,620 $299,165 $303,528 $316,930 $328,314 $345,826 $372,543 $383,366 $386,026 $330,831 $318,857
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 $34,608 $63,538 $67,296 $67,434 $74,146 $71,470 $73,716 $76,889 $72,271 $67,662 $37,031 $48,907
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 $34,608 $63,538 $67,296 $67,434 $74,146 $71,470 $73,716 $76,889 $72,271 $67,662 $37,031 $48,907
Long-term Liabilities $300,000 $297,024 $294,048 $291,072 $288,096 $285,120 $282,144 $279,168 $276,192 $273,216 $270,240 $267,264 $264,288
Total Liabilities $300,000 $331,632 $357,586 $358,368 $355,530 $359,266 $353,614 $352,884 $353,081 $345,487 $337,902 $304,295 $313,195
Paid-in Capital $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000 $600,000
Retained Earnings ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400) ($625,400)
Earnings $0 ($25,332) ($33,566) ($33,803) ($26,603) ($16,935) $100 $18,342 $44,862 $63,279 $73,524 $51,936 $31,062
Total Capital ($25,400) ($50,732) ($58,966) ($59,203) ($52,003) ($42,335) ($25,300) ($7,058) $19,462 $37,879 $48,124 $26,536 $5,662
Total Liabilities and Capital $274,600 $280,901 $298,620 $299,165 $303,528 $316,930 $328,314 $345,826 $372,543 $383,366 $386,026 $330,831 $318,857
Net Worth ($25,400) ($50,732) ($58,966) ($59,203) ($52,003) ($42,335) ($25,300) ($7,058) $19,462 $37,879 $48,124 $26,536 $5,662