Gamehenge Tapers Co-op

Start your own business plan »

Nonprofit Recording Co-op 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
Tapers 0% $0 $1,545 $2,587 $3,654 $3,878 $4,578 $3,254 $4,578 $2,587 $3,124 $3,385 $4,124
Memebership income 0% $160 $360 $400 $480 $400 $320 $280 $200 $360 $280 $200 $360
Total Funding $160 $1,905 $2,987 $4,134 $4,278 $4,898 $3,534 $4,778 $2,947 $3,404 $3,585 $4,484
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
Tapers $0 $1,391 $2,328 $3,289 $3,490 $4,120 $2,929 $4,120 $2,328 $2,812 $3,047 $3,712
Memebership income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cost of Funding $0 $1,391 $2,328 $3,289 $3,490 $4,120 $2,929 $4,120 $2,328 $2,812 $3,047 $3,712
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 30.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 $160 $1,905 $2,987 $4,134 $4,278 $4,898 $3,534 $4,778 $2,947 $3,404 $3,585 $4,484
Direct Cost $0 $1,391 $2,328 $3,289 $3,490 $4,120 $2,929 $4,120 $2,328 $2,812 $3,047 $3,712
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Direct Cost $0 $1,391 $2,328 $3,289 $3,490 $4,120 $2,929 $4,120 $2,328 $2,812 $3,047 $3,712
Gross Surplus $160 $515 $659 $845 $788 $778 $605 $658 $619 $592 $539 $772
Gross Surplus % 100.00% 27.01% 22.05% 20.45% 18.42% 15.88% 17.13% 13.77% 20.99% 17.40% 15.02% 17.23%
Expenses
Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales and Marketing and Other Expenses $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Depreciation $19 $19 $19 $19 $19 $19 $19 $19 $19 $19 $19 $19
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Rent $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $319 $319 $319 $319 $319 $319 $319 $319 $319 $319 $319 $319
Surplus Before Interest and Taxes ($159) $196 $340 $526 $469 $459 $286 $339 $300 $273 $220 $453
EBITDA ($140) $215 $359 $545 $488 $478 $305 $358 $319 $292 $239 $472
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($48) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Surplus ($111) $196 $340 $526 $469 $459 $286 $339 $300 $273 $220 $453
Net Surplus/Funding -69.56% 10.26% 11.37% 12.73% 10.96% 9.37% 8.10% 7.09% 10.17% 8.03% 6.12% 10.11%
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 $160 $1,905 $2,987 $4,134 $4,278 $4,898 $3,534 $4,778 $2,947 $3,404 $3,585 $4,484
Subtotal Cash from Operations $160 $1,905 $2,987 $4,134 $4,278 $4,898 $3,534 $4,778 $2,947 $3,404 $3,585 $4,484
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 $160 $1,905 $2,987 $4,134 $4,278 $4,898 $3,534 $4,778 $2,947 $3,404 $3,585 $4,484
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Bill Payments $8 $351 $3,235 $3,693 $4,624 $4,049 $5,007 $2,045 $5,583 $1,357 $3,021 $3,643
Subtotal Spent on Operations $8 $351 $3,235 $3,693 $4,624 $4,049 $5,007 $2,045 $5,583 $1,357 $3,021 $3,643
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 $8 $351 $3,235 $3,693 $4,624 $4,049 $5,007 $2,045 $5,583 $1,357 $3,021 $3,643
Net Cash Flow $152 $1,554 ($248) $441 ($346) $849 ($1,473) $2,733 ($2,636) $2,047 $564 $841
Cash Balance $402 $1,955 $1,708 $2,149 $1,803 $2,652 $1,180 $3,913 $1,277 $3,324 $3,888 $4,729
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 $250 $402 $1,955 $1,708 $2,149 $1,803 $2,652 $1,180 $3,913 $1,277 $3,324 $3,888 $4,729
Inventory $0 $0 $1,530 $2,561 $3,617 $3,839 $4,532 $3,221 $4,532 $3,204 $3,093 $3,351 $4,083
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $250 $402 $3,485 $4,269 $5,766 $5,642 $7,185 $4,401 $8,445 $4,480 $6,417 $7,239 $8,812
Long-term Assets
Long-term Assets $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150 $1,150
Accumulated Depreciation $0 $19 $38 $57 $76 $95 $114 $133 $152 $171 $190 $209 $228
Total Long-term Assets $1,150 $1,131 $1,112 $1,093 $1,074 $1,055 $1,036 $1,017 $998 $979 $960 $941 $922
Total Assets $1,400 $1,533 $4,597 $5,362 $6,840 $6,697 $8,221 $5,418 $9,443 $5,459 $7,377 $8,180 $9,734
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 $244 $3,113 $3,538 $4,490 $3,878 $4,943 $1,854 $5,540 $1,257 $2,900 $3,485 $4,585
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 $244 $3,113 $3,538 $4,490 $3,878 $4,943 $1,854 $5,540 $1,257 $2,900 $3,485 $4,585
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $244 $3,113 $3,538 $4,490 $3,878 $4,943 $1,854 $5,540 $1,257 $2,900 $3,485 $4,585
Paid-in Capital $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Accumulated Surplus/Deficit ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600)
Surplus/Deficit $0 ($111) $84 $424 $950 $1,419 $1,878 $2,164 $2,503 $2,803 $3,076 $3,296 $3,749
Total Capital $1,400 $1,289 $1,484 $1,824 $2,350 $2,819 $3,278 $3,564 $3,903 $4,203 $4,476 $4,696 $5,149
Total Liabilities and Capital $1,400 $1,533 $4,597 $5,362 $6,840 $6,697 $8,221 $5,418 $9,443 $5,459 $7,377 $8,180 $9,734
Net Worth $1,400 $1,289 $1,484 $1,824 $2,350 $2,819 $3,278 $3,564 $3,903 $4,203 $4,476 $4,696 $5,149