Don't bother with copy and paste.

Get this complete sample business plan as a free text document.

Download for free

Day Care icon Child Day Care Services Business Plan

Start your plan

Kid's Community College

Executive Summary

Kid’s Community College® aims to prepare its students to excel as young leaders of tomorrow by combining an exclusive collegiate-based curriculum tailored specifically for children with enhanced, first class child care services. Unlike our competitors, we offer advanced technology programs, after-school tutoring, and activities such as arts and crafts, dance, theatre and gymnastics, all in one location.

Kid’s Community College is a privately held corporation run by its owner, Timothy Bernard Kilpatrick, Sr. Mr. Kilpatrick has 17 years of Executive Management (VP) and Budgeting experience, and extensive experience with budgeting methodologies and strategic planning, including the Balanced Scorecard approach. His advanced degree (and interest) in computer science is the driving force behind our technology component. He will be supported in daily operations by an industry consultant, a campus director, and a VP of educational operations, all with extensive experience in child care fields.

With inflation continuing to rise each year, the typical American family now requires dual or supplemental incomes. This trend has created a need for quality child care services. The population growth rate in the Riverview area of Hillsborough County is now over 14.6%, leading us to anticipate expanding market potential for this industry in our local area. Price, service, certification and reputation are critical success factors in the child care services industry. Kid’s Community College® will compete well in our market by offering competitive prices, high-quality child care services, and leading-edge educational programs with certified, college-educated instructors, and by maintaining an excellent reputation with parents and the community we serve.

This is a daycare business plan for Kid’s Community College®, which will focus on two subdivisions: ‘Lake St. Charles’ and ‘The Villages of Lake St. Charles,’ which are new upscale community developments within a 2 square mile radius, boasting over 900 new homes. Our target customers are dual-income, middle-class families who value the quality of education and child care we provide for their children, ages 4 months to 12 years.

We will open for business starting with an initial enrollment of 13 students. We project healthy revenues by the end of the first year, and expect to nearly triple that by the end of Year 3. Our biggest operating expenses will be compensation at industry standard rates for our highly-qualified personnel, and rent on our facilities, improved for our purposes during the start-up period. We would like to grow into four campuses, eventually, but growth is planned conservatively, to be financed from existing cash flow as we go. We anticipate a net profit beginning in our second year.

To these ends, we are putting significant investment in the business, and are seeking a matching amount in the form of an SBA loan.

Child day care services business plan, executive summary chart image

Mission

“Some of the best years in life are the time spent as a child and later our collegiate years…” As working adults in a fast paced society, we sometimes forget just how precious and  fleeting those years are.

With that in mind, imagine an alternative to traditional infant, day and after school care that not only met your child care needs, but also provided an activity based learning environment that mirrors those used at colleges, universities and vocational centers around the nation.  A college community of professional care givers with the credentials to not only enhance your child’s early social and motor skills, but to also teach them advanced studies in the arts and sciences found at institutions of higher learning.  A collegiate-based curriculum tailored specifically for children, taught in a fun, nurturing care giving environment.

Now imagine this at a cost less than that of the combination of conventional day care and specific interest based children programs.

Kid’s Community College® is a start-up comprehensive community college exclusively for kids ages 4 months to 5 years and 1st through 5th grades.  The College dedicates its efforts and resources toward ensuring top-rated care giving services coupled with a high-quality activity based learning environment tailored for children in these age groups.  The College will respond to the needs of its parents and students with excellent care-giving and instruction, an advanced curriculum, flexible programs, local community involvement and business partnerships.

The College has a strong commitment to accessibility and diversity.  Its open door policy embraces all who desire to provide a better quality of care, preparedness and education for their children.  The College works to provide affordable, first-class care giving and education by providing a broad range of integrated programs and services and innovative learning approaches.

The College is committed to taking a leadership role in child care services, higher learning, community services and promoting cultural diversity.  Kid’s Community College® directs its activities towards student success.

Objectives

  1. Sales increasing to almost double first year sales by the end of Year 2.
  2. Maintain a high raw gross margin by the end of Year 1.
  3. Open second campus by the end of Year 1.
  4. Begin franchise effort by end of Year 3.

Keys to Success

The keys to success for KCC are:

  • Marketing: differentiating KCC’s care giving and educational services from traditional daycare offerings and interest activity programs.
  • Service quality: care giving and educational programs provided by degreed and certified educators, child care workers, tutors and subject matter industry professionals in a technologically advanced first-class collegiate environment.
  • Reputation: maintaining a highly regarded reputation for excellence in care giving, education and community involvement and being the employer of choice in our market for child care and educational talent.
  • Profitability: controlling costs and managing budgets in accordance with company goals, adhering to strategic business plans for growth and expansion and reinvesting in the business and its employees.

Company Summary

Kid’s Community College® – Lake St. Charles Campus will be located in Riverview, FL.  The College will employ six fundamentals that will serve as the driving force for the services offered:

  • Premier Care Giving Services
  • An Activity Based, Children Structured Collegiate Curriculum
  • Advanced Technology and Developmental Programs
  • Trademarked General and “Continuing” Education Mentoring and Tutoring 
  • Learning Services
  • Community Advancement and Involvement

The Lake St. Charles campus is a newly constructed, 3,600 square foot facility in the Lake St. Charles Medical Plaza and will be developed meeting strict KCC design standards, under close supervision of Hillsborough County child care Licensing.

Start-up Summary

The college founder and president, Mr. Kilpatrick, will oversee fiscal responsibility, employing an independent CPA for financial oversight.  A Campus Director will be hired to handle day-to-day operations of the facility and will work collaboratively with the silent partners and other campus personnel to ensure a successful business venture.

As reflected in the table below, the estimated start-up costs for KCC will be $39,450.  These costs will be financed solely by the owners’ personal cash funds and optional credit lines.  An anticipated $60,000 SBA guaranteed 5-year loan will be used as working capital.  Future expansion, growth and franchising strategy will be self-financed.

