BUSINESS PLAN: FINANCIALS- 30hrs
al1993
BBfinancial.xlsxPayroll
| Payroll Expenses | |||||
| Personnel plan | |||||
| 1st Year | 2nd Year | 3rd Year | |||
| Playground supervisor | $12,000.00 | $13,500.00 | $14,500.00 | ||
| Playground supervisor | $12,000.00 | $13,500.00 | $13,500.00 | ||
| Playground supervisor (contract) | $6,500.00 | $6,500.00 | $6,500.00 | ||
| Playground supervisor (contract) | $3,700.00 | $3,700.00 | $3,700.00 | ||
| Playground supervisor | $0.00 | $12,000.00 | $12,000.00 | ||
| Playground supervisor | $0.00 | $13,500.00 | $14,500.00 | ||
| Groomer | $11,500.00 | $11,500.00 | $11,500.00 | ||
| Pet Tax | $8,500.00 | $9,500.00 | |||
| Total expenses | $45,700.00 | $82,700.00 | $85,700.00 | ||
| Sales and Marketing personnel | |||||
| Other costs | $17,400.00 | $2,800.00 | $2,800.00 | ||
| other costs | $0.00 | $0.00 | $0.00 | ||
| Total expenses | $17,400.00 | $2,800.00 | $2,800.00 | ||
| General and administrative Personnel | |||||
| Manager | $17,600.00 | $18,900.00 | $18,900.00 | ||
| Receptionist 1 | $9,500.00 | $9,500.00 | $9,500.00 | ||
| Receptionist 2 | $7,500.00 | $7,500.00 | |||
| Total | $27,100.00 | $35,900.00 | $35,900.00 | ||
| total personnel | 7 | 12 | 12 | ||
| Total Payroll expenses | $90,200.00 | $121,400.00 | $124,400.00 |
sales forecast
| Sales forecast | ||||
| Sales | 1st Year | 2nd Year | 3rd Year | |
| Overnight care | $7,700.00 | $9,200.00 | $11,300.00 | |
| Day care | $101,000.00 | $110,300.00 | $119,400.00 | |
| In home care | $11,200.00 | $12,300.00 | $14,600.00 | |
| Grooming | $102,400.00 | $119,400.00 | $131,200.00 | |
| Retail section | $12,600.00 | $14,700.00 | $18,400.00 | |
| Wash your own | $16,300.00 | $20,200.00 | $25,700.00 | |
| Obedience sales | $6,200.00 | $7,300.00 | $8,900.00 | |
| Special request & Miscellaneous | $2,200.00 | $2,600.00 | $2,900.00 | |
| Total Sales | $259,600.00 | $296,000.00 | $332,400.00 | |
| Direct cost of sales | ||||
| Overnight care costs | $4,100.00 | $4,600.00 | $5,100.00 | |
| In home care | $340.00 | $390.00 | $420.00 | |
| Day care | $6,700.00 | $7,100.00 | $8,700.00 | |
| Wash Your own | $400.00 | $450.00 | $510.00 | |
| Grooming costs | $350.00 | $390.00 | $450.00 | |
| Retailing costs | $6,100.00 | $6,800.00 | $7,300.00 | |
| Obedience | $310.00 | $360.00 | $390.00 | |
| Special requests | $220.00 | $270.00 | $290.00 | |
| Total costs | $18,520.00 | $20,360.00 | $23,160.00 | |
start up
| start up | Start up funding | ||||
| Requirements | Start up expenses to fund | $97,200.00 | |||
| (a) Expenses | Start up Assets to fund | $125,000.00 | |||
| Accounting & legal fees | $1,900.00 | Total funding required | $222,200.00 | ||
| Office supplies | $700.00 | ||||
| Brochures & Cards | $5,200.00 | Assets | |||
| Insurance | $5,300.00 | Non-Cash Assets from startup | $60,000.00 | ||
| Permits/ consultancy | $5,500.00 | cas Req. from Start up | $15,000.00 | ||
| Rent/Lease | $30,000.00 | Additional cash raised | $0.00 | ||
| Space/ Contractor | $30,000.00 | Cash balance on start date | $50,000.00 | ||
| Sales & Marketing | $18,000.00 | total assets | $125,000.00 | ||
| Equipment Expense | $0.00 | ||||
| other | $600.00 | Liabilities and Capital | |||
| Total Expenses | $97,200.00 | Liabilities | $0.00 | ||
| current loans | $0.00 | ||||
| (b) Assets | Long term liabilities | $125,000.00 | |||
| Cash Required | $50,000.00 | Accounts Payable | $0.00 | ||
| Inventory | $15,000.00 | Interest | $0.00 | ||
| current assets | $0.00 | Total liabilities | $125,000.00 | ||
| longterm assests | $60,000.00 | ||||
| Total Assets | $125,000.00 | Capital | |||
| Planned investment: Investor 1 | $97,200.00 | ||||
| Total Requirements | $222,200.00 | other | $0.00 | ||
| additional investment | $0.00 | ||||
| Total Capital | $97,200.00 | ||||
| Total capital & libilities | $222,200.00 | ||||
| Total funding | $222,200.00 |
Revenues
| Revenue analysis | ||||||||||||||
| Year/month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | TOTAL | |
| 1st Year | ||||||||||||||
| 2nd Year | ||||||||||||||
| 3rd Year |
