| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Memberships | 0% | $20,000 | $20,000 | $22,000 | $22,000 | $22,000 | $24,000 | $28,000 | $32,000 | $36,000 | $42,000 | $46,000 | $50,000 |
| Childcare | 0% | $22,000 | $24,000 | $25,000 | $25,000 | $26,000 | $26,000 | $27,000 | $27,000 | $28,000 | $28,000 | $28,000 | $28,000 |
| Massage | 0% | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Physical Therapy | 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 |
| Fruit Bar Drinks | 0% | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
| Total Sales | $77,000 | $79,000 | $82,000 | $82,000 | $83,000 | $85,000 | $90,000 | $94,000 | $99,000 | $105,000 | $109,000 | $113,000 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Memberships | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Childcare | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Massage | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
| Physical Therapy | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | |
| Fruit Bar Drinks | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Subtotal Direct Cost of Sales | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Center Manager | 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 |
| Assistant Manager | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Center Staff | 0% | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
| Childcare Manager | 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 |
| Childcare Staff | 0% | $15,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
| Pool Manager | 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 |
| Tennis Manager | 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 |
| Total People | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | |
| Total Payroll | $49,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | |
| General Assumptions | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| 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 | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | $77,000 | $79,000 | $82,000 | $82,000 | $83,000 | $85,000 | $90,000 | $94,000 | $99,000 | $105,000 | $109,000 | $113,000 | |
| Direct Cost of Sales | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | |
| Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | $14,000 | |
| Gross Margin | $63,000 | $65,000 | $68,000 | $68,000 | $69,000 | $71,000 | $76,000 | $80,000 | $85,000 | $91,000 | $95,000 | $99,000 | |
| Gross Margin % | 81.82% | 82.28% | 82.93% | 82.93% | 83.13% | 83.53% | 84.44% | 85.11% | 85.86% | 86.67% | 87.16% | 87.61% | |
| Expenses | |||||||||||||
| Payroll | $49,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | |
| Sales and Marketing and Other Expenses | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
| Depreciation | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Insurance | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Payroll Taxes | 15% | $7,425 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 | $6,975 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $63,925 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | $60,475 | |
| Profit Before Interest and Taxes | ($925) | $4,525 | $7,525 | $7,525 | $8,525 | $10,525 | $15,525 | $19,525 | $24,525 | $30,525 | $34,525 | $38,525 | |
| EBITDA | $75 | $5,525 | $8,525 | $8,525 | $9,525 | $11,525 | $16,525 | $20,525 | $25,525 | $31,525 | $35,525 | $39,525 | |
| Interest Expense | $2,067 | $2,135 | $2,202 | $2,269 | $2,337 | $2,404 | $2,472 | $2,539 | $2,606 | $2,674 | $2,741 | $2,808 | |
| Taxes Incurred | ($898) | $717 | $1,597 | $1,577 | $1,856 | $2,436 | $3,916 | $5,096 | $6,576 | $8,355 | $9,535 | $10,715 | |
| Net Profit | ($2,095) | $1,673 | $3,726 | $3,679 | $4,332 | $5,685 | $9,137 | $11,890 | $15,343 | $19,496 | $22,249 | $25,002 | |
| Net Profit/Sales | -2.72% | 2.12% | 4.54% | 4.49% | 5.22% | 6.69% | 10.15% | 12.65% | 15.50% | 18.57% | 20.41% | 22.13% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $57,750 | $59,250 | $61,500 | $61,500 | $62,250 | $63,750 | $67,500 | $70,500 | $74,250 | $78,750 | $81,750 | $84,750 | |
| Cash from Receivables | $0 | $642 | $19,267 | $19,775 | $20,500 | $20,508 | $20,767 | $21,292 | $22,533 | $23,542 | $24,800 | $26,283 | |
| Subtotal Cash from Operations | $57,750 | $59,892 | $80,767 | $81,275 | $82,750 | $84,258 | $88,267 | $91,792 | $96,783 | $102,292 | $106,550 | $111,033 | |
| 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 | $70,000 | $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 | $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 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 | $137,750 | $69,892 | $90,767 | $91,275 | $92,750 | $94,258 | $98,267 | $101,792 | $106,783 | $112,292 | $116,550 | $121,033 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $49,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | $46,500 | |
| Bill Payments | $60,953 | $28,636 | $29,858 | $30,776 | $30,833 | $31,190 | $31,867 | $33,404 | $34,661 | $36,218 | $38,046 | $39,293 | |
| Subtotal Spent on Operations | $110,453 | $75,136 | $76,358 | $77,276 | $77,333 | $77,690 | $78,367 | $79,904 | $81,161 | $82,718 | $84,546 | $85,793 | |
| 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 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | $1,116 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Purchase Other Current Assets | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
| 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 | $118,369 | $83,052 | $84,274 | $85,192 | $85,249 | $85,606 | $86,283 | $87,820 | $89,077 | $90,634 | $92,462 | $93,709 | |
| Net Cash Flow | $19,381 | ($13,160) | $6,492 | $6,083 | $7,501 | $8,652 | $11,984 | $13,971 | $17,706 | $21,657 | $24,088 | $27,325 | |
| Cash Balance | $69,381 | $56,221 | $62,713 | $68,797 | $76,298 | $84,950 | $96,934 | $110,905 | $128,611 | $150,269 | $174,357 | $201,682 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $50,000 | $69,381 | $56,221 | $62,713 | $68,797 | $76,298 | $84,950 | $96,934 | $110,905 | $128,611 | $150,269 | $174,357 | $201,682 |
| Accounts Receivable | $0 | $19,250 | $38,358 | $39,592 | $40,317 | $40,567 | $41,308 | $43,042 | $45,250 | $47,467 | $50,175 | $52,625 | $54,592 |
| Other Current Assets | $50,000 | $56,000 | $62,000 | $68,000 | $74,000 | $80,000 | $86,000 | $92,000 | $98,000 | $104,000 | $110,000 | $116,000 | $122,000 |
| Total Current Assets | $100,000 | $144,631 | $156,579 | $170,305 | $183,113 | $196,864 | $212,259 | $231,976 | $254,155 | $280,078 | $310,444 | $342,982 | $378,273 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $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 |
| Accumulated Depreciation | $48,000 | $49,000 | $50,000 | $51,000 | $52,000 | $53,000 | $54,000 | $55,000 | $56,000 | $57,000 | $58,000 | $59,000 | $60,000 |
| Total Long-term Assets | $152,000 | $151,000 | $150,000 | $149,000 | $148,000 | $147,000 | $146,000 | $145,000 | $144,000 | $143,000 | $142,000 | $141,000 | $140,000 |
| Total Assets | $252,000 | $295,631 | $306,579 | $319,305 | $331,113 | $343,864 | $358,259 | $376,976 | $398,155 | $423,078 | $452,444 | $483,982 | $518,273 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $60,000 | $27,642 | $28,833 | $29,748 | $29,794 | $30,129 | $30,755 | $32,251 | $33,456 | $34,952 | $36,737 | $37,943 | $39,148 |
| Current Borrowing | $70,000 | $138,884 | $137,768 | $136,652 | $135,536 | $134,420 | $133,304 | $132,188 | $131,072 | $129,956 | $128,840 | $127,724 | $126,608 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $130,000 | $166,526 | $166,601 | $166,400 | $165,330 | $164,549 | $164,059 | $164,439 | $164,528 | $164,908 | $165,577 | $165,667 | $165,756 |
| Long-term Liabilities | $100,000 | $109,200 | $118,400 | $127,600 | $136,800 | $146,000 | $155,200 | $164,400 | $173,600 | $182,800 | $192,000 | $201,200 | $210,400 |
| Total Liabilities | $230,000 | $275,726 | $285,001 | $294,000 | $302,130 | $310,549 | $319,259 | $328,839 | $338,128 | $347,708 | $357,577 | $366,867 | $376,156 |
| Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retained Earnings | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 | $22,000 |
| Earnings | $0 | ($2,095) | ($421) | $3,305 | $6,983 | $11,315 | $17,000 | $26,137 | $38,027 | $53,370 | $72,866 | $95,115 | $120,117 |
| Total Capital | $22,000 | $19,905 | $21,579 | $25,305 | $28,983 | $33,315 | $39,000 | $48,137 | $60,027 | $75,370 | $94,866 | $117,115 | $142,117 |
| Total Liabilities and Capital | $252,000 | $295,631 | $306,579 | $319,305 | $331,113 | $343,864 | $358,259 | $376,976 | $398,155 | $423,078 | $452,444 | $483,982 | $518,273 |
| Net Worth | $22,000 | $19,905 | $21,579 | $25,305 | $28,983 | $33,315 | $39,000 | $48,137 | $60,027 | $75,370 | $94,866 | $117,115 | $142,117 |