Size: 3385
Comment:
|
← Revision 9 as of 2011-04-22 22:55:40 ⇥
Size: 3931
Comment:
|
Deletions are marked like this. | Additions are marked like this. |
Line 3: | Line 3: |
* 134 Members * 160 Pledges |
* 135 Members * 161 Pledges |
Line 8: | Line 8: |
* pledges: $800 * members: $680 |
* pledges: $805 * members: $685 |
Line 12: | Line 12: |
* ''''Deficit: $169.85'''' ($1.06/pledge, $1.26/member) * 34 additional pledges needed to break even (60 additional members |
* ''''Monthly Deficit: $164.85'''' ($1.02/pledge, $1.22/member) * 33 additional pledges needed to break even (59 additional members |
Line 16: | Line 16: |
== Questions == | == Current Accumulated Deficit (up to October) == |
Line 18: | Line 18: |
What is our accumulated peer1 deficit? | $136.30 |
Line 22: | Line 22: |
* Server Hardware: $3500 * New Colocation: ~$600/month * 2 |
* Server Hardware: ~$2000 * PowerEdge 2970 + large raid * Console Server * Switch * New Colocation: ~$700/month * 2 |
Line 25: | Line 28: |
* We would be carrying this in addition to peer1 for up to 60 days | * We would be carrying this in addition to peer1 for up to 60 days (ideally 30) |
Line 29: | Line 32: |
* 2 months at both colos * Pledges: $29.38 * Members: $35.07 * 1 month at both colos * Pledges: $25.64 * Members: $30.60 |
=== Colocation === * Each month at both colos (($700 + $850) = $2250) * Pledges: $13.97 * Members: $16.67 === Hardware === * Per pledge: $14.82 * Per member: $12.42 |
Line 44: | Line 51: |
* Plan would be enacted for November billing cycle | * Plan would be enacted for December billing cycle |
Line 50: | Line 57: |
Assuming 160 pledges | Assuming 161 pledges |
Line 52: | Line 59: |
* Adjusted to November Real Cost = ~$1561.60 * Pending known value for new colocation * Per pledge: $9.76 ($10) * Surplus: ~$38.40 (too insignificant to count) |
* Adjusted to October Real Cost = $969.85 * Per pledge: $6.02 |
Line 57: | Line 62: |
=== Deficit === October and November would run a deficit. * October deficit: $164.85 * November deficit: $864.85 * '''Total: $1029'''' This becomes a total migration deficit of ~$2000 + ~$1029 + $136.30 = ~$3165 |
|
Line 60: | Line 75: |
* December real cost:$711.60 * Surplus: ~$888.40 * Per Pledge: $5.55 * Per Member: $6.63 |
* December real cost:$811.60 * December income (161 pledges @ $7): $1127 * Surplus: ~$315 * Per Pledge: $1.85 * Per Member: $2.34 |
Line 65: | Line 81: |
* Remaining migration debt Feb 1: $2323.20 == Dues adjusted Feb 1 == * Adjusted to February real costs: $711.60 * Per pledge: $4.45 ($5) * Per member: $5.31 ($6) * Additional debt-repayment surcharge: $2 * Surplus (@ $7/share) * With pledges: $408.40 * Without pledges: $226.40 * Remaining migration debt May 1: $1644.00 * Not terrible; completely paid off by the end of 2010 |
* Remaining deficit Mar 1: ''''$2220'''' * Entire deficit paid off ~7 months later (assuming zero or slow expansion) |
Line 92: | Line 96: |
* Projected real costs: $711.60 * Per member: $2.37 (3) |
* Projected real costs: $811.60 * Per member: $2.71 (3) |
Line 96: | Line 100: |
* Monthly surplus: $488.40 | * Monthly surplus: $388.40 (or $688.40 with $2 expansion fund) |
Line 106: | Line 110: |
I can't find anything to indicate that we wouldn't be eligible for a business account with the NCB. [http://www.ncb.coop/uploadedFiles/Applications_and_Forms/Commercial/Business%20Deposit%20Account%20Application.pdf] is the NCB application for a business deposit account. Interest-bearing checking accounts are available to nonprofits, but "some nonprofit organizations may not qualify." The website has phone numbers for banking and nonprofit specialists, as well as a general contact form. |
1. Current Budget
- 135 Members
- 161 Pledges
- $5/month/pledge
- Income
- pledges: $805
- members: $685
- $969.85
'Monthly Deficit: $164.85' ($1.02/pledge, $1.22/member)
- 33 additional pledges needed to break even (59 additional members
- without pledges)
1.1. Current Accumulated Deficit (up to October)
$136.30
2. Migration Expenses
- Server Hardware: ~$2000
PowerEdge 2970 + large raid
- Console Server
- Switch
- New Colocation: ~$700/month * 2
- Actual cost pending
- We would be carrying this in addition to peer1 for up to 60 days (ideally 30)
2.1. Migration Cost Per Member
2.1.1. Colocation
- Each month at both colos (($700 + $850) = $2250)
- Pledges: $13.97
- Members: $16.67
2.1.2. Hardware
- Per pledge: $14.82
- Per member: $12.42
3. Dues Restructuring
3.1. Overview
Dues pegged to ceiling(recurring expenses / pledges)
- The board would be authorized to add $0-$3 per share for projected
- non-recurring costs and debts
- Dues would be adjusted quarterly based on new costs and member counts
- Plan would be enacted for December billing cycle
3.2. Short Term Increase
All numbers involving new setup are pending known colocation cost.
Assuming 161 pledges
- Adjusted to October Real Cost = $969.85
- Per pledge: $6.02
- No debt repayment / non-recurring costs adjustment
3.2.1. Deficit
October and November would run a deficit.
- October deficit: $164.85
- November deficit: $864.85
Total: $1029'
This becomes a total migration deficit of ~$2000 + ~$1029 + $136.30 = ~$3165
3.2.2. End Peer1 Dec 1
- December real cost:$811.60
- December income (161 pledges @ $7): $1127
- Surplus: ~$315
- Per Pledge: $1.85
- Per Member: $2.34
Remaining deficit Mar 1: '$2220'
- Entire deficit paid off ~7 months later (assuming zero or slow expansion)
4. Numbers Look Better With New Members
Each new member joining before quarterly adjustment is paying 100% toward migration debt / expansion funding.
New members therefore essentially pay for the capacity expansion required to handle them.
5. Long Term Reduction
With 300 members:
- Projected real costs: $811.60
- Per member: $2.71 (3)
- Expansion fund: $1
- Total cost: $4
- Monthly surplus: $388.40 (or $688.40 with $2 expansion fund)
This is feasible within a year given our new hardware.
6. Related Ideas
6.1. Join National Cooperatives Bank
A while ago we looked at leaving Wells Fargo and joining the NCB, but the discussion died with no resolution. Do we qualify to have a business account with NCB? If we do we might qualify for an interest bearing checking account.
I can't find anything to indicate that we wouldn't be eligible for a business account with the NCB. [http://www.ncb.coop/uploadedFiles/Applications_and_Forms/Commercial/Business%20Deposit%20Account%20Application.pdf] is the NCB application for a business deposit account. Interest-bearing checking accounts are available to nonprofits, but "some nonprofit organizations may not qualify." The website has phone numbers for banking and nonprofit specialists, as well as a general contact form.
6.2. Moving Member Deposits to an Interest Bearing Account
We could open an account for storing member deposits into a savings or similar type of account and perhaps make a small amount of interest. Member deposits tend to not be touched often (if needed only the lower 2/3 of the balance could be stored in the interest bearing account), and so would be ideal for storing this way. What are the rules for HCoop as a non-profit corporation with regard to interest? Do we have to disburse gained interest to member balances, or could it instead go into a general use fund?