Willow Park Golf Course
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 |