Transitional Housing of Pittsburgh

Start your own business plan »

Emergency Shelters Business Plan

Appendix

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