Advocates for Legal Equal Access
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 | |||||||||||||
Law Firms | 0% | $0 | $1,245 | $1,400 | $2,645 | $3,254 | $3,300 | $2,985 | $2,745 | $2,978 | $3,004 | $2,845 | $3,145 |
Corporations | 0% | $0 | $1,000 | $1,500 | $2,254 | $3,000 | $2,845 | $2,900 | $3,005 | $3,245 | $2,995 | $3,356 | $3,345 |
Total Funding | $0 | $2,245 | $2,900 | $4,899 | $6,254 | $6,145 | $5,885 | $5,750 | $6,223 | $5,999 | $6,201 | $6,490 | |
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 | |
Law Firms | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Corporations | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cost of Funding | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
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 | ||
Al | 0% | $0 | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Adminstrative assistant/paralegal | 0% | $0 | $0 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 0 | 0 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
Total Payroll | $0 | $0 | $1,600 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 |
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 | $2,245 | $2,900 | $4,899 | $6,254 | $6,145 | $5,885 | $5,750 | $6,223 | $5,999 | $6,201 | $6,490 | |
Direct Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Direct Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Gross Surplus | $0 | $2,245 | $2,900 | $4,899 | $6,254 | $6,145 | $5,885 | $5,750 | $6,223 | $5,999 | $6,201 | $6,490 | |
Gross Surplus % | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
Expenses | |||||||||||||
Payroll | $0 | $0 | $1,600 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | |
Sales and Marketing and Other Expenses | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Depreciation | $78 | $78 | $78 | $78 | $78 | $78 | $78 | $78 | $78 | $78 | $78 | $78 | |
Web site + DSL | $135 | $135 | $135 | $135 | $135 | $135 | $135 | $135 | $135 | $135 | $135 | $135 | |
Utilities | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Insurance | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | $175 | |
Rent | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Payroll Taxes | 15% | $0 | $0 | $240 | $615 | $615 | $615 | $615 | $615 | $615 | $615 | $615 | $615 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $1,038 | $1,038 | $2,878 | $5,753 | $5,753 | $5,753 | $5,753 | $5,753 | $5,753 | $5,753 | $5,753 | $5,753 | |
Surplus Before Interest and Taxes | ($1,038) | $1,207 | $22 | ($854) | $501 | $392 | $132 | ($3) | $470 | $246 | $448 | $737 | |
EBITDA | ($960) | $1,285 | $100 | ($776) | $579 | $470 | $210 | $75 | $548 | $324 | $526 | $815 | |
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 | ($1,038) | $1,207 | $22 | ($854) | $501 | $392 | $132 | ($3) | $470 | $246 | $448 | $737 | |
Net Surplus/Funding | 0.00% | 53.76% | 0.76% | -17.43% | 8.01% | 6.38% | 2.24% | -0.05% | 7.55% | 4.10% | 7.22% | 11.36% |
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 | $2,245 | $2,900 | $4,899 | $6,254 | $6,145 | $5,885 | $5,750 | $6,223 | $5,999 | $6,201 | $6,490 | |
Subtotal Cash from Operations | $0 | $2,245 | $2,900 | $4,899 | $6,254 | $6,145 | $5,885 | $5,750 | $6,223 | $5,999 | $6,201 | $6,490 | |
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 | $2,245 | $2,900 | $4,899 | $6,254 | $6,145 | $5,885 | $5,750 | $6,223 | $5,999 | $6,201 | $6,490 | |
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 | $1,600 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | $4,100 | |
Bill Payments | $32 | $960 | $968 | $1,213 | $1,575 | $1,575 | $1,575 | $1,575 | $1,575 | $1,575 | $1,575 | $1,575 | |
Subtotal Spent on Operations | $32 | $960 | $2,568 | $5,313 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | |
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 | $32 | $960 | $2,568 | $5,313 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | $5,675 | |
Net Cash Flow | ($32) | $1,285 | $332 | ($414) | $579 | $470 | $210 | $75 | $548 | $324 | $526 | $815 | |
Cash Balance | $5,068 | $6,353 | $6,685 | $6,272 | $6,851 | $7,321 | $7,531 | $7,606 | $8,154 | $8,478 | $9,004 | $9,819 |
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 | $5,100 | $5,068 | $6,353 | $6,685 | $6,272 | $6,851 | $7,321 | $7,531 | $7,606 | $8,154 | $8,478 | $9,004 | $9,819 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $5,100 | $5,068 | $6,353 | $6,685 | $6,272 | $6,851 | $7,321 | $7,531 | $7,606 | $8,154 | $8,478 | $9,004 | $9,819 |
Long-term Assets | |||||||||||||
Long-term Assets | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 | $4,700 |
Accumulated Depreciation | $0 | $78 | $156 | $234 | $312 | $390 | $468 | $546 | $624 | $702 | $780 | $858 | $936 |
Total Long-term Assets | $4,700 | $4,622 | $4,544 | $4,466 | $4,388 | $4,310 | $4,232 | $4,154 | $4,076 | $3,998 | $3,920 | $3,842 | $3,764 |
Total Assets | $9,800 | $9,690 | $10,897 | $11,151 | $10,660 | $11,161 | $11,553 | $11,685 | $11,682 | $12,152 | $12,398 | $12,846 | $13,583 |
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 | $928 | $928 | $1,160 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 |
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 | $928 | $928 | $1,160 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $928 | $928 | $1,160 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 | $1,523 |
Paid-in Capital | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Accumulated Surplus/Deficit | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) | ($200) |
Surplus/Deficit | $0 | ($1,038) | $169 | $191 | ($663) | ($162) | $230 | $362 | $359 | $829 | $1,075 | $1,523 | $2,260 |
Total Capital | $9,800 | $8,762 | $9,969 | $9,991 | $9,137 | $9,638 | $10,030 | $10,162 | $10,159 | $10,629 | $10,875 | $11,323 | $12,060 |
Total Liabilities and Capital | $9,800 | $9,690 | $10,897 | $11,151 | $10,660 | $11,161 | $11,553 | $11,685 | $11,682 | $12,152 | $12,398 | $12,846 | $13,583 |
Net Worth | $9,800 | $8,762 | $9,969 | $9,991 | $9,137 | $9,638 | $10,030 | $10,162 | $10,159 | $10,629 | $10,875 | $11,323 | $12,060 |