Nonprofit youth services business plan

Page 1

Table of Contents

1.0 Executive Summary...............................................................................................................................1 Chart: Highlights..................................................................................................................................2 1.1 Objectives..........................................................................................................................................2 1.2 Mission...............................................................................................................................................2 2.0 Organization Summary..........................................................................................................................1 2.1 Start-up Summary..............................................................................................................................1 Chart: Start-up......................................................................................................................................2 Table: Start-up.....................................................................................................................................2 2.2 Legal Entity........................................................................................................................................3 3.0 Services..................................................................................................................................................1 4.1 Market Segmentation.........................................................................................................................1 4.2 Target Market Segment Strategy.......................................................................................................3 5.1 Fundraising Strategy..........................................................................................................................1 Table: Funding Forecast..................................................................................................................2 Chart: Funding by Year...................................................................................................................3 5.2 Marketing Strategy.............................................................................................................................3 6.0 Management Summary..........................................................................................................................4 6.1 Personnel Plan....................................................................................................................................4 Table: Personnel...................................................................................................................................4 7.0 Financial Plan.........................................................................................................................................1 7.1 Important Assumptions......................................................................................................................1 Table: General Assumptions................................................................................................................1 7.2 Projected Surplus or Deficit...............................................................................................................1 Table: Surplus and Deficit...................................................................................................................2 Chart: Surplus Monthly........................................................................................................................3 Chart: Surplus Yearly..........................................................................................................................3 Chart: Gross Surplus Monthly.............................................................................................................4 Chart: Gross Surplus Yearly................................................................................................................4 7.3 Projected Cash Flow..........................................................................................................................5 Chart: Cash...........................................................................................................................................5 Table: Cash Flow.................................................................................................................................5 7.4 Projected Balance Sheet.....................................................................................................................6 Table: Balance Sheet............................................................................................................................6 7.5 Standard Ratios..................................................................................................................................7 Table: Ratios........................................................................................................................................1 Table: Funding Forecast..............................................................................................................................1 Table: Personnel...........................................................................................................................................2 ......................................................................................................................................................................2 Table: General Assumptions........................................................................................................................3 Table: Surplus and Deficit...........................................................................................................................3 Table: Cash Flow.........................................................................................................................................4 Table: Balance Sheet....................................................................................................................................8

Page 1


Unite for Youth

1.0 Executive Summary Unite for Youth is a nonprofit agency providing mentoring programs for middle and high school youth in the Greater Claremont area. The program will form partnerships with local school districts and the juvenile court system. Unite for Youth's goal is to foster a commitment to young people that will promote pro-social friendships, strong interpersonal skills, and reassert a sense of hope in the future. Only through personal relationships can a sense of individual responsibility be reestablished that will give youth the commitment to follow through on path to adulthood with a sense of pride and accomplishment. Through repeated failures in the classroom and the development of destructive habits, at-risk young people have lost faith in the possibilities that await them if they are successful in putting their lives together. To accomplish this goal, young people must be in a caring, inclusive learning environment that promotes their best effort and reinforces personal respect. Unite for Youth is a program that is in direct response to the growing number of young people that are either falling through the cracks at school or are already entangled with the juvenile court system. The goal of the program is to identify youths who are going to have a turbulent transition to adulthood and offer positive support system to avoid the pitfalls that can derail their lives. The focus is slightly different at each level but the goal remains the same; empower the young person to make positive changes in his/her life. Unite for Youth will focus primarily on middle school youths. It is projected that within three years, 50% of the system's students will be in middle school. This age group is particularly problematic and a perfect time for mentoring to be effective. Unite for Youth's mentoring programs will pair a youth with mentor for 12 months. During that time the two will participate in weekly planned activities to strengthen the relationship between the two and improve the young person's confidence and hopefulness. Mentors will receive continuous training throughout the year and will participate in monthly meeting to report the young person's progress. Over time, Unite for Youth will create a learning environment that will be an invaluable resource to young people, aspiring mentors and the community at large.

Page 1


Unite for Youth

Chart: Highlights

1.1 Objectives Unite for Youth is being established to provide mentoring for at risk middle and high school youth in the Greater Claremont area. The program will create partnerships with the local school districts and the juvenile court system. Unite for Youth matches a caring adult volunteer with a referred youth. Unite for Youth will setup four distinct mentoring programs: • Trailblazers: Trailblazers is the central program of Unite for Youth. At risk middle school students and their mentors participate in a structured program of support. • Turnaround: Turnaround focuses on students who are chronically suspended from middle and high schools. • Higher Ground: Higher Ground engages youth involved in the juvenile court system. • Lunch Friends: Lunch Friends works with children from local elementary schools. 1.2 Mission The mission of Unite for Youth is the pursuit of the following principles: • Commitment: Unite for Youth wants to inspire pro-social friendships, strong interpersonal skills, and instill a sense of hope in the future. • Responsibility: The focus of Unite for Youth is to empower youth in establishing goals and following through on commitments. Page 2


