Counseling Center



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.


EXECUTIVE SUMMARY

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.

Objectives

Our objectives are to:

Mission

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.

Keys to Success

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:

COMPANY SUMMARY

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.

Company Ownership

The founder and owner is Rolanda K. Walker, R.N., MSW, Ph.D. It is a privately owned corporation.

Company Location and Facilities

JCC will be located at 1600 West Main Street, Ann Arbor, Michigan.

Business Operations

The process of the JCC business operations is as follows:

Start-up Summary

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.

Counseling Center

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

Counseling Center

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

Counseling Center

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

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:

MARKET ANALYSIS SUMMARY

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.

Target Market Segment Strategy

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.

Teen Mothers

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.

Troubled Children/Youth

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."

Prevalence and Magnitude of Child and Adolescent Psychiatric Problems

Senior Citizens Health Status

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.

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.

Health Status:

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.

Industry Analysis and Trends

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

Competition

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.

STRATEGY & IMPLEMENTATION SUMMARY

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.

Competitive Edge

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.

Price of Service

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 Strategy

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.

Sales Forecast

We expect sales to increase as our staff and referral base increase. The following table gives a run-down on forecasted sales.

Counseling Center

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

MANAGEMENT SUMMARY

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.

Personnel Plan

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.

Counseling Center

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

FINANCIAL PLAN

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.

Counseling Center

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%

Break-even Analysis

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.

Counseling Center

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

Projected Profit and Loss

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.

Counseling Center

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%

Counseling Center

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%

Projected Cash Flow

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.

Counseling Center

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

Projected Balance Sheet

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.

Assets

Counseling Center

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

APPENDIX

Sales Forecast

Counseling Center

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 Plan

Counseling Center

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

General Assumptions

Counseling Center

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%

Counseling Center

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%

Profit and Loss (Income Statement)

Counseling Center

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%

Counseling Center

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%

Projected Cash Flow

Counseling Center

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

Projected Balance Sheet

Counseling Center

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

Counseling Center

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


Other articles you might like:

Follow City-Data.com Founder
on our Forum or Twitter

User Contributions:

1
Latrina
Report this comment as inappropriate
Jul 16, 2016 @ 2:14 pm
Great Reference that could help with starting a business plan.

Comment about this article, ask questions, or add new information about this topic: