14-10. Exhibits 14-8 and 14-9 present the statements of financial position and statements of activities for the Disabled American Veterans (DAV) Charitable Service Trust. For both 2007 and 2006,...

1 answer below »
14-10. Exhibits 14-8 and 14-9 present the statements of financial position and statements of activities for the Disabled American Veterans (DAV) Charitable Service Trust. For both 2007 and 2006, calculate: a. common size ratios for the statements of financial position and statements of activities, . the current ratio, . days of cash on hand, . the debt ratio, Gana . the debt to equity ratio,f. the total margin ratio, and g. the program services ratio.
14-11. Refer to the 2007 annual report of the American Civil Liberties Union (ACLU) in answering the following questions. The ACLU financial statements are located in the Student Resources Folder of this book’s Web site at www.pearsonhighered.com/ finkler.® 1. Do the financial statements reflect the activities of the ACLU local affiliates? How do you know?Chapter 14 © Financial Statement Analysis 555 EXHIBIT 14-8 Disabled American Veterans (DAV) ae Charitable Service Trust Statements of Financial Position As of December 31, 2007 and 2006 Assets 2007 2006 Cash and Cash Equivalents $ 1,909,606 $ 1,044,193 Interest and Dividends Receivable 61,244 j pee Campaigns’ Pledges Receivable—Net of allowance for assessment fees and uncollectible pledges of $449,162 in 2007 and $464,486 in 2006 373,788 358 632 Prepaid Expenses and Other 16,244 ae Investments 10,944,924 9,653,039 Total $ 13,305,806 $ 511.19 11,133,813 Liabilities and Net Assets Liabilities: Accounts payable—DAV Accounts payable—other Annuity payment liability Total liabilities Unrestricted Net Assets Total $ 201,721 $ 171,550 910 1,017 3,857,262 3,679,148 4,059,893 3,851,715 9,245,913 7,282,098 $ 13,305,806 $ 11,133,813- Did the ACLU receive any endowment type De donations during 2007? How do you know? - How much did temporarily restricted net assets change during the year ended March 31, 2007? How much of the temporarily restricted net assets 8. became unrestricted in that year? - Under the approach used by the ACLU, which of 9. the following would be considered to be cash equivalents? a. Checking account b. Savings account 10. c. Three-month treasury bill d. Six-month treasury bill e. One-year treasury bill How might you assess the ACLU’s short-term liquidity? Is the trend improving or deteriorating? What do you think of the trend? 11. The ACLU had a decrease in net assets for the year ending March 31, 2007. Calculate the total margin for 2007 and 2006. Is the trend improving or deteriorating? Are there any elements in the calculation that might lead you to believe that one year is worse than the other? Explain.e donations during 2007? How do you know? - How much did temporarily restricted net assets change during the year ended March 31, 2007? How much of the temporarily restricted net assets 8. became unrestricted in that year? - Under the approach used by the ACLU, which of 9. the following would be considered to be cash equivalents? a. Checking account b. Savings account 10. c. Three-month treasury bill d. Six-month treasury bill e. One-year treasury bill How might you assess the ACLU’s short-term liquidity? Is the trend improving or deteriorating? What do you think of the trend? 11. The ACLU had a decrease in net assets for the year ending March 31, 2007. Calculate the total margin for 2007 and 2006. Is the trend improving or deteriorating? Are there any elements in the calculation that might lead you to believe that one year is worse than the other? Explain. Describe how you might measure Return on Net Assets to assess the ACLU’s profitability. What does this measure reflect in terms of the organization’s financial position? Describe the organization’s use of financial leverage and its implications on financial position, If you were a fund-raising manager for the organization, and your compensation was somewhat tied to dollars raised, would you rather be focused on new membership or current members? The ACLU reports its program services expenses separately from supporting services expenses. Do generally accepted accounting principles require the organization to make this distinction? Why or why not? Why and for whom might this distinction be informative? Suppose you have a friend who is considering making a donation to the ACLU. She wants to know how much of her money would go directly to the organization’s major activities as opposed to paying for administrative expenses. Which ratio would you advise her to use? Calculate the values for 2006 and 2007. Did theDisabled American Veterans (DAV) Charitable Service Trust Statements of Activities For the Years Ended December 31, 2007 and 2006 Unrestricted 2007 2006 Support and Revenue: Contributions—net of assessment fees and provision for uncollectible pledges of $428,587 in 2007 and $433,252 in 2006 $4,771,172 $ 2,654,400 Contributions of charitable gift annuities 241,245 178,626 Bequests 2,178,924 32,436,803 Investment income—net 766,580 384,670 Total support and revenue 7,957,921 35,654,499 Expenses: Program services 6,053,675 34,754,236 Management and general 85,933 75,499 Fundraising 179,277 168,316 Total expenses 6,318,885 34,998,051 Change in Net Assests before Change in Unrealized Appreciaion of investments 1,639,036 656,448 Change in Unrealized Appreciaion of Investments 324,779 428,159 Change in Net Assets 1,963,815 1,084,607 Net Assests—Beginning of year 7,282,098 6,197,491 Net Assests—End of year $ 9,245,913 $ 7,282,098ratio improve or worsen between 2006 and 2007? Explain. 14-12. Refer to the 2002 annual report of the Make-A-Wish Foundation (Wish), in answering the following questions.° The complete report is located in the Student Resources Folder of this book’s Web site at www. pearsonhighered.com/finkler. 1. Did the accounting firm of KPMG audit all of the Make-A-Wish Foundation chapters? How do you know? 2. Would you say that the financial statements are free of error, since they have been audited by a CPA? 3. What was the range of the cost of wishes granted in 2002? How do you know?4. Under the approach used by Wish, which of the following would be considered to be cash equivalents? a. Checking account b. Savings account ¢. Three-month treasury bill d. Six-month treasury bill e. One-year treasury bill 5. Is there any difference in the way that Wish treats the donation of land, buildings and equipment from the way it treats the contributions of cash that are restricted for the purchase of land, buildings, and equipment? If so, how, and how do you know? If not, why not?6. Wish records supplies using the FIFO method. Assuming that there has been an average rate of inflation of 2.5 percent in recent years, if Wish used LIFO would they have reported a higher or lower increase in net assets than they did using FIFO? 7. In their notes, Wish indicates that it performs eight functions, listed below. Which of these eight qualify as program services, as opposed to support services? . Wish granting . Chapter support . Program-related support Committee and board support . Training and development . Public information . Fund-raising So . Management and general +» Aan Op 8. Wish had a decrease in net assets for the year ending August 31, 2002. Would you say that a sizeable portion of that decrease resulted from stock market losses on Wish’s investment portfolio? Explain. 9. Did the amount of land Wish owned increase or decrease during the year ending August 31, 2002? How do you know? 10. How much did permanently restricted net assets change during the year ending August 31, 2002? How much of the temporarily restricted net assets as of August 31, 2002 are restricted for the specific purpose of wish fulfillment? 11. Does Wish include any provision (i.e., liability) for lawsuits in its financial statements? How do you know? 12. What is the Program Services Expense Ratio for Wish for the year ending August 31, 2002? 13. What were fund-raising costs, as a percent of total revenue and other support, for the years ending August 31, 2002 and 2001? 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. Chapter 14 ¢ Financial Statement Analysis 557 a. What percent did Program Service Expenses grow from 2001 to 2002? b. What percent did Support Service Expenses grow from 2001 to 2002? c. Which is growing at a faster rate, Program Service Expenses or Support Service Expenses? Did Wish meet any donor restrictions during the year ending August 31, 2002, allowing restricted contributions to become unrestricted? If so, how much? 3 What is the unrestricted total margin for the year ending August 31, 2002? From the combined statement of cash flows we see that the change in contributions receivable required a negative adjustment of $710,659 for the year ending August 31, 2002. How would you interpret this adjustment? Explain. Cash used for investing activities was over $9 million. Should we be concerned with this cash decrease? Why or why not? Looking at Wish’s assets on the combined statements of financial position, would you consider investments to be short-term or longterm? Why? Assuming that the obligation to international affiljates is short-term, and deferred rent is long-term, what is the current ratio for 2002? What is the ratio of total debt to equity for 2002? Based on your calculation of total margin, current ratio, and debt to equity, in Questions 16, 20, and 21, and your overall review of the financial statements and notes of Wish, how would you categorize their financial position? Circle just one answer. a. Weak b. Neutral c. Strong What is your overall assessment of the finances of Wish?
Answered Same DayDec 21, 2021

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
117 Votes
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,367
0.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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here