Unite for Youth

• Possibility: Unite for Youth wants to expand the perspective of young people to make them aware of life's possibilities. • Support: An individual is dramatically influenced by their support system. Unite for Youth wants to surround young people in a caring, inclusive learning environment. 1.3 Keys to Success • Establish a strong network of support with the school systems and the juvenile court system. • Launch a series of fundraising activities that will successfully fund the expanding program. • Establish an effective training program for mentors that will increase their ability to be successful communicators. • Establish an effective monitoring system to protect both the youth and the mentor.

Page 3


Unite for Youth

2.0 Organization Summary Unite for Youth is a nonprofit agency providing mentoring programs for middle and high school youth in the Greater Claremont area. The program will form partnerships with local school districts and the juvenile court system. Youth are matched with a caring adult volunteer who is trained to focus on positive reinforcement, trust-building, and the achievement of goals, by engaging youth in one-onone outing and group adventures in the community. Mentors and youth agree to meet for between 10-15 hours per month for a full year. Ongoing training will continue with mentors on individual case management throughout the year. In addition, Unite for Youth will have monthly mentor support meetings. 2.1 Start-up Summary Our start-up expenses come to $8,500, which is mostly stationery, legal costs, and expenses associated with opening our office. We will also need cash to finance the first year of operations. The start-up costs are to be financed by contributions by ten private sponsors. The assumptions are shown in the following table and chart.

Page 1


Unite for Youth

Chart: Start-up

Table: Start-up Start-up Requirements Start-up Expenses Legal Stationery etc. Brochures Consultants Insurance Rent Total Start-up Expenses

$500 $200 $2,000 $5,000 $300 $500 $8,500

Start-up Assets Cash Required Other Current Assets Long-term Assets Total Assets Total Requirements

$71,500 $0 $0 $71,500 $80,000

Table: Start-up Funding Start-up Funding Start-up Expenses to Fund

$8,500 Page 2


Unite for Youth

Start-up Assets to Fund Total Funding Required

$71,500 $80,000

Assets Non-cash Assets from Start-up Cash Requirements from Start-up Additional Cash Raised Cash Balance on Starting Date Total Assets

$0 $71,500 $0 $71,500 $71,500

Liabilities and Capital Liabilities Current Borrowing Long-term Liabilities Accounts Payable (Outstanding Bills) Other Current Liabilities (interest-free) Total Liabilities

$0 $0 $0 $0 $0

Capital Planned Investment Donor 1 Donor 2 Donor 3 Donor 4 Donor 5 Donor 6 Donor 7 Donor 8 Donor 9 Donor 10 Additional Investment Requirement Total Planned Investment

$8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $0 $80,000

Loss at Start-up (Start-up Expenses) Total Capital Total Capital and Liabilities Total Funding

($8,500) $71,500 $71,500 $80,000

2.2 Legal Entity Unite for Youth is a tax-exempt not-for-profit mentoring organization that pairs volunteers with at-risk youth. Page 3


Unite for Youth

3.0 Services Unite for Youth offers youth, that have already been identified as at-risk, an opportunity to work with a caring mentor to improve their ability to develop a positive attitude towards their future. The long-term goal of Unite for Youth is to empower the young person to break the habits that are leading to trouble in school and in the streets. Unite for Youth has four mentoring programs. They are as follows: • Trailblazers: Trailblazers is the central program of Unite for Youth. At-risk middle school students and their mentors participate in a structured program of support. At-risk middle school students and their mentors participate in an energizing retreat, followed by a seven month structured program that includes monthly team-building and group activities. The program ends with a graduation but the mentor and youth remain together for the following five months. • Turnaround: Turnaround focuses on students who are chronically suspended from middle and high schools. The goal of the program is to rekindle the youth's commitment to learning and being successful in the classroom. By empowering young people to finish school, mentors are improving the student's success in the work world as adults. • Higher Ground: Higher Ground engages youth involved in the juvenile court system. The mentoring relationship is utilized to establish a program of change in the young person's life. The mentor encourages goal-setting, self discipline, and skill development that improves the young person's sense of hopefulness. Mentors and youth work one-onone for a year and are also offered opportunities to participate in monthly group activities and outings. • Lunch Friends: Lunch Friends works with children from local elementary schools. Adult mentors come to school each week to have lunch with their "friend." The program lasts for the duration of the school year.

