BUSINESS PLAN JUNIPER COUNSELING CENTER (JCC)
1600 West Main Street
Ann Arbor, Michigan 48106
The Juniper Counseling Center (JCC) is a mental and health counseling/education center focusing on teen mothers, troubled children/youth, and senior citizens with mental/health issues. The business plan was developed for the purpose of a start-up business loan in the amount of $20,935.
The Juniper Counseling Center (JCC) is a mental and health counseling/education center focusing on teen mothers, troubled children/youth, and senior citizens with mental/health issues. JCC is located at 1600 West Main Street in Ann Arbor, Michigan. The business plan was developed for the purpose of a start-up business loan in the amount of $20,935. The total amount needed to open JCC is $26,935. The owner's investment is $6,000.
Our projected sales for 2002 is over $290,000 and our first year projected net profits are well over $40,000.
Juniper's keys to success include: marketing, service quality, growth potential, implementing an effective cash flow plan, achieving efficiency, running our counseling center professionally, and maintaining a serious business discipline in everything we do.
Mental and health counseling and educational training services, as shown in our plan, have an excellent profitability level and growth rate. Our competitive edge along with new counseling techniques put JCC in the forefront of counseling and educational services. We are living in an age where new techniques for mental and health counseling are in great demand. Our center will differ from the traditional counseling services because of our added personal touch.
Our objectives are to:
JCC's mission is to empower disadvantaged and disenfranchised individuals, families, and youths to take control of their destiny and function productively by providing them with the necessary skills to realize their dreams, through counseling, education, social skills training, motivation, and participating in the treatment of abnormal behaviors to become successful.
Juniper's keys to success include: marketing, service quality, growth potential, implementing an effective cash flow plan, achieving efficiency, running our counseling center professionally, and maintaining a serious business discipline in everything we do.
JCC's cash flow plan is to:
Our vision is to move Washtenaw County's disenfranchised population to a condition of empowerment and self-determination, by enabling them to employ innovative strategies to produce desirable actions that lead to healthy results. JCC is dedicated to the community it serves. Through seminars, therapeutic groups, individual, couples, and family counseling, the center strives to raise public awareness to the needs of at-risk residents within our community. Services are designed to strengthen and increase self-esteem, self-respect, and respect for others in society, promote health, and to address issues relating to improving the quality of their lives.
The founder and owner is Rolanda K. Walker, R.N., MSW, Ph.D. It is a privately owned corporation.
JCC will be located at 1600 West Main Street, Ann Arbor, Michigan.
The process of the JCC business operations is as follows:
Our total start-up costs are $26,935, which is mostly for furniture, equipment, working capital, and expenses associated with opening our first office. Direct owner investment will be $6,000. JCC will seek a commercial loan for the remaining $20,935 needed to start up the business. The assumptions are shown in the following table.
Start-up Expenses | |
2-Surge Protectors | $60 |
4-Computers | $4,000 |
Copy Machine | $600 |
Laser Printer | $2,000 |
Adding Machine | $30 |
Electric Typewriter | $120 |
Fax Machine | $300 |
12-Clip Boards | $12 |
4-Waste Baskets | $12 |
File Folders | $75 |
4-Desk Organizers | $200 |
4-Floor Mates | $184 |
Hole Punchers | $12 |
Paper | $60 |
4-Wall Clock | $80 |
Pens/Pencils/Markers/Paper Clips/Tacks | $60 |
3-Large Bulletin Boards | $90 |
2-Paper Shredder | $50 |
2-Paper Stand | $30 |
4-File Cabinets | $240 |
1-Supply Cabinet | $200 |
Wall Pictures | $350 |
1-Oval Table | $400 |
12-Chairs | $312 |
4-Desk Lamps | $60 |
1-Standing Lamp | $30 |
2-TV/VCR | $500 |
Entrance Rug | $90 |
Computer Disks | $16 |
Envelopes | $50 |
Labels | $25 |
File Guides | $60 |
Organizer Compartment | $30 |
Laminator | $200 |
Paper/Plastic Cutter | $60 |
Electric Stapler | $70 |
Tape | $8 |
3-Desk Calendars | $18 |
Pencil Sharpeners | $35 |
3-Office Chairs | $130 |
1-Executive Chair | $500 |
3-Desks | $900 |
3-Love Seats | $600 |
3-Guest Chairs | $390 |
3-Book Shelves | $300 |
Childrens' Table & Chairs | $100 |
Childrens' Games | $150 |
Teaching Aids | $200 |
Childrens' Toys | $150 |
Carpeting | $2,000 |
Group Room Furniture | $752 |
Therapist Software Programs | $930 |
Kitchen Furniture | $450 |
3-Staplers | $24 |
Tablets/Rolodex | $30 |
Legal | $1,500 |
Stationery, etc. | $300 |
Brochures | $300 |
Professional Development | $500 |
Other | $0 |
Total Start-up Expense | $20,935 |
Start-up Assets Needed | |
Cash Requirements | $6,000 |
Start-up inventory | $0 |
Other Short-term Assets | $0 |
Total Short-term Assets | $6,000 |
Long-term Assets | $0 |
Total Assets | $6,000 |
Total Start-up Requirements: | $26,935 |
Left to finance: | $0 |
Start-up Funding Plan | |
Investment | |
Investor 1 | $0 |
Investor 2 | $0 |
Owner's Equity | $6,000 |
Total investment | $6,000 |
Short-term Liabilities | |
Unpaid Expenses | $0 |
Short-term Loans | $20,935 |
Interest-free Short-term Loans | $0 |
Subtotal Short-term Liabilities | $20,935 |
Long-term Liabilities | $0 |
Total Liabilities | $20,935 |
Loss at Start-up | ($20,935) |
Total Capital | ($14,935) |
Total Capital and Liabilities | $6,000 |
Checkline | $0 |
Services offered include education, training, and counseling to empower and implement a change in a person's behavior and thinking.
JCC will also provide the following services to individuals, families, couples, and youth:
JCC will be focusing on providing education and counseling services to teen mothers, out-of-control children/youth, individuals with mental health disorders, and senior citizens with mental and health issues.
The U.S Census Bureau County Population report of 1998 states that there are approximately 436,084 people living in Washtenaw County. Any of these individuals is a possible client for JCC.
JCC knows we cannot survive just waiting for the customer to come to us. Instead, we must get better at focusing on the specific market segments whose needs match our offering. Focusing on targeted segments is the key to our future. Therefore, we will focus our marketing message and our service offerings. We will develop our message, communicate it to our referral partners, and make good on it.
Nearly one million teen girls get pregnant each year. More than four out of 10 young women get pregnant at least once before they turn 20. Each year the federal government alone spends about $40 billion to help families that began with a teenage birth.
In Michigan, 11,350 15 to 17-year-olds gave birth, and 18,490 18 to 19-year-olds gave birth. Michigan ranks 24 (Rank of 1=largest decrease) for teen pregnancy rate with 87 pregnancies per 1,000 girls. Teen pregnancies were down in all age groups ranging from girls aged 14 and younger to girls aged 15 to 19-year-olds. Twenty-two percent of births in Michigan are to teens who have already had a birth.
Hispanic/Latina girls were the highest in birth rates among different racial/ethnic groups with African Americans being the second highest and White (non-Hispanic) being the third highest. From 1991-1998 African American girls has had the highest decrease in births with a 35% decrease. White (non-Hispanic) came in second with a 22% decrease and Hispanic/Latina with a 3% decrease in births. Asian/Pacific Islanders had an increase of 7% in teen births. JCC will continue this fight against teen pregnancy through our educational and counseling programs for teens.
On January 17, 2001 David Satcher, M.D., Surgeon General of the United States of America unveiled a compelling report on youth violence to the frontline caregivers of our nation. The report was commissioned after the now infamous 1999 Columbine event that focused America's attention on children's behavior and their sometimes inability to cope with stress. In the report, Dr. Satcher invites families, school personnel, and public health communities to take a proactive role in the prevention of youth violence. "This is no time to let down our guard on youth violence," said Dr. Satcher.
Dr. Satcher's public health perspective identifies behavioral, environmental, and biological factors associated with youth violence. The report goes on to encourage our nation to take steps in educating individuals, communities, and primary care physicians to protect themselves from these risks. Dr. Satcher's public health approach offers a practical, goal-oriented, and community-based strategy for promoting and maintaining health. "The most urgent need now is a national resolve to confront the problem of youth violence systematically using researchbased approaches and to correct damaging myths and stereotypes that interfere with the risk at hand," said Satcher.
According to the American Academy of Child and Adolescent Psychiatry (AACAP) the needs and voice of child and adolescent psychiatry have been buried under the sweeping forces of federal mandates and national medical organizations' consensus on the oversupply of specialists. They have failed to recognize the continuing critical shortage of child and adolescent psychiatrists. There is a danger of becoming marginalized when the profession cannot provide needed services and contribute to society. The serious undersupply of practitioners has resulted in children receiving inadequate care from mental health professionals who lack the necessary training.
Report of the Surgeon General's Conference on Children's Mental Health: A National Action Agenda released the following information on January 3, 2001. From this information a report was developed and is the culmination of nearly a year of significant activities that were launched with the March 22, 2000, White House Meeting on Children's Mental Health. The report emphasizes the magnitude of the problem facing us in the United States. One in 10 children and adolescents suffers from a mental illness severe enough to cause some level of impairment. The report also emphasizes that it is estimated that fewer than 1 in 5 of these children receive needed treatment in any given year.
As stated in the foreword to the report, "The burden of suffering experienced by children with mental health needs and their families has created a health crisis in this country. Growing numbers of children are suffering needlessly because their emotional, behavioral, and developmental needs are not being met…… It is time that we as a Nation took seriously the taskof preventing mental health problems and treating mental illnesses in youth."
Older Americans are living longer and living better than ever before. But many of those age 65 and older face disability, chronic health conditions, or economic stress according to a new federal indicators report that describes the status of the nation's older population.
The number and proportion of older people in the U.S. population has grown and generally will continue to grow at a very rapid pace. Aging in the twenty-first century will be characterized by a steep rise in the population age 85 and older and increased racial and ethnic diversity.
Older Americans are living longer and feeling better. An overwhelming majority rate their health as good or excellent. Men and women report comparable levels of well-being. Disability rates are declining as well. But large numbers of older people find their health threatened by memory impairments, depression, chronic conditions, and disability, especially at very advanced ages, which can substantially diminish quality of life.
Overall teen pregnancies have decreased but they are still too high. The overall U.S. teenage pregnancy rate declined 17 percent between 1990 and 1996 (the most recent year available), from 117 pregnancies per 1,000 women aged 15-19 to 97 per 1,000. The national teen birth rate declined 3 percent between 1998 and 1999, reaching a rate of 49.6 births per 1,000 women ages 15-19—the lowest rate ever recorded. Since 1991, the teen birth rate has declined 20 percent. Nearly one million teen girls get pregnant each year. More than four out of 10 young women get pregnant at least once before they turn 20. Each year the federal government alone spends about $40 billion to help families that began with a teenage birth. Yet, much work is needed to be done in order to keep teen pregnancy down, such as more educational and counseling programs.
About 20 percent of U.S. children and adolescents (15 million), ages 9 to 17, have diagnosable psychiatric disorders (MECA, 1996, the Surgeon General, 1999). "There is a dearth of child psychiatrists…… Furthermore, many barriers remain that prevent children, teenagers, and theirparents from seeking help from the small number of specially trained professionals…… Thisplaces a burden on pediatricians, family physicians, and other gatekeepers to identify children for referral and treatment decisions." (Mental Health: A Report of the Surgeon General, 1999). The population of children and adolescents under age 18 is projected to grow by more than 40 percent in the next 50 years from the current 70 million to more than 100 million by 2050 (U.S. Bureau of the Census, 1999).
The number of older people in the U.S. has increased tenfold since 1900. Today, an estimated 35 million people, 13 percent of the population, are age 65 and older. By 2030, 20 percent of Americans, about 70 million, will have passed their sixty-fifth birthday. The population age 85 and above is currently the fastest growing segment of the older population; its growth is particularly important for anticipating health care and assistance needs, because these individuals tend to be in poorer health and require more services than people below age 85.
The global population is aging at a rate unprecedented in history. In the U.S., the population age 65 and older is expected to double by 2030. The Forum developed the report "Older Americans 2000: Key Indicators of Well-Being" to regularly track trends as society and individuals look for ways to address the aging boom. Today's report, which brings together information from more than a dozen national data sources for the first time, will serve as a baseline for future updates.
Americans age 65 and older are an important and growing segment of our population. While many federal agencies provide data on this diverse population, it is sometimes difficult to understand how this group is faring. For the first time, the federal statistical system has come together to provide a unified picture of the overall health and well-being of older Americans.
—Katherine K. Wallman, Chief Statistician, U.S. Office of Management and Budget
As a Registered Nurse and Health Psychologist, Rolanda K. Walker is equipped with advanced training and information about the interaction of psychological and medical conditions (or psychomedical disorders). This includes information about psychological difficulties that can be caused by medical conditions, as well as psychological factors which can complicate or delay recovery from medical conditions. This is the kind of expertise that will stimulate further thought about the assessment and treatment of patients with psychomedical disorders. This is the expertise that will give Juniper Counseling Center a cutting edge over their competition.
JCC will focus on servicing Washtenaw County and the surrounding areas. The three population segments will be individuals, families, and couples. The target customer is usually a person or persons with some type of behavioral dysfunction.
We start with a critical competitive edge: there is no competitor we know of that can claim anywhere near as much specific expertise on the problems and opportunities of psychological treatment as JCC. Our positioning on this point is very hard to match, so we must maintain our focus in our strategy, marketing and business development, and fulfillment. We should be aware that the tendency to dilute this expertise with more generalized counseling work could weaken the importance of our competitive edge.
Also, our potential competitor does not make home visits. Our staff is prepared to take our services to our clients. Older citizens many times are unable to leave their home for reasons such as lack of transportation, limited mobility, fear of driving, and issues of personal safety, to name a few. We will provide a holistic approach to total wellness by including intensive medical education pertaining to all medical diagnosis and treatments.
Prices will vary according to a person's insurance coverage and their ability to pay. Generally the cost of service averages about $75.00 per one-hour session. There will be one group session with 10 clients at $30 per client for the length of 52 weeks.
Sales in our business is client service. It is repeat business. One doesn't sell a session, one develops a treatment plan that works for the client.
We expect to see at least 15 clients per day. Dr. Walker will consult with 5 clients at an average of $75 per session, and each of her therapists will consult with 5 clients at an average of $75 per session. There will be at least one ongoing group session per week, averaging 10 clients at $30 per client, running for 52 weeks.
We expect to make enough money to expand the programs that Dr. Walker will implement in order to reach all disenfranchised individuals in the surrounding area.
We expect sales to increase as our staff and referral base increase. The following table gives a run-down on forecasted sales.
Sales | FY2002 | FY2003 | FY2004 |
Therapist/Counseling Sessions | $292,500 | $292,500 | $292,500 |
Medical/Mental Health Group Sessions | $15,600 | $15,600 | $15,600 |
Total Sales | $308,100 | $308,100 | $308,100 |
Direct Cost of Sales | |||
Therapist/Counseling Sessions | $0 | $0 | $0 |
Medical/Mental Health Group Sessions | $0 | $0 | $0 |
Subtotal Cost of Sales | $0 | $0 | $0 |
JCC's staff has an accumulated 75 years plus in the Health Care industry related to experience. All are well versed in the evolution of the Health Care industry and share a vision for the successful positioning of Juniper Counseling Center within the Health Care Industry.
Our professional staff come to you with many years of experience, compassion, sensitivity to cultural values which affect the treatment outcome, and a strong desire to make life the best that it can be for all of its citizens.
Our management team consists of founder Rolanda K. Walker (RN, MSW, ACSW, Ph.D.), who has worked in the Health Care arena for over 20 years as a Registered Nurse/Health Educator and Social Worker for the last 5 years. Dr. Walker is a graduate from Wayne State University as a Health Educator and is also graduate from University of Detroit Mercy's MSW program. She is currently finishing up her Ph.D in Health Psychology from the University of Michigan-Ann Arbor.
Our professional support team will consist of of three registered nurses who will provide health education through medical seminars, groups, and individual counseling.
The following table summarizes our personnel expenditures for the first three years. We believe this plan is a compromise between fairness and expedience and meets the commitment of our mission statement. A professional staff of three RNs, 3-4 Therapists, Office Manager, Billing Clerk, Payroll Manager, Accountant, and Cleaning Crew will be assembled. These individuals will provide health education through seminars, groups, and individual counseling.
All the therapists will be paid 50-50. This means that for all counseling services provided, the therapist will be paid one-half of the amount the insurance company pays. For example, if a insurance company pays $75.00 per session, the therapist will be paid $37.50 per session.
Personnel Plan | FY2002 | FY2003 | FY2004 |
3 Therapists | $146,252 | $146,252 | $146,252 |
3 Nurses | $5,200 | $5,200 | $5,200 |
Office Manager | $21,840 | $21,840 | $21,840 |
Billing Clerk | $3,744 | $3,744 | $3,744 |
Payroll Manager | $4,160 | $4,160 | $4,160 |
Accountant | $2,500 | $2,500 | $2,500 |
Cleaning Person | $1,952 | $1,952 | $1,952 |
Other | $0 | $0 | $0 |
Total Payroll | $185,648 | $185,648 | $185,648 |
Total Headcount | 11 | 11 | 11 |
Payroll Burden | $27,847 | $27,847 | $27,847 |
Total Payroll Expenditures | $213,494 | $213,494 | $213,494 |
The financial plan is for rapid, but controlled growth. Initial capitalization is pegged at 150K with cash streaming in from referrals over a period of six months. We plan to increase our clientele and cashflow through networking.
Important Assumptions | |||
General Assumptions | FY2002 | FY2003 | FY2004 |
Short-term Interest Rate % | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate % | 10.00% | 10.00% | 10.00% |
Payment Days Estimator | 30 | 30 | 30 |
Collection Days Estimator | 14 | 14 | 14 |
Inventory Turnover Estimator | 6.00 | 6.00 | 6.00 |
Tax Rate % | 25.00% | 25.00% | 25.00% |
Expenses in Cash % | 10.00% | 10.00% | 10.00% |
Sales on Credit % | 75.00% | 75.00% | 75.00% |
Personnel Burden % | 15.00% | 15.00% | 15.00% |
The following table summarizes our break-even analysis. With approximate fixed cost of $2000 per month at the outset (a bare minimum), we need to bill $4000 to cover our costs. We really don't expect to reach break-even until a few months into the business operation.
Break-even Analysis: | |
Monthly Units Break-even | 53 |
Monthly Sales Break-even | $4,000 |
Assumptions: | |
Average Per-Unit Revenue | $75.00 |
Average Per-Unit Variable Cost | $37.50 |
Estimated Monthly Fixed Cost | $2,000 |
Our projected profit and loss is shown in the following table, with a net sales of more than $40,000 the first year to more than $60,000 through the third, and profits almost negligible for the start-up phase of this business.
Detailed monthly projections are included in the appendices.
Profit and Loss (Income Statement) | FY2002 | FY2003 | FY2004 |
Sales | $308,100 | $308,100 | $308,100 |
Direct Cost of Sales | $0 | $0 | $0 |
Production Payroll | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
Total Cost of Sales | $0 | $0 | $0 |
Gross Margin | $308,100 | $308,100 | $308,100 |
Gross Margin % | 100.00% | 100.00% | 100.00% |
Operating expenses: | |||
Sales and Marketing Expenses | |||
Sales and Marketing Payroll | $0 | $0 | $0 |
Advertising/Promotion | $900 | $450 | $450 |
Miscellaneous | $0 | $0 | $0 |
Total Sales and Marketing Expenses | $0 | $0 | $0 |
Sales and Marketing % | 0.00% | 0.00% | 0.00% |
General and Administrative Expenses | FY2002 | FY2003 | FY2004 |
General and Administrative Payroll | $0 | $0 | $0 |
Payroll Expense | $185,648 | $185,648 | $185,648 |
Payroll Burden | $27,847 | $27,847 | $27,847 |
Depreciation | $0 | $0 | $0 |
Utilities | $1,500 | $1,500 | $1,500 |
Insurance | $600 | $600 | $600 |
Rent | $12,000 | $12,000 | $12,000 |
Total General & Administrative Expenses | $0 | $0 | $0 |
General and Administrative % | 0.00% | 0.00% | 0.00% |
Other Expenses | |||
Other Payroll | $0 | $0 | $0 |
Telephone | $1,380 | $1,380 | $1,380 |
Total Other Expenses | $0 | $0 | $0 |
Other % | 0.00% | 0.00% | 0.00% |
Total Operating Expenses | $229,874 | $229,425 | $229,425 |
Profit Before Interest and Taxes | $78,226 | $78,675 | $78,675 |
Interest Expense Short-term | $2,094 | $2,094 | $2,094 |
Interest Expense Long-term | $0 | $0 | $0 |
Taxes Incurred | $19,033 | $19,145 | $19,145 |
Extraordinary Items | $0 | $0 | $0 |
Net Profit | $57,099 | $57,436 | $57,436 |
Net Profit/Sales | 18.53% | 18.64% | 18.64% |
Cash flow projections are the most critical indicator of our business's success. Attainment of the targeted population participation will ensure the accumulation of required cash to execute the running of the organization. The annual cash flow figures are included here and the more important detailed monthly numbers are included in the appendices.
Projected Cash Flow | FY2002 | FY2003 | FY2004 |
Net Profit | $57,099 | $57,436 | $57,436 |
Plus: | |||
Depreciation | $0 | $0 | $0 |
Change in Accounts Payable | $2,618 | $50 | ($4) |
Current Borrowing (repayment) | $0 | $0 | $0 |
Increase (decrease) Other Liabilities | $0 | $0 | $0 |
Long-term Borrowing (repayment) | $0 | $0 | $0 |
Capital Input | $0 | $0 | $0 |
Subtotal | $59,717 | $57,486 | $57,432 |
Less: | |||
Change in Accounts Receivable | $8,295 | $0 | $0 |
Change in Inventory | $0 | $0 | $0 |
Change in Other Short-term Assets | $0 | $0 | $0 |
Capital Expenditure | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal | $8,295 | $0 | $0 |
Net Cash Flow | $51,422 | $57,486 | $57,432 |
Cash Balance | $57,422 | $114,908 | $172,340 |
The balance sheet in the following chart shows managed but sufficient growth of net worth and a sufficiently healthy financial position. The monthly estimates are included in the appendices.
Short-term Assets | FY2002 | FY2003 | FY2004 |
Cash | $57,422 | $114,908 | $172,340 |
Accounts Receivable | $8,295 | $8,295 | $8,295 |
Inventory | $0 | $0 | $0 |
Other Short-term Assets | $0 | $0 | $0 |
Total Short-term Assets | $65,717 | $123,203 | $180,635 |
Long-term Assets | |||
Capital Assets | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 |
Total Assets | $65,717 | $123,203 | $180,635 |
Liabilities and Capital | |||
Accounts Payable | $2,618 | $2,668 | $2,664 |
Short-term Notes | $20,935 | $20,935 | $20,935 |
Other Short-term Liabilities | $0 | $0 | $0 |
Subtotal Short-term Liabilities | $23,553 | $23,603 | $23,599 |
Long-term Liabilities | $0 | $0 | $0 |
Total Liabilities | $23,553 | $23,603 | $23,599 |
Paid in Capital | $6,000 | $6,000 | $6,000 |
Retained Earnings | ($20,935) | $36,164 | $93,600 |
Earnings | $57,099 | $57,436 | $57,436 |
Total Capital | $42,164 | $99,600 | $157,036 |
Total Liabilities and Capital | $65,717 | $123,203 | $180,635 |
Net Worth | $42,164 | $99,600 | $157,036 |
Sales | Apr | May | Jun | Jul | Aug | Sep |
Therapist/Counseling Sessions | $22,500 | $28,125 | $22,500 | $22,500 | $22,500 | $22,500 |
Medical/Mental Health Group Sessions | $1,200 | $1,500 | $1,200 | $1,200 | $1,200 | $1,200 |
Total Sales | $23,700 | $29,625 | $23,700 | $23,700 | $23,700 | $23,700 |
Direct Cost of Sales | ||||||
Therapist/Counseling Sessions | $0 | $0 | $0 | $0 | $0 | $0 |
Medical/Mental Health Group Sessions | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 |
Personnel | Apr | May | Jun | Jul | Aug | Sep |
3 Therapists | $11,250 | $14,063 | $11,250 | $11,250 | $11,250 | $11,250 |
3 Nurses | $400 | $500 | $400 | $400 | $400 | $400 |
Office Manager | $1,680 | $2,100 | $1,680 | $1,680 | $1,680 | $1,680 |
Billing Clerk | $288 | $360 | $288 | $288 | $288 | $288 |
Payroll Manager | $320 | $400 | $320 | $320 | $320 | $320 |
Accountant | $200 | $225 | $200 | $200 | $200 | $200 |
Cleaning Person | $150 | $188 | $150 | $150 | $150 | $150 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Total Payroll | $14,288 | $17,835 | $14,288 | $14,288 | $14,288 | $14,288 |
Total Headcount | 11 | 11 | 11 | 11 | 11 | 11 |
Payroll Burden | $2,143 | $2,675 | $2,143 | $2,143 | $2,143 | $2,143 |
Total Payroll Expenditures | $16,431 | $20,510 | $16,431 | $16,431 | $16,431 | $16,431 |
Apr | May | Jun | Jul | Aug | Sep | |
Short-term Interest Rate % | 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% |
Payment Days Estimator | 30 | 30 | 30 | 30 | 30 | 30 |
Collection Days Estimator | 14 | 14 | 14 | 14 | 14 | 14 |
Inventory Turnover Estimator | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 |
Tax Rate % | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% |
Expenses in Cash % | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
Sales on Credit % | 75.00% | 75.00% | 75.00% | 75.00% | 75.00% | 75.00% |
Personnel Burden % | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% |
Oct | Nov | Dec | Jan | Feb | Mar | FY2002 | FY2003 | FY2004 |
$28,125 | $22,500 | $28,125 | $28,125 | $22,500 | $22,500 | $292,500 | $292,500 | $292,500 |
$1,500 | $1,200 | $1,500 | $1,500 | $1,200 | $1,200 | $15,600 | $15,600 | $15,600 |
$29,625 | $23,700 | $29,625 | $29,625 | $23,700 | $23,700 | $308,100 | $308,100 | $308,100 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Oct | Nov | Dec | Jan | Feb | Mar | FY2002 | FY2003 | FY2004 |
$14,063 | $11,250 | $14,063 | $14,063 | $11,250 | $11,250 | $146,252 | $146,252 | $146,252 |
$500 | $400 | $500 | $500 | $400 | $400 | $5,200 | $5,200 | $5,200 |
$2,100 | $1,680 | $2,100 | $2,100 | $1,680 | $1,680 | $21,840 | $21,840 | $21,840 |
$360 | $288 | $360 | $360 | $288 | $288 | $3,744 | $3,744 | $3,744 |
$400 | $320 | $400 | $400 | $320 | $320 | $4,160 | $4,160 | $4,160 |
$225 | $200 | $225 | $225 | $200 | $200 | $2,500 | $2,500 | $2,500 |
$188 | $150 | $188 | $188 | $150 | $150 | $1,952 | $1,952 | $1,952 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$17,836 | $14,288 | $17,836 | $17,836 | $14,288 | $14,288 | $185,648 | $185,648 | $185,648 |
11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 |
$2,675 | $2,143 | $2,675 | $2,675 | $2,143 | $2,143 | $27,847 | $27,847 | $27,847 |
$20,511 | $16,431 | $20,511 | $20,511 | $16,431 | $16,431 | $213,495 | $213,495 | $213,495 |
Oct | Nov | Dec | Jan | Feb | Mar | FY2002 | FY2003 | FY2004 |
10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 |
14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 |
6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 | 6.00 |
25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% |
10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% |
75.00% | 75.00% | 75.00% | 75.00% | 75.00% | 75.00% | 75.00% | 75.00% | 75.00% |
15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% | 15.00% |
Apr | May | Jun | Jul | Aug | Sep | |
Sales | $23,700 | $29,625 | $23,700 | $23,700 | $23,700 | $23,700 |
Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 |
Production Payroll | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 |
Gross Margin | $23,700 | $29,625 | $23,700 | $23,700 | $23,700 | $23,700 |
Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
Operating Expenses: | ||||||
Sales and Marketing Expenses | ||||||
Sales and Marketing Payroll | $0 | $0 | $0 | $0 | $0 | $0 |
Advertising/Promotion | $75 | $75 | $75 | $75 | $75 | $75 |
Miscellaneous | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales and Marketing Expenses | $0 | $0 | $0 | $0 | $0 | $0 |
Sales and Marketing % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
General and Administrative Expenses | ||||||
General and Administrative Payroll | $0 | $0 | $0 | $0 | $0 | $0 |
Payroll Expense | $14,288 | $17,835 | $14,288 | $14,288 | $14,288 | $14,288 |
Payroll Burden | $2,143 | $2,675 | $2,143 | $2,143 | $2,143 | $2,143 |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 |
Utilities | $125 | $125 | $125 | $125 | $125 | $125 |
Insurance | $0 | $100 | $0 | $100 | $0 | $100 |
Rent | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 |
General and Administrative % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Other Expenses | ||||||
Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 |
Telephone | $115 | $115 | $115 | $115 | $115 | $115 |
Total Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 |
Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Total Operating Expenses | $17,746 | $21,925 | $17,746 | $17,846 | $17,746 | $17,846 |
Profit Before Interest and Taxes | $5,954 | $7,700 | $5,954 | $5,854 | $5,954 | $5,854 |
Interest Expense Short-term | $174 | $174 | $174 | $174 | $174 | $174 |
Interest Expense Long-term | $0 | $0 | $0 | $0 | $0 | $0 |
Taxes Incurred | $1,445 | $1,881 | $1,445 | $1,420 | $1,445 | $1,420 |
Extraordinary Items | $0 | $0 | $0 | $0 | $0 | $0 |
Net Profit | $4,335 | $5,644 | $4,335 | $4,260 | $4,335 | $4,260 |
Net Profit/Sales | 18.29% | 19.05% | 18.29% | 17.97% | 18.29% | 17.97% |
Oct | Nov | Dec | Jan | Feb | Mar | FY2002 | FY2003 | FY2004 |
$29,625 | $23,700 | $29,625 | $29,625 | $23,700 | $23,700 | $308,100 | $308,100 | $308,100 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$29,625 | $23,700 | $29,625 | $29,625 | $23,700 | $23,700 | $308,100 | $308,100 | $308,100 |
100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$75 | $75 | $75 | $75 | $75 | $75 | $900 | $450 | $450 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$17,836 | $14,288 | $17,836 | $17,836 | $14,288 | $14,288 | $185,648 | $185,648 | $185,648 |
$2,675 | $2,143 | $2,675 | $2,675 | $2,143 | $2,143 | $27,847 | $27,847 | $27,847 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$125 | $125 | $125 | $125 | $125 | $125 | $1,500 | $1,500 | $1,500 |
$0 | $100 | $0 | $100 | $0 | $100 | $600 | $600 | $600 |
$1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $12,000 | $12,000 | $12,000 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$115 | $115 | $115 | $115 | $115 | $115 | $1,380 | $1,380 | $1,380 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
$21,826 | $17,846 | $21,826 | $21,926 | $17,746 | $17,846 | $229,874 | $229,425 | $229,425 |
$7,799 | $5,854 | $7,799 | $7,699 | $5,954 | $5,854 | $78,226 | $78,675 | $78,675 |
$174 | $174 | $174 | $174 | $174 | $174 | $2,094 | $2,094 | $2,094 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$1,906 | $1,420 | $1,906 | $1,881 | $1,445 | $1,420 | $19,033 | $19,145 | $19,145 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$5,718 | $4,260 | $5,718 | $5,643 | $4,335 | $4,260 | $57,099 | $57,436 | $57,436 |
19.30% | 17.97% | 19.30% | 19.05% | 18.29% | 17.97% | 18.53% | 18.64% | 18.64% |
Apr | May | Jun | Jul | Aug | Sep | |
Net Profit | $4,335 | $5,644 | $4,335 | $4,260 | $4,335 | $4,260 |
Plus: | ||||||
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 |
Change in Accounts Payable | $2,553 | $467 | ($467) | $65 | ($65) | $65 |
Current Borrowing (repayment) | $0 | $0 | $0 | $0 | $0 | $0 |
Increase (decrease) Other Liabilities | $0 | $0 | $0 | $0 | $0 | $0 |
Long-term Borrowing (repayment) | $0 | $0 | $0 | $0 | $0 | $0 |
Capital Input | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal | $6,887 | $6,111 | $3,868 | $4,325 | $4,269 | $4,325 |
Less: | ||||||
Change in Accounts Receivable | $8,181 | $2,045 | ($2,045) | $114 | $0 | $0 |
Change in Inventory | $0 | $0 | $0 | $0 | $0 | $0 |
Change in Other Short-term Assets | $0 | $0 | $0 | $0 | $0 | $0 |
Capital Expenditure | $0 | $0 | $0 | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal | $8,181 | $2,045 | ($2,045) | $114 | $0 | $0 |
Net Cash Flow | ($1,294) | $4,065 | $5,913 | $4,211 | $4,269 | $4,325 |
Cash Balance | $4,706 | $8,771 | $14,684 | $18,896 | $23,165 | $27,490 |
Assets | ||||||
Short-term Assets | Apr | May | Jun | Jul | Aug | Sep |
Cash | $4,706 | $8,771 | $14,684 | $18,896 | $23,165 | $27,490 |
Accounts Receivable | $8,181 | $10,227 | $8,181 | $8,295 | $8,295 | $8,295 |
Inventory | $0 | $0 | $0 | $0 | $0 | $0 |
Other Short-term Assets | $0 | $0 | $0 | $0 | $0 | $0 |
Total Short-term Assets | $12,887 | $18,998 | $22,866 | $27,191 | $31,460 | $35,785 |
Long-term Assets | ||||||
Capital Assets | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $12,887 | $18,998 | $22,866 | $27,191 | $31,460 | $35,785 |
Liabilities and Capital | ||||||
Accounts Payable | $2,553 | $3,020 | $2,553 | $2,618 | $2,553 | $2,618 |
Short-term Notes | $20,935 | $20,935 | $20,935 | $20,935 | $20,935 | $20,935 |
Other Short-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Short-term Liabilities | $23,488 | $23,955 | $23,488 | $23,553 | $23,488 | $23,553 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $23,488 | $23,955 | $23,488 | $23,553 | $23,488 | $23,553 |
Paid in Capital | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Retained Earnings | ($20,935) | ($20,935) | ($20,935) | ($20,935) | ($20,935) | ($20,935) |
Earnings | $4,335 | $9,978 | $14,313 | $18,572 | $22,907 | $27,167 |
Total Capital | ($10,600) | ($4,957) | ($622) | $3,637 | $7,972 | $12,232 |
Total Liabilities and Capital | $12,887 | $18,998 | $22,866 | $27,191 | $31,460 | $35,785 |
Net Worth | ($10,600) | ($4,957) | ($622) | $3,637 | $7,972 | $12,232 |
Oct | Nov | Dec | Jan | Feb | Mar | FY2002 | FY2003 | FY2004 |
$5,718 | $4,260 | $5,718 | $5,643 | $4,335 | $4,260 | $57,099 | $57,436 | $57,436 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$336 | ($336) | $336 | $65 | ($466) | $65 | $2,618 | $50 | ($4) |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$6,054 | $3,924 | $6,054 | $5,708 | $3,868 | $4,325 | $59,717 | $57,486 | $57,432 |
$2,074 | ($2,074) | $2,074 | $0 | ($2,074) | $0 | $8,295 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$2,074 | ($2,074) | $2,074 | $0 | ($2,074) | $0 | $8,295 | $0 | $0 |
$3,980 | $5,997 | $3,980 | $5,708 | $5,942 | $4,325 | $51,422 | $57,486 | $57,432 |
$31,470 | $37,467 | $41,448 | $47,156 | $53,098 | $57,422 | $57,422 | $114,908 | $172,340 |
Oct | Nov | Dec | Jan | Feb | Mar | FY2002 | FY2003 | FY2004 |
$31,470 | $37,467 | $41,448 | $47,156 | $53,098 | $57,422 | $57,422 | $114,908 | $172,340 |
$10,369 | $8,295 | $10,369 | $10,369 | $8,295 | $8,295 | $8,295 | $8,295 | $8,295 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$41,839 | $45,762 | $51,816 | $57,525 | $61,393 | $65,717 | $65,717 | $123,203 | $180,635 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$41,839 | $45,762 | $51,816 | $57,525 | $61,393 | $65,717 | $65,717 | $123,203 | $180,635 |
$2,954 | $2,618 | $2,954 | $3,019 | $2,553 | $2,618 | $2,618 | $2,668 | $2,664 |
$20,935 | $20,935 | $20,935 | $20,935 | $20,935 | $20,935 | $20,935 | $20,935 | $20,935 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$23,889 | $23,553 | $23,889 | $23,954 | $23,488 | $23,553 | $23,553 | $23,603 | $23,599 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$23,889 | $23,553 | $23,889 | $23,954 | $23,488 | $23,553 | $23,553 | $23,603 | $23,599 |
$6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
($20,935) | ($20,935) | ($20,935) | ($20,935) | ($20,935) | ($20,935) | ($20,935) | $36,164 | $93,600 |
$32,885 | $37,144 | $42,862 | $48,505 | $52,840 | $57,099 | $57,099 | $57,436 | $57,436 |
$17,950 | $22,209 | $27,927 | $33,570 | $37,905 | $42,164 | $42,164 | $99,600 | $157,036 |
$41,839 | $45,762 | $51,816 | $57,525 | $61,393 | $65,717 | $65,717 | $123,203 | $180,635 |
$17,950 | $22,209 | $27,927 | $33,570 | $37,905 | $42,164 | $42,164 | $99,600 | $157,036 |