Child day care services business plan, company summary chart image

Start-up
Requirements
Start-up Expenses
Legal $1,000
Stationery $250
Brochures $500
Insurance $1,500
Rent $8,250
R&D $500
Consultants $1,000
Playground Equipment $3,500
Playground Prep $700
Playground Fence $3,000
Furnishings $7,500
Toys $3,000
Buildout $8,750
Total Start-up Expenses $39,450
Start-up Assets
Cash Required $65,550
Other Current Assets $14,130
Long-term Assets $0
Total Assets $79,680
Total Requirements $119,130
Start-up Funding
Start-up Expenses to Fund $39,450
Start-up Assets to Fund $79,680
Total Funding Required $119,130
Assets
Non-cash Assets from Start-up $14,130
Cash Requirements from Start-up $65,550
Additional Cash Raised $0
Cash Balance on Starting Date $65,550
Total Assets $79,680
Liabilities and Capital
Liabilities
Current Borrowing $0
Long-term Liabilities $60,000
Accounts Payable (Outstanding Bills) $0
Other Current Liabilities (interest-free) $0
Total Liabilities $60,000
Capital
Planned Investment
Owner – Kilpatrick Cash $45,000
Owner – Kilpatrick Credit Line $12,500
Other Assets Invested $1,630
Additional Investment Requirement $0
Total Planned Investment $59,130
Loss at Start-up (Start-up Expenses) ($39,450)
Total Capital $19,680
Total Capital and Liabilities $79,680
Total Funding $119,130

Brought to you by

Create a professional business plan

Using AI and step-by-step instructions

Create Your Plan

Secure funding

Validate ideas

Build a strategy

Company Locations and Facilities

Kid’s Community College® will begin with one location – a newly constructed 3,600 square foot campus in Riverview, FL located near the entrance of the upscale Lake St. Charles subdivision.  The campus is in the Lake St. Charles Medical Professional center and will boast separate halls for arts and crafts, theatre and dance, information technology, library and quiet study, tutoring, infant care and a cafeteria.  The play area will be adjacent to the campus and will be securely fenced and furnished with appropriate playground equipment and facilities. 

Three additional campuses are planned in the rural Tampa marketplace over the next four years.  Franchise start-ups will be offered in the Orlando, Miami and Jacksonville marketplace after 2 years of successful operation.

Company Ownership

Kid’s Community College® is a privately-held proprietorship owned in majority by its founder and president, Timothy Bernard Kilpatrick, Sr.  There are also two silent partners, neither of whom owns more than 10%, but will be active participants in daily operations, management decisions and consulting, though they do not own a financial stake in the company.

Once the operation reaches its anticipated growth and profitability goals, the college plans to franchise and will re-register as a limited liability company or as a corporation, whichever will better suit the future business needs. 

Services

Kid’s Community College® offers upscale child care services and an advanced collegiate based curriculum designed for kids ages 4 months to 5 years and 1st through 5th grades.  Normal operating hours will be 6:45am to 6:30pm, Monday through Friday – with observance of all major legal holidays.  Early drop-off service will be offered as needed. 

KCC exists to provide Premier child care services that are aimed at enhancing traditional day care methodologies and integrating extracurricular interests (such as arts and crafts, dance, theatre and gymnastics) into one comprehensive program.  Our activity based collegiate curriculum is specifically tailored for children and mirrors the arts and sciences taught at colleges, universities and vocational schools around the nation.  We offer state-of-the-art technology programs in leading-edge facilities which help prepare students for the technology age in which they live.  Our general and “continuing” education programs help mentor and tutor students through “main school” homework assignments and provide a base of understanding and interaction to ensure success in future educational endeavors.  Finally, our developmental programs reinforce basic social, listening, independence and motor skills and prepare students for future related interaction.

All of our learning and child care services employ technology, partnerships, professional services and other activities that support and promote higher learning.

In addition to the extensive services and curriculum offered, each campus will also offer weekend specialty classes for children and adults and planned family activities in the community it serves.  KCC will also offer children birthday party hosting services, providing great activities for kids and an easy experience for parents.  Activity instructors will be assigned for these events and will lead the activities, ensuring a memorable celebration. 

Service Description

Upon its opening, Kid’s Community College® will offer four basic services in the Lake St. Charles community:

  • Full-time Child Day Care
  • Part-time/After School Care (including drop-off and pick-up)
  • After School Tutoring
  • Drop-In Care

Prior to opening, the college will have a two-month enrollment drive.  Based on the market reaction to the drive, these services may be altered to meet the needs of the community.  The college will always remain nimble enough to respond to the needs of the community in which it serves.

Competitive Comparison

The child care industry as a whole is saturated.  However, based on US Census 2000 data, Hillsborough County Child Care Services provider listings and Hillsborough County building permit records, the city of Riverview, Florida itself is growing and has few licensed child care facilities.  Kid’s Community College® intends to fill this local market need.

The Lake St. Charles and ‘The Villages of Lake St. Charles’ subdivisions have 800 and 100 single family homes respectively. There are only two other child care facilities in the neighborhood. One is in the immediate area, a church based facility and the other is 2 miles away, a facility hosted by a local martial arts academy.  There are also three family child caregivers listed in the area, but none in the immediate community.  Kid’s Community College® will differentiate itself from its local competitors by offering an alternative to these traditional day care approaches. 

The Kid’s Community College® market strategy is based on providing an activity based learning environment that is used in many major colleges, universities and vocational centers around the nation. We will offer a community of professional caregivers with the credentials to not only enhance a child’s early social and motor skills, but to also teach them advanced studies in the arts and sciences found at institutions of higher learning.

Kid’s Community College® will be located in a new medical arts plaza, which has already shown a need and interest for child care services. The center currently has a pediatrics office and fitness center with clientele that has inquired about child care services. By forming collaborative partnerships with these businesses and becoming an active voice in the Lake St. Charles community, the college will position itself as the market share leader in child care services, development and educational offerings.