Page 1


Unite for Youth

4.0 Market Analysis Summary Unite for Youth is a program that is in direct response to the growing number of young people that are either falling through the cracks at school or are already entangled with the juvenile court system. Unite for Youth offers at-risk youth the opportunity to make a dramatic change in their lives. The program is positioned to be most assessable to young people who otherwise would be swept into the juvenile court system or frequent school detention. The goal of the program is to identify youths who are going have a turbulent transition to adulthood and offer positive support system to avoid the pitfalls that can derail their lives. The focus is slightly different at each level. At the elementary school level, mentors strive to guide the young person back into the mainstream of class activity in order to destroy the negative reinforcers that can turn a student off to school. With middle school students, Unite for Youth provides mentors that serve as developmental role models for young people looking for direction. Sometimes it is as easy as a young person identifying with his mentor rather than a person involved in criminal or destructive activities. Once a student has entered high school with a history of classroom disturbances and poor academic skills, it takes a tremendous proactive effort to assist a student in redirecting their lives. Unite for Youth has found that group activities can service as a powerful reinforcer of hopeful behavior. Currently, middle school youths disturbances the majority of students being served by Unite for Youth. Elementary children represent a critical group as they progress through school. Children between the ages of five to 11 disturbances close to 40% of the children attending Claremont public schools. It is projected that within three years, 50% of the system's students will be in middle school. 4.1 Market Segmentation Unite for Youth has a number of market focuses that are key to the program's success. • Youth who are overcoming stressors in their lives, such as poverty, discrimination, abusive situations, addictions, unstable homes, and academic life, are the primary marketing focus of Unite for Youth. Mentoring programs foster positive changes through goal setting, self-discipline, skill development, and friendship. • Families are also the marketing focus when adult mentors are able to help youth work on solutions for their family stresses, and provide an objective but caring sounding board. As a result, many youth and their families report improved relations at home. Families must buy into the benefit from our United Parenting program, a 10-month series of customPage 1


Unite for Youth

designed information and discussion groups that enrich parenting effectiveness, especially in the area of cognitive skills associated with family management practices. • Marketing also attracts mentors to Unite for Youth because they care about kids and their community. The typical mentor-youth relationship demands a commitment that must be sold to the potential mentor. For most mentors, this experience changes their lives, taps their inner resources, and challenges their convictions and beliefs. • Ultimately, Unite for Youth is marketed to Claremont as a critical social support system young people. Unite for Youth impacts how many other city services will be called in to respond to destructive behavior in the community. Table: Market Analysis Market Analysis Year 1 Potential Customers Elementary School Youths Middle School Youths High School Youths Total

Year 2

Year 3

Year 4

Year 5

Growth 8% 12,000

12,960

13,997

15,117

16,326

CAGR 8.00%

20% 10,000 7% 8,000 12.20% 30,000

12,000 8,560 33,520

14,400 9,159 37,556

17,280 9,800 42,197

20,736 10,486 47,548

20.00% 7.00% 12.20%

Chart: Market Analysis (Pie)

Page 2


Unite for Youth

4.2 Target Market Segment Strategy The target market for Unite for Youth are young people ages eight to 16 that have developed destructive habits that will lead down a path of hopelessness. Unite for Youth has created a series of mentoring programs that pair the young person with a trained mentor who will assist him or her in developing the habits and perspective that will lead to success and hopefulness in the future.

Page 3


Unite for Youth

5.0 Strategy and Implementation Summary There are three focuses to Unite for Youth's program implementation: • First is the creation of a network of contacts with Claremont School System and the county's juvenile court system. • The second is the recruiting and training of mentors. • The third is the development of fundraising strategies. 5.1 Fundraising Strategy Unite for Youth's funding sources include private donations, federal and state contracts, grants from private foundations, school districts and business sponsorship. The program's fundraising Coordinator has established a number of contribution options that a supporter can select from. • Cash Donation: From $1,000 to sponsor a youth for a year to $30 to fund the Outdoor Challenge course that all participants take part in. • Gift of Appreciated Stock: a gift of appreciated stocks, bonds, or mutual funds can both support the program and provide tax saving to the donor. • Legacy Gifts: a planned gift in a will, trust, or other estate plan. • Corporate Giving and Sponsorship: Businesses can provide cash or grants. Businesses are also encouraged to participate in the Unite for Youth fundraising events that take place throughout the year. These events include Fun Runs, Wine Tasting, Bike Races, and Raffles. • Food Store Community Partnership Program: Unite for Youth receives a portion of what is spent in local food stores when the shopper uses the program card when making purchases. The card will be scanned at the checkout and the program will receive credit for the sale. 5.1.1 Funding Forecast Unite for Youth forecast of revenues for 2003 is $267,396. The stable core funding is from Federal/State contracts, private foundations, and the school districts. Yet anticipated growth from these funding sources is estimated to be only 5% over the next three years. Unite for Youth will focus on rapidly increasing funding from sources where the percentage growth is projected to be higher. The targets are private donations, business sponsorships and fundraising campaigns. By 2005, estimated revenue should be in excess of $350,000. Page 1


