Mountain Brook Fitness Center

Start your own business plan »

Workout Gym Business Plan

Appendix

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