Sales Literature

A copy of the Kid’s Community College® informational brochure is attached in an appendix at the end of this document.

Fulfillment

The key fulfillment and delivery of services will be provided by the campus director, licensed campus instructors and staff workers. The real core value is the professional strength and industry expertise of the founder and silent partners, staff experience and certifications, education and hard work (in that order).

We will turn to qualified professionals for freelance back-up in tutoring and educational support, which will enhance the core values provided to the clients.

Technology

Since the company founder has an extensive Information Technology background, it’s only natural that Kid’s Community College® will employ and maintain the latest technology to enhance its curriculum, office management systems, payment processing and record keeping.

Future Services

Three additional campuses are planned in the rural Tampa marketplace over the next four years. Franchise start-ups will be offered in the Orlando, Miami and Jacksonville marketplace after 2 years of successful operation.

Market Analysis Summary

Kid’s Community College® offers services which are vitally important in today’s fast paced, dual-income world. As an increasing number of families have become dependent on two incomes, the need for quality child care has skyrocketed. According to Florida Business Statistics, 84.6% of licensed child care facilities succeed and make a profit in their 1st year of operation.  Nationally, this number is 66.7%. 

There is no doubt, in the Riverview, FL area, that there is room and a need for Kid’s Community College®.  Market demographics to support this statement can be found below.

Brought to you by

Create a professional business plan

Using AI and step-by-step instructions

Create Your Plan

Secure funding

Validate ideas

Build a strategy

Market Segmentation

Kid’s Community College® has a focus on meeting the local community need for child care services within the 10-mile radius of Riverview.  Students will be taken in flexibly on either a full-time or part-time basis.

Full-Time Working Couples

The college will establish a significantly large, full-time, regular client base in order to establish the healthy, consistent revenue base which will ensure stability of the business.  Customer and community relations are extremely important, as it is imperative to keep the parents pleased in order to keep their children in the college.

After School Care

Another large segment of the college’s business will be in the after school care market.  This client base will provide a higher profit for the college since instructor-to-student ratios are higher, and the students require more educational services, which are the primary focus of the college.  By offering tutoring, and advanced studies in technology, theatre, arts and sciences, the college will attract these profitable business clients, producing significant supplemental revenues.

Part-Time Workers/Drop-Ins

Part-time workers and Drop-Ins from the fitness center and locals businesses will comprise less than 1% of the revenues.  While this market is not a primary focus, sufficient flexibility to handle this market is important to the local ‘word-of-mouth’  marketing strategy.

Child day care services business plan, market analysis summary chart image

Market Analysis
Year 1 Year 2 Year 3 Year 4 Year 5
Potential Customers Growth CAGR
Under 5 Years 6% 2,665 2,825 2,995 3,175 3,366 6.01%
5 to 9 Years 6% 2,865 3,037 3,219 3,412 3,617 6.00%
10 to 12 Years 6% 2,771 2,937 3,113 3,300 3,498 6.00%
Total 6.00% 8,301 8,799 9,327 9,887 10,481 6.00%

Target Market Segment Strategy

The target market for Kid’s Community College® is full-time working couples. Referral marketing, direct-mail campaigns and community activity days will be the primary types of marketing strategies utilized. Maintaining and enhancing its reputation with families and in the community will be crucial in obtaining the planned market share growth of this target market.

Market Growth

According to US Census 2000 data, the population growth rate for Hillsborough county is approximately 2%, which is reflected in the market analysis summary. However, the Riverview area of Hillsborough County is experiencing a residential construction boom, yielding well over a 14.6% growth. This is supported by data obtained from the Hillsborough County Building Permits office and is included in the appendix of this plan. This suggests that more families continue to move into the Riverview area, thus becoming potential customers.

In our market analysis, we suggest a modest 6% yearly growth in the number of potential customers.

Market Needs

With inflation continuing to rise each year, the typical American family now requires dual or supplemental incomes. This trend has created a need for quality child care services. We do not see this model changing in the foreseeable future. In fact, based on the growth in the Riverview area, specifically the new Lake St. Charles and Village of Lake St. Charles communities, we expect the need to increase.

Currently there are more family caregivers than licensed child care facilities nationwide. However, this business model can’t keep up with the needs of the growing child care industry. In the family care giver paradigm, space is limited and quality of care is questionable – in many cases viewed as only slightly higher quality than babysitter services.

Service Business Analysis

Kid’s Community College® is in the child care services industry, which includes several models:

  1. Licensed Child Care Facilities: Business facilities that offer child daycare services.
  2. Family Child Care Homes: Individuals that offer child daycare services in their homes.
  3. Specific Interest Based Programs: Businesses that offer specialized instruction such as gymnastics, martial arts and athletics.
  4. Church Child Care Facilities: Religious organizations that offer child daycare services in their communities.

Competition and Buying Patterns

Price, service, certification and reputation are critical success factors in the child care services industry. Kid’s Community College® will compete well in our market by offering competitive prices, high-quality child care services, and leading-edge educational programs with certified, college-educated instructors, and by maintaining an excellent reputation with parents and the community in which we serve.

Main Competitors

  1. Catholic Church Day Care:
    • Strengths: Large church congregation. Already established in market. 
    • Weaknesses: May not appeal to customers of different religious beliefs. Unlicensed facility.  Non-accredited. 
  2. Martial Arts America – Kick Kare:
    • Strengths: Already established in area. Martial arts offering with child care services. 
    • Weaknesses: Location – outside of middle-income market. Non-educational offering.  Building condition – prone to constant flooding. 
  3. Family Child Care Homes:
    • Strengths: Established in market. “Personal” service. 
    • Weaknesses: Capacity – only allowed a certain number of children. Non-professional stigma. 

