Transitional Housing of Pittsburgh is a start-up not for profit social service agency serving the greater Pittsburgh area. The organization was founded by Amy Rand who has both the practical experience and the education to lead the organization. Amy is currently working on assembling a strong Board of Trustees which will be invaluable for the organization.
Services
Transitional Housing of Pittsburgh is an organization that provides transitional housing and life skill training for women. It offers assistance to women, frequently homeless, as they move from dependent, often abusive relationships into independent, self-sufficient lifestyles. Additionally, it assists clients in child reunification. This is particularly important as 80% of the clients have children but no custody.
This is the city’s only women-only facility and the only one with long-term transitional housing. All other shelters only offer 30 days or less of housing whereas Transitional Housing offers up to two years. On staff is a chemical dependency counselor, AIDS counselor, and a family reunification counselor to assist clients.
The facility provides clients within an eight-step program that teaches them necessary life skills. This collaborative approach to empowerment is the keystone to developing self-sufficiency in the clients. The steps include personal development, vocational training, substance abuse counseling, interpersonal skills building, community involvement, leisure activities, and independent living skills.
The Market
Transitional Housing has identified two distinct market segments of customers based on age; those who are under 30 and those who are 30 and over. The distinction is important because of the high percentage of clients with children, and those in the younger market segment having far younger children. The under 30 age group is growing annually at 9%, and the 30 and over age group growing at 8%. The two groups respectively have 165,454 and 158,745 potential clients. The overwhelming majority of clients come from lower socio-economic population groups. These segments can be difficult to communicate with, yet their use of Transitional Housing’s services would give them some profound benefits.
Management
Amy Rand is the driving force behind the organization and fills the Executive Director role. Amy earned a B.S. degree in Sociology from Case Western Reserve University and a Master’s in Non-for-Profit Management from the University of Pittsburgh. Additionally, she has several years of social service project management. While working as the program manager of Pennsylvania’s largest domestic abuse relief service provider, Amy developed a proactive empowerment program which has become the foundation for Transitional Housing’s collaborative approach to empowerment. During and since her tenure as program manager, Amy has developed a comprehensive network of personal and professional contacts with key community leaders. This will be instrumental in raising the profile of Transitional Housing within the community as well as having a significant impact on fundraising activities.
Transitional Housing’s mission is to provide women of Pittsburgh a safe transitional housing alternative, teach a multitude of skills to empower the women to self-sufficiency, and facilitate the possible reunification of clients with their children.
Discover the simplest way to create detailed graphs for your business plan.
Transitional Housing was founded as a Pittsburgh, PA based not for profit 501(c)(3) organization. Upon the Board of Trustees’ final approval, Amy Rand will be the Executive Director. The nonprofit will serve female clients in need of transitional housing and life skills training.
The goal of the organization is to provide interim housing and skill training so that clients become empowered, independent individuals. Transitional Housing’s services are unique in their female-only clientele, long-duration transitional housing, and comprehensive empowerment program. Transitional Housing will make a significant impact on the Pittsburgh community, in both short-term relief, and long-term skill development and empowerment.
Real property will take the form of the old Motel 6 building located in downtown Pittsburgh. This building has been identified as an ideal facility for Transitional Housing. The asking price for the building is $2 million with $100,000 down. The building will need some renovation, primarily fixing up the 65 different rooms. A donor has approached us willing to buy the building, with the intent of leasing it back to Transitional Housing long term, for the organization’s use.
Transitional Housing will require the following real property and equipment for the start-up phase.
Start-up | |
Requirements | |
Start-up Expenses | |
Legal | $3,000 |
Stationery etc. | $500 |
Brochures | $500 |
Other | $0 |
Total Start-up Expenses | $4,000 |
Start-up Assets | |
Cash Required | $18,000 |
Other Current Assets | $23,000 |
Long-term Assets | $0 |
Total Assets | $41,000 |
Total Requirements | $45,000 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
Start-up Funding | |
Start-up Expenses to Fund | $4,000 |
Start-up Assets to Fund | $41,000 |
Total Funding Required | $45,000 |
Assets | |
Non-cash Assets from Start-up | $23,000 |
Cash Requirements from Start-up | $18,000 |
Additional Cash Raised | $0 |
Cash Balance on Starting Date | $18,000 |
Total Assets | $41,000 |
Liabilities and Capital | |
Liabilities | |
Current Borrowing | $0 |
Long-term Liabilities | $0 |
Accounts Payable (Outstanding Bills) | $0 |
Other Current Liabilities (interest-free) | $0 |
Total Liabilities | $0 |
Capital | |
Planned Investment | |
Private Donation | $45,000 |
Investor 2 | $0 |
Other | $0 |
Additional Investment Requirement | $0 |
Total Planned Investment | $45,000 |
Loss at Start-up (Start-up Expenses) | ($4,000) |
Total Capital | $41,000 |
Total Capital and Liabilities | $41,000 |
Total Funding | $45,000 |
Transitional Housing has been formed as a 501(c)(3) not for profit entity. The purpose of this organization is to offer women transitional housing as well as teach skills that allow these women to become self-sufficient, independent, and drug and alcohol free. Additionally Transitional Housing will, when applicable, assist women who attempt to gain custody of their children.
Funds for the organization will come from many sources including: silent auctions and other in house fund raising efforts, local government funds, foundation grants, corporate and individual donations, and money from the federal government. Amy Rand has in-depth experience with fundraising as well as grant writing and this will be instrumental in Transitional Housing’s search for funding.
Transitional Housing of Pittsburgh is an organization that provides transitional housing and life skill training for women. It offers assistance to women, frequently homeless, as they move from dependent, often abusive relationships into independent, self-sufficient lifestyles. Additionally, it assists clients in child reunification. This is particularly important as 80% of the clients have children but no custody.
This is the city’s only women-only facility and the only one with long-term transitional housing. All other shelters only offer 30 days or less of housing whereas Transitional Housing offers up to two years. On staff is a chemical dependency counselor, AIDS counselor, and a family reunification counselor to assist clients.
Transitional Housing offers 65 rooms, each with its own kitchen facility to homeless women. Each client is allowed to stay for up to one year as long as they are clean and sober (random drug and alcohol testing determines this), and have no other place to go. Additionally, each client must be an active participant of the program:
Collaborative Approach to Empowering Individual. This program is an eight-step program to develop self-sufficient clients. The different elements of the program are:
Transitional Housing is a women-only facility. This is of significant value to the clients as it eliminates the possibility of sexual abuse from the opposite sex within the facility. This is Transitional Housing’s competitive edge, for more detail please refer to section 5.1.
Transitional Housing has identified two distinct market segments of customers based on age; those who are under 30 and those who are 30 and over. The distinction is important because of the high percentage of clients with children, and those in the younger market segment having far younger children. The under 30 age group is growing annually at 9%, and the 30 and over age group growing at 8%. The two groups respectively have 165,454 and 158,745 potential clients. The overwhelming majority of clients come from lower socio-economic population groups. These segments can be difficult to communicate with, yet their use of Transitional Housing’s services would give them some profound benefits. The good news is if the people are willing to accept help from Transitional Housing they are far more likely to be able to get out of the dire circumstances that they currently face.
The other service providers are temporary shelters that only allow stays of less than 30 days. These service providers are only housing shelters, they do not offer the in-depth self empowerment programs. Some alternative service providers take the form of religious service organizations that assist clients, but on a much smaller scale. The lack of true competition makes Transitional Housing the premier source of interim housing and life skill training. Other agencies would like to offer the comprehensive services that Transitional Housing offers but are unable to because of organizational design constraints or economic restraints. The following sections provide demographic detail regarding the target market.
Transitional Housing has segmented the market into two distinct categories: women under 30 years old and those 30 and older. This is a significant distinction since the children of the younger group will be younger as well. Some demographic information that is relevant to both groups:
Market Analysis | |||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||
Potential Customers | Growth | CAGR | |||||
Under 30 years old | 9% | 165,454 | 180,345 | 196,576 | 214,268 | 233,552 | 9.00% |
30 years or older | 8% | 158,745 | 171,445 | 185,161 | 199,974 | 215,972 | 8.00% |
Total | 8.51% | 324,199 | 351,790 | 381,737 | 414,242 | 449,524 | 8.51% |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
Transitional Housing has chosen to target their services to these two market segments because they are the segments that are in the most need of the services. Because of a variety of factors including: time in prison, abusive relationships, alcohol and drug dependencies, and exposure/participation to prostitution, these women have nowhere else to go, no one to turn to. They are in desperate need of transitional housing as well as life skills to empower them to self sufficiency.
Transitional Housing has chosen to serve only women because women who are homeless are far more vulnerable than homeless men. They need more protection because of the increased risk of sexual abuse.
The services provided within this industry are typically broken down into two segments: transitional housing and life skills.
The following section, 4.3 offers an analysis of the alternative service providers.
Housing
Please note that the shelters are only housing and do not offer any type of life skills.
Life skills
There are several service providers that teach these skills. They are typically religious based organizations or community based organizations. The courses are generally one hour long and span a few weeks. They are far less comprehensive than Transitional Housing’s and many people miss several sessions because they are taught over a longer period of time.
Transitional Housing is in an excellent market position to be able to attract good talent and funds due to their sustainable competitive edge. This edge is Transitional Housing’s ability to provide women-only housing that lasts longer and is more complete than traditional “transition housing.”
No one else is able to offer the benefits of a single gender, reasonably long term, housing with skills training. Transitional Housing will be active in their marketing campaign to increase awareness of the facility to the target clients, as well as visibility within the community to aid fundraising efforts, and acquire referrals from other community service agencies.
Transitional Housing has three distinct competitive edges that will be leveraged to help make it a successful service provider with sufficient financial resources:
To develop good business strategies, perform a SWOT analysis of your business. It's easy with our free guide and template. Learn how to perform a SWOT analysis
Transitional Housing’s marketing strategy will be two pronged. One goal is to raise awareness about the services to the target customers. The second goal is to increase awareness of Transitional Housing within the community for fundraising efforts.
A main thrust of the effort of increasing visibility within the community of users will be through the development of relationships with other social service providers such as domestic abuse shelters, alcohol treatment centers, prisons, and half-way houses (the interim step after prison and before being totally free). These are the “front line workers” who are in the best position to make referrals to people who are truly in need of the services. By developing a relationship with these organizations, a constant flow of clients can be accomplished. These relationships can be developed through multiple means including frequent open houses for staff of the organizations to allow them to get a “feel” for things as well as maintaining relationships with the individuals that work there as well.
Transitional Housing will also campaign to develop visibility within the community for both client recruitment as well as corporate fundraising. Activities such as participation on radio shows, sponsorship of one day events/seminars, and other public events that are designed to give a presence to Transitional Housing within the community as a leader and an effective social service organization. Fundraising efforts are made more efficient when people know about Transitional Housing and the positive work they are doing.
Transitional Housing will rely on many different sources of funds, in part to increase the overall budget, in part to decrease the reliance on any one source. Some of the funds are available immediately, others such as the grants require six to eight month lead/applications periods.
The funding forecast indicates that it is expected to take six months before there are sufficient funds to to get operations rolling. With the expected opening date of month seven, initial funding will trickle in from month two to four with larger quantities arriving around months five and six.
The initial funds will be spent in preparation for the start-up, however Transitional Housing will need a substantial amount for the down payment of the building. Please note that the fundraising effort is not a static one time or annual event. In order to gain true operating sufficiency, Transitional Housing will need to raise funds throughout the year. Consequently, one of the main tasks of the Executive Director will be fundraising.
Funding Forecast | |||
Year 1 | Year 2 | Year 3 | |
Funding | |||
United Way | $115,000 | $125,000 | $135,000 |
Federal Government | $70,000 | $75,000 | $75,000 |
Local Government | $38,500 | $15,000 | $15,000 |
Corporations/Individuals | $60,000 | $65,000 | $65,000 |
Organizational Activities | $20,500 | $15,000 | $17,000 |
Total Funding | $304,000 | $295,000 | $307,000 |
Direct Cost of Funding | Year 1 | Year 2 | Year 3 |
Expenses for Organizational Activities | $2,460 | $1,800 | $2,040 |
Administrative Expenses | $41,040 | $39,825 | $41,445 |
Subtotal Cost of Funding | $43,500 | $41,625 | $43,485 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
Transitional Housing has identified several important milestones for the organization. Each one must be achieved in a timely manner in order to stay on schedule. Please review the following table for a breakdown of the pertinent information regarding the milestones.
Milestones | |||||
Milestone | Start Date | End Date | Budget | Manager | Department |
Business plan completion | 1/1/2004 | 2/1/2004 | $0 | Amy | Business development |
Board of Trustees established | 1/1/2004 | 2/15/2004 | $0 | Amy | Business Development |
First large funds secured | 1/1/2004 | 3/30/2004 | $0 | Amy | Fundraising |
Operational sufficiency | 1/1/2004 | 4/30/2005 | $0 | Amy | Operations |
Totals | $0 |
The website will be used as a resource to provide information to clients, referral social service agencies, and donors. The site will be a straightforward source of information including details regarding the empowerment program, information about the facilities, and biographical information about the staff.
The website will be marketed to all referral social service agencies as well as to prospective corporate and individual donors.
A programmer (friend of a staff member) has been identified as someone who is willing to develop the site. There will be no labor costs associated with the website as the developmental labor will be donated.
Amy Rand received her undergraduate degree in sociology from Case Western Reserve. While at Case Amy was the chairperson of the Volunteer Student Organization. Amy’s duties for this organization include leadership and member motivation, fundraising, and marketing within the school environment as well as the local community. Following Case, Amy applied and was accepted to The University or Pittsburgh’s Masters in Nonprofit Management. This two year Masters program had an emphasis on management skills, and also encouraged students to undertake practical, one-on-one clinical work, to gain experience managing and being managed in a work environment. Amy’s time in the practicum program was spent working with women victims of domestic abuse.
After graduation, Amy went to work for the largest service provider for survivors of domestic abuse in Pennsylvania. This was a relief agency that offered daytime training and counseling. When she entered the organization as a program manager, they offered some counseling which was geared toward making the person feel better, a reactive approach. Over the three years that Amy spent there she steered the program so that it became more proactive, empowering the women to effect positive change in their life. While this was rewarding, she longed to have more control and ability to effect change within the organization. Amy began discussions with local community leaders to determine the level of support for a new social service organization. She found that there was money/funds to be had for a well run, efficient social service organization that would offer transitional housing and a comprehensive empowerment program, services that were absent from the market. Before she even began the business plan she was informally assembling the Board of Trustees and arranging sources of funds.
Board of Trustees- This board will be composed of 15 different influential community leaders. The board will be used as a resource for business decisions and management as well as a source of fundraising. Transitional Housing recognizes the significant value that a board can offer.
Personnel Plan | |||
Year 1 | Year 2 | Year 3 | |
Executive Director | $20,000 | $24,000 | $30,000 |
Associate Director | $21,000 | $36,000 | $36,000 |
Chemical Dependency Counselor | $12,000 | $24,000 | $24,000 |
AIDS Counselor | $4,800 | $9,600 | $9,600 |
Family Reunification Counselor | $12,000 | $24,000 | $24,000 |
Admin Staff | $7,000 | $12,000 | $12,000 |
Admin Staff | $6,000 | $12,000 | $12,000 |
Total People | 7 | 7 | 7 |
Total Payroll | $82,800 | $141,600 | $147,600 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
The following sections outline important financial information.
The following table includes important financial assumptions.
General Assumptions | |||
Year 1 | Year 2 | Year 3 | |
Plan Month | 1 | 2 | 3 |
Current Interest Rate | 10.00% | 10.00% | 10.00% |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% |
Tax Rate | 0.00% | 0.00% | 0.00% |
Other | 0 | 0 | 0 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
The Break-even Analysis is shown in the following table and chart.
Break-even Analysis | |
Monthly Revenue Break-even | $17,643 |
Assumptions: | |
Average Percent Variable Cost | 14% |
Estimated Monthly Fixed Cost | $15,118 |
The following table and charts show projected surplus and deficit.
Surplus and Deficit | |||
Year 1 | Year 2 | Year 3 | |
Funding | $304,000 | $295,000 | $307,000 |
Direct Cost | $43,500 | $41,625 | $43,485 |
Other Costs of Funding | $0 | $0 | $0 |
Total Direct Cost | $43,500 | $41,625 | $43,485 |
Gross Surplus | $260,500 | $253,375 | $263,515 |
Gross Surplus % | 85.69% | 85.89% | 85.84% |
Expenses | |||
Payroll | $82,800 | $141,600 | $147,600 |
Account Name | $0 | $0 | $0 |
Depreciation | $4,596 | $4,596 | $4,596 |
Leased Building | $48,000 | $48,000 | $48,000 |
Utilities | $24,000 | $24,000 | $24,000 |
Insurance | $9,600 | $9,600 | $9,600 |
Payroll Taxes | $12,420 | $21,240 | $22,140 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $181,416 | $249,036 | $255,936 |
Surplus Before Interest and Taxes | $79,084 | $4,339 | $7,579 |
EBITDA | $83,680 | $8,935 | $12,175 |
Interest Expense | $0 | $0 | $0 |
Taxes Incurred | $0 | $0 | $0 |
Net Surplus | $79,084 | $4,339 | $7,579 |
Net Surplus/Funding | 26.01% | 1.47% | 2.47% |
The following table and chart illustrate projected cash flow.
Pro Forma Cash Flow | |||
Year 1 | Year 2 | Year 3 | |
Cash Received | |||
Cash from Operations | |||
Cash Funding | $304,000 | $295,000 | $307,000 |
Subtotal Cash from Operations | $304,000 | $295,000 | $307,000 |
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 | $304,000 | $295,000 | $307,000 |
Expenditures | Year 1 | Year 2 | Year 3 |
Expenditures from Operations | |||
Cash Spending | $82,800 | $141,600 | $147,600 |
Bill Payments | $129,040 | $141,071 | $146,998 |
Subtotal Spent on Operations | $211,840 | $282,671 | $294,598 |
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 | $0 | $0 | $0 |
Purchase Other Current Assets | $0 | $0 | $0 |
Purchase Long-term Assets | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal Cash Spent | $211,840 | $282,671 | $294,598 |
Net Cash Flow | $92,160 | $12,329 | $12,402 |
Cash Balance | $110,160 | $122,489 | $134,891 |
The following table shows the projected balance sheet.
Pro Forma Balance Sheet | |||
Year 1 | Year 2 | Year 3 | |
Assets | |||
Current Assets | |||
Cash | $110,160 | $122,489 | $134,891 |
Other Current Assets | $23,000 | $23,000 | $23,000 |
Total Current Assets | $133,160 | $145,489 | $157,891 |
Long-term Assets | |||
Long-term Assets | $0 | $0 | $0 |
Accumulated Depreciation | $4,596 | $9,192 | $13,788 |
Total Long-term Assets | ($4,596) | ($9,192) | ($13,788) |
Total Assets | $128,564 | $136,297 | $144,103 |
Liabilities and Capital | Year 1 | Year 2 | Year 3 |
Current Liabilities | |||
Accounts Payable | $8,480 | $11,874 | $12,101 |
Current Borrowing | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 |
Subtotal Current Liabilities | $8,480 | $11,874 | $12,101 |
Long-term Liabilities | $0 | $0 | $0 |
Total Liabilities | $8,480 | $11,874 | $12,101 |
Paid-in Capital | $45,000 | $45,000 | $45,000 |
Accumulated Surplus/Deficit | ($4,000) | $75,084 | $79,423 |
Surplus/Deficit | $79,084 | $4,339 | $7,579 |
Total Capital | $120,084 | $124,423 | $132,002 |
Total Liabilities and Capital | $128,564 | $136,297 | $144,103 |
Net Worth | $120,084 | $124,423 | $132,002 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
The following table presents standard ratios. Transitional Housing has a Standard Industrial Classification (SIC) code: 8322.0304 – Emergency Shelters. Industry profile ratios are shown for comparison.
Ratio Analysis | ||||
Year 1 | Year 2 | Year 3 | Industry Profile | |
Funding Growth | 0.00% | -2.96% | 4.07% | 7.72% |
Percent of Total Assets | ||||
Other Current Assets | 17.89% | 16.87% | 15.96% | 32.31% |
Total Current Assets | 103.57% | 106.74% | 109.57% | 56.30% |
Long-term Assets | -3.57% | -6.74% | -9.57% | 43.70% |
Total Assets | 100.00% | 100.00% | 100.00% | 100.00% |
Current Liabilities | 6.60% | 8.71% | 8.40% | 23.57% |
Long-term Liabilities | 0.00% | 0.00% | 0.00% | 28.65% |
Total Liabilities | 6.60% | 8.71% | 8.40% | 52.22% |
Net Worth | 93.40% | 91.29% | 91.60% | 47.78% |
Percent of Funding | ||||
Funding | 100.00% | 100.00% | 100.00% | 100.00% |
Gross Surplus | 85.69% | 85.89% | 85.84% | 100.00% |
Selling, General & Administrative Expenses | #NAME? | 84.42% | 83.37% | 78.74% |
Advertising Expenses | 0.00% | 0.00% | 0.00% | 0.97% |
Surplus Before Interest and Taxes | 26.01% | 1.47% | 2.47% | 1.90% |
Main Ratios | ||||
Current | 15.70 | 12.25 | 13.05 | 2.18 |
Quick | 15.70 | 12.25 | 13.05 | 1.77 |
Total Debt to Total Assets | 6.60% | 8.71% | 8.40% | 3.01% |
Pre-tax Return on Net Worth | 65.86% | 3.49% | 5.74% | 58.63% |
Pre-tax Return on Assets | 61.51% | 3.18% | 5.26% | 7.27% |
Additional Ratios | Year 1 | Year 2 | Year 3 | |
Net Surplus Margin | 26.01% | 1.47% | 2.47% | n.a |
Return on Equity | 65.86% | 3.49% | 5.74% | n.a |
Activity Ratios | ||||
Accounts Payable Turnover | 16.22 | 12.17 | 12.17 | n.a |
Payment Days | 27 | 26 | 30 | n.a |
Total Asset Turnover | 2.36 | 2.16 | 2.13 | n.a |
Debt Ratios | ||||
Debt to Net Worth | 0.07 | 0.10 | 0.09 | n.a |
Current Liab. to Liab. | 1.00 | 1.00 | 1.00 | n.a |
Liquidity Ratios | ||||
Net Working Capital | $124,680 | $133,615 | $145,790 | n.a |
Interest Coverage | 0.00 | 0.00 | 0.00 | n.a |
Additional Ratios | ||||
Assets to Funding | 0.42 | 0.46 | 0.47 | n.a |
Current Debt/Total Assets | 7% | 9% | 8% | n.a |
Acid Test | 15.70 | 12.25 | 13.05 | n.a |
Funding/Net Worth | 2.53 | 2.37 | 2.33 | n.a |
Dividend Payout | 0.00 | 0.00 | 0.00 | n.a |
Funding 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 | ||
Funding | |||||||||||||
United Way | 0% | $0 | $0 | $0 | $60,000 | $0 | $0 | $0 | $0 | $55,000 | $0 | $0 | $0 |
Federal Government | 0% | $0 | $0 | $10,000 | $10,000 | $5,000 | $25,000 | $0 | $0 | $0 | $0 | $20,000 | $0 |
Local Government | 0% | $0 | $0 | $12,000 | $0 | $20,000 | $0 | $1,500 | $5,000 | $0 | $0 | $0 | $0 |
Corporations/Individuals | 0% | $0 | $0 | $5,000 | $2,500 | $7,000 | $6,000 | $15,000 | $9,000 | $12,000 | $0 | $2,000 | $1,500 |
Organizational Activities | 0% | $0 | $0 | $0 | $0 | $8,000 | $0 | $0 | $500 | $0 | $12,000 | $0 | $0 |
Total Funding | $0 | $0 | $27,000 | $72,500 | $40,000 | $31,000 | $16,500 | $14,500 | $67,000 | $12,000 | $22,000 | $1,500 | |
Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenses for Organizational Activities | $0 | $0 | $0 | $0 | $960 | $0 | $0 | $60 | $0 | $1,440 | $0 | $0 | |
Administrative Expenses | $0 | $0 | $3,645 | $9,788 | $5,400 | $4,185 | $2,228 | $1,958 | $9,045 | $1,620 | $2,970 | $203 | |
Subtotal Cost of Funding | $0 | $0 | $3,645 | $9,788 | $6,360 | $4,185 | $2,228 | $2,018 | $9,045 | $3,060 | $2,970 | $203 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
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 | ||
Executive Director | 0% | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Associate Director | 0% | $0 | $0 | $0 | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Chemical Dependency Counselor | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
AIDS Counselor | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $800 | $800 | $800 | $800 | $800 | $800 |
Family Reunification Counselor | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Admin Staff | 0% | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Admin Staff | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total People | 0 | 0 | 1 | 1 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | |
Total Payroll | $0 | $0 | $2,000 | $2,000 | $2,000 | $6,000 | $11,800 | $11,800 | $11,800 | $11,800 | $11,800 | $11,800 |
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 | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Surplus and Deficit | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Funding | $0 | $0 | $27,000 | $72,500 | $40,000 | $31,000 | $16,500 | $14,500 | $67,000 | $12,000 | $22,000 | $1,500 | |
Direct Cost | $0 | $0 | $3,645 | $9,788 | $6,360 | $4,185 | $2,228 | $2,018 | $9,045 | $3,060 | $2,970 | $203 | |
Other Costs of Funding | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Direct Cost | $0 | $0 | $3,645 | $9,788 | $6,360 | $4,185 | $2,228 | $2,018 | $9,045 | $3,060 | $2,970 | $203 | |
Gross Surplus | $0 | $0 | $23,355 | $62,713 | $33,640 | $26,815 | $14,273 | $12,483 | $57,955 | $8,940 | $19,030 | $1,298 | |
Gross Surplus % | 0.00% | 0.00% | 86.50% | 86.50% | 84.10% | 86.50% | 86.50% | 86.09% | 86.50% | 74.50% | 86.50% | 86.50% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $2,000 | $2,000 | $2,000 | $6,000 | $11,800 | $11,800 | $11,800 | $11,800 | $11,800 | $11,800 | |
Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $383 | $383 | $383 | $383 | $383 | $383 | $383 | $383 | $383 | $383 | $383 | $383 | |
Leased Building | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Utilities | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Insurance | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Payroll Taxes | 15% | $0 | $0 | $300 | $300 | $300 | $900 | $1,770 | $1,770 | $1,770 | $1,770 | $1,770 | $1,770 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $7,183 | $7,183 | $9,483 | $9,483 | $9,483 | $14,083 | $20,753 | $20,753 | $20,753 | $20,753 | $20,753 | $20,753 | |
Surplus Before Interest and Taxes | ($7,183) | ($7,183) | $13,872 | $53,230 | $24,157 | $12,732 | ($6,481) | ($8,271) | $37,202 | ($11,813) | ($1,723) | ($19,456) | |
EBITDA | ($6,800) | ($6,800) | $14,255 | $53,613 | $24,540 | $13,115 | ($6,098) | ($7,888) | $37,585 | ($11,430) | ($1,340) | ($19,073) | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Surplus | ($7,183) | ($7,183) | $13,872 | $53,230 | $24,157 | $12,732 | ($6,481) | ($8,271) | $37,202 | ($11,813) | ($1,723) | ($19,456) | |
Net Surplus/Funding | 0.00% | 0.00% | 51.38% | 73.42% | 60.39% | 41.07% | -39.28% | -57.04% | 55.53% | -98.44% | -7.83% | -1297.03% |
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 Funding | $0 | $0 | $27,000 | $72,500 | $40,000 | $31,000 | $16,500 | $14,500 | $67,000 | $12,000 | $22,000 | $1,500 | |
Subtotal Cash from Operations | $0 | $0 | $27,000 | $72,500 | $40,000 | $31,000 | $16,500 | $14,500 | $67,000 | $12,000 | $22,000 | $1,500 | |
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 | $0 | $0 | $27,000 | $72,500 | $40,000 | $31,000 | $16,500 | $14,500 | $67,000 | $12,000 | $22,000 | $1,500 | |
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 | $0 | $0 | $2,000 | $2,000 | $2,000 | $6,000 | $11,800 | $11,800 | $11,800 | $11,800 | $11,800 | $11,800 | |
Bill Payments | $227 | $6,800 | $6,932 | $10,950 | $16,773 | $13,408 | $11,849 | $10,791 | $10,822 | $17,416 | $11,627 | $11,448 | |
Subtotal Spent on Operations | $227 | $6,800 | $8,932 | $12,950 | $18,773 | $19,408 | $23,649 | $22,591 | $22,622 | $29,216 | $23,427 | $23,248 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
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 | $227 | $6,800 | $8,932 | $12,950 | $18,773 | $19,408 | $23,649 | $22,591 | $22,622 | $29,216 | $23,427 | $23,248 | |
Net Cash Flow | ($227) | ($6,800) | $18,069 | $59,550 | $21,227 | $11,593 | ($7,149) | ($8,091) | $44,378 | ($17,216) | ($1,427) | ($21,748) | |
Cash Balance | $17,773 | $10,973 | $29,042 | $88,592 | $109,819 | $121,411 | $114,263 | $106,172 | $150,550 | $133,335 | $131,908 | $110,160 |
We recommend using LivePlan as the easiest way to create automatic financials for your own business plan.
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 | $18,000 | $17,773 | $10,973 | $29,042 | $88,592 | $109,819 | $121,411 | $114,263 | $106,172 | $150,550 | $133,335 | $131,908 | $110,160 |
Other Current Assets | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 |
Total Current Assets | $41,000 | $40,773 | $33,973 | $52,042 | $111,592 | $132,819 | $144,411 | $137,263 | $129,172 | $173,550 | $156,335 | $154,908 | $133,160 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $383 | $766 | $1,149 | $1,532 | $1,915 | $2,298 | $2,681 | $3,064 | $3,447 | $3,830 | $4,213 | $4,596 |
Total Long-term Assets | $0 | ($383) | ($766) | ($1,149) | ($1,532) | ($1,915) | ($2,298) | ($2,681) | ($3,064) | ($3,447) | ($3,830) | ($4,213) | ($4,596) |
Total Assets | $41,000 | $40,390 | $33,207 | $50,893 | $110,060 | $130,904 | $142,113 | $134,582 | $126,108 | $170,103 | $152,505 | $150,695 | $128,564 |
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 | $6,573 | $6,573 | $10,387 | $16,325 | $13,011 | $11,489 | $10,438 | $10,235 | $17,028 | $11,242 | $11,155 | $8,480 |
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 | $6,573 | $6,573 | $10,387 | $16,325 | $13,011 | $11,489 | $10,438 | $10,235 | $17,028 | $11,242 | $11,155 | $8,480 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $6,573 | $6,573 | $10,387 | $16,325 | $13,011 | $11,489 | $10,438 | $10,235 | $17,028 | $11,242 | $11,155 | $8,480 |
Paid-in Capital | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
Accumulated Surplus/Deficit | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) | ($4,000) |
Surplus/Deficit | $0 | ($7,183) | ($14,366) | ($494) | $52,736 | $76,893 | $89,625 | $83,144 | $74,874 | $112,076 | $100,263 | $98,540 | $79,084 |
Total Capital | $41,000 | $33,817 | $26,634 | $40,506 | $93,736 | $117,893 | $130,625 | $124,144 | $115,874 | $153,076 | $141,263 | $139,540 | $120,084 |
Total Liabilities and Capital | $41,000 | $40,390 | $33,207 | $50,893 | $110,060 | $130,904 | $142,113 | $134,582 | $126,108 | $170,103 | $152,505 | $150,695 | $128,564 |
Net Worth | $41,000 | $33,817 | $26,634 | $40,506 | $93,736 | $117,892 | $130,624 | $124,144 | $115,873 | $153,076 | $141,263 | $139,540 | $120,084 |