welcome: please sign in

Diff for "DuesRestructuring"

Differences between revisions 4 and 9 (spanning 5 versions)
Revision 4 as of 2009-09-24 23:35:33
Size: 3385
Editor: ClintonEbadi
Comment:
Revision 9 as of 2011-04-22 22:55:40
Size: 3931
Editor: ClintonEbadi
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
  • Current Monthly Expenses

    • $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?

DuesRestructuring (last edited 2011-04-22 22:55:40 by ClintonEbadi)