Business Participants

  1. Licensed Child Care Centers: Kids Kountry, Lapetite Academy, Mary Go Round Child Care Center and Bloomingdale Academy.  While these centers are within the 10-mile radius target area, none are inside a 5-mile radius of the Lake St. Charles community.  None of these facilities are nationally accredited. 
  2. Family Child Care Homes: Mindy Rumore FCCH and  Stacie Dawn Hamann FCCH. 
  3. Specific Interest Based Programs: Martial Arts America
  4. Church Child Care Facilities: Christian Day Academy (not licensed).

Strategy and Implementation Summary

Kid’s Community College® will focus on two subdivisions: ‘Lake St. Charles’ and ‘The Villages of Lake St. Charles,’ which are new upscale community developments within a 2 square mile radius and boast over 900 new homes. 

The target customers are dual income, middle-class families who value the quality of education and child care provided for their children ages 4 months to 12 years.

Value Proposition

Kid’s Community College’s® value proposition is quite clear and quite easily distinguished from others in the market. We offer uniquely premium child care services, as measured by the curriculum and activities offered, experience and educational level of the instructors, community involvement and community college theme. 

Competitive Edge

We start with a critical competitive edge: there is no competitor in our market that is offering our concept, quality of educational program and child care services. Our educational approach is unique and we have a resource with over 25 years of child care expertise and over 17 years of technology savvy. Our positioning on these points is very hard to match, but only if we maintain the focus in our strategy, marketing, business development, and fulfillment. We should be aware that the tendency to dilute this expertise with bargain shopping could weaken the importance of our competitive edge, but we must continue to bolster our value proposition.

Marketing Strategy

Marketing in the child care industry depends largely on reputation and referral. At Kid’s Community College® that reputation will start within our community bolstered by our involved commitment to those we serve. 

Promotion Strategy

We will depend on client referrals, community exposure and direct mail campaigns as our main way to reach new clients.  As we change strategies, however, we need to change the way we promote ourselves:

Brought to you by

Create a professional business plan

Using AI and step-by-step instructions

Create Your Plan

Secure funding

Validate ideas

Build a strategy

1.  Advertising–We’ll be developing our core positioning message: “A community college for kids!” to differentiate our service from the competition.  We will be using direct mail campaigns, pre-enrollment drives, and local community newspaper advertising to launch the initial campaign. 

2.  Sales Brochure–Our theme and curriculum will help sell the college to prospective clients. 

3.  Direct Mail–We will send quarterly direct mail campaigns to the housing developments in a 10-mile radius of the campus.  We will also offer monthly calendars for parents and the Lake St. Charles community, noting weekend family days and other open house approaches. 

4.  Community Involvement–We will be active in the Lake St. Charles community, sponsoring events at the community center for families and residents.

Marketing Programs

Catered open houses, parent survival days/nights, clubhouse pool parties and weekend movie matinees are but a few approaches we will utilize to reach out to our community.  We will also develop and maintain partnerships with local businesses that cater to the needs of children. 

Our pre-opening effort will include an application fee waiver, free children ID cards, T-shirts and a community block party sponsored and hosted by Kid’s Community College®.

Positioning Statement

For families who value the importance of higher education and quality child care services, Kid’s Community College® offers a great alternative to traditional child care services and specific interest based programs. Unlike those programs, KCC combines child care services with a modified collegiate level curriculum, just for kids!

Pricing Strategy

Kid’s Community College® must charge appropriately for the high-end, high-quality educational and care giving services we offer. Our revenue structure has to support our cost structure, so the salaries we pay to assure quality services must be balanced by the revenue we charge. 

We will be price competitive in the market we serve; however, we will not subscribe to the “low price leader” concept. The quality of our service will support the prices we charge.

Sales Strategy

Kid’s Community College® will sell its community college theme, services and offerings, separating itself from traditional daycare-only offerings.

We will be a one-stop shop for child care services, advanced learning and specialized program offerings.  We will also be active in the community, building a solid reputation with parents and the community.  By succeeding in these areas, we expect to begin seeing an operational net profit in month nine of the 1st year, while increasing enrollment by 32% monthly for the first 8 months and gradually thereafter, until our maximum allowed capacity is reached.

Sales Forecast

The following table and chart give a run-down on forecasted sales.  A detailed spreadsheet is also included in the appendix of this business plan. 

For the first eight months of operation, Kid’s Community College® has assumed a conservative enrollment due to the fact that school, aftercare and child care placement has already taken place for the school year and most parents will be comfortable with their current arrangements.  Consequently, we expect initial enrollment to be far less than anticipated future year levels. 

A sales increase of approximately 32% each month is expected until the start of the next school term, in August.  While this forecasted  increase seems large by industry standards, it is a good estimate based on initial enrollment.  Going into years 2 and 3, we expect that our presence will be known, convenience factor considered and we will then be a considered as a choice in August 2003.  In fiscal years 2004 and 2005, 80% and 90% of full enrollment is assumed respectively.

We expect to be open for business on January 1, 2003, starting with an initial enrollment of 13 students:

7 Full-time students at $115 each per week.  6 After-school students at $60 each per week and Drop-in revenue of approximately $100 per month. 

Child day care services business plan, strategy and implementation summary chart image

Child day care services business plan, strategy and implementation summary chart image

Sales Forecast
Year 1 Year 2 Year 3
Unit Sales
Full-time Couples 199 455 512
After School Care 141 220 248
Summer Camp 26 29 31
Part-time Workers/Drop-Ins 12 14 16
Total Unit Sales 378 718 807
Unit Prices Year 1 Year 2 Year 3
Full-time Couples $460.00 $460.00 $460.00
After School Care $240.00 $240.00 $240.00
Summer Camp $460.00 $460.00 $460.00
Part-time Workers/Drop-Ins $100.00 $100.00 $100.00
Sales
Full-time Couples $91,540 $209,300 $235,520
After School Care $33,840 $52,800 $59,400
Summer Camp $11,960 $13,340 $14,352
Part-time Workers/Drop-Ins $1,200 $1,380 $1,587
Total Sales $138,540 $276,820 $310,859
Direct Unit Costs Year 1 Year 2 Year 3
Full-time Couples $13.34 $13.82 $13.82
After School Care $4.56 $4.75 $4.75
Summer Camp $13.80 $13.80 $13.80
Part-time Workers/Drop-Ins $0.00 $0.00 $0.00
Direct Cost of Sales
Full-time Couples $2,655 $6,288 $7,076
After School Care $643 $1,045 $1,176
Summer Camp $359 $400 $431
Part-time Workers/Drop-Ins $0 $0 $0
Subtotal Direct Cost of Sales $3,656 $7,733 $8,682

