Attached please find the preliminary OWASP Combined (Converted to USD for all reports) financial pkg for Oct 2020 which represents financial performance for the 10th month of Fiscal year 2020. I have included the 2020 approved budget for the first 4 months and the approved Zforecast for May, June, July, August, Sept and now Oct. All amounts are combined with the EU and converted to USD in these reports.
[ Updated by ajv 1/26/2021 to include September's and October financial packages, as the October meeting was early and didn't have access to either of them.]
September 2020 Financial Packages
October 2020 Financial Packages
So I want to point this out early in the Report. I have included a detail P&L for the APSEC SF/Oct Virtual event. My question as you will see in the work book are, can we recognize all the revenue we had in the deferred account ($196K for Reg and $431K for sponsorship or will some of that be recognized in the 2021 APSEC US). Second the AV exp of $60K says first installment, will there be more bills? This is why this is preliminary. If we can recognize it all then we are in GREAT shape. If I have to put some or all of the Deferred revenue back on the balance sheet that will significantly impact the Oct 2020 close. I am sending the APSEC SF 2020 work book to Kelly and Emily for their input. With that please see the narrative with all of the Deferred and Prepaid expenses for APSEC US 2020 SF recognized at this point.
Income Statement:
Revenue: On an accrual basis, total revenue, YTD was $2,165.5K as compared to the budget of $1,623.4K. The results are BETTER by $542.1K, with Conference income being $623.7K ahead of the 2020 budget/Zforecast, offsetting the other revenue lines that were under budget (Membership and Donations). This is due to recognizing the Deferred Revenue for the 2020 OCT APSEC SF this month. If we need to move some or all of it back to recognize it will alter the Oct 2020 close.
Expenses: Total spending YTD 2020 is MORE than budget by $66K due to Conference expenses are over budget by $237.6K (Apsec Cali 20, 20 Snofroc , 20 NZ Day and 20 Seasides) as well as Professional fees (Trade Mark and legal expense, Audit fees) , offset by the underspending in Chapter expenses (down $117.7K), Travel costs($110.4K) and Project spending ($94.9K).
Net Income/Loss: YTD 2020 Net income, on a combined Accrual basis is $200.2K which is BETTER than the YTD 2020 budget/Zforecast of negative -<275.9K> by $476.1. However if we were to remove the $501.5K of net income that we recognized in October for the APSEC US SF, then we would be at a Negative Net Income of $301.3K or $25.4K WORSE than the Bud/Zforecast. This is the worse case if we have to return all of the Deferred revenue to the Balance sheet, which I do not believe we will, but we need to do that due diligence. I have sent a copy of the detail P&L for APSEC SF 2020 to Kelly and Emily to see what if any of the sponsorship we need to move back to the balance sheet. I hope to have that answer by Tues for the Board call.
Chapter Funds: US bal is $830.1K EU Ch bal is $59.9K. US Proj bal is $186.3K. EU Proj bal is $-8.4K
POINTS of NOTE:
Continuing the narrative theme from last month, as of 10.31.20 our cash position was $1,360.2K. Our avg monthly spend for operations is roughly $100K including all payroll, which is still roughly about 13.6 months of reserve, which is very good in the current environment. If we remove AP, PPP loan that is $242K which is just under 2.5 months of reserve taking us to an estimated 11 months, again a good number. Now the concern is the $1,067.9.K of Ch/Proj balances.
(though the Proj balances are just about $177.9K). The Deferred revenue, as we have recognized all of the APSEC US, leaves only APSEC EU and Lascon, and is now $87.4, or one more month of reserve, if all of the APSEC US 2020 can be recognized now. We need to make sure that we fulfill the sponsors value proposition, so we do not lose this revenue. So through 10 months of the year we are tracking way ahead of budget to due to the $501.5K of net income recognized in Oct 2020 for APSEC US which turned into an online event. If we have to remove that as noted above we are only $25.4K worse than the Bud/Zforecast, again not bad all things considered though we do need to pay attention to our liabilities and spending so that we do not veer from where we are now. One other note is APSEC CA has traditionally been a lucrative event, we are not currently planning one, however in order to bridge the gap, I think we seriously need to think about some type of “online” event for Jan 2021.
I have the next board call as Tues Nov 24th 2020 and I will be attending along with Marissa Oakley who has begun to work on the OWASP financials with me. Be safe everyone.