Our biggest savings of the year
Greek Golf Training Center
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 | |||||||||||||
Membership Fees | 0% | $2,200 | $4,400 | $6,600 | $8,800 | $11,000 | $13,200 | $15,950 | $17,600 | $19,800 | $22,000 | $22,000 | $22,000 |
Golf Equipment | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Food & Beverages | 0% | $180 | $360 | $540 | $720 | $900 | $1,080 | $1,260 | $1,440 | $1,620 | $1,800 | $1,800 | $1,800 |
Cigars | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $500 | $500 | $500 | $500 | $500 | $500 |
Private Lessons | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $250 | $250 | $250 | $250 | $250 | $250 |
Equipment Rental | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $250 | $250 | $250 | $250 | $250 | $250 |
Advertising | 0% | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Extra Performance Analysis | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $250 | $250 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $100 | $100 | $100 | $100 | $100 |
Total Sales | $2,380 | $7,760 | $12,140 | $14,520 | $16,900 | $19,280 | $23,310 | $25,140 | $27,520 | $29,900 | $30,150 | $30,150 | |
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 | |
Membership Fees | $110 | $220 | $330 | $440 | $550 | $660 | $795 | $880 | $990 | $1,100 | $1,100 | $1,100 | |
Golf Equipment | $0 | $0 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
Food & Beverages | $36 | $72 | $108 | $144 | $180 | $216 | $252 | $288 | $324 | $360 | $360 | $360 | |
Cigars | $0 | $0 | $0 | $0 | $0 | $0 | $125 | $125 | $125 | $125 | $125 | $125 | |
Private Lessons | $0 | $0 | $0 | $0 | $0 | $0 | $190 | $190 | $190 | $190 | $190 | $190 | |
Equipment Rental | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Advertising | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Extra Performance Analysis | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $50 | $50 | $50 | $50 | $50 | $50 | |
Subtotal Direct Cost of Sales | $146 | $292 | $1,938 | $2,084 | $2,230 | $2,376 | $2,912 | $3,033 | $3,179 | $3,325 | $3,325 | $3,325 |
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 | ||
Managing Director & consultant | 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 |
Administration 1 – Part time | 0% | $800 | $800 | $1,200 | $800 | $1,200 | $800 | $800 | $800 | $800 | $1,600 | $800 | $800 |
Administration 2 – Part time | 0% | $800 | $800 | $1,200 | $800 | $1,200 | $800 | $800 | $800 | $800 | $1,600 | $800 | $800 |
Administration 3 – Part time | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Janitor | 0% | $900 | $900 | $1,350 | $900 | $1,350 | $900 | $900 | $900 | $900 | $1,800 | $900 | $900 |
Janitor assistant | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Cleaning Person 1 – Part time | 0% | $800 | $800 | $1,200 | $800 | $1,200 | $800 | $800 | $800 | $800 | $1,600 | $800 | $800 |
Cleaning Person 2 – Part time | 0% | $800 | $800 | $1,200 | $800 | $1,200 | $800 | $800 | $800 | $800 | $1,600 | $800 | $800 |
Professional instructor | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accountant | 0% | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 |
Guard 1 | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Guard 2 | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
Total Payroll | $8,400 | $8,400 | $10,450 | $8,400 | $10,450 | $8,400 | $8,400 | $8,400 | $8,400 | $12,500 | $8,400 | $8,400 |
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 | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | 12.00% | |
Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
Tax Rate | 30.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | 35.00% | |
Personnel Burden | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
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 | $2,380 | $7,760 | $12,140 | $14,520 | $16,900 | $19,280 | $23,310 | $25,140 | $27,520 | $29,900 | $30,150 | $30,150 | |
Direct Cost of Sales | $146 | $292 | $1,938 | $2,084 | $2,230 | $2,376 | $2,912 | $3,033 | $3,179 | $3,325 | $3,325 | $3,325 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $146 | $292 | $1,938 | $2,084 | $2,230 | $2,376 | $2,912 | $3,033 | $3,179 | $3,325 | $3,325 | $3,325 | |
Gross Margin | $2,234 | $7,468 | $10,202 | $12,436 | $14,670 | $16,904 | $20,398 | $22,107 | $24,341 | $26,575 | $26,825 | $26,825 | |
Gross Margin % | 93.87% | 96.24% | 84.04% | 85.65% | 86.80% | 87.68% | 87.51% | 87.94% | 88.45% | 88.88% | 88.97% | 88.97% | |
Expenses | |||||||||||||
Payroll | $8,400 | $8,400 | $10,450 | $8,400 | $10,450 | $8,400 | $8,400 | $8,400 | $8,400 | $12,500 | $8,400 | $8,400 | |
Sales and Marketing and Other Expenses | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Depreciation | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | |
Rent (site) | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Supplies (Office & Janitorial) | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Web Site Expenses | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Utilities | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Insurance (fire,damages, loss) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,000 | |
Payroll Taxes | 15% | $1,260 | $1,260 | $1,568 | $1,260 | $1,568 | $1,260 | $1,260 | $1,260 | $1,260 | $1,875 | $1,260 | $1,260 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $15,810 | $15,810 | $18,168 | $15,810 | $18,168 | $15,810 | $15,810 | $15,810 | $15,810 | $20,525 | $15,810 | $25,810 | |
Profit Before Interest and Taxes | ($11,176) | ($5,942) | ($4,366) | ($974) | $103 | $3,494 | $6,988 | $8,697 | $8,531 | $6,050 | $11,015 | $1,015 | |
EBITDA | ($9,926) | ($4,692) | ($3,116) | $276 | $1,353 | $4,744 | $8,238 | $9,947 | $9,781 | $7,300 | $12,265 | $2,265 | |
Interest Expense | $814 | $811 | $808 | $805 | $802 | $799 | $796 | $793 | $790 | $788 | $785 | $782 | |
Taxes Incurred | ($3,597) | ($2,363) | ($1,811) | ($623) | ($245) | $943 | $2,167 | $2,766 | $2,709 | $1,842 | $3,581 | $82 | |
Net Profit | ($8,393) | ($4,389) | ($3,363) | ($1,156) | ($455) | $1,752 | $4,025 | $5,137 | $5,031 | $3,421 | $6,650 | $152 | |
Net Profit/Sales | -352.64% | -56.56% | -27.70% | -7.96% | -2.69% | 9.09% | 17.27% | 20.44% | 18.28% | 11.44% | 22.06% | 0.50% |
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 | $2,380 | $7,760 | $12,140 | $14,520 | $16,900 | $19,280 | $23,310 | $25,140 | $27,520 | $29,900 | $30,150 | $30,150 | |
Subtotal Cash from Operations | $2,380 | $7,760 | $12,140 | $14,520 | $16,900 | $19,280 | $23,310 | $25,140 | $27,520 | $29,900 | $30,150 | $30,150 | |
Additional Cash Received | |||||||||||||
Non Operating (Other) Income | $2,400 | $2,400 | $3,600 | $2,400 | $3,600 | $2,400 | $2,400 | $2,400 | $0 | $0 | $0 | $0 | |
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 | $4,780 | $10,160 | $15,740 | $16,920 | $20,500 | $21,680 | $25,710 | $27,540 | $27,520 | $29,900 | $30,150 | $30,150 | |
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 | $8,400 | $8,400 | $10,450 | $8,400 | $10,450 | $8,400 | $8,400 | $8,400 | $8,400 | $12,500 | $8,400 | $8,400 | |
Bill Payments | $117 | $3,569 | $4,983 | $7,437 | $8,454 | $9,289 | $10,337 | $12,059 | $12,755 | $12,835 | $12,767 | $14,067 | |
Subtotal Spent on Operations | $8,517 | $11,969 | $15,433 | $15,837 | $18,904 | $17,689 | $18,737 | $20,459 | $21,155 | $25,335 | $21,167 | $22,467 | |
Additional Cash Spent | |||||||||||||
Non Operating (Other) Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $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 | $9,017 | $12,469 | $15,933 | $16,337 | $19,404 | $18,189 | $19,237 | $20,959 | $21,655 | $25,835 | $21,667 | $22,967 | |
Net Cash Flow | ($4,237) | ($2,309) | ($193) | $583 | $1,096 | $3,491 | $6,473 | $6,581 | $5,865 | $4,065 | $8,483 | $7,183 | |
Cash Balance | $9,763 | $7,454 | $7,261 | $7,844 | $8,940 | $12,431 | $18,904 | $25,485 | $31,350 | $35,415 | $43,898 | $51,081 |
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 | $14,000 | $9,763 | $7,454 | $7,261 | $7,844 | $8,940 | $12,431 | $18,904 | $25,485 | $31,350 | $35,415 | $43,898 | $51,081 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $14,000 | $9,763 | $7,454 | $7,261 | $7,844 | $8,940 | $12,431 | $18,904 | $25,485 | $31,350 | $35,415 | $43,898 | $51,081 |
Long-term Assets | |||||||||||||
Long-term Assets | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 | $65,000 |
Accumulated Depreciation | $0 | $1,250 | $2,500 | $3,750 | $5,000 | $6,250 | $7,500 | $8,750 | $10,000 | $11,250 | $12,500 | $13,750 | $15,000 |
Total Long-term Assets | $65,000 | $63,750 | $62,500 | $61,250 | $60,000 | $58,750 | $57,500 | $56,250 | $55,000 | $53,750 | $52,500 | $51,250 | $50,000 |
Total Assets | $79,000 | $73,513 | $69,954 | $68,511 | $67,844 | $67,690 | $69,931 | $75,154 | $80,485 | $85,100 | $87,915 | $95,148 | $101,081 |
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 | $3,405 | $4,736 | $7,156 | $8,145 | $8,946 | $9,936 | $11,634 | $12,328 | $12,411 | $12,305 | $13,389 | $19,670 |
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 | $3,405 | $4,736 | $7,156 | $8,145 | $8,946 | $9,936 | $11,634 | $12,328 | $12,411 | $12,305 | $13,389 | $19,670 |
Long-term Liabilities | $140,000 | $139,500 | $139,000 | $138,500 | $138,000 | $137,500 | $137,000 | $136,500 | $136,000 | $135,500 | $135,000 | $134,500 | $134,000 |
Total Liabilities | $140,000 | $142,905 | $143,736 | $145,656 | $146,145 | $146,446 | $146,936 | $148,134 | $148,328 | $147,911 | $147,305 | $147,889 | $153,670 |
Paid-in Capital | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 | $200,000 |
Retained Earnings | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) | ($261,000) |
Earnings | $0 | ($8,393) | ($12,782) | ($16,145) | ($17,301) | ($17,756) | ($16,004) | ($11,980) | ($6,842) | ($1,811) | $1,610 | $8,259 | $8,411 |
Total Capital | ($61,000) | ($69,393) | ($73,782) | ($77,145) | ($78,301) | ($78,756) | ($77,004) | ($72,980) | ($67,842) | ($62,811) | ($59,390) | ($52,741) | ($52,589) |
Total Liabilities and Capital | $79,000 | $73,513 | $69,954 | $68,511 | $67,844 | $67,690 | $69,931 | $75,154 | $80,485 | $85,100 | $87,915 | $95,148 | $101,081 |
Net Worth | ($61,000) | ($69,393) | ($73,782) | ($77,145) | ($78,301) | ($78,756) | ($77,004) | ($72,980) | ($67,842) | ($62,811) | ($59,390) | ($52,741) | ($52,589) |