Sales Programs

Sales programs will include incentives for obtaining quarterly financial and enrollment goals, probationary period completion, passing county inspections and maintaining perfect attendance. 

Customer service awards will be provided for those employees who best exemplify the mission of Kid’s Community College® and exceed customers’ expectations. 

Milestones

The accompanying table highlights important start-up milestones, with dates, completion status, responsible parties and budgets for each.  The milestone schedule indicates our emphasis on planning for implementation. 

What the table doesn’t show is the commitment behind it.  Our business plan includes complete provisions for plan-vs.-actual analysis, and we will hold monthly follow-up meetings to discuss the variance and course corrections. 

Child day care services business plan, strategy and implementation summary chart image

Milestones
Milestone Start Date End Date Budget Manager Department
Business Plan 8/1/2002 9/30/2002 $200 Tim Kilpatrick Department
Lease RFP 7/15/2002 7/30/2002 $0 Tim Kilpatrick Department
Site Selection 8/1/2002 9/15/2002 $0 Tim Kilpatrick Department
Architect Design 9/15/2002 10/1/2002 $0 Zimmer Department
Secure Additional Funding 10/1/2002 10/30/2002 $500 Tim Kilpatrick Department
Sign Lease 10/15/2002 10/30/2002 $4,500 Tim Kilpatrick Department
Personnel Plan 10/1/2002 10/30/2002 $0 Tim Kilpatrick Department
Curriculum Development 10/1/2002 12/31/2002 $500 Candice Harris Department
County Certification Req. 9/20/2002 12/31/2002 $100 Tim Kilpatrick Department
Licensing 12/1/2002 12/31/2002 $0 Tim Kilpatrick Department
Totals $5,800

Strategic Alliances

As mentioned previously, Kid’s Community College® will form professional alliances with Impact Fitness to offer Drop-In child care services while parents work out.  We will also partner with Family Pediatrics to provide referrals of their existing customers.  A discounted rate will be offered in both cases.

Web Plan Summary

The Kid’s Community College® website will be the virtual business card and portfolio for the college, as well as its online “home.”

It will showcase the campus, curriculum and activity calendar for the school.  It will also provide for an Internet background of the instructors, online projects posted by the students, the campus newsletter and online enrollment. 

The Kid’s Community College® website will be simple, yet classy and well designed, but at the same time, in keeping with the latest trends in user interface design.  A site that is too flashy, or tries to use too much of the latest technology can be over-done, and may not be supported by all browsers. 

The key to the website strategy will be presenting a very well designed and informative Web presence that will market the Kid’s Community College® image, service offerings and community commitment.

Website Marketing Strategy

The Kid’s Community College® website will embody the mission of the college.  It will not only offer visitors the opportunity to “look around” the campus, but it will give them a good idea of the level of quality and service they can come to expect from the college.

Mostly informative in nature, the website will be a digital representation of our physical self. 

Development Requirements

The Kid’s Community College® website will be developed by the college founder, Timothy B. Kilpatrick, Sr., who has over 17 years of Information Technology experience.  Formation Technologies will host the site.

The site will be developed using Macromedia Dreamweaver 4, which will allow for support outside of Mr. Kilpatrick’s involvement.  The initial maintenance of the site will be done by Mr. Kilpatrick. 

Management Summary

The opening management team of Kid’s Community College® will consist of the founder, a silent partner, a campus director and administrative assistant.

As the college grows, gradual investments in the instructional staff will be made over the next 3 years – beginning in June 2003 or as otherwise dictated by enrollment.

Organizational Structure

Kid’s Community College® depends on the founder, silent partner, Campus Director and VP of Education Operations for management in the following roles:

Management Team

Owner/President – Timothy B.  Kilpatrick, Sr.  The Owner/President will have overall fiscal responsibility, ensuring that the business is financially sound and attains its planned goals. 

  • 17 years Executive Management (VP) and Budgeting experience
  • Advanced degree in Computer Science
  • Proven leadership and employee development ability
  • Extensive experience with budgeting methodologies and strategic planning, including the Balanced Scorecard approach.

Industry Consultant – Carolyn Steverson.  The Industry Consultant will be relied upon for her industry expertise, providing valuable insight to rules, regulations and governmental programs that may benefit the college.

  • 25 Year owner of Fat Albert Day Care Center
  • Licensed child care facility owner
  • Vast knowledge of Hillsborough County Child Care Licensing requirements and government supplemental programs

Campus Director – Candice Harris.  The Campus Director will be responsible for daily operations, curriculum oversight and management of all instructors, caregivers and tutors.

  • B.S.  Degree in Education
  • 2 years facilities administration/support experience with the University of South Florida
  • 2+ years Regional Operations Manager
  • 5+ years managerial/supervisory experience
  • 3+ years grant writing, technical writing, workflow and process documentation experience

VP of Education Operations – Nitika Steverson-Kilpatrick

  • Collegiate-level Public Relations education
  • 5+ years customer service experience
  • 8+ years child care industry experience (her mother owns Fat Albert Daycare)
  • Extensive theatre and dance background

Management Team Gaps

The present team requires Child Care Development Associate credentials to support our value proposition and preparation for 2004 Florida child care requirements.  Currently, the Campus Director and Industry Consultant are the only members of the management team who have these credentials.

The Owner/President and VP of Education Operations will be enrolling in January 2003 to complete the six-month course required to obtain these credentials.  Education for these two can’t begin in this area until that time since it is a requirement that the college be open for business before the course work can begin.  Long-term, all full-time instructors will be required by the college (not the State) to obtain this credential.