Unite for Youth

Table: Funding Forecast Funding Forecast Year 1

Year 2

Year 3

Funding Private Donations Federal/State Contracts Private Foundations School Districts Business Sponsors Fundraising Campaign Total Funding

$39,966 $89,112 $42,316 $52,156 $26,472 $17,374 $267,396

$43,163 $93,568 $44,432 $54,764 $40,000 $30,000 $305,926

$46,616 $98,246 $46,653 $57,502 $60,000 $50,000 $359,018

Direct Cost of Funding Costs Other Subtotal Cost of Funding

$0 $0 $0

$0 $0 $0

$0 $0 $0

Chart: Funding Monthly

Page 2


Unite for Youth

Chart: Funding by Year

5.2 Marketing Strategy Unite for Youth believes in the goal of leaving no child behind. The goal is to raise the visibility of program to assure that: • Referral sources will use the service; • Funding sources will support the program; • Adults will volunteer to be mentors. The marketing strategy will be to successfully sell this new resource to the schools and the juvenile court system. This will be accomplished by a referral coordinator who will create and maintain a network of contacts that will serve as the referral source for the program. Brochures will be developed to sell the benefits of the program to both potential referrers and participants. The referral coordinator will provide progress reports for the referring program, school, or agency. The goal will be to build an effective marketing program on the success of the mentoring relationships. A marketing effort will also be implemented to attract and retain quality mentors for the program. The program's mentor recruiter/trainer will make presentations to Claremont civic and social group, selling the benefits of participating in Unite for Youth. Reward activities Page 3


Unite for Youth

will be planned for mentors. These activities will be used to recruit new mentors from the friends and associates of current mentors. The core of the marketing strategy will be the creation of the program's Board of Directors who will be chartered with the responsibility of selling the benefits of the program to the community.

6.0 Management Summary Unite for Youth's management team will consist of the Board of Directors and the program's executive director. A team of professional program and fundraising managers will be assembled to manage and grow the program. 6.1 Personnel Plan The following table summarizes our personnel expenditures for the first three years. Unite for Youth will have the following staff. • • • •

Fundraising/grant coordinator; Mentor recruitment/training coordinator; Youth referral coordinator; Office manager.

Table: Personnel Personnel Plan Executive Director Fundraising/Grant Coordinator Mentor Recruitment Coordinator Youth Referral Coordinator Office Manager Total People Total Payroll

Year 1 $30,000 $24,000 $24,000 $24,000 $20,400 5 $122,400

Year 2 $30,000 $24,000 $24,000 $24,000 $20,400 5 $122,400

Year 3 $30,000 $24,000 $24,000 $24,000 $20,400 5 $122,400

Page 4


Unite for Youth

7.0 Financial Plan Unite for Youth will build funding support from businesses and private donors in the community at an aggressive rate of growth. Yet it will take five years before funding from these sources becomes strong enough to expand the program. The primary expenditures for the program are for the training and managing of mentors and the program activities for youth and mentors. Therefore it is essential that due diligence is applied to fund allocation for these critical program responsibilities. An effective communication system will be established to report fiscal data to the Board of Directors so adjustment can be made quickly to assure the health of the program. We are also assuming beginning cash reserves on October 1st of $71,500 according to the treasurer. 7.1 Important Assumptions The financial plan depends on important assumptions, most of which are shown in the following table. The key underlying assumptions are: • • • •

We assume a slow-growth economy, without major recession. We assume that there are no unforeseen changes in federal grant funding availability. We assume a continued need for services by at-risk youths. We assume broad community support for mentoring.

Table: General Assumptions General Assumptions Plan Month Current Interest Rate Long-term Interest Rate Tax Rate Other

Year 1 1 10.00% 10.00% 0.00% 0

