Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2023.05 YTD Financial workbook (1) (1)
As of May 31, 2023 As of May 31, 2022 (PY)Change ASSETS Current Assets Bank Accounts 1000 Checking 8289-South State Bank 254,334.87 607,055.58 (352,720.71) 1001 Savings - Live Oak Bank 633,122.05 5,170.34 627,951.71 Total Bank Accounts $887,456.92 $612,225.92 $ 275,231.00 Accounts Receivable 11000 Accounts Receivable 141,418.24 47,657.79 93,760.45 11010 Bad Debt Reserve (20,000.00)-(20,000.00) Total Accounts Receivable $121,418.24 $47,657.79 $ 73,760.45 Other Current Assets 1260 Intercompany Receivables 1261 Due From CFC Capital, LLC 9,900.00 16,400.00 (6,500.00) 1262 Due From CFC Ventures, LLC 49,050.00 49,050.00 - 1263 Due from CF Collective Impact 1 49,168.00 67,250.00 (18,082.00) 1264 Due from CF Collective Impact 2 317,500.35 55,815.98 261,684.37 1265 Due from Brick Capital 10,425.00 25.00 10,400.00 1266 Due from CFC Affordable Housing 7,943.50 500.00 7,443.50 1267 Due from MDM 6,500.00 1,300.00 5,200.00 Total 1260 Intercompany Receivables $450,486.85 $190,340.98 $ 260,145.87 1350 Prepaid insurance 381.79 1,479.35 (1,097.56) 1351 Prepaid Expense 700.00 -700.00 Total Other Current Assets $451,568.64 $191,820.33 $ 259,748.31 Total Current Assets $1,460,443.80 $851,704.04 $ 608,739.76 Fixed Assets 1501 Computers 2,213.63 2,213.63 - 1502 Software 125,000.00 125,000.00 - 1599 Accumulated Depreciation (32,110.49)-(32,110.49) Total Fixed Assets $95,103.14 $127,213.63 $ (32,110.49) Other Assets 1800 Invest - CFC Ventures, LLC 1,000.00 1,000.00 - 1801 Invest - CFC Capital 1,000.00 1,000.00 - 1802 Invest - CFCIO1 300,000.00 300,000.00 - Total Other Assets $302,000.00 $302,000.00 $- TOTAL ASSETS $1,857,546.94 $ 1,280,917.67 $ 576,629.27 LIABILITIES AND EQUITY Liabilities Current Liabilities Accounts Payable 20000 Accounts Payable 28,294.00 48,100.00 (19,806.00) Total Accounts Payable $28,294.00 $48,100.00 $ (19,806.00) Total Credit Cards $1,633.68 $-$ 1,633.68 Total Collective Impact in New Hanover County, Inc Statement of Financial Position Comparison As of May 31, 2023 No assurance is provided on these financial statements 1 Other Current Liabilities Total 2400 Payroll Liabilities $ 23,085.47 $ 36,414.22 $ (13,328.75) 2417 Accrued Expenses 600.00 - 600.00 2500 Deferred Revenue 327,282.76 173,735.00 153,547.76 2501 CCofW Fiscal Sponsorship Pass-through 47,070.00 - 47,070.00 Total Other Current Liabilities $ 398,038.23 $ 210,149.22 $ 187,889.01 Total Current Liabilities $ 427,965.91 $ 258,249.22 $ 169,716.69 Total Liabilities $ 427,965.91 $ 258,249.22 $ 169,716.69 Equity 3150 Temp. Restricted Net Assets 374,352.76 - 374,352.76 3200 Unrestricted Net Assets 601,040.90 759,313.23 (158,272.33) Net Revenue 454,187.37 263,355.22 190,832.15 Total Equity $ 1,429,581.03 $ 1,022,668.45 $ 406,912.58 TOTAL LIABILITIES AND EQUITY $ 1,857,546.94 $ 1,280,917.67 $ 576,629.27 No assurance is provided on these financial statements 2 Actual Budget over Budget % of Budget Revenue 4000 Corporate Contributions 311,277.48 330,000.00 (18,722.52)94.33% 4100 Individual Contributions 254,936.50 183,333.37 71,603.13 139.06% 4200 Grants 4200.1 Healthy Opportunities 361,217.27 504,368.37 (143,151.10)71.62% 4200.3 KB Reynolds Grant 258,215.62 - 258,215.62 100.00% 4200.4 City of Wilmington-ARP 72,236.94 250,000.00 (177,763.06)28.89% 4200.5 City of Wilmington - 750,000.00 (750,000.00)0.00% 4200.6 NHCEF 70,000.00 - 70,000.00 100.00% 4801.1 Smart Start Service Agreement 33,000.00 - 33,000.00 100.00% 4801.2 Impact Health 30,000.00 - 30,000.00 100.00% 4801.3 Wireless Research Center 40,000.00 - 40,000.00 100.00% Total 4200 Grants $ 864,669.83 $ 1,504,368.37 $ (639,698.54)57.48% 4300 Management Fee 300,716.66 297,916.63 2,800.03 100.94% 4800 Services 500.00 148,500.00 (148,000.00)0.34% 4800.10 UMBC 14,000.01 - 14,000.01 100.00% 4800.11 PACES 23,666.67 - 23,666.67 100.00% 4800.3 NCPC Service Contract 1,100.00 - 1,100.00 100.00% 4800.4 CCNC 125,000.00 100,000.00 25,000.00 125.00% 4800.5 CCLCF 5,000.00 4,583.37 416.63 109.09% 4800.6 Onslow County Health Department 12,000.00 - 12,000.00 100.00% 4800.7 WRC Tech Talent Initiatve - 174,166.63 (174,166.63)0.00% 4800.8 TDI 50,000.00 - 50,000.00 100.00% 4800.9 UNC Wilmington 30,000.00 - 30,000.00 100.00% Total 4800 Services $ 261,266.68 $ 427,250.00 $ (165,983.32)61.15% 4999 Interest Income 8,283.09 0.00 8,283.09 100.00% 9999 CC Rewards 25.00 0.00 25.00 100.00% Total Revenue $ 2,001,175.24 $ 2,742,868.37 $ (741,693.13)72.96% Gross Profit $ 2,001,175.24 $ 2,742,868.37 $ (741,693.13)72.96% Expenditures 6001 Recruitment & Job Posting - 366.63 (366.63)0.00% 6002 Capital Expenditures < $2000 - 1,833.37 (1,833.37)0.00% 6003 Repairs & Maint - Equipment - 458.37 (458.37)0.00% 6004 Professional Development 5,069.78 27,500.55 (22,430.77)18.44% 6005 Team Travel & Conferences 7,424.56 18,333.37 (10,908.81)40.50% 6006 Office Supplies/Materials 6,996.88 2,291.63 4,705.25 305.32% 6007 Meeting and Convenings 4,977.12 1,833.37 3,143.75 271.47% 6009 Brand, Website Maintenance, Marketing 3,188.12 13,750.00 (10,561.88)23.19% 6010 Hosting, Email and Technology 14,366.54 3,300.00 11,066.54 435.35% 6012 Contract Labor 89,220.00 89,833.37 (613.37)99.32% 6013 Videography/Photography 2,862.25 - 2,862.25 100.00% 6014 Branded Materials (deleted) 237.55 916.63 (679.08)25.92% Total 6015 Payroll Expenses $ 1,205,286.01 $ 1,392,579.65 $ (187,293.64)86.55% Collective Impact in New Hanover County, Inc Budget vs. Actuals: YTD FY23 P&L July 2022 - May 2023 Total No assurance is provided on these financial statements 3 6016 Accounting Expense 8,736.26 14,666.63 (5,930.37)59.57% 6017 Data Platform Implem/Contracts 534.68 13,750.00 (13,215.32)3.89% 6022 Community Engagement Contract 1,341.29 - 1,341.29 100.00% 6023 Prof/Organ Membership Fees 2,470.00 - 2,470.00 100.00% 6024 Bad Debt 20,000.00 - 20,000.00 100.00% 6025 Office Space Rent - 22,000.00 (22,000.00)0.00% 6026 Community Events and Sponsorships 8,504.23 3,666.63 4,837.60 231.94% 6030 Insurance Expense 9,076.50 5,596.25 3,480.25 162.19% 6033 Share Care Network Software 660.00 - 660.00 100.00% 6036 Community Support Programs (deleted) - 9,166.63 (9,166.63)0.00% 6038 Electronics & Software 1,990.68 - 1,990.68 100.00% 6200 Grant Expense - CFCAH 72,236.94 - 72,236.94 100.00% 6502 Bank & Merchant Fees 479.33 - 479.33 100.00% 6503 Depreciation Expense 23,593.02 - 23,593.02 100.00% 6600 Legal & Professional Fees 58,087.03 - 58,087.03 100.00% 6800 HOP Expenses 31.97 - 31.97 100.00% 6800.1 Recruitment - 458.37 (458.37)0.00% 6800.2 Communications 234.92 2,750.00 (2,515.08)8.54% 6800.3 Equipment - 9,166.63 (9,166.63)0.00% 6800.4 Software 158.10 4,583.37 (4,425.27)3.45% 6800.5 Rent or Lease of Buildings 360.50 - 360.50 100.00% 6800.6 Travel 151.67 13,750.00 (13,598.33)1.10% 6800.7 Office Expense (1,762.37) 2,291.63 (4,054.00)-76.90% 6800.8 IT Management - 2,291.63 (2,291.63)0.00% 6800.9 Payroll Expenses 199.72 8,250.00 (8,050.28)2.42% Total 6800 HOP Expenses $ (625.49) $ 43,541.63 $ (44,167.12)-1.44% Total Expenditures $ 1,546,713.28 $ 1,665,384.71 $ (118,671.43)92.87% Net Operating Revenue $ 454,461.96 $ 1,077,483.66 $ (623,021.70)42.18% Other Revenue 9990 9990 CCofW 9991 CCofW Income 1,000.00 0.00 1,000.00 100.00% 9992 CCofW Expense -1,000.00 0.00 -1,000.00 -100.00% Total 9990 9990 CCofW $ 0.00 $ 0.00 $ 0.00 9995 EJI/NHCCRP 0.00 9996 EJI/NHCCRP Income 9.41 0.00 9.41 100.00% 9997 EJI / NHCCRP expenses -284.00 0.00 -284.00 -100.00% Total 9995 EJI/NHCCRP -$ 274.59 $ 0.00 -$ 274.59 -100.00% Total Other Revenue -$ 274.59 $ 0.00 -$ 274.59 -100.00% Net Other Revenue -$ 274.59 $ 0.00 -$ 274.59 -100.00% Net Revenue $ 454,187.37 $ 1,077,483.66 -$ 623,296.29 42.15% No assurance is provided on these financial statements 4