Regarding financial administration, we will retain a strong CPA to help the owner guard cash flow.  While the owner is well versed in the worries of cash flow, he also has the sense to listen to reason and deal with constraints, as guided by the CPA.

Personnel Plan

The following table summarizes our personnel expenditures for the first three years, with compensation increasing from approximately $57K the first year to about $113K in the third.  We believe this plan is a fair compromise between fairness and expedience, and meets the commitment of our mission statement. 

The yearly figures in the second and third year are assumptions for the Lake St. Charles campus only.  The numbers reflect 100% enrollment, a full staff of instructors and a 5% payroll increase each year – which will include tuition reimbursement, pay increases, vacation pay, bonuses and state required certifications.

Personnel Plan
Year 1 Year 2 Year 3
Campus Director $23,877 $25,071 $26,324
F/T Instructors $21,760 $61,440 $64,512
P/T Instructors $11,400 $21,600 $22,680
Total People 5 8 8
Total Payroll $57,037 $108,111 $113,516

Financial Plan

  • Kid’s Community College® will finance growth mainly through cash flow.  It is recognized that this means the school will have to grow gradually into the planned four campuses. 
  • The most important factor in our case is enrollment.  We must stay focused on our enrollment plan and maintain budgeted enrollment levels. 
  • Adequate start-up capital is assumed, along with an SBA 5-year guaranteed loan.

Important Assumptions

The Kid’s Community College® financial plan depends on important assumptions, most of which are shown in the following table as annual assumptions.  The monthly assumptions are included in the appendices.  From the beginning, it is recognized that total enrollment is critical, which is a factor that must be influenced immediately.  Interest rates, tax rates, and personnel burden are based on conservative assumptions. 

The most important underlying assumption is that there is a strong need for the business in the Lake St. Charles community. 

General Assumptions
Year 1 Year 2 Year 3
Plan Month 1 2 3
Current Interest Rate 7.00% 7.00% 7.00%
Long-term Interest Rate 7.00% 7.00% 7.00%
Tax Rate 30.00% 30.00% 30.00%
Other 0 0 0

Key Financial Indicators

The following benchmark chart indicates the key financial indicators for the first three years.  We foresee a gradual growth in sales (enrollment) and operating expenses into the second and third year.

It is projected that the raw gross margin will remain stable for the first three years since expenses are relatively indirect in the service based course work industry.  Operating expenses increase gradually as enrollment increases.

Enrollment is very important.  We must maintain an average weekly enrollment of 34 students for fixed cost coverage. 

Child day care services business plan, financial plan chart image

Break-even Analysis

For the break-even analysis, start-up monthly running costs assumptions are shown in the the table below, including a three person payroll, rent, utilities and an estimation of other running costs.  Payroll, at median market averages, was presented previously in the Personnel table. 

Based on these assumptions, the chart below shows the enrollment of students per month needed to break-even.  This represents about 46% of our allowable monthly enrollment based on state and county course work guidelines.

Child day care services business plan, financial plan chart image

Break-even Analysis
Monthly Units Break-even 34
Monthly Revenue Break-even $12,350
Assumptions:
Average Per-Unit Revenue $366.51
Average Per-Unit Variable Cost $9.67
Estimated Monthly Fixed Cost $12,024

Projected Profit and Loss

Our projected profit and loss is shown on the following table, with sales increasing from the first year to the third. 

In years two and three, we are projecting full enrollment regarding cost of sales and gross margin.  The investment return in these years supports the goal of opening another campus at the end of the second year and begin the franchise offering by the end of the third year.  Profit from the additional campuses and income from franchising are not included in this business plan. 

The detailed monthly projections are included in the appendices. 

Child day care services business plan, financial plan chart image

Child day care services business plan, financial plan chart image

Child day care services business plan, financial plan chart image

Child day care services business plan, financial plan chart image

Pro Forma Profit and Loss
Year 1 Year 2 Year 3
Sales $138,540 $276,820 $310,859
Direct Cost of Sales $3,656 $7,733 $8,682
Hidden Row $0 $0 $0
Total Cost of Sales $3,656 $7,733 $8,682
Gross Margin $134,884 $269,087 $302,177
Gross Margin % 97.36% 97.21% 97.21%
Expenses
Payroll $57,037 $108,111 $113,516
Sales and Marketing and Other Expenses $2,200 $3,500 $3,500
Depreciation $0 $0 $0
Rent $58,800 $59,500 $60,000
Utilities $10,500 $10,500 $10,500
Insurance $7,200 $7,200 $7,200
Payroll Taxes $8,556 $16,217 $17,027
Other $0 $0 $0
Total Operating Expenses $144,293 $205,027 $211,744
Profit Before Interest and Taxes ($9,409) $64,059 $90,433
EBITDA ($9,409) $64,059 $90,433
Interest Expense $3,819 $3,144 $2,440
Taxes Incurred $0 $18,275 $26,398
Net Profit ($13,228) $42,641 $61,595
Net Profit/Sales -9.55% 15.40% 19.81%

Projected Cash Flow

The following cash flow projections show the annual amounts only, significant for the first year mainly in the amounts projected in cash sales and payables. 

Cash flow projections are critical to the success of Kid’s Community College®.  The monthly cash flow is shown in the illustration, with one bar representing the cash flow per month and the other the monthly cash balance.  The annual cash flow figures are included here and the more important detailed monthly numbers are included in the appendices. 

Child day care services business plan, financial plan chart image