Year 2 2 10.00% 10.00% 0.00% 0

Year 3 3 10.00% 10.00% 0.00% 0

7.2 Projected Surplus or Deficit Unite for Youth's projected surplus or deficit is shown on the following table, with revenue increasing from more than $267,396 the first year to more than $350,000 the third. Surplus Page 1


Unite for Youth

may be applied to program activities, marketing activities, or held for contingencies. The detailed monthly projections are included in the appendix. Table: Surplus and Deficit Surplus and Deficit Funding Direct Cost Other Costs of Funding Total Direct Cost

Year 1 $267,396 $0 $0 $0

Year 2 $305,926 $0 $0 $0

Year 3 $359,018 $0 $0 $0

Gross Surplus Gross Surplus %

$267,396 100.00%

$305,926 100.00%

$359,018 100.00%

Expenses Payroll Sales and Marketing and Other

$122,400 $12,000

$122,400 $15,000

$122,400 $18,000

Expenses Depreciation Rent Utilities Insurance Activities Payroll Taxes Training

$0 $3,600 $1,200 $0 $60,000 $0 $36,000

$0 $3,600 $1,200 $0 $70,000 $0 $40,000

$0 $4,000 $1,500 $0 $90,000 $0 $50,000

Total Operating Expenses

$235,200

$252,200

$285,900

Surplus Before Interest and Taxes EBITDA Interest Expense Taxes Incurred

$32,196 $32,196 $0 $0

$53,726 $53,726 $0 $0

$73,118 $73,118 $0 $0

Net Surplus Net Surplus/Funding

$32,196 12.04%

$53,726 17.56%

$73,118 20.37%

Page 2


Unite for Youth

Chart: Surplus Monthly

Chart: Surplus Yearly

Page 3


Unite for Youth

Chart: Gross Surplus Monthly

Chart: Gross Surplus Yearly

Page 4


Unite for Youth

7.3 Projected Cash Flow 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 appendix. Chart: Cash

Table: Cash Flow Pro Forma Cash Flow Cash Received

Year 1

Year 2

Year 3

Cash from Operations Cash Funding Subtotal Cash from Operations

$267,396 $267,396

$305,926 $305,926

$359,018 $359,018

Additional Cash Received Sales Tax, VAT, HST/GST Received New Current Borrowing New Other Liabilities (interest-free) New Long-term Liabilities Sales of Other Current Assets Sales of Long-term Assets

$0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 Page 5


Unite for Youth

New Investment Received Subtotal Cash Received

$0 $267,396

$0 $305,926

$0 $359,018

Expenditures

Year 1

Year 2

Year 3

Expenditures from Operations Cash Spending Bill Payments Subtotal Spent on Operations

$122,400 $103,713 $226,113

$122,400 $128,218 $250,618

$122,400 $160,730 $283,130

Additional Cash Spent Sales Tax, VAT, HST/GST Paid Out Principal Repayment of Current Borrowing Other Liabilities Principal Repayment Long-term Liabilities Principal Repayment Purchase Other Current Assets Purchase Long-term Assets Dividends Subtotal Cash Spent

$0 $0 $0 $0 $0 $0 $0 $226,113

$0 $0 $0 $0 $0 $0 $0 $250,618

$0 $0 $0 $0 $0 $0 $0 $283,130

Net Cash Flow Cash Balance

$41,283 $112,783

$55,308 $168,091

$75,888 $243,979

7.4 Projected Balance Sheet The balance sheet in the following table shows managed but sufficient growth of net worth, and a sufficiently healthy financial position. The monthly estimates are included in the appendix. Table: Balance Sheet Pro Forma Balance Sheet Assets

Year 1

Year 2

Year 3

Current Assets Cash Other Current Assets Total Current Assets

$112,783 $0 $112,783

$168,091 $0 $168,091

$243,979 $0 $243,979

Long-term Assets Long-term Assets Accumulated Depreciation Total Long-term Assets

$0 $0 $0

$0 $0 $0

$0 $0 $0 Page 6


Unite for Youth

Total Assets

$112,783

$168,091

$243,979

Liabilities and Capital

Year 1

Year 2

Year 3

Current Liabilities Accounts Payable Current Borrowing Other Current Liabilities Subtotal Current Liabilities

$9,087 $0 $0 $9,087

$10,668 $0 $0 $10,668

$13,438 $0 $0 $13,438

Long-term Liabilities Total Liabilities

$0 $9,087

$0 $10,668

$0 $13,438

Paid-in Capital Accumulated Surplus/Deficit Surplus/Deficit Total Capital Total Liabilities and Capital

