We are a corporate membership organisation that offers membership at six different levels and in three different currencies. I have always used excel to model subscription levels for budgeting purposes on both an accruals basis and cash flow basis as we had one renewal point - 1st January - regardless of when a new member joined.
This has now changed to 12 renewal points as a member will renew on the anniversary of their join date (to the nearest month end) and my excel model no longer works.
My variables are now:
- type of membership
- currency / region
- renewal date
- accrual or cash flow
Can anyone recommend any software they use successfully in similar scenarios?
Thank you
Replies (9)
Please login or register to join the discussion.
Fundamentally your output will only be as good as your input.
Modelling your assumptions will be keym, I don't see how a package will help
Me? Id do it in excel as its infinitely flexible. it sounds pretty straightforward to knock up, and then filter in some variable assumptions, eg drop in revenue %'s., variable sign ups so you can test your resilience
Is there someone else there that can use excel over a basic level? Your external accountants might be happy to model it, its really bread and butter stuff for bean counters.
+1 for Excel
There are some techniques that will make it easier (separate input, workings and output tabs, named ranges etc).
But monthly columns for each level with # of renewals in each month for each currency would be my starting point...
Plenty of apps that can do this but how do you actually initiate the membership subscription transactions?
Excel definitely! It can do this no problem.
PM me if you want me to pass your details on to a guy I know who produces spreadsheets full time.
Or just spend a few hours, if you've been using Excel so far then it won't take many tweaks to get a spreadsheet that would work for your new model
Sorry I thought this was a latest question, no idea why it popped up when I was on the latest screen.
Hope you've got it sorted by now