Pro Forma Cash Flow
Year 1 Year 2 Year 3
Cash Received
Cash from Operations
Cash Sales $138,540 $276,820 $310,859
Subtotal Cash from Operations $138,540 $276,820 $310,859
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 $138,540 $276,820 $310,859
Expenditures Year 1 Year 2 Year 3
Expenditures from Operations
Cash Spending $57,037 $108,111 $113,516
Bill Payments $86,777 $123,660 $134,952
Subtotal Spent on Operations $143,814 $231,771 $248,468
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 $10,057 $10,057 $10,057
Purchase Other Current Assets $0 $0 $0
Purchase Long-term Assets $0 $0 $0
Dividends $0 $0 $0
Subtotal Cash Spent $153,871 $241,828 $258,525
Net Cash Flow ($15,331) $34,992 $52,334
Cash Balance $50,219 $85,211 $137,545

Projected Balance Sheet

The balance sheet in the following table shows managed but sufficient growth of net worth, and a gradually sufficient healthy financial position.  The monthly estimates are included in the appendices.

Pro Forma Balance Sheet
Year 1 Year 2 Year 3
Assets
Current Assets
Cash $50,219 $85,211 $137,545
Other Current Assets $14,130 $14,130 $14,130
Total Current Assets $64,349 $99,341 $151,675
Long-term Assets
Long-term Assets $0 $0 $0
Accumulated Depreciation $0 $0 $0
Total Long-term Assets $0 $0 $0
Total Assets $64,349 $99,341 $151,675
Liabilities and Capital Year 1 Year 2 Year 3
Current Liabilities
Accounts Payable $7,954 $10,362 $11,157
Current Borrowing $0 $0 $0
Other Current Liabilities $0 $0 $0
Subtotal Current Liabilities $7,954 $10,362 $11,157
Long-term Liabilities $49,943 $39,886 $29,829
Total Liabilities $57,897 $50,248 $40,986
Paid-in Capital $59,130 $59,130 $59,130
Retained Earnings ($39,450) ($52,678) ($10,037)
Earnings ($13,228) $42,641 $61,595
Total Capital $6,452 $49,093 $110,688
Total Liabilities and Capital $64,349 $99,341 $151,675
Net Worth $6,452 $49,093 $110,688

Business Ratios

The following table shows the projected businesses ratios for our industry: Child Day Care services, SIC code 8351. Kid’s Community College® expects to maintain healthy ratios for profitability, risk, and return.

Ratio Analysis
Year 1 Year 2 Year 3 Industry Profile
Sales Growth n.a. 99.81% 12.30% 6.98%
Percent of Total Assets
Other Current Assets 21.96% 14.22% 9.32% 30.21%
Total Current Assets 100.00% 100.00% 100.00% 60.28%
Long-term Assets 0.00% 0.00% 0.00% 39.72%
Total Assets 100.00% 100.00% 100.00% 100.00%
Current Liabilities 12.36% 10.43% 7.36% 27.78%
Long-term Liabilities 77.61% 40.15% 19.67% 24.23%
Total Liabilities 89.97% 50.58% 27.02% 52.01%
Net Worth 10.03% 49.42% 72.98% 47.99%
Percent of Sales
Sales 100.00% 100.00% 100.00% 100.00%
Gross Margin 97.36% 97.21% 97.21% 100.00%
Selling, General & Administrative Expenses 113.51% 78.74% 72.22% 81.45%
Advertising Expenses 0.00% 0.00% 0.00% 0.88%
Profit Before Interest and Taxes -6.79% 23.14% 29.09% 1.52%
Main Ratios
Current 8.09 9.59 13.59 1.96
Quick 8.09 9.59 13.59 1.56
Total Debt to Total Assets 89.97% 50.58% 27.02% 60.93%
Pre-tax Return on Net Worth -205.01% 124.08% 79.50% 2.47%
Pre-tax Return on Assets -20.56% 61.32% 58.01% 6.32%
Additional Ratios Year 1 Year 2 Year 3
Net Profit Margin -9.55% 15.40% 19.81% n.a
Return on Equity -205.01% 86.86% 55.65% n.a
Activity Ratios
Accounts Payable Turnover 11.91 12.17 12.17 n.a
Payment Days 27 27 29 n.a
Total Asset Turnover 2.15 2.79 2.05 n.a
Debt Ratios
Debt to Net Worth 8.97 1.02 0.37 n.a
Current Liab. to Liab. 0.14 0.21 0.27 n.a
Liquidity Ratios
Net Working Capital $56,396 $88,979 $140,517 n.a
Interest Coverage -2.46 20.37 37.06 n.a
Additional Ratios
Assets to Sales 0.46 0.36 0.49 n.a
Current Debt/Total Assets 12% 10% 7% n.a
Acid Test 8.09 9.59 13.59 n.a
Sales/Net Worth 21.47 5.64 2.81 n.a
Dividend Payout 0.00 0.00 0.00 n.a

Appendix

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
Full-time Couples 0% 6 8 10 12 12 10 10 20 27 27 27 30
After School Care 0% 6 6 6 6 6 8 8 15 20 20 20 20
Summer Camp 0% 0 0 0 0 0 13 13 0 0 0 0 0
Part-time Workers/Drop-Ins 0% 1 1 1 1 1 1 1 1 1 1 1 1
Total Unit Sales 13 15 17 19 19 32 32 36 48 48 48 51
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
Full-time Couples $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00
After School Care $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00
Summer Camp $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00
Part-time Workers/Drop-Ins $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Sales
Full-time Couples $2,760 $3,680 $4,600 $5,520 $5,520 $4,600 $4,600 $9,200 $12,420 $12,420 $12,420 $13,800
After School Care $1,440 $1,440 $1,440 $1,440 $1,440 $1,920 $1,920 $3,600 $4,800 $4,800 $4,800 $4,800
Summer Camp $0 $0 $0 $0 $0 $5,980 $5,980 $0 $0 $0 $0 $0
Part-time Workers/Drop-Ins $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Sales $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
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
Full-time Couples 2.90% $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34
After School Care 1.90% $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56
Summer Camp 3.00% $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80
Part-time Workers/Drop-Ins 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
Full-time Couples $80 $107 $133 $160 $160 $133 $133 $267 $360 $360 $360 $400
After School Care $27 $27 $27 $27 $27 $36 $36 $68 $91 $91 $91 $91
Summer Camp $0 $0 $0 $0 $0 $179 $179 $0 $0 $0 $0 $0
Part-time Workers/Drop-Ins $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $107 $134 $161 $187 $187 $349 $349 $335 $451 $451 $451 $491
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Campus Director 0% $1,833 $1,833 $1,833 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042
F/T Instructors 0% $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $2,560 $2,560 $2,560 $2,560 $2,560
P/T Instructors 0% $600 $600 $600 $600 $600 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Total People 3 3 3 3 3 4 4 5 5 5 5 5
Total Payroll $3,713 $3,713 $3,713 $3,922 $3,922 $4,522 $4,522 $5,802 $5,802 $5,802 $5,802 $5,802

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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0

