Psychological Health Center Business Plan
2.2 Company Locations and Facilities
4.1 Target Market Segment Strategy..
The market for behavioral health services is healthy, as will be shown by the growth the existing Center has experienced during the past two and a half years. Massachusetts has recently passed a mental health parity bill that will become effective in month one. The bill requires insurance companies to develop benefits for biologically based behavioral health disorders similar to those provided for health disorders. This should help sustain the anticipated projected growth. Currently, the Outpatient Psychiatric Center is referring approximately four phone calls a day to other providers.
The key to success for this turnkey project includes:
The business plan provides a map for sustaining growth, improving revenue collections, and increasing our bottom line to produce a profit.
Goal 1: To continuously develop, strengthen, and improve services offered by the Center.
Goal 2: To strengthen the Center's commitment to excellence.
History
Although the Center is a new company, it is taking over the operation of an existing full-service mental health center. Prior to the privatization of the Outpatient Mental Health and Addictions Center, the Center was part of Anna Jaques Hospital's Psychiatric Services Program. This program offered an array of behavioral health services which included both inpatient and outpatient services. Currently, there are approximately 565 active cases. There are another 233 inactive cases that use the Center's services on an as-needed basis. The Center is located at the Amesbury Health Center, a facility owned by Anna Jaques Hospital. The Amesbury Health Center, formerly a city-owned community hospital, is a four-story brick building. It has been modified to accommodate a child inpatient unit and medical office spaces, including the mental health center.
The outpatient center began as a psychopharmacology center at Anna Jaques Hospital. During 1995, the psychopharmacology center moved to the Amesbury Health Center. At that time, the center expanded to include an Addictions Program.
In 1998, the Center further expanded to offer psychotherapy services. The psychotherapy component consisted of individual, couple, family therapies, and specialized groups. The composition of staff was multidisciplinary and included independently licensed/certified mental health centerians and certified addiction treatment specialists. During this time, the Center was licensed by the Department of Public Health to offer specialized addiction services that included a Second Offenders Program, an Addiction Counseling program, and an Intensive Outpatient Program. The licensing enables the Center to collaborate with other state and community agencies working with substance abuse/addiction populations, resulting in further growth for this program.
Since 1996 the number of visits/procedures has continued to grow to its present day tallies. The total number of visits for 1996 was 1,471, in 1997 it was 1,869, in 1998 it was 3,399, and in 1999 it was 6,158. The projected number of units of service for 2000 is 5,700. Although units of service have increased by 45% over the past two years, the net revenue has decreased per unit of service. As volume has increased, expenses per unit of service has fallen from $88 in 1996 to $52 in 1999. Since 1998, operating expenses have been under control and reasonably proportionate to units of service provided.
Start-up |
|
|
|
Requirements |
|
|
|
Start-up Expenses |
|
Legal |
$2,000 |
Stationery etc. |
$400 |
Insurance |
$500 |
Rent |
$900 |
Redecorating and signage |
$2,500 |
Staff Training |
$2,000 |
Other |
$700 |
Total Start-up Expenses |
$9,000 |
|
|
Start-up Assets |
|
Cash Required |
$101,000 |
Other Current Assets |
$5,000 |
Long-term Assets |
$0 |
Total Assets |
$106,000 |
|
|
Total Requirements |
$115,000 |
Start-up Funding |
|
Start-up Expenses to Fund |
$9,000 |
Start-up Assets to Fund |
$106,000 |
Total Funding Required |
$115,000 |
|
|
Assets |
|
Non-cash Assets from Start-up |
$5,000 |
Cash Requirements from Start-up |
$101,000 |
Additional Cash Raised |
$0 |
Cash Balance on Starting Date |
$101,000 |
Total Assets |
$106,000 |
|
|
|
|
Liabilities and Capital |
|
|
|
Liabilities |
|
Current Borrowing |
$0 |
Long-term Liabilities |
$50,000 |
Accounts Payable (Outstanding Bills) |
$0 |
Other Current Liabilities (interest-free) |
$0 |
Total Liabilities |
$50,000 |
|
|
Capital |
|
|
|
Planned Investment |
|
Direct Owner Investment |
$65,000 |
Investor 2 |
$0 |
Other |
$0 |
Additional Investment Requirement |
$0 |
Total Planned Investment |
$65,000 |
|
|
Loss at Start-up (Start-up Expenses) |
($9,000) |
Total Capital |
$56,000 |
|
|
|
|
Total Capital and Liabilities |
$106,000 |
|
|
Total Funding |
$115,000 |
The Center occupies approximately 2,200 square feet. It has nine clinical offices and group rooms. There is a larger reception area that is separated by a divider, allowing for a child and adult reception area. Included in the square footage is a small staff kitchen, a staff bathroom, and a business/intake office. The offices are handicapped accessible. There is a public unisex, handicapped-accessible bathroom within close proximity to the Center, and one within the building.
Leasing arrangements are in process. Based upon a financial analysis and financial projections, the hospital will need to subsidize rent for the first two years if the project is to succeed. It is our goal to obtain a three-year lease from the Anna Jaques Hospital with an option to renew a second three-year lease. The present location is not critical to the success of the business. After three years we will review our rental options, the need for additional space, and other available facilities in the geographical area prior to renewing the contract.
The Center has identified several behavioral health payors who have a strong foothold in the Merrimack Valley area. They include: Tufts HMO and Tufts Affiliated Health Programs, Harvard/Pilgrim Health Care, Medicare, Medicaid/MBHP, Magellan/MBC, Magellan Lucent, United Behavioral Health, Behavior Health Network, managed care company (MCC)/Cigna, US Health Care, and Health Care Value Management (indemnity products). Consumers participating in these programs are drawn from the communities of the Merrimack Valley and Southern New Hampshire area. Within this service area it is estimated that HMOs provide insurance for approximately 51% of the population.
It should be noted that there is an abundant supply of behavioral health providers/institutions within the Merrimack Valley and Southern New Hampshire. They include: psychiatric hospitals, residential facilities, outpatient group practices that vary from public to private organizations, and solo practitioners. Customer service, then becomes an even more critical factor. To obtain and maintain a foothold in the behavioral health market will necessitate the provision of optimal, accessible, quality customer service.
The Center has four primary customers, each with their own specific needs. These include:
1. Referral Source |
Customer Needs |
Physicians |
Professionalism |
Hospitals |
Consultation |
Schools |
Correspondence |
Agencies |
Accessibility |
|
|
2. Individuals and Families |
|
Individuals |
Accessibility |
Couples |
Respect |
Families |
Compassion |
Groups |
Empathy |
|
|
3. Managed Care Companies and Other Payors |
|
MCO's |
Clear communication |
Self-pay |
Cost-effective care |
Agencies |
Easy access for clients |
PPOs |
Shared treatment philosophy |
Indemnity Program |
Responsiveness and cooperation |
|
|
4. Vendors |
|
Billing/Collectable |
Cooperative working relationship |
Legal |
Timely payment facility owner |
Human Resource |
Respect |
Insurance |
|
With the advent of mental health parity in Massachusetts, utilization rates and reimbursement rates should improve. Under the mental health parity law, insurance companies are not allowed to cap mental health services for biologically based mental health disorders. Co-payments cannot escalate during the course of treatment for these disorders.
Managed care organizations (MCOs) are beginning to review provider compensation packages with the intent of increasing compensation rates. Rates have been flat for the past ten years.
Dr. Marc Shay, an adult psychiatrist, has recently become an associate of the Center. He has committed to 12 hours per week, resulting in an increase of services by 48 units per week. His schedule is filled for the next three weeks as of July 10, 2000. He will begin work on July 17, 2000. We are also in the process of negotiating with a clinical nurse specialist to work 12 hours per week. Her specialty is with children and adolescents. Her starting date is estimated to be early September 2000.
Not-for-Profit Facility
1. North Essex Mental Health Center
North Essex Mental Health Center, Inc., Newburyport, Massachusetts with a satellite office in Haverhill, Massachusetts. Three years ago, this facility was bought by a subsidiary of Northeast Health Systems of Beverly, Massachusetts. This facility is a community mental health center whose primary consumer is the medicaid population. The center has been providing behavioral health services in the Merrimack Valley area for over 20 years. This center has grown significantly in the last 10 years, culminating in the opening of an Amesbury office. North Essex Mental Health Center is the dominant provider in the Northeast area of Massachusetts. They are the emergency services provider for MBHP and have contracted with the AJH to provide emergency services to their emergency room. Their payor mix is composed of medicare, medicaid, self pay, and some MCOs.
a. Strengths:
b. Weaknesses:
c. Potential Impact of Strengths:
d. Strategies To Thwart Competition:
2. Arbour/HRI Counseling
HRI/Arbour Psychological Center is a moderate-size, for-profit mental health center. It is a full-service multidisciplinary center, offering mental health services to children, adolescents, and adults. It was recently procured by Arbour Mental Health Systems. This center has recently invested money to refurbish a facility that houses their geropsychiatry program. Their payor mix is spread among Medicare, Medicaid, self pay, and MCOs
a. Strengths:
b. Weaknesses:
c. Potential Impact of Strengths:
d. Strategies to Thwart Competition:
3. Harris Street Associates
Harris Street Associates is a multidisciplinary group practice providing mental health services to the Newburyport and Haverhill communities. It was established over fifteen years ago by several local psychiatrists and psychologists. Their payor mix has been primarily with MCOs, with some indemnity programs. It has had a rocky financial history, culminating in being bought by H.E.S. For the past three years, H.E.S. has attempted to turn around the financial status of the agency without success. It was recently announced that the center is closing on October 30, 2000.
4. Harborside Psychological Center
Harborside Psychological Center is located in Newburyport, Massachusetts. It is a multidisciplinary mental health group practice. Until recently, their service focus has been psychotherapy with children, adolescents and adults. Currently, this center has added pharmacology to their list of services. Their payor mix is composed of MCOs and employee assistance programs (EAPs).
a. Strengths:
b. Weaknesses:
c. Potential Impact of Strengths:
d. Strategies to Thwart Competition:
All services are offered to all age groups, with a modality of treatments that include individual, couple, families, and group. Some customers will use only one service at a time, while others will use a mix of the various services simultaneously.
Market Analysis |
|
|
|
|
|
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Potential Customers |
Growth |
|
|
|
|
|
CAGR |
Psychotherapy |
6% |
5,784 |
6,793 |
7,374 |
7,846 |
8,348 |
9.61% |
Psychopharmacology |
0% |
3,911 |
5,184 |
6,282 |
6,282 |
6,282 |
12.58% |
IOP |
0% |
898 |
898 |
988 |
988 |
988 |
2.42% |
B H Contracts |
5% |
0 |
0 |
2,000 |
2,000 |
2,000 |
0.00% |
Other |
0% |
0 |
0 |
0 |
0 |
0 |
0.00% |
Total |
13.56% |
10,593 |
12,875 |
16,644 |
17,116 |
17,618 |
13.56% |
The target customers are the consumers of mental health services (i.e. individuals, couples, families, and groups). The composition breakdown is approximately 50% adults and 50% children, adolescents, and families. The second target customer are the payors. They are an integral piece of this turn key project. The payors are basically the gatekeepers for referrals and authorizations.
Wherever possible, our niche marketing approach will be linked to our sales strategies.
Operationally, the Center is prepared to handle growth. Support staff is in place, as are other necessary environmental resources. The immediate problem would be to transfer patients from one center to another. Through a planned transition program being driven by the therapists, it should occur without too much difficulty or confusion.
The chart and table depict a modest 18% growth rate for the second year, and a 23% growth rate for the third year. The second year growth rate will be the result of adding additional therapy hours. The third year growth will be a result of adding therapy contracts. We are in the process of negotiating with Harbor Schools to provide on sight therapy services.
Sales Forecast |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Unit Sales |
|
|
|
Psychotherapy |
5,784 |
6,792 |
7,374 |
Psychopharmacology/MD |
2,520 |
3,264 |
3,950 |
Psychopharmacology/CNS |
1,391 |
1,920 |
2,332 |
Addictions/3 hr IOP |
310 |
310 |
450 |
Addictions/1hr IOP |
588 |
588 |
538 |
Contracts |
0 |
0 |
2,000 |
Other |
0 |
0 |
0 |
Total Unit Sales |
10,593 |
12,874 |
16,644 |
|
|
|
|
Unit Prices |
Year 1 |
Year 2 |
Year 3 |
Psychotherapy |
$59.52 |
$59.52 |
$59.52 |
Psychopharmacology/MD |
$40.92 |
$40.92 |
$40.92 |
Psychopharmacology/CNS |
$32.55 |
$32.55 |
$32.55 |
Addictions/3 hr IOP |
$77.19 |
$77.19 |
$77.19 |
Addictions/1hr IOP |
$22.32 |
$22.32 |
$22.32 |
Contracts |
$0.00 |
$0.00 |
$59.52 |
Other |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
Sales |
|
|
|
Psychotherapy |
$344,264 |
$404,260 |
$438,900 |
Psychopharmacology/MD |
$103,118 |
$133,563 |
$161,634 |
Psychopharmacology/CNS |
$45,277 |
$62,496 |
$75,907 |
Addictions/3 hr IOP |
$23,929 |
$23,929 |
$34,736 |
Addictions/1hr IOP |
$13,124 |
$13,124 |
$12,008 |
Contracts |
$0 |
$0 |
$119,040 |
Other |
$0 |
$0 |
$0 |
Total Sales |
$529,712 |
$637,372 |
$842,225 |
|
|
|
|
Direct Unit Costs |
Year 1 |
Year 2 |
Year 3 |
Psychotherapy |
$35.71 |
$35.71 |
$35.71 |
Psychopharmacology/MD |
$28.64 |
$28.64 |
$28.64 |
Psychopharmacology/CNS |
$19.53 |
$19.53 |
$19.53 |
Addictions/3 hr IOP |
$13.12 |
$27.02 |
$27.02 |
Addictions/1hr IOP |
$4.91 |
$6.47 |
$6.47 |
Contracts |
$0.00 |
$0.00 |
$35.71 |
Other |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
Direct Cost of Sales |
|
|
|
Psychotherapy |
$206,558 |
$242,542 |
$263,326 |
Psychopharmacology/MD |
$72,183 |
$93,481 |
$113,128 |
Psychopharmacology/CNS |
$27,166 |
$37,498 |
$45,544 |
Addictions/3 hr IOP |
$4,068 |
$8,376 |
$12,159 |
Addictions/1hr IOP |
$2,887 |
$3,804 |
$3,481 |
Contracts |
$0 |
$0 |
$71,420 |
Other |
$0 |
$0 |
$0 |
Subtotal Direct Cost of Sales |
$312,863 |
$385,701 |
$509,057 |
Target marketing of our services is critical to growth. Strategies will include:
Marketing tools will include: direct mail, print and audio advertising, public speaking, and relationship building with identified managed care corporations and persons.
An advisory management group, consisting of the Center's staff, will meet on a regular basis to review the Center's financial structure, identify customer relations issues, and develop future goals for growth, marketing, and sales. This group will be assigned the task of developing a plan to implement and integrate a Continuous Quality Improvement (CQI) component and culture into a private practice Shared Service Model (SSM). A customer relations committee will be formed to brainstorm, formulate ideas, plan and implement activities to enhance levels of satisfaction among all customers. The organizational chart follows:
|
Amesbury Psychological Center |
|
|
Organizational Chart |
|
|
|
|
ADVISORY BOARD |
CENTER DIRECTOR |
CONSULTANTS |
SUPPORT STAFF |
ASSOCIATES |
MEDICAL DIRECTOR |
|
MEDICAL STAFF |
|
|
THERAPISTS |
|
|
ADDICTION STAFF |
|
|
CONTRACTS STAFF |
|
**Names have been removed for confidentiality
Human resources, legal, fiscal billing, and marketing/sales will be out sourced. We are in the process of identifying a human resource company and a billing/collection company. The billing company will be paid a percent of fees collected with a goal of collecting at least 93% of that billed. Thought will be given to other risk variables to be included in the contract. The costs for the Human Resource services are not determined as of this writing.
The president/director's compensation will be a combined package that includes 75% administrative salary and 25% from clinical work.
Personnel Plan |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Center Director (.75 FTE) |
$41,244 |
$42,481 |
$43,755 |
Client Accounts Coord. (.75 FTE) |
$23,244 |
$23,941 |
$24,659 |
Secretary/Recep (1 FTE) |
$24,000 |
$24,720 |
$25,462 |
Receptionist (.50 FTE) |
$11,256 |
$11,594 |
$12,302 |
Total People |
4 |
4 |
4 |
|
|
|
|
Total Payroll |
$99,744 |
$102,736 |
$106,178 |
There are several assumptions related to this turn key project.
The following table summarizes the general financial assumptions.
General Assumptions |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Plan Month |
1 |
2 |
3 |
Current Interest Rate |
9.75% |
9.75% |
9.75% |
Long-term Interest Rate |
9.75% |
9.75% |
9.75% |
Tax Rate |
2.50% |
0.00% |
2.50% |
Other |
0 |
0 |
0 |
Similiarly, collection days remains the same during the next three years. However, efforts will be made to improve this variable with the use of electronic billing.
As sales of services increase, operating costs will rise as well. Every effort will be made to contain these costs proportionately. There are no actual or projected significant increases evident. The variable costs will increase during the third year as we need to hire new staff for the projected contracts. The hiring will not be concluded until the contracts are signed so as to avoid any unnecessary spending.
Break-even Analysis |
|
|
|
Monthly Units Break-even |
752 |
Monthly Revenue Break-even |
$37,618 |
|
|
Assumptions: |
|
Average Per-Unit Revenue |
$50.01 |
Average Per-Unit Variable Cost |
$29.53 |
Estimated Monthly Fixed Cost |
$15,400 |
Pro Forma Profit and Loss |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Sales |
$529,712 |
$637,372 |
$842,225 |
Direct Cost of Sales |
$312,863 |
$385,701 |
$509,057 |
Other |
$0 |
$0 |
$0 |
Total Cost of Sales |
$312,863 |
$385,701 |
$509,057 |
|
|
|
|
Gross Margin |
$216,850 |
$251,670 |
$333,167 |
Gross Margin % |
40.94% |
39.49% |
39.56% |
|
|
|
|
|
|
|
|
Expenses |
|
|
|
Payroll |
$99,744 |
$102,736 |
$106,178 |
Marketing/Promotion |
$7,700 |
$10,500 |
$11,100 |
Depreciation |
$0 |
$0 |
$0 |
Leased Equipment |
$3,000 |
$3,000 |
$3,500 |
Billing Fees (6% of billed plus 1.5% copays) |
$22,951 |
$31,869 |
$42,111 |
Insurance |
$3,500 |
$3,600 |
$3,600 |
Rent |
$10,992 |
$11,000 |
$26,400 |
Human Resource/HR Logic |
$6,000 |
$6,000 |
$6,000 |
Med Dir.,Multidisc.,RNCS Sup. |
$10,000 |
$12,000 |
$12,000 |
Telephone |
$6,000 |
$6,500 |
$7,000 |
Postage |
$1,050 |
$1,300 |
$1,400 |
Office Supplies |
$3,860 |
$4,110 |
$4,200 |
Payroll Taxes |
$0 |
$0 |
$0 |
Contract/Consultants |
$10,000 |
$10,000 |
$10,000 |
|
|
|
|
Total Operating Expenses |
$184,797 |
$202,615 |
$233,489 |
|
|
|
|
Profit Before Interest and Taxes |
$32,053 |
$49,055 |
$99,678 |
EBITDA |
$32,053 |
$49,055 |
$99,678 |
Interest Expense |
$4,400 |
$3,436 |
$2,260 |
Taxes Incurred |
$1,103 |
$0 |
$2,435 |
|
|
|
|
Net Profit |
$26,550 |
$45,619 |
$94,983 |
Net Profit/Sales |
5.01% |
7.16% |
11.28% |
Pro Forma Cash Flow |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Cash Received |
|
|
|
|
|
|
|
Cash from Operations |
|
|
|
Cash Sales |
$52,971 |
$63,737 |
$84,222 |
Cash from Receivables |
$356,266 |
$557,202 |
$724,642 |
Subtotal Cash from Operations |
$409,237 |
$620,940 |
$808,864 |
|
|
|
|
Additional Cash Received |
|
|
|
Sales Tax, VAT, HST/GST Received |
$0 |
$0 |
$0 |
New Current Borrowing |
$0 |
$0 |
$0 |
New Other Liabilities (interest-free) |
$0 |
$0 |
$0 |
New Long-term Liabilities |
$0 |
$0 |
$0 |
Sales of Other Current Assets |
$0 |
$0 |
$0 |
Sales of Long-term Assets |
$0 |
$0 |
$0 |
New Investment Received |
$0 |
$0 |
$0 |
Subtotal Cash Received |
$409,237 |
$620,940 |
$808,864 |
|
|
|
|
Expenditures |
Year 1 |
Year 2 |
Year 3 |
|
|
|
|
Expenditures from Operations |
|
|
|
Cash Spending |
$99,744 |
$102,736 |
$106,178 |
Bill Payments |
$369,968 |
$482,273 |
$628,567 |
Subtotal Spent on Operations |
$469,712 |
$585,010 |
$734,744 |
|
|
|
|
Additional Cash Spent |
|
|
|
Sales Tax, VAT, HST/GST Paid Out |
$0 |
$0 |
$0 |
Principal Repayment of Current Borrowing |
$0 |
$0 |
$0 |
Other Liabilities Principal Repayment |
$0 |
$0 |
$0 |
Long-term Liabilities Principal Repayment |
$9,000 |
$11,515 |
$12,620 |
Purchase Other Current Assets |
$0 |
$0 |
$0 |
Purchase Long-term Assets |
$0 |
$0 |
$0 |
Dividends |
$0 |
$0 |
$0 |
Subtotal Cash Spent |
$478,712 |
$596,525 |
$747,364 |
|
|
|
|
Net Cash Flow |
($69,475) |
$24,415 |
$61,500 |
Cash Balance |
$31,525 |
$55,940 |
$117,439 |
Pro Forma Balance Sheet |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Assets |
|
|
|
|
|
|
|
Current Assets |
|
|
|
Cash |
$31,525 |
$55,940 |
$117,439 |
Accounts Receivable |
$120,475 |
$136,908 |
$170,268 |
Other Current Assets |
$5,000 |
$5,000 |
$5,000 |
Total Current Assets |
$157,000 |
$197,847 |
$292,708 |
|
|
|
|
Long-term Assets |
|
|
|
Long-term Assets |
$0 |
$0 |
$0 |
Accumulated Depreciation |
$0 |
$0 |
$0 |
Total Long-term Assets |
$0 |
$0 |
$0 |
Total Assets |
$157,000 |
$197,847 |
$292,708 |
|
|
|
|
Liabilities and Capital |
Year 1 |
Year 2 |
Year 3 |
|
|
|
|
Current Liabilities |
|
|
|
Accounts Payable |
$33,450 |
$40,193 |
$52,690 |
Current Borrowing |
$0 |
$0 |
$0 |
Other Current Liabilities |
$0 |
$0 |
$0 |
Subtotal Current Liabilities |
$33,450 |
$40,193 |
$52,690 |
|
|
|
|
Long-term Liabilities |
$41,000 |
$29,485 |
$16,865 |
Total Liabilities |
$74,450 |
$69,678 |
$69,555 |
|
|
|
|
Paid-in Capital |
$65,000 |
$65,000 |
$65,000 |
Retained Earnings |
($9,000) |
$17,550 |
$63,169 |
Earnings |
$26,550 |
$45,619 |
$94,983 |
Total Capital |
$82,550 |
$128,169 |
$223,153 |
Total Liabilities and Capital |
$157,000 |
$197,847 |
$292,708 |
|
|
|
|
Net Worth |
$82,550 |
$128,169 |
$223,153 |
Ratio Analysis |
|
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Industry Profile |
Sales Growth |
n.a. |
20.32% |
32.14% |
2.30% |
|
|
|
|
|
Percent of Total Assets |
|
|
|
|
Accounts Receivable |
76.74% |
69.20% |
58.17% |
25.20% |
Other Current Assets |
3.18% |
2.53% |
1.71% |
33.00% |
Total Current Assets |
100.00% |
100.00% |
100.00% |
60.00% |
Long-term Assets |
0.00% |
0.00% |
0.00% |
40.00% |
Total Assets |
100.00% |
100.00% |
100.00% |
100.00% |
|
|
|
|
|
Current Liabilities |
21.31% |
20.32% |
18.00% |
23.10% |
Long-term Liabilities |
26.11% |
14.90% |
5.76% |
19.60% |
Total Liabilities |
47.42% |
35.22% |
23.76% |
42.70% |
Net Worth |
52.58% |
64.78% |
76.24% |
57.30% |
|
|
|
|
|
Percent of Sales |
|
|
|
|
Sales |
100.00% |
100.00% |
100.00% |
100.00% |
Gross Margin |
40.94% |
39.49% |
39.56% |
0.00% |
Selling, General & Administrative Expenses |
39.65% |
36.14% |
32.27% |
73.80% |
Advertising Expenses |
0.00% |
0.00% |
0.00% |
0.40% |
Profit Before Interest and Taxes |
6.05% |
7.70% |
11.84% |
8.90% |
|
|
|
|
|
Main Ratios |
|
|
|
|
Current |
4.69 |
4.92 |
5.56 |
2.45 |
Quick |
4.69 |
4.92 |
5.56 |
1.95 |
Total Debt to Total Assets |
47.42% |
35.22% |
23.76% |
42.70% |
Pre-tax Return on Net Worth |
33.50% |
35.59% |
43.66% |
8.10% |
Pre-tax Return on Assets |
17.61% |
23.06% |
33.28% |
14.20% |
|
|
|
|
|
Additional Ratios |
Year 1 |
Year 2 |
Year 3 |
|
Net Profit Margin |
5.01% |
7.16% |
11.28% |
n.a |
Return on Equity |
32.16% |
35.59% |
42.56% |
n.a |
|
|
|
|
|
Activity Ratios |
|
|
|
|
Accounts Receivable Turnover |
3.96 |
4.19 |
4.45 |
n.a |
Collection Days |
83 |
82 |
74 |
n.a |
Accounts Payable Turnover |
12.06 |
12.17 |
12.17 |
n.a |
Payment Days |
27 |
27 |
26 |
n.a |
Total Asset Turnover |
3.37 |
3.22 |
2.88 |
n.a |
|
|
|
|
|
Debt Ratios |
|
|
|
|
Debt to Net Worth |
0.90 |
0.54 |
0.31 |
n.a |
Current Liab. to Liab. |
0.45 |
0.58 |
0.76 |
n.a |
|
|
|
|
|
Liquidity Ratios |
|
|
|
|
Net Working Capital |
$123,550 |
$157,654 |
$240,018 |
n.a |
Interest Coverage |
7.29 |
14.28 |
44.11 |
n.a |
|
|
|
|
|
Additional Ratios |
|
|
|
|
Assets to Sales |
0.30 |
0.31 |
0.35 |
n.a |
Current Debt/Total Assets |
21% |
20% |
18% |
n.a |
Acid Test |
1.09 |
1.52 |
2.32 |
n.a |
Sales/Net Worth |
6.42 |
4.97 |
3.77 |
n.a |
Dividend Payout |
0.00 |
0.00 |
0.00 |
n.a |
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 |
Unit Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
Psychotherapy |
0% |
482 |
482 |
482 |
482 |
482 |
482 |
482 |
482 |
482 |
482 |
482 |
482 |
Psychopharmacology/MD |
0% |
210 |
210 |
210 |
210 |
210 |
210 |
210 |
210 |
210 |
210 |
210 |
210 |
Psychopharmacology/CNS |
0% |
86 |
86 |
86 |
86 |
86 |
86 |
146 |
146 |
146 |
146 |
146 |
146 |
Addictions/3 hr IOP |
0% |
26 |
26 |
26 |
26 |
26 |
26 |
26 |
26 |
26 |
26 |
26 |
26 |
Addictions/1hr IOP |
0% |
49 |
49 |
49 |
49 |
49 |
49 |
49 |
49 |
49 |
49 |
49 |
49 |
Contracts |
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 Unit Sales |
|
853 |
853 |
853 |
853 |
853 |
853 |
913 |
913 |
913 |
913 |
913 |
913 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Unit Prices |
|
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Month 7 |
Month 8 |
Month 9 |
Month 10 |
Month 11 |
Month 12 |
Psychotherapy |
$64.00 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
$59.52 |
Psychopharmacology/MD |
$44.00 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
$40.92 |
Psychopharmacology/CNS |
$35.00 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
$32.55 |
Addictions/3 hr IOP |
$83.00 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
$77.19 |
Addictions/1hr IOP |
$24.00 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
$22.32 |
Contracts |
$64.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
Other |
|
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
Psychotherapy |
|
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
$28,689 |
Psychopharmacology/MD |
|
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
$8,593 |
Psychopharmacology/CNS |
|
$2,794 |
$2,794 |
$2,794 |
$2,794 |
$2,794 |
$2,794 |
$4,752 |
$4,752 |
$4,752 |
$4,752 |
$4,752 |
$4,752 |
Addictions/3 hr IOP |
|
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
$1,994 |
Addictions/1hr IOP |
|
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
$1,094 |
Contracts |
|
$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 |
Total Sales |
|
$43,163 |
$43,163 |
$43,163 |
$43,163 |
$43,163 |
$43,163 |
$45,122 |
$45,122 |
$45,122 |
$45,122 |
$45,122 |
$45,122 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Direct Unit Costs |
|
Month 1 |
Month 2 |
Month 3 |
Month 4 |
Month 5 |
Month 6 |
Month 7 |
Month 8 |
Month 9 |
Month 10 |
Month 11 |
Month 12 |
Psychotherapy |
60.00% |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
$35.71 |
Psychopharmacology/MD |
70.00% |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
$28.64 |
Psychopharmacology/CNS |
60.00% |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
$19.53 |
Addictions/3 hr IOP |
17.00% |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
$13.12 |
Addictions/1hr IOP |
22.00% |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
$4.91 |
Contracts |
60.00% |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
Other |
0.00% |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
$0.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Direct Cost of Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
Psychotherapy |
|
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
$17,213 |
Psychopharmacology/MD |
|
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
$6,015 |
Psychopharmacology/CNS |
|
$1,676 |
$1,676 |
$1,676 |
$1,676 |
$1,676 |
$1,676 |
$2,851 |
$2,851 |
$2,851 |
$2,851 |
$2,851 |
$2,851 |
Addictions/3 hr IOP |
|
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
$339 |
Addictions/1hr IOP |
|
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
$241 |
Contracts |
|
$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 |
Subtotal Direct Cost of Sales |
|
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
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 |
|
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
Long-term Interest Rate |
|
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
9.75% |
Tax Rate |
|
30.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
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 |
|
$43,163 |
$43,163 |
$43,163 |
$43,163 |
$43,163 |
$43,163 |
$45,122 |
$45,122 |
$45,122 |
$45,122 |
$45,122 |
$45,122 |
Direct Cost of Sales |
|
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
Other |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Cost of Sales |
|
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$25,484 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
$26,659 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gross Margin |
|
$17,679 |
$17,679 |
$17,679 |
$17,679 |
$17,679 |
$17,679 |
$18,462 |
$18,462 |
$18,462 |
$18,462 |
$18,462 |
$18,462 |
Gross Margin % |
|
40.96% |
40.96% |
40.96% |
40.96% |
40.96% |
40.96% |
40.92% |
40.92% |
40.92% |
40.92% |
40.92% |
40.92% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
Payroll |
|
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
Marketing/Promotion |
|
$675 |
$675 |
$675 |
$675 |
$675 |
$625 |
$625 |
$625 |
$625 |
$625 |
$625 |
$575 |
Depreciation |
|
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Leased Equipment |
|
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
$250 |
Billing Fees (6% of billed plus 1.5% copays) |
|
$53 |
$665 |
$1,685 |
$2,093 |
$2,096 |
$2,104 |
$2,131 |
$2,174 |
$2,217 |
$2,385 |
$2,628 |
$2,720 |
Insurance |
|
$300 |
$300 |
$300 |
$300 |
$300 |
$300 |
$300 |
$300 |
$300 |
$300 |
$300 |
$200 |
Rent |
|
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
$916 |
Human Resource/HR Logic |
|
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
Med Dir.,Multidisc.,RNCS Sup. |
|
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
Telephone |
|
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
$500 |
Postage |
|
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$100 |
$50 |
$50 |
$50 |
Office Supplies |
|
$330 |
$330 |
$330 |
$330 |
$330 |
$330 |
$330 |
$330 |
$330 |
$330 |
$330 |
$230 |
Payroll Taxes |
15% |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Contract/Consultants |
|
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$833 |
$837 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Operating Expenses |
|
$13,602 |
$14,214 |
$15,234 |
$15,642 |
$15,645 |
$15,603 |
$15,630 |
$15,673 |
$15,716 |
$15,834 |
$16,077 |
$15,923 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Profit Before Interest and Taxes |
|
$4,077 |
$3,465 |
$2,445 |
$2,037 |
$2,034 |
$2,076 |
$2,832 |
$2,789 |
$2,746 |
$2,628 |
$2,385 |
$2,539 |
EBITDA |
|
$4,077 |
$3,465 |
$2,445 |
$2,037 |
$2,034 |
$2,076 |
$2,832 |
$2,789 |
$2,746 |
$2,628 |
$2,385 |
$2,539 |
Interest Expense |
|
$400 |
$394 |
$388 |
$382 |
$376 |
$370 |
$364 |
$358 |
$351 |
$345 |
$339 |
$333 |
Taxes Incurred |
|
$1,103 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Profit |
|
$2,574 |
$3,071 |
$2,057 |
$1,655 |
$1,658 |
$1,706 |
$2,469 |
$2,432 |
$2,395 |
$2,283 |
$2,046 |
$2,206 |
Net Profit/Sales |
|
5.96% |
7.11% |
4.77% |
3.83% |
3.84% |
3.95% |
5.47% |
5.39% |
5.31% |
5.06% |
4.53% |
4.89% |
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 |
|
$4,316 |
$4,316 |
$4,316 |
$4,316 |
$4,316 |
$4,316 |
$4,512 |
$4,512 |
$4,512 |
$4,512 |
$4,512 |
$4,512 |
Cash from Receivables |
|
$0 |
$0 |
$1,295 |
$38,847 |
$38,847 |
$38,847 |
$38,847 |
$38,847 |
$38,906 |
$40,610 |
$40,610 |
$40,610 |
Subtotal Cash from Operations |
|
$4,316 |
$4,316 |
$5,611 |
$43,163 |
$43,163 |
$43,163 |
$43,359 |
$43,359 |
$43,418 |
$45,122 |
$45,122 |
$45,122 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
$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,316 |
$4,316 |
$5,611 |
$43,163 |
$43,163 |
$43,163 |
$43,359 |
$43,359 |
$43,418 |
$45,122 |
$45,122 |
$45,122 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
$8,312 |
Bill Payments |
|
$1,076 |
$32,261 |
$31,815 |
$32,808 |
$33,196 |
$33,192 |
$33,185 |
$34,343 |
$34,379 |
$34,419 |
$34,535 |
$34,759 |
Subtotal Spent on Operations |
|
$9,388 |
$40,573 |
$40,127 |
$41,120 |
$41,508 |
$41,504 |
$41,497 |
$42,655 |
$42,691 |
$42,731 |
$42,847 |
$43,071 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
$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 |
|
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
$750 |
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 |
|
$10,138 |
$41,323 |
$40,877 |
$41,870 |
$42,258 |
$42,254 |
$42,247 |
$43,405 |
$43,441 |
$43,481 |
$43,597 |
$43,821 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Cash Flow |
|
($5,822) |
($37,007) |
($35,265) |
$1,293 |
$905 |
$910 |
$1,112 |
($45) |
($23) |
$1,641 |
$1,525 |
$1,301 |
Cash Balance |
|
$95,178 |
$58,172 |
$22,906 |
$24,200 |
$25,105 |
$26,014 |
$27,126 |
$27,081 |
$27,058 |
$28,699 |
$30,224 |
$31,525 |
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 |
$101,000 |
$95,178 |
$58,172 |
$22,906 |
$24,200 |
$25,105 |
$26,014 |
$27,126 |
$27,081 |
$27,058 |
$28,699 |
$30,224 |
$31,525 |
Accounts Receivable |
$0 |
$38,847 |
$77,694 |
$115,246 |
$115,246 |
$115,246 |
$115,246 |
$117,009 |
$118,772 |
$120,475 |
$120,475 |
$120,475 |
$120,475 |
Other Current Assets |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
$5,000 |
Total Current Assets |
$106,000 |
$139,026 |
$140,866 |
$143,153 |
$144,446 |
$145,351 |
$146,261 |
$149,135 |
$150,853 |
$152,533 |
$154,174 |
$155,699 |
$157,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Assets |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Accumulated Depreciation |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Long-term Assets |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
$0 |
Total Assets |
$106,000 |
$139,026 |
$140,866 |
$143,153 |
$144,446 |
$145,351 |
$146,261 |
$149,135 |
$150,853 |
$152,533 |
$154,174 |
$155,699 |
$157,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
$31,202 |
$30,721 |
$31,701 |
$32,090 |
$32,087 |
$32,041 |
$33,197 |
$33,232 |
$33,268 |
$33,376 |
$33,605 |
$33,450 |
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 |
$31,202 |
$30,721 |
$31,701 |
$32,090 |
$32,087 |
$32,041 |
$33,197 |
$33,232 |
$33,268 |
$33,376 |
$33,605 |
$33,450 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Long-term Liabilities |
$50,000 |
$49,250 |
$48,500 |
$47,750 |
$47,000 |
$46,250 |
$45,500 |
$44,750 |
$44,000 |
$43,250 |
$42,500 |
$41,750 |
$41,000 |
Total Liabilities |
$50,000 |
$80,452 |
$79,221 |
$79,451 |
$79,090 |
$78,337 |
$77,541 |
$77,947 |
$77,232 |
$76,518 |
$75,876 |
$75,355 |
$74,450 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid-in Capital |
$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 |
Retained Earnings |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
($9,000) |
Earnings |
$0 |
$2,574 |
$5,644 |
$7,701 |
$9,356 |
$11,014 |
$12,720 |
$15,189 |
$17,620 |
$20,015 |
$22,298 |
$24,344 |
$26,550 |
Total Capital |
$56,000 |
$58,574 |
$61,644 |
$63,701 |
$65,356 |
$67,014 |
$68,720 |
$71,189 |
$73,620 |
$76,015 |
$78,298 |
$80,344 |
$82,550 |
Total Liabilities and Capital |
$106,000 |
$139,026 |
$140,866 |
$143,153 |
$144,446 |
$145,351 |
$146,261 |
$149,135 |
$150,853 |
$152,533 |
$154,174 |
$155,699 |
$157,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Worth |
$56,000 |
$58,574 |
$61,644 |
$63,701 |
$65,356 |
$67,014 |
$68,720 |
$71,189 |
$73,620 |
$76,015 |
$78,298 |
$80,344 |
$82,550 |