$80,000 ($8,500) $32,196 $103,696 $112,783

$80,000 $23,696 $53,726 $157,422 $168,091

$80,000 $77,422 $73,118 $230,540 $243,979

Net Worth

$103,696

$157,422

$230,540

7.5 Standard Ratios Business ratios for the years of this plan are shown below. Industry profile ratios based on the Standard Industrial Classification (SIC) code 8322 or NAICS 624110, Child and Youth Services, are shown for comparison.

Page 7


Unite for Youth

Table: Ratios Ratio Analysis Funding Growth

Year 1 n.a.

Year 2 14.41%

Year 3 17.35%

Industry Profile 7.72%

Percent of Total Assets Other Current Assets Total Current Assets Long-term Assets Total Assets

0.00% 100.00% 0.00% 100.00%

0.00% 100.00% 0.00% 100.00%

0.00% 100.00% 0.00% 100.00%

32.31% 56.30% 43.70% 100.00%

Current Liabilities Long-term Liabilities Total Liabilities Net Worth

8.06% 0.00% 8.06% 91.94%

6.35% 0.00% 6.35% 93.65%

5.51% 0.00% 5.51% 94.49%

23.57% 28.65% 52.22% 47.78%

100.00% 100.00% 94.83%

100.00% 100.00% 88.44%

100.00% 100.00% 84.75%

100.00% 100.00% 78.74%

0.00% 12.04%

0.00% 17.56%

0.00% 20.37%

0.97% 1.90%

Main Ratios Current Quick Total Debt to Total Assets Pre-tax Return on Net Worth Pre-tax Return on Assets

12.41 12.41 8.06% 31.05% 28.55%

15.76 15.76 6.35% 34.13% 31.96%

18.16 18.16 5.51% 31.72% 29.97%

2.18 1.77 58.63% 3.01% 7.27%

Additional Ratios Net Surplus Margin Return on Equity

Year 1 12.04% 31.05%

Year 2 17.56% 34.13%

Year 3 20.37% 31.72%

n.a n.a

Activity Ratios Accounts Payable Turnover Payment Days Total Asset Turnover

12.41 27 2.37

12.17 28 1.82

12.17 27 1.47

n.a n.a n.a

Percent of Funding Funding Gross Surplus Selling, General & Administrative Expenses Advertising Expenses Surplus Before Interest and Taxes

Debt Ratios Page 1


Unite for Youth

Debt to Net Worth Current Liab. to Liab.

0.09 1.00

0.07 1.00

0.06 1.00

n.a n.a

Liquidity Ratios Net Working Capital Interest Coverage

$103,696 0.00

$157,422 0.00

$230,540 0.00

n.a n.a

Additional Ratios Assets to Funding Current Debt/Total Assets Acid Test Funding/Net Worth Dividend Payout

0.42 8% 12.41 2.58 0.00

0.55 6% 15.76 1.94 0.00

0.68 6% 18.16 1.56 0.00

n.a n.a n.a n.a n.a

Page 2


Appendix

Table: Funding Forecast

Funding Forecast Month 2

3

4

5

6

7

8

9

Month Month Month 10 11 12

0% $3,644

$3,512

$3,446

$2,918

$3,578

$3,182

$3,314

$3,314

$2,984

$3,380

$3,248

$3,446

0% $7,426

$7,426

$7,426

$7,426

$7,426

$7,426

$7,426

$7,426

$7,426

$7,426

$7,426

$7,426

0% $3,446

$3,578

$3,578

$3,578

$3,380

$3,512

$3,512

$3,512

$3,446

$3,644

$3,578

$3,552

0% $4,370

$4,370

$4,370

$4,304

$4,304

$4,304

$4,436

$4,304

$4,304

$4,370

$4,304

$4,416

0% $2,184

$2,184

$2,208

$2,208

$2,208

$2,208

$2,208

$2,208

$2,208

$2,208

$2,232

$2,208

0% $1,446

$1,456

$1,439

$1,439

$1,439

$1,439

$1,423

$1,456

$1,456

$1,456

$1,472

$1,456

$22,51 6

$22,52 6

$22,46 7

$21,87 3

$22,33 5

$22,07 1

$22,31 9

$22,22 0

$21,82 4

$22,48 4

$22,26 0

$22,50 4

Month 10 $0 $0 $0

Month 11 $0 $0 $0

Month 12 $0 $0 $0

1 Funding Private Donations Federal/State Contracts Private Foundations School Districts Business Sponsors Fundraising Campaign Total Funding Direct Cost of Funding Costs Other Subtotal Cost of Funding

