Mountain Brook Fitness Center
Financial Plan
Forecast
Key Assumptions
- Increasing overall demand for gyms and fitness continues
- Increasing overall demand for healthy organic food continues
- No big changes in general view on gyms vs. outside activities
- No major push from chain competition
Revenue by Month
Expenses by Month
Net Profit (or Loss) by Year
Financing
Financing Needed
We have existing loans of $100,000 long-term and $70,000 short-term. We’ll be opening a new credit line of $70,000 as we start with this plan.
Statements
Projected Profit & Loss
|
|
|
|
|
|
|
|
| Gross Margin |
$1,212,300 |
$1,457,320 |
$1,639,606 |
| Salaries & Wages |
$862,800 |
$1,030,608 |
$1,166,071 |
| Employee Related Expenses |
$97,200 |
$117,504 |
$134,835 |
| Sales |
$18,000 |
$18,000 |
$18,000 |
| Marketing |
$11,400 |
$11,400 |
$11,400 |
| Utilities |
$6,000 |
$6,000 |
$6,000 |
| Insurance |
$12,000 |
$12,000 |
$12,000 |
| Rent |
$72,000 |
$72,000 |
$72,000 |
| Amortization of Other Current Assets |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
| Interest Incurred |
$9,151 |
$3,696 |
$2,695 |
| Depreciation and Amortization |
$12,667 |
$12,666 |
$12,667 |
| Gain or Loss from Sale of Assets |
|
|
|
| Income Taxes |
$16,662 |
$26,017 |
$30,591 |
Projected Balance Sheet
| Cash |
$55,000 |
$59,344 |
$91,488 |
$110,298 |
| Accounts Receivable |
|
$17,388 |
$17,359 |
$19,429 |
| Inventory |
|
|
|
|
| Other Current Assets |
$45,000 |
$45,000 |
$45,000 |
$45,000 |
|
|
|
|
|
| Long-Term Assets |
$200,000 |
$200,000 |
$200,000 |
$200,000 |
| Accumulated Depreciation |
($48,000) |
($60,667) |
($73,333) |
($86,000) |
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
$60,000 |
$16,318 |
$16,318 |
$16,318 |
| Income Taxes Payable |
|
$10,391 |
$6,519 |
$7,654 |
| Sales Taxes Payable |
|
$30,000 |
$30,860 |
$34,540 |
| Short-Term Debt |
$88,054 |
$24,968 |
$19,949 |
$20,969 |
| Prepaid Revenue |
|
|
|
|
| Long-Term Debt |
$81,946 |
$62,968 |
$43,020 |
$22,050 |
|
|
|
|
|
|
|
|
|
|
| Paid-In Capital |
|
|
|
|
| Retained Earnings |
$22,000 |
$22,000 |
$16,420 |
$13,848 |
| Earnings |
|
$94,420 |
$147,428 |
$173,347 |
|
|
|
|
|
Projected Cash Flow Statement
| Net Profit |
$94,420 |
$147,428 |
$173,347 |
| Depreciation & Amortization |
$12,667 |
$12,667 |
$12,667 |
| Change in Accounts Receivable |
($17,388) |
$29 |
($2,070) |
| Change in Inventory |
|
|
|
| Change in Accounts Payable |
($43,682) |
$0 |
$0 |
| Change in Income Tax Payable |
$10,391 |
($3,872) |
$1,135 |
| Change in Sales Tax Payable |
$30,000 |
$860 |
$3,680 |
| Change in Prepaid Revenue |
|
|
|
| Assets Purchased or Sold |
|
|
|
| Investments Received |
|
|
|
| Dividends & Distributions |
|
($100,000) |
($150,000) |
| Change in Short-Term Debt |
($63,086) |
($5,020) |
$1,021 |
| Change in Long-Term Debt |
($18,978) |
($19,949) |
($20,969) |
| Cash at Beginning of Period |
$55,000 |
$59,344 |
$91,488 |
| Net Change in Cash |
$4,344 |
$32,143 |
$18,811 |