Site Logo

 
It is currently Wed Oct 22, 2014 11:55 pm

All times are UTC - 6 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Example Funding Model
PostPosted: Thu May 28, 2009 9:44 pm 
Offline
Site Admin
User avatar

Joined: Mon Jan 19, 2009 1:57 am
Posts: 385
Location: Minneapolis, MN
Inspired by the discussions at the meeting on Wednesday I created a simple(ish) model of possible funding etc.

Here is the spreadsheet http://spreadsheets.google.com/ccc?key=rTJKPBuZNCr_frIhl2Hj3UQ.

!!Please do not edit below the indicated line!! Any "adjustable" settings are located at the top. If you have an interesting idea or compelling reason to edit below the line, post it in this thread.

Description

This model works of the idea of preliminary dues which lead to some prorated period were members who paid preliminary dues have half of their contribution paid toward the full dues. Then completely full dues kicks in It also assumes renting a "clubhouse" sort of location, and then a shop when funds are available.

Memberbase Controls


I have defined a starting member base, two ranges of member growth, an adjustable threshold between the two ranges, and stable membership cap. The two ranges allow for modeling of growth before we "pull the trigger" and after. e.g. Lower numbers up front, larger when people actually see what we can do. T

The growth rates specify the number of members added per month during each range. Once the membership cap is reached no more members are added. The threshold specifies when the dues switch from preliminary to pro-rated/full.

Money Controls

The preliminary dues and full dues are adjustable. It is assumed that half of the preliminary dues contributions from members will be deducted from the full dues period after the membership threshold is reached.

The lease for both the clubhouse and shop are adjustable, so is the multiplier which specifies how many times the lease amount must be saved before we can assume the lease. e.g. lease = $1000/mo. multiplier= 3 then $3000 must be banked before we assume the lease.

The model does not currently account for other sources of income (pledges, etc.) since they aren't predictable.

Reports

The model generates a rough month-to-month account of membership size, dues generated, expenses, banked monies, and what facility we can afford. It will tell you the number of months in the preliminary dues period, the period before we hit the membership threshold. It will also tell you how many months until the clubhouse and shop are each attained


Run yer numbers and report what you find. Enjoy!

PS There are some shortcomings, I thought it was an interesting first step though

_________________
Check out #tcmaker on irc.freenode.net Click for Freenode Webchat
Maker Map - Add your location!
TC Maker Flickr Pool


Top
 Profile  
 
 Post subject: Re: Example Funding Model
PostPosted: Thu May 28, 2009 9:57 pm 
Offline
User avatar

Joined: Wed Jan 28, 2009 9:53 am
Posts: 928
Location: Eagan, MN
O HAI -- I FIX YR LOLSPEEK :D

_________________
my workplace blog
my builder blog
my personal blog


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 6 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Template made by DEVPPL Flash Games