Answer To: 14-10. Exhibits 14-8 and 14-9 present the statements of financial position and statements of...
Robert answered on Dec 21 2021
14-10
a. Common size ratios for the statements of financial position and statement of activities
2007
($)
Amount Percentage
2006
($)
Amount Percentage
Statement of
Financial
Position:
Cash 1,909,606
14.35%
1,044,193
9.38%
Interest and
Dividends
Receivable
61,244 0.46% 52,582 0.47%
Campaigns’
Pledges
Receivable
373,788 2.81% 358,632 3.22%
Prepaid
Expenses and
Other
16,244
0.12%
25,3670.23%
Investments 10,944,924 82.26% 9,653,039 86.70%
Total Assets 13,305,806 100% 11,133,813 100%
Liabilities and
Net Assets (L
&NA)
Liabilities (L) 4,059,893 30.51% 3,851,715 34.59%
Unrestricted
Net Assets
9,245,913 69.49% 7,282,098 65.41%
Total 13,305,806 100% 11,133,813 100%
Statements of
Activities
Contributions-
net of assess
fees
4,771,172 59.96% 2,654,400 7.44%
Contributions
of charitable
gift annuities
241,425 3.03% 178,626 0.50%
Bequests 2,178,924 27.38% 32,436,803 90.98%
Investment
income
766,580 9.63% 384,670 1.08%
Total support
and revenue
7,957,921 100% 35,654,499 100%
Expenses:
Program
services
6,053,675 76.07% 34,754,236 97.48%
Management
and general
85,933 1.08% 75,499 0.21%
Fundraising 179,277 2.25% 168,316 0.47%
Total
expenses
6,318,885 79.40% 34,998,051 98.16%
Change in Net
Assets before
Change in
Unrealised
Appreciation
of Investment
1,639,036 20.60% 656,448 1.84%
Note: All items of statement of financial position are shown as percentage of total assets and
all items of statement of activities are shown as percentage of total revenue and support.
Other Ratios
Type of ratio Formula 2006 2007
b. Current ratio Current Assets ÷ Current
Liabilities
$1,480,774 ÷
$3,851,715 = 0.38
$2,360,882 ÷
$4,059,893 = 0.58
c. Days of cash on
hand
Cash and cash
equivalents ÷ Daily
operating expenses
$1,044,193 ÷
($34,998,051 ÷
365) = 1,044,193
÷ 95885 = 10.89
days
$1,909,606 ÷
($6,318,885 ÷365)
= 1,909,606
÷17,312 = 110
days
d. Debt ratio Total liabilities ÷ Total
unrestricted net assets
$3,851,715 ÷
$7,282,098=
0.529
$4,059,893 ÷
$9,245,913= 0.439
e. Debt to Equity
ratio
Long term debt ÷ total
net assets
$3,679,148 ÷
$7,282,098 = 0.51
$3,857,262 ÷
$9,245,913 =0.417
f. Total Margin
ratio
(Revenue – Expenses) ÷
Total Revenues
($35,654,499 -
$34,998,051) ÷
35,654,499 =
0.018
($7,957,921 -
$6,318,885) ÷
7,957,921 = 0.206
g. Product services
ratio
(Program services
expense ÷ Total support
and revenue) ×100
($34,754,236, ÷
$35,654,499) ×
100= 97.48%
($6,053,675
÷$7,957,921) ×
100= 76.07%
14.11
1. The financial statements do not reflect the activities of the ACLU local affiliates. This is
clear from the fact that the title on each page of the financial statements clearly mentions that
the financial report relates to the ACLU National Organisation exclusive of local affiliates.
However, the notes mention that the Union and its affiliates jointly fundraise and work
together on certain programs. The related dues on this aspect are shown as ‘dues from
affiliates’ and ‘dues to affiliates’ in the financial statements.
2. Apparently, ACLU did not receive any endowment type donations during 2007.
Endowment type donations are those which are made by the donors with a particular
stipulation as to their use. This is evident from the fact that there are no permanently
restricted funds in the financial statements for the year 2007.
3. During the year ended March 31, 2007, the temporarily restricted net assets changed from
$2,292,641 in the beginning of the year to $2,916,537 at the end of the year. The amount
which became unrestricted from the temporarily restricted net assets in that year was
$1,257,699, as is given in the Statement of Activities as ‘Net Assets released from
restrictions’.
4. The ACLU uses the approach that all debt instrument with a maturity period of three
months or less are to be considered as cash equivalents. On this basis, a. Checking account, b.
Savings account and c. Three-month treasury bill are to be considered as cash equivalents.
5. The short term liquidity of ACLU may be assessed with the help of determining ratios such
as the current ratio and quick ratio, and also by determining its working capital. The working
capital or the access of current assets over current liabilities is a measure of the ability to pay
off short term debt with the help of current assets. Current ratio measures the short term
liquidity by comparing current assets to current liabilities. Quick ratio is similar to current
ratio, except that it eliminates prepaid expenses from the current asset figure. On these bases,
it is seen that the working capital for 2006 is $9,214,793 - $1,847,009 or $7,367,784.
Similarly, for 2007, this comes to $7,485,618 - $809,916 which is equal to $6,675,702. As
regards the current ratio for 2006, it comes to $9,214,793 divided by $1,847,009 or 4.99 For
2007, the current ratio comes to $7,485,618 divided by $809,916 or 9.24 As regards the quick
ratio for 2006, it comes to $9,082,827 divided by $1,847,009 or 4.92. For 2007, it comes to
$7,315,120 divided by $809,916 or 9.03. Thus, from all these three indicators or short term
liquidity, we see that there is a high working capital which has declined from 2006, a very
high and increasing current ratio, and also a high and increasing quick ratio. Such high ratios
indicate that the organization has idle funds in the short run, and that...