May 2018

TENNESSEE VOICES FOR CHILDREN, INC. STATEMENT OF FINANCIAL POSITION MAY 31, 2018 Assets Current Assets Petty Cash Cash-...

0 downloads 103 Views 78KB Size
TENNESSEE VOICES FOR CHILDREN, INC. STATEMENT OF FINANCIAL POSITION MAY 31, 2018

Assets Current Assets Petty Cash Cash-Checking Cash-money market funds Investments Unrealized market value change-investment Accounts receivable-general Travel advances Accounts receivable-grants Total current assets

$

Other Assets Deposits Prepaid Expenses Land Building Building Improvements Equipment & Furniture Accumulated Depreciation Total assets

250 421,123 1,049,840 1,530,682 91,941 373,170 3,467,006

9,989 192,254 470,383 243,996 95,589 (97,171) $

4,382,046

$

13,273 58,287 9,119 80,679

Liabilities and Net Assets Current Liabilities Accounts Payable Accrued Expenses Payroll withholdings/accruals Deferred Revenues Total current liabilities Long-Term Liabilities Note Payable Mortgage payable Total long-term liabilities

-

Net Assets Unrestricted Temporarily restricted

4,178,516 122,851

Total Net Assets

4,301,367

Total Liabilities and Net Assets

UNAUDITED-Prepared by TVC personnel For internal management use only

$

4,382,046

TENNESSEE VOICES FOR CHILDREN, INC. STATEMENT OF ACTIVITIES FOR THE ELEVEN MONTH PERIOD ENDED MAY 31, 2018

UNRESTRICTED Support and Revenue Contributions Conference Revenue Silent Auction Gala Event Documentary Film Revenue Grant/Contract Revenue Administrative Overhead Ear Honorarium Income Earned Income Brick purchases Training/Shipping Charges DC Interest Income Dividends Unrealized gain or (loss) Realized gain or (loss) Miscellaneous Revenue Net assets released from restrictions Gain or (Loss) Asset Disposal

$

TEMPORARILY RESTRICTED

35,100 27,638 59,175 1,226,219 241,228 16,764 5,186 7,159 42,550 21,192 (4,908) 1,655 103,672 -

TOTALS

$ $

80,000

35,100 27,638 59,175 1,226,219 241,228 96,764 5,186 7,159 42,550 21,192 (4,908) 1,655 1,758,958 -

(103,672)

Total Support and Revenue

1,782,630

Expenses Salaries Employee Benefits & Taxes

1,013,282 170,984

1,013,282 170,984

1,184,266

1,184,266

155,254 44,431 22,838 2,589 25,028 11,097 32,599 129,710 115,348 4,527 19,263 150 2,408 24,500

155,254 44,431 22,838 2,589 25,028 11,097 32,599 129,710 115,348 4,527 19,263 150 2,408 24,500

Total Personnel Expenses Professional Services Supplies Telephone Postage Occupancy Equipment Rental & Maint. Printing & Publications Travel Meetings & Conferences Awards & Gifts Subsidies/Flex Funds Contract services Insurance Special Events Miscellaneous Expenses Bank and Credit Card Fees Conference Expenses Special Projects Depreciation Total Expenses

1,774,008

Excess of Support & Revenue over (under) Expense Other Changes in Net Assets Net Asset Balance, beginning Net Assets, ending

(23,672)

$

UNAUDITED-Prepared by TVC personnel For internal management use only

-

1,774,008

8,622

(23,672)

(15,050)

4,169,894

(5,080) 151,603

(5,080) 4,321,497

4,178,516

$

122,851

$

4,301,367

TENNESSEE VOICES FOR CHILDREN, INC. ACTUAL REVENUE AND EXPENSES VS BUDGET - UNRESTRICTED FUNDS FOR THE ELEVEN MONTH PERIOD ENDED MAY 31, 2018 Current Month

Actual YTD

Budget

Support and Revenue Contributions Conference Revenue Silent Auction Gala Event Documentary Film Revenue Grant/Contract Revenue Adm Overhead Earned Honorarium Income Earned Income Brick purchases Training/Shipping Charges DC Interest Income Dividends Unrealized gain or (loss) Realized gain or (loss) Miscellaneous Income Assets released from restrictions Gain (Loss) Asset Disposal Total Support & Revenue

1,126 120,065 23,041 589 624 1,004 12,974 100 12,653 172,176

35,100 $ 27,638 59,175 150,000 1,226,219 1,752,391 241,228 281,724 16,764 5,186 7,159 92,650 42,550 21,192 (4,908) 1,655 103,672 1,782,630 2,276,765