Month 1 $0 $0 $0

Month

Month 2 $0 $0 $0

Month

Month 3 $0 $0 $0

Month

Month 4 $0 $0 $0

Month

Month 5 $0 $0 $0

Month

Month 6 $0 $0 $0

Month

Month 7 $0 $0 $0

Month

Month 8 $0 $0 $0

Month

Month 9 $0 $0 $0

Page 1


Appendix

Table: Personnel Personnel Plan Month Executive Director Fundraising/Grant Coordinator Mentor Recruitment Coordinator Youth Referral Coordinator Office Manager Total People Total Payroll

Month

Month

Month

Month

Month

Month

Month

Month

1 0% $2,500

2 $2,500

3 $2,500

4 $2,500

5 $2,500

6 $2,500

7 $2,500

8 $2,500

9 $2,500

Month Month Month 10 11 12 $2,500 $2,500 $2,500

0% $2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

0% $2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

0% $2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

$2,000

0% $1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$1,700 5

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

$10,20 0

Page 2


Appendix

Table: General Assumptions

General Assumptions

Plan Month Current Interest Rate Long-term Interest Rate Tax Rate Other

Month Month Month Month Month Month Month Month Month Month Month Month 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12 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% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 0.00% 0

0.00% 0

0.00% 0

Month

Month

0.00% 0

0.00% 0

0.00% 0

0.00% 0

0.00% 0

0.00% 0

0.00% 0

0.00% 0

0.00% 0

Table: Surplus and Deficit Surplus and Deficit

Funding Direct Cost Other Costs of Funding Total Direct Cost Gross Surplus Gross Surplus %

Month

Month

Month

Month

Month

Month

Month

1 $22,516 $0 $0

2 $22,526 $0 $0

3 $22,467 $0 $0

4 $21,873 $0 $0

5 $22,335 $0 $0

6 $22,071 $0 $0

7 $22,319 $0 $0

8 $22,220 $0 $0

9 $21,824 $0 $0

Month 10 $22,484 $0 $0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Mon 11 $22,26 $0 $0 $0

$22,516 $22,526 $22,467 $21,873 $22,335 $22,071 $22,319 $22,220 $21,824 $22,484 $22,26 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00 Page 3


Appendix

Expenses Payroll Sales and Marketing and Other Expenses Depreciation Rent Utilities Insurance Activities Payroll Taxes Training

$10,200 $1,000

$0 $300 $100 $0 $5,000 15% $0 $3,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,200 $1,000

$10,20 $1,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

$0 $300 $100 $0 $5,000 $0 $3,000

Total Operating Expenses

$19,600

$19,600

$19,600

$19,600

$19,600

$19,600

$19,600

$19,600

$19,600

$19,600

$19,60

Surplus Before Interest and Taxes EBITDA Interest Expense Taxes Incurred

$2,916

$2,926

$2,867

$2,273

$2,735

$2,471

$2,719

$2,620

$2,224

$2,884

$2,660

$2,916 $0 $0

$2,926 $0 $0

$2,867 $0 $0

$2,273 $0 $0

$2,735 $0 $0

$2,471 $0 $0

$2,719 $0 $0

$2,620 $0 $0

$2,224 $0 $0

$2,884 $0 $0

$2,660 $0 $0

Net Surplus Net Surplus/Funding

$2,916 12.95%

$2,926 12.99%

$2,867 12.76%

$2,273 10.39%

$2,735 12.25%

$2,471 11.20%

$2,719 12.18%

$2,620 11.79%

$2,224 10.19%

$2,884 12.82%

$2,660 11.95%

Table: Cash Flow Pro Forma Cash Flow Page 4


Appendix

Month

Month

Month

Month

Month

Month

Month

Month 8

1

2

3

4

5

6

7

$22,51 6 $22,51 6

$22,52 6 $22,52 6

$22,46 7 $22,46 7

$21,87 3 $21,87 3

$22,33 5 $22,33 5

$22,07 1 $22,07 1

$22,31 9 $22,31 9

$22,220

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

Month 9

Month

Month

M

10

11

12

$21,824

$22,484

$22,260

$22,

$22,220

$21,824

$22,484

$22,260

$22,

$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

$0

Cash Received Cash from Operations Cash Funding Subtotal Cash from Operations

Additional Cash Received Sales Tax, 0.00% $0 VAT, HST/GST Received New Current $0 Borrowing New Other $0 Liabilities (interestfree) New Long$0 term Liabilities Sales of $0

Page 5


Appendix