Pro Forma Profit and Loss
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 $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
Direct Cost of Sales $107 $134 $161 $187 $187 $349 $349 $335 $451 $451 $451 $491
Hidden Row $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $107 $134 $161 $187 $187 $349 $349 $335 $451 $451 $451 $491
Gross Margin $4,193 $5,086 $5,979 $6,873 $6,873 $12,251 $12,251 $12,565 $16,869 $16,869 $16,869 $18,209
Gross Margin % 97.50% 97.43% 97.38% 97.35% 97.35% 97.23% 97.23% 97.40% 97.39% 97.39% 97.39% 97.37%
Expenses
Payroll $3,713 $3,713 $3,713 $3,922 $3,922 $4,522 $4,522 $5,802 $5,802 $5,802 $5,802 $5,802
Sales and Marketing and Other Expenses $0 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900
Utilities $875 $875 $875 $875 $875 $875 $875 $875 $875 $875 $875 $875
Insurance $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Payroll Taxes 15% $557 $557 $557 $588 $588 $678 $678 $870 $870 $870 $870 $870
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $10,645 $10,845 $10,845 $11,085 $11,085 $11,775 $11,775 $13,247 $13,247 $13,247 $13,247 $13,247
Profit Before Interest and Taxes ($6,452) ($5,759) ($4,866) ($4,213) ($4,213) $475 $475 ($683) $3,621 $3,621 $3,621 $4,961
EBITDA ($6,452) ($5,759) ($4,866) ($4,213) ($4,213) $475 $475 ($683) $3,621 $3,621 $3,621 $4,961
Interest Expense $345 $340 $335 $330 $326 $321 $316 $311 $306 $301 $296 $291
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,797) ($6,099) ($5,201) ($4,543) ($4,538) $155 $160 ($993) $3,315 $3,320 $3,325 $4,670
Net Profit/Sales -158.08% -116.84% -84.71% -64.35% -64.28% 1.23% 1.27% -7.70% 19.14% 19.17% 19.20% 24.97%

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,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
Subtotal Cash from Operations $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
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,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
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 $3,713 $3,713 $3,713 $3,922 $3,922 $4,522 $4,522 $5,802 $5,802 $5,802 $5,802 $5,802
Bill Payments $246 $7,392 $7,607 $7,630 $7,681 $7,685 $7,923 $7,924 $8,095 $8,203 $8,198 $8,194
Subtotal Spent on Operations $3,959 $11,105 $11,320 $11,552 $11,603 $12,207 $12,445 $13,726 $13,897 $14,005 $14,000 $13,996
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 $838 $838 $838 $838 $838 $838 $838 $838 $838 $838 $838 $838
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 $4,797 $11,943 $12,158 $12,390 $12,441 $13,045 $13,283 $14,564 $14,735 $14,843 $14,838 $14,834
Net Cash Flow ($497) ($6,723) ($6,018) ($5,330) ($5,381) ($445) ($683) ($1,664) $2,585 $2,477 $2,482 $3,866
Cash Balance $65,053 $58,330 $52,312 $46,982 $41,601 $41,156 $40,473 $38,809 $41,394 $43,871 $46,353 $50,219
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 $65,550 $65,053 $58,330 $52,312 $46,982 $41,601 $41,156 $40,473 $38,809 $41,394 $43,871 $46,353 $50,219
Other Current Assets $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130
Total Current Assets $79,680 $79,183 $72,460 $66,442 $61,112 $55,731 $55,286 $54,603 $52,939 $55,524 $58,001 $60,483 $64,349
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 $79,680 $79,183 $72,460 $66,442 $61,112 $55,731 $55,286 $54,603 $52,939 $55,524 $58,001 $60,483 $64,349
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 $7,138 $7,353 $7,374 $7,425 $7,420 $7,659 $7,654 $7,822 $7,929 $7,925 $7,920 $7,954
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 $7,138 $7,353 $7,374 $7,425 $7,420 $7,659 $7,654 $7,822 $7,929 $7,925 $7,920 $7,954
Long-term Liabilities $60,000 $59,162 $58,324 $57,486 $56,648 $55,810 $54,972 $54,134 $53,295 $52,457 $51,619 $50,781 $49,943
Total Liabilities $60,000 $66,300 $65,677 $64,860 $64,073 $63,230 $62,631 $61,788 $61,117 $60,387 $59,544 $58,701 $57,897
Paid-in Capital $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130
Retained Earnings ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450)
Earnings $0 ($6,797) ($12,897) ($18,098) ($22,641) ($27,179) ($27,024) ($26,865) ($27,858) ($24,543) ($21,223) ($17,898) ($13,228)
Total Capital $19,680 $12,883 $6,783 $1,582 ($2,961) ($7,499) ($7,344) ($7,185) ($8,178) ($4,863) ($1,543) $1,782 $6,452
Total Liabilities and Capital $79,680 $79,183 $72,460 $66,442 $61,112 $55,731 $55,286 $54,603 $52,939 $55,524 $58,001 $60,483 $64,349
Net Worth $19,680 $12,883 $6,783 $1,582 ($2,961) ($7,499) ($7,344) ($7,185) ($8,178) ($4,863) ($1,543) $1,782 $6,452