Expenses Salaries Employee Benefits & Taxes Total Personnel Expense

107,147 17,461 124,608

1,013,282 170,984 1,184,266

1,271,735 307,621 1,579,356

Professional Services & Fees Supplies Telephone Postage and Shipping Occupancy Equipment Rental & Maintenance Printing & Publications Travel Meetings & Conferences Grants & Awards Subsidies/Flex Funds Contract services Insurance Special Events Miscellaneous Expenses Bank and Credit Card Fees Dues and Subscriptions Conference Expenses Special Projects Depreciation Total Expenses

5,420 2,624 887 141 1,693 1,326 4,866 11,485 4,204 200 1,613 102 2,239 161,408

155,254 44,431 22,838 2,589 25,028 11,097 32,599 129,710 115,348 4,527 19,263 150 2,408 24,500 1,774,008

281,830 59,674 42,297 5,070 45,808 16,069 44,896 141,646 49,390

10,768

8,622

4,167,748

4,169,894

4,169,894

$ 4,178,516

$ 4,178,516

$ 4,104,562

Excess of Support & Revenue over Expense Other Changes in Net Assets Net Assets, Beginning Net Assets, Ending

UNAUDITED-Prepared by TVC personnel For internal management use only

Variance

$

Percent Used/Earned

35,100 27,638 (90,825) (526,172) (40,496) 16,764 5,186

39.45% 69.97% 85.63%

(85,491)

23,040 19,967 33,054 2,342,097

21,192 (4,908) 1,655 103,672 (536,685)

78.30%

258,453 136,637 395,090

79.68% 55.58% 74.98%

126,576 15,243 19,459 2,481 20,780 4,972 12,297 11,936 (65,958) 18,513 704 (150) (2,408) 8,554 568,089

55.09% 74.46% 53.99% 51.07% 54.64% 69.06% 72.61% 91.57% 233.55%

(65,332)

$

(73,954)

19.65% 96.47%

74.12% 75.74%

TENNESSEE VOICES FOR CHILDREN, INC. GRANT/CONTRACT REVENUE DETAIL FOR THE ELEVEN MONTH PERIOD ENDED MAY 31, 2018

Current Month 20 - Childcare Consultation 21 - Statewide Family Support Network 22 - Fed Family Support 24 - Nurturing Parenting 25 - Strengthening Families Program 32 - YouthScreen 56 -LFC-Set-Svr 57 - Youth Move 59 60 - FSS Training 76 - Family Connection DCS Davidson Co. 81 - Socat 82 - Healthy Transitions 91 - Family Conn. Amerigroup 92 - Family Support 93 - Family Conn. United HC 97 - Family Conn. BlueCare

Actual YTD

11,772 24,807 8,956 1,473 6,257 500 18,009 39,004 6,597 (39) 2,742 3 (16)

Total Grant/Contract Revenue

120,065

Direct Expense Budget

142,725 240,760 12,000 37,249 52,362 93,802 35,515 2,500 16,000 204,024 232,504 152,259 2,450 14,209 720 3,140

162,159 285,532 41,667 62,500 113,010 48,217 8,421 12,500 199,619 346,119 174,573 34,270 50,000 34,952 30,119

1,242,219

1,603,658

Variance

Percent Used

19,434 44,772 (12,000) 4,418 10,138 19,208 12,702 (2,500) 8,421

88.02% 84.32%

(4,405) 113,615 22,314 31,820 35,791 34,232 26,979

102.21% 67.17% 87.22% 7.15% 28.42% 2.06% 10.43%

364,939

77.46%

89.40% 83.78% 83.00% 73.66% 0.00%

NET ASSETS RELEASED FROM RESTRICTIONS FOR THE ELEVEN MONTH PERIOD ENDED MAY 31, 2018

Current Month 46 - Care Foundation 47 - Baptist Healing Trust 48 - HCA Foundation

$

839 11,813 -

Actual YTD $

12,652

37,059 66,612 -

Direct Epense Budget $

103,671

82,415 75,485 1,000 158,900

Variance $

Percent Used

45,356 8,873

44.97% 88.25%

54,229

133.21%

MISCELLANEOUS REVENUES FOR THE ELEVEN MONTH PERIOD ENDED MAY 31, 2018

Current Month 00 - Administrative - Misc 01 - Fundraising - Misc 61 - TVC Counseling Svc Total Miscellaneous Revenue

UNAUDITED-Prepared by TVC personnel For internal management use only

$

117 200 317

Actual YTD $

1,655 17 375 2,047

Budget $

Variance

-

(1,655) (17)

-

(1,672)

Percent Used