Other Current Assets Sales of Long-term Assets New Investment Received Subtotal Cash Received

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$22,51 6

$22,52 6

$22,46 7

$21,87 3

$22,33 5

$22,07 1

$22,31 9

$22,220

$21,824

$22,484

$22,260

$22,

Month 8

Month 9

Expenditures

Expenditures from Operations Cash Spending Bill Payments Subtotal Spent on Operations Additional Cash Spent Sales Tax, VAT,

Month

Month

Month

Month

Month

Month

Month

1

2

3

4

5

6

7

$10,20 0 $313

$10,20 0 $9,400

$10,20 0 $9,400

$10,20 0 $9,400

$10,20 0 $9,400

$10,20 0 $9,400

$10,20 0 $9,400

$10,200

$10,51 3

$19,60 0

$19,60 0

$19,60 0

$19,60 0

$19,60 0

$0

$0

$0

$0

$0

$0

Month

Month

M

10

11

12

$10,200

$10,200

$10,200

$10,

$9,400

$9,400

$9,400

$9,400

$9,4

$19,60 0

$19,600

$19,600

$19,600

$19,600

$19,

$0

$0

$0

$0

$0

$0 Page 6


Appendix

HST/GST Paid Out Principal Repayment of Current Borrowing Other Liabilities Principal Repayment Long-term Liabilities Principal Repayment Purchase Other Current Assets Purchase Long-term Assets Dividends Subtotal Cash Spent Net Cash Flow Cash Balance

$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

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0 $10,51 3

$0 $19,60 0

$0 $19,60 0

$0 $19,60 0

$0 $19,60 0

$0 $19,60 0

$0 $19,60 0

$0 $19,600

$0 $19,600

$0 $19,600

$0 $19,600

$0 $19,

$12,00 3 $83,50 3

$2,926

$2,867

$2,273

$2,735

$2,471

$2,719

$2,620

$2,224

$2,884

$2,660

$2,9

$86,42 8

$89,29 5

$91,56 8

$94,30 3

$96,77 4

$99,49 3

$102,11 2

$104,33 6

$107,21 9

$109,87 9

$112 3

Page 7


Appendix

Table: Balance Sheet Pro Forma Balance Sheet Month Assets

Current Assets Cash

Liabilities and Capital

Month

Month

Month

Month

Month

1

2

3

4

5

6

7

$83,503

$86,428

$89,295

$91,568

$94,303

$96,774

$99,493

$0

$0

$0

$0

$0

$0

$0

$83,503

$86,428

$89,295

$91,568

$94,303

$96,774

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$71,500

$83,503

$86,428

Month

Month

Month 8

Month 9

Month

Month

10

11

Starting Balances $71,500

Other Current $0 Assets Total Current $71,500 Assets Long-term Assets Long-term Assets Accumulated Depreciation Total Longterm Assets Total Assets

Month

1

2

$102,11 2 $0

$104,33 6 $0

$107,21 9 $0

$109,87 9 $0

$99,493

$102,11 2

$104,33 6

$107,21 9

$109,87 9

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$89,295

$91,568

$94,303

$96,774

$99,493

$102,11 2

$104,33 6

$107,21 9

$109,87 9

Month

Month

Month

Month

Month

Month 8

Month 9

3

4

5

6

7

Month 10

Month 11

Page 8


Appendix

Current Liabilities Accounts Payable Current Borrowing Other Current Liabilities Subtotal Current Liabilities

$0

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$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

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

Long-term Liabilities Total Liabilities

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$0

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

$9,087

Paid-in Capital Accumulated Surplus/Deficit Surplus/Deficit Total Capital

$80,000 ($8,500)

$80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 ($8,500) ($8,500) ($8,500) ($8,500) ($8,500) ($8,500) ($8,500) ($8,500)

$80,000 ($8,500)

$80,000 ($8,500)

$80,000 ($8,500)

$0 $71,500

$2,916 $74,416

$5,842 $77,342

$8,709 $80,209

$10,982 $82,482

$13,717 $85,217

$16,188 $87,688

$18,906 $90,406

$21,526 $93,026

$23,749 $95,249

$26,633 $98,133

Total $71,500 Liabilities and Capital

$83,503

$86,428

$89,295

$91,568

$94,303

$96,774

$99,493

$102,11 2

$104,33 6

$107,21 9

$29,293 $100,79 3 $109,87 9

Net Worth

$74,416

$77,342

$80,209

$82,482

$85,217

$87,688

$90,406

$93,026

$95,249

$98,133

$71,500

$100,79 3

Page 9


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.