Monthly Financial Summary for Make Hack Void (Updated: May 2019)


(Ryan Mitchell) #1

Hi all,
At the last committee meeting we discussed publishing a monthly financial summary of how MHV’s doing, and hopefully give a layer of transparency to the community regarding the Space’s finances.
I’ve made a summary of all info I’ve thought of so far that could be of public interest, if there’s anything else you might want to know in a following summary please let me know and I can revise it for the next summary, which should be published at the end of May/Start of June

But for now, here’s a summary for our standing as of the end of April/Start of May:

Summary for April 2019

Donations:



We have 16 active donators, including two new donators, and two lost donators.
The average donation amount this month was $30.48125, down from last months $34.23125, and the yearly average of $34.25901442.
The peak average donation amount was January, with 13 donators averaging $40.59230769, and the overall peak total donated was March, with 16 donators averaging $ 34.23125

Income and Expenses
The following graph is most representative of the truth, as it treats monthly and yearly payments differently, by taking any yearly payments, dividing them by 12, and spreading them over the proceeding 12 months. Raw data will follow, but as far as keeping MHV afloat goes, this is the one that matters.


In this case, the green line needs to at least be above the pink line, as this is the average of our absolute minimal operating cost, including nothing other than rent and utilities (the light blue line).
The red line is our raw running cost, factoring and dividing yearly payments, and the dark blue line is the average of this.
The green line needs to get above the dark blue line for us to continue operating as-is.

Losses



We are currently loosing on average $667.2125 a month, with $8483.14 in the bank, that gives us
12.7 months until our balance will be at zero. This does not factor for reserved money, but that’s a whole can of worms I’m not going into again (Sorry Ben, my bad).
So 12 months is our absolute maximum.
There is, however, a downward trend on losses, however we don’t yet have enough data to work out if it’s just statistical noise.
This all said, we’ve got less than half as many people donating as we need.

RAW INFO
Here’s just some other graphs for you to make use of yourself.
(Keep in mind, this includes things like the ~$3.5k glowforge refund, $1.5k one-off insurance payments, and a whole bunch of other stuff, totally unfiltered.




(Ryan Mitchell) #2

tl;dr We’ve got around 12 months maximum to double our number of contributing members.


#3

A super good analysis …lets hope this helps turn the tide…


(Ryan Mitchell) #4

It has come to my attention that we may be being overcharged for some services, so I’ll hold off on the monthly summary for the time being until I have been able to investigate further.


(Ryan Mitchell) #5

Alright, there’s no time as good as bed time for doing spreadsheets, because, if you’re lucky, you’ll fall asleep on your keyboard half way through.
No such luck here, so it’s time for

MHV Financial Summary for May 2019

Donations:
Monthly%20Donations
Average%20Donations
We have 13 active donators, including one new donator, and five lost donators.
(Discrepancies with last months numbers are due to me not considering a donator who missed one month a “New” donator, even though the previous month they were considered a lost donator. For future months, I will add an additional category of “Returned” donators.)

The average donation amount this month was $37.04, up from last months $30.48 despite having three less donators, and the yearly average is $34.82.
The peak average donation amount remains as January, with 13 donators averaging $40.59, and the overall peak total donated remains March, with 16 donators averaging $34.23.
Income%20From%20Donations
Income and Expenses
The following graph is most representative of the truth, as it treats monthly and yearly payments differently, by taking any yearly payments, dividing them by 12, and spreading them over the proceeding 12 months. Raw data will follow, but as far as keeping MHV afloat goes, this is the one that matters.
Simple%20I_O
In this case, the green line needs to at least be above the red line, as this is the average of our absolute minimal operating cost, including nothing other than rent, utilities, and divided yearly payments (the light blue line).
The dark blue line is our raw running cost, factoring and dividing yearly payments, and the pink line is the average of this.
The green line needs to get above the pink line for us to continue operating as-is.

Disclaimer
I will note here, however, that I have noticed some anomalies with what we have been charged for services rendered or, in some cases, not rendered, dating back as far as September 2016.
If this is the case, then, once corrections have been made, this could reduce both our minimal running cost and corrected total cost by a not insubstantial amount, alongside what I suspect will be a significant reimbursement, and I will provide further details when I am at liberty to divulge further.
In this months calculations, I have corrected for spurious transactions, and, should the issue be resolved, for next months summary I will recalculate all months to date to provide more accurate graphs going forwards.
For now, treat all information as provided with a pinch of salt.

Losses
Losses
Losses%20Delta
Needed%20Delta
We are currently loosing on average $567.532 a month, with $8387.7 in the bank, that gives us
14.8 months until our balance will be at zero. This does not factor for reserved money, however I will propose to set a safe shutdown threshold at the next committee meeting, which has been moved forwards to the Second of July, 2019.
While it is good that our time-to-live has increased from 12.7 months to 14.8, (retroactively) factor in a safe shutdown threshold of $2,000 and it’s gone from 9.7 months to 11.3 months, a good thing regardless.
We remain as having a maximum of 12 months to live, however, we didn’t know that last month we only had 10 months, so it’s gone up anyway.
I will remind you that, due to various issues yet to be resolved, our running costs may be somewhat lower that currently thought, so, hopefully, by next month, our TTL will be significantly longer.

Our downward trend on losses remains steady, however we don’t yet have enough data to work out if it’s just statistical noise for sure.
We remain as having less than half as many donators as needed.

RAW INFO
Here’s just some other graphs for you to make use of yourself.
(Keep in mind, this includes things like the ~$3.5k glowforge refund, $1.5k one-off insurance payments, and a whole bunch of other stuff, totally unfiltered, along with anomalous transactions yet to be dealt with.
In%20The%20Bank
Running%20Bank%20Balance

Note for next months Summary:
Refactor for any corrected months transactions
Include “Returned Donators” as a category
Create additional spreadsheet charting time-to-live
Add “Total needed Donations” onto graphs, as just having the current amount and extra needed doesn’t show a clear delta