January 2018 Financials

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

0 downloads 59 Views 75KB Size
TENNESSEE VOICES FOR CHILDREN, INC. STATEMENT OF FINANCIAL POSITION JANUARY 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

200 423,042 1,097,374 1,528,524 118,462 320,811 3,488,413

10,905 192,254 470,383 239,849 95,589 (88,229) $

4,409,164

$

22,560 50,911 3,397 76,868

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,246,616 85,680

Total Net Assets

4,332,296

Total Liabilities and Net Assets

UNAUDITED-Prepared by TVC personnel For internal management use only

$

4,409,164

TENNESSEE VOICES FOR CHILDREN, INC. STATEMENT OF ACTIVITIES FOR THE SEVEN MONTH PERIOD ENDED JANUARY 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) Insurance Proceeds Miscellaneous Revenue Net assets released from restrictions Gain or (Loss) Asset Disposal

$

TEMPORARILY RESTRICTED

31,617 27,638 59,175 762,284 147,331 5,186 4,689 35,476 47,714 1,185 75,843 -

TOTALS

$ $

15,000

31,617 27,638 59,175 762,284 147,331 15,000 5,186 4,689 35,476 47,714 1,185 1,137,295 -

(75,843)

Total Support and Revenue

1,198,138

Expenses Salaries Employee Benefits & Taxes

587,913 104,696

587,913 104,696

Total Personnel Expenses

692,609

692,609

Professional Services Supplies Telephone Postage Occupancy Equipment Rental & Maint. Printing & Publications Travel/Mtgs/Conferences Awards & Gifts Subsidies/Flex Funds Contract services Insurance Special Events Miscellaneous Expenses Write Off Old Accts Receivable Conference Expenses Special Projects Depreciation

123,090 31,663 14,776 2,115 16,183 6,966 24,118 175,182 4,195 12,816 150 1,995 15,558

123,090 31,663 14,776 2,115 16,183 6,966 24,118 175,182 4,195 12,816 150 1,995 15,558

Total Expenses

1,121,416

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

(60,843)

$

UNAUDITED-Prepared by TVC personnel For internal management use only

-

76,722

(60,843)

4,169,894

(5,080) 151,603

4,246,616

$

85,680

1,121,416

15,879 (5,080) 4,321,497 $

4,332,296

TENNESSEE VOICES FOR CHILDREN, INC. ACTUAL REVENUE AND EXPENSES VS BUDGET - UNRESTRICTED FUNDS FOR THE SEVEN MONTH PERIOD ENDED JANUARY 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) Insurance Proceeds Miscellaneous Income Assets released from restrictions Gain (Loss) Asset Disposal Total Support & Revenue

2,740 104,582 18,850 652 950 22,542 90 11,181 161,587

31,617 27,638 59,175 762,284 147,331 5,186 4,689 35,476 47,714 1,185 75,843 1,198,138

Expenses Salaries Employee Benefits & Taxes Total Personnel Expense

77,753 14,739 92,492

587,913 104,696 692,609

1,171,217 282,720 1,453,937

Professional Services & Fees Supplies Telephone Postage and Shipping Occupancy Equipment Rental & Maintenance Printing & Publications Travel/Mtgs/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

18,825 7,767 2,158 627 2,446 926 389 7,960 450 1,612 115 2,222 137,989

123,090 31,663 14,776 2,115 16,183 6,966 24,118 175,182 4,195 12,816 150 1,995 15,558 1,121,416

270,692 42,567 37,398 4,806 44,341 15,693 43,906 177,232

26,676 2,154,039

23,598

76,722

122,726

4,223,018

4,169,894

4,169,894

$ 4,246,616

$ 4,246,616

$ 4,292,620

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

$

150,000 1,752,391 281,724 -

Variance

$

31,617 27,638 (90,825) (990,107) (134,393) 5,186

92,650 2,276,765

Percent Used/Earned

#DIV/0! #DIV/0! 39.45% #DIV/0! 43.50% 52.30% #DIV/0! #DIV/0!

(87,961) 47,714 1,185 75,843 (1,114,103)

19,740 17,051 -

583,304 178,024 761,328

50.20% 37.03% 47.64%

147,602 10,904 22,622 2,691 28,158 8,727 19,788 2,050 15,545 4,235 (150) (1,995) 11,118 1,032,623

45.47% 74.38% 39.51% 44.01% 36.50% 44.39% 54.93% 98.84%

$

52.62%

46,004

21.25% #DIV/0! 75.16%

58.32% 52.06%

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

Current Month 20 - Childcare Consultation 21 - Statewide Family Support Network 24 - Nurturing Parenting 25 - Strengthening Families Program 32 - YouthScreen 56 - ECN 59 60 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 Total Grant/Contract Revenue

Actual YTD

10,935 21,701 2,832 4,274 10,624 -

91,726 146,067 22,762 35,186 62,864 35,515

4,000 23,930 15,108 9,095 314 1,052 92 625 104,582

Budget

Variance

Percent Used

102,865 196,571 27,238 39,814 72,747 21,381

47.14% 42.63% 45.52% 46.91% 46.36% 62.42%

16,000 128,210 88,968 121,744 2,121 7,789 927 2,405

194,591 342,638 50,000 75,000 135,611 56,896 8,421 12,500 241,986 197,542 209,488 41,124 60,000 41,942 36,143

113,776 108,574 87,744 39,003 52,211 41,015 33,738

52.98% 45.04% 58.12% 5.16% 12.98% 2.21% 6.65%

762,284

1,703,882

936,677

44.74%

NET ASSETS RELEASED FROM RESTRICTIONS FOR THE SEVEN MONTH PERIOD ENDED JANUARY 31, 2018 Current Month 46 - Care Foundation 47 - Baptist Healing Trust 48 - HCA Foundation

$

4,047 7,134 -

Actual YTD $

11,181

33,976 41,867 -

Budget $

75,843

Variance

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

$

Percent Used

48,439 33,618

41.23% 55.46%

82,057

96.69%

MISCELLANEOUS REVENUES FOR THE SEVEN MONTH PERIOD ENDED JANUARY 31, 2018

Current Month 00 - Administrative - Misc 01 - Fundraising - Misc Total Miscellaneous Revenue

UNAUDITED-Prepared by TVC personnel For internal management use only

$

90 90

Actual YTD $

1,168 17 1,185

Budget $

Variance

-

(1,168) (17)

-

(1,185)

Percent Used