Download Our Daycare Center Financial Projections Template

Get a daycare financial projections template for your business. Using our CPA developed daycare expense spreadsheet and business plan template, you can create investor and lender-ready projections in less than one hour. Download you daycare business plan template online today at ProjectionHub.

How it works?

Our certified public accountant (CPA) built spreadsheet helps you create realistic projections based on your unique business plan.

Create lender-ready projections in hours, not weeks.

Our CPA developed template enables you to create professional projections based on your unique assumptions.

Create investor- and lender-ready projections in hours, not days.

Built for child care centers specifically  — our tools have been used by over 500 daycare facilities to develop financial forecasts. Our daycare expense spreadsheet template makes creating SBA and investor-ready financial forecasts for daycare centers a breeze.

How it works?

Watch a demo of the template

Save time & money - get organized with our template!

Get a day care center template now for $99

BUY

The template price: $

99

USD

100% money-back guarantee if you are not satisfied.

Step 1: Purchase and download the template

After purchase, you will download an unlocked Excel file with a ready-to-usefinancial projection template for your business model

Get the template

Step 2: Enter your assumptions on the input tabs

The Sales Projections  

  • The daycare facility revenue model will help you predict your daycare capacity and overall revenue by looking at hourly revenue per child for different age groups. ​ The model also helps you calculate staff expenses based on required caregivers per age group, and supplies cost on a per-child basis. The forecasted values will automatically flow through to the financial reports. 

Daycare Facility Expenses

  • We will guide you through entering your general operating expenses in the operating expense spreadsheet tab, which includes recommended expenses and dollar amounts to help you get started. ​This portion of the spreadsheet will flow through to the P&L and cash flow statement. Enter monthly expenses as either fixed dollar amounts or set them as a percentage of sales for variable expenses like payment processing fees. 

Daycare General Assumptions Tab

  • The general assumptions spreadsheet tab will help you enter balance sheet items such as fixed assets, loans, investments, inventory assumptions, and accounts receivable assumptions. The template will allow you to input some simple information and then calculate the more complicated numbers for you: loan amortization, interest expense, depreciation expense, inventory purchases, etc. 

Daycare Facility Salaries Spreadsheet

  • The salaries and owner’s draw sheet helps you calculate monthly expenses for salaried employees, including expenses like employer taxes and benefits. This template also helps you determine how much you can take as an owner’s draw in your childcare business.

Step 3: The model is automatically updated based on your assumptions

Daycare Financial Summary Tab

  • The At-A-Glace tab shows you a financial pro forma through graphs, charts, ratios, and financial summaries, all ready to be inserted into a business plan. 

Projected Financial Statements

  • The Financial Statement tabs include: annual income statements, cash flow statements, and balance sheets, and the monthly breakdowns of the same financial statements.

Investor Friendly Spreadsheet

  • This template was built with potential investors in mind. The simplicity of how data and complex financial data is displayed makes it easy for any desired funders to be included. Any user granted access can manipulate variables in order to stress test and consider new variables.

Dashboards and charts include:

Tables, charts, graphs and dashboards include:

  • P&L at a glance table
  • Use of startup funds 
  • Key daycare ratios table ​​ 
  • Five years of monthly and annual 3 statement financial reports

  • Profit and loss at a glance table

  • Use of start-up funds graph

  • Key ratios table

  • ​Cash generated from operating activities graph

  • Investor dashboard

  • 5 years of monthly and annual income statement, cash flow and balance sheet reports

Step 4: If you need help, we're here

We can fill out or modify any of the templates we sell, and we’re always happy to answer questions.

When you call us, you can speak directly to the developers of the model, not a call center or customer service representative.

Contact us in the most convenient way for you. We're here to help you

If the model doesn’t work for you, we’re happy to provide a refund.

You may also like these templates

The ProjectionHub Team

Grace Cisna, CPA

Before joining ProjectionHub, Grace served as an auditor for a public accounting firm in Indianapolis. There, she audited start-up tech companies, major regional hospitals, public manufacturers and everything in between.

As an auditor, she gained insinullght to the inner workings of all kinds of business models. Grace is a CPA, has a bachelor’s degrees in Accounting and French and a Master’s of Accountancy all from the University of Iowa, where she also taught introductory accounting classes to undergraduates.

Grace loves to use her accounting expertise to serve as an advisor to her clients, helping them understand what it takes to make a business succeed.

Adam Hoeksema — Co-founder ProjectionHub

Adam is the co-founder of ProjectionHub which is a SaaS web application that helps entrepreneurs create financial projections for their business.

Since 2012, over 40,000 entrepreneurs from around the world have used ProjectionHub to help create financial projections.

Adam also serves as the Executive Director of Bankable. Bankable is a Small Business Administration (SBA) lender that makes loans from $500 to $250,000 to Indiana small businesses that are unable to secure financing from a traditional bank.

Adam has managed the loan program since loan #1 in 2010. Since 2010, Bankable has closed over 1,200 loans totaling over $38,000,000. Adam is an entrepreneur at heart and loves working with entrepreneurs to launch and grow their business.

What others have to say about our templates

We are available to help you complete your projections

Troubleshoot

We'll answer your questions about how the template works

Customize

We'll help you customize your template, add a cafe, bookstore, or brewery to your coffee shop

Frequently Asked Questions

How much profit does a daycare center make?

The average daycare center owner reported earning just $37,000 per year in profit.  Although this is the average, this number can contain many very small daycare centers and in-home daycares that makes earning a significant profit difficult.  It is certainly possible to earn a significant profit from a daycare center if your center is large enough.  Our daycare financial projection template can help you see how much increasing the capacity of your daycare can impact your projected profitability.  

Are daycare centers profitable?

Yes. The average daycare center owner reported earning $37,000 per year in profit.  The profitability potential of your daycare center is tied very closely to the capacity of your center.  

Is opening a daycare worth it?

Yes. Opening a daycare can be both a profitable and rewarding business.  While the average daycare center owner reports only $37,000 in annual profit, this number includes many in-home daycare centers and small centers.  Larger daycare centers can earn a significant profit.  So much of the profitability is centered around your daycare capacity.  If you can afford the startup costs associated with a larger daycare center, you will greatly increase your potential profits. 

What is the startup cost for a daycare center?

The average startup cost for a daycare center can range between $10,000 and $100,000+.  Small, in-home daycare centers can open their doors for as little as $10,000, but larger daycare centers could cost $100,000 or more to open.  Daycare center startup costs can include:

  • Kitchen equipment and remodeling
  • Bathroom remodeling
  • Outdoor fencing and playground equipment
  • Child check-in system
  • Tables, chairs, toys and supplies
  • Remodeling of space to “child-proof” the space

The cost of the template is estimated at $ 2000

If you hired a CPA to build this template from scratch it would take at least 20 hours of billable time to build a similar template. At an average hourly rate of $100 per hour it would cost you $2,000.

20 hours X $100 = $2,000 value

But we've already done all the work and you don't need to hire a CPA

Save time & money - get organized with our template!

Get a day care center template now for $99

BUY

The template price: $

99

USD

100% money-back guarantee if you are not satisfied.

?