GIRL SCOUTS OF CENTRAL INDIANA, INC. FINANCIAL STATEMENTS September 30, 2019
GIRL SCOUTS OF CENTRAL INDIANA, INC. Indianapolis, Indiana FINANCIAL STATEMENTS September 30, 2019
CONTENTS
INDEPENDENT AUDITOR’S REPORT .................................................................................................
1
FINANCIAL STATEMENTS STATEMENT OF FINANCIAL POSITION ........................................................................................
3
STATEMENT OF ACTIVITIES .........................................................................................................
4
STATEMENT OF FUNCTIONAL EXPENSES .................................................................................
5
STATEMENT OF CASH FLOWS .....................................................................................................
6
NOTES TO FINANCIAL STATEMENTS ..........................................................................................
7
SUPPLEMENTARY INFORMATION SCHEDULE OF EXPENDITURES OF FEDERAL, STATE, AND LOCAL AWARDS ........................ 21
Crowe LLP Independent Member Crowe Global
INDEPENDENT AUDITOR’S REPORT
The Board of Directors Girl Scouts of Central Indiana, Inc. Indianapolis, Indiana
Report on Financial Statements We have audited the accompanying financial statements of the Girl Scouts of Central Indiana, Inc. (Council), which comprise the statement of financial position as of September 30, 2019, and the related statements of activities, functional expenses, and cash flows for the year then ended, and the related notes to the financial statements. Management’s Responsibility for the Financial Statements Management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor’s Responsibility Our responsibility is to express an opinion on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor’s judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity’s preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity’s internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinion.
(Continued)
1.
Opinion In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of the Girl Scouts of Central Indiana, Inc. as of September 30, 2019, and the changes in its net assets and its cash flows for the year then ended in accordance with accounting principles generally accepted in the United States of America. Other Matters Our audit was conducted for the purpose of forming an opinion on the financial statements as a whole. The accompanying schedule of expenditures of federal, state, and local awards is presented for purpose of additional analysis and is not a required part of the financial statements. Such information is the responsibility of management and was derived from and relates directly to the underlying accounting and other records used to prepare the financial statements. The schedule of expenditures of federal, state, and local awards has been subjected to the auditing procedures applied in the audit of the financial statements and certain other procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the information is fairly stated, in all material respects, in relation to the financial statements as a whole. Prior-Year Comparative Information We have previously audited the Council’s 2018 financial statements, and we expressed an unmodified audit opinion on those audited financial statements in our report dated March 8, 2019. In our opinion, the summarized comparative information presented herein as of and for the year ended September 30, 2018 is consistent, in all material respects, with the audited financial statements from which it has been derived.
Crowe LLP Indianapolis, Indiana March 2, 2020
2.
GIRL SCOUTS OF CENTRAL INDIANA, INC. STATEMENT OF FINANCIAL POSITION September 30, 2019 (with comparative amounts for September 30, 2018)
2019 ASSETS Cash and cash equivalents Accounts and other receivables Pledges receivable, net (Note 3) Inventories Prepaid expenses Investments (Note 4) Beneficial interest in assets held by others (Note 5) Beneficial interest in perpetual trust (Note 5) Land, buildings, and equipment, net (Note 6) Total assets
LIABILITIES AND NET ASSETS Liabilities Accounts payable and accrued expenses Due to Girl Scouts USA Deferred revenue Annuity payment liability Capital lease payable (Note 8) Long-term debt (Note 9) Total liabilities
$
928,877 3,581 124,288 476,042 18,322 6,372,555 113,526 388,667 10,662,031
2018 $
1,460,791 125,435 185,493 473,930 58,998 6,144,098 116,215 400,656 10,939,315
$ 19,087,889
$ 19,904,931
$
$
294,140 55,459 257,123 36,655 28,047 3,612,297 4,283,721
331,077 30,497 229,034 44,500 49,999 3,811,735 4,496,842
Net assets Without donor restrictions With donor restrictions (Note 10) Total net assets
13,815,503 988,665 14,804,168
13,571,274 1,836,815 15,408,089
Total liabilities and net assets
$ 19,087,889
$ 19,904,931
See accompanying notes to financial statements. 3.
GIRL SCOUTS OF CENTRAL INDIANA, INC. STATEMENT OF ACTIVITIES Year ended September 30, 2019
Without Donor Restrictions Public support and revenues Public support Contributions and grants United Way allocations Revenues Product and Retail sales revenue, net Program service fees Investment income Other revenue Net assets released from restrictions Total public support and revenues
$
736,039 253,070
With Donor Restrictions
$
Total
259,839 -
$
995,878 253,070
8,682,966 824,297 224,696 136,433 1,096,000
(1,096,000)
8,682,966 824,297 224,696 136,433 -
11,953,501
(836,161)
11,117,340
Expenses Program services General and administrative Fundraising
9,077,978 1,993,983 582,634
-
9,077,978 1,993,983 582,634
Total expenses
11,654,595
-
11,654,595
Change in net assets before other income, gains and losses Other income, gains and losses Unrealized loss on investments Realized gain on investments Change in value of beneficial interest in assets held by others Change in value of beneficial interest in perpetual trust Change in net assets Net assets, beginning of period Net assets, end of period
298,906
(836,161)
(176,658) 118,583
-
3,398
-
(537,255) (176,658) 118,583 3,398
(54,677)
(11,989) (11,989)
(11,989) (66,666)
244,229
(848,150)
(603,921)
13,571,274 $ 13,815,503
1,836,815
15,408,089
988,665
$ 14,804,168
$
See accompanying notes to financial statements. 4.
GIRL SCOUTS OF CENTRAL INDIANA, INC. STATEMENT OF FUNCTIONAL EXPENSES Year ended September 30, 2019
Program Services Salaries and benefits Professional fees and services Supplies and program expenses Telecommunications Postage and shipping Occupancy Equipment expense Printing and publications Travel and meetings Awards, grants and assistance Interest expense Insurance Other Total expenses before depreciation
$
Depreciation Total expenses
$
5,102,246 135,602 1,302,205 50,075 35,314 469,945 263,697 204,318 354,055 312,579 109,345 131,841 172,336
General and Administrative $
1,224,646 109,990 84,770 84,472 30,860 145,314 84,034 18,235 73,434 46 23,221 49,156 10,563
Fundraising $
346,044 81,254 19,422 1,270 2,437 5,872 14,090 7,620 82,315 4,932 4,097 3,532
Total $
6,672,936 326,846 1,406,397 135,817 68,611 621,131 361,821 230,173 509,804 317,557 136,663 180,997 186,301
8,643,558
1,938,741
572,885
11,155,054
434,420
55,242
9,749
499,411
582,634
$ 11,654,595
9,077,978
$
1,993,983
$
See accompanying notes to financial statements. 5.
GIRL SCOUTS OF CENTRAL INDIANA, INC. STATEMENT OF CASH FLOWS Year ended September 30, 2019
Cash flows from operating activities Change in net assets Adjustments to reconcile change in net assets to net cash from operating activities Depreciation and amortization Net realized/unrealized loss on investments Change in value of beneficial interest in funds held by others Change in value of beneficial interest in perpetual trust Contributions restricted for long-term investment Change in assets and liabilities Accounts and other receivable Pledges receivable Inventories Prepaid expenses Accounts payable and accrued expenses Deferred Revenue Due to Girl Scouts USA Net cash from operating activities
$
(603,921)
508,500 58,075 (3,398) 11,989 (82,033) 121,854 61,205 (2,112) 40,676 (36,937) 28,089 24,962 126,949
Cash flows from investing activities Purchases of property and equipment Proceeds from sale of equipment Withdrawals from beneficial interests in assets held by others Purchases of investments Proceeds from sales and maturities of investments Net cash from investing activities
(222,310) 183 6,087 (1,809,628) 1,523,096 (502,572)
Cash flows from financing activities Principal payments on mortgages payable Repayment on bonds payable Repayment on capital lease obligations Payment on annuity obligation Draw on line of credit Repayment on line of credit Contributions restricted for long-term investment Net cash from financing activities
(142,607) (65,920) (21,952) (7,845) 1,000,000 (1,000,000) 82,033 (156,291)
Net change in cash and cash equivalents
(531,914)
Cash and cash equivalents, beginning of year
1,460,791
Cash and cash equivalents, end of year
$
928,877
Supplemental disclosure of cash flow information Cash paid during the year for interest Donated stock
$
136,664 789
(Continued) 6.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 1 - DESCRIPTION OF COUNCIL Girl Scouts is the preeminent leadership development organization for girls and the leading authority on girls’ healthy development. Girl Scouting builds girls of courage, confidence, and character, who make the world a better place. Girl Scouts of Central Indiana (Council) is a non-profit organization chartered by Girl Scouts of the USA (GSUSA) to deliver local and regional program opportunities. Girl Scouts of Central Indiana serves more than 29,000 girls and 12,000 volunteers in 45 counties across central Indiana. During 2018, the Council changed its reporting year end to September 30 from December 31. These financial statements reflect the fiscal year ended September 30, 2019.
NOTE 2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Method of Accounting: The Council maintains its accounts on the accrual basis of accounting and prepares its financial statements in accordance with accounting principles generally accepted in the United States of America (GAAP). Basis of Presentation: The Council reports information regarding its financial position and activities according to two classes of net assets: Net assets without donor restrictions - Net assets that are not subject to donor-imposed stipulations. Net assets with donor restrictions - Net assets subject to donor-imposed stipulations that may or will be met, either by actions of the Council and/or passage of time. Also included in this category are net assets subject to donor-imposed stipulations that assets be maintained in perpetuity by the Council. Generally, the donors of these assets permit the Council to use all or part of the income earned on any related investments for general or specific purposes. Cash Equivalents: For the purpose of the statement of cash flows, the Council considers all highly liquid debt instruments purchased with an original maturity of three months or less to be cash equivalents, unless the Board has designated the funds to be reinvested and held for long-term purposes. Girl Scouts Service Units and Troops establish bank accounts under the Council’s tax identification number. All funds are maintained for the benefit of the girls in the respective Service Units and Troops. These funds are not under the financial control of the Council and have not been included in the financial statements. Accounts Receivable: Accounts receivable includes amounts owed to the Council from individual Girl Scouts and other parties. The Council does not charge interest on past due accounts. Pledges Receivable: Pledges receivable that are expected to be collected within one year are recorded at net realizable value. Unconditional promises to give that are expected to be collected in future years are recorded at the present value of their estimated future cash flows. The discounts on those amounts are computed using a discount rate commensurate with the risks involved. Amortization of discounts is included in contribution revenue.
(Continued) 7.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Allowances: The Council estimates and records an allowance for uncollectible accounts and pledges receivables. The allowances are based upon prior experience and management’s analysis of specific receivables and promises to give. Losses are charged off to the reserve when management deems further collection efforts will no longer produce additional recoveries. As of September 30, 2019, the Council currently considers accounts and other receivables and pledges receivables to be fully collectible. Inventories: Girl Scout supplies and merchandise for resale are stated at the lower of cost or net realizable value on a first-in, first-out basis (FIFO). Investments: Investments in marketable securities with readily determinable fair values and all investments in debt securities are reported at their fair values in the statement of financial position. Realized and unrealized gains and losses are included in the change in net assets. Investment income and gains restricted by donors are reported as increases in net assets without restrictions if the restrictions are met (either by passage of time or use) in the reporting period in which the income and gains are recognized. Land, Buildings and Equipment: Expenditures for land, buildings and equipment and items in excess of $5,000 which substantially increase the useful lives of existing assets are capitalized at cost or at fair value at date of gift. Repairs and maintenance costs are expensed as incurred. Depreciation has been computed on straight-line method at rates designed to depreciate the costs of assets over their estimated useful lives as follows: Buildings and improvements Furniture, fixtures and equipment Transportation equipment
10-40 years 3-10 years 5 years
Leasehold improvements and capital leased assets are depreciated over the shorter of the asset’s useful life or the lease term. Revenue Recognition: Public support in the form of contributions, including unconditional pledges and bequests, is recognized when received, net of an allowance for uncollectible pledges. All contributions and bequests, unless specifically restricted by the donor, are considered available for general expenditure. Donor designated United Way funds are also accounted for as contributions. For the year ended September 30, 2019, there was approximately $21,000 of donor designated funds included in contribution revenue. United Way allocations are recognized over the period designated by the local United Way. All donor-restricted contributions are recorded as increases in net assets with donor restrictions. When a restriction expires (that is, when a stipulated time restriction ends or purpose restriction is accomplished), net assets are reclassified to net assets without donor restrictions and reported in the statement of activities as net assets released from restrictions. Revenue from program product sales, consisting of Girl Scout Cookies and fall product sales, is recognized when such products are delivered. Such revenue is recorded net of gross receipts allocated to troops and product and related costs. Retail sales, consisting of the sale of uniforms, pins, badges and other supplies, are recognized at the time of sale and are recorded net of cost of goods sold and product discounts. Program service fees are recognized when such program services are provided. Program fees received in advance are classified as deferred revenue.
(Continued) 8.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) A substantial number of volunteers have donated significant amounts of their time in relation to the Council’s program services; however, no amounts have been reflected in the accompanying financial statements for the value of these donated services because they do not meet the recognition criteria. Deferred Revenue: Deferred revenue consists of advances for event sponsorships and camp and program fees. Revenue is recognized upon the period in which services are rendered or the event is held. Advertising: The Council expenses advertising costs as incurred. Functional and Allocated Expenses: Expenses are charged directly to activities when specifically identifiable. All other costs are allocated to the activities based upon various actual statistical bases. Salaries and related expenses are charged based on the relative amount of time historically spent by personnel. Business and Credit Concentrations: Financial instruments, which potentially subject the Council to concentrations of credit risk, consist principally of temporary cash investments and other marketable securities and investments. The Council places its temporary cash investments with high credit quality financial institutions and from time to time balances may exceed federally insured limits. The Council manages risk on investments by maintaining a diversified portfolio of investments and placing its investments in high quality financial institutions and funds. In addition, the Council utilizes investment consultants to assist in review of investment activity and performance. Program product sales account for a significant portion of the Council’s revenue. Program product sales include the sale of Girl Scout Cookies. Impairment of Long-Lived Assets: On an ongoing basis, the Council reviews its long-lived assets for impairment whenever events or circumstances indicate that the carrying amount may be overstated. The Council recognizes impairment losses if the undiscounted cash flows expected to be generated are less than the carrying value of the related asset. If impaired, the assets are adjusted to fair value based on the discounted cash flows. Management does not believe any long-lived assets are impaired as of September 30, 2019. Income Taxes: The Council is exempt from income taxes on income from related activities under Section 501(c)(3) of the U. S. Internal Revenue Code and corresponding state tax law. Accordingly, no provision has been made for federal or state income taxes. Additionally, the Council is not considered to be a private foundation under Section 509(a) of the Internal Revenue Code. The Council follows guidance issued by the Financial Accounting Standards Board (FASB) with respect to accounting for uncertainty in income taxes. A tax position is recognized as a benefit only if it is “more likely than not” that the tax position would be sustained in a tax examination, with a tax examination being presumed to occur. The amount recognized is the largest amount of tax benefit that is greater than 50% likely of being realized on examination. For tax positions not meeting the “more likely than not” test, no tax benefit will be recorded. The Council does not expect the total amount of unrecorded tax benefits to significantly change in the next 12 months. The Council recognizes interest and/or penalties related to income tax matters in income tax expense. The Council did not have any amounts accrued for interest and penalties at September 30, 2019.
(Continued) 9.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Use of Estimates: The preparation of financial statements in conformity with GAAP requires management to make estimates and assumptions that effect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenue and expenses. Actual results could differ from those estimates. Subsequent Events: Management has performed an analysis of the activities and transactions subsequent to September 30, 2019, to determine the need for any adjustments or disclosures to the audited financial statements for the year ended September 30, 2019. Management has performed their analysis through March 2, 2020, the date the financial statements were available to be issued. On November 21, 2019, Council was awarded a grant from Lilly Endowment Inc (LEI) of $7,500,000. The grant is part of LEI’s social services sustainability initiative. The purpose of the grant is support for development capacity and energy-saving systems and to create an endowment. NOTE 3 - PLEDGES RECEIVABLE At September 30, 2019, pledges receivable consist of unconditional promises to give from various donors. Pledges that are expected to be collected beyond one year are recorded at present value using a discount rate of 2%. As of September 30, 2019, the Council considers outstanding pledge receivables to be fully collectible. The following is the detail of the pledges receivable balances at September 30, 2019: Amounts Receivable in: Less than one year One to five years
$
32,500 100,000 132,500 (8,212)
$
124,288
Less: unamortized present value discount Pledges receivable, net
The Council did not recognize any bad debt expense related to pledges receivable for the year ended September 30, 2019. NOTE 4 - INVESTMENTS At September 30, 2019, the Council’s investments consist of the following: Equity mutual funds Money market funds Corporate bonds Municipal bonds
$
4,830,488 829,013 691,878 21,176
$
6,372,555
Investment fees expense was $26,959 for the year ended September 30, 2019.
(Continued) 10.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 5 - BENEFICIAL INTEREST IN ASSETS HELD BY OTHERS The Council maintains a quasi-endowment fund with a number of Community Foundations throughout the state. The original principal of the funds cannot be committed, granted or expended by the Community Foundations. The funds are shown as an asset on the Council’s financial statements, and an allocation of earnings is available for distribution. The fair value of these beneficial interests at September 30, 2019 is $113,526. Gains of $3,398 on these beneficial interests are included in the statement of activities for the year ended September 30, 2019. The funds are included in net assets without donor restrictions on the statement of financial position. The Council is also the sole income beneficiary of a perpetual trust administered by an outside party. Under the terms of the trust, the Council has the irrevocable right to receive 100% of the income earned on the trust’s assets in perpetuity, but will never receive the assets held in trust. The marketable securities in the trust are valued at quoted fair values of the underlying bonds and equity investments. The Council’s estimated value of the expected future cash flows from the trust is $388,667 as of September 30, 2019. The change in value of this perpetual trust was ($11,989) for the year ended September 30, 2019, which is reflected in the statement of activities.
NOTE 6 - LAND, BUILDINGS AND EQUIPMENT At September 30, 2019, the carrying value of land, buildings and equipment consists of the following: Land Buildings and improvements Transportation vehicles Furniture, fixtures and equipment Leasehold improvements
$
Less: accumulated depreciation
509,600 15,739,771 317,710 1,490,812 56,679 (7,452,541)
$ 10,662,031 NOTE 7 - OPERATING LEASES The Council leases office space under non-cancelable operating leases that expire at various dates through October 2022. The Council also leases certain equipment under various non-cancelable operating leases, which expire at various dates through October 2022. Future minimum lease payments under operating leases at September 30, 2019, are as follows: 2020 2021 2022 2023
$
74,557 52,048 42,451 3,246
Total future minimum payments
$
172,302
Operating lease expenses for the year ended September 30, 2019 were $99,772.
(Continued) 11.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 8 - CAPITAL LEASE PAYABLE In 2015, the Council entered into a capital lease agreement for copiers, which expires in November 2020. Principal and interest payments of $2,653 are due monthly. In 2016, the Council entered into a capital lease agreement for optic fibers, which expires in May 2021. Principal and interest payments of $449 are due monthly. The amount of equipment and related amortization recorded under the capital leases are as follows: Furniture, fixtures and equipment Accumulated amortization
$
113,739 (83,441)
$
30,298
Amortization of assets held under capital leases is included with depreciation expense. Future minimum lease payments under the capital lease at September 30, 2019, are as follows: 2020 2021 2022 Total
$
Interest due
25,181 3,594 28,775 (728)
$
28,047
NOTE 9 - LONG-TERM DEBT Long-term debt consists of the following at September 30, 2019: Series 2015A bond payable with interest only monthly payments starting on December 1, 2015 at a fixed interest rate of 3.10%, with principal payments starting on December 1, 2017, secured by real estate and maturing November 2027.
$ 1,459,463
Series 2015B bond payable with interest only monthly payments starting on December 1, 2015 at a variable interest rate of 65% of the 1-month LIBOR plus 1.30% until November 1, 2017 when the rate increases to 2.25% plus the 1-month LIBOR (3.62% at September 30, 2019). Principal payments beginning on December 1, 2027, secured by real estate and maturing November 2042.
1,749,926
Mortgage payable in monthly payments, including variable interest at the one year treasury weekly average plus 3.00% (5.44% at September 30, 2019), secured by real estate and maturing August 2024.
50,946
Mortgage payable in monthly payments of $6,609, including interest at 3.28% as of September 30, 2019, respectively, secured by real estate and maturing August 2025. Bond issuance cost, net of accumulated amortization Total long-term debt
414,823 3,675,158 (62,861) $ 3,612,297
(Continued) 12.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 9 - LONG-TERM DEBT (Continued) On November 18, 2015, the Indiana Finance Authority (IFA) issued Educational Facilities Revenue Bonds, Series 2015A and Series 2015B, totaling $3,500,000 to the Council to fund the construction of the Leadership and Adult Learning Center at Camp Dellwood. The bonds are a direct purchase by a financial institution and do not require a letter of credit. The bond issuances are subject to certain covenants, primarily financial coverage ratios, with which the Council has reported compliance. Long-term debt is presented on the statement of financial position net of bond issuance costs related to the bonds payable of $62,861 for the year ended September 30, 2019. Estimated future principal payments due on long term debt are: 2020 2021 2022 2023 2024 Thereafter
$
233,997 242,496 250,488 258,748 266,189 2,423,240
$ 3,675,158 Interest expense was $136,663 for the year ended September 30, 2019.
NOTE 10 - NET ASSETS WITH DONOR RESTRICTIONS Net assets with donor restrictions are restricted for the following purposes or periods: 2019 Subject to expenditure for specified purposes: Membership outreach Scholarships Capital campaign Capital improvements Other
$
Subject to the Council’s spending policy and appropriation: Endowment funds restricted in perpetuity
106,746
Illiquid assets not subject to the Council’s spending policy or appropriation: Land Beneficial interest in perpetual trust
Total net assets with donor restrictions
27,500 64,131 74,816 82,033 4,772 253,252
240,000 388,667 628,667 $
988,665
(Continued) 13.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 10 - NET ASSETS WITH DONOR RESTRICTIONS (Continued) Net assets released from donor restrictions are as follows: 2019 Membership outreach Capital campaign Capital improvements Scholarships Other
$
926,183 98,726 65,191 4,000 1,900
$ 1,096,000 NOTE 11 - PENSION PLAN The Council participates in the Retirement Plan of the GSUSA, a noncontributory defined benefit multiemployer pension plan (Plan) sponsored by GSUSA. The risks of participating in this multi-employer plan are different from single-employer plans in the following respects: a) Assets contributed to the Plan by one employer may be used to provide benefits to employees of other participating employers. b) If a participating employer stops contributing to the Plan, the unfunded obligations of the plan may be borne by the remaining participating employers. c) If the Council chooses to stop participating in the Plan, the Council may be required to pay those plans an amount based on the Council’s proportionate share of unfunded vested plan benefits, referred to as a withdrawal liability. The National Board of GSUSA voted to freeze the plan to new entrants and to freeze future benefit accruals for all current participants under the plan effective July 31, 2010. The plan covers substantially all of the employees of various Girl Scout councils who were eligible to participate in the plan prior to the plan freeze. Accrued and vested benefits prior to July 31, 2010 are based on years of service and salary levels. The Council’s participation in the plan is outlined in the table below. “EIN/Pension Plan Number” provides the Employee Identification Number (EIN) and the three-digit plan number. “FIP/RP Status” indicates plans for which a financial improvement plan (FIP) or a rehabilitation plan (RP) is either pending or has been implemented. There have been no significant changes that affect the comparability of 2019 contributions.
(Continued) 14.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 11 - PENSION PLAN (Continued) Plan Pension Fund
Retirement Plan of the Girl Scouts of the USA
EIN/Pension Plan Number Council Contributions – Year ended- 9/30/2019 Plan Year-End of Most Recent Form 5500 Filing FIP/RP Status Surcharge Imposed Council Contributed more than 5% of Total Contributions
13-1624016 $584,208 12/31/2018 N/A No No
Due to the nature of the Plan, it is not practicable to determine the extent to which the assets of the Plan cover the actuarially computed value of vested benefits for the Council as a stand-alone operation. In addition, because the Plan is considered a multi-employer plan, it is only subject to certain minimum reporting requirements. As of December 31, 2018, the date for which the most current information is available, the Retirement Plan of the Girl Scouts of the USA had assets of $405,253,952 and liabilities of $524,720,461 for a net funded status of $(119,466,509). The Council expects to make contributions totaling approximately $584,000 to the Plan during the year ending September 30, 2020. NOTE 12 - RETIREMENT PLAN The Council maintains a 403(b) thrift plan that matches 3% of contributions made by employees. In addition, the Council makes contributions of 2% and 4% based on years of service. The Council contributed $163,992 to the plan for the year ended September 30, 2019. NOTE 13 - RELATED PARTY Girl Scouts of Central Indiana is chartered by GSUSA to use the name, marks and programs of the national organization. The Council collected and subsidized annual dues on behalf of GSUSA totaling $240,848 for the year ending September 30, 2019, and passed through the amounts to GSUSA. In addition, the Council purchased uniforms and other sales items from GSUSA totaling $469,766 for the year ending September 30, 2019. NOTE 14 - EMPLOYEE SELF-INSURANCE PROGRAM The Council has adopted a partially self-funded insurance plan for employee medical and prescription drug insurance. Expenses are recorded as incurred. Insurance policies in force at September 30, 2019 limit the Council’s maximum claims cost to approximately $1,000,000 and the maximum claim liability per covered individual to $60,000. Actual claims costs were $540,295 for the year ended September 30, 2019. The Council’s portion of the predetermined funding provision is charged to expense each month. Unpaid claims incurred prior to September 30 and filed within three months of year-end are accrued at September 30. This liability is part of accrued expenses on the statement of financial position.
(Continued) 15.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 15 - COMMITMENTS AND CONTINGENCIES The Council is involved, from time to time, in claims and legal actions arising in the course of operations. At September 30, 2019, there are no matters that have a material effect on the Council’s financial statements. NOTE 16 - COST OF SALES Net product sales for the year ended September 30, 2019: Product Sales Sales Cost of sales Net Sales
Retail Sales
Total
$ 13,582,042 (5,132,250)
$
666,915 (433,741)
$ 14,248,957 (5,565,991)
$
$
233,174
$ 8,682,966
8,449,792
NOTE 17 - DISCLOSURE ABOUT FAIR VALUE OF FINANCIAL INSTRUMENTS Fair value is defined as the price that would be received for an asset or paid to transfer a liability (an exit price) in the Council’s principal or most advantageous market for the asset or liability in an orderly transaction between market participants on the measurement date. To maximize the use of observable inputs and minimize the use of unobservable inputs when measuring fair value, the Council uses the fair value hierarchy. GAAP describes three levels of inputs that may be used to measure fair value: Level 1: Inputs include quoted prices (unadjusted) for identical assets or liabilities in active markets that the entity has the ability to access as of the measurement date. Level 2: Inputs include significant other observable inputs other than Level 1 prices such as quoted prices for similar assets or liabilities; quoted prices in markets that are not active; or other inputs that are observable or can be corroborated by observable market data. Level 3: Inputs include significant unobservable inputs that reflect a reporting entity’s own assumptions about the assumptions that market participants would use in pricing an asset or liability. In many cases, a valuation technique used to measure fair value includes inputs from multiple levels of the fair value hierarchy. The lowest level of significant input determines the placement of the entire fair value measurement in the hierarchy. Pursuant to the adoption of ASU 2015-07, Fair Value Measurement, those investments which are valued at net asset value are excluded from the fair value hierarchy. The fair value of mutual funds and money market funds are based on quoted prices in active markets. This is considered a level 1 input. The fair value of the corporate and municipal bonds are based on similar investments over the same period at specific rates. These are considered a level 2 input. The valuations of the level 2 investments are determined using the market or income approach.
(Continued) 16.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 17 - DISCLOSURE ABOUT FAIR VALUE OF FINANCIAL INSTRUMENTS (Continued) The fair value of beneficial interest in assets held by various community foundations is based upon the Council’s proportionate share of the community foundations’ pooled investment portfolio. The Council's management reviews the valuations and returns in comparison to industry benchmarks and other information provided by the community foundations. The Council uses the net asset value (NAV) to determine beneficial interest in assets valuation using the market approach. The Council does not have the ability to redeem the beneficial interests in assets on a short-term basis. Withdrawals are limited to the terms of the Council's agreements with the various community foundations. The fair value of beneficial interest in trust assets (or any type of beneficial interest) is based on a valuation model that calculates the present value of estimated distributed income. The valuation model incorporates assumptions that market participants would use in estimating future distributed income. The Council is able to compare the valuation model inputs and results to widely available published industry data for reasonableness. If not readily comparable to published data, then the Council would have to develop a model similar to the above for a Level 3 input. Since the Council does not have the ability to redeem these beneficial interests on a short-term basis, they are classified as Level 3 valuations. Assets measured at fair value on a recurring basis for 2019 are summarized below: Fair Value Measurements Level 1 Assets: Money market funds Equity mutual funds Corporate bonds Municipal bonds Total investments
$
829,013 4,830,488 5,659,501
Beneficial interest in assets held by others Beneficial interest in perpetual trust Total
Level 2 $
Funds Valued at NAV
Level 3
691,878 21,176 713,054
$
-
$
-
-
-
-
113,526
-
-
388,667
-
$ 5,659,501
$
713,054
$
388,667
$
113,526
The table below presents a reconciliation and income statement classification of gains and losses for all assets measured at fair value on a recurring basis using significant unobservable inputs (Level 3) for the year ended September 30, 2019: Fair Value Measurements Using Significant Unobservable Inputs (Level 3) Beneficial Interest in Perpetual Trusts Beginning balance Withdrawals and fees Change in value of beneficial interest
$
400,656 (3,138) (8,851)
Ending balance
$
388,667
(Continued) 17.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 18 - ENDOWMENT COMPOSITION DISCLOSURE The Council’s endowment consists of seven individual funds established for a variety of purposes. The endowment includes both donor-restricted endowment funds and funds designated by the Board to function as endowments. Additionally, the endowment includes a beneficial interest in a perpetual trust, which is not subject to the State Uniform Prudent Management of Institutional Funds Act (SPMIFA). As of September 30, 2019, the Council had the following endowment net asset composition by type of fund: Without Donor Restrictions Donor-restricted endowment funds Beneficial interest in perpetual trust Board designated funds held by community foundations Total funds
$
$
-
With Donor Restrictions
$
Total
106,746
$
106,746
-
388,667
388,667
113,526
-
113,526
113,526
$
495,413
$
608,939
Changes in endowment net assets for year ended September 30, 2019: Without Donor Restrictions Net assets, beginning of year Net investment return Gifts Appropriation of endowment assets for expenditure Net assets, end of year
$
116,215 2,278 -
With Donor Restrictions $
(4,967) $
113,526
507,402 (8,851) -
Total $
(3,138) $
495,413
623,617 (6,573) (8,105)
$
608,939
Interpretation of Relevant Law: The Council is subject to the State Prudent Management of Institutional Funds Act (SPMIFA). The Council has interpreted SPMIFA as requiring the preservation of the fair value of the original gift as of the date of the donor-restricted endowment funds, unless there are explicit donor stipulations to the contrary.
(Continued) 18.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 18 - ENDOWMENT COMPOSITION DISCLOSURE (Continued) As a result of this interpretation, the Council retains in perpetuity (a) the original value of initial and subsequent gifts donated to the endowment, and (b) any accumulations to the endowment made in accordance with the direction of the applicable donor gift instrument at the time the accumulation is added. Donor-restricted amounts not retained in perpetuity are subject to the appropriation for expenditure by the Council in a manner consistent with the standard of prudence prescribed by SPMIFA. In accordance with SPMIFA, the Council considers the following factors in making a determination to appropriate or accumulate donor-restricted endowment funds: (1) The duration and preservation of the fund (2) The purposes of the organization and the donor-restricted endowment fund (3) General economic conditions (4) The possible effect of inflation and deflation (5) The expected total return from income and the appreciation of investments (6) Other resources of the organization (7) The investment policies of the organization Spending Policies of the Endowment Funds: The endowments held at the various community foundations have adopted a spending policy based on the guidance of the community foundations. On average, the community foundations set a suggested spending policy of 5% of the fund balance. This policy is subject to change based on market and other factors. The endowments held as part of the pooled investments have been designated as net assets with donor restrictions. All but one of the donor-restricted funds has allowed the income from these funds to be available for general expenditure. One of the donor-restricted funds has a restriction based on the donor guidance. The Council has adopted the policy that interest and dividends only will be allocated to the fund and held as net assets with donor restriction until appropriated for expenditure. Return Objectives and Risk Parameters: The Council has adopted investment and spending policies for endowment assets that attempt to preserve the capital, maximize the return within reasonable and prudent levels of risk, and provide a return to the restricted funds. Endowment assets are comprised of the assets of donor-restricted funds that the organization must hold in perpetuity. Under this policy, the endowment assets are invested in a manner that is intended to produce results that exceed the price and yield a return while assuming a moderate level of investment risk. Actual returns in any given year may vary from this amount. Strategies Employed for Achieving Objectives: To satisfy its long-term rate-of-return objectives, the Council relies on a total return strategy in which investment returns are achieved through both capital appreciation (realized and unrealized) and current yield (interest and dividends). Funds with Deficiencies: As of September 30, 2019, the Council did not have any funds with deficiencies.
19.
GIRL SCOUTS OF CENTRAL INDIANA, INC. NOTES TO FINANCIAL STATEMENTS September 30, 2019
NOTE 19 - LIQUIDITY AND AVAILABILITY The Council’s financial assets available for general expenditure, that is, without donor or other restrictions limiting their use, within one year of the statement of financial position date comprise the following: Financial assets at year-end: Cash and cash equivalents Accounts and other receivables Pledges receivable, net Investments Beneficial interest in assets held by others Beneficial interest in perpetual trust Total financial assets
$
928,877 3,581 124,288 6,372,555 113,526 388,667 7,931,494
Less amounts not available for general expenditure within one year: Pledges receivable restricted by donor Donor-restricted endowment funds Beneficial interest in assets held by others Beneficial interest in perpetual trust
124,288 106,746 107,850 388,667
Financial assets not available to be used within one year
727,551
Financial assets available to meet general expenditures within one year
$ 7,203,943
The Council has certain donor-restricted assets limited to use which are available for general expenditures within one year in the normal course of operations. Accordingly, these assets have been included in the quantitative information above for financial assets to meet general expenditures within one year. As part of the Council’s liquidity management plan, the Council invests its financial assets to be available as its general expenditures, liabilities, and other obligations come due. Additionally, the Council maintains a $1,000,000 line of credit with maturing in November 2020 and a $500,000 line of credit maturing in June 2020 which are available to meet any unexpected liquidity needs. There were no outstanding balances on the lines of credit as of September 30, 2019.
20.
SUPPLEMENTARY INFORMATION
GIRL SCOUTS OF CENTRAL INDIANA, INC. SCHEDULE OF EXPENDITURES OF FEDERAL, STATE, AND LOCAL AWARDS Year ended September 30, 2019
Grantor/ Program Title Department of Education Passed through the Indiana Department of Education: Summer Food Service Program for Children
CFDA Number
10.559
Amount
$
38,308
21.